Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#6695 closed defect (fixed)

SQLite: non geometry column of type BLOB reported as geometry

Reported by: Even Rouault Owned by: Even Rouault
Priority: normal Milestone:
Component: OGR_SF Version: unspecified
Severity: normal Keywords: sqlite
Cc:

Description

When opening a sqlite/spatialite DB, some columns of type BLOB are sometimes misrecognized as being geometry columns. This happen when that BLOB column is before the geometry column(s) in the CREATE TABLE statement

Reported in ​https://lists.osgeo.org/pipermail/gdal-dev/2016-October/045351.html

Change History (7)

comment:1 by Even Rouault, 7 years ago

Resolution: → fixed
Status: new → closed

In 35898:

Spatialite: do not report some BLOB columns as geometry columns of tables/views (when found before the geometry column(s)) (fixes #6695, fixes #6659)

comment:2 by Even Rouault, 7 years ago

In 35899:

Spatialite: do not report some BLOB columns as geometry columns of tables/views (when found before the geometry column(s)) (fixes #6695, fixes #6659)

comment:3 by Even Rouault, 7 years ago

In 35900:

Spatialite: do not report some BLOB columns as geometry columns of tables/views (when found before the geometry column(s)) (fixes #6695, fixes #6659)

comment:4 by Even Rouault, 7 years ago

In 35901:

Spatialite: do not report some BLOB columns as geometry columns of tables/views (when found before the geometry column(s)) (fixes #6695, fixes #6659)

comment:5 by Even Rouault, 7 years ago

In 35904:

Spatialite: fix previous commit that broke VirtualShape (refs #6695, refs #6659)

comment:6 by Even Rouault, 7 years ago

In 35905:

Spatialite: fix previous commit that broke VirtualShape (refs #6695, refs #6659)

comment:7 by Even Rouault, 7 years ago

In 35906:

Spatialite: fix previous commit that broke VirtualShape (refs #6695, refs #6659)

Note: See TracTickets for help on using tickets.