Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-22995

JQL query "fixVersion >= B AND fixVersion <= D" returns unexpected results

      Steps to reproduce:
      1. Create a project with versions A, B, C, D, and E (or 1, 2, 3, 4, 5, etc), A being the first version and E being the last.
      2. Create a six issues, the first with fix version as A, the second as B, and so on, then one with the fix version as A and E.
      3. In the Issue Navigator, run the following JQL query: fixVersion >= "B" AND fixVersion <= "D"

      Expected results:
      The issues with fix version B, C, and D are returned.

      Actual results:
      The issues with fix versions B, C, and D are indeed returned, but so is the issue with fix versions A and E.

      The same issue occurs if you use just < and > instead of >= and <=.

            [JRASERVER-22995] JQL query "fixVersion >= B AND fixVersion <= D" returns unexpected results

            Bugfix Automation Bot made changes -
            Minimum Version New: 4.01
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2836654 ] New: JAC Bug Workflow v3 [ 2926049 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2567002 ] New: JAC Bug Workflow v2 [ 2836654 ]

            We don't have an alternative for this at the moment, sorry.

            Eric Dalgliesh added a comment - We don't have an alternative for this at the moment, sorry.

            Dmitry added a comment -

            Is there an alternative syntax maybe? The one that would allow to specify a range condition for a single value instead of a set of conditions for a combination of values?

            Something like fixVersion IN (B - D) or fixVersion BETWEEN B AND D.

            Regexp check in the versionMatch of the script runner mentioned above is not flexible enough in my case.

            Dmitry added a comment - Is there an alternative syntax maybe? The one that would allow to specify a range condition for a single value instead of a set of conditions for a combination of values? Something like fixVersion IN (B - D) or fixVersion BETWEEN B AND D . Regexp check in the versionMatch of the script runner mentioned above is not flexible enough in my case.
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1532381 ] New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2567002 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels Original: JQL bughunt_jql ho-jql-backend New: JQL affects-server bughunt_jql ho-jql-backend
            Hannes Obweger (Inactive) made changes -
            Component/s New: Issue Navigation & Search - JQL [ 43398 ]
            Component/s Original: JQL [Deprecated] [ 12922 ]
            Labels Original: JQL bughunt_jql New: JQL bughunt_jql ho-jql-backend
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 678438 ] New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1532381 ]
            Oswaldo Hernandez (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v5 [ 645994 ] New: JIRA Bug Workflow w Kanban v6 [ 678438 ]

              Unassigned Unassigned
              nmason Nick Mason
              Affected customers:
              5 This affects my team
              Watchers:
              14 Start watching this issue

                Created:
                Updated:
                Resolved: