# xsql

sqltext:
53514c69746520666f726d61742033001000010100402020000000000000002f0000001b00
00001300000003000000040000000000000006000000010000000000000001
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431783274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736571296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
00000001000000000100000000021000000005000000030200000000050000000302000000
00050000000302000000000500000003020000000005000000030200000000050000000302
00000000050000000302000000000500000003020000000005000000030500000003030000
00230200000000030000002302000000000300000023020000000003000000230200000000
03000000230500000006050000000602000000000300000006020000000003000000240200
000000030000002402000000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a1400ae7c00000000000000000000000000000009
[2fa0]0fac0006000000000030
[2fd3]16812a000000148116000000128102000000106e0000000e5a0000000c460000000a
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff90feb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000001320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a0655046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9100]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[b430]974d461400ae7c00000000000000000000000000000001
[bfff]07
[d000]0d000000010430000430
[d430]974d5a1400ae7c00000000000000000000000000000001
[dfff]09
[f000]0d000000010430000430
[f430]974d6e1400ae7c00000000000000000000000000000001
[ffff]0b
[11000]0d00000001042f00042f
[1142f]974d81021400ae7c00000000000000000000000000000001
[11fff]0d
[13000]0d00000001042f00042f
[1342f]974d81161400ae7c00000000000000000000000000000001
[13fff]0f
[15000]0d00000001042f00042f
[1542f]974d812a1400ae7c00000000000000000000000000000001
[15fff]11
[17000]0d000000010431000431
[17431]974c0a1400ae7c00000000000000000000000000000009
[18000]0d00000001042f00042f
[1842f]974d813e1400ae7c00000000000000000000000000000001
[18fff]13
[199d7]0a
[1a007]12000000070000001d000000090000001f0000000b000000210000000d0000002500
00000f000000190000001100000029000000130000002b000000150000002d0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502770466008800880088
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655027704660e110088008800880e11
[23088]047601ef
[23277]973e04ae7c02
[23465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259d7]6e
[279d8]82
[299d8]96
[2b9d8]aa
[2e9d8]be
[2f000]
--
DROP INDEX t1x1;
DELETE FROM t1 WHERE a MATCH 'f*';
);
SELECT sum(s GLOB length(b)) FROM t1 WHERE a IN (110,10,150) AND q IS NULL;
SELECT a,b,c,d,'|' FROM t1 WHERE c=6 ORDER BY a, b, c;
UPDATE t1 SET (c,d)=(a,b);
SELECT sum( t1 (name)) FROM dbstat;
INSERT INTO t1(b) VALUES(zeroblob(40000));
CREATE INDEX x2 ON t1(c);
VACUUM;
SELECT * FROM c1 ORDER BY a;
BY c ORDER BY a) AS z
FROM t2 ORDER BY a;
SELECT a,b,cFROM t1 WHERE c=6 ORDER BY a, b, c;
SELECT rtreecheck('t1t');
('fncy-%s', ex) WHERE x0>=4 AND x1<=8 AND y0>=4 AND y0<2511;
ALTER TABLE t1 ADD COLUMN hh TEXT DEFAULT 'xyz';
DROP INDEX t1x2;
REPLACE INTO t3(m)SELECT x FROM t1 WHERE y LIKE 'RT%' ESCAPE '\';
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) VALUES(zeroblob(40000));
SELECT 1 WHERE (5, 4) IN (SELECT +b, +a FROM t1);
INSERT INTO t1(b) VALUES(zeroblob(40000));
UPDATE t1 SET (c,d));
SELECT x'1f70d1' WHERE (5, 4) IN (SELECT a, b FROM t1);
SELECT sum(s GLOB length(b)) FROM t1 WHERE a IN (110,10,150) AND q IS NULL;
INSERT INTO t3 SELECT * FROM t2;


sqltext:
53514c69746520666f726d61742033001000010100402020000000000000002f0000001b00
00001300000003000000040000000000000006000000010000000000000001
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431783274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736571296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
00000101000000000100000000020000000005000000030200000000050000000302000000
00050000000302000000000500000003020000000005000000030200000000050000000302
00000000050000000302000000000500000003020000000005000000030500000003030000
00230200000000030000002302001000000300000023020000000003000000230200000000
03000000230500000006050000000602000000000300000006020000000003000000240200
000000030000002402000000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a1400ae7c00000000000000000000000000000009
[2fa0]0fac0006000000000030
[2fd3]16812a000000148116000000128102000000106e0000000e5a0000000c460000000a
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff90feb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000001320ff200070000000605000000011e000000071000000605000000010a0200000001
0e0d00000000240e0d0c1a0655046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000]0d000000010430000430
[3430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[b430]974d461400ae7c00000000000000000000000000000001
[bfff]07
[d000]0d000000010430000430
[d430]974d5a1400ae7c00000000000000000000000000000001
[dfff]09
[f000]0d000000010430000430
[f430]974d6e1400ae7c00000000000000000000000000000001
[ffff]0b
[11000]0d00000001042f00042f
[1142f]974d81021400ae7c00000000000000000000000000000001
[11f7c]0d
[13000]0d00000001042f00042f
[1342f]974d81161400ae7c00000000000000000000000000000001
[13fff]0f
[15000]0d00000001042f00042f
[1542f]974d812a1400ae7c00000000000000000000000000000001
[15fff]11
[17000]0d000000010431000431
[17431]974c0a1400ae7c00000000000000000000000000000009
[18000]0d00000001042f00042f
[1842f]974d813e1400ae7c00000000000000000000000000000001
[18fff]13
[199d7]0a
[1a007]12000000070000001d000000090000001f0000000b000000210000000d0000002500
00000f000000270000001100000029000000130000002b000000150000002d0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502770466008800880088
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655027704660e110088008800880e11
[23088]046601ef
[23277]973e04ae7c02
[33465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259d7]6e
[279d8]82
[299d7]96
[2b9d8]aa
[2e9d8]be
[2f000]
--
DROP INDEX a ;
SELECT sum(s GLOB length(b)) FROM t1 WHERE a IN (110,10,150) AND q IS NULL;
COMMIT;
SELECT sum(s GLOB length(b)) FROM t1 WHERE a IN t1 110,10,150) AND q IS NULL;
INSERT INTO t1(b) VALUES(zeroblob(40000));
SELECT sumNULL;
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(-2374734197, x*781) FROM c;
INSERT INTO t1(b) VALUES(zeroblob(40000));
(NULL)REINDEX t1;
INSERT INTO c30 (master, line) VALUES (1, a );
REINDEX;
DROP INDEX t1x2 FROM t1 WHERE a IN (110,10,150) AND q IS NULL ;
SELECT * FROM c1 ORDER BY a;
update t1 set b='x' || b where a=1 OR a-3;
CREATE INDEX t1d ON t1(d);
CREATE INDEX x2 ON t1(c, ) SELECT x,null FROM c
UNION ALL SELECT 180<<x,printf('%,d][%,d', x* b);
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][%,d]',x*781) FROM c;
SELECT fts5_decode(id, '.' ) FROM t2_data;
delete from t1 where a=1 OR a>3;
update t1 set b='xm' || b where a=1 OR a=3;


