Opened 12 years ago
#4150 new defect
WFS Filter "IsEqualTo" makes wrong assumption on field type
Reported by: | jaykayone | Owned by: | msogcbugs |
---|---|---|---|
Priority: | high | Milestone: | |
Component: | WFS Server | Version: | 6.0 |
Severity: | normal | Keywords: | WFS, Filter, XSD |
Cc: |
Description
If a WFS Filter Request contains a numeric value, mapserver will generate a SQL Query on Postgres with a numeric value even if the field is a string field.
eg: <PropertyIsEqualTo><PropertyName>code_commu</PropertyName><Literal>105</Literal></PropertyIsEqualTo>
If we explicitly set the field type (or use "gml_types" "auto") the query is correct, but the XSD served for the getDescription - Request becomes invalid. The field is declared as "Character" which is not a correct XSD type. It should be string.
Observed on Mapserver 6.0.1. built from source on RHEL 6 with a PostGIS Database.