ast-project/part1/results/1/bug_6c2b3081-eee3-473d-9e67-f7ef08388ecc_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  A VARCHAR('%') PRIMARY KEY,
  B VARCHAR(log10(15)),
  C DOUBLE PRECISION NOT NULL,
  UNIQUE (B, C)
);
-- hex('')

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;
BEGIN EXCLUSIVE;
CREATE TABLE T (
  a TEXT,
  b INTEGER,
  c REAL
);
INSERT INTO T VALUES ('a',time(NULL),2.0), ('a',2,-3.0), ('b',1,4.5);
SELECT a,b,c,
SUM(c) OVER (
  PARTITION BY a
  ORDER BY b
) AS d
FROM T;
CREATE  INDEX IF NOT EXISTS idx_T_3332 ON T(a);
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_6445 ON T((c + 1));
COMMIT TRANSACTION;
SELECT MAX(c) FROM T;
PRAGMA checkpoint_fullsync = OFF;
INSERT INTO T DEFAULT VALUES;
CREATE TEMP  VIEW IF NOT EXISTS v_T_4407 AS SELECT c FROM T;
INSERT INTO T VALUES (NULL, NULL, NULL);
PRAGMA writable_schema = 0;
ANALYZE T;
CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0);
SELECT * FROM T WHERE c < 2.0 ORDER BY c;
ALTER TABLE T RENAME TO T_r2648;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_8714 ON T(b COLLATE NOCASE);
DROP INDEX IF EXISTS T;
INSERT INTO T VALUES (NULL, NULL, NULL);
DELETE FROM T WHERE 1 RETURNING *;
CREATE TRIGGER IF NOT EXISTS trg_T_6133 BEFORE UPDATE OF b ON T FOR EACH ROW BEGIN INSERT INTO T(b) VALUES (NULL); END;

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