SQLite 3.39

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