ast-project/part1/results/3/bug_8a7b28ed-4bf6-4348-966b-fd4d0799e8e6_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T1 (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15) UNIQUE,
  C BIGINT
);
CREATE TABLE T2 (
  X VARCHAR(20) PRIMARY KEY,
  A VARCHAR(10),
  FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', 9999999999999);
INSERT INTO T1 VALUES ('b', 'q', -9999999999999);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.C FROM T2 INNER JOIN T1 ON T2.A = T1.A WHERE T1.C > -1000000000000;
PRAGMA defer_foreign_keys;

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> m|9999999999999
sqlite> 0
sqlite>

Expectation

SQLite version 3.51.1 2025-11-28 17:28:25
Enter ".help" for usage hints.
sqlite> (x1...> (x1...> (x1...> (x1...> sqlite> (x1...> (x1...> (x1...> (x1...> sqlite> sqlite> sqlite> sqlite> sqlite> m|9999999999999
sqlite> 0
sqlite>

Flag

-interactive