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

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

XMLWordPrintable

      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.

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

              Created:
              Updated:
              Resolved: