WMS request using PropertyIsEqualTo and matchCase="false" (on a PostGIS database) :
http request : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&&LAYERS=bdparcellaire_numero&SLD_BODY=%3CStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3CNamedLayer%3E%3CName%3Ebdparcellaire_numero%3C%2FName%3E%3CUserStyle%3E%3CFeatureTypeStyle%3E%3CRule%3E%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C%2FPropertyName%3E%3CLiteral%3E66%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%20matchCase=%22false%22%3E%3CPropertyName%3Enom_com%3C%2FPropertyName%3E%3CLiteral%3ELES%20angles%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C%2FPropertyName%3E%3CLiteral%3EAH%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C%2FPropertyName%3E%3CLiteral%3E41%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FAnd%3E%3C%2FFilter%3E%3CPointSymbolizer%3E%3CGraphic%3E%3CMark%3E%3CWellKnownName%3Ecircle%3C%2FWellKnownName%3E%3CFill%3E%3CCssParameter%20name%3D%22fill%22%3E%23A5F38D%3C%2FCssParameter%3E%3C%2FFill%3E%3C%2FMark%3E%3CSize%3E20.0%3C%2FSize%3E%3C%2FGraphic%3E%3C%2FPointSymbolizer%3E%3C%2FRule%3E%3C%2FFeatureTypeStyle%3E%3C%2FUserStyle%3E%3C%2FNamedLayer%3E%3C%2FStyledLayerDescriptor%3E&ISBASELAYER=false&TRANSPARENT=true&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&SRS=EPSG%3A27582&BBOX=578278.0213085935,1730404.299804687,578406.2266601564,1730489.7700390625&WIDTH=900&HEIGHT=600
http request for human : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&&LAYERS=bdparcellaire_numero&SLD_BODY=bdparcellaire_numerocode_dep66nom_comLES anglessectionAHnumero41circle#A5F38D20.0
&ISBASELAYER=false&TRANSPARENT=true&FORMAT=image/png&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&EXCEPTIONS=application/vnd.ogc.se_inimage&SRS=EPSG:27582&BBOX=578278.0213085935,1730404.299804687,578406.2266601564,1730489.7700390625&WIDTH=900&HEIGHT=600
Log mapserver(verbosity = 2) :
[Fri Aug 22 14:22:55 2008].529003 loadParams() QUERY_STRING: map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&&LAYERS=bdparcellaire_numero&SLD_BODY=%3CStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3CNamedLayer%3E%3CName%3Ebdparcellaire_numero%3C%2FName%3E%3CUserStyle%3E%3CFeatureTypeStyle%3E%3CRule%3E%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C%2FPropertyName%3E%3CLiteral%3E66%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%20matchCase=%22false%22%3E%3CPropertyName%3Enom_com%3C%2FPropertyName%3E%3CLiteral%3ELES%20angles%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C%2FPropertyName%3E%3CLiteral%3EAH%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C%2FPropertyName%3E%3CLiteral%3E41%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FAnd%3E%3C%2FFilter%3E%3CPointSymbolizer%3E%3CGraphic%3E%3CMark%3E%3CWellKnownName%3Ecircle%3C%2FWellKnownName%3E%3CFill%3E%3CCssParameter%20name%3D%22fill%22%3E%23A5F38D%3C%2FCssParameter%3E%3C%2FFill%3E%3C%2FMark%3E%3CSize%3E20.0%3C%2FSize%3E%3C%2FGraphic%3E%3C%2FPointSymbolizer%3E%3C%2FRule%3E%3C%2FFeatureTypeStyle%3E%3C%2FUserStyle%3E%3C%2FNamedLayer%3E%3C%2FStyledLayerDescriptor%3E&ISBASELAYER=false&TRANSPARENT=true&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&SRS=EPSG%3A27582&BBOX=578278.0213085935,1730404.299804687,578406.2266601564,1730489.7700390625&WIDTH=900&HEIGHT=600
[Fri Aug 22 14:22:55 2008].550569 msLoadMap(): 0.021s
[Fri Aug 22 14:22:55 2008].552709 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:22:55 2008].552738 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 14:22:55 2008].620755 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8361878)
[Fri Aug 22 14:22:55 2008].620805 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:22:55 2008].620823 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 14:22:55 2008].620836 msPOSTGISLayerWhichShapes called
[Fri Aug 22 14:22:55 2008].620873 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 14:22:55 2008].621901 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "code_dep"::text,"nom_com"::text,"section"::text,"numero"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE the_geom && setSRID('BOX3D(578278.092533789 1730404.37102988,578406.155434961 1730489.69881387)'::BOX3D, 27582 )
[Fri Aug 22 14:22:55 2008].663709 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:22:55 2008].663731 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:22:55 2008].663739 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 14:22:55 2008].665098 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8361878)
[Fri Aug 22 14:22:55 2008].665115 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8361878)
[Fri Aug 22 14:22:55 2008].665539 msDrawMap(): Layer 2 (bdparcellaire_numero), 0.113s
[Fri Aug 22 14:22:55 2008].689938 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:22:55 2008].689968 msPOSTGISLayerClose -- layerinfo is NULL
[Fri Aug 22 14:22:55 2008].690416 mapserv total execution time: 0.162s
WMS request using PropertyIsLike (on a PostGIS database) :
http request : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&&LAYERS=bdparcellaire_numero&SLD_BODY=%3CStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3CNamedLayer%3E%3CName%3Ebdparcellaire_numero%3C%2FName%3E%3CUserStyle%3E%3CFeatureTypeStyle%3E%3CRule%3E%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C%2FPropertyName%3E%3CLiteral%3E66%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsLike%20wildCard%3D%22*%22%20singleChar%3D%22%23%22%20escapeChar%3D%22!%22%20escape%3D%22!%22%20matchCase=%22true%22%3E%3CPropertyName%3Enom_com%3C/PropertyName%3E%3CLiteral%3E*Les%20AnGLes*%3C/Literal%3E%3C/PropertyIsLike%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C%2FPropertyName%3E%3CLiteral%3EAH%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C%2FPropertyName%3E%3CLiteral%3E41%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FAnd%3E%3C%2FFilter%3E%3CPointSymbolizer%3E%3CGraphic%3E%3CMark%3E%3CWellKnownName%3Ecircle%3C%2FWellKnownName%3E%3CFill%3E%3CCssParameter%20name%3D%22fill%22%3E%23A5F38D%3C%2FCssParameter%3E%3C%2FFill%3E%3C%2FMark%3E%3CSize%3E20.0%3C%2FSize%3E%3C%2FGraphic%3E%3C%2FPointSymbolizer%3E%3C%2FRule%3E%3C%2FFeatureTypeStyle%3E%3C%2FUserStyle%3E%3C%2FNamedLayer%3E%3C%2FStyledLayerDescriptor%3E&ISBASELAYER=false&TRANSPARENT=true&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&SRS=EPSG%3A27582&BBOX=578278.0213085935,1730404.299804687,578406.2266601564,1730489.7700390625&WIDTH=900&HEIGHT=600
Log mapserver(verbosity = 2) :
[Fri Aug 22 15:51:20 2008].271848 loadParams() QUERY_STRING: map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&&LAYERS=bdparcellaire_numero&SLD_BODY=%3CStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3CNamedLayer%3E%3CName%3Ebdparcellaire_numero%3C%2FName%3E%3CUserStyle%3E%3CFeatureTypeStyle%3E%3CRule%3E%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C%2FPropertyName%3E%3CLiteral%3E66%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsLike%20wildCard%3D%22*%22%20singleChar%3D%22%23%22%20escapeChar%3D%22!%22%20escape%3D%22!%22%20matchCase=%22true%22%3E%3CPropertyName%3Enom_com%3C/PropertyName%3E%3CLiteral%3E*Les%20AnGLes*%3C/Literal%3E%3C/PropertyIsLike%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C%2FPropertyName%3E%3CLiteral%3EAH%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C%2FPropertyName%3E%3CLiteral%3E41%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FAnd%3E%3C%2FFilter%3E%3CPointSymbolizer%3E%3CGraphic%3E%3CMark%3E%3CWellKnownName%3Ecircle%3C%2FWellKnownName%3E%3CFill%3E%3CCssParameter%20name%3D%22fill%22%3E%23A5F38D%3C%2FCssParameter%3E%3C%2FFill%3E%3C%2FMark%3E%3CSize%3E20.0%3C%2FSize%3E%3C%2FGraphic%3E%3C%2FPointSymbolizer%3E%3C%2FRule%3E%3C%2FFeatureTypeStyle%3E%3C%2FUserStyle%3E%3C%2FNamedLayer%3E%3C%2FStyledLayerDescriptor%3E&ISBASELAYER=false&TRANSPARENT=true&FORMAT=image%2Fpng&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_inimage&SRS=EPSG%3A27582&BBOX=578278.0213085935,1730404.299804687,578406.2266601564,1730489.7700390625&WIDTH=900&HEIGHT=600
[Fri Aug 22 15:51:20 2008].293142 msLoadMap(): 0.021s
[Fri Aug 22 15:51:20 2008].295288 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:51:20 2008].295315 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:51:20 2008].361078 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8361c30)
[Fri Aug 22 15:51:20 2008].361127 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:51:20 2008].361144 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:51:20 2008].361156 msPOSTGISLayerWhichShapes called
[Fri Aug 22 15:51:20 2008].361191 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:51:20 2008].362221 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "nom_com"::text,"code_dep"::text,"section"::text,"numero"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE the_geom && setSRID('BOX3D(578278.092533789 1730404.37102988,578406.155434961 1730489.69881387)'::BOX3D, 27582 )
[Fri Aug 22 15:51:20 2008].402187 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:51:20 2008].402210 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:51:20 2008].402218 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 15:51:20 2008].403551 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8361c30)
[Fri Aug 22 15:51:20 2008].403569 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8361c30)
[Fri Aug 22 15:51:20 2008].403987 msDrawMap(): Layer 2 (bdparcellaire_numero), 0.109s
[Fri Aug 22 15:51:20 2008].428003 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:51:20 2008].428034 msPOSTGISLayerClose -- layerinfo is NULL
[Fri Aug 22 15:51:20 2008].428473 mapserv total execution time: 0.157s
WFS request using PropertyIsEqualTo and matchCase="false" (on a PostGIS database) :
http request : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&=&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=bdparcellaire_numero&FILTER=(%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C/PropertyName%3E%3CLiteral%3E66%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%20matchCase=%22false%22%3E%3CPropertyName%3Enom_com%3C/PropertyName%3E%3CLiteral%3ELes%20angles%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C/PropertyName%3E%3CLiteral%3EAH%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C/PropertyName%3E%3CLiteral%3E41%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3C/And%3E%3C/Filter%3E)
http request for human : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&=&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=bdparcellaire_numero&FILTER=(code_dep66nom_comLes anglessectionAHnumero41)
Log mapserver(verbosity = 2) :
[Fri Aug 22 14:50:31 2008].868381 loadParams() QUERY_STRING: map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&=&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=bdparcellaire_numero&FILTER=(%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C/PropertyName%3E%3CLiteral%3E66%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%20matchCase=%22false%22%3E%3CPropertyName%3Enom_com%3C/PropertyName%3E%3CLiteral%3ELes%20angles%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C/PropertyName%3E%3CLiteral%3EAH%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C/PropertyName%3E%3CLiteral%3E41%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3C/And%3E%3C/Filter%3E)
[Fri Aug 22 14:50:31 2008].890382 msLoadMap(): 0.022s
[Fri Aug 22 14:50:31 2008].891019 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:31 2008].891043 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 14:50:31 2008].957626 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8283410)
[Fri Aug 22 14:50:31 2008].957674 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:50:31 2008].957686 in msPOSTGISLayerGetItems (find column names)
[Fri Aug 22 14:50:31 2008].957721 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 14:50:31 2008].961918 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 14:50:31 2008].961947 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:50:31 2008].961955 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:31 2008].961964 msPOSTGISLayerClose -- query_result is NULL
[Fri Aug 22 14:50:31 2008].961971 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8283410)
[Fri Aug 22 14:50:31 2008].961983 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x8283410)
[Fri Aug 22 14:50:31 2008].962492 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:31 2008].962512 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 14:50:32 2008].18912 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b07c0)
[Fri Aug 22 14:50:32 2008].18944 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:50:32 2008].18956 msPOSTGISLayerWhichShapes called
[Fri Aug 22 14:50:32 2008].18979 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 14:50:32 2008].19929 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE ( (code_dep= 66) And ( (lower(nom_com) = lower('Les angles') ) And ( (section= 'AH') And (numero= 41) ) ) ) and (the_geom && setSRID( 'BOX3D(47650 1620400,1197850 2677450)'::BOX3D,27582) )
[Fri Aug 22 14:50:33 2008].563248 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:50:33 2008].563265 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:33 2008].563274 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 14:50:33 2008].564522 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b07c0)
[Fri Aug 22 14:50:33 2008].564538 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b07c0)
[Fri Aug 22 14:50:33 2008].565097 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:33 2008].565161 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 14:50:33 2008].621668 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b07c0)
[Fri Aug 22 14:50:33 2008].621699 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:50:33 2008].621708 in msPOSTGISLayerGetItems (find column names)
[Fri Aug 22 14:50:33 2008].621725 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 14:50:33 2008].628396 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 14:50:33 2008].628499 msPOSTGISLayerGetShape called for record = 676578
[Fri Aug 22 14:50:33 2008].629120 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 14:50:33 2008].629142 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT "gid"::text,"numero"::text,"feuille"::text,"section"::text,"code_dep"::text,"nom_com"::text,"code_com"::text,"com_abs"::text,"code_arr"::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from (select * FROM localisant) as foo WHERE gid = 676578
[Fri Aug 22 14:50:33 2008].665297 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 14:50:33 2008].665312 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:33 2008].665320 msPOSTGISLayerClose -- query_result is NULL
[Fri Aug 22 14:50:33 2008].665328 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b07c0)
[Fri Aug 22 14:50:33 2008].665340 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b07c0)
[Fri Aug 22 14:50:33 2008].665534 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 14:50:33 2008].665554 msPOSTGISLayerClose -- layerinfo is NULL
[Fri Aug 22 14:50:33 2008].666034 mapserv total execution time: 1.798s
WFS request using PropertyIsLike and matchCase="false" (on a PostGIS database) :
http request : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&=&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=bdparcellaire_numero&FILTER=(code_dep66nom_com*Les aNGles*sectionAHnumero41)
http request for human : http://mapserver_i2.cete-mediterranee.i2/maps/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&=&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=bdparcellaire_numero&FILTER=(code_dep66nom_com*Les aNGles*sectionAHnumero41)
Log mapserver(verbosity = 2) :
[Fri Aug 22 15:09:34 2008].590769 loadParams() QUERY_STRING: map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_iso.map&=&SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=bdparcellaire_numero&FILTER=(%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Ecode_dep%3C/PropertyName%3E%3CLiteral%3E66%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsLike%20wildCard%3D%22*%22%20singleChar%3D%22%23%22%20escapeChar%3D%22!%22%20escape%3D%22!%22%20matchCase=%22false%22%3E%3CPropertyName%3Enom_com%3C/PropertyName%3E%3CLiteral%3E*Les%20aNGles*%3C/Literal%3E%3C/PropertyIsLike%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esection%3C/PropertyName%3E%3CLiteral%3EAH%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Enumero%3C/PropertyName%3E%3CLiteral%3E41%3C/Literal%3E%3C/PropertyIsEqualTo%3E%3C/And%3E%3C/Filter%3E)
[Fri Aug 22 15:09:34 2008].612394 msLoadMap(): 0.021s
[Fri Aug 22 15:09:34 2008].613046 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:09:34 2008].613069 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:09:34 2008].679192 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82838a8)
[Fri Aug 22 15:09:34 2008].679241 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:09:34 2008].679253 in msPOSTGISLayerGetItems (find column names)
[Fri Aug 22 15:09:34 2008].679288 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:09:34 2008].683485 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:09:34 2008].683513 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:09:34 2008].683522 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:09:34 2008].683530 msPOSTGISLayerClose -- query_result is NULL
[Fri Aug 22 15:09:34 2008].683538 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82838a8)
[Fri Aug 22 15:09:34 2008].683550 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82838a8)
[Fri Aug 22 15:09:34 2008].684049 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:09:34 2008].684071 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:09:34 2008].740724 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b0ad8)
[Fri Aug 22 15:09:34 2008].740757 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:09:34 2008].740770 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:09:34 2008].740780 msPOSTGISLayerWhichShapes called
[Fri Aug 22 15:09:34 2008].740801 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:09:34 2008].741740 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "code_dep"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE the_geom && setSRID('BOX3D(47650 1620400,1197850 2677450)'::BOX3D, 27582 )
[Fri Aug 22 15:09:50 2008].932299 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:09:50 2008].932326 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:09:50 2008].932336 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 15:09:50 2008].964509 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b0ad8)
[Fri Aug 22 15:09:50 2008].964541 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b0ad8)
[Fri Aug 22 15:09:51 2008].209113 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:09:51 2008].209218 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:09:51 2008].265135 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b0ad8)
[Fri Aug 22 15:09:51 2008].265167 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:09:51 2008].265178 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:09:51 2008].265188 msPOSTGISLayerWhichShapes called
[Fri Aug 22 15:09:51 2008].265205 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:09:51 2008].266102 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "nom_com"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE the_geom && setSRID('BOX3D(47650 1620400,1197850 2677450)'::BOX3D, 27582 )
[Fri Aug 22 15:10:06 2008].318610 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:06 2008].318637 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:06 2008].318646 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 15:10:06 2008].325264 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b0ad8)
[Fri Aug 22 15:10:06 2008].325297 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b0ad8)
[Fri Aug 22 15:10:06 2008].326203 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:06 2008].326223 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:10:06 2008].382283 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:06 2008].382314 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:06 2008].382328 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:10:06 2008].382338 msPOSTGISLayerWhichShapes called
[Fri Aug 22 15:10:06 2008].382353 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:10:06 2008].383257 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "nom_com"::text,"section"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE the_geom && setSRID('BOX3D(47650 1620400,1197850 2677450)'::BOX3D, 27582 )
[Fri Aug 22 15:10:25 2008].200212 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:25 2008].200240 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:25 2008].200249 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 15:10:25 2008].207464 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:25 2008].207496 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:25 2008].211269 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:25 2008].211294 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:10:25 2008].267233 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:25 2008].267266 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:25 2008].267279 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:10:25 2008].267289 msPOSTGISLayerWhichShapes called
[Fri Aug 22 15:10:25 2008].267304 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:10:25 2008].268214 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "nom_com"::text,"numero"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select * FROM localisant) as foo WHERE the_geom && setSRID('BOX3D(47650 1620400,1197850 2677450)'::BOX3D, 27582 )
[Fri Aug 22 15:10:42 2008].758688 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:42 2008].758715 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:42 2008].758724 msPOSTGISLayerClose -- closing query_result
[Fri Aug 22 15:10:42 2008].765985 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].766018 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].794679 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:42 2008].794707 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:10:42 2008].850623 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].850661 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:42 2008].850676 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:10:42 2008].850687 msPOSTGISLayerGetShape called for record = 676578
[Fri Aug 22 15:10:42 2008].851696 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:10:42 2008].851714 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT "nom_com"::text,"numero"::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from (select * FROM localisant) as foo WHERE gid = 676578
[Fri Aug 22 15:10:42 2008].892426 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:42 2008].892442 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:42 2008].892450 msPOSTGISLayerClose -- query_result is NULL
[Fri Aug 22 15:10:42 2008].892458 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].892472 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].893015 msPOSTGISLayerOpen called datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:42 2008].893031 MSPOSTGISLayerOpen -- shared connection not available.
[Fri Aug 22 15:10:42 2008].949679 msConnPoolRegister(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].949713 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:42 2008].949722 in msPOSTGISLayerGetItems (find column names)
[Fri Aug 22 15:10:42 2008].949737 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:10:42 2008].953782 msPOSTGISLayerInitItemInfo called
[Fri Aug 22 15:10:42 2008].953891 msPOSTGISLayerGetShape called for record = 676578
[Fri Aug 22 15:10:42 2008].954507 msPOSTGISLayerParseData: unique column = gid, srid='27582', geom_column_name = the_geom, table_name=(select * FROM localisant) as foo
[Fri Aug 22 15:10:42 2008].954531 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT "gid"::text,"numero"::text,"feuille"::text,"section"::text,"code_dep"::text,"nom_com"::text,"code_com"::text,"com_abs"::text,"code_arr"::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from (select * FROM localisant) as foo WHERE gid = 676578
[Fri Aug 22 15:10:42 2008].989434 msPOSTGISLayerFreeItemInfo called
[Fri Aug 22 15:10:42 2008].989449 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:42 2008].989459 msPOSTGISLayerClose -- query_result is NULL
[Fri Aug 22 15:10:42 2008].989467 msConnPoolRelease(bdparcellaire_numero,user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].989479 msConnPoolClose(user=postgres password=postgres dbname=bdparcellaire_2007_iso host=172.23.208.134 port=5432,0x82b1818)
[Fri Aug 22 15:10:42 2008].989643 msPOSTGISLayerClose datastatement: the_geom FROM (select * FROM localisant) as foo USING UNIQUE gid USING SRID=27582
[Fri Aug 22 15:10:42 2008].989654 msPOSTGISLayerClose -- layerinfo is NULL
[Fri Aug 22 15:10:42 2008].990122 mapserv total execution time: 68.399s