Opened 8 years ago
Closed 8 years ago
#6062 closed defect (fixed)
Too permissive heuristics in OGRSQLiteSelectLayerCommonBehaviour::GetExtent()
|Reported by:||Even Rouault||Owned by:||Even Rouault|
ogrinfopoints.csv -sql "select way_id, makeline(pt) from (select way_id, makepoint(cast(x as float),cast(y as float)) pt from points order by way_id, pt_id) t group by way_id" -dialect sqlite
gives the following error
INFO: Open of `points.csv' using driver `CSV' successful. Layer name: SELECT Geometry: Unknown (any) Feature Count: 2 ERROR 1: In ExecuteSQL(): sqlite3_prepare(select way_id, makeline(pt) from (select way_id, makepoint(cast(x as float),cast(y as float)) pt from points): near "points": syntax error Extent: (-3.000000, 49.000000) - (3.000000, 50.000000) Layer SRS WKT: (unknown) Geometry Column = makeline(pt) way_id: String (0.0) OGRFeature(SELECT):0 way_id (String) = 1 LINESTRING (2 49,3 50) OGRFeature(SELECT):1 way_id (String) = 2 LINESTRING (-2 49,-3 50)
The result is correct but the error emission is annoying
Change History (1)
comment:1 by , 8 years ago
|Status:||new → closed|
Note: See TracTickets for help on using tickets.
trunk r29620, branches/2.0 r29621 "SQLite: fix heuristics in OGRSQLiteSelectLayer::GetExtent() to not be used when there's a sub SELECT (#6062)"