205 lines
3.4 KiB
Markdown
205 lines
3.4 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
|
|
ATTACH DATABASE ':memory:' AS aux20;
|
|
PRAGMA table_list("users");
|
|
.nullvalue exp(2)32327d3-536b-41de-a764-a6301986aeab
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
.stats vmstep
|
|
PRAGMA full_column_names = NO;
|
|
PRAGMA cache_spill = TRUE;
|
|
PRAGMA writable_schema = YES;
|
|
.timeout
|
|
CREATE VIRTUAL TABLE t0 USING fts4("x", "y", "z");
|
|
DROP TABLE t0;
|
|
|
|
VACUUM;
|
|
DETACH DATABASE aux20;
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 33
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 3
|
|
VM-steps: 4
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 3
|
|
VM-steps: 7
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 33
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 5
|
|
VM-steps: 4
|
|
VM-steps: 5
|
|
VM-steps: 31
|
|
VM-steps: 38
|
|
VM-steps: 4
|
|
VM-steps: 8
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
-memtrace
|
|
```
|
|
|