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
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
Activity
feat: Configurable backslash `\` escaping