ast-project/part1/results/1/bug_98583f43-5922-4b6f-88f9-bb5deead3046_logic.md

Summary

**No review yet**

Minimized query

BEGIN DEFERRED TRANSACTION;
.shell pwd
CREATE TABLE T (
  a INTEGER,
  b REAL
);
INSERT INTO T VALUES (NULL,substring(1.5, 1, 2)), (2,-7.25), (3,0.0);
SELECT a,b FROM T WHERE +a >= 2 ORDER BY b;
SAVEPOINT sp9376;
SELECT exp(0)x0ACB29BM205381;
SELECT sqlite_compileoption_used('我的天你是怎么了');
SELECT 1 >> -999999999999999999999999999;
SELECT sqlite_compileoption_get($1);
SELECT sqlite_version();
ROLLBACK TO sp9376;
RELEASE sp9376;

SELECT COUNT(*) FROM T;
CREATE TRIGGER IF NOT EXISTS trg_T_8559 AFTER UPDATE ON T BEGIN INSERT INTO T(a) VALUES (NULL); END;
SELECT GROUP_CONCAT(b) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM T;
INSERT INTO T VALUES (NULL, NULL);
END;
PRAGMA automatic_index = OFF;
SELECT * FROM T;

Actual output

/fuzzer
2|-7.25
3|0.0
1.0
0
0
ATOMIC_INTRINSICS=1
3.39.0
3
-7.25
-7.25,0.0
-7.25,0.0,1.0
|1.0
2|-7.25
3|0.0
|

Expectation

/fuzzer
2|-7.25
3|0.0
1.0
0
0
ATOMIC_INTRINSICS=1
3.51.1
3
-7.25
-7.25,0.0
-7.25,0.0,1.0
|1.0
2|-7.25
3|0.0
|

Flag