ast-project/part1/results/3/bug_730974f6-f9c9-42dc-9478-dc572165521c_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; /* [1,2,3] */ CREATE UNIQUE  INDEX IF NOT EXISTS idx_T_2569 ON T(C COLLATE NOCASE);
CREATE TRIGGER IF NOT EXISTS trg_T_5392 BEFORE INSERT ON T BEGIN SELECT RAISE(FAIL, 'no'); END;

Actual output

1

Expectation

0

Flag

-nullvalue "NU11"