[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2066) HSQL DB + multi-schema --> raised an exception (Problem to get an increment key [select max(id) from table)

[XOrangOutan (JIRA)]

HSQL DB + multi-schema --> raised an exception (Problem to get an increment key [select max(id) from table)
-----------------------------------------------------------------------------------------------------------

         Key: HHH-2066
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2066
     Project: Hibernate3
        Type: Bug

  Components: core  
    Versions: 3.2.0.cr4    
 Environment: HSQL DB 1.8.x
    Reporter: XOrangOutan


When trying to save an object that has an "incremental" primary key, Hibernate API tries to know what the max current id is by executing a "SELECT MAX".

Though, in this particular sql query, schema name is not taken into account (in hsqldialect). This cause an error that prevents anyone from carrying out unit tests.

This bug also exists on 3.x versions





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