ast-project/part1/results/3/bug_12024b15-79f5-4daa-a1a2-69b8504e1ee0_logic.md

Summary

**No review yet**

Minimized query

.stats vmstep
CREATE TABLE main.T (
  a INTEGER,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (pi(),1.5,10.0), (2,-2.5,20.0), (3,-9e999,30.0);
SELECT * FROM T WHERE b IS 2.0 ORDER BY b;
CREATE TRIGGER IF NOT EXISTS trg_T_3707 AFTER UPDATE OF c ON T BEGIN INSERT INTO T(c) VALUES (NULL); END;
INSERT INTO T SELECT * FROM T;
SELECT COUNT(c) FILTER (WHERE c IS NOT NULL) OVER (ORDER BY c RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM T;
VACUUM main;
SELECT PERCENT_RANK() OVER (PARTITION BY a ORDER BY a) FROM T;
DELETE FROM T WHERE c > (SELECT AVG(c) FROM T) RETURNING *;

Actual output

VM-steps: 30
VM-steps: 37
VM-steps: 20
VM-steps: 15
VM-steps: 70
6
6
4
4
2
2
VM-steps: 524
VM-steps: 3
0.0
0.0
0.0
0.0
0.0
0.0
VM-steps: 274
3|-Inf|30.0
3|-Inf|30.0
VM-steps: 132

Expectation

VM-steps: 30
VM-steps: 37
VM-steps: 20
VM-steps: 15
VM-steps: 70
6
6
4
4
2
2
VM-steps: 524
VM-steps: 4
0.0
0.0
0.0
0.0
0.0
0.0
VM-steps: 274
3|-Inf|30.0
3|-Inf|30.0
VM-steps: 142

Flag