[gdal-dev] Wrongly identified SQLITE_BLOB as geomtry

[Christian Urich]

Here is a link to a small test database

https://www.dropbox.com/s/vwu4q7ud3e3sv2y/binary_blob.sqlite.zip?dl=0 <https://www.dropbox.com/s/vwu4q7ud3e3sv2y/binary_blob.sqlite.zip?dl=0>

The problem seems to come up when the BLOB is a bit bigger. I couldn’t reproduce it with a smaller dataset.  

For the db I get with ogrinfo GDAL 2.1.0

INFO: Open of `/home/christian/Desktop/binary_blob.sqlite'
      using driver `SQLite' successful.
1: timeseries





> On 24 Oct. 2016, at 7:17 pm, jratike80 <jukka.rahkonen at maanmittauslaitos.fi> wrote:
> 
> Please put a test db somewhere or describe how to create such a database. I
> made a quick test by importing some XML file with spatialite-gui 1.8.0-dev.
> it creates a table as
> 
> CREATE TABLE "xml" (
> "pk_uid" INTEGER PRIMARY KEY AUTOINCREMENT,
> "xml_document" BLOB NOT NULL
> ,"file_name" TEXT NOT NULL
> ,"schema_uri" TEXT
> ,"parse_errors" TEXT
> ,"validate_errors" TEXT);
> 
> Test with ogrinfo of GDAL 2.2.0dev does not list table "xml".
> 
> ogrinfo blob.sqlite
> INFO: Open of `blob.sqlite'
>      using driver `SQLite' successful.
> 1: layer_1 (Point)
> 
> -Jukka Rahkonen-
> 
> 
> 
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-Wrongly-identified-SQLITE-BLOB-as-geomtry-tp5292220p5292228.html
> Sent from the GDAL - Dev mailing list archive at Nabble.com.
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20161024/758e03c8/attachment.html>