On 11 Jul 2019, at 3:21pm, Richard Hipp <d...@sqlite.org> wrote: > EVERYONE: If you have personally experienced some unusual or > unexpected feature of SQLite that you think should be added to > "quirks.html", please follow-up to this thread, or send me private > email, so that I can consider adding it.
A) (perhaps add to the BOOLEAN) SQLite has no UNSIGNED affinity. The Quirks document so far is all about SQLite's interpretation of SQL, but I am thinking about other things which might belong in it. B) SQLite doesn't open a database when you call _open() . And it doesn't return an error message if you try to open a non-existent database in read-only mode. C) SQLite doesn't close a database when you call _close(). And if there's a pending statement which would precent closure, it won't return an error code. D) SQLite (may ?) require read/write access to a database's folder even if you open the database in read-only mode. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users