Re: [sqlite] Another Inconsistency in .lint fkeys-index

On Thursday, 6 April, 2017 08:58, Dan Kennedy wrote: > On 04/06/2017 08:26 PM, Keith Medcalf wrote: > > Note the report first line. Interval is the primary key of both tables > > so there is an internal index. > Thanks for this. Should be fixed here: >

Re: [sqlite] Another Inconsistency in .lint fkeys-index

That fixed the issue I was seeing the first time around, thanks. Still getting some weirdness where it looks like the results are highly dependent on the contents of sqlite_stat1. I've been trying to construct a simplified version to share but am having trouble reproducing it on a smaller

Re: [sqlite] Another Inconsistency in .lint fkeys-index

On 04/06/2017 08:26 PM, Keith Medcalf wrote: Note the report first line. Interval is the primary key of both tables so there is an internal index. Thanks for this. Should be fixed here: http://www.sqlite.org/src/info/48826b222c110a90 Dan. Table Forecast does the same but is not

[sqlite] Another Inconsistency in .lint fkeys-index

Note the report first line. Interval is the primary key of both tables so there is an internal index. Table Forecast does the same but is not reported (because of the extra unique constraints perhaps?) The later two reported missing indexes are correct. sqlite> .lint fkey-indexes CREATE INDEX