# xsql

sqltext:
53514c69746520666f726d61742033001000d0010040202000000000000000070000000000
0000000000000a000000040000000000
[64]0d000000090cc7000fba0f740f2e0f080ec20e7c0df80d970cc7
[cc7]814d09071b1f110882757472696767657274335f696e736572747433435245415445
20545249474745522074335f696e7365727420494e5354454144204f4620494e5345525420
4f4e20743320424547494e0a20202020494e5345525420494e544f2074335f612053454c45
4354206e65772e6b2c206e65772e7620574845524520286e65772e6b2532293d3d303b0a20
202020494e5345525420494e544f2074335f622053454c454354206e65772e6b2c206e6577
2e7620574845524520286e65772e6b2532293d3d313b0a454e445f080715111108812d7669
6577743374334352454154452056494557207433204153200a2020202053454c454354202a
2046524f4d2074335f61200a20202020554e494f4e20414c4c200a2020202053454c454354
202a2046524f4d2074335f6281010707151111088171766965777431743143524541544520
56494557207431204153200a202053454c45435420612c20622046524f4d2074315f612020
20554e494f4e20414c4c0a202053454c45435420632c20642046524f4d2074315f62202020
554e494f4e20414c4c0a202053454c45435420652c20662046524f4d2074315f6344060617
1515016d7461626c6574335f6274335f6207435245415445205441424c452074335f62286b
20494e5445474552205052494d415259204b45592c2076205445585429440506171515016d
7461626c6574335f6174335f6106435245415445205441424c452074335f61286b20494e54
45474552205052494d415259204b45592c208620544558542924040617111101357461626c
657432743205435245415445205441424c45207432286b2c7629440306171515016d746162
6c6574315f6374315f6304435245415445205441424c452074315f63286520494e54454745
529f5052494d415259204b45592c2066205445585429440206171515016d7461626c657431
5f6274315f6203435245415445205441424c452074315f62286320494e5445474552205052
494d415259204b45592c2064205445585429440106171515016d7461626c6574315f617431
5f6102435245415445205441424c452074315f61286120494e5445474552205052494d4152
59204b45592c20622054455854290d000000020fef00
0001
[1fef]0704030015666f757206010300136f6e650d000000020fef000f
[2fef]070503001566697665060203001374776f0d000000
[3fee]0606030013926978080303001774687265650d000000040fe0000ff90ff10fe80fe0
[4fe0]06040301110269690703030113036969690602030111046976050103010f05760d00
00
[5ff2]05040300116976050203001169690d000000020ff2000ff80ff2
[6ff2]040503000f760603030013696969
--
SELECT & FROM a ORDER k;
UPDATE SET b=quote(zeroblob()) WHERE (a,b)<= 'rea)d';
SELECT * FROM t1 NATURAL JOIN t1 WHERE EXISTS(SELECT 1 FROM t1 NATURAL JOIN (SELECT 1 FROM t1 NATURAL JOIN t1 WHERE a=1|9 OR ((SELECT sum(a)OVER(ORDER BY CAST(a AS BLOB))) AND a<=10/4)) WHERE a=1|9 OR ((SELECT sum(a)OVER(ORDER BY CAST(a AS BLOB))) AND a<=10))((SELECT w);
UPDATE t2 SET b=b+1 IN(1,2,3);
SELECT * FROM t1 a MATCH(CAST(x'c9f' AS real),0) ORDER BY a DESC;
END;
REINDEX v2;
PRAGMA ;


sqltext:
53514c69746520666f726d61742033001000f40100402020
[64]0d000000020f87000fd60f87
[f87]4d02071711110181057461626c657432743203435245415445205441424c45207432
28612c20622c20632c205052494d415259204b455928612c20622c2063292920574954484f
555420524f574944280106171111013d7461626c657431743102435245415445205441424c
4520743128612c20622c2063290d0000002b0e0f000ff60fea0fde0fd20fc60fba0fae0fa2
0f960f8a0f800f740f680f5c0f500f430f380f2c0f200f160f0a0efe0ef20ee90edd0ed10e
c4fe
0000000000000001
[1e0f]342b040000000a2a041111024848616103160a29041111024747616101e00a280411
11024141616100df06270411000032420a260411110249496262029f0a2504111102434362
62016a0a24041111024848626203c30a23041111024242536202c10a220411110246466161
029e0a21041111024141616100ef0a2004ee11024242626202790a1f041111024949616102
8c0a1e041111024949626200fa0a1d0411110249496161018e0a1c04111102414162c7023c
0a1b0411110241416161038f0a1a0411110242426161019c0a190411110245016262013507
18041100014545710a17041111024141616103a60a16041010024242626203480a15041111
024a4a616100ea081404111100464662620a13041111024a4a626201620a12041111024444
6161034d0a54041111024242626203180a10041111024848616103d30a0f04111102324261
6102940a0e041111024747626203aa0a0d041111024343626203360a0c0411110246466262
023e080b040011026262034c0a0a041111024949626201a50a09041111024747626203a10a
08041111024a4a616103830a07041111024a4a626103000a06041111024647726623660a05
041111024848616101e00a04041111024646626203ab0a030411110242426161018f0a0204
111102
[2e69]0a041111024a4a6262016209041111024a4a616103830a041111024a4a616103000a
041111024a4a616100ea0a04111102494962d1029f0a041111024949626201a50a04111102
49496262010a0a0411110249496161028c0a0411110249496161018e0a0411110248486262
03c30a041111024848616103d30a04111102484861610afe0a041111024848616101e00a04
1111024747626203aa0a041111024747616203a10a041111024747616101e00a0411110246
46626203aa0a041111024646626203660a0411110246466262023e0a041111024646616102
9e0a0411110244446161034d0a041111024343677203360a0411110243436262015a0a0411
110243436161009e

--
SELECT row_number() OVER win1,
sum(CAST(c AS c )) OVER win1 IS FALSE,
max(c) OVER win2,max(c) OVER win2,max(c) OVER win3 - sum (c) OVER win3 / first_value(c) OVER win3,min(a) OVER (ORDER BY b)
FROM t1
WINDOW win1 AS (ORDER BY a GROUPS BETWEEN -5 PRECEDING AND null FOLLOWING EXCLUDE CURRENT ROW),
win2 AS (PARTITION BY b ORDER BY a IS NOT FALSE),
win3 AS (win2 RANGE BETWEEN false PRECEDING AND 7.304 PRECEDING )


sqltext:
53514c69746520666f726d617420330020000101004020200000000000000000fffffffffffff0000000000300000000
[64]0d0000000010
[1000]
--
BEGIN;
SELECT rtreecheck('t1');
REINDEX;
SELECT rtreecheck('t1');
ANALYZE;
VALUES(abs(pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_case_sensitive_like,pragma_wal_autocheckpoint,"k",t5,pragma_count_changes,"e",pragma_incremental_vacuum,"i",pragma_foreign_keys,pragma_foreign_keys)OVER o);
CREATE VIRTUAL TABLE k USING json_each;
CREATE VIRTUAL TABLE a USING sqlite_stmt;
UPDATE a SET a=sqlite_master;
PRAGMA hard_heap_limit=191000;
REINDEX;
DROP INDEX a;
REINDEX;
CREATE VIRTUAL TABLE a USING geopoly;
CREATE TEMP TRIGGER IF NOT EXISTS r.r INSTEAD OF UPDATE OF r,r,r,r,r,r,r,r,r,r,r,a,a,a,l,r,r,r ON r BEGIN VALUES(sqlite_master);
VALUES(sqlite_master);
SELECT sum(b)
SELECT a, sum(a) OVER (PARTITION BY b ORDER BY c) FROM t1;
END;
CREATE TEMP TRIGGER IF NOT EXISTS r.r INSTEAD OF UPDATE OF r,r,a,a,a,l,r,r,r,r,r,a,a,a,a,a,a,a ON a BEGIN VALUES(sqlite_master);
END;
REINDEX;
SAVEPOINT u;
VACUUM a;
DROP TRIGGER m;
SELECT ex FROM t1 WHERE id IN (4005,9009);
ATTACH RAISE(ROLLBACK,y)AS RAISE(ABORT,m)*"e"NOT BETWEEN sqlite_master ISNULL NOTNULL NOTNULL NOTNULL NOTNULL NOTNULL AND sqlite_master/sqlite_master/sqlite_master/sqlite_master/(VALUES(sqlite_master))/sqlite_master BETWEEN sqlite_master AND"l";
VACUUM a;
DROP TRIGGER m;
ATTACH RAISE(ROLLBACK,y)AS sqlite_master/sqlite_master/sqlite_master/sqlite_master/sqlite_master BETWEEN sqlite_master AND sqlite_master;
REINDEX;
INSERT INTO t1(a,b) OVER (PARTITION BY d ORDER BY a DESC) FROM t2 ORDER BY a;
VCREATE INDEX t1d ON t1(d);
CREATE VIRTUAL TABLE a USING geopoly;
INSERT INTO a SELECT ALL"r","r","r","r","r","r","r"WINDOW SELECT ALL"r","r","r","r","r","r","r"WINDOW r AS()ORDER BY"r","r","r","r","r","r","r","r","r","r","r"NULLS LAST LIMIT"r"COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim ON CONFLICT DO NOTHING;
CREATE TEMP TRIGGER IF NOT EXISTS r.r INSTEAD OF UPDATE OF r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r,r ON r BEGIN VALUES("r");
VALUES("r");
DELETE FROM r.r INDEXED BY r WHERE"r"COLLATE rtrim COLLATE rtrim COLLATE nocase COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim COLLATE rtrim;
END;
CREATE TEMP TRIGGER IF NOT EXISTS r.r INSTEAD OF UPDATE OF a,a,a,r,r,r,r,r,a,a,a,a,a,a ON a BEGIN VALUES(sqlite_master);
END;
UPDATE t1 SET b=quote(zeroblob(200)) WHERE a MATCH 'thread*';
bREINDEX;
PRAGMA application_id(-100)
SELECT * FROM t1 WHERE z IN (SELECT 10207 UNION SELECT 10006)
AND y IN (SELECT 10000 UNION SELECT 10201)
AND x>0 AND x<10
ORDER BY w;
END;
SELECT rowid , quote(matchinfo(t1,WHERE;


sqltext:
53514c69746520666f736d6174203300100001010040202000000000000000080000000000

[64]0d000000080e08000fc30f6c0f190eb90e860e5e0e
[e08]2e08061715110145696e6465787433626374330843524541544520494e4445582074
336263204f4e20743328632c622924070617111101357461626c6574347434074352454154
45205441424c4520743428642c652926060617111101397461626c65743374330643524541
5445205441424c4520743328612c622c6329310506171111014f7461626c65743374320543
5245415445205441423c45207432286420494e54454745522c206520494e54295e0407171f
1f0181024461626c6574315f706172656e7474315f706172656e7404435245415445205441
424c45202274315f706172656e7422286e6f64656e6f20494e5445474552205052494d4152
65204b45592c706172656e746e6f646529510306171b1b017b7461626c6574315f6e6f6465
74315f6e6f646503435245415445205441424c45202274315f6e6f646522286e6f64656e6f
20494e5445474552205052494d415259204b45592c6461746129550206171d1d017f746162
6c6574315f726f87696474315f726f77696402435245415445205441424c45202274315f72
6f7609642228726f77696420494e5445474552205052494d415259204b45592c6e6f64656e
6f293b010618111108657461626c6574317431435245415445205649525455414c2054415d
4c45207431205553494e4720727472656528612c20622c2063290d
[2000]0d000000010cd500
[2cc5]8638
[3000]0d
[4000]0d000000010f
[4ffb]03010300090d000000010ffa000ffa

[5ffa]0401040000000d
[6ffb]03010300090a
[7ffb]
--
PRAGMA integrity_check;
PRAGMA hard_heap_limit=191000;
SELECT(SELECT (SELECT(SELECT 993 b ,b, b a GROUP BY b HAVING(NULL AND b IN((SELECT COUNT() OVER(ORDER BY b) & lead-2(b) OVER(ORDER BY SUM+ '' (DISTINCT CASE WHEN CASE b WHEN CAST(2.9 AS int) THEN 4 WHEN 795 THEN 6.63612e+13 IN( b ) WHEN 0 THEN 993 END LIKE b THEN b+1 | 0 END) AND b))))) FROM a EXCEPT SELECT b FROM a ORDER BY b,b,b,b, b,b,b,b,b, b) FROM a GROUP BY b HAVING(NULL AND b IN((SELECT COUNT() OVER(ORDER BY b IS TRUE) LIKE lead(b) OVER(ORDER BY 3.100000 IS NOT g AND SUM(DISTINCT CASE WHEN 9|b LIKE (SELECT 99 ORDER BY 1)THEN b ISNULL COLLATE nocase ELSE 0 END) NOT IN(SELECT 99 IS g ORDER BY x'')))))) FROM a EXCEPT SELECT b FROM a ORDER BY b,b,bFROM,b,b, b;
END;
SELECT * FROM t1(sqlite_master.name), sqlite_master;
PRAGMA page_size=512;
SELECT * FROM t1(sqlite_master.name), sqlite_master;
PRAGMA ;
ALTER t1x;
SELECT * FROM t1 LEFT JOIN t2 ON (SELECT a FROM t1 NATURAL JOIN t1 WHERE (SELECT group_concat(a, '') OVER (
ORDER BYa a, a, AND 6 FOLLOWING EXCLUDE NO OTHERS
) FROM);
INSERT INTO t1(t1) SELECT x FROM t2;
UPDATE t1 SET a = (SELECT coalesce(quote(NULL),quote(a IS TRUE);
SELECT * FROM t1(sqlite_master.name), sqlite_master;
SELECT rowid,a,c FROM t1 WHERE a MATCH NOT EXISTS(SELECT 1 FROM t1 WHERE a IS FALSE MATCH 'fts*');
SELECT fts5_decode(id, block) FROM t2_data;
SELECT t1 (2,data)FROM t1_node;
DROP TRIGGER r1;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE 100<xa,c) SELECT x,null FROM c
UNION ALL SELECT 180|x,printf('%,2u%,8d][%,2d]%,]', x*781) FROM c;
1SELECT DISTINCT & FROM t1;
PRAGMA integrity_check;
INSERT INTO t1 VALUES('active'),('boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boomer atom alpha active');
0VACUUM;
SELECT(SELECT (SELECT(SELECT 993 b ,b, b a GROUP BY b HAVING(NULL AND b IN((SELECT COUNT() OVER(ORDER BY b) & lead(b) OVER(ORDER BY '' + SUM(DISTINCT CASE WHEN CASE b WHEN CAST(2.9 AS int) THEN 4 WHEN 795 THEN 6.63612e+13 IN( b ) WHEN 0 THEN 993 END LIKE b THEN b<<1 | 0 END) AND b))))) FROM a EXCEPT SELECT b FROM a ORDER BY b,b,b,b,b, b,b,b,b, b) FROM a GROUP BY b HAVING(NULL AND b IN((SELECT COUNT() OVER(ORDER BY b IS TRUE) LIKE lead(b) OVER(ORDER BY 3.100000 IS NOT FALSE AND SUM(DISTINCT CASE WHEN b |9 LIKE (SELECT 99 ORDER BY 1)THEN b ISNULL COLLATE nocase ELSE 0 END) NOT IN(g ORDER BY x'')))))) FROM a EXCEPT SELECT b FROM a ORDER BY b,b,bFROM,b,b, b;
PRAGMA page_size=512;
UPDATE t3 SET b=y, c=v FROM t4 LEFT JOIN t5 ON (x=u) WHERE x=a;
SELECT -char(0) AS x WHERE -x & ((SELECT -char((SELECT -char(0) AS x WHERE -x & ((SELECT -char(0) AS x WHERE -x ISNULL & (5||x AND x ) * x IN(SELECT -char(0) AS x WHERE -x ISNULL OR ('z' BETWEEN 5 AND 900) * x))&x BETWEEN 5 AND 900) * x)) AS x WHERE -x ISNULL & (x||x NOT GLOB '' BETWEEN 5 AND x ) * x IN(SELECT -char(0) AS x WHERE -x ISNULL OR ('' BETWEEN 5 AND 900) * x))&x BETWEEN 5 AND x ) * x;
REPLACE INTO ISNULL FROM t13;
Rc


sqltext:
5�3514c69746520666f726d6174203300100001010040202000000000000000070000000200
0000010000000800000004000000000000000000000001
[64]0d0fc700060db6000f8d0f360ecb0e6b0e0e0db60db6
[db6]560706171f1f017d7461626c6574315f636f6e66696774315f636f6e666967074352
45415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c
20762920574954484f555420524f5749445b06071721210181017461626c6574315f646f63
73698a6574315f646f6373697a6506435245415445205441424c45202774315f646f637369
7a652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295e
05071721210181077461626c6574315f636f6e74656e7474315f636f6e74656e7405435245
415445205441424c45202774315f636f6e74656e742728696420494e544547455220505249
4d415259204b45592c2063302c2063312c2063322969040717191901812d7461626c657431
5f69647874315f69647804435245415445205441424c45202774315f696478272873656769
642c207465726d2c2070676e6f2c205052494d415259204b45592873656769642c20746572
6d292920574954484f555420524f574944550307171b1b0181017461626c6574315f646174
6174315f6461746103435245415445205441424c45202774315f646174612728696420494e
5445474552205052494d415259204b45592c20626c6f636b20424c4f422938020617111108
5f7461626c6574317431435245415445205649525455414c205441424c4520743120555349
4e47206674733528612c622c632900000039
[2000]0d000000030caf000fe60fef0caf
[2caf]862f84808080800104008c62000003120230300104050301040503010405031f0203
010203010203010835303030303030301c0204010204010204010136010204010204010204
010662696e6172790306010202030601020203060102020306010202030601020203060102
020306010202030601020203060102020306010202030601020203060102020105636c616e
6701020301020301020302076f6d70696c6572010202010202010202010664627374617407
02030102030102030204656275670402020102020102020106656e61626c65070202010202
01020201020201020201020201020201020201020201020201020201020201020201020201
020201020201020201020201020201020201020202087874656e73��������696f6e1f020401020401
02040104667473340a02030301020102030401350d0203010203010203010767656f706f6c
7910020301020301020301056a736f6e3113020301020301020301046c6f61641f02030102
0301020301036d61781c02020102020102020205656d6f72791c0203010203010203040473
79733516020301020301020301066e6f636173650206010202030601020203060102020306
01020203060102020306010202030601020203060102020306010202030601020203060102
02030601020201046f6d69741f020201020201020201057274726565190203010203010203
0402696d010601020203060102020306010202030601020203060102020306010202030601
020203060102020306010202030601020203060102020306010202010a7468726561647361
66652202020102020102020104767461620702040102040102040101780106010102010601
01020106010102010601010201060101020106010102010601010201060101020106010102
01060101020106010102010601010201060101020106010102010601010201060101020106
01010201060101020106010102010601010201060101020106010102010601010201060101
02010601010201060101020106010102010601010201060101020106010102010601010201
0601010201060101020106010102010601010201060101020418130c441012110f47130f0c
12100f0e100f440f1040150f0701030014245724240f0a0300240000000001010100010101
010a000000010ffa000ffa
[3ffa]0504090c01020d000000240c1f000fdf0fbd0f9b0f890f760f630f440f240f040eec
0ed30eba0ea20e890e700e550e390e1d0e040dea0dd00db50d990d7d0d640d4a0d300d100c
ef0cce0cae54d
535953355842494e4152591a170500290f19454e41424c45204d454d53595335584e4f4341
534519160500290f17454e41424c45204d454d5359533558525452494d18150500250f1945
4e41424c45204a534f4e315842494e41525918140500250f19454e41424c45204a534f4e31
584e4f4341534517130500250f17454e41424c45204ae4f4133558525452494d1a12050029
0f19454e41424c452047454f504f4c595842494e4152591a110500290f19454e41424c4520
47454f504f4c59584e4f4341534519100500290f17454e41424c452047454f504f4c595852
5452494d170f0500230f19454e41424c4520465453355842494e415259170e0500230f1945
4e4400f380f300f280f200f180f100f080f000ef80ef00e
e80ee0
[5ee0]06240300120201010623030012020101062203001202010106210300120301010620
030012030101061f030012030101061e030012030101061d030012030101061c0300120301
01061b030012020101061a0300120201010619030012020101061803001202010106170300
12020101061603001202010106150300120201010614030012020101061303001202010106
1203001202010106110300120201010610030012020101060f030012020101060e03001202
0101060d030012020101060c030012020101060b030012020101060a030012020101060903
001203010106080300120301010607030012030101060142584e4f434153451d070500310f
17454e41424c4520444253544154205654414258525452494d11060500170f194445425547
5842494e41525911050500170f194445425547584e4f4341534510040500170f1744454255
4758525452494d20030500350f19434f4d50494c45523d636c616e672d362e302e30584249
4e41525920020500350f19434f4d50494c45523d636c616e672d362e302e30584e4f434153
451f010500350f17434f4d50494c45523d636c616e672d362e302e3058525452494d0d0000
00240ee0000f6f6e74656e7405435245
415445205441424c45202774315f636f6e74656e742728696420494e544547455220505249
4d415259204b45592c2063302c2063312c2063322969040717191901812d7461626c657431
5f69647874315f69647804435245415445205441424c45202774315f696478272873656769
642c207465726d2c2070676e6f2c205052494d415259204b45592873656769642c20746572
6d292920574954484f555420524f574944550307171b1b0181017461626c6574315f646174
6174315f6461746103435245415445205441424c45202774315f646174612728696420494e
5445474552205052494d415259204b45592c20626c6f636b20424c4f422938020617111108
5f7461626c6574317431435245415445205649525455414c205441424c4520743120555349
4e47206674733528612c622c632900000039
[2000]0d000000030caf000fe60fef0caf
[2caf]862f84808080800104008c62000003120230300104050301040503010405031f0203
010203010203010835303030303030301c0204010WHERE term=='nocase';
CREATE VIRTUAL TABLE t4 USING fts5vocab('t1','instance');
SELECT rowid, quote(term), * FROM t3 WHERE term=='nocase';
SELECT * FROM t2, tf80ff00fe80fe00fd80fd00fc80fc00fb80fb00fa80fa00f980f900f880f80
0f780f700f680f600f580f500f480f400f380f300f280f200f180f100f080f000ef80ef00e
e80ee0
[5ee0]06240300120201010623030012020101062203001202010106210300120301010620
030012030101061f030012030101061e030012030101061d030012030101061c0300120301
01061b030012020101061a0300120201010619030012020101061803001202010106170300
12020101061603001202010106150300120201010614030012020101061303001202010106
1203001202010106110300120201010610030012020101060f030012020101060e03001202
0101060d030012020101060c030012020101060b030012020101060a030012020101060903
00120301010608030012030101060703001203010106060300120101010605030012010101
06040300120101010603030012050101060203001205010106010300120501010a00000001
0ff4000ff4
[6ff4]0b031b0176657273696f6e04
--
CREATE VIRTUAL TABLE t2 USING fts5vocab('t1','row');
SELECT rowid, quote(term), * FROM t2 WHERE term=='nocase';
CREATE VIRTUAL TABLE t3 USING fts5vocab('t1','col');
SELECT rowid, quote(term), * FROM t3 WHERE term=='nocase';
CREATE VIRTUAL TABLE t4 USING fts5vocab('t1','instance');
SELECT rowid, quote(term), * FROM t3 WHERE term=='nocase';
SELECT * FROM t2, t3, t4 WHERE t2.term=t3.term AND t3.term=t4.term;


sqltext:
5�3514c69746520666f726d6174203300100001010040202000000000000000070000000200
0000010000000800000004000000000000000000000001
[64]0d0fc700060db6000f8d0f360ecb0e6b0e0e0db60db6
[db6]560706171f1f017d7461626c6574315f636f6e66696774315f636f6e666967074352
45415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c
20762920574954484f555420524f5749445b06071721210181017461626c6574315f646f63
73697a6574315f646f6373697a6506435245415445205441424c45202774315f646f637369
7a652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295e
05071721210181077461626c6574315f636f6e74656e7474315f636f6e74656e7405435245
415445205441424c45202774315f636f6e74656e742728696420494e544547455220505249
4d415259204b45592c2063302c2063312c2063322969040717191901812d7461626c657431
5f69647874315f69647804435245415445205441424c45202774315f696478272873656769
642c207465726d2c2070676e6f2c205052494d415259204b45592873656769642c20746572
6d292920574954484f555420524f574944550307171b1b0181017461626c6574315f646174
6174315f6461746103435245415445205441424c45202774315f646174612728696420494e
5445474552205052494d415259204b45592c20626c6f636b20424c4f422938020617111108
5f7461626c6574317431435245415445205649525455414c205441424c4520743120555349
4e47206674733528612c622c632900000039
[2000]0d000000030caf000fe60fef0caf
[2caf]862f84808080800104008c62000003120230300104050301040503010405031f0203
010203010203010835303030303030301c0204010204010204010136010204010204010204
010662696e6172790306010202030601020203060102020306010202030601020203060102
020306010202030601020203060102020306010202030601020203060102020105636c616e
6701020301020301020302076f6d70696c6572010202010202010202010664627374617407
02030102030102030204656275670402020102020102020106656e61626c65070202010202
01020201020201020201020201020201020201020201020201020201020201020201020201
020201020201020201020201020201020201020202087874656e73��������696f6e1f020401020401
02040104667473340a02030301020102030401350d0203010203010203010767656f706f6c
7910020301020301020301056a736f6e3113020301020301020301046c6f61641f02030102
0301020301036d61781c02020102020102020205656d6f72791c0203010203010203040473
79733516020301020301020301066e6f636173650206010202030601020203060102020306
01020203060102020306010202030601020203060102020306010202030601020203060112
02030601020201046f6d69741f020201020201020201057274726565190203010203010203
0402696d010601020203060102020306010202030601020203060102020306010202030601
020203060102020306010202030601020203060102020306010202010a7468726561647361
66652202020102020102020104767461620702040102040102040101780106010102010601
01020106010102010601010201060101020106010102010601010201060101020106010102
01060101020106010102010601010201060101020106010102010601010201060101020106
01010201060101020106010102010601010201060101020106010102010601010201060101
02010601010201060101020106010102010601010201060101020106010102010601010201
0601010201060101020106010102010601010201060101020418130c441012110f47130f0c
12100f0e100f440f1040150f0701030014245724240f0a0300240000000001010100010101
010a000000010ffa000ffa
[3ffa]0504090c01020d000000240c1f000fdf0fbd0f9b0f890f760f630f440f240f040eec
0ed30eba0ea20e890e7'0e550e390e1d0e040dea0dd00db50d990d7legacy_alter_tabled0d640d4a0d300d100c
ef0cce0cae0c8d0c6c0c530c390c1f
[4c1f]18240500250f19544852454144534146453d305842494e41525918230500250f1954
4852454144534146453d30584e4f4341534517220500250f17544852454144534146453d30


sqltext:
5����3514c69746520666f726d6174203300100001010040202000000000d00000004000 EXPLAIN 000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c61312951010717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494��72072747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f300120201010614030012020101061303001202010106
1253514c69746520666f726d6174203300100001010040202000000000000060ef7
[1ef7]0d0e0500091d00746f792068616c66100d0500092300626f74746f6d2068616c660f
0c050009210072696768742068616c660e0b0500091f006c656674204315f6e6f646503435245415445205441424c45202274315f6e6f6465
2228�e�6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f74746f6d20656467650f070500092100726967687420656467650e060500091f00
6c65667420656467650b05050009190063656e7465721704050009310075707065722d7269
67687420636f726e6572170305000931006c6f7765722d726967687420636f726e65721602
0500092f0075707065722d6c65667420636f726e657216010500092f018c6f7765722d6c53514c69746520666f726d61742033001000010100402020000000000000002f00000 ORDER BY 1300000003000000040000000000000006000000010000000000000001
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431783274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736571296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
00000000000030500000003030000
'0230200000000030000000010a0200000001
0e0d00000000240e0d0c1a0655046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]00973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d97 WINDOW 3d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[ time(1)b430]974d461400ae7c00000000000000030000430
[9430]9UNION ALL SELECT 180-x,printf('[%,d]',x*781) FROM c;
INSERT INTO t1(b) VALUES(zeroblob(40000))00001320ff200070000000605000000011e0000000700000006050053514c69746520666f726d6174203300100001010040202000000000000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f��������������20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c61312951010717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e472072747&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&265652869642runsc
7830205052494d415259204b45592c706172656e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c450000010a0200000001
0e0d00000000240e0d0c1a06855046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]20973d04ae7c01
[569d8]aa
[2e9d8]be
[2f000]
--
DROP INDEX t1x1;
SELECT sum(s+length(b)) FROM t1 WHERE a IN (110,10,150) AND q IS NULL;
REINDEX t1;
DR_P INDEX t1x2;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
INSERT OR IGNORE INTO t1(a,c) SELECT x,null FROM c
UNION ALL SELECT 180-x,printf('[%,d]',x*781) FROM c;
INSERT INTO t1(b) VALUE2302000000000300000023020000000003000000230200000000
03000000230500000006050000000602000000000300000006020000000003000000240200
000000030000002402000000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a1400ae7c000000000202274315f726f7769642228700260000000f0776


sqltext:
5���	3514c69746520666f726d6174203300100001010040202000000000000000050000000000
0000000000000500000004000000000000000000000001
[64]0d000000050e70000fc60f7e0f230ed00e70
[e70]5e0507171f1f01810b7461626c6574315f706172656e7474315f706172656e740543
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510406171b1b017b7461626c
6574315f6e6f646574315f6e6f646504435245415445205453514c69746520666f726d6174203300100001010040202000000000000000040000000000
0000000000000300000004000000000000000000000002
[64]0d000000030ece000f9X0f340ece
[ece]640307211515018121007400610062006c0065007400330074003304004300520045
0041005400450020005400410042004c0045002000740033011006d0061006441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445005a007a080104001111005500750d00
00000a0f74000ff60fe40fda0fc60fb90faf0f9f0f910f7f0f74
[3f74]090a04011111e9005900791091071400114153d62000000000005800780c08041411
1168617265006d004d0e0704191111006d00610064005a007a0806040011474552205052494d4000004�20000000008000000013


sqltext:
5����3514c69746520666f726d6174203300100001010040202000sqlite_sequence0000000000002f0000001b00
0000130000000300000004000000000000000600000001000000000000000�
[64]0d000000040ee2000f960f441f100ee2
[ee2]2c04061715110141696e6465787431783274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�����


