Active object with oracle - adding quotes to table alias in order clause

[Sagar Jadhav]

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..

[Volodymyr Havryliuk]

Please check here https://community.atlassian.com/t5/Confluence-questions/How-to-using-alias-in-Active-Object-with-Oracle-DB/qaq-p/1358042