ast-project/part1/results/2/bug_7720683b-6eac-4550-a7fb-5499d7abb543_unexpected_error.md

Summary

**No review yet**

Minimized query

.bail off
.progress
.mode
ATTACH DATABASE ':memory:' AS aux59;
-- PRAGMA locking_mode = 'EXCLUSIVE';

.excel
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
CREATE TABLE T (
  a TEXT,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b','{"a":1,"b":[1,2,3]}'), ('a','c',-trim(if(0, 2.25, 2.25), 'xyz')), ('b','b',4.75);
SELECT a,
SUM(CASE WHEN b='b' THEN c ELSE 0 END) AS d,
SUM(CASE WHEN b='c' THEN c ELSE 0 END) AS e
FROM T
GROUP BY a;
DROP TABLE t0;
PRAGMA mmap_size = 3486721695780892466;
VACUUM main;
DETACH DATABASE aux59;
UPDATE T SET a = json_object('k', a) WHERE NOT NOT a IS NOT NULL RETURNING *;
ALTER TABLE T RENAME COLUMN a TO a_r7349;
REINDEX;
INSERT INTO T DEFAULT VALUES;
WITH cte AS (SELECT NULL AS x, NULL AS y) SELECT x, y, x IS NULL FROM cte;
VACUUM;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<62) SELECT MAX(x) FROM cnt;
PRAGMA reverse_unordered_selects = OFF;
PRAGMA freelist_count;
INSERT INTO T VALUES (NULL, NULL, NULL);
VACUUM main;
SELECT * FROM T AS a JOIN T AS b ON a.rowid = b.rowid;
SELECT * FROM T AS a LEFT OUTER JOIN T AS b ON a.rowid = b.rowid;

Actual output

current output mode: list
||1
62
0
|||||
|||||
|||||
|||||

Expectation

Flag