Issue Summary

JQL queries with large operand lists, like:

parent in (ISSUE-1, ISSUE-2, ..., ISSUE-10000)

can cause an error in the internal JQL execution engine due to a large number of operands.

The exact number of operands to cause the issue depends on the operators and other clauses in the query, the user executing them and other factors, so we can't determine an absolute number; however the range starts around the few thousands of operands, and it will always cause an error around the 25000 count.

Steps to Reproduce

1. Create a project with a large number of issues (25k+)
2. Run a JQL query with a large number of operands, such as "key in (ISSUE-1, ISSUE-2, ... ISSUE-25000)

Expected Results

The search should execute normally and return the expected results.

Actual Results

A 500 error is produced by the search backend

Workaround

The current workaround is to reduce the number of operands in the query.