ast-project/part1/results/2/bug_0791ea7d-2338-4596-b245-a3cc5dd0e9bf_logic.md

Summary

**No review yet**

Minimized query

.tables non_existent_table
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (1, 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);

CREATE INDEX t1bc ON t1(b, c);

PRAGMA writable_schema == ON;

.imposter t1bc t2

SELECT * FROM t2;

SELECT b, c FROM t1 ORDER BY b, c;

.quit
INSERT INTO t1 VALUES (NULL, 'x', 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
UPDATE t1 SET c = '' WHERE c IS NOT NULL RETURNING *;

SELECT COUNT(*) FROM t1;
SELECT c, COUNT(*) FROM t1 GROUP BY c HAVING COUNT(*) > (SELECT COUNT(*) FROM t1 LIMIT 1);

Actual output

CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
WARNING: writing to an imposter table will corrupt the "t1bc" index!
Braun    30  3      
Wernher  10  1      
von      20  2      
Braun    30
Wernher  10
von      20

Expectation

CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
Braun    30  3      
Wernher  10  1      
von      20  2      
Braun    30
Wernher  10
von      20

Flag

-column