ast-project/part1/results/2/bug_3ac8f1e8-ebe4-46ea-8232-0f6ee554e205_logic.md

Summary

**No review yet**

Minimized query

BEGIN EXCLUSIVE TRANSACTION;
.system false && echo "success" || echo "error code: $?"
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (unixepoch(likelihood(1, 0.0625)), '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
SAVEPOINT sp6237;
CREATE TABLE T (
  A VARCHAR(concat_ws('', 'a', 'b', 'c')) PRIMARY KEY,
  B VARCHAR(if(0,30,0,30,0,30,0,30,0,30,0,30,30)) NOT NULL,
  C BIGINT UNIQUE
);
INSERT INTO T VALUES ('a', 'x', -9223372036854775808);
INSERT INTO T VALUES ('b', 'y', -1000000);
INSERT INTO T VALUES ('c', 'y', 0);
INSERT INTO T VALUES ('d', 'y', 42);
INSERT INTO T VALUES ('e', 'x', 9223372036854775807);
INSERT INTO T VALUES ('f', 'z', 2147483648);
SELECT * FROM T WHERE C > 0 ORDER BY C DESC;
BEGIN EXCLUSIVE TRANSACTION;
.timer off
.schema
PRAGMA foreign_keys = -CAST(-1 AS BIGINT);
PRAGMA threads;
PRAGMA foreign_keys = ON;
.timeout -1
CREATE TABLE t0 (c0, c1 NOT NULL DEFAULT 1, c2, PRIMARY KEY (c0, c1));
INSERT INTO t0(c2) VALUES (NULL), (NULL);
INSERT INTO t0(c2) VALUES('a');
SELECT DISTINCT * FROM t0 WHERE NULL IS t0.c0;
SELECT * FROM t0 WHERE (( (0 IS NOT FALSE) OR NOT (0 IS FALSE OR (t0.c0 = 1)) ) IS 0);
SELECT ((0 IS NOT FALSE) OR NOT (0 IS FALSE OR (t0.c0 = 1)) ) IS 0 FROM t0;
SELECT ( (0 IS NOT FALSE) OR NOT (0 IS 0 OR (t0.c0 = 1)) ) IS 0 FROM t0;
SELECT ((0 IS NOT FALSE) OR NOT (0 IS FALSE OR (t0.c0 = 1)) ) FROM t0;
SELECT NOT (0 IS FALSE OR (t0.c0 = 1)) FROM t0;


SELECT * FROM (SELECT * FROM t0) AS sub;
REINDEX;
CREATE  INDEX IF NOT EXISTS idx_t0_6740 ON t0(c2 COLLATE NOCASE) WHERE c2 IS NOT NULL;
SELECT * FROM t0 WHERE c1 = (SELECT c1 FROM t0 t2 WHERE t2.c1 = t0.c1 LIMIT 1);
CREATE TRIGGER IF NOT EXISTS trg_t0_2041 BEFORE INSERT ON t0 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<37), filtered AS (SELECT * FROM cnt WHERE x > 18) SELECT * FROM filtered;

CREATE TRIGGER IF NOT EXISTS trg_t0_1600 BEFORE INSERT ON t0 FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'abort'); END;
INSERT OR FAIL INTO t0 VALUES (0, 0, '');
ROLLBACK;
UPDATE t0 SET c1 = json_object('k', c1);
SELECT * FROM t0;
ROLLBACK TRANSACTION TO SAVEPOINT sp6237;
RELEASE SAVEPOINT sp6237;
INSERT OR ABORT INTO t0 VALUES ('', NULL, NULL);
WITH RECURSIVE multi(a, b) AS (VALUES(1, "x") UNION ALL SELECT a+1, "x" FROM multi WHERE a<2) SELECT * FROM multi;
END;
CREATE  VIEW IF NOT EXISTS v_t0_7574 AS SELECT c1 FROM t0;
ANALYZE;
PRAGMA writable_schema = YES;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<5) SELECT SUM(x) FROM cnt;

Actual output

error code: 1
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|-210866673600
von|20|2
Braun|30
Wernher|10
von|20

Expectation

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

Flag