Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)

2018-09-26 Thread Deon Brewis
Sorry, false alarm. That corruption far predates the 3.26 changes (occurred under 3.24). The tool I was using to test didn't show the errors on the old version of the database but a newer tool shows them. Thanks! - Deon -Original Message- From: sqlite-users On Behalf Of Dan Kennedy

Re: [sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)

2018-09-26 Thread Dan Kennedy
On 09/26/2018 01:14 PM, Deon Brewis wrote: I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's not everywhere and it may be coincidental, but it may also be related to the new change where expression indexes aren't updated if their columns aren't modified. I'm

[sqlite] integrity_check failure on 3.26 with expression indexes (wrong # of entries)

2018-09-26 Thread Deon Brewis
I am receiving an integrity check failure on 3.26 on the 9/19/2018 drop. It's not everywhere and it may be coincidental, but it may also be related to the new change where expression indexes aren't updated if their columns aren't modified. I'm getting these integrity check failures: wrong #