Closed
Description
I'm not sure if this is a duplicate of other issues related with ESCAPE keyword, in my case this query is causing an error
SELECT * FROM t1 WHERE UPPER(t1.TIPCOR_A8) like ? ESCAPE '' ORDER BY PERFILB2||TRANSLATE(UPPER(AP1SOL10 || ' ' || AP2SOL10 || ',' || NOMSOL10), '?', 'A') asc
I get this error:
Exception in thread "main" net.sf.jsqlparser.parser.ParseException: Encountered " <S_CHAR_LITERAL> "' || AP2SOL10 || ' "" at line 1, column 112.
Looks like something related with ESCAPE keyword because the parsing works if I changed the ESCAPE from '' to '\' for example
Does it make sense?
Metadata
Metadata
Assignees
Labels
No labels