SQLite Forum

sqlite_master -> sqlite_schema rename breaks DB dump compatibility
Login
In git commit 067b92ba0088 ("Extend the refactoring into extensions.  Clean up stray newlines.", 2020-06-19), which was first released as part of "version-3.33.0", the DUMP command ("ext/misc/dbdump.c", function dump_callback()) was modified as follows: it would now generate an "ANALYZE sqlite_schema" command, rather than the "ANALYZE sqlite_master" command.

As a consequence, importing -- executing -- such dumps against earlier sqlite3 releases now fails, because those versions do not know about "sqlite_schema", only "sqlite_master".

As a further consequence, the "sqlite_stat1" table is also not created -- it would normally be created by this particular ANALYZE command --, and so the subsequent "INSERT INTO sqlite_stat1" commands in the dump also fail.