Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-75231

SQL Logical Operators not highlighted when using Code Macro

    XMLWordPrintable

Details

    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

      1. Create a page
      2. 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            ediel Elisa [Atlassian]
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: