SQLite Forum


(1.1) By Matt Thomas (thomat65) on 2021-03-12 19:06:15 edited from 1.0 [source]


(2) By Richard Hipp (drh) on 2021-03-12 18:33:05 in reply to 1.0 [link] [source]

Why is that wrong? There is no "temp.table" table, and so the pragma returns no results, as it is documented to do. What should it have done?

(3) By Matt Thomas (thomat65) on 2021-03-12 18:48:30 in reply to 2 [link] [source]

Something must be wrong with my eyes. I read the sentence "In the documentation below, pragmas for which the schema name is meaningful are shown with a 'schema.' prefix" several times and each time I thought it said meaningless.

...until I went to copy and paste that sentence again to (in my mind graciously) point out how un-meaningless it is in my example queries.

Ha! Please accept my apologies!