[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4931) two tests in org.hibernate.test.legacy.MultiTableTest fail on Ingres

[Strong Liu (JIRA)]

two tests in org.hibernate.test.legacy.MultiTableTest fail on Ingres
--------------------------------------------------------------------

                 Key: HHH-4931
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4931
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.5.0-CR-1
         Environment: ingres 9.3
            Reporter: Strong Liu
            Assignee: Strong Liu


  testMultiTable(org.hibernate.test.legacy.MultiTableTest)
  testMultiTableGeneratedId(org.hibernate.test.legacy.MultiTableTest)
-------------------------
20:37:55,892  WARN JDBCExceptionReporter:100 - SQL Error: 2925, SQLState: 5000A
20:37:55,893 ERROR JDBCExceptionReporter:101 - SELECT: FOR UPDATE clause found in non-updatable SELECT statement. 
      May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more 
      than one variable in the FROM clause, at the outermost query level.
20:37:55,895  INFO DefaultLoadEventListener:160 - Error performing load command
org.hibernate.exception.GenericJDBCException: could not load an entity: [org.hibernate.test.legacy.Top#1]
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:132)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:120)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1921)
	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
	at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
	at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3212)
	at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
	at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
	at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
	at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:403)
	at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:155)
	at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
	at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1045)
	at org.hibernate.impl.SessionImpl.load(SessionImpl.java:1036)
	at org.hibernate.test.legacy.MultiTableTest.testMultiTable(MultiTableTest.java:343)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at junit.framework.TestCase.runTest(TestCase.java:154)
	at org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:125)
	at junit.framework.TestCase.runBare(TestCase.java:127)
	at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:63)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:118)
	at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: com.ingres.gcf.util.SqlEx: SELECT: FOR UPDATE clause found in non-updatable SELECT statement. 
      May not use set function, GROUP, HAVING, DISTINCT, UNION, ORDER or more 
      than one variable in the FROM clause, at the outermost query level.
	at com.ingres.gcf.jdbc.DrvObj.readError(Unknown Source)
	at com.ingres.gcf.jdbc.JdbcStmt.readError(Unknown Source)
	at com.ingres.gcf.jdbc.DrvObj.readResults(Unknown Source)
	at com.ingres.gcf.jdbc.JdbcStmt.readResults(Unknown Source)
	at com.ingres.gcf.jdbc.JdbcStmt.readResults(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.loadEntity(Loader.java:1907)
	... 30 more

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