[mapserver-dev] strange problem with WFS and ArcSDE layers

[bartvde at osgis.nl]

Hi list,

does anyone have an idea why the sequence of Query elements in the WFS
request is influencing my result?

Something like:

<GetFeature service="WFS" version="1.0.0"
  xmlns="http://www.opengis.net/wfs"
  xmlns:gml="http://www.opengis.net/gml"
  xmlns:ogc="http://www.opengis.net/ogc"
  xmlns:xlink="http://www.w3.org/1999/xlink"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://schemas.opengis.net/wfs/1.0.0 WFS-basic.xsd">
<Query typeName="KGNAT.LOEVER">
  <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
  <ogc:PropertyIsLike wildCard="*" singleChar="." escape="!">
  <ogc:PropertyName>CODEBPN</ogc:PropertyName>
  <ogc:Literal>*KST1.OO.-.23.ov*</ogc:Literal>
  </ogc:PropertyIsLike>
  </ogc:Filter>
</Query>
  <Query typeName="KGNAT.VOEVER">
 <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
 <ogc:PropertyIsLike wildCard="*" singleChar="." escape="!">
  <ogc:PropertyName>CODEBPN</ogc:PropertyName>
  <ogc:Literal>*KST1.OO.-.23.ov*</ogc:Literal>
  </ogc:PropertyIsLike>
  </ogc:Filter>
  </Query>
</GetFeature>

yields 1 result which is correct.

If I change the sequence, so first VOEVER and then LOEVER, I get:

<?xml version='1.0' encoding="ISO-8859-1" ?>
<wfs:FeatureCollection
   xmlns:rws="http://mapserver.gis.umn.edu/mapserver"
   xmlns:wfs="http://www.opengis.net/wfs"
   xmlns:gml="http://www.opengis.net/gml"
   xmlns:ogc="http://www.opengis.net/ogc"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
                       http://mapserver.gis.umn.edu/mapserver
http://test.intranet.rijkswaterstaat.nl/services/geoservices/kerngisnat_noho?SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=KGNAT.VOEVER,KGNAT.LOEVER&amp;OUTPUTFORMAT=XMLSCHEMA">
   <gml:boundedBy>
      <gml:null>missing</gml:null>
   </gml:boundedBy>
</wfs:FeatureCollection>

Using 5.2, and running out of ideas .... TIA.

Best regards,
Bart