By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Fooey(SomeInteger INTEGER PRIMARY KEY) STRICT;
✓
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
✓
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
✓
select * from fooey;
| SomeInteger |
|---|
| 1 |
| 2 |
INSERT INTO Fooey(SomeInteger) VALUES (33);
✓
INSERT INTO Fooey(SomeInteger) VALUES (44);
✓
INSERT INTO Fooey(SomeInteger) VALUES (33);
{ "code": "SQLITE_CONSTRAINT_PRIMARYKEY" }
select * from fooey;
| SomeInteger |
|---|
| 1 |
| 2 |
| 33 |
| 44 |