From noreply at atlassian.com Fri Mar 5 10:28:49 2010 Content-Type: multipart/mixed; boundary="===============8805236222514207907==" MIME-Version: 1.0 From: Ray Fan (JIRA) To: hibernate-issues at lists.jboss.org Subject: [hibernate-issues] [Hibernate-JIRA] Created: (HHH-4977) org.hibernate.test.hql.ASTParserLoadingTest error running testOneToManyFilter with Ingres Date: Fri, 05 Mar 2010 09:28:48 -0600 Message-ID: <724203062.1394.1267802928598.JavaMail.j2ee-opensource-projects@vps07.contegix.com> --===============8805236222514207907== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable org.hibernate.test.hql.ASTParserLoadingTest error running testOneToManyFilt= er with Ingres ---------------------------------------------------------------------------= -------------- Key: HHH-4977 URL: http://opensource.atlassian.com/projects/hibernate/br= owse/HHH-4977 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), Ing= res9Dialect Reporter: Ray Fan Attachments: hql-astparserloadingtest.zip Error reported executing org.hibernate.test.hql.ASTParserLoadingTest testOn= eToManyFilter with an Ingres exception {noformat} org.hibernate.exception.SQLGrammarException: could not= execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.= java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel= per.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.j= ava:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.jav= a:196) at org.hibernate.impl.SessionImpl.listFilter(SessionImpl.java:1614) at org.hibernate.impl.CollectionFilterImpl.list(CollectionFilterImpl.ja= va:74) at org.hibernate.test.hql.ASTParserLoadingTest.testOneToManyFilter(ASTP= arserLoadingTest.java:1653) Caused by: com.ingres.gcf.util.SqlEx: A contained a 'order0_' which did not correspond to any of the s within whose scope the 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.(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(AbstractBatc= her.java:534) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatc= her.java:452) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBat= cher.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(L= oader.java:271) at org.hibernate.loader.Loader.doList(Loader.java:2254) ... 38 more {noformat} The SQL query that is produced references order0_ in the WHERE clause of th= e subselect. {noformat} select order0_.customerId as customerId35_, order0_.orderNumber as orderNum2_35_, order0_.orderDate as orderDate35_, ( select sum(li.quantity*p.cost) from LineItem li, Product p where li.productId =3D p.productId and li.customerId =3D order0_.customerId and li.orderNumber =3D order0_.orderNumber ) as formula1_ from CustomerOrder order0_ where order0_.customerId =3D ? {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: htt= p://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira =20 --===============8805236222514207907==-- From noreply at atlassian.com Mon Apr 5 09:30:32 2010 Content-Type: multipart/mixed; boundary="===============1820353631324465468==" MIME-Version: 1.0 From: Strong Liu (JIRA) To: hibernate-issues at lists.jboss.org Subject: [hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-4977) org.hibernate.test.hql.ASTParserLoadingTest error running testOneToManyFilter with Ingres Date: Mon, 05 Apr 2010 08:30:31 -0500 Message-ID: <2105016062.2264.1270474231829.JavaMail.j2ee-opensource-projects@vps07.contegix.com> In-Reply-To: 724203062.1394.1267802928598.JavaMail.j2ee-opensource-projects@vps07.contegix.com --===============1820353631324465468== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4977?p= age=3Dcom.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Strong Liu resolved HHH-4977. ----------------------------- Assignee: Strong Liu Resolution: Fixed Fix Version/s: 3.5.x > org.hibernate.test.hql.ASTParserLoadingTest error running testOneToManyFi= lter with Ingres > -------------------------------------------------------------------------= ---------------- > > Key: HHH-4977 > URL: http://opensource.atlassian.com/projects/hibernate/b= rowse/HHH-4977 > 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), In= gres9Dialect > Reporter: Ray Fan > Assignee: Strong Liu > Fix For: 3.5.x > > Attachments: hql-astparserloadingtest.zip > > > Error reported executing org.hibernate.test.hql.ASTParserLoadingTest test= OneToManyFilter with an Ingres exception > {noformat} > org.hibernate.exception.SQLGrammarException: could n= ot execute query > at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverte= r.java:91) > at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionH= elper.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.j= ava:196) > at org.hibernate.impl.SessionImpl.listFilter(SessionImpl.java:1614) > at org.hibernate.impl.CollectionFilterImpl.list(CollectionFilterImpl.= java:74) > at org.hibernate.test.hql.ASTParserLoadingTest.testOneToManyFilter(AS= TParserLoadingTest.java:1653) > Caused by: com.ingres.gcf.util.SqlEx: A contained a 'order0_' > which did not correspond to any of the
s > within whose scope the 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.(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(AbstractBa= tcher.java:534) > at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBa= tcher.java:452) > at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractB= atcher.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 > > {noformat} > The SQL query that is produced references order0_ in the WHERE clause of = the subselect. > {noformat} > select > order0_.customerId as customerId35_, > order0_.orderNumber as orderNum2_35_, > order0_.orderDate as orderDate35_, > ( select > sum(li.quantity*p.cost) > from > LineItem li, > Product p > where > li.productId =3D p.productId > and li.customerId =3D order0_.customerId > and li.orderNumber =3D order0_.orderNumber ) as formula1_ > from > CustomerOrder order0_ > where > order0_.customerId =3D ? > {noformat} > Once the scoping error is removed a more fundamental error is exposed "Su= b-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: htt= p://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira =20 --===============1820353631324465468==--