sqlite> create table foo (pk integer primary key not null, bar text);
sqlite> insert into foo values (10,'ten');
sqlite> insert into foo values (20,'twenty');
sqlite> select rowid, pk, bar from foo;
10|10|ten
20|20|twenty
sqlite> insert into foo values ('thirty','thirty');
Error: datatype mismatch
sqlite> insert into foo values (30,30);
sqlite> select rowid, pk, bar from foo;
10|10|ten
20|20|twenty
30|30|30