Opened 13 months ago

Closed 13 months ago

Last modified 13 months 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 Changed 13 months ago by Even Rouault

Resolution: fixed
Status: newclosed

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 Changed 13 months ago by Even Rouault

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 Changed 13 months ago by Even Rouault

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 Changed 13 months ago by Even Rouault

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 Changed 13 months ago by Even Rouault

In 35904:

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

comment:6 Changed 13 months ago by Even Rouault

In 35905:

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

comment:7 Changed 13 months ago by Even Rouault

In 35906:

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

Note: See TracTickets for help on using tickets.