Hi, No, I'm sorry, I don't have a solution for this. Patches are welcome!
According to my test, MySQL, PostgreSQL, and HSQLDB support this. Apache Derby and H2 do not. I think the typical solution would be to use a join. Regards, Thomas On Fri, Sep 20, 2013 at 6:38 PM, Markus Waltl <[email protected]>wrote: > 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. > -- 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.
