On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos <[email protected]> wrote:
>
> Changing the journal_mode does not solve my issue :(
>
A self contained test case:
$ LD_LIBRARY_PATH= ./sqlite3 /tmp/broken2.sqlite
SQLite version 3.8.4.3 2014-04-03 16:53:12
Enter ".help" for usage hints.
sqlite> PRAGMA page_size=65536;
sqlite> PRAGMA legacy_file_format=ON;
sqlite> PRAGMA synchronous = OFF;
sqlite> PRAGMA journal_mode=DELETE;
delete
sqlite> CREATE TABLE IF NOT EXISTS mytable (
...> my_id INTEGER PRIMARY KEY,
...> my_name TEXT,
...> CONSTRAINT part_name_idx UNIQUE (my_name));
sqlite>
$ LD_LIBRARY_PATH= sqlite3 /tmp/broken2.sqlite
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
Error: file is encrypted or is not a database
And here it is the gziped+base64ed broken2.sqlite file:
http://pastebin.com/Tk6Nvxv7
Thank you,
--
Alejandro Santos
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
