ast-project/part1/results/3/bug_525fb2fc-60e0-4748-b8f6-a8dfbf9fcf00_logic.md

Summary

**No review yet**

Minimized query

BEGIN IMMEDIATE;
CREATE TABLE T (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15),
  C BIGINT NOT NULL,
  UNIQUE (B, C)
);
INSERT INTO T VALUES ('a', 'p', 3000);
INSERT INTO T VALUES ('b', 'q', 9223372036854775807);
INSERT INTO T VALUES ('c', 'r', 1700);
INSERT INTO T VALUES ('e', 'q', -9223372036854775808);
INSERT INTO T VALUES ('f', 'r', 0);
SELECT B, COUNT(*) AS D, SUM(C) AS E, AVG(C) AS F FROM T GROUP BY B HAVING SUM(C) > 0;
DROP TRIGGER IF EXISTS T;
COMMIT TRANSACTION;
SELECT * FROM T WHERE C NOT IN (SELECT C FROM T WHERE C IS NULL);
VACUUM main;
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
DROP TABLE t0;

Actual output

SQLite version 3.39.0 2022-05-10 23:28:12
Enter ".help" for usage hints.
sqlite> sqlite>    ...>    ...>    ...>    ...>    ...> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> p|1|3000|3000.0
r|2|1700|850.0
sqlite> sqlite> sqlite> a|p|3000
b|q|9223372036854775807
c|r|1700
e|q|-9223372036854775808
f|r|0
sqlite> sqlite> sqlite> sqlite>

Expectation

SQLite version 3.51.1 2025-11-28 17:28:25
Enter ".help" for usage hints.
sqlite> sqlite> (x1...> (x1...> (x1...> (x1...> (x1...> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> p|1|3000|3000.0
r|2|1700|850.0
sqlite> sqlite> sqlite> a|p|3000
b|q|9223372036854775807
c|r|1700
e|q|-9223372036854775808
f|r|0
sqlite> sqlite> sqlite> sqlite>

Flag

-interactive