Hi, Are you completely sure this is the query?
WHERE ATTR2 = 9 AND ATTR2 IN (<a large list that doesn't contain 9>) This sounds like it would never return rows? No matter if that's correct or not, why do you use such a large list of IN() values? I could optimize the code for this case, and I will add it to the roadmap. However, I don't understand the use case. What does the query actually do? What is this large list of literals? 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.
