ast-project/part1/results/3/bug_9ea116ca-924a-4072-8263-aadd09cfed9a_logic.md

Summary

**No review yet**

Minimized query

PRAGMA vdbe_debug = ON;
.stats vmstep
CREATE TABLE main.T (
  a INTEGER,
  b REAL,
  c REAL
);
INSERT INTO T VALUES (pi(),-(-(-(-(power((1.5 * 1), 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 *;
INSERT INTO T SELECT * FROM T;
CREATE TRIGGER IF NOT EXISTS trg_T_4039 AFTER INSERT ON T BEGIN SELECT RAISE(ABORT, 'abort'); END;

Actual output

VM-steps: 30
VM-steps: 50
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
VM-steps: 89
VM-steps: 15

Expectation

VM-steps: 30
VM-steps: 50
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
VM-steps: 89
VM-steps: 15

Flag