Skip to content

Parsing issue in LIKE ESCAPE '\' #578

Closed
@anderruiz

Description

@anderruiz

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions