I can remember this discussion since I think I pointed out the problem with the indices. And I was against it.
I am wondering that this feature is implemented. Nobody, having a little knowledge about db engines would formulate such an SQL clause putting performance for large tables into the cellar. It is better to store the uppercase content into an additional attribute. Anyways, I see some questions on the user lists like "Why is the performance so slow.... " and then we have to inform the user to not use this feature, but we are offering it. Strange. Quoting Justin Deoliveira <jdeol...@opengeo.org>: > Yeah seems strange. Although something vaguely familiar perhaps for cite > tests. But I can't recall anything that would require that behavior, I > think case sensitive should be the default. > > On 10-06-16 11:12 AM, Andrea Aime wrote: >> Hi, >> the current filter factory creates case insensitive like filters >> which end up being encoded in sql as upper(att) like 'BLAH%' >> making it impossible to use indexing. >> >> Was that done on purpose or just by accident? >> >> Cheers >> Andrea >> > > > -- > Justin Deoliveira > OpenGeo - http://opengeo.org > Enterprise support for open source geospatial. > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > Geotools-devel mailing list > Geotools-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
