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

CQL query fails when using a semicolon

    XMLWordPrintable

Details

    Description

      Issue

      Performing a CQL search with a semicolon generates an error

      Examples

      http://myhost:8080/rest/api/content/search?cql=space=TEST:
      http://myhost:8080/rest/api/content/search?cql=space~TEST:

      Error code
      {
statusCode: 400,
data: {
authorized: false,
valid: true,
errors: [ ]
},
message: "Could not parse cql : title=test:"
}
      Report from DoS

      Entering title~"somethingwithacolon:" throws an error. It's because in a Lucene query, the ':' marks a key and a value, so 'macroName:jira' is the Lucene syntax to search for pages that contain a JIRA macro. It does however work if you use '=' instead of '' (eg title="somethingwithacolon:"), or if you put double and single quotes around the value - title"'somethingwithacolon:'" - that stops Lucene from trying to interpret it as a key/value pair.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-39548 CQL Text field with colon caused server error

          • Medium - Medium priority issues
          • Closed
          included in

          [JIRA] CPU-171 Confluence 6.0.0-OD-2015.52.1-0001

          [JIRA] CPU-179 Confluence 6.0.0-OD-2016.01.1-0002

          [JIRA] CPU-180 Confluence 6.0.0-OD-2016.01.1-0003

          Activity

            People

              Unassigned Unassigned
              rlouie Robert Louie
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: