| Ticket Hash: | 1d2a8efc6c3a595af339395cdc016aa0a1531880 | |||
| Title: | VACUUM on table with generated column that uses TYPEOF results in an error | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Minor | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-10-31 13:16:40 | |||
| Version Found In: | 3.30.0 | |||
| User Comments: | ||||
mrigger added on 2019-10-31 09:42:58:
(text/x-fossil-wiki)
Consider the following test case: <pre> CREATE TABLE t0(c0 AS(TYPEOF(c1)), c1); INSERT INTO t0(c1) VALUES(0); VACUUM; -- table vacuum_db.t0 has 1 columns but 2 values were supplied </pre> Unexpectedly, the VACUUM results in an error. | ||||