ast-project/part1/results/2/bug_b9f29b90-6fe8-4e46-bf7e-75c6e9353fe1_unexpected_error.md

Summary

**No review yet**

Minimized query

PRAGMA short_column_names;
BEGIN IMMEDIATE TRANSACTION;
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
DROP TABLE t0;
CREATE TABLE main.t1(a,b);
INSERT INTO t1 VALUES(pi(),jsonb_insert(4722785646842838875, '$.key', 4722785646842838875));
INSERT INTO t1 VALUES(2,22);
INSERT INTO t1 SELECT a+2, b+22 FROM t1;
INSERT INTO t1 SELECT a+4, b+44 FROM t1;
CREATE TABLE main.t2(c,d);
INSERT INTO t2 SELECT a, 900+b FROM t1;
PRAGMA automatic_index=ON;
SELECT b, d FROM t1 JOIN t2 ON a=c ORDER BY b;
SELECT COUNT(*) FROM t2;
DELETE FROM t1 WHERE b > (SELECT AVG(b) FROM t1) RETURNING *;
CREATE  INDEX IF NOT EXISTS idx_t1_3986 ON t1((a + 1)) WHERE a IS NOT NULL;
COMMIT TRANSACTION;
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;
SELECT * FROM t2 AS a INNER JOIN t1 AS b ON a.rowid = b.rowid;
ALTER TABLE t1 ADD COLUMN extra_716 SMALLINT DEFAULT NULL;
DROP TRIGGER IF EXISTS t2;
VACUUM main;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 DEFAULT VALUES;
SELECT GROUP_CONCAT(c) FROM t2;
INSERT OR ABORT INTO t2 VALUES (NULL, 4);
SELECT COUNT(*) FROM t1;

Actual output

1
22|922
44|944
66|966
88|988
4
6|66
8|88
1|a||1
2|b|1|2
3|c|2|3
2|922|2|22
4|944|4|44
2,4,6,8
5

Expectation

Flag