[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4973) org.hibernate.test.hql.ASTParserLoadingTest error running testSelectClauseSubselect with Ingres
org.hibernate.test.hql.ASTParserLoadingTest error running testSelectClauseSubselect with
Ingres
-----------------------------------------------------------------------------------------------
Key: HHH-4973
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4973
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
Attachments: hql-astparserloadingtest.zip
Error executing testSelectClauseSubselect in org.hibernate.test.hql.ASTParserLoadingTest
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.testSelectClauseSubselect(ASTParserLoadingTest.java:1057)
Caused by: com.ingres.gcf.util.SqlEx: A <column reference> contained a
<qualifier> 'animal0_'
which did not correspond to any of the <table reference>s
within whose scope the <column reference> 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.<init>(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 animal0_ in the WHERE clause of the sub-select.
{noformat}
select
(select
max(zoo1_.id)
from
Zoo zoo1_
where
animal0_.zoo_id=zoo1_.id) as col_0_0_
from
Animal animal0_
{noformat}
Once the scoping error is removed a more fundamental error is exposed "Sub-selects
are not supported within select target lists."
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira