SQLPro
SQLPro copied to clipboard
Syntax coloring when keyword escape and backslash character is used
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
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