I am using Oracle12c with jira 7.3.6 and ojdbc8.jar driver.
I have enabled SQL logging and noticed that active objects generated query has quotes to table alias in order clause. Why active objects are quoting table alias only in order clause?
Generated sample query:
SELECT * FROM ( SELECT du."WORKFLOW_ENTRY_ID",du."ID",du."STATUS",du."REVIEWER_STATUS",du."REVIEWER_EMAIL",du."DISTRIBUTION_ID",du."ABOUT_USER_STATUS",du."FORM_OPEN_TILL",du."IS_CLOSED",du."SHARE_WITH_ABOUT" FROM "AO_EB0AB3_DISTRIBUTION_USER" du JOIN "AO_EB0AB3_DISTRIBUTION" d ON d."ID" = du."DISTRIBUTION_ID" WHERE d."IS_DELETED" = ? AND du."USER_ID" = ? AND du."SHARE_WITH_ABOUT" = ? AND du."WORKFLOW_ENTRY_ID" is not null ORDER BY "du"."STATUS" asc ) WHERE ROWNUM <= 10
Because of those quotes : java.sql.SQLSyntaxErrorException: ORA-00904: "du"."STATUS": invalid identifier
Please help..