add support for `IN (NULL)` for empty value-set

zendframework / zend-db

Db component from Zend Framework

BSD 3-Clause "New" or "Revised" License

101 stars 122 forks source link

add support for `IN (NULL)` for empty value-set #356

Closed pine3ree closed 4 years ago

pine3ree commented 5 years ago

Calling $expression->in($identifier, []) results in an invalid SQL string. For an empty valueSet we should return a never-satisfied (IVL) condition string such as (NULL).

michalbundyra commented 4 years ago

Thanks, @pine3ree!