Re: [sqlite] Bug: Table contains two records for the same primary key in .dump output but not in SELECT output

, typeof(id) FROM test; > id typeof(id) > > 12345 text > 12345 integer > sqlite> SELECT id, typeof(id) FROM test WHERE id = '12345'; > id typeof(id) > > 12345 text > > On Sat, Dec 21, 2019 at 1:26 PM Michael Walker (barrucadu) < > m...@barrucadu.co.uk> wro

[sqlite] Bug: Table contains two records for the same primary key in .dump output but not in SELECT output

Hi, I've somehow ended up with a table which contains two records for the same primary key - well actually I've got two primary keys like that, so I have four records with two primary keys between them. I've been unable to reproduce this from a clean database, so I attach my database file to