Is there any way to make use of a case sensitive index when doing a case insensitive query?
I can, in fact, 'unroll' the matches if they're not very long, like select * where x = 'foo' union select * where x = 'foO' union select * where x = 'fOo' union ... which is much, much faster than doing select * where lower(x) = 'foo' which requires a table scan. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
