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

CQL query fails when using a semicolon

XMLWordPrintable

      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.

            [CONFSERVER-39566] CQL query fails when using a semicolon

            Deleted Account (Inactive) added a comment -

            This issue is mentioned in commits included in the Confluence 6.0.0-OD-2016.01.1-0003 release being approved for production: CPU-180

            Deleted Account (Inactive) added a comment - This issue is mentioned in commits included in the Confluence 6.0.0-OD-2016.01.1-0003 release being approved for production: CPU-180

            Deleted Account (Inactive) added a comment -

            This issue is mentioned in commits included in the Confluence 6.0.0-OD-2016.01.1-0002 release being approved for production: CPU-179

            Deleted Account (Inactive) added a comment - This issue is mentioned in commits included in the Confluence 6.0.0-OD-2016.01.1-0002 release being approved for production: CPU-179

            Deleted Account (Inactive) added a comment -

            This issue is mentioned in release Confluence 6.0.0-OD-2015.52.1-0001 just promoted to jirastudio-prd-virtual

            Deleted Account (Inactive) added a comment - This issue is mentioned in release Confluence 6.0.0-OD-2015.52.1-0001 just promoted to jirastudio-prd-virtual

            Deleted Account (Inactive) added a comment -

            This issue is mentioned in commits included in the Confluence 6.0.0-OD-2015.52.1-0001 release being approved for production: CPU-171

            Deleted Account (Inactive) added a comment - This issue is mentioned in commits included in the Confluence 6.0.0-OD-2015.52.1-0001 release being approved for production: CPU-171

            Minh Tran added a comment -

            Dear All,

            This ticket has been marked as duplicate. Please follow the progress here https://jira.atlassian.com/browse/CONF-39548

            Thanks,
            Minh Tran
            Confluence BugMaster
            Atlassian

            Minh Tran added a comment - Dear All, This ticket has been marked as duplicate. Please follow the progress here https://jira.atlassian.com/browse/CONF-39548 Thanks, Minh Tran Confluence BugMaster Atlassian

              Unassigned Unassigned
              rlouie Robert Louie
              Affected customers:
              0 This affects my team
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: