[hibernate-issues] [Hibernate-JIRA] Created: (HSEARCH-1011) Unable to load entities with composite id using HSQLDB

[Baptiste MATHUS (JIRA)]

Unable to load entities with composite id using HSQLDB
------------------------------------------------------

                 Key: HSEARCH-1011
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-1011
             Project: Hibernate Search
          Issue Type: Bug
    Affects Versions: 3.1.1.GA
         Environment: HSQLDB 1.8.0.2
            Reporter: Baptiste MATHUS


Hi,

Hibernate Search actually manages to find entries in the lucene index, but then it fails trying to load them.
In fact, this issue seems to boil down to HSQLDB not supporting a query of this kind "...where (a,b) in (('x','y'))".
{{Caused by: java.sql.SQLException: Unexpected token: , in statement}}

This issue doesn't appear with Oracle, which is our production database. But it prevents us from unit/integration testing our code (using Arquillian/hsqldb/dbunit), which is in fact not very cool.

After that [discussion on the forum|https://forum.hibernate.org/viewtopic.php?f=9&t=1013645&sid=3f56cef8e295dee3c15bf77e1925e269&p=2450858#p2450858], I've taken some time to create a test project (I'll host in a dedicated github repository, actually).

As explained on the forum, I guess I'm stuck using 3.1.1.GA, since we're using JBoss EAP 5.x.

Do you think that could be fixed?
If you give me pointers so that I can see if I can propose a patch, would it even be possible to release a 3.x version of hsearch?

Thanks for your answers.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira