## Summary **No review yet** ## Minimized query ```sql .system false && echo "success" || echo "error code: $?" ATTACH DATABASE '' || (':memory:') AS aux93; .read commands.sql ATTACH DATABASE ':memory:' AS aux89; BEGIN; ATTACH DATABASE '' || (':memory:') AS aux30; CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT); INSERT INTO t1 VALUES ((unixepoch('<') + upper(atan(atan2(NULL, 2147483646))) -> '$.a' -> '$.b'), 'Wernher', 10, 100); INSERT INTO t1 VALUES (2, 'von', 20, 200); INSERT INTO t1 VALUES (3, 'Braun', 30, 300); CREATE INDEX t1bc ON t1(b, c); PRAGMA writable_schema = ON; .imposter t1bc t2 WITH _m AS MATERIALIZED (WITH _m AS MATERIALIZED (SELECT * FROM T2) SELECT * FROM t2) SELECT * FROM _m; SELECT b, c FROM t1 ORDER BY b, c; .quit .save output.db PRAGMA cell_size_check = TRUE; .timeout -log(('#' || ''), 9223372036854775809) CREATE TABLE T ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (nullif(CAST(unixepoch(jsonb_replace(1, '$.key', 1)) AS REAL), 'same'),'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) > 5 AND ABS(d) > 5; CREATE TABLE t1(a INTEGER /* .schema !@#$%^&*()qwertyuiop[]\{}|asdfghjkl;':"zxcvbnm,./<>? */ PRIMARY KEY,R); CREATE TABLE main.t2(x UNIQUE); CREATE VIEW v1a(z,y) AS SELECT x IS NULL, x FROM t2; SELECT a,(+a)b,(+a)b,(+a)b,NOT EXISTS(SELECT null FROM t2),CASE z WHEN max(json_type(487, '$.key'), 487) THEN 992 WHEN 391 THEN 203 WHEN 10 THEN '?k 0; WITH cte AS (SELECT COUNT(*) AS cnt FROM t2) SELECT * FROM cte WHERE cnt > 0; SELECT * FROM t2 WHERE NOT EXISTS (SELECT 1 FROM t2 t2 WHERE t2.x = t2.x); DELETE FROM t2 WHERE x IS NULL; DROP INDEX IF /**/ EXISTS t1; ALTER TABLE t2 RENAME TO t2_r4197; ALTER TABLE T RENAME COLUMN d TO d_r7054; ALTER TABLE T RENAME COLUMN d TO d_r437; PRAGMA vdbe_debug = 0; CREATE TABLE T ( a TEXT, b REAL ); INSERT INTO T VALUES ('a',100.0), ('b',-200.5), ('c',9e999); SELECT a,b, LEAD(b,1) OVER (ORDER BY b DESC) AS c, NTILE(2) OVER (ORDER BY b DESC) AS d FROM T; PRAGMA fullsync = 1; INSERT INTO t2 SELECT * FROM t2; DETACH DATABASE aux30; WITH cte AS (SELECT x, COUNT(*) AS cnt FROM t2 GROUP BY x) SELECT * FROM cte WHERE cnt > 1; ROLLBACK; SELECT LEAD(a, 2) OVER (ORDER BY a RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; DROP VIEW IF EXISTS t1; ALTER TABLE T ADD COLUMN extra_8461 DOUBLE; WITH cte AS (SELECT a, LEAD(a) OVER (ORDER BY a) AS nxt FROM T) SELECT * FROM cte; SELECT COUNT(*) FROM T; PRAGMA incremental_vacuum(100); SELECT * FROM t1; ALTER TABLE t2 RENAME TO t2_r9528; ALTER TABLE T RENAME COLUMN a TO a_r6338; ALTER TABLE T ADD COLUMN extra_6788 REAL DEFAULT (random()); WITH RECURSIVE empty(x) AS (SELECT 1 WHERE 1=0 UNION ALL SELECT x+1 FROM empty WHERE x<10) SELECT * FROM empty; DETACH DATABASE aux89; SELECT AVG(b) FROM T; SELECT COUNT(*) FILTER (WHERE a IS NOT NULL), SUM(rowid) FILTER (WHERE a > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(a) FILTER (WHERE a > 0 AND a < 100), COUNT(*) FILTER (WHERE typeof(a) = "text") FROM t1; CREATE INDEX IF NOT EXISTS idx_T_6367 ON T(lower(a)) WHERE a > 0; ALTER TABLE T DROP COLUMN a; CREATE TEMPORARY VIEW IF NOT EXISTS v_t2_6594 AS SELECT x FROM t2; SELECT * FROM T2; INSERT OR ABORT INTO T VALUES (0, 10); WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<39) SELECT SUM(x) FROM cnt; DETACH DATABASE aux93; INSERT INTO T DEFAULT VALUES; INSERT INTO T1 DEFAULT VALUES; WITH cte AS (SELECT X FROM T1) SELECT * FROM cte; ANALYZE t2; CREATE TRIGGER IF NOT EXISTS trg_T_9024 BEFORE INSERT ON T FOR EACH ROW BEGIN SELECT RAISE(IGNORE); END; ALTER TABLE T2 RENAME COLUMN A TO A_r1186; ALTER TABLE T2 RENAME COLUMN Y TO Y_r3199; CREATE TEMP VIEW IF NOT EXISTS v_T1_1029 AS SELECT A FROM T1; REINDEX; CREATE TEMP VIEW IF NOT EXISTS v_t1_2900 AS SELECT a FROM t1; CREATE TRIGGER IF NOT EXISTS trg_T2_5344 AFTER INSERT ON T2 FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'abort'); END; INSERT INTO T VALUES (NULL, NULL); CREATE UNIQUE INDEX IF NOT EXISTS idx_t2_702 ON t2(x); ALTER TABLE T RENAME COLUMN b TO b_r7668; ``` ## Actual output ```sql error code: 1 Memory Used: 79920 (max 79920) bytes Number of Outstanding Allocations: 158 (max 158) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 82) Successful lookaside attempts: 145 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 bytes Statement Heap/Lookaside Usage: 3040 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3040 Bytes received by read(): 14557 Bytes sent to write(): 14 Read() system calls: 21 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1 Memory Used: 79920 (max 79960) bytes Number of Outstanding Allocations: 158 (max 159) Number of Pcache Overflow Bytes: 16928 (max 16928) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 82) Successful lookaside attempts: 159 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18496 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1104 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 4 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 14663 Bytes sent to write(): 1309 Read() system calls: 24 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 92136 (max 92136) bytes Number of Outstanding Allocations: 175 (max 175) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 41 (max 82) Successful lookaside attempts: 216 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27744 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 7 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 14761 Bytes sent to write(): 2607 Read() system calls: 27 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 92136 (max 92136) bytes Number of Outstanding Allocations: 175 (max 175) Number of Pcache Overflow Bytes: 25392 (max 25392) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 82) Successful lookaside attempts: 219 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27744 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1472 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(): 14859 Bytes sent to write(): 3903 Read() system calls: 29 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 104352 (max 104352) bytes Number of Outstanding Allocations: 192 (max 192) Number of Pcache Overflow Bytes: 33856 (max 33856) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 43 (max 84) Successful lookaside attempts: 284 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 36992 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1840 bytes Statement Heap/Lookaside Usage: 3040 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3040 Bytes received by read(): 14957 Bytes sent to write(): 5199 Read() system calls: 31 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 117264 (max 122944) bytes Number of Outstanding Allocations: 218 (max 229) Number of Pcache Overflow Bytes: 42320 (max 42320) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 92) Successful lookaside attempts: 359 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41336 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2192 bytes Statement Heap/Lookaside Usage: 2464 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2464 Bytes received by read(): 15311 Bytes sent to write(): 6498 Read() system calls: 34 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114824 (max 122944) bytes Number of Outstanding Allocations: 207 (max 229) Number of Pcache Overflow Bytes: 42320 (max 42320) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 55 (max 93) Successful lookaside attempts: 425 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41336 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2216 bytes Statement Heap/Lookaside Usage: 5648 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5648 Bytes received by read(): 15409 Bytes sent to write(): 7797 Read() system calls: 36 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114824 (max 122944) bytes Number of Outstanding Allocations: 207 (max 229) Number of Pcache Overflow Bytes: 42320 (max 42320) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 45 (max 93) Successful lookaside attempts: 447 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41336 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2216 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 15507 Bytes sent to write(): 9096 Read() system calls: 38 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 114824 (max 122944) bytes Number of Outstanding Allocations: 207 (max 229) Number of Pcache Overflow Bytes: 42320 (max 42320) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 45 (max 93) Successful lookaside attempts: 469 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41336 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2216 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 15605 Bytes sent to write(): 10395 Read() system calls: 40 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 122232 (max 132024) bytes Number of Outstanding Allocations: 227 (max 239) Number of Pcache Overflow Bytes: 46680 (max 46680) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 36 (max 96) Successful lookaside attempts: 549 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45680 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2416 bytes Statement Heap/Lookaside Usage: 2768 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2768 Bytes received by read(): 15704 Bytes sent to write(): 11695 Read() system calls: 42 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 119392 (max 132024) bytes Number of Outstanding Allocations: 210 (max 239) Number of Pcache Overflow Bytes: 46680 (max 46680) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 39 (max 96) Successful lookaside attempts: 554 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45680 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2416 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 4 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 15804 Bytes sent to write(): 12996 Read() system calls: 44 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; WARNING: writing to an imposter table will corrupt the "t1bc" index! Braun|30|3 Wernher|10|1 von|20|2 Memory Used: 119952 (max 218680) bytes Number of Outstanding Allocations: 220 (max 239) Number of Pcache Overflow Bytes: 46680 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 55 (max 104) Successful lookaside attempts: 732 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45680 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2960 bytes Statement Heap/Lookaside Usage: 10880 bytes Fullscan Steps: 4 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 47 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 10880 Bytes received by read(): 15904 Bytes sent to write(): 14447 Read() system calls: 46 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Braun|30 Wernher|10 von|20 Memory Used: 119976 (max 218680) bytes Number of Outstanding Allocations: 221 (max 239) Number of Pcache Overflow Bytes: 46680 (max 54888) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 49 (max 104) Successful lookaside attempts: 771 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45680 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 2984 bytes Statement Heap/Lookaside Usage: 4752 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 19 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4752 Bytes received by read(): 16004 Bytes sent to write(): 15784 Read() system calls: 48 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql error code: 1 Memory Used: 80568 (max 80568) bytes Number of Outstanding Allocations: 168 (max 168) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 93) Successful lookaside attempts: 151 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 bytes Statement Heap/Lookaside Usage: 3040 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3040 Bytes received by read(): 15333 Bytes sent to write(): 14 Read() system calls: 22 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 1 Memory Used: 80568 (max 80600) bytes Number of Outstanding Allocations: 168 (max 169) Number of Pcache Overflow Bytes: 16944 (max 16944) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 93) Successful lookaside attempts: 165 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 18512 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: 944 bytes Statement Heap/Lookaside Usage: 2784 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2784 Bytes received by read(): 15439 Bytes sent to write(): 1347 Read() system calls: 25 Write() system calls: 2 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 92720 (max 92720) bytes Number of Outstanding Allocations: 185 (max 185) Number of Pcache Overflow Bytes: 25416 (max 25416) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 57 (max 93) Successful lookaside attempts: 217 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27768 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: 1256 bytes Statement Heap/Lookaside Usage: 2912 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 8 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2912 Bytes received by read(): 15537 Bytes sent to write(): 2683 Read() system calls: 28 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 92720 (max 92720) bytes Number of Outstanding Allocations: 185 (max 185) Number of Pcache Overflow Bytes: 25416 (max 25416) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 54 (max 93) Successful lookaside attempts: 220 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 27768 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: 1256 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(): 15635 Bytes sent to write(): 4018 Read() system calls: 30 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 104872 (max 104872) bytes Number of Outstanding Allocations: 202 (max 202) Number of Pcache Overflow Bytes: 33888 (max 33888) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 59 (max 95) Successful lookaside attempts: 280 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 37024 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: 1568 bytes Statement Heap/Lookaside Usage: 3040 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 10 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3040 Bytes received by read(): 15733 Bytes sent to write(): 5353 Read() system calls: 32 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 117552 (max 123184) bytes Number of Outstanding Allocations: 228 (max 239) Number of Pcache Overflow Bytes: 42352 (max 42352) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 101) Successful lookaside attempts: 348 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41376 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: 1840 bytes Statement Heap/Lookaside Usage: 2352 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2352 Bytes received by read(): 15831 Bytes sent to write(): 6691 Read() system calls: 34 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 115208 (max 123184) bytes Number of Outstanding Allocations: 217 (max 239) Number of Pcache Overflow Bytes: 42352 (max 42352) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 71 (max 105) Successful lookaside attempts: 414 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41376 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1848 bytes Statement Heap/Lookaside Usage: 13152 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 30 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 13152 Bytes received by read(): 15929 Bytes sent to write(): 8030 Read() system calls: 36 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 115208 (max 123184) bytes Number of Outstanding Allocations: 217 (max 239) Number of Pcache Overflow Bytes: 42352 (max 42352) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 61 (max 105) Successful lookaside attempts: 436 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41376 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1848 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 16027 Bytes sent to write(): 9371 Read() system calls: 38 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 115208 (max 123184) bytes Number of Outstanding Allocations: 217 (max 239) Number of Pcache Overflow Bytes: 42352 (max 42352) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 61 (max 105) Successful lookaside attempts: 458 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 41376 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 1848 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 16 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 16125 Bytes sent to write(): 10710 Read() system calls: 40 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 122424 (max 132152) bytes Number of Outstanding Allocations: 235 (max 247) Number of Pcache Overflow Bytes: 46720 (max 46720) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 52 (max 105) Successful lookaside attempts: 531 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45728 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: 2056 bytes Statement Heap/Lookaside Usage: 2576 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2576 Bytes received by read(): 16224 Bytes sent to write(): 12050 Read() system calls: 42 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Memory Used: 119784 (max 132152) bytes Number of Outstanding Allocations: 220 (max 247) Number of Pcache Overflow Bytes: 46720 (max 46720) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 55 (max 105) Successful lookaside attempts: 536 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45728 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: 2056 bytes Statement Heap/Lookaside Usage: 2528 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 5 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 2528 Bytes received by read(): 16324 Bytes sent to write(): 13391 Read() system calls: 44 Write() system calls: 11 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID; Braun|30|3 Wernher|10|1 von|20|2 Memory Used: 120264 (max 219128) bytes Number of Outstanding Allocations: 230 (max 247) Number of Pcache Overflow Bytes: 46720 (max 54920) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 66 (max 116) Successful lookaside attempts: 703 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45728 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: 2536 bytes Statement Heap/Lookaside Usage: 11312 bytes Fullscan Steps: 4 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 49 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 11312 Bytes received by read(): 16424 Bytes sent to write(): 14813 Read() system calls: 46 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Braun|30 Wernher|10 von|20 Memory Used: 120272 (max 219128) bytes Number of Outstanding Allocations: 231 (max 247) Number of Pcache Overflow Bytes: 46720 (max 54920) bytes Largest Allocation: 87360 bytes Largest Pcache Allocation: 4368 bytes Lookaside Slots Used: 63 (max 116) Successful lookaside attempts: 740 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 45728 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Temporary data spilled to disk: 0 Schema Heap Usage: 2544 bytes Statement Heap/Lookaside Usage: 4496 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 19 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4496 Bytes received by read(): 16524 Bytes sent to write(): 16189 Read() system calls: 48 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Flag ``` -stats ```