sqlformat
sqlformat copied to clipboard
Proper handling of IS NULL and IS NOT NULL when multiple conditions are used
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.
Please provide a failing test to clarify this issue. I'm not sure what the problem is
Thanks