ast-project/part1/results/3/bug_f0279551-0b13-42dc-a5b2-4de8309e23f4_logic.md

Summary

**No review yet**

Minimized query

PRAGMA ignore_check_constraints = NO;
PRAGMA integrity_check;
PRAGMA cell_size_check;
.cd bugs
CREATE TABLE t41(a INTEGER PRIMARY KEY, b INTEGER);
CREATE TABLE t42(d INTEGER PRIMARY KEY, e INTEGER);
CREATE TABLE t43(f INTEGER PRIMARY KEY, g INTEGER);
SELECT * FROM t41 LEFT JOIN (SELECT count(*) AS cnt, x1.d FROM (t42 INNER JOIN t43 ON d=g) AS x1 WHERE x1.d>CAST(NULL AS CLOB) GROUP BY x1.d) AS x2 ON t41.b=x2.d;
SELECT COUNT(*)
FROM t42;
ALTER TABLE t43 ADD COLUMN extra_9040 REAL DEFAULT NULL;
INSERT INTO t42  DEFAULT VALUES;
CREATE TABLE T (
  A VARCHAR(15) PRIMARY KEY,
  B VARCHAR(30) NOT NULL,
  C BIGINT UNIQUE
);
INSERT INTO T VALUES ('a', 'x', -9223372036854775808);
INSERT INTO T VALUES ('b', 'y', -1000000);
INSERT INTO T VALUES ('c', 'y', 0);
INSERT INTO T VALUES ('d', 'y', 42);
INSERT INTO T VALUES ('e', 'x', 9223372036854775807);
INSERT INTO T VALUES ('f', 'z', 2147483648);
SELECT * FROM T WHERE C > 0 ORDER BY C DESC;
ALTER TABLE t41 ADD COLUMN extra_3505 CHARACTER(20) COLLATE NOCASE;
SELECT * FROM t42;

Actual output

SQLite version 3.39.0 2022-05-10 23:28:12
Enter ".help" for usage hints.
sqlite> sqlite> ok
sqlite> 0
sqlite> sqlite> sqlite> sqlite> sqlite> sqlite>    ...> 0
sqlite> sqlite> sqlite>    ...>    ...>    ...>    ...> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> e|x|9223372036854775807
f|z|2147483648
d|y|42
sqlite> sqlite> 1|
sqlite>

Expectation

SQLite version 3.51.1 2025-11-28 17:28:25
Enter ".help" for usage hints.
sqlite> sqlite> ok
sqlite> 0
sqlite> sqlite> sqlite> sqlite> sqlite> sqlite>    ...> 0
sqlite> sqlite> sqlite> (x1...> (x1...> (x1...> (x1...> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> e|x|9223372036854775807
f|z|2147483648
d|y|42
sqlite> sqlite> 1|
sqlite>

Flag

-interactive