ast-project/part1/results/1/bug_7805d638-0498-4c52-baea-6f0de1a63115_logic.md

Summary

**No review yet**

Minimized query

.scanstats off
PRAGMA full_column_names = NO;
PRAGMA encoding;
PRAGMA fullsync = YES;
.stats
CREATE TABLE "v"(b, d, e);
CREATE TABLE u(a, b, c);
ANALYZE sqlite_master;
INSERT INTO "sqlite_stat1" VALUES('u','uab','40000 400 1');
INSERT INTO "sqlite_stat1" VALUES('v','vbde','40000 400 1 1');
INSERT INTO "sqlite_stat1" VALUES('v','ve','40000 21');
CREATE INDEX uab on u(a, b);
CREATE INDEX ve on v(e);
CREATE INDEX vbde on v(b,d,e);
DROP TABLE IF EXISTS sqlite_stat4;
ANALYZE sqlite_master;

ALTER TABLE u ADD COLUMN extra_8479 DATETIME DEFAULT (random());
REINDEX v;
SELECT * FROM u WHERE b = (SELECT GROUP_CONCAT(b) FROM u);

Actual output

UTF-8
Memory Used:                         67704 (max 67744) bytes
Number of Outstanding Allocations:   141 (max 142)
Number of Pcache Overflow Bytes:     8464 (max 8464) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4360 bytes
Lookaside Slots Used:                32 (max 76)
Successful lookaside attempts:       96
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    9248 bytes
Page cache hits:                     0
Page cache misses:                   0
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   736 bytes
Statement Heap/Lookaside Usage:      0 bytes
Bytes received by read():            6938
Bytes sent to write():               55
Read() system calls:                 13
Write() system calls:                2
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0

Expectation

UTF-8
Memory Used:                         68416 (max 68448) bytes
Number of Outstanding Allocations:   151 (max 152)
Number of Pcache Overflow Bytes:     8472 (max 8472) bytes
Largest Allocation:                  48000 bytes
Largest Pcache Allocation:           4368 bytes
Lookaside Slots Used:                48 (max 87)
Successful lookaside attempts:       107
Lookaside failures due to size:      0
Lookaside failures due to OOM:       0
Pager Heap Usage:                    9256 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:                   632 bytes
Statement Heap/Lookaside Usage:      0 bytes
Bytes received by read():            7714
Bytes sent to write():               55
Read() system calls:                 14
Write() system calls:                2
Bytes read from storage:             0
Bytes written to storage:            0
Cancelled write bytes:               0

Flag