ast-project/part1/results/3/bug_d684194d-023f-411c-9b44-83ec5448fe4d_logic.md

Summary

**No review yet**

Minimized query

PRAGMA query_only = 0;
PRAGMA encoding = 'UTF-16be';
PRAGMA auto_vacuum = NONE;
.timer on
CREATE TABLE t1(a,b INT);
INSERT INTO t1(a,b) VALUES(1,2),(3,3),(4,5);
CREATE UNIQUE INDEX i1 ON t1(b,b,a,a,a,a,a,b,a);
ANALYZE;
DROP TABLE IF EXISTS sqlite_stat4;
INSERT INTO sqlite_stat1 VALUES('t1','i1','30 30 30 2 2 2 2 2 2 2');
ANALYZE sqlite_master;

PRAGMA checkpoint_fullsync = NO;

Actual output

Run Time: real 0.000 user 0.000094 sys 0.000000
Run Time: real 0.000 user 0.000019 sys 0.000000
Run Time: real 0.000 user 0.000071 sys 0.000000
Run Time: real 0.000 user 0.000074 sys 0.000000
Run Time: real 0.000 user 0.000005 sys 0.000000
Run Time: real 0.000 user 0.000008 sys 0.000000
Run Time: real 0.000 user 0.000020 sys 0.000000
Run Time: real 0.000 user 0.000003 sys 0.000000

Expectation

Run Time: real 0.000066 user 0.000081 sys 0.000000
Run Time: real 0.000018 user 0.000019 sys 0.000000
Run Time: real 0.000058 user 0.000060 sys 0.000000
Run Time: real 0.000067 user 0.000067 sys 0.000000
Run Time: real 0.000004 user 0.000005 sys 0.000000
Run Time: real 0.000006 user 0.000007 sys 0.000000
Run Time: real 0.000018 user 0.000018 sys 0.000000
Run Time: real 0.000002 user 0.000002 sys 0.000000

Flag