Skip to content

x=NULL-Values are now projected as ISNULL(x) in some cases

Pre-release
Pre-release

Choose a tag to compare

@rkrx rkrx released this 10 Sep 15:24
· 90 commits to master since this release

NULL-Values used in conjunction with Select::where and Select::having when conditions are used as a key-value-array are now projected with ISNULL instead of field=NULL.

$str = $select
->field('a')
->from('t', 'test')
->where(['field' => null])
->asString();

will result in

SELECT
    a
FROM
    test t
WHERE
    (ISNULL(`field`))