ast-project/part1/results/3/bug_c33cdafe-61c3-44a0-b87c-693c487bfaae_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
-- like('%{v}', {v})

INSERT INTO t1 VALUES (1, 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c INTEGER
);
INSERT INTO T VALUES (1,'a',NULL), (2,'b',1), (3,'c',2);
WITH RECURSIVE d(a,b,c,e) AS (
  SELECT *,1 FROM T WHERE c IS NULL
  UNION ALL
  SELECT T.a,T.b,T.c,d.e+1
  FROM T JOIN d ON T.c=d.a
)
SELECT * FROM d;
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
ATTACH DATABASE (':memory:' || '') AS aux99;
PRAGMA foreign_key_check;
.output blablabla.whatever
BEGIN DEFERRED;
CREATE TABLE [T] (
  a SMALLINT,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (length(randomblob(CAST(10 AS UNSIGNED BIG INT))),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
SELECT * FROM T NATURAL JOIN T;
INSERT INTO T SELECT * FROM T;
SELECT * FROM T;
PRAGMA case_sensitive_like = ON;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_T_8230 AS SELECT a FROM T;
DROP /* json_remove({v}) */ INDEX IF EXISTS T;
SELECT * FROM T WHERE NOT NOT (NOT NOT (EXISTS (SELECT 1 FROM T WHERE 1 = 0))) ;
INSERT INTO T DEFAULT VALUES;
ALTER TABLE T RENAME TO T_r7824;
ROLLBACK;
VACUUM main;
PRAGMA cache_spill = 0;
DETACH DATABASE aux99;
ANALYZE t1;
UPDATE t1 SET a = 'x' WHERE a IS NOT NULL;
CREATE TEMP  VIEW IF NOT EXISTS v_t1_4811 AS SELECT d FROM t1;
SELECT * FROM t1 WHERE b IN (SELECT b FROM t1 WHERE b IS NOT NULL);
DROP INDEX IF EXISTS t1; /* concat('a', 'b', 'c') */ SELECT * FROM t1 WHERE d = ANY (SELECT d FROM t1);
ALTER TABLE t1 ADD COLUMN extra_6667 NUMERIC DEFAULT (abs(random()) % 1000);
SELECT * FROM t1;
DELETE FROM T WHERE a > (SELECT AVG(a) FROM T) RETURNING *;

Actual output

1|a||1
2|b|1|2
3|c|2|3
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

1|a||1
2|b|1|2
3|c|2|3
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