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 <[email protected]> 
> 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
> [email protected]
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to