ast-project/part1/results/2/bug_265f4a93-dfdd-4cc0-b20b-58042335fded_logic.md

Summary

**No review yet**

Minimized query

ATTACH DATABASE ':memory:' AS aux57;
.import corrupt001.db main
BEGIN DEFERRED TRANSACTION;
CREATE TABLE t0(c0);
INSERT INTO t0(c0) VALUES (NULL);
CREATE INDEX i0 ON t0(-(-(json_extract(1, '$.key')))) WHERE c0 NOT NULL;
SELECT 1 FROM t0 WHERE (t0.c0 IS FALSE) IS FALSE;
SELECT 1 FROM t0 WHERE (t0.c0 IS FALSE) BETWEEN FALSE AND TRUE;

UPDATE t0 SET c0 = 'x' WHERE c0 BETWEEN 0 AND 100 RETURNING *;
ANALYZE t0;
SELECT * FROM t0 WHERE c0 IN (SELECT c0 FROM t0 ORDER BY c0 LIMIT 1 OFFSET 1000);
END;
ANALYZE;

SELECT * FROM t0 AS a INNER JOIN t0 AS b ON a.rowid = b.rowid;
SELECT * FROM t0;
CREATE TEMP  VIEW IF NOT EXISTS v_t0_2416 AS SELECT c0 FROM t0;

SELECT COUNT(*) FROM t0;
DETACH DATABASE aux57;
VACUUM main;

Actual output

1
|

1

Expectation

1
1
|

1

Flag