## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux40; BEGIN IMMEDIATE; CREATE TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',quote(date(if(1, NULL, 12.5)))), ('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 INDEX IF NOT EXISTS idx_T_6101 ON T(a COLLATE NOCASE) WHERE a IS NOT NULL; END TRANSACTION; INSERT OR FAIL INTO T VALUES (NULL, NULL, 'x'); WITH cte AS (SELECT * FROM T) SELECT * FROM cte JOIN T ON cte.b = T.b; DETACH DATABASE aux40; DELETE FROM T WHERE 1 RETURNING *; VACUUM; ``` ## Actual output ```sql ||x ``` ## Expectation ```sql ``` ## Flag ``` ```