Hi, is there already a solution for this planned? As the current version still does not support this kind of queries.
I am using H2 with Hibernate and have the issue that Hibernate generates a query with multiple columns in the subquery which I cannot modify. Do you have a solution for this, e.g., modifying the H2Dialect of Hibernate or telling Hibernate to not generate this thing? Best regards, Markus On Wednesday, November 30, 2011 4:40:54 PM UTC+1, Noel Grandin wrote: > > > H2 does not currently support that style of IN query. > > You're welcome to log a feature request. > > Karsten Krieg wrote: > > Hi group! > > > > We have a working query (working on oracle that is) which throws the > > above SQL error in H2 v1.3.154. The query is designed to return two > > values from a subquery. This seems to be defunct in H2. > > > > The query is: > > > > select * from organization as org > > where (org.id, org.timestamp) in > > ( select org1.id, max(org1.timestamp) from organization as ges1 > > group by org1.id) > > and org.state=1 > > order by org.name; > > > > > > > > Is this designed as such or are we facing a bug? > > > > Thanks > > Karsten > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
