Opened 9 years ago

Closed 9 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 Even Rouault, 9 years ago

Milestone: → 2.0.1
Resolution: → fixed
Status: new → closed

trunk r29620, branches/2.0 r29621 "SQLite: fix heuristics in OGRSQLiteSelectLayer::GetExtent() to not be used when there's a sub SELECT (#6062)"

Note: See TracTickets for help on using tickets.