search

josefmezera / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Supporting multiple columns for IN-clause #595

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
At least Oracle and HSQLDB is supporting this feature.

For example a SQL like

select a.* from table_a a
where (a.foo, a.bar) in 
(select foo, max(bar) from table_b
 group by foo)

is working in Oracle and HSQLDB, but not in H2

Will be good that H2 can support these extra SQL feature.

Original issue reported on code.google.com by adrians...@gmail.com on 6 Jan 2015 at 2:06