81 lines
1.3 KiB
Markdown
81 lines
1.3 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
|
|
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
|
|
|
|
```sql
|
|
/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
|
|
|
|
```sql
|
|
/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
|
|
|
|
```
|
|
|
|
```
|
|
|