On 01-08-2009 17:56:06 +0200, Stefan Manegold wrote:
On Sat, Aug 01, 2009 at 03:45:42PM +0000, Fabian wrote:
Modified Files: pcre.mx Log Message: Always use PCRE for case insensitive matches, even though they don't use any wildcards. As far as I know there are no case insensitive versions of BAT*select, so fixing that up would be more efforts than just going through PCRE.
Once / in case that turns[C out to be(come) a performance bottleneck, we could probably add a BAT(u)iselect (for string-tailed BATs, only) that is based on strcasecmp(3) with not too much efford ...
True, I don't expect it to be a very complicated task to achieve either. The only case for which we now do PCRE matching instead of BAT*select now is the case where you do this: SELECT col FROM table WHERE col ILIKE 'myStrInG';