[WFS Server - PostGIS] PropertyIsLike filter inconsistencies

[tomkralidis]

Hi,

I am able to run a GetFeature on a given feature type with filter
PropertyIsEqualTo:

http://devgeo.cciw.ca/cgi-bin/mapserv/eccat?version=1.0.0&service=WFS&request=GetFeature&typename=service_endpoints&filter=<Filter><PropertyIsEqualTo><PropertyName>contact_country</PropertyName><Literal>Canada</Literal></PropertyIsEqualTo></Filter>&

When I attempt to run with filter PropertyIsLike:

http://devgeo.cciw.ca/cgi-bin/mapserv/eccat?version=1.0.0&service=WFS&request=GetFeature&typename=service_endpoints&filter=<Filter><PropertyIsLike
wildcard="*" singlechar="."
escape="!"><PropertyName>keywords</PropertyName><Literal>*water*</Literal></PropertyIsLike></Filter>&

I get no results back.

When I re-attempt the PropertyIsLike request with no wildcards in the
Literal:

http://devgeo.cciw.ca/cgi-bin/mapserv/eccat?version=1.0.0&service=WFS&request=GetFeature&typename=service_endpoints&filter=<Filter><PropertyIsLike
wildcard="*" singlechar="."
escape="!"><PropertyName>keywords</PropertyName><Literal>water</Literal></PropertyIsLike></Filter>&

It works.  So then I think that the PropertyIsLike attributes are not needed
since the previous command works.  When I run it:

http://devgeo.cciw.ca/cgi-bin/mapserv/eccat?version=1.0.0&service=WFS&request=GetFeature&typename=service_endpoints&filter=<Filter><PropertyIsLike><PropertyName>keywords</PropertyName><Literal>water</Literal></PropertyIsLike></Filter>&

It doesn't work.

I'm confused.  The attributes or PropertyIsLike seem to be required to execute,
however they don't work when applied?

Assefa reports that he can run these types of queries on his MapServer CVS just
fine, using shapefiles.  So I'm not sure this is a mapwfs.c or mappostgis.c issue.

A test case attachment will follow.

Environment:

MapServer CVS
PostGIS 1.0.0RC2
Fedora Core 2 box

..Tom

[tomkralidis]

testcase for this bug

[tomkralidis]

I've tested this again and all works fine now. So this means something must have been fixed since this ticket was opened. Regardless, closing.