You were correct David. The explain rootpage referred to an index and I was
checking against the table rootpage.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
, February 3, 2020 6:19:31 PM
To: SQLite mailing list
Subject: Re: [sqlite] Table has different rootpage in EXPLAIN and sqlite_master
They shouldn't be different, no. Do you have a copy of the weird version of the
database still, or have a copy of the explain text and the sqlite_master
contents
the table, but
it used a covering index instead?
-Original Message-
From: sqlite-users On Behalf Of x
Sent: Monday, February 3, 2020 1:07 PM
To: Discussion of SQLite Database
Subject: [sqlite] Table has different rootpage in EXPLAIN and sqlite_master
Differing by 1. I noticed
Differing by 1. I noticed this today for 1 table only but not always -
sometimes they were equal. I’ve been unable to reproduce it after a vacuum.
Does this indicate a corrupt db or is it a case of it can happen for some
reason I’ve missed?
___
4 matches
Mail list logo