Cannot open a sqlite database that has been created using WAL mode

[sbroberg]

Hi. Thanks in advance for the nice tool. I'm using it with sqlite, but find I cannot open a sqlite file in wal mode (see the attached T07_endToEnd_NestedDirectories.db file with associated -wal and -shm files). The same schema, when exported and re-imported to a new db is able to be read (attached file newdb.sqlite).

The error I'm getting (running on OSX, 10.12) upon trying to open T07_endToEnd_NestedDirectories.db is:

[connecting...] Connection Error : (error "\"Can't call method \\\"fetchall_arrayref\\\" on unblessed reference at /Users/stebro/.emacs.d/elpa/edbi-20160224.1741/edbi-bridge.pl line 135. \"") Check your setting...

Archive.zip

[sbroberg]

New information: The file above (T07_endToEnd_NestedDirectories) is readable by edbi if the -shm file is removed from the directory. Also, copying the 3 files to a new name (with only a slight change, like T08_endToEnd_NestedDirectories) causes the file to be readable as well.

[kiwanami]

Hi @sbroberg Thank you for your report. I confirmed the problem too. I'll check the problem. It seems that the interface of sqlite was changed or some pragma is needed.