[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5002) testQuery in org.hibernate.test.legacy.FooBarTest errors running with Ingres dialect

testQuery in org.hibernate.test.legacy.FooBarTest errors running with Ingres dialect ------------------------------------------------------------------------------------ Key: HHH-5002 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5002 Project: Hibernate Core Issue Type: Bug Components: query-sql, testsuite Affects Versions: 3.5.0-CR-2 Environment: Hibernate 3.5.0-CR-2, Ingres 9.3.1 (int.lnx/106), IngresDialect Reporter: Ray Fan Assignee: Strong Liu Attachments: legacy.FooBarTest.zip testQuery in org.hibernate.test.legacy.FooBarTest errors with an exception whilst using IngresDialect {noformat} <error message="could not execute query" type="org.hibernate.exception.GenericJDBCException">org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2276) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2151) at org.hibernate.loader.Loader.list(Loader.java:2146) at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:936) 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.legacy.FooBarTest.testQuery(FooBarTest.java:388) Caused by: com.ingres.gcf.util.SqlEx: An internal error prevents further processing of this query. Associated error messages which provide more detailed information about the problem can be found in the error log, II_CONFIG:errlog.log at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source) at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source) at com.ingres.gcf.jdbc.RsltFtch.preLoad(Unknown Source) at com.ingres.gcf.jdbc.RsltCurs.preLoad(Unknown Source) at com.ingres.gcf.jdbc.RsltCurs.&lt;init&gt;(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.exec(Unknown Source) at com.ingres.gcf.jdbc.JdbcPrep.executeQuery(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1832) at org.hibernate.loader.Loader.doQuery(Loader.java:719) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:271) at org.hibernate.loader.Loader.doList(Loader.java:2273) ... 37 more </error> {noformat}