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é
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to