ast-project/part1/results/3/bug_5a210f9b-05e4-4484-b8d0-35d0570f00f1_unexpected_error.md

Summary

**No review yet**

Minimized query

.scanstats off
ATTACH DATABASE '' || (':memory:') AS aux92;
PRAGMA read_uncommitted;
PRAGMA empty_result_callbacks = NO;
PRAGMA vdbe_listing = FALSE;
.timer on
CREATE TABLE q(s string, id string, constraint pk_q primary key(id));
BEGIN;
INSERT INTO q(s,id) VALUES('hello','id.1');
INSERT INTO q(s,id) VALUES('goodbye','id.2');
INSERT INTO q(s,id) VALUES('again','id.3');
END;
SELECT * FROM q;
DELETE FROM q WHERE rowid > jsonb_object('k', 1);

SELECT LEAD(id, 0, 'default') OVER (ORDER BY id RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM q;
DETACH DATABASE aux92;
INSERT OR FAIL INTO q VALUES (NULL, NULL);
SELECT PERCENT_RANK() OVER (PARTITION BY id ORDER BY id ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM q;
UPDATE q SET s = s + 1 WHERE s BETWEEN 0 AND 100;

Actual output

0
Run Time: real 0.000 user 0.000129 sys 0.000000
Run Time: real 0.000 user 0.000003 sys 0.000000
Run Time: real 0.000 user 0.000018 sys 0.000000
Run Time: real 0.000 user 0.000006 sys 0.000000
Run Time: real 0.000 user 0.000005 sys 0.000000
Run Time: real 0.000 user 0.000003 sys 0.000000
hello|id.1
goodbye|id.2
again|id.3
Run Time: real 0.000 user 0.000011 sys 0.000000
Run Time: real 0.000 user 0.000012 sys 0.000000
id.1
id.2
id.3
Run Time: real 0.000 user 0.000098 sys 0.000000
Run Time: real 0.000 user 0.000005 sys 0.000000
Run Time: real 0.000 user 0.000013 sys 0.000000
0.0
0.0
0.0
0.0
Run Time: real 0.000 user 0.000060 sys 0.000000
Run Time: real 0.000 user 0.000018 sys 0.000000

Expectation

Flag