ast-project/part1/results/1/bug_0c1c7d6c-d0a2-44a4-89ef-25d4f98dd8cf_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a
INTEGER,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (upper('hello'),2.0,10.5), (1,-3.5,20.25), (2,9e999,-1.0);
WITH d AS (SELECT a,SUM(b*c) AS e FROM T GROUP BY a) SELECT * FROM d;
PRAGMA trusted_schema;
PRAGMA defer_foreign_keys;
PRAGMA synchronous = 'EXTRA';
.nullvalue -(-(2))32327d3-536b-41de-a764-a6301986aeab
CREATE TABLE t0(c0);
INSERT INTO t0(c0) VALUES (NULL);
CREATE INDEX i0 ON t0(1) WHERE c0 NOT NULL;
SELECT 1 FROM t0 WHERE (t0.c0 IS FALSE) IS FALSE;
SELECT 1 FROM t0 WHERE (t0.c0 IS FALSE) BETWEEN FALSE AND TRUE;

REINDEX T;
ANALYZE;
DROP INDEX IF EXISTS t0;
PRAGMA wal_autocheckpoint = 1000;
UPDATE t0 SET c0 = NULL WHERE c0 IS NOT NULL;
ALTER TABLE T RENAME TO T_r6099;
CREATE  VIEW IF NOT EXISTS v_T_502 AS SELECT c FROM T;

Actual output

1|-70.875
2|-Inf
HELLO|21.0
1
0
1
1000

Expectation

1|-70.875
2|-Inf
HELLO|21.0
0
0
1
1
1000

Flag