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

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

          is blocked by

          Suggestion - CONFSERVER-12149 Third-party macros should be able to specify whether macro body should be displayed in Rich Text editor

          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-15960 RTE insterting extra symbol in {sql} query

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-17397 RTE Mangles Wiki Markup

          • Medium - Medium priority issues
          • Closed
          is incorporated by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-16169 Macros that contain non-wiki-markup bodies are broken by rich text editor

          • Medium - Medium priority issues
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: