[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-4961) org.hibernate.test.hql.ASTParserLoadingTest error running testPaginationWithPolymorphicQuery with Ingres

[Strong Liu (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Strong Liu resolved HHH-4961.
-----------------------------

       Resolution: Fixed
    Fix Version/s:  3.5.x

skip this test on ingres

> org.hibernate.test.hql.ASTParserLoadingTest error running  testPaginationWithPolymorphicQuery with Ingres
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-4961
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4961
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: testsuite
>    Affects Versions: 3.5.0-CR-2
>         Environment: Hibernate 3.5.0-CR-2, Ingres 9.3.1 (int.lnx/106), Ingres9Dialect
>            Reporter: Ray Fan
>            Assignee: Strong Liu
>             Fix For:  3.5.x
>
>         Attachments: hql-astparserloadingtest.zip
>
>
> org.hibernate.test.hql.ASTParserLoadingTest testPaginationWithPolymorphicQuery reports an error executing the test with an Ingres exception
> {noformat}
> <error message="could not execute query" type="org.hibernate.exception.SQLGrammarException">org.hibernate.exception.SQLGrammarException: could not execute query
>     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
>     at org.hibernate.loader.Loader.doList(Loader.java:2257)
>     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2151)
>     at org.hibernate.loader.Loader.list(Loader.java:2146)
>     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448)
>     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
>     at org.hibernate.test.hql.ASTParserLoadingTest.testPaginationWithPolymorphicQuery(ASTParserLoadingTest.java:249)
> Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a <qualifier> 'product0_'
> which did not correspond to any of the <table reference>s
> within whose scope the &lt;column reference&gt; appeared.
>     at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source)
>     at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source)
>     at com.ingres.gcf.jdbc.DrvPrep.prepare(Unknown Source)
>     at com.ingres.gcf.jdbc.DrvConn.createPrepStmt(Unknown Source)
>     at com.ingres.gcf.jdbc.JdbcPrep.&lt;init&gt;(Unknown Source)
>     at com.ingres.gcf.jdbc.JdbcConn.createPrep(Unknown Source)
>     at com.ingres.gcf.jdbc.JdbcConn.prepareStatement(Unknown Source)
>     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
>     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
>     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
>     at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1597)
>     at org.hibernate.loader.Loader.doQuery(Loader.java:718)
>     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271)
>     at org.hibernate.loader.Loader.doList(Loader.java:2254)
>     ... 38 more
> </error>
> {noformat}
> The SQL query that is produced references product0_ in the WHERE clause of the subselect.
> {noformat}
>     select
>         product0_.productId as productId37_,
>         product0_.description as descript2_37_,
>         product0_.cost as cost37_,
>         product0_.numberAvailable as numberAv4_37_,
>         ( select
>             sum(li.quantity)
>         from
>             LineItem li
>         where
>             li.productId = product0_.productId ) as formula2_
>     from
>         Product product0_
> {noformat}
> Ingres does not support this scoping in 9.3.

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