https://www.sqlite.org/pragma.html has: "No error messages are generated if an unknown pragma is issued. Unknown pragmas are simply ignored. This means if there is a typo in a pragma statement the library does not inform the user of the fact."
I just lost some time due to this, even though I was fully aware of it. My code wasn't working, so I instrumented to report errors, and gradually dug things deeper and deeper. It wasn't until I was verifying statements line-by-line against sqlite3 in a terminal window that I saw that I was setting journal_mod rather than journal_mode! I realize that pragma don't have the compatibility guarantees that other syntax has. But that means I actually _would_ want my code to start barfing if a PRAGMA stops being supported. Say I'm issuing "PRAGMA secure_delete=ON" - presumably it's for a reason, and I'm going to want to revisit that reason if it's no longer supported. One could perhaps fake pedantic pragma with SQLITE_FCNTL_PRAGMA in a custom VFS, but that seems a little excessive for something like this. Something like "PRAGMA pedantic_pragma = on" would be much slicker. OK, back to the mines, scott _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
