## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux86; PRAGMA function_list; .exit ATTACH DATABASE '' || (':memory:') AS aux5; .output PRAGMA full_column_names = unistr(NULL); .shell pwd BEGIN EXCLUSIVE; .quit PRAGMA full_column_names; PRAGMA integrity_check(load_extension(json_valid(-'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', -(-(NULL))))); PRAGMA max_page_count = 5000000; .backup CREATE TABLE t1(a DOUBLE PRECISION, b INTEGER PRIMARY KEY, c BLOB, FOREIGN KEY (b) REFERENCES t2); CREATE TABLE t2(c, d, e); insErT INTO t1 VALUES(1, 2, 3); ALTER TABLE t1 RENAME COLUMN b TO d; CREATE TABLE t3(a, b, c, d, e, f, g, h, i, j, k, l, m, FOREIGN KEY (b, c, d, e, f, g, h, i, j, k, l, m) REFERENCES main.t4); CREATE TABLE t4(x, y, z); INSERT INTO t4 VALUES(3, 2, 1); SELECT * FROM t1 WHERE NOT NOT (NOT a > /* .changes */ ALL (SELECT a FROM t1)) ; COMMIT; ALTER TABLE t4 ADD COLUMN extra_8043 CLOB COLLATE RTRIM; VACUUM; SELECT COUNT(*) FROM t3; PRAGMA foreign_keys = 1; WITH cte(a, b, c) AS (SELECT d, d, d FROM t2) SELECT a, b, c FROM cte; SELECT * FROM (SELECT * FROM (SELECT * FROM t3) AS inner1) AS inner2; SELECT STRING_AGG(x) FROM t4; WITH RECURSIVE fib(a,b,n) AS (VALUES(1,1,1) UNION ALL SELECT b, a+b, n+1 FROM fib WHERE +n<82) SELECT a, n FROM fib; PRAGMA recursive_triggers = NO; VACUUM; DELETE FROM t2 WHERE c IS NULL RETURNING *; SELECT * FROM t3 AS a JOIN t2 AS b ON a.rowid = b.rowid; INSERT INTO t3 VALUES ('x', 'x', NULL, 'x', 'x', NULL, NULL, 'x', 'x', NULL, 1, NULL, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; CREATE VIEW IF NOT EXISTS v_t3_25 AS SELECT f FROM t3; CREATE TEMPORARY VIEW IF NOT EXISTS v_t2_5761 AS SELECT d FROM t2; VACUUM; WITH RECURSIVE cnt(x) AS (VALUES(0) UNION ALL SELECT x-1 FROM cnt WHERE +x>-61) SELECT * FROM cnt; SELECT COUNT(*) FROM t2; SELECT x, (SELECT MAX(x) FROM t4) AS max_val FROM t4; ALTER TABLE t2 RENAME TO t2_r4493; REINDEX; DETACH DATABASE aux5; SELECT COUNT(*) FROM t1; VACUUM; ALTER TABLE t2 DROP COLUMN e; ALTER TABLE t1 RENAME TO t1_r2401; INSERT AND REPLACE INTO t1 VALUES ('', 'x', -7); SELECT COUNT(c) FROM t2; PRAGMA vdbe_addoptrace = 0; DROP TABLE IF EXISTS t1; SELECT LAG(z, 0, 'default') OVER (ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM t4; DELETE FROM t3 WHERE rowid = 56 RETURNING *; INSERT INTO t2 VALUES ('x', 'x', 1) ON CONFLICT(c) DO UPDATE SET c = excluded.c, d = excluded.d, e = excluded.e; UPDATE t2 SET e = NULL RETURNING *; PRAGMA function_list; .exit ATTACH DATABASE '' || (':memory:') AS aux5; .output PRAGMA full_column_names = unistr(NULL); .shell pwd BEGIN EXCLUSIVE; .quit PRAGMA full_column_names; PRAGMA integrity_check(load_extension(json_valid(-'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', -(-(0.0))))); PRAGMA max_page_count = 5000000; .backup CREATE TABLE t1(a DOUBLE PRECISION, b INTEGER PRIMARY KEY, c BLOB, FOREIGN KEY (b) REFERENCES t2); CREATE TABLE t2(c, d, e); insErT INTO t1 VALUES(1, 2, 3); ALTER TABLE t1 RENAME COLUMN b TO d; CREATE TABLE t3(a, b, c, d, e, f, g, h, i, j, k, l, m, FOREIGN KEY (b, c, d, e, f, g, h, i, j, k, l, m) REFERENCES main.t4); CREATE TABLE t4(x, y, z); INSERT INTO t4 VALUES(3, 2, 1); SELECT * FROM t1 WHERE NOT NOT (NOT a > /* .changes */ ALL (SELECT a FROM t1)) ; COMMIT; ALTER TABLE t4 ADD COLUMN extra_8043 CLOB COLLATE RTRIM; VACUUM; SELECT COUNT(*) FROM t3; PRAGMA foreign_keys = 1; WITH cte(a, b, c) AS (SELECT d, d, d FROM t2) SELECT a, b, c FROM cte; SELECT * FROM (SELECT * FROM (SELECT * FROM t3) AS inner1) AS inner2; SELECT STRING_AGG(x) FROM t4; WITH RECURSIVE fib(a,b,n) AS (VALUES(1,1,1) UNION ALL SELECT b, a+b, n+1 FROM fib WHERE +n<82) SELECT a, n FROM fib; PRAGMA recursive_triggers = NO; VACUUM; DELETE FROM t2 WHERE c IS NULL RETURNING *; SELECT * FROM t3 AS a FULL JOIN t2 AS b ON a.rowid = b.rowid; INSERT INTO t3 VALUES ('x', 'x', NULL, 'x', 'x', NULL, NULL, 'x', 'x', NULL, 1, NULL, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; CREATE VIEW IF NOT EXISTS v_t3_25 AS SELECT f FROM t3; CREATE TEMPORARY VIEW IF NOT EXISTS v_t2_5761 AS SELECT d FROM t2; VACUUM; WITH RECURSIVE cnt(x) AS (VALUES(0) UNION ALL SELECT x-1 FROM cnt WHERE x>-61) SELECT * FROM cnt; SELECT COUNT(*) FROM t2; SELECT x, (SELECT MAX(x) FROM t4) AS max_val FROM t4; ALTER TABLE t2 RENAME TO t2_r4493; REINDEX; DETACH DATABASE aux5; SELECT COUNT(*) FROM t1; VACUUM; ALTER TABLE t2 DROP COLUMN e; ALTER TABLE t1 RENAME TO t1_r2401; INSERT OR REPLACE INTO t1 VALUES ('', 'x', -7); SELECT COUNT(c) FROM t2; PRAGMA vdbe_addoptrace = 0; DROP TABLE IF EXISTS t1; SELECT LAG(z, 0, 'default') OVER (ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM t4; DELETE FROM t3 WHERE rowid = 56 RETURNING *; INSERT INTO t2 VALUES ('x', 'x', 1) ON CONFLICT(c) DO UPDATE SET c = excluded.c, d = excluded.d, e = excluded.e; UPDATE t2 SET e = NULL RETURNING *; PRAGMA function_list; .exit ATTACH DATABASE '' || (':memory:') AS aux5; .output PRAGMA full_column_names = unistr(NULL); .shell pwd BEGIN EXCLUSIVE; .quit PRAGMA full_column_names; PRAGMA integrity_check(load_extension(json_valid(-'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', -(-(0.0))))); PRAGMA max_page_count = 5000000; .backup CREATE TABLE t1(a DOUBLE PRECISION, b INTEGER PRIMARY KEY, c BLOB, FOREIGN KEY (b) REFERENCES t2); CREATE TABLE t2(c, d, e); insErT INTO t1 VALUES(1, 2, 3); ALTER TABLE t1 RENAME COLUMN b TO d; CREATE TABLE t3(a, b, c, d, e, f, g, h, i, j, k, l, m, FOREIGN KEY (b, c, d, e, f, g, h, i, j, k, l, m) REFERENCES main.t4); CREATE TABLE t4(x, y, z); INSERT INTO t4 VALUES(3, 2, 1); SELECT * FROM t1 WHERE NOT NOT (NOT a > /* .changes */ ALL (SELECT a FROM t1)) ; COMMIT; ALTER TABLE t4 ADD COLUMN extra_8043 CLOB COLLATE RTRIM; VACUUM; SELECT COUNT(*) FROM t3; PRAGMA foreign_keys = 1; WITH cte(a, b, c) AS (SELECT d, d, d FROM t2) SELECT a, b, c FROM cte; SELECT * FROM (SELECT * FROM (SELECT * FROM t3) AS inner1) AS inner2; SELECT STRING_AGG(x) FROM t4; WITH RECURSIVE fib(a,b,n) AS (VALUES(1,1,1) UNION ALL SELECT b, a+b, n+1 FROM fib WHERE +n<82) SELECT a, n FROM fib; PRAGMA recursive_triggers = NO; VACUUM; DELETE FROM t2 WHERE c IS NULL RETURNING *; SELECT * FROM t3 AS a FULL JOIN t2 AS b ON a.rowid = b.rowid; INSERT INTO t3 VALUES ('x', 'x', NULL, 'x', 'x', NULL, NULL, 'x', 'x', NULL, 1, NULL, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; CREATE VIEW IF NOT EXISTS v_t3_25 AS SELECT f FROM t3; CREATE TEMPORARY VIEW IF NOT EXISTS v_t2_5761 AS SELECT d FROM t2; VACUUM; WITH RECURSIVE cnt(x) AS (VALUES(0) UNION ALL SELECT x-1 FROM cnt WHERE x>-61) SELECT * FROM cnt; SELECT COUNT(*) FROM t2; SELECT x, (SELECT MAX(x) FROM t4) AS max_val FROM t4; ALTER TABLE t2 RENAME TO t2_r4493; REINDEX; DETACH DATABASE aux5; SELECT COUNT(*) FROM t1; VACUUM; ALTER TABLE t2 DROP COLUMN e; ALTER TABLE t1 RENAME TO t1_r2401; INSERT OR REPLACE INTO t1 VALUES ('', 'x', -7); SELECT COUNT(c) FROM t2; PRAGMA vdbe_addoptrace = 0; DROP TABLE IF EXISTS t1; SELECT LAG(z, 0, 'default') OVER (ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM t4; DELETE FROM t3 WHERE rowid = 56 RETURNING *; INSERT INTO t2 VALUES ('x', 'x', 1) ON CONFLICT(c) DO UPDATE SET c = excluded.c, d = excluded.d, e = excluded.e; UPDATE t2 SET e = NULL RETURNING *; DETACH DATABASE aux86; ALTER TABLE t4 ADD COLUMN extra_6476 INT8 DEFAULT (random()); ``` ## Actual output ```sql pow|1|s|utf8|2|2099200 group_concat|1|w|utf8|1|2097152 group_concat|1|w|utf8|2|2097152 json_type|1|s|utf8|1|2048 json_type|1|s|utf8|2|2048 julianday|1|s|utf8|-1|2099200 ntile|1|w|utf8|1|2097152 nullif|1|s|utf8|2|2099200 sqlite_compileoption_get|1|s|utf8|1|2097152 json_valid|1|s|utf8|1|2048 json_quote|1|s|utf8|1|2048 json_patch|1|s|utf8|2|2048 ->|1|s|utf8|2|2048 json_array|1|s|utf8|-1|2048 current_timestamp|1|s|utf8|0|2097152 power|1|s|utf8|2|2099200 sqlite_compileoption_used|1|s|utf8|1|2097152 json_remove|1|s|utf8|-1|2048 json_object|1|s|utf8|-1|2048 json_insert|1|s|utf8|-1|2048 ->>|1|s|utf8|2|2048 sin|1|s|utf8|1|2099200 sum|1|w|utf8|1|2097152 quote|1|s|utf8|1|2099200 printf|1|s|utf8|-1|2099200 likelihood|1|s|utf8|2|2099200 json_replace|1|s|utf8|-1|2048 json_extract|1|s|utf8|-1|2048 last_value|1|w|utf8|1|2097152 rank|1|w|utf8|0|2097152 sign|1|s|utf8|1|2099200 sqrt|1|s|utf8|1|2099200 sinh|1|s|utf8|1|2099200 tan|1|s|utf8|1|2099200 round|1|s|utf8|1|2099200 round|1|s|utf8|2|2099200 rtrim|1|s|utf8|1|2099200 rtrim|1|s|utf8|2|2099200 nth_value|1|w|utf8|2|2097152 tanh|1|s|utf8|1|2099200 random|1|s|utf8|0|2097152 trim|1|s|utf8|1|2099200 trim|1|s|utf8|2|2099200 time|1|s|utf8|-1|2099200 radians|1|s|utf8|1|2099200 trunc|1|s|utf8|1|2099200 total|1|w|utf8|1|2097152 substr|1|s|utf8|2|2099200 substr|1|s|utf8|3|2099200 replace|1|s|utf8|3|2099200 upper|1|s|utf8|1|2099200 subtype|1|s|utf8|1|2099200 typeof|1|s|utf8|1|2099200 load_extension|1|s|utf8|1|524288 load_extension|1|s|utf8|2|524288 json_group_array|1|w|utf8|1|1050624 avg|1|w|utf8|1|2097152 abs|1|s|utf8|1|2099200 json_group_object|1|w|utf8|2|1050624 json_array_length|1|s|utf8|1|2048 json_array_length|1|s|utf8|2|2048 strftime|1|s|utf8|-1|2099200 atan|1|s|utf8|1|2099200 asin|1|s|utf8|1|2099200 acos|1|s|utf8|1|2099200 unknown|1|s|utf8|-1|2099200 substring|1|s|utf8|2|2099200 substring|1|s|utf8|3|2099200 randomblob|1|s|utf8|1|2097152 unicode|1|s|utf8|1|2099200 percent_rank|1|w|utf8|0|2097152 row_number|1|w|utf8|0|2097152 atanh|1|s|utf8|1|2099200 asinh|1|s|utf8|1|2099200 acosh|1|s|utf8|1|2099200 cos|1|s|utf8|1|2099200 atan2|1|s|utf8|2|2099200 last_insert_rowid|1|s|utf8|0|2097152 sqlite_log|1|s|utf8|2|2099200 unlikely|1|s|utf8|1|2099200 cosh|1|s|utf8|1|2099200 ceil|1|s|utf8|1|2099200 char|1|s|utf8|-1|2099200 unixepoch|1|s|utf8|-1|2099200 exp|1|s|utf8|1|2099200 count|1|w|utf8|0|2097152 count|1|w|utf8|1|2097152 date|1|s|utf8|-1|2099200 sqlite_offset|1|s|utf8|1|2097152 ceiling|1|s|utf8|1|2099200 total_changes|1|s|utf8|0|2097152 changes|1|s|utf8|0|2097152 sqlite_version|1|s|utf8|0|2097152 degrees|1|s|utf8|1|2099200 floor|1|s|utf8|1|2099200 coalesce|1|s|utf8|-1|2099200 glob|1|s|utf8|2|2099200 zeroblob|1|s|utf8|1|2099200 hex|1|s|utf8|1|2099200 iif|1|s|utf8|3|2099200 sqlite_source_id|1|s|utf8|0|2097152 format|1|s|utf8|-1|2099200 datetime|1|s|utf8|-1|2099200 cume_dist|1|w|utf8|0|2097152 ln|1|s|utf8|1|2099200 instr|1|s|utf8|2|2099200 json|1|s|utf8|1|2048 dense_rank|1|w|utf8|0|2097152 log|1|s|utf8|1|2099200 log|1|s|utf8|2|2099200 ifnull|1|s|utf8|2|2099200 current_date|1|s|utf8|0|2097152 current_time|1|s|utf8|0|2097152 lag|1|w|utf8|1|2097152 lag|1|w|utf8|3|2097152 lag|1|w|utf8|2|2097152 mod|1|s|utf8|2|2099200 log2|1|s|utf8|1|2099200 like|1|s|utf8|2|2099200 like|1|s|utf8|3|2099200 max|1|s|utf8|-1|2099200 max|1|w|utf8|1|2097152 min|1|s|utf8|-1|2099200 min|1|w|utf8|1|2097152 lead|1|w|utf8|1|2097152 lead|1|w|utf8|3|2097152 lead|1|w|utf8|2|2097152 log10|1|s|utf8|1|2099200 lower|1|s|utf8|1|2099200 ltrim|1|s|utf8|1|2099200 ltrim|1|s|utf8|2|2099200 first_value|1|w|utf8|1|2097152 pi|1|s|utf8|0|2099200 length|1|s|utf8|1|2099200 likely|1|s|utf8|1|2099200 json_set|1|s|utf8|-1|2048 edit|0|s|utf8|2|0 edit|0|s|utf8|1|0 usleep|0|s|utf8|1|0 shell_idquote|0|s|utf8|1|0 shell_escape_crnl|0|s|utf8|1|0 shell_putsnl|0|s|utf8|1|0 ieee754_from_blob|0|s|utf8|1|2097152 shell_add_schema|0|s|utf8|3|0 ieee754_to_blob|0|s|utf8|1|2097152 ieee754|0|s|utf8|2|2097152 ieee754|0|s|utf8|1|2097152 shell_int32|0|s|utf8|2|0 regexp|0|s|utf8|2|2099200 ieee754_exponent|0|s|utf8|1|2097152 decimal_sub|0|s|utf8|2|2099200 decimal_cmp|0|s|utf8|2|2099200 writefile|0|s|utf8|-1|524288 lsmode|0|s|utf8|1|0 readfile|0|s|utf8|1|524288 match|0|s|utf8|2|0 fts3_tokenizer|0|s|utf8|2|524288 fts3_tokenizer|0|s|utf8|1|524288 ieee754_mantissa|0|s|utf8|1|2097152 decimal_add|0|s|utf8|2|2099200 decimal|0|s|utf8|1|2099200 snippet|0|s|utf8|-1|0 offsets|0|s|utf8|1|0 shell_module_schema|0|s|utf8|1|0 matchinfo|0|s|utf8|2|0 matchinfo|0|s|utf8|1|0 optimize|0|s|utf8|1|0 decimal_sum|0|w|utf8|1|2099200 sha3|0|s|utf8|2|2099200 sha3|0|s|utf8|1|2099200 rtreedepth|0|s|utf8|1|0 regexpi|0|s|utf8|2|2099200 decimal_mul|0|s|utf8|2|2099200 sha3_query|0|s|utf8|2|524288 sha3_query|0|s|utf8|1|524288 rtreenode|0|s|utf8|2|0 rtreecheck|0|s|utf8|-1|0 ``` ## Expectation ```sql pow|1|s|utf8|2|2099200 median|1|w|utf8|1|0 group_concat|1|w|utf8|1|2097152 group_concat|1|w|utf8|2|2097152 json_type|1|s|utf8|1|2099200 json_type|1|s|utf8|2|2099200 jsonb_set|1|s|utf8|-1|3147776 julianday|1|s|utf8|-1|2099200 ntile|1|w|utf8|1|2097152 nullif|1|s|utf8|2|2099200 sqlite_compileoption_get|1|s|utf8|1|2097152 json_valid|1|s|utf8|1|2099200 json_valid|1|s|utf8|2|2099200 json_quote|1|s|utf8|1|3147776 json_patch|1|s|utf8|2|2099200 ->|1|s|utf8|2|2099200 json_array|1|s|utf8|-1|3147776 current_timestamp|1|s|utf8|0|2097152 power|1|s|utf8|2|2099200 sqlite_compileoption_used|1|s|utf8|1|2097152 json_remove|1|s|utf8|-1|2099200 json_pretty|1|s|utf8|1|2099200 json_pretty|1|s|utf8|2|2099200 jsonb_patch|1|s|utf8|2|2099200 json_object|1|s|utf8|-1|3147776 json_insert|1|s|utf8|-1|3147776 ->>|1|s|utf8|2|2099200 jsonb_array|1|s|utf8|-1|3147776 sin|1|s|utf8|1|2099200 sum|1|w|utf8|1|2097152 quote|1|s|utf8|1|2099200 printf|1|s|utf8|-1|2099200 likelihood|1|s|utf8|2|2099200 json_replace|1|s|utf8|-1|3147776 jsonb_remove|1|s|utf8|-1|2099200 jsonb_object|1|s|utf8|-1|3147776 jsonb_insert|1|s|utf8|-1|3147776 json_extract|1|s|utf8|-1|2099200 last_value|1|w|utf8|1|2097152 rank|1|w|utf8|0|2097152 sign|1|s|utf8|1|2099200 sqrt|1|s|utf8|1|2099200 sinh|1|s|utf8|1|2099200 tan|1|s|utf8|1|2099200 round|1|s|utf8|1|2099200 round|1|s|utf8|2|2099200 rtrim|1|s|utf8|1|2099200 rtrim|1|s|utf8|2|2099200 jsonb_replace|1|s|utf8|-1|3147776 jsonb_extract|1|s|utf8|-1|2099200 nth_value|1|w|utf8|2|2097152 tanh|1|s|utf8|1|2099200 random|1|s|utf8|0|2097152 trim|1|s|utf8|1|2099200 trim|1|s|utf8|2|2099200 time|1|s|utf8|-1|2099200 radians|1|s|utf8|1|2099200 trunc|1|s|utf8|1|2099200 total|1|w|utf8|1|2097152 substr|1|s|utf8|2|2099200 substr|1|s|utf8|3|2099200 replace|1|s|utf8|3|2099200 percentile|1|w|utf8|2|0 unhex|1|s|utf8|1|2099200 unhex|1|s|utf8|2|2099200 upper|1|s|utf8|1|2099200 subtype|1|s|utf8|1|3147776 typeof|1|s|utf8|1|2099200 load_extension|1|s|utf8|1|524288 load_extension|1|s|utf8|2|524288 json_group_array|1|w|utf8|1|3147776 avg|1|w|utf8|1|2097152 unistr|1|s|utf8|1|2099200 abs|1|s|utf8|1|2099200 octet_length|1|s|utf8|1|2099200 json_group_object|1|w|utf8|2|3147776 jsonb_group_array|1|w|utf8|1|3147776 json_array_length|1|s|utf8|1|2099200 json_array_length|1|s|utf8|2|2099200 strftime|1|s|utf8|-1|2099200 atan|1|s|utf8|1|2099200 asin|1|s|utf8|1|2099200 acos|1|s|utf8|1|2099200 unknown|1|s|utf8|-1|2099200 substring|1|s|utf8|2|2099200 substring|1|s|utf8|3|2099200 randomblob|1|s|utf8|1|2097152 unicode|1|s|utf8|1|2099200 jsonb_group_object|1|w|utf8|2|3147776 timediff|1|s|utf8|2|2099200 percent_rank|1|w|utf8|0|2097152 row_number|1|w|utf8|0|2097152 atanh|1|s|utf8|1|2099200 asinh|1|s|utf8|1|2099200 acosh|1|s|utf8|1|2099200 cos|1|s|utf8|1|2099200 atan2|1|s|utf8|2|2099200 string_agg|1|w|utf8|2|2097152 last_insert_rowid|1|s|utf8|0|2097152 sqlite_log|1|s|utf8|2|2099200 unlikely|1|s|utf8|1|2099200 json_error_position|1|s|utf8|1|2099200 cosh|1|s|utf8|1|2099200 ceil|1|s|utf8|1|2099200 char|1|s|utf8|-1|2099200 unixepoch|1|s|utf8|-1|2099200 exp|1|s|utf8|1|2099200 percentile_disc|1|w|utf8|2|0 percentile_cont|1|w|utf8|2|0 count|1|w|utf8|0|2097152 count|1|w|utf8|1|2097152 date|1|s|utf8|-1|2099200 concat|1|s|utf8|-3|2099200 sqlite_offset|1|s|utf8|1|2099200 ceiling|1|s|utf8|1|2099200 total_changes|1|s|utf8|0|2097152 changes|1|s|utf8|0|2097152 unistr_quote|1|s|utf8|1|2099200 sqlite_version|1|s|utf8|0|2097152 if|1|s|utf8|-4|2099200 coalesce|1|s|utf8|-4|2099200 degrees|1|s|utf8|1|2099200 floor|1|s|utf8|1|2099200 glob|1|s|utf8|2|2099200 zeroblob|1|s|utf8|1|2099200 hex|1|s|utf8|1|2099200 iif|1|s|utf8|-4|2099200 sqlite_source_id|1|s|utf8|0|2097152 concat_ws|1|s|utf8|-4|2099200 format|1|s|utf8|-1|2099200 datetime|1|s|utf8|-1|2099200 cume_dist|1|w|utf8|0|2097152 ln|1|s|utf8|1|2099200 instr|1|s|utf8|2|2099200 json|1|s|utf8|1|2099200 dense_rank|1|w|utf8|0|2097152 log|1|s|utf8|1|2099200 log|1|s|utf8|2|2099200 ifnull|1|s|utf8|2|2099200 jsonb|1|s|utf8|1|2099200 current_date|1|s|utf8|0|2097152 current_time|1|s|utf8|0|2097152 lag|1|w|utf8|1|2097152 lag|1|w|utf8|3|2097152 lag|1|w|utf8|2|2097152 mod|1|s|utf8|2|2099200 log2|1|s|utf8|1|2099200 like|1|s|utf8|2|2099200 like|1|s|utf8|3|2099200 max|1|s|utf8|-3|2099200 max|1|w|utf8|1|2097152 min|1|s|utf8|-3|2099200 min|1|w|utf8|1|2097152 lead|1|w|utf8|1|2097152 lead|1|w|utf8|3|2097152 lead|1|w|utf8|2|2097152 log10|1|s|utf8|1|2099200 lower|1|s|utf8|1|2099200 ltrim|1|s|utf8|1|2099200 ltrim|1|s|utf8|2|2099200 first_value|1|w|utf8|1|2097152 pi|1|s|utf8|0|2099200 length|1|s|utf8|1|2099200 likely|1|s|utf8|1|2099200 json_set|1|s|utf8|-1|3147776 usleep|0|s|utf8|1|0 shell_putsnl|0|s|utf8|1|0 dtostr|0|s|utf8|2|0 dtostr|0|s|utf8|1|0 sqlar_uncompress|0|s|utf8|2|2097152 sqlar_compress|0|s|utf8|1|2097152 zipfile|0|a|utf8|-1|0 lsmode|0|s|utf8|1|0 writefile|0|s|utf8|-1|524288 readfile|0|s|utf8|1|524288 ieee754_from_blob|0|s|utf8|1|2097152 offsets|0|s|utf8|1|0 decimal_cmp|0|s|utf8|2|2099200 fts3_tokenizer|0|s|utf8|2|524288 fts3_tokenizer|0|s|utf8|1|524288 decimal|0|s|utf8|1|2099200 sha1b|0|s|utf8|1|2099200 zipfile_cds|0|s|utf8|-1|0 decimal_mul|0|s|utf8|2|2099200 matchinfo|0|s|utf8|2|0 matchinfo|0|s|utf8|1|0 ieee754_inc|0|s|utf8|2|2097152 optimize|0|s|utf8|1|0 rtreedepth|0|s|utf8|1|0 ieee754_mantissa|0|s|utf8|1|2097152 rtreenode|0|s|utf8|2|0 shell_add_schema|0|s|utf8|3|0 strtod|0|s|utf8|1|0 rtreecheck|0|s|utf8|-1|0 shell_module_schema|0|s|utf8|1|0 match|0|s|utf8|2|0 sha1|0|s|utf8|1|2099200 sha1_query|0|s|utf8|1|524288 sha3|0|s|utf8|2|2099200 sha3|0|s|utf8|1|2099200 sha3_agg|0|a|utf8|2|2099200 sha3_agg|0|a|utf8|1|2099200 ieee754_exponent|0|s|utf8|1|2097152 ieee754|0|s|utf8|2|2097152 ieee754|0|s|utf8|1|2097152 decimal_sub|0|s|utf8|2|2099200 regexpi|0|s|utf8|2|2099200 sha3_query|0|s|utf8|2|524288 sha3_query|0|s|utf8|1|524288 stmtrand|0|s|utf8|0|0 stmtrand|0|s|utf8|1|0 decimal_exp|0|s|utf8|1|2099200 ieee754_to_blob|0|s|utf8|1|2097152 base85|0|s|utf8|1|2623488 decimal_add|0|s|utf8|2|2099200 edit|0|s|utf8|2|0 edit|0|s|utf8|1|0 decimal_pow2|0|s|utf8|1|2099200 base64|0|s|utf8|1|2623488 snippet|0|s|utf8|-1|0 decimal_sum|0|w|utf8|1|2099200 regexp|0|s|utf8|2|2099200 ``` ## Flag ``` ```