News for hackers. Stuff that matters.

A comment on SQLite Release 3.37.0. Parent comment

Re:SQLite Release 3.37.0 by ComputerGuru on Saturday November 27, 2021 @04:28PM (#29363736)
The existing check syntax would cover inserts but wouldn’t have supported the behavior of the new “any” type in a strict table.

What would be nice is if SQLite had separate “compatible with” and “read-only compatible with” fields, since the read-only behavior should not have changed at all (although I suppose describing the table would fail depending on how the presence of the STRICT modifier is codified).

[ Parent | on HN ]
Re:SQLite Release 3.37.0 by cryptonector on Saturday November 27, 2021 @05:10PM (#29364065)
What they could have done is translated a STRICT table w/o ANY-typed columns to an older CREATE TABLE with CHECK()s. But anyways.
[ Parent | on HN ]