[mapserver-users] DATA "table" does not find FID for WFS

[Even Rouault]

Le mercredi 28 octobre 2015 08:10:44, Rahkonen Jukka (MML) a écrit :
> Hi,
> 
> I have noticed with Mapserver 7.0 that WFS server does not find the
> "gml_featureid" column if I define DATA this way:
> 
> CONNECTIONTYPE OGR
> CONNECTION "\ms4w\apps\wms-wfs.sqlite"
> DATA "states"
> 
> This gives a warning into GML sent by GetFeature
> <!-- WARNING: FeatureId item 'PK_UID' not found in typename 'states_table'.
> -->
> and featureMembers are without fid
> <gml:featureMember>
> <ms:states_table>
> 
> This leads to correct result:
> 
> CONNECTIONTYPE OGR
> CONNECTION "\ms4w\apps\wms-wfs.sqlite"
> DATA "select * from states"
> 
> <gml:featureMember>
> <ms:states_table fid="states_table.1">
> 
> Documentation http://www.mapserver.org/input/vector/ogr.html does not warn
> that defining data as "layer_name" vs. "select * from layer" could make a
> difference. Ogrinfo finds the FID column and reports it as: FID Column =
> PK_UID
> 
> PK_UID is defined in the table as
> CREATE TABLE states (
> PK_UID INTEGER PRIMARY KEY AUTOINCREMENT,
> 
> 
> This looks like a bug but I am not sure if it is a Mapserver bug of GDAL
> bug and if it affects only Spatialite.

You didn't specify which GDAL version is used.

That could possibly be the following bug that was fixed in 1.11.2 and 2.0:
 * make GetFIDColumn() work when run as first method call (#5781)


> 
> -Jukka Rahkonen-

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com