## Summary **No review yet** ## Minimized query ```sql .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); DELETE FROM v WHERE rowid = 60 RETURNING *; ``` ## Actual output ```sql 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(): 6982 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 ```sql 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(): 7758 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 ``` ```