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'; ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
