Skip to content

properly simulate IS NULL #297

@staabm

Description

@staabm

instead of

SELECT `adp`.*, `ada`.`spracheid`
                FROM `adp`
                INNER JOIN `ada` ON ada.adaid = adp.adaid
                WHERE (adpid = NULL)
                LIMIT 1

we should simulate

SELECT `adp`.*, `ada`.`spracheid`
                FROM `adp`
                INNER JOIN `ada` ON ada.adaid = adp.adaid
                WHERE adpid IS NULL
                LIMIT 1

for code like

            $query = '
                SELECT `adp`.*, `ada`.`spracheid`
                FROM `adp`
                INNER JOIN `ada` ON ada.adaid = adp.adaid
                WHERE (adpid = ?)
                LIMIT 1';

            $adpMapper = new Application_Model_Mapper_Adp();
            $adpModel = $adpMapper->fetchRowByStatement(new ClxProductNet_DbStatement($query, [$adpid]));

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions