ast-project/part1/results/3/bug_bf13c622-8dc0-4e6d-b695-cd0a8ac0a267_unexpected_error.md

Summary

**No review yet**

Minimized query

.show
.timeout -'[1,2,3]'
PRAGMA journal_mode = 'WAL';
CREATE TABLE t1(a,b INT);
INSERT INTO t1(a,b) VALUES(datetime(((length('') + 0) + 1), '+1 day'),2),(3,3),(4,5);
CREATE UNIQUE INDEX i1 ON t1(b,b,a,a,a,a,a,b,a);
ANALYZE;
DROP TABLE IF EXISTS sqlite_stat4;
INSERT INTO sqlite_stat1 VALUES('t1','i1','30 30 30 2 2 2 2 2 2 2');
ANALYZE sqlite_master;

CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_650 ON t1(a COLLATE NOCASE);
CREATE TABLE T (
  a INTEGER,
  b REAL
);
INSERT INTO T VALUES (1,1.5), (2,-2.5), (3,0.0);
CREATE INDEX c
ON T(b);
SELECT * FROM T WHERE +b != -2.5 OR b < 2.0;
VACUUM main;
PRAGMA wal_checkpoint('RESTART');
INSERT INTO t1 VALUES (NULL, NULL);

SELECT COUNT(*) FROM t1;
SELECT a, COUNT(*) FROM t1 GROUP BY a HAVING a IN (SELECT a FROM t1);
DELETE FROM T WHERE rowid = 62;
UPDATE T SET b = CURRENT_TIMESTAMP WHERE b IS NOT NULL RETURNING *;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t1 DEFAULT VALUES;
VACUUM main;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_4468 ON t1(lower(b)) WHERE b > 0;
SELECT STRING_AGG(b, '|') FROM t1;
SELECT COUNT(a) FILTER (WHERE a IS NOT NULL) OVER (PARTITION BY a ORDER BY a RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T;
ANALYZE T;
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t1 VALUES (1, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
PRAGMA secure_delete = 0;
SELECT * FROM t1 CROSS JOIN T;
WITH a AS (SELECT a FROM t1), b AS (SELECT a FROM a), c AS (SELECT a FROM b) SELECT * FROM c;
UPDATE T SET a = 'x' WHERE a BETWEEN 0 AND 100 RETURNING *;
WITH cte(x) AS (VALUES(1),(2),(3)) SELECT * FROM cte WHERE x > 1;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_t1_3829 ON t1(a COLLATE NOCASE) WHERE a IS NOT NULL;
INSERT INTO T SELECT * FROM T;
INSERT INTO t1 VALUES (1, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b;
SELECT * FROM T AS a FULL JOIN T AS b ON a.rowid = b.rowid;
UPDATE T SET b = b + 1 WHERE rowid = 1;

Actual output

echo: off
         eqp: off
     explain: auto
     headers: off
        mode: list
   nullvalue: ""
      output: stdout
colseparator: "|"
rowseparator: "\n"
       stats: off
       width: 
    filename: :memory:
memory
1|1.5
2|-2.5
3|0.0
0|-1|-1
4
3|1
4|1
-4713-11-26 12:00:00|1
1|2026-05-15 11:46:11
2|2026-05-15 11:46:11
3|2026-05-15 11:46:11
1
1
1
0
-4713-11-26 12:00:00|2|1|2026-05-15 11:46:11
-4713-11-26 12:00:00|2|2|2026-05-15 11:46:11
-4713-11-26 12:00:00|2|3|2026-05-15 11:46:11
3|3|1|2026-05-15 11:46:11
3|3|2|2026-05-15 11:46:11
3|3|3|2026-05-15 11:46:11
4|5|1|2026-05-15 11:46:11
4|5|2|2026-05-15 11:46:11
4|5|3|2026-05-15 11:46:11
||1|2026-05-15 11:46:11
||2|2026-05-15 11:46:11
||3|2026-05-15 11:46:11
||1|2026-05-15 11:46:11
||2|2026-05-15 11:46:11
||3|2026-05-15 11:46:11
||1|2026-05-15 11:46:11
||2|2026-05-15 11:46:11
||3|2026-05-15 11:46:11
||1|2026-05-15 11:46:11
||2|2026-05-15 11:46:11
||3|2026-05-15 11:46:11
1|x|1|2026-05-15 11:46:11
1|x|2|2026-05-15 11:46:11
1|x|3|2026-05-15 11:46:11




1
3
4
-4713-11-26 12:00:00
x|2026-05-15 11:46:11
x|2026-05-15 11:46:11
x|2026-05-15 11:46:11
2
3
x|2026-05-15 11:46:11|x|2026-05-15 11:46:11
x|2026-05-15 11:46:11|x|2026-05-15 11:46:11
x|2026-05-15 11:46:11|x|2026-05-15 11:46:11
x|2026-05-15 11:46:11|x|2026-05-15 11:46:11
x|2026-05-15 11:46:11|x|2026-05-15 11:46:11
x|2026-05-15 11:46:11|x|2026-05-15 11:46:11

Expectation

Flag

-vfs memdb