I understand the workaround. Shouldn't this information be on the h2 site somewhere (and not only in the forums)?
The same with the fact that REGEXP does not use indicies. I'm worried that there are other commands that do not use indicies and I dont know about them because they are in some posting and not in the documentation. On Wednesday, October 3, 2012 6:12:54 AM UTC-4, Vasile Rotaru wrote: > > This was already discussed some time ago. A working workaround is to use > > (SELECT ..) UNION (SELECT ...) > > instead of OR. > > On Tue, Oct 2, 2012 at 6:57 PM, BrianR <[email protected] <javascript:>> > wrote: > > If column a is index and running a query of >> >> SELECT * FROM tableFoo WHERE a = 'value' OR a LIKE 'value2' >> >> does not use the index on a. >> >> I also noticed the following query does not use an index >> >> SELECT * FROM tableFoo WHERE a = 'value' OR 1=1 >> >> This may be by design but probably should be documented somewhere. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/h2-database/-/GjKh5-2c-H4J. >> To post to this group, send email to [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > -- > Vasile Rotaru > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/Fy_NTkf0qGUJ. 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.
