SQLite Forum

Possible bug: pragma table_info(A) does not work, but equivalent select does in preupdate hook
Login
Some more results - using shorthand. On each INSERT there is a call to `PRAGMA table_info() for that table:

```
CREATE A
CREATE B
CREATE C
INSERT A
INSERT B
INSERT C
```
** all good **

```
CREATE A
INSERT A
CREATE B
CREATE C
INSERT B
INSERT C
```
** INSERT B and INSERT C fail **

```
CREATE A
CREATE B
INSERT A
CREATE C
INSERT B
INSERT C
```
** all good **

```
CREATE B
INSERT B
CREATE A
INSERT A
CREATE C
INSERT C
```
** INSERT A and INSERT C fail **

Basically, if a table is created, then an insert in that table (with call to `PRAGMA table_info`), the second and subsequent calls to `PRAGMA table_info()` fail. But... all these succeed if PRAGMA ... is replaced with `SELECT * FROM pragma_table_info()`.