ast-project/part1/results/3/bug_f16641fa-601a-4ae9-a266-e5fb3572e612_logic.md

Summary

**No review yet**

Minimized query

BEGIN IMMEDIATE TRANSACTION;
.parameter
PRAGMA temp_store = '0';
PRAGMA cache_spill = julianday(-(-(-like('', '', ''))));
PRAGMA auto_vacuum = ')';
.timeout
CREATE TABLE A(Name text);
CREATE TABLE Items(ItemName text , Name text);
INSERT INTO Items VALUES('Item1','Parent');
INSERT INTO Items VALUES('Item2','Parent');
CREATE TABLE B(Name text);
SELECT Items.ItemName FROM Items LEFT JOIN A ON (A.Name = Items.ItemName OR Items.ItemName = 'dummy') LEFT JOIN B ON (B.Name = Items.ItemName) WHERE Items.Name = 'Parent' ORDER BY Items.ItemName;

SELECT Name FROM B WHERE Name = (SELECT MAX(Name) FROM B);
SELECT * FROM B AS a FULL OUTER JOIN Items AS b ON a.rowid = b.rowid;
INSERT INTO B DEFAULT VALUES;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (-852966518777461081,'a',1.25), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0;
END TRANSACTION;
INSERT INTO B DEFAULT VALUES;
PRAGMA short_column_names = YES;
ALTER TABLE T DROP COLUMN a;
ALTER TABLE T RENAME TO T_r1550;

Actual output

3.39.0 2022-05-10 23:28:12 764b71267e0b31ff7eaf2a0def7526a1a02dce4d5b456dea060d97ed342ealt1

Expectation

3.51.1 2025-11-28 17:28:25 281fc0e9afc38674b9b0991943b9e9d1e64c6cbdb133d35f6f5c87ff6af38a88 (64-bit)

Flag

-version