534 lines
22 KiB
Markdown
534 lines
22 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;
|
|
CREATE TABLE album( aid INTEGER PRIMARY KEY, title TEXT UNIQUE NOT NULL);
|
|
CREATE TABLE track( tid INTEGER PRIMARY KEY, aid INTEGER NOT NULL REFERENCES album, tn INTEGER NOT NULL, name TEXT, UNIQUE(aid, tn));
|
|
INSERT INTO album VALUES(1, '1-one'), (2, '2-two'), (3, '3-three');
|
|
INSERT INTO track VALUES (NULL, 1, 1, 'one-a'), (NULL, 2, 2, 'two-b'), (NULL, 3, 3, 'three-c'), (NULL, 1, 3, 'one-c'), (NULL, 2, 1, 'two-a'), (NULL, 3, 1, 'three-a');
|
|
COMMIT;
|
|
SELECT name FROM album JOIN track USING (aid) ORDER BY title, tn;
|
|
|
|
ALTER TABLE album RENAME COLUMN aid TO aid_r8401;
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
Memory Used: 62608 (max 62608) bytes
|
|
Number of Outstanding Allocations: 122 (max 122)
|
|
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4104 bytes
|
|
Lookaside Slots Used: 35 (max 35)
|
|
Successful lookaside attempts: 35
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 4904 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 0 bytes
|
|
Statement Heap/Lookaside Usage: 2528 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 2
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2528
|
|
Bytes received by read(): 6887
|
|
Bytes sent to write(): 0
|
|
Read() system calls: 13
|
|
Write() system calls: 0
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 86824 (max 92728) bytes
|
|
Number of Outstanding Allocations: 173 (max 182)
|
|
Number of Pcache Overflow Bytes: 21288 (max 21288) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 90)
|
|
Successful lookaside attempts: 112
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 17936 bytes
|
|
Page cache hits: 5
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1224 bytes
|
|
Statement Heap/Lookaside Usage: 4168 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 41
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4168
|
|
Bytes received by read(): 7237
|
|
Bytes sent to write(): 1285
|
|
Read() system calls: 16
|
|
Write() system calls: 1
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 96328 (max 102320) bytes
|
|
Number of Outstanding Allocations: 187 (max 200)
|
|
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 32 (max 91)
|
|
Successful lookaside attempts: 189
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1904 bytes
|
|
Statement Heap/Lookaside Usage: 4248 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 39
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4248
|
|
Bytes received by read(): 7334
|
|
Bytes sent to write(): 2581
|
|
Read() system calls: 18
|
|
Write() system calls: 2
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94480 (max 104288) bytes
|
|
Number of Outstanding Allocations: 172 (max 200)
|
|
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 50 (max 91)
|
|
Successful lookaside attempts: 231
|
|
Lookaside failures due to size: 1
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1928 bytes
|
|
Statement Heap/Lookaside Usage: 5624 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 72
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 5624
|
|
Bytes received by read(): 7431
|
|
Bytes sent to write(): 3878
|
|
Read() system calls: 20
|
|
Write() system calls: 3
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 94504 (max 104312) bytes
|
|
Number of Outstanding Allocations: 173 (max 200)
|
|
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 56 (max 103)
|
|
Successful lookaside attempts: 306
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1952 bytes
|
|
Statement Heap/Lookaside Usage: 13896 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 165
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 13896
|
|
Bytes received by read(): 7528
|
|
Bytes sent to write(): 5175
|
|
Read() system calls: 22
|
|
Write() system calls: 4
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 90520 (max 104312) bytes
|
|
Number of Outstanding Allocations: 169 (max 200)
|
|
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 35 (max 103)
|
|
Successful lookaside attempts: 309
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1952 bytes
|
|
Statement Heap/Lookaside Usage: 2528 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 2
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2528
|
|
Bytes received by read(): 7625
|
|
Bytes sent to write(): 6476
|
|
Read() system calls: 24
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
one-a
|
|
one-c
|
|
two-a
|
|
two-b
|
|
three-a
|
|
three-c
|
|
Memory Used: 90568 (max 104312) bytes
|
|
Number of Outstanding Allocations: 171 (max 200)
|
|
Number of Pcache Overflow Bytes: 30008 (max 30008) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 46 (max 103)
|
|
Successful lookaside attempts: 359
|
|
Lookaside failures due to size: 2
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26624 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 2000 bytes
|
|
Statement Heap/Lookaside Usage: 3680 bytes
|
|
Fullscan Steps: 2
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 47
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 3680
|
|
Bytes received by read(): 7722
|
|
Bytes sent to write(): 7773
|
|
Read() system calls: 26
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 208568 (max 684680) bytes
|
|
Number of Outstanding Allocations: 243 (max 349)
|
|
Number of Pcache Overflow Bytes: 38216 (max 71048) bytes
|
|
Largest Allocation: 87200 bytes
|
|
Largest Pcache Allocation: 4360 bytes
|
|
Lookaside Slots Used: 101 (max 123)
|
|
Successful lookaside attempts: 707
|
|
Lookaside failures due to size: 5
|
|
Lookaside failures due to OOM: 268
|
|
Pager Heap Usage: 35840 bytes
|
|
Page cache hits: 13
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Schema Heap Usage: 1920 bytes
|
|
Statement Heap/Lookaside Usage: 52928 bytes
|
|
Fullscan Steps: 12
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 257
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 52928
|
|
Bytes received by read(): 7819
|
|
Bytes sent to write(): 9111
|
|
Read() system calls: 29
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
Memory Used: 63416 (max 63416) bytes
|
|
Number of Outstanding Allocations: 132 (max 132)
|
|
Number of Pcache Overflow Bytes: 4104 (max 4104) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4104 bytes
|
|
Lookaside Slots Used: 51 (max 51)
|
|
Successful lookaside attempts: 51
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 4904 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 0 bytes
|
|
Statement Heap/Lookaside Usage: 2528 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 3
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2528
|
|
Bytes received by read(): 7663
|
|
Bytes sent to write(): 0
|
|
Read() system calls: 14
|
|
Write() system calls: 0
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 87264 (max 93072) bytes
|
|
Number of Outstanding Allocations: 183 (max 192)
|
|
Number of Pcache Overflow Bytes: 21304 (max 21304) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 99)
|
|
Successful lookaside attempts: 121
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 17960 bytes
|
|
Page cache hits: 5
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1072 bytes
|
|
Statement Heap/Lookaside Usage: 3984 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 41
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 3984
|
|
Bytes received by read(): 7757
|
|
Bytes sent to write(): 1324
|
|
Read() system calls: 16
|
|
Write() system calls: 1
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 96736 (max 102624) bytes
|
|
Number of Outstanding Allocations: 197 (max 210)
|
|
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 48 (max 100)
|
|
Successful lookaside attempts: 191
|
|
Lookaside failures due to size: 0
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1696 bytes
|
|
Statement Heap/Lookaside Usage: 4096 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 39
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 4096
|
|
Bytes received by read(): 7854
|
|
Bytes sent to write(): 2659
|
|
Read() system calls: 18
|
|
Write() system calls: 2
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 95016 (max 104744) bytes
|
|
Number of Outstanding Allocations: 182 (max 210)
|
|
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 66 (max 100)
|
|
Successful lookaside attempts: 236
|
|
Lookaside failures due to size: 1
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1704 bytes
|
|
Statement Heap/Lookaside Usage: 5616 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 72
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 5616
|
|
Bytes received by read(): 7951
|
|
Bytes sent to write(): 3996
|
|
Read() system calls: 20
|
|
Write() system calls: 3
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 96368 (max 106096) bytes
|
|
Number of Outstanding Allocations: 184 (max 210)
|
|
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 71 (max 100)
|
|
Successful lookaside attempts: 307
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 bytes
|
|
Page cache hits: 2
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1712 bytes
|
|
Statement Heap/Lookaside Usage: 8672 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 165
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 8672
|
|
Bytes received by read(): 8048
|
|
Bytes sent to write(): 5333
|
|
Read() system calls: 22
|
|
Write() system calls: 4
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 91064 (max 106096) bytes
|
|
Number of Outstanding Allocations: 179 (max 210)
|
|
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 51 (max 100)
|
|
Successful lookaside attempts: 310
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 bytes
|
|
Page cache hits: 0
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1712 bytes
|
|
Statement Heap/Lookaside Usage: 2528 bytes
|
|
Fullscan Steps: 0
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 3
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 2528
|
|
Bytes received by read(): 8145
|
|
Bytes sent to write(): 6671
|
|
Read() system calls: 24
|
|
Write() system calls: 5
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
one-a
|
|
one-c
|
|
two-a
|
|
two-b
|
|
three-a
|
|
three-c
|
|
Memory Used: 91080 (max 106096) bytes
|
|
Number of Outstanding Allocations: 181 (max 210)
|
|
Number of Pcache Overflow Bytes: 30040 (max 30040) bytes
|
|
Largest Allocation: 48000 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 61 (max 100)
|
|
Successful lookaside attempts: 359
|
|
Lookaside failures due to size: 3
|
|
Lookaside failures due to OOM: 0
|
|
Pager Heap Usage: 26664 bytes
|
|
Page cache hits: 4
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1728 bytes
|
|
Statement Heap/Lookaside Usage: 3552 bytes
|
|
Fullscan Steps: 2
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 47
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 3552
|
|
Bytes received by read(): 8242
|
|
Bytes sent to write(): 8007
|
|
Read() system calls: 26
|
|
Write() system calls: 6
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
Memory Used: 208024 (max 681040) bytes
|
|
Number of Outstanding Allocations: 218 (max 302)
|
|
Number of Pcache Overflow Bytes: 38240 (max 71040) bytes
|
|
Largest Allocation: 87360 bytes
|
|
Largest Pcache Allocation: 4368 bytes
|
|
Lookaside Slots Used: 99 (max 123)
|
|
Successful lookaside attempts: 699
|
|
Lookaside failures due to size: 6
|
|
Lookaside failures due to OOM: 214
|
|
Pager Heap Usage: 35896 bytes
|
|
Page cache hits: 13
|
|
Page cache misses: 0
|
|
Page cache writes: 0
|
|
Page cache spills: 0
|
|
Temporary data spilled to disk: 0
|
|
Schema Heap Usage: 1696 bytes
|
|
Statement Heap/Lookaside Usage: 42944 bytes
|
|
Fullscan Steps: 12
|
|
Sort Operations: 0
|
|
Autoindex Inserts: 0
|
|
Virtual Machine Steps: 257
|
|
Reprepare operations: 0
|
|
Number of times run: 1
|
|
Memory used by prepared stmt: 42944
|
|
Bytes received by read(): 8383
|
|
Bytes sent to write(): 9384
|
|
Read() system calls: 30
|
|
Write() system calls: 7
|
|
Bytes read from storage: 0
|
|
Bytes written to storage: 0
|
|
Cancelled write bytes: 0
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
-stats
|
|
```
|
|
|