JQL query: assignee = empty will also pull issues assigned to a user called unassigned

XMLWordPrintable

    • Type: Bug
    • Resolution: Timed out
    • Priority: Low
    • None
    • Affects Version/s: 6.4.1, 6.4.8
    • Component/s: JQL
    • 6.04
    • 5
    • Severity 3 - Minor

      If an issue is assigned to a user named "unassigned" and you perform the JQL query assignee = empty. Results will come back for the user "unassigned" and issues that are unassigned.

      Steps to Reproduce

      1. Enable debug logging for the class com.atlassian.jira.issue.search .
      2. Create user unassigned (with assignable user permission for the project).
      3. Create 2 issues one that is assigned to the user "unassigned" and an issue that is not assigned.
      4. Perform Query 1: assignee = empty
      5. Perform Query 2: assignee = unassigned
      6. Both return the same results.

      Expected Results

      1. Query 1 would result in issues that are actually unassigned.
      2. Query 2 will return results of issues assigned to the user "unassigned"

      Actual Results

      The below exception is thrown in the catalina.out file:

      assignee = empty
2015-09-15 19:15:03,351 http-bio-8080-exec-11 DEBUG jcastro 1155x1090x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable [issue.search.providers.LuceneSearchProvider] JQL lucene query: *issue_assignee:unassigned*
2015-09-15 19:15:03,351 http-bio-8080-exec-11 DEBUG jcastro 1155x1090x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@2ba2fb37>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@291fb799>!]
2015-09-15 19:15:03,351 http-bio-8080-exec-11 DEBUG jcastro 1155x1090x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_assignee:unassigned
2015-09-15 19:15:03,507 http-bio-8080-exec-11 DEBUG jcastro 1155x1094x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL query:
{key in ((10002))}

2015-09-15 19:15:03,507 http-bio-8080-exec-11 DEBUG jcastro 1155x1094x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL lucene query: issue_id:10002

2015-09-15 19:15:03,507 http-bio-8080-exec-11 DEBUG jcastro 1155x1094x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@56a05fd>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@21ecd1da>!]

2015-09-15 19:15:03,507 http-bio-8080-exec-11 DEBUG jcastro 1155x1094x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_id:10002

2015-09-15 19:15:03,947 http-bio-8080-exec-11 DEBUG jcastro 1155x1099x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL query: {key in ((10002))}
2015-09-15 19:15:03,947 http-bio-8080-exec-11 DEBUG jcastro 1155x1099x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL lucene query: issue_id:10002
2015-09-15 19:15:03,947 http-bio-8080-exec-11 DEBUG jcastro 1155x1099x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@4b067b3d>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@1e16ca4d>!]
2015-09-15 19:15:03,947 http-bio-8080-exec-11 DEBUG jcastro 1155x1099x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_id:10002
2015-09-15 19:15:04,060 http-bio-8080-exec-4 DEBUG jcastro 1155x1103x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL query:
{key in ((10002))}

2015-09-15 19:15:04,060 http-bio-8080-exec-4 DEBUG jcastro 1155x1103x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL lucene query: issue_id:10002

2015-09-15 19:15:04,060 http-bio-8080-exec-4 DEBUG jcastro 1155x1103x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@55ebea11>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@326102d6>!]

2015-09-15 19:15:04,060 http-bio-8080-exec-4 DEBUG jcastro 1155x1103x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_id:10002



assignee = unassigned

2015-09-15 19:16:00,202 http-bio-8080-exec-22 DEBUG jcastro 1156x1107x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable [issue.search.providers.LuceneSearchProvider] Lucene boolean *Query:issue_assignee:unassigned*
2015-09-15 19:16:00,413 http-bio-8080-exec-22 DEBUG jcastro 1156x1112x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL query: {key in ((10002))}
2015-09-15 19:16:00,413 http-bio-8080-exec-22 DEBUG jcastro 1156x1112x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL lucene query: issue_id:10002
2015-09-15 19:16:00,413 http-bio-8080-exec-22 DEBUG jcastro 1156x1112x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@6150301c>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@29231326>!]
2015-09-15 19:16:00,413 http-bio-8080-exec-22 DEBUG jcastro 1156x1112x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_id:10002
2015-09-15 19:16:00,898 http-bio-8080-exec-22 DEBUG jcastro 1156x1117x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL query:
{key in ((10002))}
2015-09-15 19:16:00,898 http-bio-8080-exec-22 DEBUG jcastro 1156x1117x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL lucene query: issue_id:10002
2015-09-15 19:16:00,898 http-bio-8080-exec-22 DEBUG jcastro 1156x1117x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@137bdd19>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@734bcfba>!]
2015-09-15 19:16:00,898 http-bio-8080-exec-22 DEBUG jcastro 1156x1117x2 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_id:10002
2015-09-15 19:16:01,115 http-bio-8080-exec-3 DEBUG jcastro 1156x1122x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL query: {key in ((10002))}
2015-09-15 19:16:01,115 http-bio-8080-exec-3 DEBUG jcastro 1156x1122x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL lucene query: issue_id:10002
2015-09-15 19:16:01,115 http-bio-8080-exec-3 DEBUG jcastro 1156x1122x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"projkey": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@3d17e3ad>!, <custom:"keynumpart_range": com.atlassian.jira.issue.search.parameters.lucene.sort.StringSortComparator@31eafee6>!]
2015-09-15 19:16:01,115 http-bio-8080-exec-3 DEBUG jcastro 1156x1122x1 dw3ejs 0:0:0:0:0:0:0:1 /rest/issueNav/1/issueTable/stable [issue.search.providers.LuceneSearchProvider] Lucene boolean Query:issue_id:10002

      Workaround

      Perform a direct database query to differentiate the issues that are actually unassigned from the user 'unassigned':

      select * from jiraissue where assignee is null;

      select * from jiraissue where assignee - 'unassigned';

        1. null.png
          null.png
          125 kB
        2. userun.png
          userun.png
          126 kB

            Assignee:
            Unassigned
            Reporter:
            Jose Castro (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: