## Summary **No review yet** ## Minimized query ```sql .progress CREATE TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',NULL), ('a','c',5.0), ('b','d',-8.25); CREATE TABLE T1 ( a INTEGER, b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (1,1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; SELECT a,b,c, RANK() OVER (PARTITION BY a ORDER BY c DESC) AS d FROM T; UPDATE T SET a = CURRENT_TIMESTAMP WHERE a IS NOT NULL; INSERT INTO T SELECT * FROM T; UPDATE T SET c = c + 1 WHERE 1 RETURNING *; CREATE TEMP VIEW IF NOT EXISTS v_T1_5689 AS SELECT b FROM T1; INSERT INTO T SELECT * FROM T; WITH RECURSIVE inf(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM inf) SELECT * FROM inf LIMIT 10; INSERT OR REPLACE INTO T1 VALUES ('', 0); SELECT TOTAL(a) FROM T1; ``` ## Actual output ```sql 1|1.0 1|-1.0 2|Inf a|c|5.0|1 a|b||2 b|d|-8.25|1 2026-05-15 11:30:17|b| 2026-05-15 11:30:17|c|6 2026-05-15 11:30:17|d|-7.25 2026-05-15 11:30:17|b| 2026-05-15 11:30:17|c|6 2026-05-15 11:30:17|d|-7.25 1 2 3 4 5 6 7 8 9 10 4.0 ``` ## Expectation ```sql 1|1.0 1|-1.0 2|Inf a|c|5.0|1 a|b||2 b|d|-8.25|1 2026-05-15 11:30:17|b| 2026-05-15 11:30:17|c|6.0 2026-05-15 11:30:17|d|-7.25 2026-05-15 11:30:17|b| 2026-05-15 11:30:17|c|6.0 2026-05-15 11:30:17|d|-7.25 1 2 3 4 5 6 7 8 9 10 4.0 ``` ## Flag ``` ```