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 |
---|---|---|---|
Priority: | normal | Milestone: | 2.0.1 |
Component: | OGR_SF | Version: | unspecified |
Severity: | normal | Keywords: | sqlite |
Cc: |
Description
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
Milestone: | → 2.0.1 |
---|---|
Resolution: | → fixed |
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)"