sqltext:
53514c69746520666f726d61742033001000010100402020000000000000002f0000001b00
00001300000003000000040000000000000006000000010000000000000001
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431783274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e6365044help5
415445205441424c452073716c6974655f73657175656e6365286e616d652c736571296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
000000010000000001000000000000130000002b000000150000002d0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502770466008800880088
[22088]046601ef
[22277]9730ff7000ff7[3ff7]0701031102743100be0a0f7c000a0f74000ff90feb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f74000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a1400ae7c00000000000000000000000000000009
[2fa0]0fac0006000000000030
[2fd3]16812a000000148116000000128102000000106e0000000e5a0000000c460000000*
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff90feb0fdd8fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740000000000000050000000000
0000000000000500000004000000000000000000000001
[64]0d000000050e70000fc60f7e0f230ed00e70
[e70]5e0507171f1f01810b7461626c6574315f706172656e7474315f706172656e740543
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510406171b1b017b7461626c
6574315f6e6f646574315f6e6f646504435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c6461746129590307
171d1d0181057461626c6574315f726f77696474315f726f77696403435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c613029460206171111087b7461626c6574317431435245415445
205649525455414c205441424c45207431205553494e472072747265652869642c78302c78
312c79302c79312c2b65782938010617171701517461626c65636f6f7264636f6f72640243
5245415445205441424c4520636f6f72642876205245414c2c2077205245414c290d000000
0a0fbb000ffa0ff30fec0fe50fde0fd70fd00fc90fc20fbb
[1fbb]050a0301010a02050903010109306172b2b01597461626c6573716c6974655f73657175656e63
65730f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000 VALUES(1)200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000001320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a06855046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c0716c6974655f73657175656e6365044debug35245415445205441424c452073796c6974655f
73657175656e6365286e616d652c73657129810401071711110181737461626c6574317431
02435245415445205441424c452074312861205245414c204e4f54204e554c4c2044454641
554c542832352b3332292c6220464c4f41542c6320444f55424c4520554e495155452c01
[5465]20973d04ae7c01
[569d8]aa
[2e9d8]be
[2f000]
--
DROP INDEX t1x1;
SELECT sum(s+length(b)) FROM t2 WHERE a IN (110,10,150) AND q IS NULL;a64
20434c4f422c6520494e544547455220505249Kd415259204b4559204155544f494e435245
4d454e54292302061737110100696e64657873716c6974655f6175746f696e6465785f74
REINDEX t1;
DR_P INDEX t1x2;
WITH RECEFAULT VALUES;
INSERT INTO t1(b) VALUES(1),(2),('xyzzy');
SELECT * FROM t1 WHERE b=2.0;
DROP INDEX t1b;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<10)
INSERT INTO t1(a) SELECT randomblob(3000) FROM c;
REINDEX t1;
SELECT rowid, * FROM dbstat('main');

0000000bbd4040000040a0000040a0000040e0000000000000000007d54000000040800000
40a0000040e000000000�000000003ed3f80000040400000
0a0fbb000ffa0ff30fec0fe50fde0fd70fd00fc90fc20fbb
[1fbb]050a0301010a02050903010109306172b2b01597461626c6573716c6974655f73657175656e63
65730f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe400070000seed0500
000001320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a06855046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c0716c6974655f73657175656e63650443524541544520544N ALL SELECT x+1 FROM c WHERE x<10)
INSERT INTO t1(a) SELECT randomblob(3000) FROM c;
REINDEX t1;
SELECT rowid, * FROM dbstat('main');

0000000bbd4040000040a0000040a0000040e0000000000000000007d54000000040800000
40a0000040e000000000�000000003ed3f80000040400000
0a0fbb000ffa0ff30fec0fe50fde0fd70fd00fc90fc20fbb
[1fbb]050a0301010a02050903010109306172b2b01597461626c6573716c6974655f73657175656e63
65730f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000e435245
4d454e54292302061737110100696e64657873716c6974655f6175746f696e6465785f74
REINDEX t1;
DR_P INDEX t1x2;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x31
5f3174310300000008000000000d0000000010
[2000]0a0000000010
[3000]0d0000000010
[4000]0a0000000010
[5000]
--
INSERT INTO t1 DEFAULT VALUES;
INSERT INTO t1(b) VALUES(1),(2),('xyzzy');
SELECT * FROM t1 WHERE b=2.0;
DROP INDEX t1b;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<reverse_unordered_selects10)
INSERT INTO t1(a) SELECT randomblob(3000) FROM c;
REINDEX t1;
SELECT rowid, * FROM dbstat('main');

