Summary:

Querying JIRA using the standardIssueTypes() JQL, expected issues are not returned.

Environment

• JIRA 5.2.7
• PostgreSQL 9.1
• Mac OS X

Steps to Reproduce:

1. Create a new issue using the default Issue Type "Bug" and then query for it with the following, replacing the issuekey with the appropriate key:

   issuekey = LLAMA-52 AND issuetype in standardIssueTypes()
   

2. Add a new Issue Type "1" (without quotes).
3. Execute the JQL again.

Expected Results:

The issue still appears.

Actual Results:

The issue vanishes.

Notes:

It appears that the JQL for standardIssueTypes() is querying on the quoted value instead of the actual. For example, the below will return results:

issuekey = LLAMA-52 AND issuetype = 1

This appears to go off the issuetype.id.

However this will not:

issuekey = LLAMA-52 AND issuetype = "1"

This appears to go off issuetype.pname.

Workaround

Do not use Issue Types that are integers.