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