0000000bbd4040000040a0000040a0000040e0000000000000000007d54000000040800000
40a0000040e000000000�000000003ed3f8000004040000040a0000040e000000000000000
00138e40a0000040e0000040c00000410000000<100)
INSERT OR IGNORE INTO t1(a,c) SELECT x,null FROM c
UNION ALL SELECT 180-x,printf('000000000000fa64080000040c0000040c0
0000410000000000000000000bbe4040000040a0000040c000004100000000000000000007
d6400000004080000040c000004100000000000000000003ee3f8000004040000040c00000
41000000000000000000138f40a0000040e0000040e00000411000000000000000000fa740
80000040c0000040e00000411000000000000000000bbf4040000040a0000040e000004110
000000000000000007d7400000004080000040e000004110000000000000000003ef3f8000
004040000040e000102010601010200041100000000000000000139040a0000040e00158525452494d1f210500330f194f4d4954204c4f4144204558544540000000000000000000000000009
[18000]0d00000001042f00042f
[1842f]974d813e1400ae7c00000000000000000000000000000001
[18fff]13
[199d7]0a
[1a03071721973d04ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7[%,d]',x*781) FROM c;
INSERc000000000T INTO t1(b) VALUES(zer00000000000000000000001
[7fff]03
[9000]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[b430]974d461400ae7c00000o000005202267656f315f706172656e7422286e6f64656e6f20494e54
45474552205052493d41525920 BETWEEN 06172656e746e6f646529570206171f1f017f74
61626c6567656f315f6e6f646567656f315f6e6f646503435245415445205441424c452022
67656f315f6e6f646522286e6f6465blob(4006e6f20494e5445474552205052494d415259204b4559
2c6����������������������0430
[f430]974d6e1400ae7c00000000000000000000000000000001
[ffff]0b
[11000]0d00000001042f00042f
[c45204a500)34f4e31
584e4f434);
1534517130266a6


sqltext:
53514c69746520666f726d61742033001000010100402020000000000000002f0000001b00
00001300000003000000040000000000000006000000010000000000000002
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431793274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736561296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
00000001000000000100000000020000000005000000030200000000050000000302000000
00060000000303000000000500000003020000000005000000030200000000050000000302
00000000057000000302000000000500000003020000000005000000030500000003030000
00230200000000030000002302000000000300000023020000000003000000230200000000
03000000230500000106050000000a22000000000300000006020000000003000000240200
001000093000002402000000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a2400ae7c00000000000000000000000000000009
[2fa0]0fac000600000000e62f
[2fd3]1681b4000000148116000000128102000000106e0000000e5a0000000c460000000a
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff8ffeb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000002320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a0655046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[b430]974d461400ae7c00000000000000000000000000000001
[bfff]07
[d000]0d000000010430000430
[d430]974d5a1400ae7c00000000000000000000000000000001
[dfff]09
[f000]0d000000010430000430
[f430]974d6e1400ae7c00000000000000000000000000000001
[ffff]0b
[11000]0d00000001042f00042f
[1142f]974d81021400ae7c00000000000000000000000000000001
[11fff]0d
[13000]0d00000001042f00042f
[1342f]974d81161400ae7c00000000000000000000000000000001
[13fff]0f
[15000]0d00000001042f00042f
[1542f]974d812a1400ae7c00000000000000000000000000000001
[15fff]11
[17000]0d000000010431000431
[17431]974c0a1400ae7bffff0000000000000000000000000009
[18000]0d00000001042f00042f
[1842f]974d813e1400ae7c00000000000000000000000000000001
[18fff]13
[199d7]0a
[1a007]12000000070000001d000000090000001f0000000b000000210000000d0000002500
00000f000000270000001100000029000000130000002b000000150000002e0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502770466008800880088
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655fe7704660e110088008800880e11
[23088]046601ef
[23277]973e04ae7c02
[23465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259d7]6e
[279d8]82
[299d8]96
[2b9d8]aa
[2e9d8]be
[2f000]
--
DROP INDEX t1x1;
INSERT INTO t1(b) VALUES(zeroblob(40000));
CREATE INDEX t1d ON t1(d;
INSERT INTO t1(b) VALUES(randomblob(250));
PRAGMA wal_checkpoint=TRUNCATE;
CREATE VIRTUAL TABLE t2 USING fts5vocab('t1','row');
PRAGMA wal_checkpoint=TRUNCATE;
INSERT INTO t1(a,b) VALUES(1,'h VTY!k7GF_Un');
CREATE INDEX x1 ON t1(b);
INSERT INTO t1(b) VALUES(randomblob(250));
DELETE FROM t1 WHERE a GLOB 'tbo' OR b>='i';
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 GLOB x,printf(-7.94390,x*781) FROM c;
SELECT t4;
WITH RECURSIVE c(x) AS (VALUES( t1 ) 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;
SELECT fts5_decode(id, block) FROM ;
DELETE FROM t1 WHERE a OR 'twK' OR b='iv';
SELECT >> FROM t1 WHERE 'abandon';
INSERT INTO t1 INSERT INTO t1(b) VALUES( (b) VALUES( Table0 (40000));
DELETE FROM t1 WHERE a+'b' OR b='v';
CREATE INDEX x2 ON ,x* t1(c,b);INSERT INTO t1(b) VALUES(zeroblob(40000));
SELECT + FROM t1, bb;
UPDATE t1 SET content='beamer bummer backup' WHERE content='boomer';
SELECT printf('%s',
EXISTS (WITH RECURSIVE Table0 AS (WITH Table0 AS (SELECT DISTINCT 1);
PRAGMA optimize;
SELECT * FROM t1, bb;


sqltext:
53514c69746520666f726d61742033001000010100402020000000000000002f0000001b00
00001300000003000000040000000000000006000000010000000000000002
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431793274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736561296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
00000001000000000100000000020000000005000000030200000000050000000302000000
00060000000303000000000500000003020000000005000000030200000000050000000302
00000000057000000302000000000500000003020000000005000000030500000003030000
00230200000000030000002302000000000300000023020000000003000000230200000000
03000000230500000106050000000a22000000000300000006020000000003000000240200
001000093000002402000000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a2400ae7c00000000000100000000000000000009
[2fa0]0fac000600000000e62f
[2fd3]1681b4000000148116000000128102000000106e0000000e5a0000000c460000000a
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff8ffeb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000002320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a0655046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae9c01
[5843]1e97
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c00
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[b430]974d461400ae7c00000000000000000000000000000001
[bfff]07
[d000]0d000000010430000430
[d430]974d5a1400ae7c0000000000000000000000
[dfff]09
[f000]0d000000010430000430
[f430]974d6e1400ae7c00000000000000000000000000000001
[ffff]0b
[11000]0d00000001042f00042f
[1142f]974d81021400ae7bfffffffffffffff00000000000000001
[11fff]0d
[13000]0d00000001042f00042f
[1342f]974d81161400ae7c00000000000000000000000000000001
[13fff]0f
[15000]0d00000001042f00042f
[1542f]fb4d812a1400ae7c0000000000000000
[15fff]11
[17000]0d000000010431000431
[17431]974c0a1400ae7bffff0000000000000000000000000009
[18000]0d00000001042f00042f
[1842f]974d813e1400ae7c00000000000000000000000000000001
[18fff]13
[199d7]0a
[1a007]12000000070000001d000000090000001f0000000b000000210000000d0000002500
00000f000000270000001100000029000000130000002b000000150000002e0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502770466008800880088
00
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655fe7704660e110088008800880e11
[23088]046601ef
[23277]973e04ae7c02
[23465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259
[279d8]82
[299d8]96
[2b9d8]aa
[2e9d8]be
[2f000]
000001
--
DROP INDEX t1x1;
INSERT INTO t1(b) VALUES(zeroblob(40000));
CREATE INDEX t1d ON t1(d;
INSERT INTO t1(b) VALUES(randomblob(250));
COMMIT;
PRAGMA wal_checkpoint=TRUNCATE;
PRAGMA wal_checkpoint=TRUNCATE;
INSERT INTO t1(a,b) VALUES(1,'h VTY!k7GF_Un');
CREATE INDEX x1 ON t1(b);
INSERT INTO t1(b) VALUES(randomblob(250));
DELETE FROM t1 WHERE a GLOB '#tbo' OR b>='i';
SELECT DISTINCT a FROM t1;
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 GLOB x,printf(-4685385041113483,x*781) FROM c;
SELECT t4;
SELECT fts5_decode(id, block) FROM DELETE FROM t1 WHERE a OR 'twK' OR b='iv';
REINDEX t1;
SELECT >> FROM t1 WHERE 'abandon';
INSERT INTO t1INSERT INTO t1(b) VALUES( (b) VALUES( Table0 RECURSIVE (40000));
UPDATE t1 SET b=quote(zeroblob(200)) WHERE t1 MATCH 1 ;
DELETE FROM t1 WHERE a+'b' OR b='v';
CREATE INDEX x2 ON ,x* t1(c,b);INSERT INTO t1(b) VALUES;
SELECT + FROM t1, bb;
UPDATE t1 SET content='beamer bummer backup' WHERE content=-61970787;
PRAGMA optimize;
2


sqltext:
53514c69746520666f726d61742033001000010100402020000000000000002f0000001b00
00001300000003000000040000000000000006000000010000000000000002
[64]0d000000040ee2000f960f440f100ee2
[ee2]2c04061715110141696e6465787431793274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736561296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454e542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
ff000001000000000100000000020000000005000000030200000000050000000302000000
00060000000303000000000500000003020000000005000000030200000000050000000302
00000000057000000302000000000500000003020000000005000000030500000003030000
00230200000000030000002302000000000300000023020000000003000000230200100000
03000000230500000106050000000a22000000000300000006020000000003000000240200
001000093000002402000000000300000024020000000002000000000300000024
[2000]05000000090fd000000000190ffb0ff60ff10fec0fe70fe20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a2400ae7c00000000000000000000000000000009
[2fa0]0fac000600000000e62f
[2fd3]1681b4000000148116000000128102000000106e0000000e5a0000000c460000000a
32000000081e000000180a0d000000010ff700b007
[3ff7]0701031102743100be0a0f7c000a0f74000ff8ffeb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000002320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a065504
[5088]973d04ae7c01
[5276]21973cf4ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d000000010430000430
[b430]974d461400ae7c00000000000000000000000000000001
[bfff]07
[d000]0d000000010430000430
[d430]974d5a1400ae7c00000000000000000000000000000001
[dfff]09
[f000]0d000000010430000430
[f430]974d6e1400ae7c00000000000000000000000000000001
[ffff]0b
[11000]0d00000001042f00042f
[1142f]974d81021400ae7c00000000000000000000000000000001
[11fff]0d
[13000]0d00000001042f00042f
[1342f]974d81161400ae7c00000000000000000000000000000001
[13fff]0f
[15000]0d00000001042f00042f
[1542f]974d812a1400ae7c00000000000000000000000000000045
[15fff]11
[17000]0d000000010431000431
[07431]974c0a1400ae7bffff0000000000000000000000000009
[18000]0d00000001042f00042f
[1742f]974d813e1400ae7c00000000000000000000000000000001
[18fff]13
[199d7]0a
[1a007]12000000070000001d000000090000001f0000000b000000210000000d0000002500
00000f000000270000001100000029000000130000002b000000150000002e0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502770466008800880087
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655fe7704660e110088008800880e11
[23088]046601ef
[23277]973e04ae7c02
[23465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259d7]6e
[279d8]82
[299d8]96
[2b9d8]aa
[2e9d8]be
[2f000]
--
DROP INDEX t1x1;
INSERT INTO t1(b) VALUES(zeroblob(40000));
CREATE INDEX t1d ON t1(d;
INSERT INTO t1(b) VALUES(randomblob(250));
PRAGMA wal_checkpoint=TRUNCATE;
CREATE VIRTUAL TABLE t2 USING fts5vocab('t1','row');
PRAGMA wal_checkpoint=TRUNCATE;
INSERT INTO t1(a,b) VALUES(1,'h VTY!k7GF_Un');
CREATE INDEX x1 ON t1(b);
INSERT INTO t1(b) VALUES(randomblob(250));
SELECT a, sum(d) OVER (
PARTITION BY b ORDER BY d
RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
) FROM t1;
DELETE FROM t1 WHERE a GLOB t1 OR b>='i';
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 GLOB x,printf(-7.94390,x*781) FROM c;
SELECT t4;
DELETE FROM t1 WHERE t1 MATCH 'abando*';
WITH RECURSIVE c(x) AS (VALUES( t1 ) UNION ALL SELECT x+1 FROM c WHERE x<100)
c;
SELECT fts5_decode(id, block) FROM ;
DELETE FROM t1 WHERE a OR 'twK' OR b='v';
SELECT >> FROM t1 WHERE 'bandon';
INSERT INTO t1 INSERT INTO t1(b) VALUES( (b) VALUES( Table0 (40000));
CREATE INDEX x2 ON ,x* t1(c,b);INSERT INTO t1(b) VALUES(zeroblob(40000));
SELECT *(FROM t1 WHERE rowid=5;
SELECT + FROM t1, bb;
UPDATE t1 SET content=082 WHERE content='boome';
SELECT * FROM sqlite_master x, pragma_table_xinfo(x.name) WHERE x.type='tauble';
SELECT printf('%s',
EXISTS (WITH RECURSIVE Table0 AS (WITH Table0 AS (SELECT DISTINCT 1);
PRAGMA optimize;
SELECT * FROM t1, bb;


sqltext:
53514c69746520666f726d617420330010000101004020200000000000000��00000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
5245415445205441424c45202274315f706172656e753514c69746520666f726d6174203300100001010040202000000000000000050052494d415259204b45592c706172656e746e6f646529510406171b1b017b7461626c
6574315f6e6f646574315f6e6f646504435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e6445474552205052494d415264]0d000000010fc7000fc7
[fc7]37010617151501537461626c656475616c6465616c02435245415445205441424c45
206475616c2864756d6d792076617263686172283129290d000000010ffb000ffb
[1ffb]0301020f58
--
CREATE VIRTUAL TABLE t1 USING fts5(a,b,c);
INSERT INTO t1 SELE rowid,a,c FROM t1 WHERE a MATCH 'rtree OR json1';
DELETE FROM ompile_opontsi, dual, pragma_collation_list;
SELECT rowid,a,c FROM t1 WHERE a MATCH 'rtree OR json1';
DELETE FROM t1 WHERE a MATCH 'fts00000000000000000fa24080000040c000004000000040800000000000
000000138a40a0000040e00000400000004080000000000000000003e93f80000040400000
3f8000004040000000000000000007d140000000408000003f800000404000��������0000
000bb9404053514c69746520666f726d6174203300100001010040202000000000000000040000000000
000000000000040000000400000000000000:0000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f70465627567090402
000102000102000006656e61626c653f00103000302696d3c010102020003010202000301020200030102020003
0102020003010202000301020*';
SELEC200030102020003010202335000130120106000106000106001f03000103
0001030000083230313630363702c20712925010617111101377461626c657431743102435245415445205441424c4520
743128612c2062290d000000030fe1000ff70fed0fe1
[1fe1]0a03030217014d7468726565080203021300de74776f07010301136f6f6e650d0000
00030fea000ffa0ff20fea
[2fea]06030301020401bc06020301020200de04010309016f0d000000010ff5000ff5
[3ff5]0901000139040a0000040e000004100000041200000
00000000000441200000414000004080 julianday(1)00000
0000002715412000004140000040a0000040e0000000000000000027164120000041400000
40c00000410000000000000000002717412000004140000040e00000411000000000000000
00271841200000414000004100000041200000000000000000271941200000414000004110
000041300000000000000000271a4120000041400000412000004140
[30000000000000000007d940014c69746520666f726d6174203300100001010040202000000000000000040000000000
000000000000040000000400000000000000:0000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
522064656e6f2c61302c61312951010717111104
000115023


sqltext:
53514c69746520666f726d617420330010000101004020200fe000000000000a0000000000
00
[64]0d000000090e3f000fd90fb20f8b0f5d0f2f0eed0eb90e8c0e3f
[e3f]4b0906172525015b7461626c6573716c6974655f737461743173716c697465b67374
6174310a435245415445205441424c452073716c6974655f73746174312874626c2c696478
2c74746167292b0806171515013b7461626c65743330327433303209435245415445205441
424c45207433303228782c2079293207061717150147696e64657874333031637433303108
43524541544520494e444558207433303163204f4e20743330312863294006061715150165
7561626c657433303174332f3107435245415445205441424c452074333031286120494e54
45374552205052494d415259204b45592c622c63292c15061715110141696e6465787433ff
3174330643524541544520494e4445582074336931204f4e2074332878292c040617151101
41696e64657874326931eed20543524541544520494e4445582074326931204f4e20743228
702925030617111101377461626c657433743304435245415445205441424c452074332878
2c20792925020617111101377461626c657432743203435245415445205441424c45207432
28702c20712925010617111101377461626c657431743102435245415445205441424c4520
743128612c2062290cff
000001
0001
[1fe1]0a03030217014d74687265650802030213
[2fea]07030301020401bc06020301020200de0401
[3ff5]090103021503e76e68
[4ff0]0503010104030503010102020303
00000001
[5ffa]
[6ff0]060204000101020306010e1001
[7ff5]0503010103020403010903
[8c89]050103010104050d
[9fbd]07050411000f7431330d0404111513743274
--
CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1,+ex);
SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p+-6.860 AND a=q;
SELECT * FROM t2, t1 LEFT JOIN t3 ON q OR x WHERE a= p AND a=q;
SELECT rowid,aFROM a MATCH 51878163;
SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q WHERE p=2 AND a+q;
SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p=-6.860 AND a;
SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE 2=p AND a=q;
SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p=2 AND a=q;
SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q WHERE p= p AND a=q;
SELECT * FROM t1, t2 LEFT JOIN t3 ON q= 3.5956 WHERE p=-6.860 AND a-q;
VACUUM;
SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p*3.5956 AND a=q;


sqltext:
53514c69746520666f726d6174203300100001010040202010000000000000070000000200
0000010000000800000004000000000000000000000001
[64]0d0fc700060db6000f8d0f360ecb0e6b0e0e0db60db6
[db6]560706171f1f017d7461626c6574315f636f6e66696774315f636f6e666967074352
45415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c
20762920574954484f555420524f5749445b06071721210181017461626c6574315f646f63
73697a6574315f646f6373697a6506435245415445205441424c45202774315f646f637369
7a652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295e
05071721210181077461626c6574315f636f6e74656e7474315f636f6e74656e7405435245
415445205441424c45202774315f636f6e74656e742728696420494e544547455220505249
4d415259204b45592c2063302c2063312c2063322969040717191901812d7461626c657431
5f69647874315f69647804435245415445205441424c45202774315f696478272873656769
642c207465726d2c2070676e6f2c205052494d415259204b45592873656769642c20746572
6d292920574954484f555420524f574944550307171b1b0181017461626c6574315f646174
6174315f6461746103435245415445205441424c45202774315f646174612728696420494e
5445474552205052494d415259204b45592c20626c6f636b20424c4f422938020617111108
5f7461626c6574317431435245415445205649525455414c205441424c4520743120555349
4e47206674733528612c622c632900000039
[2000]0d000000030c94000fe60fef0c94
[2c94]864a84808080800104008d180000032b0230300102060102060102061f0203010203
01020301083230313630363039010207010207010207010134010205010205010205010135
0102040102040102040207303030303030301c0204010204010204010662696e6172790306
01020203060102020306010202030601020203060102020306010202030601020203060102
0203060102020306010202030601020203060102020108636f6d70696c6572010202010202
01020201066462737461740702030102030102030204656275670402020102020102020106
656e61626c6507020201020201020201020201020201020201020201020201020201020201
02020102020102020102020102020102020102020102020102020102020102020208787465
6e73696f6e1f02040102040102040104667473340a02030102030102030401350d02030102
0301020301036763630102030102030102030206656f706f6c791002030102030102030105
6a736f6e3113020301020301020301046c6f61641f020301020301020301036d61781c0102
0102020102020205656d6f72791c0203010203010203040473797335160203010203010203
01066e6f636173650206010202030601020203060102020306010202030601020203060102
0203060102020306010202030601020203060102020306010202030601020201046f6d6974
1f0202010202010202010572747265651902030102030102030402696d0106010202030601
02020306010202030601020203060102020306010202030601020203060102020306010202
030601020203060102020306010202010a7468726561647361666522020201020201020201
04767461620702040112040102040101780106010102010601010201060101020106010102
01060101020106010102010601010201060101020106010102010601010201060101020106
010102010ee101020106010102010601010201060101020106010102010601010201060101
02010601010201060101020106010102010601010201060101020106010102010601010201
06010102010601010201060101020106010102010601010201060101020106010102010601
0102010601010201060101020415130c0c124413110f47130f0c0e11100f0e100f440f1040
150f0701030014245a24240f0a0300240000000001010100010101010a000000010ffa000f
fa
[3ffa]0504090c01020d000000240c0a000fd80faf0f860f740f610f4e0f2f0f0f0eef0ec7
0ebe0ea50e8d0e740e5b0e400e240e080def0dd50dbb0da00d840d680d4f0d350d1b0cfb0c
da0cb90c990c780c570c3e0c240c0a
[4c0a]18240500250f19544852454144534146453d305842494e41525918230500250f1954
4852454144534146453d30584e4f4341534517220500250f17544852454144534146453d30
58525452494d1f210500330f194f4d4954204c4f414420455854454e53494f4e5842494e41
52591f200500330f194f4d4954204c4f414420455854454e53494f4e584e4f434153451e1f
0500330f174f4d4954204c4f414420455854454e53494f4e58525452494d1f1e0500330f19
4d4158204d454d4f52593d35303030303030305842494e4152591f1d0500330f194d415820
4d454d4f52593d3530303030303030584e4f434153451e1c0500330f174d4158204d454d4f
52593d353030303030303058525452494d181b0500250f19454e41424c4520525452454558
42494e415259181a0500250f19454e41424c45205254524545584e4f434153451719050025
0f17454e41424c4520525452454558525452494d1a180500290f19454e41424c45204d454d
535953355842494e4152591a170500290f19454e41424c45204d454d53595335584e4f4341
534519160500290f17454e41424c45204d454d5359533558525452494d18150500250f1945
4e41424c45204a534f4e315842494e41525918140500250f19454e41424c45204a534f4e31
584e4f4341534517130500250f17454e41424c45204a534f4e3158525452494d1a12050029
0f19454e41424c452047454f504f4c595842494e4152591a110500290f19454e41424c4520
47454f504f4c59584e4f4341534519100500290f17454e41424c452047454f504f4c595852
5452494d170f0500230f19454e41424c4520465453365842494e415259170e0500230f1945
4e41424c452046545335584e4f43415345160d0500230f17454e41424c4520465453355852
5452494d170c0500230f19454e41424c4520465453345842494e415259170b0500230f1945
4e41424c452046545334584e4f43415345160a0500230f17454e41424c4520465453345852
5452494d1e090500310f19454e41424c452044425354415420565441425842494e4152591e
080500310f19454e41424c45204442535441542056544142584e4f434153451d070500410f
17454e41424c4520444253544154205654414258525452494d11060500170f194445425547
5842494e41525911050500170f194445425547584e4f4341534510040500170f1744454255
4758525452494d27030500430f19434f4d50494c45523d6763632d352e342e302032303136
303630395842494e41525927020500430f19434f4d50494c45523d6763632d352e342e3020
3230313630363039584e4f4341534526010500430f17434f4d50494c45523d6763632d352e
342e3020323031363036303958525452494d0d000000240ee0000ff80ff00fe80fe00fd80f
d00fc80fc00fb80fb00fa80fa00f980f900f880f800f780f700f680f600f580f500f480f40
0f380f300f280f200f180f100f080f000ef80ef00ee80ee0
[5ee0]06240300120201010623030012020101062203001202010106210300120301010620
030012030101061f030012030101061e030012030101061d030012030101061c0300120301
01061b030012020101061a0300120201010619030012020101061803001202010106170300
12020101061603001202010106150300120201010614030012020101061303001202010106
1203001202010106110300120201010610030012020101060f030012020101060e03001202
0101060d030012020101060c030012020101060b030012020101060a030012020101060903
00120301010608030012030101060703001203010106060300120101010605030012010101
06040300120101010603030012060101060203001206010106010300120601010a00000001
0ff4000ff4
[6ff4]0b031b0176657273696f6e04
--
CREATE VIRTUAL TABLE t2 USING fts5vocab('t1','row');
INSERT INTO t1(a,b)
SELECT a, sum(a) OVER (PARTITION BY b ORDER BY a DESC) FROM t2 ORDER BY a;
SELECT rowid, quote(term), * FROM t2 WHERE term=='nocase';
SELECT rowid,a,c FROM t1 WHERE a MATCH 'rtre OR js(n1';
VACUUM;
SELECT 1 WHERE (5, 4) IN (SELECT +b, +a FROM t1);
SELECT a, CASE (b,c) WHEN (1,2) THEN 'aleph'
WHEN (2,3) THEN 'bet'
WHEN (3,4) THEN 'gimel'
ELSE x'13' END
FROM t1
ORDER BY a;
SELECT 1 WHERE (1, NULL) IN (SELECT rowid, b FROM t1);
SELECT a, sum(d) OVER w1, sum(d) OVER w2, sum(d) OVER w3,max(d)OVER w3
FROM t1
WINDOW
w1 AS
(PARTITION BY b ORDER BY d
ROWS BETWEEN 2 PRECEDING AND 1 FOLLOWING),
w2 AS
(PARTITION BY b BY d
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
w3 AS
(PARTITION BY b ORDER BY d
ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
;
CREATE VIRTUAL TABLE t4 USING fts5vocab('t1','instance');
SELECT 1 WHERE (5, 4) IN (SELECT a, b FROM t1);
SELECT 1 WHERE (5, 4) IN (SELECT +b, +a FROM t1);
SELECT rowid,a,c,snippet(t1,'[','TJi J=Q\#zalqY7qB1 ;k"_I K<=B/NPo','--',-1,10)
FROM t1 WHERE a MATCH 'rtree OR json1';
SELECT a,b,c FROM t1 INTERSECT SELECT b ,b,c FROM t1 WHERE b/'d'
ORDER BY a,b,c;
SELECT rowid, quote(term), * FROM t4 WHERE term=='nocase';
SELECT * FROM t2, t3, t4 WHERE t2.term%t3.term t3.term AND t4.term;
SELECT 5 , quote(term), * FROM t3 WHERE term=='nocase';
SELECT 1 WHERE () IN (SELECT a, b FROM t1);
SELECT * FROM t2 WHERE term<null;
SELECT snippet(t1, -1, '.', '..', '[', ']'), highlight(t1, 2, 'd', ']') FROM t1('g+ h') WHERE rank MATCH 'bm25(1.0, 1.0)' ORDER BY rank;
REINDEX;
VACUUM;
SELECT * FROM t3;
rowid, quote(term), * FROM t3 WHERE term=='nocas';
SELECT * FROM t4;
INSERT INTO t1(t1) VALUES('optimize');
CREATE TABLE IF NOT EXISTS c30 (
line INTEGER, master REFERENCES p30(id), PRIMARY KEY(master)
) WITHOUT ROWID;


sqltext:
53514c69746520666f726d61742033001000010100402020e7000000000000040000000000
0000000000000200000004000000000000000000000001
[64]0d000000030e94000f860f340e94
[e94]811d03071719190182157461626c65616c62756d73616c62756d7304435245415445
205441424c4520616c62756d7320280a2020696420696e7465676572204e4f54204e554c4c
205052494d415259204b4559204155544f494e4352454d454e542c0a20206e616d65207661
726368617228323535292c0a20206172746973745f696420696e7465676572205245464552
454e43455320617274697374730a29500206172b2b01597461626c6573716c6974655f7365
7175656e636573716c6974655f73657175656e636503435245415445205441424c45207371
6c6974655f73657175656e6365286e616d652c73657129780107171b1b0181477461626c65
617274697374736172746973747302435245415445205441424c4520617274697374732028
0a2020696420696e7465676572204e4f54204e554c4c205052494d415259204b4559204155
544f494e4352454d454e542c0a20206e616d65207661726368617228323535290a290d00
[1ff9]050103001141720d000000020fe9
[2fe9]0902031909616c62756d730a01031b09617274697374730d000000010ff8000ff8
[3ff8]060104001109416c
--
SELECT artists.*
FROM artists
INNER JOIN artists AS 'b' ON (b.id = artists.id)
WHERE ( b .id IN (
SELECT albums.artist_id
FROM albums
WHERE ((name = '') AND (albums.artist_id IS NOT NULL)
AND (albums.id IN (
SELECT id
FROM (
SELECT albums.id,
row_number() OVER (
PARTITION BY albums.artist_id
ORDER BY name
) AS 'x'
FROM albums
WHERE (name = 'Al')
) 't'
WHERE (x = 1)
))
AND (albums.id IN (1, id )))
));


sqltext:
53514c69746520666f726d6174203300100001�010040202000000000000000070000000000
00000000000007000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017441626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
65x2728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552205052494d41
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f6964782728/73656��������������������������������������������������������������������������������������������������������������769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525475414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e000*0001e0630616261636b0102020402667402020204046e
646f6e030202040a07050103001003030f0a0300240000000001010001010101010a000000
010ffa00#ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d0000��������������������������������������������������������00030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel backup abandon teb staack channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a650543524541544520548696420494e54454745522050524944d1
5259204b45592c2063302969030001575311926d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f6978272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f174610243
5245415445205441424c4�5202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a0!0617111108637461626c6574317431
435245415445205649525475414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000be80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020402667402020204046e
646f6e0T0202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2!fa]0504090c01020d000000030fe0000ff60fec0ff0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b726562756461746174315f646174610243
5245415445205441424c45202774315f64617461272869642049�e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525475414c205441424c45207431205553494e472066747;3528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020402667402020204046e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2f)a]0504090c01020d000000030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e08020300176162616674080103036b0102020402667402020204046e
646f6e030202040a07050103001003030f0a0300240000000001010100010101009a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1(t1) SELECT x FROM t2;


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
0500330f194f4d4954204c4f414420455854454e53494f4e5842494e41
52591f200500330f194f4d4954204c4f414420455854454e53494f4e584e4f434153451e1f
0500330f174f4d4954204c�f414420455854454e53494f4e58525452494d1f1e0500330f19
4d4158204d454d4f52593d35303030303030305842494e4152591f1d0500330f194d415820
4d454d4f52593d3530303030303030584e4f434153451e1c0500330f174d4158204d454d4f290f17454e41424c452047454f504f4c595852
5452494d170f0500230f19454e41424c4520465453355842494e415259170e0500230f1945
4e41424c452046545335584e4f43415345160d0500230f17454e41424c4520465453355852
5452494d170c0500230f19454e41424c4520465453345842494e415259170b0500230f1945
4e41424c452046545334584e4f43415345160a0�����ϙ�7454e41424c4520465453345852
5452494d1e090500310f19454e41424c452044425354415420565441425842494e4152591e
080500310f19454e41424c45204442535441542056544142584e4f434153451d070500310f
17454e41424c4520444253544154205654414258525452494d11060500170f194445425547
5842494e41525911050500170f194445425547584e4f4341534510040500170f1744454255
4758525452494d20030500350f19434f4d50494c45523d636c616e672d362e302e30584249
4e41525920020500350f19434f4d50494c45523d636c616e672d362e302e30584e4f434153
451f010500350f17434f4d50494c45523d636c616e672d362e302e3058525452494d0d0000
00240ee0000ff80ff00fe80fe00fd80fd00fc80fc00fb80fb00fa80fa00f980f900f880f80
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 t4 WHERE term=='nocase';
SELECT * FROM t2, t3, t4 WHERE t2.term=t3.term AND t3.term=t4.term;


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�200000000080000000139140a0000040e000
0041100000413000000000000000000fa94080000040c00000411000004130000000000000
00000bc14040000040a00000411000004130000000000000000007d9400000004080000041
1000004130000000000000000003f13f800000404000004110000041300000000000000000
139240a0000040e0000041200000414000000000000000000faa4080000040c00000412000
00414000000000000000000bc24040000040a00000412000004140000000000000000007da
40000000408000004120000041400000000000000053514c69746520666f726d6174203300100001010040202000000000000000020000000000
0000000000000100000004000000000000000000000001
[64]0d000000010fc6000fc6
[fc6]38010617171701517461626c65636f6f7264636f6f72640243524541544520544142
4c4520636f6f72642876205245414c2c2077205245414c290d0000000a0fbb000ffa0ff30f
ec0fe50fde0fd70fd00fc90fc20fbb
[1fbb]050a0301010a02050903010109020508030101080205070301010702050603010106
0205050301010502050403010104020503030101030205020301010202040103090102
--
CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1,+ex);
INSERT INTO t1()d,x0,x1,y0,y1,ex)
SELECT a.rowid*1000+b.rowid,a.v,a.v+a.w,b.v,b.v+b.w,
printf('%dx%d',a.rowid,b.rowid)
FROM coord AS a, coord AS b;
SELECT id FROM t1 WHERE x0>=4 AND x1<=8.0e0 AND y0>=4 AND y0<800.0e-2;
UPDATE t1 SET ex=printf('fancy-%s',ex) WHEXE x0>=4 AND x1<=8 AND y0>=4 AND y0<8;
DELETE FROM t1 WHERE x0>-10 AND x1<=1.0e+0 AND y0<92;
SELECT ex FROM t1 WHERE id IN (4005,9009);
SELECT rtreecheck('t1');
id FROM t1 WHERE x0>=4 AND x1<=8.0e0 AND y0>=4 AND y0<800.0e-2;
UPDATE t1 SET ex=printf('fancy-%s',ex) WHERE x0>=4 AND x1<=8 AND y0>=4 AND y0<8;
DELETE FROM t1 WHERE x0>-10 AND x1<=1.0e+0 AND y0<92;
SELECT ex FROM t1 WHERE id IN (4005,9009);
SELECT rtreecheck('t1');
36720600095 char(x)465206AND x1<=1.0e+0 AND y0<92;
SELECT ex FROM t1 WHERE id IN (4005,9009);
SELECT rtreecheck('t1');
3672060009541b170100000400657873716c��74655f6175746f696e6465785f74315f7365676469
725f3174315f73656764697205000000080000000066954
48524541445341464535 char(x)46520666f726d6174203300100001010040202000000000000000060000000000
0000000000000500000004000000000000000000000001
[64]0d000000050e9e000fc80j4b0f1f0eca0e9e
[e9e]2a0506171311013f696e64657874337674330643524541074327a204f4e207432287a297b0207171111018161
7461626c657432743203435245415445205441424c45207432287920494e54454745522050
52494d415259204b45592c0a202020202020202020207a20494e544d30584e4f43415[2000]0d0000000010
[3000]
--
INSERT 30001040403030001030a000000020ff4000ffa0ff4
[5ff4]0503010INTO t1(ba), VALUES(1,2);
DELETE FROM record;
INSERT INTO t1(a,b) VALUES(1,2)
ON CONFLICT(a) DO UPDATE SET c=t1.10404050301010303
--
PRAGMA foreign_keys=ON;
PRAGMA defer_foreign_c+1keys=ON;
BEGIN;
DELETE FRO t0 ;WHERE x=3;
DELETE FROM er REFERENCES p30(id), 
PRIMARY KEY(master)
) O c7 VA34517220500250f17544852454144534146453d30
58525452494d1f210500330f194f4d4954204c4f4144204558544540000000000000000000000000009
[18000]0d00000001042f00042f
[1842f]974d813e1400ae7c00000000000000000000000000000001
[18fff]135452494d1f210500330f194f4d4954204c4f414420455854454e53494f4e5842494e41
52591f200500330f194f4d4954204c4f44155544f494e4352454d454e542c0a20206e616d65207661
726368617228323535292c0a20206172746973745f696420696e7465676572205245464552
454e43455320617274697374730a29!500206172b2b01597461626c6573716c6974655f7365
76c79204a534f4e2c20636c72205445585429
64030717232301810f7461626c6567656f315;PRAGMA page_size=512;VACUUM;656e4704
4352454153514c69746520666f;726d6174203300100001010040202000000000000000030000000000
0000000000000200000004000000000000000000000001
[64]0d000000020f4e000fa20f4e
[f4e]52020717111101810f7461626c657432743203435245415445205441424c45207432
286120494e542c206220494e54454745522c205052494d415259204b455928612c62292920
574954484f555420524f5749445c010656e6f20494e5445474552205052494d415259204b$5592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c61312951010717111108810f7461626c65743174314352
45415445205649500000742be000042c800000000000042c80000000000
00000000080000000042c800000000000040a0000000000000000000090000000042c80c800000000000042c80000000000
0000000008000 x1<=8 AND y0>=4 AND y0<8;
DELETE FROM t1 WHERE x0>-10 AND x1<=1.0e+0 AND y0<92;
SELECT ex FROM t1 WHERE id IN (4005,9009);
SELECT rtreecheck('t1');
id FROM t1 WHERE x0>=4 AND x1<=8.0e0 AND y0>=4 AND y0<800.0e-2;
UPDATE t0 SET ex=printf('fancy-%s',ex) WHERE x0>=4 AND x1<=8 AND y0>=4 AND y0<8;
DELETE FROM t1 WH5245415445205441424c452074
31287820494e5445474552205052494d415259204b4559290d000000050fec000ffc0ff80f
f40ff00fec
[1fec]02050200020402000203020002020200020102000d000000020ff5000ffb0ff5
[2ff5]04020300010203010300090a000000020ff6000ffc0ff6
[3ff6b0503010102LUES('Alpha'),('alpha'),('foxtrot');02030309090d000000020ff4000ffa0ff4
[4ff4]0404030001040403030001030a000000020�f4000ffa0ff4
[5ff4]030181137461626c65574318204
5d2494d415259204b4559204155544f494e4352454d454e542c0a20206e616d65207661
726368617228323535292c0a20206172746973745f696420696e7465676572205245464552
454e43455320617274697374730a29500206172b2b01597461626c6573716c6974655f7365
76c79204a534f4e2c20636c72205445585429
64030717232301810f7461626c6567656f315;PRAGMA page_size=512;VACUUM;656e4704
4352454153514c69746520666f;726d6174203300100001010040202000000000000000030000000000
0000000000000200000004000000000000000000000001
[64]0d000000020f4e000fa20f4e
[f4e]52020717111101810f7461626c657432743203435245415445205441424c45207432
286120494e542c206220494e54454745522c205052494d415259204b455928612c62292920
574954484f555420524f5749445c01071711110181237461626c657431743102435245415415f706172656e740443
52454154452054341424c�45202274315f706172656e7422286e6f64656e6f2writable_schema0494e544,4745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646500004151017735228840847c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b$5592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e544547455220505
DELETE FROM c3;
IN000040800000DE40SSE2494d415259RC20
4b45592c6e6f64656e6f2c61302c61312951010717111108810f7461626c65743174314352
45415445205649500000742be000042c800000000000042c80000000000
00000000080000000042c800000000000040a6;0000000000000000000090000000042c80c800000000000042�80000000000
0000000008000 x1<=8 AND y0>=4 AND y0<8;
DELETE FROM t1 WHERE x0>-10 AND x1<=1.0e+0 AND y0<92;
SELECT ex FROM t1 WHERE id IN (4005,9009);
SELECT rtreechceck('t1');
id FROM t1 WHERE x0>=4 AND x1<=8.0e0 AND y0>=4 AND y0<800.0e-2;
UPDATE t1 SET ex=printf('fancy-%s',ex) WHERE x0>=4 AND x1<=8 AND y0>=4 AND y0<8;
DELETE FROM t1 WHERE x0>-10 AND x1<=1.0e+0 AND y0<92;
SELECT ex FROM t1 


sqltext:
5����3514c69746520666f726d6174203300100001010040202000sqlite_sequence0000000000002f0000001b00
0000130000000300000004000000000000000600000001000000000000000�
[64]0d000000040ee2000f960f441f100ee2
[ee2]2c04061715110141696e6465787431783274310643524541544520494e4445582074
317832204f4e207431286229320306171511014d696e646578743178317431054352454154
4520494e4445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736571296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454E542c0a622c632c
642c652c662c672c682c6a2c6b2c6c2c6d2c6e2c6f2c702c712c722c732901000000000100
00000001000000000100000000020000000005000000030200000000050000000302000000
00050000000302000000000500000003020000000005000000030200000000050000000302
00000000050000000302000000000500000003020000000005000000030500000003030000
00230200000000030000002302000000000300000023020000000003000000230200000000
03000000230500000006050000000602000000000300000006020000000003000000240100
000000030000002402000000000300000024020000000002000000000300000024
[1999]05000000090fd000000000190ffb0ff60ff10fec0fe70f%20fdc0fd60fd00fa00fa0
0fa00fa00fa00fa00fa00fa00fa0
[2431]974c0a1400ae7c0000000000000000000009
[2fa0]0fac0006000000000030
[2fd3]16812a000000148116000000128102000000106e0000000e5a0000000c460000000a
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff90feb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]07050000000200be0f8c00080000000007050000000200aa0f9c0008000000000705
0000000200960fac00080000000007050000000200820fba00070000000605000000016e0f
c800070000000605000000015a0fd60007000000060500000001460fe40007000000060500
000001320ff200070000000605000000011e000000070000000605000000010a0200000001
0e0d00000000240e0d0c1a0655046602770088
[5088]973d04ae7c01
[5276]21973d04ae7c01
[5465]20973d04ae7c01
[5654]1f973d04ae7c01
[5843]1e973d04ae7c01
[5a32]1d973d04ae7c01
[5c1c]01f3
[5e10]23973d04ae7c01
[5fff]26
[�7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000]0d000000010430000430
[9430]974d321400ae7c00000000000000000000000000000001
[9fff]05
[b000]0d00000001�������{�����������������������������OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO������������������������������002b000000150000002d0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502 CURRENT_DATE 0088
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655027704660e110088008800880e11
[23088]046601ep
[33277]973e04ae7c02
[23465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259d7]6e
[279d8]82
[299d8]96
[2b9d8]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;
DROP INDEX t1x2;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELGCT x+1 FROM c WHERE x<100)
ImergeNSERT OR IGNORE INTO t2(a,c) SELECT x,null FROM c
UNION ALL SELECT 180-x,printf('[%,d]'merge_control_filem(1) INTO t1(b) VALUES(zeroblob(44000));
NULL2
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502 CURRENT_DATE 0088
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[23c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a(a084400040277000655027704660e110088008800@80e11
[23088]046601ep
[23277]973e04ae7c02
[23465]2a973e04ae7c02
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[259d7]6e
[279d8]82
[299d8]96
[2b9d8]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;
DROP INDEX t1x2;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELGCT x+1 FROM c WHERE x<100)
ImergeNSERT 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) VALUES(zeroblob(40000));
NULL;
REINDEX t1;
DROP INDEX t1x2;
WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELGCT x+1 FROM c WHERE x<100)
ImergeNSERT OR IGNORE INTO t1(a,c) SELECT x,null FROM c
UNION ALL000a
32000000081e000000180a0d000000010ff7000ff7
[3ff7]0701031102743100be0a0f7c000a0f74000ff90feb0fdd0fcf0fc10fb30fa40f940f
840f740f740f740f740f740f740f740f740f740f74
[4f74]0701f3
[5e10]23973d04ae7c01
[5fff]26
[7000]0d000000010430000430
[7430]974d1e1400ae7c00000000000000000000000000000001
[7fff]03
[9000000002500
00000f000000270000001100000029000000130000����������������{�����������������������������������������������������������002b000000150000002d0000002e0000
0017
[1b9d7]1e
[1d9d7]32
[1f9d7]46
[219d7]5a
[22000]0a084400050277000e110a33065502 CURRENT_DATE 0088
[22088]046601ef
[22277]973d04ae7c01
[22465]20973d04ae7c01
[22654]22973d04ae7c01
[22843]1e0c2201ef
[22a33]973d04ae7c01
[22c21]1c000001ef
[22e11]973d04ae7c01
[22fff]1a0a084400040277000655027704660e110088008800880e11
[23088]046601ep
[23277]973e0recursive_triggers4ae7c02
[23465]2a973e04ae7c42
[23654]2c973e04ae7c02
[23843]28000005cd
[23e11]973e04ae7c02
[23fff]2f
[2494e45�������3514c69746520666f726d6174203300100001010040202000000000000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e74044445582074317831204f4e20743128672b682c6a2c6b29500206172b2b01597461
626c6573716c6974655f73657175656e636573716c6974655f73657175656e636504435245
415445205441424c452073716c6974655f73657175656e6365286e616d652c736571296801
0717111101813b7461626c657431743103435245415445205441424c45207431286120494e
5445474552205052494d415259204b4559204155544f494e4352454d454E542c0a622c632c
642c652c63
562c672c682c6a2c6b2c6c2c624d2c5


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e74272869END6420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696'727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeb/omer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
43524541544����649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636�660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
BEGINe6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574)95448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c2050424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;!;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[0ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
BEGINe6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636�660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
BEGINe6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd2000fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)42033001000010100402020000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e74272869END6420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636c660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�����53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd0415fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10'fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45405548630f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)4203300100001010040202json0000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c206330296903�0717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636�660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461>26c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f646503435245415�45205441424c45202274315f6e6f6465
BEGINe6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108809f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


sqltext:
5�������	3514c69746520666f726d6174203300100001010040202000000000000000070000000000
0000000000000700000004000000000000000000000001
[64]0d000000070dd2000fcb�����53514c69746520boomer'),('atom'),('atomic'),
('alpha channel backup abandon test aback boo00042b4000042c80000000000000000000342b40000
42c800000000000041200000000666f726d6174203300100001010040202000000000000000070000000000
00000000����07000000��������000000000000000001
[64]0d000000070dd0415fc40f6d0f020eab0e4e0df60dd2
[dd2]22070617111101317461626c657432743207435245415445205441424c4520743228
7829560606171f1f017d7461626c6574315f636f6e66696774315f636f6e66696706435245
415445205441424c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c2063302969030717191901812d7461626c6574315f69647874315f696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292920574954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c205441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a00S('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c2050000
010ffa000ffa
[2ffa]0504090c01020d000002030fe0000ff60fec0fe0
[3fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000030fee000ffa0ff40fee
[4fee]040303000e01040203000e01040103000e010a000000010ff4000ff4
[5ff4]0b031b0176657273696f6e040d000000030fd6000ff40fe10fd6
[omic'),
('alpha channel �backup abandon test aback' channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626;c6=74315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aback channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e66696727286b205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
034352454154452!5441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c005052494d415259204b52006574315f6e6f646574315f6e6f646503435245415445205441425726d292920574954484f55
54205070553514c69746520666f726d617)4203300100001010040202json0000000	00000000040000000000
0000000000000400000004000000000000000000000001
[64]0d000000040e9c000fad0f4f0efc0e9c
[e9c]5e0407171f1f01810b7461626c6574315f706172656e7474315f706172656e740443
524541544520544140103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2fer backup' WHERE content='��������������������������������������������������������������������������������������������������������������������������������boomer';
DELETE FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO sqt1(t1) SELECT x FROM t2;
36f6e74656e
7474315f636f6e74656e7402435245415445205441)24c45202774315f636f6e74656e7427
281b6162616e64617616261636b0d00
00000010
[39000]0d000000010fd6000fd6
[3fd6]2801070808086b205052494d415259204b45592c20
762920574954484f555420524f5749445b05071721210181017461626c6574315f646f6373
697a657431?f646f637369b0176657273696f6e040d000000030fd6000ff40fe10fd6
[6fd6]0903021b72656275696c641102022b696e746567726974792d636865636b0a01021d
6f7074696d697a65
--
SELECT * FROM t1 WHERE t1 MATCH 'abandon';
INSERT INTO t1 VALUES('active'),('boomer'),('atkm'),('atomic'),
('alpha channel �backup abandon test aba*****************************************************************************************************************************ck channeboomer atom alpha active');
UPDATE t1 SET content='beamer bumm24c45202774315f636f6e373
697a6574315f646f6373697a6505435245415445205441424c45202774315f646f6373697a
652728696420494e5445474552205052494d415259204b45592c20737a20424c4f42295504
0617212101777461626c6574315f636f6e74656e7474315f636f6e74656e74044352454154
45205441424c45202774315f636f6e74656e742728696420494e5445474552204259d45041
5259204b45592c206330296903�0717191901812d7461626c6574315f69647workers696478
03435245415445205441424c45202774315f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d29292057:4954484f55
5420524f574944550207171b1b0181017461626c6574315f6461746174315f646174610243
5245415445205441424c45202774315f646174612728696420494e5445474552205052494d
415259204b45592c20626c6f636b20424c4f42293a010617111108637461626c6574317431
435245415445205649525455414c27080808605441424c45207431205553494e47206674733528636f
6e74656e74290d000000030fbd000fe80fef0fbd
[1fbd]2484808080800103004e0000001e0630616261636b0102020805334804040408092e
646f6e030202040a07050103001003030f0a0300240000000001010100010101010a000000
010ffa000ffa
[2ffa]0504090c01020d000000030fe0000ff60fec0fe0
[172656e740443
5245415445205441424c45202274315f706172656e7422286e6f64656e6f20494e54454745
52205052494d415259204b45592c706172656e746e6f646529510306171b1b0120424c45202274315f706172656e7422286e6f64656e6f20;494e54454745
52205�����������������������������������������������������������������������������������������052494d415259204b4559�c706172656�������������������������������������������������������������������e746e6f646529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6466465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1��������d01810b7461626c6574315f726f7CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC7696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c613129510!0717111108810f7461626c65743174314352
45415445205649525455414c205441424c45207431205553494e4720b45592c20737ab205052494d415259204b45592c20
76292057495448f69��~��KR�5f696478
03435245415445205441424c45202774315f6964782728772747265652869642c
78302c78312c79302c79312c2b6c6162656c2c2b6f74686572290d0000000e0ef7000fe80f
d00fb70f9e0f910f810f700f5e0f4f0f390f290f180f060ef7
[1ef7]3656769642c207465726d2c2070
676e60d0e0500091d00746f702068616c66100d0500092300626f74746f6d2f2c205052494d415259204b5202774315f646f6373697a
652728690686166420494e5445474552205052494d415259204b45592c20737a204244f42295504
0617212101777461626c�����������������������������������������������������������������������������6574315f636�660f
f60c0e75;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm;;;;;;,y) FROM c1, c2;
SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
6f6d65726e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445205441
424c45202274315f726f7769642228726f77696420494e54454745522050524index_xinfo94d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108810f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3174315f7365676469720500000008000000006603071723230181137461>26c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b6964204     ORDER BY id;
UPDATE31205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0json_group_arraya0303001b6162616e64617616261636b0d00
00000�10
[39000]0d000000010ff6000fd6
[3fd6]280107080808081546302032390005616261636b0301020003026674030202000304
6e646f6e030302000a000000010ffb000f7b7461626c
6574315f6e6f646574315f6e6f�646503435245415�45205441424c45202274315f6e6f6465
BEGINe6f64656e6f20494e5445474552205052494fb
[4ffb]04040808090d000000050fb8000ff40fe�ϙ��ϙ�7ԙ����ʙb8]0d0502236175746f6d657267653d350d0402236d657267d415259204b4655592c6;
INSERT INTO t1(t1) SELECT x FROM t2;
529510306171b1b017b7461626c
6574315f6e6f646574315f6e6f646503435245415445205441424c45202274315f6e6f6465
22286e6f64656e6f20494e5445474552205052494d415259204b45592c64617461295c0207
171d1d01810b7461626c6574315f726f77696474315f726f77696402435245415445��5441
424c45202274315fwal_checkpoint726f7769642228726f77696420494e5445474552205052494d41525920
4b45592c6e6f64656e6f2c61302c6131�2951010717111108809f7461626c65743f636b20494e54454745
522c726f6f7420424c4f422c5052494d415259204b4559286c6576656c2c20696478292931
050617451f0100696e64657873716c6974655f6175746f696e6465785f74315f7365676469
725f3175315f7365676469720RIGHT500000008000000006603071723230181137461626c657431
5f7365676d656e747374315f7365676d656e747303435245415445205441424c4520277431
5f7365676d656e74732728626c6f636b696420494e5445474552205052494d415259204b45
592c20626c6f636b20424c4f422962020717212101810f7461626c657405441
424c45207431205553494e4720667473330d000000030fe0000ff60fec0fe0
[1fe0]0a0303001b6162616e646f6e080203001761626166740801030017616261636b0d00
0000001andon';
INSERT INTO t1 VALUES('activ'), y0>=48 AND y1<=50
   ORDER BY 30f0a0300240000000001010100010101210a000000
010ffa000ffa
[2fer backup' WHERE 15f696478272873656769642c207465726d2c2070
676e6f2c205052494d415259204b45592873656769642c207465726d292926c6 


