## Summary **No review yet** ## Minimized query ```sql PRAGMA secure_delete = TRUE; .stats stmt SAVEPOINT sp4970; .scanstats on DROP TABLE IF EXISTS t0; CREATE TABLE t0(c0 REAL UNIQUE); INSERT INTO t0(c0) VALUES (0.0); SELECT 3175546974276630385 < c0 FROM t0; SELECT 1 FROM t0 WHERE NOT NOT /**/ (3175546974276630385 < c0) ; ALTER TABLE t0 ADD COLUMN extra_80 DOUBLE COLLATE NOCASE; ANALYZE t0; REINDEX t0; SELECT STRING_AGG(c0, '|') FROM t0; RELEASE sp4970; ALTER TABLE t0 ADD COLUMN extra_3988 TEXT NOT NULL DEFAULT 0; ALTER TABLE t0 ADD COLUMN extra_7474 DOUB DEFAULT 0; SELECT LEAD(c0, 0, 'default') OVER (ORDER BY c0 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM t0; ALTER TABLE t0 RENAME COLUMN c0 TO c0_r7017; ``` ## Actual output ```sql 1 Number of output columns: 0 Memory Used: 62592 (max 62632) bytes Number of Outstanding Allocations: 122 (max 123) Number of Pcache Overflow Bytes: 4104 (max 4104) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4104 bytes Lookaside Slots Used: 37 (max 38) Successful lookaside attempts: 45 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: 2656 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: 2656 Bytes received by read(): 6984 Bytes sent to write(): 2 Read() system calls: 13 Write() system calls: 1 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 67704 (max 67704) bytes Number of Outstanding Allocations: 141 (max 141) Number of Pcache Overflow Bytes: 8464 (max 8464) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 37 (max 75) Successful lookaside attempts: 100 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 9248 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 736 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 7078 Bytes sent to write(): 1375 Read() system calls: 15 Write() system calls: 3 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 86624 (max 92512) bytes Number of Outstanding Allocations: 172 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 33 (max 91) Successful lookaside attempts: 177 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 4 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1168 bytes Statement Heap/Lookaside Usage: 4040 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: 4040 Bytes received by read(): 7431 Bytes sent to write(): 2705 Read() system calls: 18 Write() system calls: 4 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 82608 (max 92512) bytes Number of Outstanding Allocations: 156 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 47 (max 91) Successful lookaside attempts: 205 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1192 bytes Statement Heap/Lookaside Usage: 3808 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 17 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3808 Bytes received by read(): 7528 Bytes sent to write(): 4040 Read() system calls: 20 Write() system calls: 5 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0 Number of output columns: 1 Column 0 name: 3175546974276630385 < c0 Column 0 declared type: (null) Memory Used: 82608 (max 92512) bytes Number of Outstanding Allocations: 156 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 91) Successful lookaside attempts: 230 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1192 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 14 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 7625 Bytes sent to write(): 5375 Read() system calls: 22 Write() system calls: 6 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 1 Column 0 name: 1 Column 0 declared type: (null) Memory Used: 82608 (max 92512) bytes Number of Outstanding Allocations: 156 (max 181) Number of Pcache Overflow Bytes: 21288 (max 21288) bytes Largest Allocation: 48000 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 91) Successful lookaside attempts: 257 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 1 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1192 bytes Statement Heap/Lookaside Usage: 3296 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 11 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3296 Bytes received by read(): 7722 Bytes sent to write(): 6818 Read() system calls: 24 Write() system calls: 7 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 87128 (max 191616) bytes Number of Outstanding Allocations: 181 (max 220) Number of Pcache Overflow Bytes: 21288 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 33 (max 91) Successful lookaside attempts: 328 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 17936 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1184 bytes Statement Heap/Lookaside Usage: 4528 bytes Fullscan Steps: 1 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 51 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4528 Bytes received by read(): 7819 Bytes sent to write(): 8236 Read() system calls: 26 Write() system calls: 8 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 92080 (max 191616) bytes Number of Outstanding Allocations: 188 (max 220) Number of Pcache Overflow Bytes: 25648 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 92) Successful lookaside attempts: 445 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 6 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1496 bytes Statement Heap/Lookaside Usage: 5944 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 50 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 5944 Bytes received by read(): 7916 Bytes sent to write(): 9572 Read() system calls: 28 Write() system calls: 9 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 87280 (max 191616) bytes Number of Outstanding Allocations: 164 (max 220) Number of Pcache Overflow Bytes: 25648 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 42 (max 92) Successful lookaside attempts: 461 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 3 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1496 bytes Statement Heap/Lookaside Usage: 3168 bytes Fullscan Steps: 0 Sort Operations: 1 Autoindex Inserts: 0 Virtual Machine Steps: 24 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 3168 Bytes received by read(): 8013 Bytes sent to write(): 10908 Read() system calls: 30 Write() system calls: 10 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 85672 (max 191616) bytes Number of Outstanding Allocations: 161 (max 220) Number of Pcache Overflow Bytes: 25648 (max 29496) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 38 (max 92) Successful lookaside attempts: 480 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 0 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1496 bytes Statement Heap/Lookaside Usage: 2656 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: 2656 Bytes received by read(): 8112 Bytes sent to write(): 12364 Read() system calls: 32 Write() system calls: 12 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 90456 (max 194776) bytes Number of Outstanding Allocations: 189 (max 228) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 92) Successful lookaside attempts: 583 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1720 bytes Statement Heap/Lookaside Usage: 4560 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4560 Bytes received by read(): 8211 Bytes sent to write(): 13701 Read() system calls: 34 Write() system calls: 13 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 90536 (max 194856) bytes Number of Outstanding Allocations: 191 (max 234) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 34 (max 92) Successful lookaside attempts: 686 Lookaside failures due to size: 0 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 5 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1832 bytes Statement Heap/Lookaside Usage: 4528 bytes Fullscan Steps: 2 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 56 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 4528 Bytes received by read(): 8310 Bytes sent to write(): 15039 Read() system calls: 36 Write() system calls: 14 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 0.0 Number of output columns: 1 Column 0 name: LEAD(c0, 0, 'default') OVER (ORDER BY c0 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) Column 0 declared type: (null) Memory Used: 90096 (max 194856) bytes Number of Outstanding Allocations: 168 (max 234) Number of Pcache Overflow Bytes: 25648 (max 33856) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 48 (max 92) Successful lookaside attempts: 755 Lookaside failures due to size: 2 Lookaside failures due to OOM: 0 Pager Heap Usage: 22280 bytes Page cache hits: 2 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1856 bytes Statement Heap/Lookaside Usage: 6800 bytes Fullscan Steps: 0 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 61 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 6800 Bytes received by read(): 8409 Bytes sent to write(): 16377 Read() system calls: 38 Write() system calls: 15 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 Number of output columns: 0 Memory Used: 204224 (max 678776) bytes Number of Outstanding Allocations: 244 (max 348) Number of Pcache Overflow Bytes: 33856 (max 66688) bytes Largest Allocation: 87200 bytes Largest Pcache Allocation: 4360 bytes Lookaside Slots Used: 101 (max 123) Successful lookaside attempts: 1093 Lookaside failures due to size: 5 Lookaside failures due to OOM: 299 Pager Heap Usage: 31496 bytes Page cache hits: 14 Page cache misses: 0 Page cache writes: 0 Page cache spills: 0 Schema Heap Usage: 1856 bytes Statement Heap/Lookaside Usage: 51664 bytes Fullscan Steps: 8 Sort Operations: 0 Autoindex Inserts: 0 Virtual Machine Steps: 192 Reprepare operations: 0 Number of times run: 1 Memory used by prepared stmt: 51664 Bytes received by read(): 8508 Bytes sent to write(): 17891 Read() system calls: 41 Write() system calls: 16 Bytes read from storage: 0 Bytes written to storage: 0 Cancelled write bytes: 0 ``` ## Expectation ```sql ``` ## Flag ``` ```