ast-project/part1/results/2/bug_d709e10d-4374-4a56-ac68-f725acef6911_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a INTEGER,
  b REAL,
  c REAL
);
INSERT INTO T VALUES ((1 - 0),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;

Actual output

SQLite version 3.39.0 2022-05-10 23:28:12
Enter ".help" for usage hints.
sqlite>    ...>    ...>    ...>    ...> sqlite> sqlite> 1|-49.875
2|-Inf
sqlite>

Expectation

SQLite version 3.51.1 2025-11-28 17:28:25
Enter ".help" for usage hints.
sqlite> (x1...> (x1...> (x1...> (x1...> sqlite> sqlite> 1|-49.875
2|-Inf
sqlite>

Flag

-interactive