[jboss-jira] [JBoss JIRA] Created: (JBAS-4576) Include ORDER BY cols in SELECT clause in EJBQLToSQL92Compiler

Mon Jul 23 11:27:47 EDT 2007

Include ORDER BY cols in SELECT clause in EJBQLToSQL92Compiler
--------------------------------------------------------------

                 Key: JBAS-4576
                 URL: http://jira.jboss.com/jira/browse/JBAS-4576
             Project: JBoss Application Server
          Issue Type: Bug
      Security Level: Public (Everyone can see)
    Affects Versions: JBossAS-4.0.5.GA
         Environment: postgresql 8.2.4
            Reporter: Michal Borowiecki

Bug JBAS-206 is still present in the EJBQLToSQL92Compiler.

For example this dynamic JBoss QL works fine with the default compiler:
select distinct object(o) from TransactionRO o where o.account.accountId = ?1 and o.date >= ?2 order by o.user.login desc offset 0 limit 25

After switching to the EJBQLToSQL92Compiler, an exception is raised on posgresql:

org.postgresql.util.PSQLException: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira