ast-project/part1/results/2/bug_0cd32bbd-8134-4ac1-8ca8-24699b887d97_unexpected_error.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a TEXT,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES ('a','b',if(1, 1.0)), ('a','c',-1.0), ('b','d',0.0);
SELECT
COALESCE(a,'e') AS d,
COALESCE(b,'f') AS e,
SUM(c) AS f
FROM T
GROUP BY a,b;
CREATE TABLE T1 (
  a INTEGER,
  b TEXT
);
CREATE TABLE T2 (
  a INTEGER,
  b TEXT
);
INSERT INTO T1 VALUES (1,'a'),(2,'b');
INSERT INTO T2 VALUES (1,'c'),(1,'d');
SELECT T1.b,
(
  SELECT GROUP_CONCAT(b,',')
  FROM T2
  WHERE T2.a=T1.a
) AS c
FROM T1;
INSERT INTO T1 DEFAULT VALUES;
INSERT INTO T2 VALUES (NULL, NULL);
UPDATE T2 SET b = 74 WHERE b BETWEEN 0 AND 100;
INSERT INTO T2 SELECT * FROM T2;
UPDATE T SET a = -84 WHERE +rowid = 1;
SELECT * FROM T2;
SELECT * FROM T;
WITH cte AS (SELECT COUNT(*) AS cnt FROM T1) SELECT * FROM cte WHERE +cnt > 0;
CREATE  INDEX IF NOT EXISTS idx_T1_97 ON T1((a + 1)) WHERE a IS NOT NULL;

Actual output

a|c,d
b|
1|c
1|d
|
1|c
1|d
|
3

Expectation

Flag