SQLite Forum

alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL
Login
Why does it work on MacOS then? As well how can I add required column then? I prefer to have an error that field value is missing, then have an error, that NOT NULL, the default value cannot be NULL lol. That's kind of obvious, why even try to add a default value for the field. Why it doesn't do that when a new table is created, why do it only on ALTER?