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