[gdal-dev] Feature ID propagation in SQLite data source

[Even Rouault]

Le lundi 29 février 2016 14:33:28, Andre Vautour a écrit :
> Hi all,
> 
> When I execute an SQL query on a SQLite source, I am observing that the
> feature identifiers are changing. This was observed using 1.11.1.

See https://trac.osgeo.org/gdal/ticket/5781

> 
> ogrinfo -geom=NO -fid 1227 test2.sqlite
> OGRFeature(roads):1227
>    gml_id (String) = Roads.371c00000011070000000046
>    arc_flag (String) = T
>    line_compilation_status (String) = BACKGROUND
>    contour_height (Real) = (null)
>    line_description (String) = (null)
>    line_feature_code (String) = RRARDUR
>    line_key (String) = RD6091
>    length (Real) = 253.400783404
>    num_points (Real) = 42
>    line_source_id (String) = USL
>    line_theme_number (Real) = 20100
>    line_user_number (Real) = 20100
> 
> ogrinfo -geom=NO -sql "select * from roads where length = 253.400783404"
> -dialect sqlite test2.sqlite
> OGRFeature(SELECT):0
>    gml_id (String) = Roads.371c00000011070000000046
>    arc_flag (String) = T
>    line_compilation_status (String) = BACKGROUND
>    contour_height (Real) = (null)
>    line_description (String) = (null)
>    line_feature_code (String) = RRARDUR
>    line_key (String) = RD6091
>    length (Real) = 253.400783404
>    num_points (Real) = 42
>    line_source_id (String) = USL
>    line_theme_number (Real) = 20100
>    line_user_number (Real) = 20100
> 
> Shouldn't the ID of the feature remain unchanged instead of going from
> the original 1227 to 0?
> 
> Thanks,
> André
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

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