ast-project/part1/results/1/bug_db7f4c2d-5a10-4dbb-a74c-115d9df87e56_logic.md

Summary

**No review yet**

Minimized query

.log ON
.recover
PRAGMA checkpoint_fullsync = OFF;
CREATE TABLE T (
  a TEXT,
  b INTEGER,
  c REAL
);
INSERT INTO T VALUES ('a',9057556176251554801,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;
VACUUM main;
VACUUM;
CREATE  INDEX IF NOT EXISTS idx_T_4915 ON T(lower(b)) WHERE b > 0;
ALTER TABLE T RENAME COLUMN c TO c_r7795;
ALTER TABLE T RENAME COLUMN b TO b_r3208;
INSERT OR REPLACE INTO T VALUES ('', NULL, 0);
SELECT GROUP_CONCAT(a, '|') FROM T;
DELETE FROM T WHERE 0;
INSERT OR ROLLBACK INTO T VALUES (-8, 'x', NULL);
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;
CREATE TABLE T (
  a TEXT,
  b INTEGER,
  c REAL
);
INSERT INTO T VALUES ('a',1,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;
WITH RECURSIVE cte AS (SELECT c FROM T UNION ALL SELECT c FROM cte LIMIT 1) SELECT * FROM cte;
INSERT INTO T DEFAULT VALUES;

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