sqlformat icon indicating copy to clipboard operation
sqlformat copied to clipboard

Proper handling of IS NULL and IS NOT NULL when multiple conditions are used

Open dnnancy opened this issue 11 years ago • 1 comments

SELECT Name FROM Customer
WHERE telephone IS NOT NULL
  AND email IS NULL
  AND TwitterId IS NULL

When parsing the above SQL script, the WHERE condition is evaluated as a CriteriaExpression, with the left part being "telephone" and the right part being "NOT NULL AND email IS NULL AND TwitterId IS NULL".

Thanks for the great library.

dnnancy avatar Aug 28 '13 18:08 dnnancy

Please provide a failing test to clarify this issue. I'm not sure what the problem is

Thanks

benlaan avatar Sep 27 '13 00:09 benlaan