## Summary **No review yet** ## Minimized query ```sql SAVEPOINT sp8760; ATTACH DATABASE ':memory:' AS aux23; PRAGMA vdbe_debug = 1; PRAGMA temp_store = 'MEMORY'; PRAGMA cell_size_check = FALSE; .scanstats on CREATE TABLE [T] ( a INTEGER, b REAL, c REAL ); INSERT INTO T VALUES (1,2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0); WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d; ALTER TABLE T RENAME COLUMN a TO a_r2555; SELECT * FROM T AS a FULL JOIN T AS b ON a.rowid = b.rowid; DELETE FROM T WHERE 1; DETACH DATABASE aux23; RELEASE sp8760; CREATE TRIGGER IF NOT EXISTS trg_T_2695 AFTER DELETE ON T FOR EACH ROW BEGIN SELECT RAISE(IGNORE); END; INSERT INTO T VALUES (NULL, NULL, NULL); SELECT * FROM T WHERE EXISTS (SELECT 1 FROM T t2 WHERE t2.c = T.c); SELECT * FROM T; DELETE FROM T WHERE 1; SELECT * FROM T AS a FULL JOIN T AS b ON a.rowid = b.rowid; ``` ## Actual output ```sql [{"a":1,"e":-49.875000000000000001}, {"a":2,"e":-1e999}] [{"a_r2555":1,"b":2.0,"c":10.499999999999999999,"a_r2555":1,"b":2.0,"c":10.499999999999999999}, {"a_r2555":1,"b":-3.5,"c":20.25,"a_r2555":1,"b":-3.5,"c":20.25}, {"a_r2555":2,"b":1e999,"c":-1.0,"a_r2555":2,"b":1e999,"c":-1.0}] [{"a_r2555":null,"b":null,"c":null}] ``` ## Expectation ```sql [{"a":1,"e":-49.875}, {"a":2,"e":-9.0e+999}] [{"a_r2555":1,"b":2.0,"c":10.5,"a_r2555":1,"b":2.0,"c":10.5}, {"a_r2555":1,"b":-3.5,"c":20.25,"a_r2555":1,"b":-3.5,"c":20.25}, {"a_r2555":2,"b":9.0e+999,"c":-1.0,"a_r2555":2,"b":9.0e+999,"c":-1.0}] [{"a_r2555":null,"b":null,"c":null}] ``` ## Flag ``` -json ```