ast-project/part1/results/1/bug_f81b9934-ccfd-4574-b4f5-d7484ee25a41_logic.md

Summary

**No review yet**

Minimized query

.once log.txt
PRAGMA automatic_index = OFF;
-- PRAGMA parser_trace = ON;

-- concat({v}, {v}, {v})

.save output.db
ATTACH DATABASE '' || (':memory:') AS aux86;
ATTACH DATABASE ':memory:' AS aux18;
SAVEPOINT sp5997;
.bail off
ATTACH DATABASE ':memory:' AS aux0;
.dump
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
-- inf

DROP TABLE t0;
DETACH DATABASE aux0;
ROLLBACK TO sp5997;
RELEASE sp5997;
DETACH DATABASE aux18;
PRAGMA legacy_alter_table = TRUE;
DETACH DATABASE aux86;
CREATE TABLE T (
  a TEXT,
  b REAL
);
INSERT INTO T VALUES ('a',likelihood(NULL, 0.5)), ('b',-200.5), ('c',9e999);
SELECT a,b,
LEAD(b,1) OVER (ORDER BY b DESC) AS c,
NTILE(2) OVER (ORDER BY b DESC) AS d FROM T;
CREATE  INDEX IF NOT EXISTS idx_T_1192 ON T(a) WHERE a > 0;
SELECT * FROM T WHERE b NOT IN (SELECT b FROM T);
SELECT GROUP_CONCAT(a) FROM T;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_6996 ON T(lower(a));
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
ALTER TABLE T RENAME COLUMN b TO b_r990;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_1324 ON T(lower(a)) WHERE a > 0;
DROP TRIGGER IF EXISTS T;
SELECT GROUP_CONCAT(a) OVER (PARTITION BY a ORDER BY a RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM T;
INSERT INTO t1 VALUES (NULL, NULL, 1, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
INSERT INTO T SELECT * FROM T;
INSERT INTO T SELECT * FROM T;
WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte;
SELECT LAG(a, 0) OVER (ORDER BY a) FROM T;
ALTER TABLE t1 ADD COLUMN extra_2589 INT8;
INSERT INTO t1 SELECT * FROM t1;
CREATE TABLE T (
  a INTEGER,
  b REAL
);
INSERT INTO T VALUES (1,1.5), (2,-7.25), (3,0.0);
SELECT a,b FROM T WHERE a >= 2 ORDER BY b;
ALTER TABLE T DROP COLUMN b;

Actual output

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
c|Inf|-200.5|1
b|-200.5||1
a|||2
a,b,c
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

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
c|Inf|-200.5|1
b|-200.5||1
a|||2
a,b,c
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