## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux57; .progress if(0, 9999, 0, 9999, 0, 9999) 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(pi(), NULL, -10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000)))), ('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 NOT 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; INSERT INTO T VALUES (NULL, NULL, NULL); CREATE INDEX IF NOT EXISTS idx_T_6375 ON T(b); SELECT COUNT(*) FROM T; CREATE UNIQUE INDEX IF NOT EXISTS idx_T_413 ON T((a + 1)) WHERE a IS NOT NULL; ANALYZE T; PRAGMA parser_trace = NO; REINDEX T; SELECT * FROM T; DETACH DATABASE aux57; ``` ## Actual output ```sql ||x 1 || ``` ## Expectation ```sql ``` ## Flag ``` ```