SQLite Forum

Possible bug: pragma table_info(A) does not work, but equivalent select does in preupdate hook
Login
I should add that the failure occurs on the first insert command _after_ the last create table statement.

I retested it and the problem remains the same: works with select, fails with pragma.

Putting a breakpoint in the code on where the result code returns (`SQLITE_DONE` where `SQLITE_ROW` is expected), and opening the file with sqlite3 shell, pragma table_info(people); works as expected.

It is as if the route by which "people" is associated with the table data is subtly different depending on whether I use select or pragma.