SQLite: View Ticket

Ticket Hash:	f00d7b651aa3cc3ee5df12e84b83b4bd96ee4524
Title:	ALTER TABLE corrupts the schema for tables that start with "sqlite"
Status:	Fixed	Type:	Code_Defect
Severity:	Severe	Priority:	Immediate
Subsystem:	Unknown	Resolution:	Fixed
Last Modified:	2019-04-19 18:23:36 6.21 years ago	Created:	2019-04-19 16:26:26 6.21 years ago
Version Found In:	3.28.0

User Comments:

drh added on 2019-04-19 16:26:26:

The following sequence of SQL statements results in an sqlite_master table that has one name for the table in the "name" column but a different name in the "sql" column:

CREATE TABLE "sqlite1234" ("id" integer);
ALTER TABLE "sqlite1234" RENAME TO "User";
SELECT name, sql FROM sqlite_master WHERE sql IS NOT NULL;

This issue was reported on the mailing list by Semih Hazar. The problem appears to have originated in SQLite version 3.25.0.