Re: [sqlite] Table has different rootpage in EXPLAIN and sqlite_master
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 http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Table has different rootpage in EXPLAIN and sqlite_master
Hi David, The two queries were as follows explain select vCol,* from Race,Meta.vCols; and select * from meta.sqlite_master where type='table'; Sorry, I don’t have a copy of the unvacuumed db. From: sqlite-users on behalf of David Raymond Sent: Monday, 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? Was there another index or table whose root page is what was listed in the explain output? For example, were you expecting it to use 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 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? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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? Was there another index or table whose root page is what was listed in the explain output? For example, were you expecting it to use 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 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? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Table has different rootpage in EXPLAIN and sqlite_master
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? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users