JPA - Native Queries : IN condition fails

[Timo Westkämper]

SQLTemplates templates = new MySQLTemplates();
HibernateSQLQuery query = new HibernateSQLQuery(session, templates);

Collection collection = new ArrayList();
collection.add("test1");
collection.add("test");

query.from(example).where(example.column.in(collection));

it's returning

select example.*
from example example
where example.column in ?, ?

It fails due to MySQL needing parens - in (?,?)

[Timo Westkämper (timo-westkamper)]

Fixed in SVN trunk

[Timo Westkämper (timo-westkamper)]

Released in 2.2.0-beta4