SQLPro icon indicating copy to clipboard operation
SQLPro copied to clipboard

Syntax coloring when keyword escape and backslash character is used

Open cwolcott opened this issue 9 months ago • 0 comments

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):

  • Device: MacBook Pro (2019)
  • OS: Sonoma 14.5
  • SQLPro app Version: SQLPro for Oracle Version 2023.81 (Build 581)
  • Installation source: Directly from using since SQLPro Oracle updates can't be download from AppStore anymore.
  • Target database server: Oracle

Additional context None

cwolcott avatar May 23 '24 15:05 cwolcott