ast-project/part1/results/3/bug_cec1957b-32b0-45bc-9b01-7f54ab5dd309_logic.md

Summary

**No review yet**

Minimized query

PRAGMA trusted_schema;
.output blablabla.whatever
PRAGMA page_size;
PRAGMA encoding = 'UTF-16be';
PRAGMA wal_checkpoint;
.log OFF
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;
WITH RECURSIVE vals(x) AS (SELECT A FROM T WHERE A IS NOT NULL UNION ALL SELECT A FROM T WHERE A IS NOT NULL LIMIT 10) SELECT * FROM vals;
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_2569 ON T(C COLLATE NOCASE);

Actual output

1

Expectation

0

Flag