Details
-
Bug
-
Status: Testing (building)
-
Major
-
Resolution: Unresolved
-
Xray DC 7.11.4
-
None
-
any jira version
Description
While running the JQL testTestExecutions the below SQL will be triggered
SELECT DISTINCT TEST_EXEC_TABLE_ALIAS."id" AS testExecId FROM public."AO_8B1069_TEST_RUN" AS TEST_RUN_TABLE_ALIAS JOIN public."jiraissue" AS TEST_EXEC_TABLE_ALIAS ON TEST_RUN_TABLE_ALIAS."TEST_EXEC_ISSUE" = TEST_EXEC_TABLE_ALIAS."id" JOIN public."jiraissue" AS TEST_TABLE_ALIAS ON TEST_RUN_TABLE_ALIAS."TEST_ISSUE_ID" = TEST_TABLE_ALIAS."id" WHERE (TEST_TABLE_ALIAS."id" IN ) AND (TEST_RUN_TABLE_ALIAS."STATUS" IN ) ORDER BY TEST_EXEC_TABLE_ALIAS."id" DESC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY
We are doing 2 inner joins between test run and jira issue table in order to filter out invalid references on issue objects that may no longer exist in the environment.
Doing so might no be ideal, or even necessary in some contexts. Review if we can make the query lighter by removing the inner joins.
