Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
1
-
Severity 3 - Minor
-
Description
Issue Summary
SQL Logical Operators are not highlighted when using Code Macro
Sample of operators:
- AND
- BETWEEN
- IN
- LIKE
- NOT
- OR
Steps to Reproduce
- Create a page
- Add the following SQL queries into the code macro with language set as SQL:
SELECT * FROM Customers WHERE City = "London" AND Country = "UK"; SELECT * FROM Products WHERE Price BETWEEN 50 AND 60; SELECT * FROM Customers WHERE City IN ('Paris','London'); SELECT * FROM Customers WHERE City LIKE 's%'; SELECT * FROM Customers WHERE City NOT LIKE 's%'; SELECT * FROM Customers WHERE City = "London" OR Country = "UK";
Expected Results & Actual Results
Those keywords should be highlighted as are: ALL, ANY, EXISTS, SOME:
Workaround
Currently, there is no known workaround for this behavior. A workaround will be added here when available