Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-15887

Queries in SQL macro are corrupted by editing with Rich Text Editor

    XMLWordPrintable

    Details

      Description

      This bug is reported against the appropriate plugin at http://developer.atlassian.com/jira/browse/SQL-58, but since it is caused by a change in Confluence we should keep it open here until we're sure that we aren't going to revert the Confluence change to solve it.

      Use wiki markup such as:

      {sql:dataSource=CustomerDB}
      SELECT region_name || ' ' || store_name FROM Geography
      WHERE store_name = 'Boston';
      {sql}
      
      {sql}
      count(*), x != 2 
      {sql}
      
      

      After switching to RTE andback this becomes:

      {sql:dataSource=CustomerDB}
      SELECT region_name \|\| ' ' \|\| store_name FROM Geography
      WHERE store_name = 'Boston';
      {sql}
      
      {sql}
      count(*y) , x \!= 2
      {sql}
      

      Which is no longer a valid query.

      This did not happen in 2.10.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              don.willis@atlassian.com Don Willis
              Reporter:
              mhrynczak Mark Hrynczak (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: