[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4075) UnsupportedOperationException when assigning an alias to an indexed collection

[Robert Wruck (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=33731#action_33731 ] 

Robert Wruck commented on HHH-4075:
-----------------------------------

Oh and there is another issue:

select count(*) from Order o left join o.orderAttributes oa
where maxelement(oa) = '2'

java.lang.StringIndexOutOfBoundsException: String index out of range: -5
        at java.lang.String.substring(String.java:1768)
        at java.lang.String.substring(String.java:1735)
        at org.hibernate.hql.CollectionSubqueryFactory.createCollectionSubquery(CollectionSubqueryFactory.java:55)
        at org.hibernate.hql.ast.tree.FromElementType.toColumns(FromElementType.java:325)
        at org.hibernate.hql.ast.tree.FromElementType.toColumns(FromElementType.java:315)
        at org.hibernate.hql.ast.tree.FromElement.toColumns(FromElement.java:414)
        at org.hibernate.hql.ast.tree.MethodNode.resolveCollectionProperty(MethodNode.java:138)
        at org.hibernate.hql.ast.tree.MethodNode.collectionProperty(MethodNode.java:118)
        at org.hibernate.hql.ast.tree.MethodNode.resolve(MethodNode.java:67)
        at org.hibernate.hql.ast.HqlSqlWalker.processFunction(HqlSqlWalker.java:961)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.functionCall(HqlSqlBaseWalker.java:2465)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1364)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4243)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3722)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1864)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:818)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:604)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:288)
        at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:231)
        at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
        at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
        at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
        at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
        at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
        at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
        at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
        at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
        at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)


> UnsupportedOperationException when assigning an alias to an indexed collection
> ------------------------------------------------------------------------------
>
>                 Key: HHH-4075
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4075
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: query-hql
>    Affects Versions: 3.3.2
>         Environment: Hibernate 3.3.2.GA, MySQL5InnoDBDialect
>            Reporter: Robert Wruck
>
> This works:
> select count(*) from Order o left join o.orderAttributes oa, Attribute a
> where a.id = 1
> and index(oa) = a
> but accessing elements throws an exception:
> select count(*) from Order o left join o.orderAttributes oa, Attribute a
> where a.id = 1
> and oa[a] is null or oa[a] = '2'
> Replacing oa[a] with o.orderAttributes[a] does not throw an exception but also does an inner join, so it's not a workaround.
> Stack trace:
> java.lang.UnsupportedOperationException
>         at org.hibernate.hql.ast.tree.IdentNode.resolveIndex(IdentNode.java:66)
>         at org.hibernate.hql.ast.tree.IndexNode.resolve(IndexNode.java:94)
>         at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:117)
>         at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:113)
>         at org.hibernate.hql.ast.HqlSqlWalker.processIndex(HqlSqlWalker.java:956)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:4576)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1289)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4243)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4084)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1864)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1792)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:818)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:604)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:288)
>         at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:231)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
>         at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
>         at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
>         at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
>         at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
>         at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
>         at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
>         at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)

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