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
Hey Everyone! Unfortunately, the venue that was hosting us on the 23rd has pulled out so we're looking for a new venue. If anyone would have a room free that we could use on the ev...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs