SQLite

View Ticket
Login
Ticket Hash: 6484e6ce678fffab6371cddc2e7e530ac4d8fd72
Title: VACUUM on table with generated column results in an error
Status: Fixed Type: Code_Defect
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-10-29 16:19:00
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-29 09:24:24:

Consider the following test case:

CREATE TABLE t0(c0 AS(1), c1);
PRAGMA legacy_file_format = true;
CREATE INDEX i0 ON t0(0 DESC);
VACUUM; -- table vacuum_db.t0 has 1 columns but 2 values were supplied

Unexpectedly, the VACUUM statement results in an error. This issue seems to be closely related to [166347c6fc].