Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Declined
-
R3.0.1
Description
The active objects usage is not optimized in some cases leading to a lot of similar queries which are then hard-parsed unnecessarily. e.g.:
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (767410) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (623242) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1681431) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1648947) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1144693) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1648950) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1571368) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1649186) |
| SELECT "TEST_ISSUE_ID","RANK","ASSIGNEE","START_DATE","COMMENT","STATUS","TEST_ISSUE","TEST_EXEC_ISSUE","ID","CREATED_DATE","USER","FINISH_DATE" FROM "AO_8B1069_TEST_RUN" WHERE "TEST_ISSUE_ID" in (1521674) |
Â
