Hi,

I'm working on a C# SQLite wrapper and have created some unit tests. One of
them checks the behavior when changing the permanent journal mode of a
database (from DELETE to WAL and the other way around) while the database
is in read-only mode. Here's what I do basically:

1. Open new database in read-write mode.
2. Set "source" journal mode (WAL or DELETE)
3. Close connection
4. Open connection to this database in read-only mode
5. Try to change to the "destination" journal mode (again WAL or DELETE).
Except this to return SQLITE_READONLY.

Now, on Windows "sqlite3_step()" returns "SQLITE_READONLY" in both
directions but on Linux (or on Android, to be more precise) I get
"SQLITE_READONLY" when changing from DELETE to WAL but I get "SQLITE_IOERR"
("disk I/O error") when changing from WAL to DELETE.

I'm using SQLite 3.7.14.

Is this a bug?

Best regards
Sebastian
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to