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

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...], 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.