## Summary **No review yet** ## Minimized query ```sql 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 ```sql 1 ``` ## Expectation ```sql 0 ``` ## Flag ``` -nullvalue "NU11" ```