ast-project/part1/results/1/bug_3f4482db-572a-43e4-bb1b-0f6539847ed0_unexpected_error.md

Summary

**No review yet**

Minimized query

ATTACH DATABASE ':memory:' AS aux83;
PRAGMA short_column_names = OFF;
SAVEPOINT sp7579;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES ((-(-(jsonb_array(2147483646))) + 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
ALTER TABLE t1 RENAME COLUMN d TO d_r9880;
ROLLBACK TO sp7579;
RELEASE sp7579;
INSERT AND ABORT INTO t1 VALUES /**/ ('', '', 'x', 0);
INSERT INTO t1 SELECT * FROM t1;
PRAGMA short_column_names = OFF;
SAVEPOINT sp7579;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES ((0 + 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
ALTER TABLE t1 RENAME COLUMN d TO d_r9880;
ROLLBACK TO sp7579;
RELEASE sp7579;
INSERT AND ABORT INTO t1 VALUES /**/ ('', '', 'x', 0);
INSERT INTO t1 SELECT * FROM t1;
PRAGMA short_column_names = OFF;
SAVEPOINT sp7579;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES ((0 + 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
ALTER TABLE t1 RENAME COLUMN d TO d_r9880;
ROLLBACK TO sp7579;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0);
SELECT * FROM T WHERE c < 2.0 ORDER BY c;
RELEASE sp7579;
INSERT AND ABORT INTO t1 VALUES /**/ ('', '', 'x', 0);
INSERT INTO t1 SELECT * FROM t1;
PRAGMA short_column_names = OFF;
SAVEPOINT sp7579;
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES ((0 + 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
ALTER TABLE t1 RENAME COLUMN d TO d_r9880;
ROLLBACK TO sp7579;
RELEASE sp7579;
INSERT AND ABORT INTO t1 VALUES /**/ ('', '', 'x', 0);
INSERT INTO t1 SELECT * FROM t1;
DETACH DATABASE aux83;
UPDATE t1 SET a = CURRENT_TIMESTAMP WHERE a IS NOT NULL;
REINDEX T;

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
von|20|2
Braun|30
von|20

Expectation

Flag