Here's the SQL AST's and resulting queries for the test case

This works:

 \-[SELECT] QueryNode: 'SELECT'  querySpaces (Client)
    +-[SELECT_CLAUSE] SelectClause: '{select clause}'
    |  +-[ALIAS_REF] IdentNode: 'client0_.id as id0_' {alias=c, className=hhh951.Client, tableAlias=client0_}
    |  \-[SQL_TOKEN] SqlFragment: 'client0_.OTHER_ID as OTHER2_0_'
    \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[c], fromElementByTableAlias=[client0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
       \-[FROM_FRAGMENT] FromElement: 'Client client0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=null,tableName=Client,tableAlias=client0_,origin=null,columns={,className=hhh951.Client}}

select * from ( select client0_.id as id0_, client0_.OTHER_ID as OTHER2_0_ from Client client0_ ) where rownum <= ?

This throws the exception:

 \-[SELECT] QueryNode: 'SELECT'  querySpaces (ClientWithMixedCaseColumnNames)
    +-[SELECT_CLAUSE] SelectClause: '{select clause}'
    |  +-[ALIAS_REF] IdentNode: 'clientwith0_.id as id1_' {alias=c, className=hhh951.ClientWithMixedCaseColumnNames, tableAlias=clientwith0_}
    |  \-[SQL_TOKEN] SqlFragment: 'clientwith0_.other_id as other2_1_, clientwith0_.OTHER_ID as OTHER2_1_'
    \-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[c], fromElementByTableAlias=[clientwith0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
       \-[FROM_FRAGMENT] FromElement: 'ClientWithMixedCaseColumnNames clientwith0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=null,tableName=ClientWithMixedCaseColumnNames,tableAlias=clientwith0_,origin=null,columns={,className=hhh951.ClientWithMixedCaseColumnNames}}

select * from ( select clientwith0_.id as id1_, clientwith0_.other_id as other2_1_, clientwith0_.OTHER_ID as OTHER2_1_ from ClientWithMixedCaseColumnNames clientwith0_ ) where rownum <= ?

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira