christian.muel...@nvoe.at ha scritto: > I can remember this discussion since I think I pointed out the problem > with the indices. And I was against it.
Ah, so there has been a discussion on this? Do you remember when? > 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. So it seems there is some agreement that like should be case sensitive. At the same time I have this nagging feeling that it's not case insensitive because various used asked for it that way, but I can't find the relevant discussion. What worries me the most is that if we flip the behavior we might break someone application irreparably. People using GeoTools can use FilterFactory2 and exert control over the case sensitivity flag, but in CQL and OGC Filter 1.1 there is no way to state a case sensivity flag... Cheers Andrea -- Andrea Aime OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ 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
