ast-project/part1/results/2/bug_d3e29ffe-d0ba-403c-bd08-6a427f3e2a32_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;

Actual output

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

Expectation

Flag