ast-project/part1/results/3/bug_ab191d11-aac1-4df6-ab6f-35208b007b6f_unexpected_error.md

Summary

**No review yet**

Minimized query

SAVEPOINT sp3675;
.timer on
.explain
.restore emplyeee.db
PRAGMA read_uncommitted = ON;
CREATE TABLE t0(c0 REAL, c1 REAL GENERATED ALWAYS AS (c0));
INSERT INTO t0(c0) VALUES (jsonb_object('k', 1));
SELECT * FROM t0 GROUP BY c0;
CREATE TABLE t1(a, b);
CREATE TABLE t2(c, d);
SELECT max(t1.a), (SELECT 'xyz' FROM (SELECT * FROM t2 WHERE 0) WHERE t1.b=1) FROM t1;

SELECT MIN(c0) FROM t0;
ANALYZE;
SELECT MAX(d) FROM t2;
ROLLBACK TO sp3675;
RELEASE sp3675;

Actual output

Run Time: real 0.000 user 0.000022 sys 0.000000
Run Time: real 0.000 user 0.000170 sys 0.000000
Run Time: real 0.000 user 0.000015 sys 0.000000
Run Time: real 0.000 user 0.000025 sys 0.000000
Run Time: real 0.000 user 0.000040 sys 0.000000
Run Time: real 0.000 user 0.000031 sys 0.000000
max(  (SELECT 'xyz'
----  -------------
      
Run Time: real 0.000 user 0.000038 sys 0.000000
MIN(
----

Run Time: real 0.000 user 0.000009 sys 0.000000
Run Time: real 0.000 user 0.000057 sys 0.000000
MAX(
----

Run Time: real 0.000 user 0.000007 sys 0.000000
Run Time: real 0.000 user 0.000009 sys 0.000000
Run Time: real 0.000 user 0.000005 sys 0.000000

Expectation

Flag