Menu

#19 case else bug

open
nobody
None
5
2012-12-07
2012-01-24
Anonymous
No

This sql statement should work: (else 'el' || 'se')

select case when dummy = 'X' then 'XXX' else 'el' || 'se' end from dual

jsqlparser version: 0.7

java.text.ParseException: Encountered " "CASE" "case "" at line 1, column 8.
Was expecting one of:
"ALL" ...
"TOP" ...
"DISTINCT" ...
"(" ...
"*" ...
"ALL" ...
"DISTINCT" ...
"TOP" ...
"*" ...
"(" ...

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.