CQL/Filter Like is case sensitive
---------------------------------
Key: GEOT-2356
URL: http://jira.codehaus.org/browse/GEOT-2356
Project: GeoTools
Issue Type: Bug
Components: data postgis
Affects Versions: 2.5.2
Environment: Postgresql 8, Java 6 (probably all earlier too)
Reporter: Nick Griffiths
Assignee: Justin Deoliveira
Priority: Minor
PostgreSQL has two like operators, LIKE and ILIKE which are case sensitive and
insensitive respectively. The SQLEncoderPostgis is using LIKE which makes it
case sensitive, whereas other database plugins are presumably case insensitive.
There doesn't seem to be a way to do case-insensitive filtering through the
CQL/Filtering api, so I'm guessing the LIKE should be changed to ILIKE to make
the Postgis driver work like all the others. Not sure what CQL says about
case-sensitivity...
We've patched gt-postgis to do the ILIKE so it works for us - it is a very
basic change, but i'd be happy to append a patch.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
