SQLite Forum

Possible bug: pragma table_info(A) does not work, but equivalent select does in preupdate hook
Are you using transactions in any way? Either explicitly, with `BEGIN` statements in your scripts, or perhaps created "automatically" by whatever layer your script uses to talk to SQLite? (I believe some Python wrappers are notorious for creating "unexpected" transactions).  Not sure whether that would explain the difference between `PRAGMA tableinfo` and the `SELECT * FROM pragma_table_info`, but might be helpful in tracking down what's happening.