Filter encoding : matchCase with WFS requests using PropertyIsEqualTo or PropertyIsLike (with a tab file)

[elzouavo]

I have a mapfile referencing a tab file (representing some french cities). I try to select a city called "milla". In the tab file the data is : "Milla". I use mapserver 5.2 from ms4w. WFS requests with filter using PropertyIsEqualTo doesn't look matchCase settings. It works always like if matchCase was false.

Example : This request matches Millas when searching millas. ​http://localhost/cgi-bin/mapserv.exe?map=C:\mapfiles\casse_couche_locale.i2.map&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=c_COMMUNE&FILTER=(%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3ENOM_COM%3C/PropertyName%3E%3CLiteral%3Emillas%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CBBOX%3E%3CPropertyName%3EmsGeometry%3C/PropertyName%3E%3CBox+srsName=%22EPSG:27582%22%3E%3Ccoordinates%3E549532,1703258+669196,1768513%3C/coordinates%3E%3C/Box%3E%3C/BBOX%3E%3C/And%3E%3C/Filter%3E)

I have also tried WFS request with PropertyIsLike and matchCase="false" and it works very good.

In fact I can say (about filter encoding with matchCase option in WFS and WMS requests on tab file) :

1. WFS requests :
   1. with filter PropertyIsEqualTo : Doesn't take into account matchCase (it works like matchCase was set to false by default) : requests are non case sensitive,
   2. with filter PropertyIsLike : OK.
2. WMS requests : (cf. ​http://trac.osgeo.org/mapserver/ticket/2730)
   1. with filter PropertyIsEqualTo : OK,
   2. with filter PropertyIsLike : Doesn't take into account matchCase (it works like matchCase was set to true by default) : requests are case sensitive.

Regards

[elzouavo]

I have test with a PostGIS database. The behaviour of MapServer is different.

1. WFS requests :

1. with filter PropertyIsEqualTo? : OK,
2. with filter PropertyIsLike? : OK.

2. WMS requests :

1. with filter PropertyIsEqualTo? : OK,
2. with filter PropertyIsLike? : Doesn't look after matchCase (it works like matchCase was set to false by default) : requests are non case sensitive.

[elzouavo]

There is also a problem of performance with WFS requests using PropertyIsLike. cf. ​http://trac.osgeo.org/mapserver/ticket/1292#comment:10

[assefa]

duplicate of #2730