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

Andre Vautour andre.vautour at caris.com
Mon Feb 29 05:33:28 PST 2016


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.

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é


More information about the gdal-dev mailing list