SQLite

View Ticket
Login
Ticket Hash: 166347c6fc994155e23fd1a1899d3b19bcefb5d1
Title: VACUUM issue on table with generated column
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-10-29 03:39:31
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-10-28 21:48:22:

Consider the following test case:

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

Unexpectedly, the VACUUM results in an error.