Sorry Andrea, but I cant remember the point in time. Independent of the result of the discussion I would propose to write at least a warning to the log file if we do a toUpper(attribute).
I did something similar in the db2 module concerning limit and offset handling. "Warning: DB2 handles limit and offset inefficiently, turn Oracle features on to avoid this" This is at least a hint for users why performance may have degraded. Quoting Andrea Aime <aa...@opengeo.org>: > 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. ---------------------------------------------------------------- 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
