Thomas, your time-to-fix is awesome! And also many thanks to all those finding the issues - some of them could hit me also, but I am just in the beginning with projects using H2 so your all contributions have the potential of saving me from headache later.
Thanks to you all! On Thu, Feb 25, 2010 at 07:12, Thomas Mueller <[email protected]> wrote: > Hi, > > I found the problem, it will be fixed in the next release. The index > is currently not used if there were multiple IN(..) conditions. A > workaround is to use OR: > > SELECT pk FROM om WHERE pk IN (<BIGINT-LIST>) AND (b = 1 OR b = 2) > > The query plan is not very clear. I will change that as well, so that > the query plan will contain ".tableScan" if a table scan is used. > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- Martin Wildam mailto:[email protected] Home: http://sites.google.com/site/mwildam/ Life Hack Blog: http://1-2-solved.blogspot.com IT Blog: http://it-tactics.blogspot.com Skype: callto:martin.wildam -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
