85 lines
1.2 KiB
Markdown
85 lines
1.2 KiB
Markdown
## Summary
|
|
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
|
|
|
|
## Minimized query
|
|
|
|
```sql
|
|
.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
|
|
|
|
```sql
|
|
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
|
|
|
|
```sql
|
|
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
|
|
|
|
```
|
|
|
|
```
|
|
|