hankinsoft / SQLPro

SQLPro bug & features tracking.
104 stars 27 forks source link

Syntax coloring when keyword escape and backslash character is used #981

Open cwolcott opened 4 months ago

cwolcott commented 4 months ago

Describe the bug When adding the reserved word ESCAPE '\' to like statement the syntax coloring is messed up

To Reproduce Review the following SQL Statements

SELECT * FROM MOLMAN.LIBRARIES WHERE DESCRIPTION like 'ABC_%' order by DESCRIPTION;

-- Using period as my escape character doesn't cause a problem with the syntax coloring.
SELECT * FROM MOLMAN.LIBRARIES WHERE DESCRIPTION like 'ABC._%' ESCAPE '.' order by DESCRIPTION;

-- Using backslash as my escape character causes a problem with the syntax coloring.
SELECT * FROM MOLMAN.LIBRARIES WHERE DESCRIPTION like 'ABC\_%' ESCAPE '\' order by DESCRIPTION;

Expected behavior The "order by DESCRIPTION" in the 3rd statement should not be colored red.

Screenshots

image

Environment details (please complete the following information):

Additional context None