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

org.hibernate.test.hql.ASTParserLoadingTest error running testJpaTypeOperator test with Ingres ---------------------------------------------------------------------------------------------- Key: HHH-4960 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4960 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 Attachments: hql-astparserloadingtest.zip org.hibernate.test.hql.ASTParserLoadingTest testJpaTypeOperator reports an error executing the test 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(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.testJpaTypeOperator(ASTParserLoadingTest.java:121) Caused by: com.ingres.gcf.util.SqlEx: line 1, There is no such function as 'type'. 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) {noformat} The test source code {{s.createQuery( "from Animal a where type(a) = Dog" ).list();}} invokes the 'type' function as part of the SQL WHERE clause. The function 'type' is not one that is supported by Ingres.