Re: [sqlite] UNIQUE INDEX behaves differently depending on the order rows are inserted

2016-11-03 Thread Ben Hearsum
On Wed, Nov 02, 2016 at 11:30:37PM -0400, Richard Hipp wrote: > On 11/2/16, Ben Hearsum wrote: > > I've also had a couple of kernel panics lately, and I imagine that could > > either directly cause issues, or cause issues the next time Firefox starts > > (and tries t

Re: [sqlite] UNIQUE INDEX behaves differently depending on the order rows are inserted

2016-11-02 Thread Ben Hearsum
lying to me (maybe due to the corruption?), there are no duplicate guids in moz_places. 2016-11-02 17:27 GMT-04:00 Richard Hipp : > On 11/2/16, Ben Hearsum wrote: > > > > I then did some inserts, and discovered that the order in which the rows > are > > inserted appears t

[sqlite] UNIQUE INDEX behaves differently depending on the order rows are inserted

2016-11-02 Thread Ben Hearsum
Hi there, I recently had an issue with an index in a large-ish (>100,000 rows) table becoming corrupted. I tried to issue a REINDEX on it, but it complained of duplicated values. I dug into that a bit, and couldn't find any duplicate entries: sqlite> select count(*) from moz_places; 100575 sqli