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
Hi @lascarayf
I have filed an issue (JSQLParser/JSqlParser#658) with the underlying project that I use for the SQL parsing, and I will see if I can submit a solution to it as well.
In the meantime you could use the following work around:
SELECT IF(CASE WHEN 2 > 1 THEN TRUE ELSE FALSE END, 'A', 'B') FROM notifications;
The above statement should work and yield the same result.
olavloite
changed the title
jsqlparser ParseException
JSqlParser ParseException - Boolean expression not allowed in select item
Aug 12, 2018
Hi @olavloite. I have this error.
The text was updated successfully, but these errors were encountered: