118 lines
2.1 KiB
Markdown
118 lines
2.1 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
|
|
PRAGMA short_column_names;
|
|
ATTACH DATABASE ':memory:' AS aux31;
|
|
ATTACH DATABASE ':memory:' AS aux55;
|
|
-- json_set({v}, '$.new_key', {v})
|
|
|
|
ATTACH DATABASE ':memory:' AS aux6;
|
|
CREATE TABLE T (
|
|
a INTEGER,
|
|
b TEXT,
|
|
c REAL
|
|
);
|
|
INSERT INTO T VALUES (asinh(-7932293039094677366),'a',1.25), (2,'b',-3.5), (3,'c',9e999);
|
|
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0;
|
|
PRAGMA module_list;
|
|
PRAGMA journal_mode;
|
|
PRAGMA user_version;
|
|
.prompt 'IPA eli isopropanoli on loistava puhdistusaine joka irrataa'
|
|
CREATE TABLE t1(a,b,x);
|
|
CREATE TABLE t2(c,d,y);
|
|
CREATE INDEX t1b ON t1(b);
|
|
CREATE INDEX t2d ON t2(d);
|
|
ANALYZE sqlite_master;
|
|
INSERT INTO sqlite_stat1 VALUES('t1','t1b','10000 500');
|
|
INSERT INTO sqlite_stat1 VALUES('t2','t2d','10000 500');
|
|
ANALYZE sqlite_master;
|
|
SELECT * FROM t1, t2 WHERE d=b;
|
|
SELECT * FROM t1, t2 WHERE d>b AND x=y;
|
|
DETACH DATABASE aux6;
|
|
SELECT * FROM T WHERE a IN (SELECT a FROM T);
|
|
SELECT MAX(x) FROM t1;
|
|
PRAGMA soft_heap_limit = 10000000;
|
|
CREATE TEMP VIEW IF NOT EXISTS v_T_6525 AS SELECT a FROM T;
|
|
SELECT * FROM t2 AS a JOIN t1 AS b ON a.rowid = b.rowid;
|
|
REINDEX;
|
|
SELECT SUM(c) OVER (ORDER BY c RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM t2;
|
|
DETACH DATABASE aux55;
|
|
DETACH DATABASE aux31;
|
|
UPDATE t1 SET b = CURRENT_TIMESTAMP;
|
|
CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_6727 AS SELECT a FROM t1;
|
|
INSERT INTO t1 VALUES (NULL, NULL, NULL);
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
1
|
|
-44.210621008338|a|1.25
|
|
3|c|Inf
|
|
sqlite_dbdata
|
|
generate_series
|
|
completion
|
|
fsdir
|
|
tables_used
|
|
sqlite_stmt
|
|
json_tree
|
|
fts4aux
|
|
fts3
|
|
fts4
|
|
sqlite_dbptr
|
|
fts3tokenize
|
|
bytecode
|
|
rtree_i32
|
|
sqlite_dbpage
|
|
rtree
|
|
dbstat
|
|
json_each
|
|
memory
|
|
0
|
|
-44.210621008338|a|1.25
|
|
2|b|-3.5
|
|
3|c|Inf
|
|
|
|
10000000
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
1
|
|
-44.210621008338|a|1.25
|
|
3|c|Inf
|
|
fsdir
|
|
generate_series
|
|
bytecode
|
|
dbstat
|
|
tables_used
|
|
sqlite_stmt
|
|
sqlite_dbpage
|
|
rtree_i32
|
|
fts4aux
|
|
fts3
|
|
zipfile
|
|
fts4
|
|
completion
|
|
rtree
|
|
fts3tokenize
|
|
memory
|
|
0
|
|
-44.210621008338|a|1.25
|
|
2|b|-3.5
|
|
3|c|Inf
|
|
|
|
10000000
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
|
|
```
|
|
|