You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
SQL contains ISNULL function in select clause parsing fails if used with NOT #733
The fix for ISNULL as a keyword or as a function doesn't work with NOT as a prefix:
@TestpublicvoidtestSqlContainIsNullFunctionShouldBeParsed3() throwsJSQLParserException {
assertSqlCanBeParsedAndDeparsed("SELECT name, age FROM person WHERE NOT ISNULL(home, 'earn more money')");
}
results in:
at line 1, column 46.
Was expecting one of:
"&&"
";"
"AND"
"CONNECT"
"EXCEPT"
"FOR"
"GROUP"
"HAVING"
"INTERSECT"
"MINUS"
"ORDER"
"START"
"UNION"
<EOF>
Ran into this issue as well. An example to reproduce the issue:
SELECT col from tbl WHERE NOT ISNULL(col)
This query is valid in many different databases.
Activity
tomershay commentedon Jan 19, 2019
Ran into this issue as well. An example to reproduce the issue:
SELECT col from tbl WHERE NOT ISNULL(col)
This query is valid in many different databases.
wumpz commentedon Feb 10, 2019
already fixed
Merge recent changes in the master from the master (#1)
Added support for DROP INDEX, ADD UNIQUE INDEX, ALGORITHM and USING (#…