ast-project/part1/results/1/bug_d627aae4-3a05-4e14-9464-c9097fa55e1a_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;

Actual output

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

Expectation

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

Flag