Dear list,
When my database opened with sqlite3 command line program, it shows this:
SQLite version 3.26.0 2018-10-29 21:01:28
Enter ".help" for usage hints.
sqlite> .schema
CREATE VIRTUAL TABLE zip USING zipfile('funddata.db')
/* zip(name,mode,mtime,sz,rawdata,data,method) */;
sqlite> select * from zip;
Error: failed to read CDS at offset 119844
When I use python to open this database, it reads correctly.
There are a lot of zip files stored in this "datasave" table, where v is
the zip file.
CREATE TABLE datasave (k TEXT PRIMARY KEY, ver INTEGER, v BLOB)
I look at the database file, there is a half zip file in the end. So
maybe the PK header confused the SQLite command line.
Is this considered a bug?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
