Hi, Conditions of the form "WHERE (ID1, ID2) IN ((5,10), (30,60))" are still slow. But I'm not aware of an "error".
Regards, Thomas On Mon, Feb 10, 2014 at 10:19 PM, Nick Hristov <[email protected]>wrote: > Has this issue been fixed? I still see the error in 1.3.174 ... > > > On Saturday, July 30, 2011 7:36:01 AM UTC-7, Thomas Mueller wrote: >> >> Hi, >> >> This is a known problem. Even equality doesn't work well for tuples >> (where (a, b) = (1, 2)). I don't consider this an urgent request >> however, as using tuples isn't very common and database-independent. >> What you could do is using one column where both columns are combined. >> Or use a join with a temporary table: >> >> from temp_table temp, your_table t where temp.a = t.a and temp.b = t.b >> >> Regards, >> Thomas >> >> -- > 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.
