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: