Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(526)

Issues Search
    My Issues | Starred     Open | Closed | All

Side by Side Diff: third_party/sqlite/sqlite-src-3080704/test/whereJ.test

Issue 883353008: [sql] Import reference version of SQLite 3.8.7.4. (Closed) Base URL: http://chromium.googlesource.com/chromium/src.git@master
Patch Set: Hold back encoding change which is messing up patch. Created 5 years, 10 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/whereI.test ('k') | third_party/sqlite/sqlite-src-3080704/test/wherelimit.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
(Empty)
1 # 2014-06-06
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 #
12 # This file implements regression tests for a complex
13 # query planning case.
14 #
15
16 set testdir [file dirname $argv0]
17 source $testdir/tester.tcl
18 set ::testprefix whereJ
19
20 ifcapable !stat4 {
21 finish_test
22 return
23 }
24
25 do_execsql_test whereJ-1.0 {
26 CREATE TABLE tx1 (
27 est,
28 cid,
29 sid,
30 fid,
31 aid,
32 edate,
33 rstat,
34 ftype,
35 cx,
36 fyear,
37 fp,
38 acode,
39 a1,
40 curx,
41 tdate,
42 gstat,
43 trgtpx,
44 effdate,
45 adate,
46 ytime,
47 mstat
48 );
49 CREATE INDEX ix0 on tx1(a1,curx,aid,cid,sid,ftype,fp,fyear DESC,edate DESC,fid );
50 CREATE INDEX ix1 on tx1(a1,curx,aid,ftype,fp,fyear DESC,fid,edate DESC,cid,sid );
51 CREATE INDEX ix2 on tx1(a1,curx,cid,sid,ftype,fp,fyear DESC,edate DESC,aid,fid );
52 CREATE INDEX ix3 on tx1(a1,curx,fid,ftype,fp,fyear DESC,cid,sid,aid,edate DESC );
53 CREATE INDEX ix4 on tx1(a1,curx,ftype,cid,sid,aid,edate DESC,fid,fp,fyear DESC );
54 CREATE INDEX ix5 on tx1(a1,curx,ftype,aid,fid,cid,sid,edate DESC,fp,fyear DESC );
55 CREATE INDEX ix6 on tx1(ftype,fp,fyear DESC,cid,sid,edate DESC,a1,fid,aid,curx ,est,rstat,cx,acode,tdate,gstat,trgtpx,effdate,adate,ytime,mstat);
56 CREATE INDEX ix7 on tx1(cid,a1,curx,sid,ftype,est,fid,aid,edate,rstat,cx,fyear ,fp,acode,tdate,gstat,trgtpx,effdate,adate,ytime,mstat);
57 CREATE INDEX ix8 on tx1(cid,sid,edate DESC,aid,est);
58 CREATE INDEX ix9 on tx1(aid,edate DESC,a1,curx);
59 } {}
60 do_execsql_test whereJ-1.1 {
61 ANALYZE sqlite_master;
62 DELETE FROM sqlite_stat1;
63 DELETE FROM sqlite_stat4;
64 INSERT INTO sqlite_stat1 VALUES('tx1','ix9','11680827 289 2 2 2');
65 INSERT INTO sqlite_stat1 VALUES('tx1','ix8','11680827 286 250 2 2 2');
66 INSERT INTO sqlite_stat1 VALUES('tx1','ix7','11680827 286 194 98 88 83 18 7 6 2 2 2 2 2 2 2 2 2 2 2 2 2');
67 INSERT INTO sqlite_stat1 VALUES('tx1','ix6','11680827 5840414 5840414 5840414 240 212 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2');
68 INSERT INTO sqlite_stat1 VALUES('tx1','ix5','11680827 5840414 2920207 1668690 114 90 8 8 2 2 2');
69 INSERT INTO sqlite_stat1 VALUES('tx1','ix4','11680827 5840414 2920207 1668690 92 83 9 2 2 2 2');
70 INSERT INTO sqlite_stat1 VALUES('tx1','ix3','11680827 5840414 2920207 2048 183 5 1835 1835 12 11 8 2');
71 INSERT INTO sqlite_stat1 VALUES('tx1','ix2','11680827 5840414 2920207 98 88 83 83 83 2 2 2');
72 INSERT INTO sqlite_stat1 VALUES('tx1','ix1','11680827 5840414 2920207 117 114 114 114 90 2 2 2');
73 INSERT INTO sqlite_stat1 VALUES('tx1','ix0','11680827 5840414 2920207 117 9 9 9 9 9 2 2');
74 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','6736 21 21 21 1','29210 29404 294 04 29404 29424','44 12184 13020 13079 29424',X'06030409080416C1150133512800B01FC A');
75 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','6658 24 21 21 1','452220 453273 4 53276 453276 453296','622 226258 235279 236774 453296',X'06030409080416F34501332 ADC00AA1BD3');
76 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','820 2 2 2 1','1297771 1297869 129 7869 1297869 1297869','1964 681724 711020 715822 1297869',X'06030409080317875501 332C6C55AF4D');
77 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','26985 2216 2216 2216 1','1797607 1797782 1797782 1797782 1799997','3162 970307 1008879 1016089 1799997',X'0603040 809041A08040132401A0099A334');
78 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','10434 19 17 17 1','2118117 212040 3 2120405 2120405 2120421','3815 1136110 1181459 1190207 2120421',X'060304090804 1AD36901332CD000861A2F');
79 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','437 1 1 1 1','2595414 2595739 259 5739 2595739 2595739','5005 1409452 1464066 1475163 2595739',X'0603040808031CE7F D01317FD46BFBCC');
80 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','12619 38 38 38 1','2595957 260021 2 2600212 2600212 2600249','5007 1410347 1464961 1476068 2600249',X'060304080804 1CE87E01328F61008CE96A');
81 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','7534 23 18 18 1','3329985 3334890 3334895 3334895 3334912','6901 1834013 1902216 1917268 3334912',X'0603040908042 44E1901328F59008CAA39');
82 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','5693 1 1 1 1','3891665 3893609 38 93609 3893609 3893609','8357 2164400 2245393 2263185 3893609',X'0603040808043063 B70132B66800A28A43');
83 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','44405 2588 2223 1527 1','4220255 4221633 4221998 4222694 4224220','9221 2354858 2441973 2461511 4224220',X'060304 0909043377630133517A00B0DE4F');
84 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','6883 32 28 28 1','4423918 4429926 4429930 4429930 4429957','9690 2452276 2543443 2563995 4429957',X'0603040908043 4F46801328F5C008CC3DA');
85 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','6974 27 26 26 1','5048404 5051129 5051130 5051130 5051155','11703 2817010 2920184 2944013 5051155',X'060304090804 3C1C5C0132DEA5009F7473');
86 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','476 2 2 2 1','5191322 5191479 519 1479 5191479 5191479','12242 2901130 3006663 3031222 5191479',X'0603040908033DC6 080132DEA478849A');
87 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','627 4 4 4 1','6488823 6489349 648 9349 6489349 6489349','16423 3644815 3778857 3809866 6489349',X'0603040808035AA0 0E0131F4AE342150');
88 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','145 2 2 1 1','7787091 7787218 778 7218 7787219 7787219','20223 4343720 4510110 4547961 7787219',X'0603040809037254 890132189C703706');
89 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','20 1 1 1 1','9085074 9085089 9085 089 9085089 9085089','25315 5033102 5230788 5275692 9085089',X'06040408080300EAE 6CA01326657620652');
90 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','229621 6135 5934 5934 1','9507353 9572696 9572696 9572696 9576801','27189 5255584 5463962 5511784 9576801',X'0604 0408080300F2FA440132DF1A7D1A60');
91 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','6376 24 22 22 1','10381524 103829 38 10382940 10382940 10382959','30519 5581705 5804515 5856651 10382959',X'060404 09080400F9DBF3013305AC00A688A4');
92 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','7761 45 9 9 1','10569039 10572476 10572512 10572512 10572520','31455 5661599 5888691 5941811 10572520',X'06040409 080400FB31560132DDD800A05DF5');
93 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','8382 37 37 37 1','10866664 108675 65 10867565 10867565 10867601','33475 5809193 6042611 6097741 10867601',X'060404 09080400FFA4A701332A0E00A93957');
94 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','76136 4099 3018 3018 1','11283107 11308143 11309224 11309224 11312241','37001 6022861 6264510 6322923 11312241',X '060404090804010B0A5C0133517200B0E8E0');
95 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','23472 2188 2188 2181 1','11365285 11380281 11380281 11380288 11382468','37055 6026680 6268909 6327509 11382468',X '060404080904010B3C6701332B2E00AA4374');
96 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','59591 4087 4073 4 1','11415316 11 448759 11448773 11452842 11452845','37350 6040743 6283483 6342389 11452845',X'06 0404090904010BFA810133512800B010AE');
97 INSERT INTO sqlite_stat4 VALUES('tx1','ix9','43891 3029 3021 4 1','11598477 11 622881 11622889 11625906 11625909','39110 6107644 6353109 6413914 11625909',X'06 04040909040113B9960133512800B01235');
98 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7340 4977 19 1 1 1','206533 20653 3 208739 208757 208757 208757','125 164 111403 207397 207399 208757',X'070308040 407030187840132B54B0101A0D1401C0000000000004C87E5');
99 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','8877 8788 45 1 1 1','1221375 1221 375 1224509 1224553 1224553 1224553','931 1117 679933 1216705 1216722 1224553',X '07030804040703018D3F0133023D010B9B67401C0000000000007A99EF');
100 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7204 7204 39 1 1 1','1240162 1240 162 1242572 1242610 1242610 1242610','942 1131 688420 1234655 1234672 1242610',X '07030804040703018D4F0132DB820105D324401C0000000000007EC569');
101 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','9608 9608 44 1 1 1','1264939 1264 939 1266529 1266572 1266572 1266572','952 1145 699518 1258423 1258440 1266572',X '07030804040704018D61013305B9010D3CEB406E8000000000000081E17A');
102 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','6636 6636 1 1 1 1','1294580 12945 80 1297869 1297869 1297869 1297869','964 1159 713121 1289522 1289540 1297869',X' 07030804030704018D7801328F693482A2403400000000000000A26728');
103 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7822 6629 26 1 1 1','2375708 2375 708 2381333 2381358 2381358 2381358','3423 3833 1371902 2366527 2366559 2381358' ,X'0703080403070301B1F501317F16403B7B403F00000000000060D67A');
104 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','1403 1303 5 1 1 1','2594767 25947 67 2595737 2595739 2595739 2595739','3914 4427 1512042 2580073 2580114 2595739', X'0703080403070301B6480131CC18558082407120000000000029CC12');
105 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7901 6067 26 1 1 1','3424107 3424 107 3425939 3425964 3425964 3425964','5872 6630 2032411 3406550 3406594 3425964' ,X'0703080404070401C3F90132B7A100FDCC04403E00000000000000A014CE');
106 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7483 6161 22 1 1 1','3549446 3549 446 3555223 3555244 3555244 3555244','5932 6752 2099309 3535259 3535304 3555244' ,X'0703080403070301C4490131573F4104F8403400000000000067FD1E');
107 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','12076 8263 37 1 1 1','3558079 355 8079 3560036 3560072 3560072 3560072','5935 6758 2101989 3540078 3540123 3560072 ',X'0703080404070301C44E0132DD0901076DA9404200000000000076F994');
108 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','1123 1113 1 1 1 1','3892913 38929 13 3893609 3893609 3893609 3893609','6594 7611 2305483 3871711 3871770 3893609', X'0703080403070301CA280131CA1C215083401C00000000000071F6B2');
109 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','9344 7315 41 1 1 1','4213510 4213 510 4219434 4219474 4219474 4219474','7200 8390 2503024 4196141 4196204 4219474' ,X'0703080404070301CE8C01317DE800FE4E8B4034000000000000458317');
110 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','8062 3291 1 1 1 1','5037060 50370 60 5040350 5040350 5040350 5040350','10201 11915 3045602 5012912 5012997 5040350 ',X'070308040307030213B20130B83A16DF86403600000000000028F8CD');
111 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','9125 2926 1 1 1 1','5046490 50526 65 5055590 5055590 5055590 5055590','10203 11926 3055524 5028097 5028182 5055590 ',X'070302040307030213B5232A013107F01745AF40330000000000002B57DE');
112 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','591 591 1 1 1 1','5190991 5190991 5191479 5191479 5191479 5191479','10649 12426 3145181 5163206 5163296 5191479', X'070308040307030244AD0131315217C1CD401C00000000000003BC32');
113 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7381 4689 1 1 1 1','6112248 61122 48 6116936 6116936 6116936 6116936','13780 16308 3748958 6083681 6083797 6116936 ',X'0703080403070402A9D1013108B531A21C401C0000000000000092F5C6');
114 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7569 7381 28 1 1 1','6280084 6280 084 6281842 6281869 6281869 6281869','14559 17217 3856803 6247722 6247841 628186 9',X'0703080404070302C14C0132DBF101044CC7401C00000000000074FB16');
115 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','8289 7047 28 1 1 1','6290764 6290 764 6296854 6296881 6296881 6296881','14569 17229 3863206 6262658 6262777 629688 1',X'0703080403070302C16401317CC348B670401C0000000000006824BB');
116 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','2209 2209 1 1 1 1','6489075 64890 75 6489349 6489349 6489349 6489349','15377 18147 3986912 6454194 6454318 6489349 ',X'0703080403070402EA5901332A656C6F5E401C00000000000000AE7C03');
117 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7381 6799 1 1 1 1','7314420 73144 20 7321218 7321218 7321218 7321218','18403 21722 4532963 7281695 7281847 7321218 ',X'07030804030703049EE501310667176DC940438000000000005ED2B5');
118 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','7163 7001 31 1 1 1','7652849 7652 849 7658600 7658630 7658630 7658630','19462 22956 4750159 7617449 7617608 765863 0',X'070308040407030503EB01317DEF010ADD3F402800000000000061C3EF');
119 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','1433 1433 2 1 1 1','7785842 77858 42 7787219 7787219 7787219 7787219','20001 23575 4834605 7745315 7745477 7787219 ',X'07030804030703055010013156D81B11AC404380000000000004A313');
120 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','2247 2247 1 1 1 1','9083272 90832 72 9085089 9085089 9085089 9085089','24940 29143 5668423 9036693 9036887 9085089 ',X'070308040307031A620A01323EEB5CE39C406FE000000000006F8177');
121 INSERT INTO sqlite_stat4 VALUES('tx1','ix8','107 107 5 1 1 1','10382912 103829 12 10382957 10382959 10382959 10382959','31251 36297 6541362 10329764 10330008 1 0382959',X'0704080403070400955501013350516AA9D0406060000000000000884648');
122 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7340 4770 4527 3331 3331 970 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','206533 206533 206533 206533 206533 206596 207565 2 07565 207565 207565 207565 207565 207565 207565 207565 207565 207565 207565 2075 65 207565 207565 207565','125 202 402 512 560 6209 20696 25885 206260 206260 206 260 206260 206260 206260 206260 206260 206260 206260 206260 206260 206260 207565 ',X'1703080808080704030408030808010308070808080803018784401C000000000000024FD353 493F8801317E4700FFFF0F00FFFFC0F869E0000000002642C5');
123 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','8877 4669 71 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','1221375 1225583 1230181 1230249 1230249 1230251 1230251 1230 251 1230251 1230251 1230251 1230251 1230251 1230251 1230251 1230251 1230251 1230 251 1230251 1230251 1230251 1230251','931 1504 2992 3495 3751 39629 120561 14742 4 1222711 1222711 1222711 1222711 1222711 1222711 1222711 1222711 1222711 122271 1 1222711 1222711 1222711 1230251',X'1703090902080704030408090808010108070404040 804018D3F03E8405680000000000000822B981EB823013351F00F0C4086E00000000000013351F00 13351F053870D7500B22A8C');
124 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7204 4801 193 193 4 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','1240162 1240162 1244770 1244770 1244959 1244961 1244962 1 244962 1244962 1244962 1244962 1244962 1244962 1244962 1244962 1244962 1244962 1 244962 1244962 1244962 1244962 1244962','942 1520 3024 3531 3791 40098 122274 14 9540 1237296 1237296 1237296 1237296 1237296 1237296 1237296 1237296 1237296 123 7296 1237296 1237296 1237296 1244962',X'1703080908010703030408030808010308070408 040803018D4F07406FE000000000000602CF16DE05013303C300FFFF0300FFFFC0F869E000000000 013303C3008000004BD756');
125 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','9608 6098 5910 5910 5910 2149 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','1264939 1264939 1264939 1264939 1264939 1265217 1 267365 1267365 1267365 1267365 1267365 1267365 1267365 1267365 1267365 1267365 1 267365 1267365 1267365 1267365 1267365 1267365','952 1536 3055 3576 3841 40616 1 24132 151876 1259547 1259547 1259547 1259547 1259547 1259547 1259547 1259547 125 9547 1259547 1259547 1259547 1259547 1267365',X'17030808080807040304080908080101 01070404040803018D61401C0000000000000131374D1726AB0132DD780F0C054039000000000000 0132DD780132DD784E2789C6190CA9');
126 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','6636 4411 4237 4237 4237 33 8 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1','1294580 1294580 1294580 1294580 1294580 1297842 129 7862 1297862 1297869 1297869 1297869 1297869 1297869 1297869 1297869 1297869 129 7869 1297869 1297869 1297869 1297869 1297869','964 1557 3097 3622 3888 41246 126 538 154868 1289863 1289863 1289863 1289863 1289863 1289863 1289863 1289863 12898 63 1289863 1289863 1289863 1289863 1297869',X'1703080808080703030408090808010308 070808080803018D7840420000000000007332F1227B5901321AF80800FFFF40260000000000006D 0CEB');
127 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7822 4817 260 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','2375708 2375708 2380265 2380524 2380524 2380524 2380524 238 0524 2380524 2380524 2380524 2380524 2380524 2380524 2380524 2380524 2380524 238 0524 2380524 2380524 2380524 2380524','3423 5117 10120 11184 11775 86237 242937 294878 2366404 2366404 2366404 2366404 2366404 2366404 2366404 2366404 2366404 2 366404 2366404 2366404 2366404 2380524',X'17030809030807030404080308080103080704 0408080401B1F501831C405C40000000000077646800EAD44C0132697000FFFF0300FFFFC0F869E0 000000000132696F0132696F0094935E');
128 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','1403 1022 82 74 74 55 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','2594767 2594767 2595707 2595707 2595707 2595708 2595739 2 595739 2595739 2595739 2595739 2595739 2595739 2595739 2595739 2595739 2595739 2 595739 2595739 2595739 2595739 2595739','3914 5817 11518 12879 13613 98100 27830 4 342850 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2580971 2595739',X'170308090808070303040803080801030807 080808080301B648405C400000000000038EAC243F770131A6F700FFFF0E00FFFFC0F869E0000000 005C8664');
129 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7901 5298 291 55 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','3424107 3424107 3429114 3429350 3429404 3429404 3429404 34 29404 3429404 3429404 3429404 3429404 3429404 3429404 3429404 3429404 3429404 34 29404 3429404 3429404 3429404 3429404','5872 8944 17727 19769 20846 145206 40199 5 498360 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3411279 3429404',X'170308090201070404040803080801030807 040808080401C3F9232807405C40000000000000FF559400F2FA440133294600FFFF0300FFFFC0F8 69E000000000013329460083157B');
130 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7483 5407 230 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','3549446 3549446 3554623 3554845 3554852 3554852 3554852 355 4852 3554852 3554852 3554852 3554852 3554852 3554852 3554852 3554852 3554852 355 4852 3554852 3554852 3554852 3554852','5932 9041 17921 20139 21264 149060 417718 520064 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3536268 3554852',X'1703080902010704040408030808010308070 40808080401C449232807405C40000000000000FF559400F2FA440133294600FFFF0300FFFFC0F86 9E000000000013329460083162A');
131 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','12076 8365 7981 5546 5546 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','3558079 3558079 3558079 3558079 3558079 3563624 356 3624 3563624 3563624 3563624 3563624 3563624 3563624 3563624 3563624 3563624 356 3624 3563624 3563624 3563624 3563624 3563624','5935 9046 17930 20154 21279 14923 5 418443 521109 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3544970 3563624',X'17030808080807030304080308080 1030107040408080301C44E4074300000000000029EB13BB98E01328EFE00FFFF0E00FFFF0AC0F86 9E00000000001328F0001328F0071D802');
132 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','1123 916 875 875 875 93 22 22 1 1 1 1 1 1 1 1 1 1 1 1 1 1','3892913 3892913 3892913 3892913 3892913 3893531 38936 02 3893602 3893609 3893609 3893609 3893609 3893609 3893609 3893609 3893609 38936 09 3893609 3893609 3893609 3893609 3893609','6594 10057 19942 22653 23964 165533 468498 587524 3873325 3873325 3873325 3873325 3873325 3873325 3873325 3873325 3 873325 3873325 3873325 3873325 3873325 3893609',X'170308080808070403040802080801 030107040404080301CA28403F00000000000000832DC71933330132DB8800FC0F00FFFF054050C0 00000000000132DB870132DB8A4D5E35A2107205');
133 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','9344 6359 6022 9 9 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','4213510 4213510 4213510 4219523 4219523 4219531 4219531 42 19531 4219531 4219531 4219531 4219531 4219531 4219531 4219531 4219531 4219531 42 19531 4219531 4219531 4219531 4219531','7200 11025 21872 25036 26543 181203 5173 45 652858 4198057 4198057 4198057 4198057 4198057 4198057 4198057 4198057 419805 7 4198057 4198057 4198057 4198057 4219531',X'17030808030807030304080308080103080 7080808080301CE8C0186A0403F00000000000002C2142F19870131554100FFFF0F00FFFFC0F869E 0000000000687F7');
134 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','8062 4993 241 53 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','5037060 5037060 5041812 5042000 5042051 5042052 5042052 50 42052 5042052 5042052 5042052 5042052 5042052 5042052 5042052 5042052 5042052 50 42052 5042052 5042052 5042052 5042052','10201 15484 30736 35196 37326 231854 654 010 829510 5017193 5017193 5017193 5017193 5017193 5017193 5017193 5017193 50171 93 5017193 5017193 5017193 5017193 5042052',X'1703080902010703040408030808010308 0704080808030213B2245407406FE0000000000002C0AA00F6ABA101332A7E00FFFF0300FFFFC0F8 69E00000000001332A7E5287C0');
135 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','9125 5761 264 5 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','5046490 5046490 5051987 5052246 5052246 5052250 5052250 505 2250 5052250 5052250 5052250 5052250 5052250 5052250 5052250 5052250 5052250 505 2250 5052250 5052250 5052250 5052250','10203 15488 30744 35230 37365 232178 6549 64 830718 5027358 5027358 5027358 5027358 5027358 5027358 5027358 5027358 502735 8 5027358 5027358 5027358 5027358 5052250',X'17030809030807030304080308080103080 708080808030213B501831F406FE00000000000029E627136F901328DD500FFFF0300FFFFC0F869E 000000000290DD6');
136 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','591 591 566 566 566 27 18 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1','5190991 5190991 5190991 5190991 5190991 5191461 5191464 5191474 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479','10649 16115 31973 36593 38793 239550 673441 853755 5165855 5165855 5165855 5165855 5165855 5165855 5165855 5165855 51 65855 5165855 5165855 5165855 5165855 5191479',X'1703080808080703040408010808010 1080708080808040244AD4045800000000000029E6200EAE8740132690D0A0F0C402E00000000000 000941EAF');
137 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7381 3728 83 16 16 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','6112248 6115901 6119546 6119613 6119613 6119628 6119628 61 19628 6119628 6119628 6119628 6119628 6119628 6119628 6119628 6119628 6119628 61 19628 6119628 6119628 6119628 6119628','13780 20707 41067 47538 50438 296473 834 203 1056686 6089878 6089878 6089878 6089878 6089878 6089878 6089878 6089878 6089 878 6089878 6089878 6089878 6089878 6119628',X'170309090208070304040809080801010 807040404080402A9D12328407360000000000002172300EABCFF0133517F0F0C404AA6665E02EA9 60133517F01335239538BC5C1008B5EC9');
138 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7569 5785 274 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','6280084 6280084 6285595 6285867 6285868 6285868 6285868 628 5868 6285868 6285868 6285868 6285868 6285868 6285868 6285868 6285868 6285868 628 5868 6285868 6285868 6285868 6285868','14559 21811 43240 50020 53057 307264 8628 71 1092992 6255378 6255378 6255378 6255378 6255378 6255378 6255378 6255378 62553 78 6255378 6255378 6255378 6255378 6285868',X'1703080903010704040408030808010308 07040808080302C14C01832707405C40000000000000FF559400F2FA440133294600FFFF0300FFFF C0F869E000000000013329461E5109');
139 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','8289 5734 266 33 3 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','6290764 6290764 6296232 6296465 6296495 6296495 6296497 62 96497 6296497 6296497 6296497 6296497 6296497 6296497 6296497 6296497 6296497 62 96497 6296497 6296497 6296497 6296497','14569 21827 43272 50056 53096 307563 864 043 1094585 6265950 6265950 6265950 6265950 6265950 6265950 6265950 6265950 6265 950 6265950 6265950 6265950 6265950 6296497',X'170308090201070404040803080801030 807040808080402C164232807405C40000000000000FF559400F2FA440133294600FFFF0300FFFFC 0F869E0000000000133294600A90415');
140 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','2209 1450 1369 1369 1369 597 13 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1','6489075 6489075 6489075 6489075 6489075 6489139 6 489344 6489344 6489349 6489349 6489349 6489349 6489349 6489349 6489349 6489349 6 489349 6489349 6489349 6489349 6489349 6489349','15377 22998 45584 52641 55837 3 19564 895653 1134252 6458046 6458046 6458046 6458046 6458046 6458046 6458046 645 8046 6458046 6458046 6458046 6458046 6458046 6489349',X'170308080808070303040802 080801030807040404080302EA59401C0000000000000D4B201AD8B30132DF0400FC0600FFFF4018 0000000000000132DF040132DF054EBA338714FBBA');
141 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7381 5446 171 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','7314420 7314420 7319695 7319855 7319865 7319865 7319865 73 19865 7319865 7319865 7319865 7319865 7319865 7319865 7319865 7319865 7319865 73 19865 7319865 7319865 7319865 7319865','18403 27319 54152 62541 66337 369851 103 2180 1306261 7284923 7284923 7284923 7284923 7284923 7284923 7284923 7284923 728 4923 7284923 7284923 7284923 7284923 7319865',X'17030809020107030304080308080103 08070408080804049EE503E907405C400000000000029EC32E97BE0133061F00FFFF0300FFFFC0F8 69E0000000000133061F00A9ECEF');
142 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','7163 4782 209 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','7652849 7652849 7657422 7657626 7657630 7657630 7657630 765 7630 7657630 7657630 7657630 7657630 7657630 7657630 7657630 7657630 7657630 765 7630 7657630 7657630 7657630 7657630','19462 28830 57147 65962 69945 388539 1084 446 1372423 7621247 7621247 7621247 7621247 7621247 7621247 7621247 7621247 7621 247 7621247 7621247 7621247 7621247 7657630',X'170308090201070404040803080801030 80704080808040503EB03EA07405C40000000000000FF559400F2FA440133294600FFFF0300FFFFC 0F869E0000000000133294600831554');
143 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','1433 582 571 571 571 15 15 15 1 1 1 1 1 1 1 1 1 1 1 1 1 1','7785842 7786693 7786693 7786693 7786693 7787208 77872 08 7787208 7787219 7787219 7787219 7787219 7787219 7787219 7787219 7787219 77872 19 7787219 7787219 7787219 7787219 7787219','20001 29582 58632 67649 71736 39684 0 1107204 1400830 7750264 7750264 7750264 7750264 7750264 7750264 7750264 775026 4 7750264 7750264 7750264 7750264 7750264 7787219',X'170309080808070304040809080 8010108070404040804055010406E80000000000001C7A600FC429201332D890F0C402C000000000 00001332D890133505352D7248A008775D8');
144 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','2247 682 657 657 657 117 45 45 1 1 1 1 1 1 1 1 1 1 1 1 1 1','9083272 9084837 9084837 9084837 9084837 9085088 9085 088 9085088 9085089 9085089 9085089 9085089 9085089 9085089 9085089 9085089 9085 089 9085089 9085089 9085089 9085089 9085089','24940 36384 72113 82665 87632 4749 87 1318830 1664527 9042708 9042708 9042708 9042708 9042708 9042708 9042708 90427 08 9042708 9042708 9042708 9042708 9042708 9085089',X'17030908080807030304080208 080103010704040408031A620A403E00000000000001C3D332CF850132DE9D00FC0200FFFF054050 E000000000000132DE9D0132DE9D4E8C092E790553');
145 INSERT INTO sqlite_stat4 VALUES('tx1','ix7','107 77 69 69 69 11 5 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1','10382912 10382942 10382942 10382942 10382942 10382952 103829 56 10382956 10382959 10382959 10382959 10382959 10382959 10382959 10382959 10382 959 10382959 10382959 10382959 10382959 10382959 10382959','31251 45639 90416 10 2896 109225 567280 1544395 1943661 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10337289 10382959 ',X'170409080808070303040809080801010807040404080300955501403E000000000000029E68 6E250B01332D220F0C402E00000000000001332D220133504E52CFCF4F21CD7F');
146 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7337 4 975 19 19 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 206462 206462 210789 210789 2108 07 210807 210807 210807 210807 210807 210807 210807 210807 210807 210807 210807 210807 210807 210807','0 0 0 125 164 112407 128579 207456 209489 209490 209490 2 09490 209490 209490 209490 209490 209490 209490 209490 209490 209490 210807',X'1 70808080308040804030807080301030807080808080301878401317F26024FD3531E2DAF4042000 00000000000FFFF0200FFFFC0F869E0000000002642C4');
147 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 8874 8 785 45 25 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 1221012 1221012 1224145 1224165 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189 1224189','0 0 0 931 1117 679896 773861 1207582 1 216653 1216673 1216673 1216673 1216673 1216673 1216673 1216673 1216673 1216673 1 216673 1216673 1216673 1224189',X'1708080803080409040408070809010308070404040803 018D3F0133023D01940C420106B14D40420000000000000F00FFFF4070E000000000000133023D01 33023D4F2053654AE525');
148 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7200 7 200 39 15 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 1239793 1239793 1242199 1242223 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237 1242237','0 0 0 942 1131 688381 783660 1225441 1 234602 1234622 1234622 1234622 1234622 1234622 1234622 1234622 1234622 1234622 1 234622 1234622 1234622 1242237',X'1708080803080409040308070809010301070404040804 018D4F0132DB820113FAB92F19C5401C0000000000000F00FFFF0F403A0000000000000132DB8201 32DB824D542A4F009B5C72');
149 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 9606 9 606 44 25 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 1264560 1264560 1266149 1266168 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192 1266192','0 0 0 952 1145 699479 796008 1249062 1 258369 1258391 1258391 1258391 1258391 1258391 1258391 1258391 1258391 1258391 1 258391 1258391 1258391 1266192',X'1708080803080409040308070809010101070404040803 018D61013305B9017CDF4916F8B140280000000000000F0C0A403600000000000001330557013305 B9507EA8DD212E79');
150 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 6635 6 635 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 1294199 1294199 1297868 1297869 12 97869 1297869 1297869 1297869 1297869 1297869 1297869 1297869 1297869 1297869 12 97869 1297869 1297869 1297869 1297869','0 0 0 964 1159 713241 812408 1280435 128 9849 1289871 1289871 1289871 1289871 1289871 1289871 1289871 1289871 1289871 128 9871 1289871 1289871 1297869',X'170808080308040903030807080301030807080808080301 8D78013267DC0EF747387106403F00000000000000FFFF0F00FFFFC0F869E00000000006B968');
151 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7815 6 624 26 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 2374939 2374939 2380559 2380584 2 380584 2380584 2380584 2380584 2380584 2380584 2380584 2380584 2380584 2380584 2 380584 2380584 2380584 2380584 2380584','0 0 0 3423 3833 1371803 1539928 2350493 2366415 2366460 2366460 2366460 2366460 2366460 2366460 2366460 2366460 2366460 2366460 2366460 2366460 2380584',X'17080808030804090303080708030103080708080808 0301B1F501317F160DDEA51C46AB405280000000000000FFFF0F00FFFFC0F869E0000000006ADDA9 ');
152 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 3595 3 459 10 7 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 2595336 2595336 2595734 2595737 2 595739 2595739 2595739 2595739 2595739 2595739 2595739 2595739 2595739 2595739 2 595739 2595739 2595739 2595739 2595739','0 0 0 3918 4433 1512586 1693312 2557025 2580917 2580967 2580967 2580967 2580967 2580967 2580967 2580967 2580967 2580967 2580967 2580967 2580967 2595739',X'17080808030804090303080708010101010704040408 0301B64F01332ACC029E833D19084028000000000000320F0C054074A0000000000001332A090133 2ACC518A316F1F30D6');
153 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7894 6 061 26 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 3422592 3422592 3424418 3424434 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443 3424443','0 0 0 5872 6630 2032185 2267240 336672 7 3406294 3406363 3406363 3406363 3406363 3406363 3406363 3406363 3406363 340636 3 3406363 3406363 3406363 3424443',X'1708080803080409040308070801010308070404040 80401C3F90132B7A100D6FD7F6CE97F4070500000000000100F00FFFF40560000000000000132B73 10132DB2D4D3F72D9009AE8EE');
154 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7479 6 158 22 22 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 3547845 3547845 3553619 3553619 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640 3553640','0 0 0 5932 6752 2099067 2343370 349167 9 3534981 3535053 3535053 3535053 3535053 3535053 3535053 3535053 3535053 353505 3 3535053 3535053 3535053 3553640',X'1708080803080408040308070803010308070808080 80301C4490131573F008E7AC03077E0403E00000000000000FFFF0F00FFFFC0F869E00000000065B 45A');
155 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 12068 8257 37 17 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 3556474 3556474 3558426 3558446 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462 3558462','0 0 0 5935 6758 2101744 2346448 34964 04 3539797 3539869 3539869 3539869 3539869 3539869 3539869 3539869 3539869 35398 69 3539869 3539869 3539869 3558462',X'170808080308040904030807080201010107040404 080301C44E0132DD09016891C11788EB404200000000000000FC0F0C0F400199999999999A0132DD 090132DD094DE5DCE3763299');
156 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 1510 1 497 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 3892149 3892149 3893609 3893609 38 93609 3893609 3893609 3893609 3893609 3893609 3893609 3893609 3893609 3893609 38 93609 3893609 3893609 3893609 3893609','0 0 0 6596 7614 2306358 2572095 3823194 3873232 3873319 3873319 3873319 3873319 3873319 3873319 3873319 3873319 3873319 3873319 3873319 3873319 3893609',X'170808080308040803030807080301030807080808080 301CA2E01312E3A038EE6257265400000000000000000FFFF0600FFFFC0F869E00000000032518F' );
157 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 9341 7 313 41 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 4211282 4211282 4217204 4217243 4 217244 4217244 4217244 4217244 4217244 4217244 4217244 4217244 4217244 4217244 4 217244 4217244 4217244 4217244 4217244','0 0 0 7200 8390 2502650 2792131 4139620 4195704 4195798 4195798 4195798 4195798 4195798 4195798 4195798 4195798 4195798 4195798 4195798 4195798 4217244',X'17080808030804090303080708030103080708080808 0301CE8C01317DE8029E9D3B6D23403E00000000000000FFFF0F00FFFFC0F869E00000000008EF7D ');
158 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 8055 3 290 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 5033936 5033936 5037225 5037225 50 37225 5037225 5037225 5037225 5037225 5037225 5037225 5037225 5037225 5037225 50 37225 5037225 5037225 5037225 5037225','0 0 0 10201 11915 3045026 3383481 494132 3 5012256 5012369 5012369 5012369 5012369 5012369 5012369 5012369 5012369 501236 9 5012369 5012369 5012369 5037225',X'1708080803080409030308070803080308070808080 8030213B20130B83A018A7516DF86403600000000000000FFFF00FFFFC0F869E00000000028F8CD' );
159 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 9117 2 923 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 5043358 5049528 5052450 5052450 50 52450 5052450 5052450 5052450 5052450 5052450 5052450 5052450 5052450 5052450 50 52450 5052450 5052450 5052450 5052450','0 0 0 10203 11926 3054947 3394812 495640 8 5027439 5027552 5027552 5027552 5027552 5027552 5027552 5027552 5027552 502755 2 5027552 5027552 5027552 5052450',X'1708080803020408030308070803010308070808080 8030213B5232A013107F00217231745AF403300000000000000FFFF0200FFFFC0F869E0000000002 B57DE');
160 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 333 33 3 4 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 5191271 5191271 5191479 5191479 5191 479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191479 5191 479 5191479 5191479 5191479 5191479','0 0 0 10672 12452 3147059 3494842 5093162 5165710 5165827 5165827 5165827 5165827 5165827 5165827 5165827 5165827 5165827 5165827 5165827 5165827 5191479',X'170808080308040803030807080301030807080808080 30244F00131CB4201C1C917188E403F00000000000000FFFF0800FFFFC0F869E00000000001C5CB' );
161 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7374 4 684 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 6107894 6107894 6112577 6112577 61 12577 6112577 6112577 6112577 6112577 6112577 6112577 6112577 6112577 6112577 61 12577 6112577 6112577 6112577 6112577','0 0 0 13780 16308 3748117 4153600 599577 6 6082692 6082834 6082834 6082834 6082834 6082834 6082834 6082834 6082834 608283 4 6082834 6082834 6082834 6112577',X'1708080803080408030308070803010308070808080 80402A9D1013108B5029E6831A21C401C00000000000000FFFF0200FFFFC0F869E0000000000092F 5C6');
162 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7562 7 376 28 11 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 6275521 6275521 6277274 6277291 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301 6277301','0 0 0 14559 17217 3855913 4271255 6156 622 6246677 6246823 6246823 6246823 6246823 6246823 6246823 6246823 6246823 6246 823 6246823 6246823 6246823 6277301',X'17080808030804090403080708020103010704040 4080302C14C0132DBF100832DC739FF53403F00000000000000FC0F00FFFF05402C0000000000000 132DBF10132DBF34D89B7AA1114CB');
163 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 8282 7 043 28 28 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 6286191 6286191 6292277 6292277 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304 6292304','0 0 0 14569 17229 3862314 4278722 6171 137 6261611 6261757 6261757 6261757 6261757 6261757 6261757 6261757 6261757 6261 757 6261757 6261757 6261757 6292304',X'17080808030804080403080708030103080708080 8080302C16401317CC301B5AA4A1AB270405680000000000000FFFF0F00FFFFC0F869E0000000004 8FD4C');
164 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 3101 3 101 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 6486495 6486495 6489349 6489349 64 89349 6489349 6489349 6489349 6489349 6489349 6489349 6489349 6489349 6489349 64 89349 6489349 6489349 6489349 6489349','0 0 0 15379 18149 3988504 4417216 636379 6 6457879 6458036 6458036 6458036 6458036 6458036 6458036 6458036 6458036 645803 6 6458036 6458036 6458036 6489349',X'1708080803080408030308070803010308070808080 80302EA6601317F7301C3EB17C4CE401C00000000000000FFFF0F00FFFFC0F869E00000000039819 8');
165 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 7379 6 798 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 7308682 7308682 7315479 7315479 73 15479 7315479 7315479 7315479 7315479 7315479 7315479 7315479 7315479 7315479 73 15479 7315479 7315479 7315479 7315479','0 0 0 18403 21722 4531809 5008068 717230 4 7280343 7280536 7280536 7280536 7280536 7280536 7280536 7280536 7280536 728053 6 7280536 7280536 7280536 7315479',X'1708080803080408040308070803010308070808080 803049EE501310667008390D0176DC9404380000000000000FFFF0500FFFFC0F869E0000000005ED 2B5');
166 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 211 21 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 7787150 7787150 7787219 7787219 7787 219 7787219 7787219 7787219 7787219 7787219 7787219 7787219 7787219 7787219 7787 219 7787219 7787219 7787219 7787219','0 0 0 20027 23602 4837427 5341824 7634169 7750020 7750224 7750224 7750224 7750224 7750224 7750224 7750224 7750224 7750224 7750224 7750224 7750224 7787219',X'170808080308040803030807080901030807040408080 30550B30132B73501A79C17C3D840340000000000000F00FFFF40140000000000000132B6D00132B 7400D1DB9');
167 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 26 26 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 9085083 9085083 9085088 9085088 908508 9 9085089 9085089 9085089 9085089 9085089 9085089 9085089 9085089 9085089 908508 9 9085089 9085089 9085089 9085089','0 0 0 24964 29171 5671673 6246216 8904392 90 42441 9042684 9042684 9042684 9042684 9042684 9042684 9042684 9042684 9042684 90 42684 9042684 9042684 9085089',X'17080808030804080303080708030103080708080808031 AA25C0131CA197A6D831B1D84401C00000000000000FFFF0F00FFFFC0F869E00000000071E307');
168 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','11668540 11668540 11668540 1261 1 261 9 8 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','0 0 0 10381872 10381872 10382956 1038295 6 10382959 10382959 10382959 10382959 10382959 10382959 10382959 10382959 103829 59 10382959 10382959 10382959 10382959 10382959 10382959','0 0 0 31297 36344 654 5140 7198586 10180602 10336983 10337266 10337266 10337266 10337266 10337266 1033 7266 10337266 10337266 10337266 10337266 10337266 10337266 10382959',X'170808080 40804080303080708010101080708080808030095A4C401321BB603010141073C401C00000000000 0080F0C40308000000000007E55BE');
169 INSERT INTO sqlite_stat4 VALUES('tx1','ix6','12287 12287 12287 17 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1','11668540 11668540 11668540 11672111 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127 11672127','1 1 1 43128 49 243 7431284 8170740 11452355 11624787 11625093 11625093 11625093 11625093 116250 93 11625093 11625093 11625093 11625093 11625093 11625093 11625093 11672127',X'17 01080803020408040409070803010308070408040804070267C127130133041E00AB540900E64074 405C40000000000000FFFF0300FFFFC0F869E0000000000133041E0080000000A3EE16');
170 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 24157 241 57 29 29 1 1 1 1','0 0 0 1236590 1236590 1251799 1251799 1251827 1251827 1251827 1251827','0 0 0 3120 4771 71527 72755 1238782 1238782 1238782 1251827',X'0C0808 0803040308040808031A080400FF5594029BB30131CD372B1368');
171 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 1209 1209 129 129 1 1 1 1','0 0 0 1296873 1296873 1297744 1297744 1297869 1297869 1297869 1297869','0 0 0 3203 4902 74577 75831 1284645 1284645 1284645 1297869',X'0C0808 0803030308040808041A215F04C9D901B0A30131066F0087162A');
172 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 12129 926 1 428 428 1 1 1 1','0 0 0 1790076 1790076 1790076 1790076 1790503 1790503 179050 3 1790503','0 0 0 4938 7561 108783 110860 1774402 1774402 1774402 1790503',X'0C0 8080803030308040808031CE87E029E6B018700013219C1373BA8');
173 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 273 273 5 5 1 1 1 1','0 0 0 2595625 2595625 2595738 2595738 2595739 2595739 2595739 25957 39','0 0 0 7863 12132 166423 169877 2575172 2575172 2575172 2595739',X'0C0808080 3030308040808042F020502DA0E02C73A0133049700A711F8');
174 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 7735 7735 29 29 1 1 1 1','0 0 0 2924165 2924165 2929754 2929754 2929782 2929782 2929782 2 929782','0 0 0 9123 14045 191316 195293 2907742 2907742 2907742 2929782',X'0C080 808030403080408080333776300FF559475928D013329435A824F');
175 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 360 229 2 7 27 1 1 1 1','0 0 0 3893374 3893505 3893605 3893605 3893609 3893609 3893609 389 3609','0 0 0 13912 21124 273265 278784 3866425 3866425 3866425 3893609',X'0C0808 0803030308040808044717710E070B01E88F0131A5B80098D0A5');
176 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 683 671 3 2 32 1 1 1 1','0 0 0 5191447 5191459 5191477 5191477 5191479 5191479 5191479 519 1479','0 0 0 20361 30776 381171 389104 5158962 5158962 5158962 5191479',X'0C0808 0803030308040808037370D10F00290188450132B537354C5E');
177 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 213354 21 3354 113 113 1 1 1 1','0 0 0 6102233 6102233 6155183 6155183 6155295 6155295 615 5295 6155295','0 0 0 26812 39489 472780 483115 6119281 6119281 6119281 6155295', X'0C080808040403080408080300F2FA4400FF5594019B6D01324067714AE8');
178 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 3675 3675 241 241 1 1 1 1','0 0 0 6486701 6486701 6489287 6489287 6489349 6489349 6489349 6489349','0 0 0 28380 41383 502486 513750 6452691 6452691 6452691 6489349',X'0C 080808040304080408080300F6ABAC6C967D009F84B60132DBDD155A2A');
179 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 24063 240 63 38 38 1 1 1 1','0 0 0 7080911 7080911 7102380 7102380 7102417 7102417 7102417 7102417','0 0 0 35724 49844 582928 595393 7065320 7065320 7065320 7102417',X'0C 0808080404040804080803010B0A5C00FF559400CCD3EE0133294559DDCD');
180 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 7173953 7173950 20284 202 84 38 38 1 1 1 1','0 0 0 7107237 7107237 7126606 7126606 7126643 7126643 7126643 7126643','0 0 0 35764 49885 586473 599030 7089546 7089546 7089546 7126643',X'0C 0808080404040804080803010B3C6700FF55940114CE73013329432225CC');
181 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 630326 618063 11855 11855 3 1 1 1 1 1','0 7173953 7173953 7665258 7665258 7672559 7672561 7672561 7672561 7672561 7672561','0 1 2 64320 91213 1077048 1100563 7630436 7630436 7630436 767 2561',X'0C080908040403020408080400F2FA4400FF559405DD0A23280132DD75009F3468');
182 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 630326 618063 4 4 1 1 1 1 1 1','0 7173953 7173953 7787218 7787218 7787219 7787219 7787219 7787219 7787219 7787219','0 1 2 74034 102405 1189484 1215034 7745001 7745001 7745001 7787219',X '0C0809080403040804080803010DDABE0368B700FEBFF60133068F22D1E5');
183 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','7804279 630326 12263 1433 1433 1 1 1 1 1 1','0 7173953 7792016 7797877 7797877 7799309 7799309 7799309 7799309 77 99309 7799309','0 1 3 76213 104626 1201397 1227113 7757087 7757087 7757087 77993 09',X'0C08090104040408040808030700F2FA4400FF559401C3969E013329461E5052');
184 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 8657 8657 605 605 1 1 1 1','7804279 7804279 7804279 8360485 8360485 8364643 8364643 83652 47 8365247 8365247 8365247','1 2 4 77865 106290 1217527 1243460 8321843 8321843 8321843 8365247',X'0C09080803030308040808031AD369021FFC0DC36E01328E2F3D9128');
185 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 33421 334 21 57 26 1 1 1 1','7804279 7804279 7804279 8873934 8873934 8891008 8891039 88910 64 8891064 8891064 8891064','1 2 4 78914 107340 1231432 1257622 8846644 8846644 8846644 8891064',X'0C090808030403020408080433776300FF55940CE166232801332A1800836 DFB');
186 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 2182 2182 94 94 1 1 1 1','7804279 7804279 7804279 9083187 9083187 9085006 9085006 9085089 9085089 9085089 9085089','1 2 4 79307 107733 1237174 1263453 9040316 9040316 90 40316 9085089',X'0C09080803030308040808033AC92C021FFC04AF670132B5FC38DBD0');
187 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 6023 6023 50 50 1 1 1 1','7804279 7804279 7804279 9393480 9393480 9395815 9395815 9395864 9395864 9395864 9395864','1 2 4 79973 108402 1245294 1271679 9350536 9350536 93 50536 9395864',X'0C09080803030308040808034CDD9A7E1C2301C30D0132908703CC11');
188 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 79 79 6 6 1 1 1 1','7804279 7804279 7804279 10382946 10382946 10382956 10382956 10382959 10382959 10382959 10382959','1 2 4 82501 110947 1276304 1303221 10336296 1033629 6 10336296 10382959',X'0C090808040303080408080400E9A10A0CC31602A47201332C6C00ABC D60');
189 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 8251 8251 280 280 1 1 1 1','7804279 7804279 7804279 11067468 11067468 11072690 11072690 1 1072969 11072969 11072969 11072969','1 2 4 85529 113989 1307763 1335183 11025935 11025935 11025935 11072969',X'0C090808040404080408080300FFA4A7008A66AD0089DBDD0 132B5FF6AE2B8');
190 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 44772 447 72 58 58 1 1 1 1','7804279 7804279 7804279 11268036 11268036 11269261 11269261 1 1269318 11269318 11269318 11269318','1 2 4 87132 115597 1321101 1348736 11222284 11222284 11222284 11269318',X'0C0908080404030804080804010B0A5C00FF5594018ACD013 3294300B0E291');
191 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 53775 537 75 37 19 1 1 1 1','7804279 7804279 7804279 11330929 11330929 11355027 11355045 1 1355063 11355063 11355063 11355063','1 2 4 87335 115800 1327560 1355328 11308029 11308029 11308029 11355063',X'0C0908080404030204080803010BFA8100FF5594026C24232 801332B2E1F8BB5');
192 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 3718791 3718791 39430 394 30 39 39 1 1 1 1','7804279 7804279 7804279 11458789 11458789 11476757 11476757 1 1476795 11476795 11476795 11476795','1 2 4 88502 116970 1340484 1368500 11429761 11429761 11429761 11476795',X'0C09080804040308040808030113B99600FF559402F6AF013 32B2E1F8A54');
193 INSERT INTO sqlite_stat4 VALUES('tx1','ix5','3876548 157757 157736 5317 5317 1 1 1 1 1 1','7804279 11523070 11523070 11652823 11652823 11658139 11658139 11658 139 11658139 11658139 11658139','1 3 5 100045 128561 1480184 1510648 11611105 11 611105 11611105 11658139',X'0C0909080404040204080803010BFA8100FF559402594CCB2328 013351E85B0F5D');
194 } {}
195 do_execsql_test whereJ-1.3 {
196 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 4748 4629 308 1 1 1 1 1','0 0 0 634880 634880 639119 639426 639426 639426 639426 639426', '0 0 0 779 907 26900 633919 633920 633920 633920 639426',X'0C0808080308040403080 803018C4A00F450A80132671F029EAC271DA5');
197 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 4608 4608 246 1 1 1 1 1','0 0 0 752580 752580 755578 755823 755823 755823 755823 755823', '0 0 0 936 1089 31876 749384 749385 749385 749385 755823',X'0C080808030803040308 0804018D4F347FD20131547D018A7500936FE2');
198 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 4776 4776 240 1 1 1 1 1','0 0 0 762070 762070 764545 764784 764784 764784 764784 764784', '0 0 0 940 1097 32187 758274 758275 758275 758275 764784',X'0C080808030803040308 0804018D562E0EAB0131A68F029E9300994D36');
199 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5910 5910 257 1 1 1 1 1','0 0 0 771353 771353 772646 772902 772902 772902 772902 772902', '0 0 0 946 1103 32460 766333 766334 766334 766334 772902',X'0C080808030803040408 0803018D611726F40130E13C00822B980302A0');
200 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 1834 1834 46 1 1 1 1 1','0 0 0 1296866 1296866 1297832 1297869 1297869 1297869 1297869 12 97869','0 0 0 2621 2842 56932 1287063 1287064 1287064 1287064 1297869',X'0C08080 8030803040308080301A6E33010BC01317F2005516E3932DB');
201 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5007 3959 317 1 1 1 1 1','0 0 0 2152400 2152400 2153781 2154097 2154097 2154097 2154097 2 154097','0 0 0 5683 6304 111431 2139450 2139457 2139457 2139457 2154097',X'0C080 808030803040308080301C3F91E114001315549029F74635F36');
202 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 4768 4609 397 1 1 1 1 1','0 0 0 2200466 2200466 2200700 2201096 2201096 2201096 2201096 2 201096','0 0 0 5714 6370 114266 2186220 2186227 2186227 2186227 2201096',X'0C080 808030803040308080401C42217887E01312D72036D5B009AF3F8');
203 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5177 4669 264 1 1 1 1 1','0 0 0 2234078 2234078 2235865 2236128 2236128 2236128 2236128 2 236128','0 0 0 5743 6422 116499 2221108 2221115 2221115 2221115 2236128',X'0C080 808030803040308080401C4491EF49D013155450D4B200091BFB3');
204 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 7981 5546 272 1 1 1 1 1','0 0 0 2239923 2239923 2242583 2242854 2242854 2242854 2242854 2 242854','0 0 0 5746 6428 116800 2227775 2227782 2227782 2227782 2242854',X'0C080 808030803040308080301C44E2EFF35013109E67764687E36D6');
205 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 351 336 1 5 1 1 1 1 1','0 0 0 2595725 2595725 2595725 2595739 2595739 2595739 2595739 2595 739','0 0 0 6747 7717 144364 2578697 2578708 2578708 2578708 2595739',X'0C080808 030803040308080401CCC91782C20131CC1902D7C0008E7A4F');
206 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 6022 4942 304 1 1 1 1 1','0 0 0 2648510 2648510 2648849 2649152 2649152 2649152 2649152 2 649152','0 0 0 6934 7959 149030 2631886 2631900 2631900 2631900 2649152',X'0C080 808030803040308080301CE8C17887E01312D6E036D5B424939');
207 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 4752 1965 5 1 1 1 1 1','0 0 0 3161780 3161780 3163740 3163744 3163744 3163744 3163744 316 3744','0 0 0 9707 11219 194477 3143873 3143896 3143896 3143896 3163744',X'0C0808 0803080404030808030213B20116290C01332B9D0270102494C2');
208 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5497 1880 3 1 1 1 1 1','0 0 0 3167643 3167643 3169520 3169522 3169522 3169522 3169522 316 9522','0 0 0 9709 11226 194760 3149632 3149655 3149655 3149655 3169522',X'0C0808 0803080404040808030213B5010B0A5C0133294500FF55941DCA72');
209 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 2185 2126 134 1 1 1 1 1','0 0 0 3891669 3891669 3893607 3893609 3893609 3893609 3893609 3 893609','0 0 0 13596 15952 257364 3869701 3869733 3869733 3869733 3893609',X'0C0 80808030804040308080302BD5F01010F13013350517B8BF356D913');
210 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5511 5355 345 1 1 1 1 1','0 0 0 3931849 3931849 3931954 3932298 3932298 3932298 3932298 3 932298','0 0 0 13793 16188 260160 3908172 3908206 3908206 3908206 3932298',X'0C0 80808030803040308080402C14C17887E01312D75036D5B009AF4B1');
211 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5468 5115 310 1 1 1 1 1','0 0 0 3939090 3939090 3939894 3940203 3940203 3940203 3940203 3 940203','0 0 0 13803 16200 260571 3916034 3916068 3916068 3916068 3940203',X'0C0 80808030803040308080302C164191E7F0131A4FC0606F30CE25A');
212 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 5275 4792 252 1 1 1 1 1','0 0 0 4590216 4590216 4591340 4591591 4591591 4591591 4591591 4 591591','0 0 0 17456 20455 315887 4563939 4563981 4563981 4563981 4591591',X'0C0 808080308030403080804049EE51EB67B01317C5204C9D900AE08CD');
213 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 339 339 2 0 1 1 1 1 1','0 0 0 5191257 5191257 5191475 5191479 5191479 5191479 5191479 5191 479','0 0 0 20754 24230 366257 5160652 5160701 5160701 5160701 5191479',X'0C0808 0803080404030808030CEE9300E50D8D013242BE018A755F6BC3');
214 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 7173953 7173950 13 13 1 1 1 1 1 1','0 0 0 6489337 6489337 6489349 6489349 6489349 6489349 6489349 6489349 ','0 0 0 29449 33987 481632 6453309 6453378 6453378 6453378 6489349',X'0C0808080 4080304030808030091B3AB600E9801323F54029F7403EF0C');
215 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 630326 618063 10 9 1 1 1 1 1 1','0 7173953 7173953 7787217 7787217 7787219 7787219 7787219 7787219 778721 9 7787219','0 1 2 74978 85458 1107555 7744920 7744997 7744997 7744997 7787219',X '0C0809080408030403080804014F459B48960801332ADC01C7A600AA1BA3');
216 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','7804279 630326 12263 17 1 1 1 1 1 1 1','0 7173953 7792016 7795570 7795586 7795586 7795586 7795586 7795586 7795586 7795586','0 1 3 78329 89057 1115864 7753287 7753364 7753364 7753364 7795586',X' 0C0809010302040404080804070267C1271300E640740133041E00AB540900A3EE16');
217 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','3876548 3718791 3718791 397 397 4 6 1 1 1 1 1','7804279 7804279 7804279 9084892 9084892 9085088 9085089 9085089 90 85089 9085089 9085089','1 2 4 87584 99143 1159195 9040539 9040616 9040616 904061 6 9085089',X'0C090808030804040308080301CBAF00E5C288013351810C390F26671E');
218 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','3876548 3718791 3718791 141 141 2 0 1 1 1 1 1','7804279 7804279 7804279 10382921 10382921 10382951 10382959 103829 59 10382959 10382959 10382959','1 2 4 95054 107437 1210217 10336699 10336776 103 36776 10336776 10382959',X'0C09080803080304030808030DB5C14114E301332A7E018A751F1 7C1');
219 INSERT INTO sqlite_stat4 VALUES('tx1','ix4','3876548 157757 157736 83 16 1 1 1 1 1 1','7804279 11523070 11523070 11587733 11587800 11587815 11587815 11587815 11587815 11587815 11587815','1 3 5 112412 126326 1332792 11540704 11540781 11540 781 11540781 11587815',X'0C090908030204040308080402A9D12328010B92880133517F029E9 D008B5B23');
220 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 213279 213279 213 279 213279 376 212 101 1 1','0 0 12394 12394 12394 12394 18421 18421 18421 18424 18424','0 0 3 3 3 3 810 1027 1949 18324 18424',X'0C0808030808080308030403018A75 018788178574013265FC611E2A');
221 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 86515 86515 86515 86515 377 377 377 1 1','0 0 271240 271240 271240 271240 274521 274521 274521 27 4780 274780','0 0 8 8 8 8 9766 10762 19602 273178 274780',X'0C080803080808030803 040401A79C01886F174AEF0132678B00A4AEFF');
222 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 193482 193482 193 482 193482 444 444 444 1 1','0 0 542802 542802 542802 542802 575453 575453 57545 3 575505 575505','0 0 27 27 27 27 24310 25597 43165 571774 575505',X'0C080803080 808030803040401C3EB018CCE55312F013305B700AF487C');
223 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 126108 126108 126 108 126108 200 200 28 1 1','0 0 747801 747801 747801 747801 762121 762121 762293 762320 762320','0 0 33 33 33 33 30770 32410 56629 757315 762320',X'0C0808030808 08030803040301C7A6018A9D6AB1100131F17D04364A');
224 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 149712 149712 149 712 149712 216 216 5 1 1','0 0 1107747 1107747 1107747 1107747 1147090 1147090 1 147301 1147305 1147305','0 0 98 98 98 98 51603 53785 94043 1139967 1147305',X'0C 080803080808030803040302172301B84D2E828501317B95651924');
225 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 87289 87289 87289 87289 27 27 12 1 1','0 0 1257751 1257751 1257751 1257751 1297850 1297850 129786 5 1297869 1297869','0 0 100 100 100 100 57625 60123 107069 1289807 1297869',X'0C 0808030808080308040403021FFC02554D00E643C7013242692A9BBC');
226 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 192597 192597 192 597 192597 291 291 3 1 1','0 0 1464077 1464077 1464077 1464077 1512946 1512946 1 513234 1513236 1513236','0 0 134 134 134 134 67476 70262 123260 1502886 1513236' ,X'0C0808030808080308040404029E6201B94000F8341701330419008B74DA');
227 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 196917 196917 196 917 196917 326 326 12 1 1','0 0 1677739 1677739 1677739 1677739 1797333 1797333 1797647 1797658 1797658','0 0 136 136 136 136 76717 80026 143308 1785522 1797658 ',X'0C0808030808080308040404029E6802B7DC0108ACBA0132DD7B0087795F');
228 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 140297 140297 140 297 140297 206 188 90 1 1','0 0 1951850 1951850 1951850 1951850 2020506 2020524 2020622 2020711 2020711','0 0 146 146 146 146 85439 89181 160816 2006993 2020711 ',X'0C0808030808080302040403029E8102171603E800FA82B20132B5AD384ECD');
229 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 132041 132041 132 041 132041 173 173 20 1 1','0 0 2415706 2415706 2415706 2415706 2428962 2428962 2429115 2429134 2429134','0 0 163 163 163 163 100984 105182 186071 2412732 24291 34',X'0C0808030808080308030403029EB1018BF55020D60131A3D23BB156');
230 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 6830 6830 6830 68 30 35 35 35 1 1','0 0 2595444 2595444 2595444 2595444 2595711 2595711 2595711 25 95739 2595739','0 0 169 169 169 169 108584 113037 199947 2578183 2595739',X'0C08 08030808080308030403029EC001878C17A7520131A43A6E513C');
231 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 101615 101615 101 615 101615 244 33 33 1 1','0 0 2999185 2999185 2999185 2999185 3019255 3019466 3 019466 3019498 3019498','0 0 213 213 213 213 131035 136293 237357 2999333 301949 8',X'0C080803080808030203040302D7C001B93E03F041A96D013303017C72B6');
232 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 26914 26914 26914 26914 87 87 73 1 1','0 0 3868553 3868553 3868553 3868553 3893568 3893568 389358 2 3893609 3893609','0 0 387 387 387 387 172456 180121 311050 3869040 3893609',X' 0C08080308080803080304040498C86B7EF347CC5A0132B678008A4646');
233 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 97492 97492 97492 97492 410 410 44 1 1','0 0 4948831 4948831 4948831 4948831 5009456 5009456 5009 822 5009865 5009865','0 0 751 751 751 751 226745 236274 399260 4980988 5009865', X'0C08080308080803080404030E565F03686C00F89CD001332A115479DC');
234 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 1782 1782 1782 17 82 52 52 52 1 1','0 0 5190938 5190938 5190938 5190938 5191434 5191434 5191434 51 91479 5191479','0 0 800 800 800 800 236362 246237 414618 5161779 5191479',X'0C08 080308080803080304040EBD0F0268E064A6DB013242CB00875BAF');
235 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 4645 4645 4645 46 45 17 17 17 1 1','0 0 6485214 6485214 6485214 6485214 6489339 6489339 6489339 64 89349 6489349','0 0 1396 1396 1396 1396 317293 329836 538486 6453712 6489349',X' 0C080804080808040803040300ABD9B000A69D33737CBB01328F6B0F6298');
236 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 7173953 290196 290196 290 196 290196 138 138 26 1 1','0 0 6734628 6734628 6734628 6734628 6744872 6744872 6744984 6745009 6745009','0 0 1641 1641 1641 1641 338986 352099 569319 6708651 6 745009',X'0C080804080808030804040400FF5594018819010B3C670133294300B1674C');
237 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','7804279 630326 24310 1435 1435 14 35 1 1 1 1 1','0 7173953 7763625 7786500 7786500 7786500 7787219 7787219 7787219 7787219 7787219','0 1 3518 4119 4119 4119 726018 753845 1215054 7745002 7787219 ',X'0C080904010808030204040400FF5594070357AB232800F2FA440133294600A90441');
238 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','3876548 3718791 114188 114188 114 188 114188 463 61 61 1 1','7804279 7804279 7809377 7809377 7809377 7809377 78647 55 7865157 7865157 7865217 7865217','1 2 3751 4413 4413 4413 740133 768607 12339 27 7822883 7865217',X'0C0908030808080302030403018A750213B2245416DF860131CB3A2879 CC');
239 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','3876548 3718791 86108 86108 86108 86108 605 605 605 1 1','7804279 7804279 8403815 8403815 8403815 8403815 8463845 8463845 8463845 8464449 8464449','1 2 3805 4467 4467 4467 760796 789718 1255047 8421249 8464449',X'0C0908030808080308030403021FFC0DC36E1AD36901328E2F3D9128');
240 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','3876548 3718791 60490 60490 60490 60490 44 44 44 1 1','7804279 7804279 9062901 9062901 9062901 9062901 9085056 90 85056 9085056 9085089 9085089','1 2 3845 4507 4507 4507 778931 808217 1273550 90 40805 9085089',X'0C0908030808080308040403029EB101C30B00E889140132697F092505');
241 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','3876548 3718791 57304 57304 57304 57304 2 2 2 1 1','7804279 7804279 10328144 10328144 10328144 10328144 10382958 10382958 10382958 10382959 10382959','1 2 4106 4768 4768 4768 823966 853934 1319 290 10336860 10382959',X'0C09080308080804080404040E565F00CE8C3100E7F68D013351790 0B0B4CE');
242 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','3876548 3718791 174377 174377 174 377 174377 81 81 66 1 1','7804279 7804279 11246252 11246252 11246252 11246252 11 358749 11358749 11358764 11358829 11358829','1 2 4517 5179 5179 5179 867595 8982 52 1363807 11311829 11358829',X'0C090804080808030804040300FF55940E584300F2FA4401 3240670E2E89');
243 INSERT INTO sqlite_stat4 VALUES('tx1','ix3','3876548 157757 15066 15066 15066 15066 1 1 1 1 1','7804279 11523070 11657249 11657249 11657249 11657249 11672314 11672314 11672314 11672314 11672314','1 3 5503 6167 6167 6167 1025351 1059076 15 24822 11625280 11672314',X'0C090904080808040203040300FF5594025D19032328337763013 351F2277A3E');
244 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 4748 4629 4629 46 29 4629 17 1 1 1','0 0 634880 634880 634880 634880 634880 639175 639191 639191 6 39191','0 0 779 907 907 907 907 415429 633684 633685 639191',X'0C080803080808080 4030303018C4A013157983CE7FE05E54B6BB7FB');
245 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 4608 4608 4608 46 08 4608 33 1 1 1','0 0 752580 752580 752580 752580 752580 755506 755538 755538 7 55538','0 0 936 1089 1089 1089 1089 491324 749126 749127 755538',X'0C08080308080 80804030303018D4F0131A682512ECF029E6A70A9E9');
246 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 4776 4776 4776 47 76 4776 27 1 1 1','0 0 762070 762070 762070 762070 762070 763357 763383 763383 7 63383','0 0 940 1097 1097 1097 1097 495628 756890 756891 763383',X'0C08080308080 80804040303018D560132DB8800F3416D029EA654D9AC');
247 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5910 5910 5910 59 10 5910 37 2 2 1','0 0 771353 771353 771353 771353 771353 775562 775597 775597 7 75598','0 0 946 1103 1103 1103 1103 501111 769013 769014 775598',X'0C08080308080 80804030303018D610131CADE4C6E2D01D5860141A9');
248 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 1834 1834 1834 18 34 1834 6 1 1 1','0 0 1296866 1296866 1296866 1296866 1296866 1297867 1297869 12 97869 1297869','0 0 2621 2842 2842 2842 2842 857867 1287063 1287064 1297869',X'0 C080803080808080403030301A6E30132419A1E1B7F0567EE2880C0');
249 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5007 3959 3959 39 59 3959 25 1 1 1','0 0 2152400 2152400 2152400 2152400 2152400 2155551 2155575 2 155575 2155575','0 0 5683 6304 6304 6304 6304 1442790 2140930 2140937 2155575',X '0C080803080808080404030301C3F901317CC701044CC7029E6834F7E2');
250 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 4768 4609 4609 46 09 4609 26 1 1 1','0 0 2200466 2200466 2200466 2200466 2200466 2204364 2204389 2 204389 2204389','0 0 5714 6370 6370 6370 6370 1470393 2189496 2189503 2204389',X '0C080803080808080403030301C4220131586B3EB735018A7567CE9E');
251 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5177 4669 4669 46 69 4669 22 1 1 1','0 0 2234078 2234078 2234078 2234078 2234078 2238366 2238387 2 238387 2238387','0 0 5743 6422 6422 6422 6422 1490145 2223355 2223362 2238387',X '0C080803080808080403030301C4490131573F4104F802D9CA67FD1E');
252 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 7981 5546 5546 55 46 5546 32 1 1 1','0 0 2239923 2239923 2239923 2239923 2239923 2243388 2243419 2 243419 2243419','0 0 5746 6428 6428 6428 6428 1492784 2228358 2228365 2243419',X '0C080803080808080404030301C44E0131A4FE00FDCC04029E8175076B');
253 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 351 336 336 336 3 36 1 1 1 1','0 0 2595725 2595725 2595725 2595725 2595725 2595739 2595739 2595739 2595739','0 0 6747 7717 7717 7717 7717 1732397 2578697 2578708 2595739',X'0C080 803080808080404030301CCC901332A7700F17E5D0E5D6F523B01');
254 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 6022 4942 4942 49 42 4942 38 1 1 1','0 0 2648510 2648510 2648510 2648510 2648510 2652126 2652163 2 652163 2652163','0 0 6934 7959 7959 7959 7959 1770411 2634884 2634898 2652163',X '0C080803080808080404030301CE8C01317DE800FE4E8B029E81458317');
255 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 4752 1965 1965 19 65 1965 1 1 1 1','0 0 3161780 3161780 3161780 3161780 3161780 3163744 3163744 31 63744 3163744','0 0 9707 11219 11219 11219 11219 2143797 3143873 3143896 3163744 ',X'0C08080308080808040303030213B20130BC9216F939029E815B86EE');
256 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5497 1880 1880 18 80 1880 1 1 1 1','0 0 3167643 3167643 3167643 3167643 3167643 3169522 3169522 31 69522 3169522','0 0 9709 11226 11226 11226 11226 2148088 3149632 3149655 3169522 ',X'0C08080308080808040303030213B50130BBC616FC6501C7A62A1BB2');
257 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 2185 2126 2126 21 26 2126 4 1 1 1','0 0 3891670 3891670 3891670 3891670 3891670 3893609 3893609 38 93609 3893609','0 0 13596 15952 15953 15953 15953 2677069 3869700 3869732 389360 9',X'0C080803080808080403030302BD5F01317CC81782F704C9D95EFF0C');
258 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5511 5355 5355 53 55 5355 21 1 1 1','0 0 3931850 3931850 3931850 3931850 3931850 3936206 3936226 3 936226 3936226','0 0 13793 16188 16189 16189 16189 2705655 3912091 3912125 39362 26',X'0C080803080808080403030302C14C01317C514010FA01B64235E688');
259 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5468 5115 5115 51 15 5115 27 1 1 1','0 0 3939091 3939091 3939091 3939091 3939091 3943255 3943281 3 943281 3943281','0 0 13803 16200 16201 16201 16201 2709082 3919099 3919133 39432 81',X'0C080803080808080403030302C16401317CC348B67001C3EB6824BB');
260 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 5275 4792 4792 47 92 4792 31 1 1 1','0 0 4590217 4590217 4590217 4590217 4590217 4591639 4591669 4 591669 4591669','0 0 17456 20455 20456 20456 20456 3175906 4564022 4564064 45916 69',X'0C0808030808080804040403049EE50132915200FA2F9300EA0DC50554E0');
261 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 339 339 339 339 3 39 2 1 1 1','0 0 5191258 5191258 5191258 5191258 5191258 5191478 5191479 5191479 5191479','0 0 20754 24230 24231 24231 24231 3601696 5160652 5160701 5191479',X' 0C08080308080808040303030CEE930132671A1B8AFF01B6426386D0');
262 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 7173953 13 13 13 13 13 1 1 1 1','0 0 6489339 6489339 6489339 6489339 6489339 6489349 6489349 6489349 6489 349','0 0 29449 33987 33989 33989 33989 4540005 6453309 6453378 6489349',X'0C080 80408080808040303030091B3AB01321B5A4F26F2018A750B6686');
263 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','7804279 630326 19 19 18 18 18 1 1 1 1','0 7173953 7787203 7787203 7787203 7787203 7787203 7787219 7787219 7787219 7787219','0 1 73522 83967 91688 91688 91688 5643606 7744920 7744997 7787219',X' 0C080904080808080404030300FF69210132DB2900FB0715029EB573EB9F');
264 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','3876548 3718791 4598 4512 4512 45 12 4512 38 1 1 1','7804279 7804279 8237877 8237877 8237877 8237877 8237877 82389 86 8239023 8239023 8239023','1 2 76726 87349 95641 95641 95641 5923145 8195880 8 195957 8239023',X'0C0908030808080804040404018D3F01332A780111068001FB6F840083BEF9 ');
265 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','3876548 3718791 397 397 397 397 3 97 2 1 1 1','7804279 7804279 9084892 9084892 9084892 9084892 9084892 9085089 908 5089 9085089 9085089','1 2 79826 90851 99143 99143 99143 6505397 9040540 9040617 9085089',X'0C090803080808080403030301CBAF0133028A4E35BE715A2A49098C');
266 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','3876548 3718791 141 141 141 141 1 41 2 1 1 1','7804279 7804279 10382921 10382921 10382921 10382921 10382921 103829 58 10382959 10382959 10382959','1 2 87296 99145 107437 107437 107437 7432077 103 36699 10336776 10382959',X'0C09080308080808040403030DB5C101332BF7010E37310EB9742 0BFF6');
267 INSERT INTO sqlite_stat4 VALUES('tx1','ix2','3876548 157757 83 16 16 16 16 1 1 1 1','7804279 11523070 11587750 11587817 11587817 11587817 11587817 11587832 11 587832 11587832 11587832','1 3 104655 118035 126343 126343 126343 8311754 115407 21 11540798 11587832',X'0C090903020808080404030402A9D1232801332CC300EB7D35029E83 008581B1');
268 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 24157 24157 24157 24157 24157 133 1 1 1','0 0 1236590 1236590 1236590 1236590 1236590 1241150 124 1282 1241282 1241282','0 0 3120 3120 3120 3120 4771 741878 1223262 1228239 12412 82',X'0C08080308080804040408031A080400FF559401321BC20099C49F3BE84C');
269 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 1209 1209 1209 12 09 1209 2 1 1 1','0 0 1296873 1296873 1296873 1296873 1296873 1297868 1297869 12 97869 1297869','0 0 3203 3203 3203 3203 4902 763298 1279554 1284645 1297869',X'0 C08080308080803040308031A215F04C9D901317D1501B0A355A290');
270 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 12129 12129 12129 12129 9261 38 1 1 1','0 0 1790076 1790076 1790076 1790076 1790076 1791737 17917 74 1791774 1791774','0 0 4938 4938 4938 4938 7561 1075153 1767990 1775629 179177 4',X'0C08080308080803040408031CE87E029E6B01328F6100B473FD5BE552');
271 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 273 273 273 273 2 73 1 1 1 1','0 0 2595625 2595625 2595625 2595625 2595625 2595739 2595739 2595739 2595739','0 0 7863 7863 7863 7863 12132 1580849 2562484 2575172 2595739',X'0C08 080308080803040308032F020502DA0E013241A16B73DE01E021');
272 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 7735 7735 7735 77 35 7735 503 1 1 1','0 0 2924165 2924165 2924165 2924165 2924165 2931394 2931896 2931896 2931896','0 0 9123 9123 9123 9123 14045 1794002 2895440 2909856 2931896' ,X'0C080803080808040404080433776300FF55940133294301C56631008BCB5A');
273 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 360 360 360 360 2 29 1 1 1 1','0 0 3893374 3893374 3893374 3893374 3893505 3893609 3893609 3893609 3893609','0 0 13912 13912 13912 13912 21124 2420346 3846830 3866425 3893609',X' 0C08080308080803040308034717710E070B01317F7102C73A396CE1');
274 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 683 683 683 683 6 71 2 1 1 1','0 0 5191447 5191447 5191447 5191447 5191459 5191479 5191479 5191479 5191479','0 0 20361 20361 20361 20361 30776 3226670 5127525 5158962 5191479',X' 0C08080308080803040308037370D10F00290132B59A018F7A694C9B');
275 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 213354 213354 213 354 213354 213354 5934 1 1 1','0 0 6102233 6102233 6102233 6102233 6102233 61542 76 6155650 6155650 6155650','0 0 26812 26812 26812 26812 39489 3770219 6079715 6 119855 6155650',X'0C080804080808040403080300F2FA4400FF55940132DF1A01C0C115D4D4') ;
276 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 3675 3675 3675 36 75 3675 14 1 1 1','0 0 6486701 6486701 6486701 6486701 6486701 6489347 6489349 6 489349 6489349','0 0 28380 28380 28380 28380 41383 3868787 6409451 6452691 64893 49',X'0C080804080808030403020300F6ABAC6C967D0132B672026C8D03E8155844');
277 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 24063 24063 24063 24063 24063 1799 1 1 1','0 0 7080914 7080914 7080914 7080914 7080914 7103178 71 04976 7104976 7104976','0 0 35724 35725 35725 35725 49845 4189282 7019641 706787 9 7104976',X'0C0808040808080404040804010B0A5C00FF55940133294301D2C35700A877B5');
278 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 7173953 20284 20284 20284 20284 20284 1518 1 1 1','0 0 7107240 7107240 7107240 7107240 7107240 7124584 71 26101 7126101 7126101','0 0 35764 35765 35765 35765 49886 4191089 7040717 708900 4 7126101',X'0C0808040808080404040803010B3C6700FF55940133294501F0A829511573');
279 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 630326 13288 11855 11855 11855 11855 5449 1 1 1','0 7173953 7671119 7671119 7671119 7671119 7671119 76765 14 7676526 7676526 7676526','0 1 64320 65543 65543 65543 92453 4431581 7580039 7 634401 7676526',X'0C080904080808040403080400F2FA4400FF5594013329430186CB00A866E4 ');
280 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','7804279 630326 61 61 61 61 61 14 1 1 1','0 7173953 7787172 7787172 7787172 7787172 7787172 7787217 7787219 778721 9 7787219','0 1 73272 75274 75274 75274 103642 4468650 7689369 7745002 7787219', X'0C0809040808080304030803010ABA910DD2420133068F05DE6223042F');
281 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 8657 8657 8657 86 57 8657 18 1 1 1','7804279 7804279 8360485 8360485 8360485 8360485 8360485 83609 77 8360994 8360994 8360994','1 2 75785 77865 77865 77865 106290 4756698 8258979 8317590 8360994',X'0C09080308080803040408031AD369021FFC0133517F01B017F259F6C3');
282 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 33421 33421 33421 33421 33421 2221 1 1 1','7804279 7804279 8873934 8873934 8873934 8873934 887393 4 8874868 8877088 8877088 8877088','1 2 76834 78914 78914 78914 107340 5041847 8 770182 8832668 8877088',X'0C090803080808040404020333776300FF5594013351790241FEE4 232825FB3D');
283 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 2182 2182 2182 21 82 2182 20 1 1 1','7804279 7804279 9083187 9083187 9083187 9083187 9083187 90850 87 9085089 9085089 9085089','1 2 77227 79307 79307 79307 107733 5141706 8974619 9040316 9085089',X'0C09080308080803040308043AC92C021FFC0132B668018BAB00964778');
284 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 6008 6008 6008 60 08 6008 26 1 1 1','7804279 7804279 9124662 9124662 9124662 9124662 9124662 91282 86 9128311 9128311 9128311','1 2 77300 79380 79380 79380 107806 5160088 9016921 9083451 9128311',X'0C09080308080804040408033C1C5C00F024880132DB2100B88E8A420C1B' );
285 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 6023 6023 6023 60 23 6023 91 1 1 1','7804279 7804279 9393480 9393480 9393480 9393480 9393480 93965 19 9396609 9396609 9396609','1 2 77893 79973 79973 79973 108402 5311949 9282988 9351281 9396609',X'0C09080308080803040408044CDD9A7E1C230132DE4200D105C800A087F7' );
286 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 79 79 79 79 79 1 1 1 1','7804279 7804279 10382946 10382946 10382946 10382946 10382946 10382959 10 382959 10382959 10382959','1 2 80421 82501 82501 82501 110947 5821380 10258569 1 0336296 10382959',X'0C090804080808030403080300E9A10A0CC3160133505F0D25365733C6') ;
287 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 8251 8251 8251 82 51 8251 37 1 1 1','7804279 7804279 11067468 11067468 11067468 11067468 11067468 11068084 11068120 11068120 11068120','1 2 83449 85529 85529 85529 113989 6177561 10936213 11021086 11068120',X'0C090804080808040404080400FFA4A7008A66AD01332AD10 170A8B10084054A');
288 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 44772 44772 44772 44772 44772 3018 1 1 1','7804279 7804279 11268036 11268036 11268036 11268036 11 268036 11282829 11285846 11285846 11285846','1 2 85052 87132 87132 87132 115597 6281979 11151347 11238812 11285846',X'0C0908040808080404040804010B0A5C00FF559401 3351720249087400B0523C');
289 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 53775 53775 53775 53775 53775 4069 1 1 1','7804279 7804279 11330929 11330929 11330929 11330929 11 330929 11359035 11363103 11363103 11363103','1 2 85255 87335 87335 87335 115800 6292285 11227544 11316069 11363103',X'0C0908040808080404040804010BFA8100FF559401 3351280252F8A000B01818');
290 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 3718791 39430 39430 39430 39430 39430 3018 1 1 1','7804279 7804279 11458789 11458789 11458789 11458789 11 458789 11468188 11471205 11471205 11471205','1 2 86422 88502 88502 88502 116970 6333877 11333316 11424171 11471205',X'0C09080408080804040408040113B99600FF559401 335174024530C4008AC82C');
291 INSERT INTO sqlite_stat4 VALUES('tx1','ix1','3876548 157757 5317 5317 5317 531 7 5317 12 1 1 1','7804279 11523070 11652844 11652844 11652844 11652844 11652844 11658149 11658160 11658160 11658160','1 3 97969 100051 100051 100051 128567 6429 914 11517744 11611126 11658160',X'0C0909040808080404040804010BFA8100FF559401332B 2E01521E0B008447F4');
292 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 24157 29 29 29 29 29 1 1 1','0 0 1236590 1251799 1251799 1251799 1251799 1251799 1251827 1251827 1251827','0 0 3120 62451 63798 63798 63798 63798 1238772 1238782 1251827',X'0C08 080303080808080404031A0804029BB30131CD3700FF55942B1368');
293 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 1209 129 129 129 129 129 1 1 1','0 0 1296873 1297744 1297744 1297744 1297744 1297744 1297869 1297 869 1297869','0 0 3203 65280 66657 66657 66657 66657 1284635 1284645 1297869',X' 0C08080303080808080403041A215F01B0A30131066F04C9D90087162A');
294 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 12129 604 604 604 604 604 1 1 1','0 0 1790076 1790076 1790076 1790076 1790076 1790076 1790679 179 0679 1790679','0 0 4938 95334 97612 97612 97612 97612 1774566 1774578 1790679',X '0C08080303080808080403031CE87E01870001317C4D0CED622FE2E8');
295 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 273 5 5 5 5 5 1 1 1','0 0 2595625 2595738 2595738 2595738 2595738 2595738 2595739 2595739 2595739 ','0 0 7863 145612 149427 149427 149427 149427 2575145 2575172 2595739',X'0C0808 0303080808080403042F020502C73A0133049702DA0E00A711F8');
296 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 7735 29 29 29 29 29 1 1 1','0 0 2924165 2929754 2929754 2929754 2929754 2929754 2929782 2929782 2 929782','0 0 9123 167852 172269 172269 172269 172269 2907715 2907742 2929782',X' 0C080803030808080804040333776375928D0133294300FF55945A824F');
297 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 360 6 6 6 6 6 1 1 1','0 0 3893374 3893607 3893607 3893607 3893607 3893607 3893609 3893609 3893609 ','0 0 13912 240908 247109 247109 247109 247109 3866384 3866425 3893609',X'0C080 803030808080804030347177104AF8701317D220E070B687905');
298 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 683 32 32 32 32 3 2 2 2 1','0 0 5191447 5191465 5191465 5191465 5191465 5191465 5191479 5191479 51 91479','0 0 20361 336764 345696 345696 345696 345696 5158907 5158962 5191479',X' 0C08080303080808080403037370D101884501328F690F002900A69C');
299 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 213354 113 113 11 3 113 113 1 1 1','0 0 6102233 6155183 6155183 6155183 6155183 6155183 6155295 61 55295 6155295','0 0 26812 421693 433202 433202 433202 433202 6119212 6119281 615 5295',X'0C080804030808080804040300F2FA44019B6D0132406700FF5594714AE8');
300 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 3675 241 241 241 241 241 1 1 1','0 0 6486701 6489287 6489287 6489287 6489287 6489287 6489349 6489 349 6489349','0 0 28380 450494 462953 462953 462953 462953 6452616 6452691 64893 49',X'0C080804040808080804030300F6ABAC009F84B60132DBDD6C967D155A2A');
301 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 24063 38 38 38 38 38 1 1 1','0 0 7080914 7102383 7102383 7102383 7102383 7102383 7102420 7102420 7102420','0 0 35724 528136 541855 541858 541858 541858 7065247 7065323 7102420', X'0C0808040408080808040403010B0A5C00CCD3EE0133294500FF559459DDCD');
302 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 7173953 20284 38 38 38 38 38 1 1 1','0 0 7107240 7126609 7126609 7126609 7126609 7126609 7126646 7126646 7126646','0 0 35764 531673 545484 545487 545487 545487 7089473 7089549 7126646', X'0C0808040408080808040403010B3C670114CE730133294300FF55942225CC');
303 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 630326 13288 5 1 1 1 1 1 1 1','0 7173953 7671119 7675167 7675171 7675171 7675171 7675171 7675171 7675171 7675171','0 1 64320 967583 993386 999414 999414 999414 7632969 7633046 7675171', X'0C080904030308080804040400F2FA4401D16F0183350132DEFE00FF5594009FA501');
304 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','7804279 630326 61 1 1 1 1 1 1 1 1 ','0 7173953 7787172 7787219 7787219 7787219 7787219 7787219 7787219 7787219 778 7219','0 1 73272 1068631 1096442 1107608 1107608 1107608 7744925 7745002 7787219 ',X'0C0809040408080808040304010ABA9100AA4C1F013351DB0DD242008BFFEF');
305 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 8657 605 605 605 605 605 1 1 1','7804279 7804279 8360485 8364643 8364643 8364643 8364643 8364643 8365247 8365247 8365247','1 2 75785 1096159 1124446 1135923 1135923 1135923 8321 766 8321843 8365247',X'0C09080303080808080403031AD3690DC36E01328E2F021FFC3D9128' );
306 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 33421 57 26 26 26 26 1 1 1','7804279 7804279 8873934 8891008 8891039 8891039 8891039 8891039 8891 064 8891064 8891064','1 2 76834 1110063 1138607 1150084 1150084 1150084 8846567 8846644 8891064',X'0C09080303020808080404043377630CE166232801332A1800FF559400836 DFB');
307 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 2182 94 94 94 94 94 1 1 1','7804279 7804279 9083187 9085006 9085006 9085006 9085006 9085006 90850 89 9085089 9085089','1 2 77227 1115805 1144438 1155915 1155915 1155915 9040239 9 040316 9085089',X'0C09080303080808080403033AC92C04AF670132B5FC021FFC38DBD0');
308 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 6008 277 277 277 277 277 1 1 1','7804279 7804279 9124662 9124662 9124662 9124662 9124662 9124662 9124938 9124938 9124938','1 2 77300 1116652 1145304 1156781 1156781 1156781 9080 000 9080077 9124938',X'0C09080303080808080404033C1C5C01B49901328DDA00F024883D605 2');
309 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 6023 50 50 50 50 50 1 1 1','7804279 7804279 9393480 9395815 9395815 9395815 9395815 9395815 93958 64 9395864 9395864','1 2 77893 1123924 1152663 1164140 1164140 1164140 9350459 9 350536 9395864',X'0C09080303080808080403034CDD9A01C30D013290877E1C2303CC11');
310 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 79 6 6 6 6 6 1 1 1','7804279 7804279 10382946 10382956 10382956 10382956 10382956 10382956 103829 59 10382959 10382959','1 2 80421 1154920 1184197 1195674 1195674 1195674 1033621 9 10336296 10382959',X'0C090804030808080804030400E9A10A02A47201332C6C0CC31600ABC D60');
311 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 8251 280 280 280 280 280 1 1 1','7804279 7804279 11067468 11072690 11072690 11072690 11072690 110 72690 11072969 11072969 11072969','1 2 83449 1186373 1216159 1227636 1227636 122 7636 11025858 11025935 11072969',X'0C090804040808080804040300FFA4A70089DBDD0132B 5FF008A66AD6AE2B8');
312 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 44772 58 58 58 58 58 1 1 1','7804279 7804279 11268036 11269261 11269261 11269261 11269261 1126926 1 11269318 11269318 11269318','1 2 85052 1199706 1229712 1241189 1241189 1241189 11222207 11222284 11269318',X'0C0908040308080808040404010B0A5C018ACD0133294300F F559400B0E291');
313 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 53775 37 19 19 19 19 1 1 1','7804279 7804279 11330929 11355027 11355045 11355045 11355045 1135504 5 11355063 11355063 11355063','1 2 85255 1206165 1236304 1247781 1247781 1247781 11307952 11308029 11355063',X'0C0908040302080808040403010BFA81026C24232801332B2 E00FF55941F8BB5');
314 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 3718791 39430 39 39 39 39 39 1 1 1','7804279 7804279 11458789 11476757 11476757 11476757 11476757 1147675 7 11476795 11476795 11476795','1 2 86422 1219089 1249476 1260953 1260953 1260953 11429684 11429761 11476795',X'0C09080403080808080404030113B99602F6AF01332B2E00F F55941F8A54');
315 INSERT INTO sqlite_stat4 VALUES('tx1','ix0','3876548 157757 5317 1 1 1 1 1 1 1 1','7804279 11523070 11652844 11658160 11658160 11658160 11658160 11658160 1165 8160 11658160 11658160','1 3 97969 1358780 1391643 1403122 1403122 1403122 11611 049 11611126 11658160',X'0C0909040402080808040403010BFA8102594CCB2328013351E800F F55945B0F5D');
316 ANALYZE sqlite_master;
317 } {}
318
319 # Ensure that the query planner implements the GROUP BY using a separate sort
320 #
321 do_execsql_test whereJ-1.4 {
322 EXPLAIN QUERY PLAN
323 SELECT aid, sid, MAX(edate) edate
324 FROM tx1
325 WHERE cid = 115790
326 AND sid = 9100
327 AND edate <= 20140430 AND edate >= 20120429
328 GROUP BY aid;
329 } {/B-TREE/}
330
331 ############################################################################
332 # Ensure that the sorting cost does not swamp the loop costs and cause
333 # distinctions between individual loop costs to get lost, and hence for
334 # sub-optimal loops to be chosen.
335 #
336 do_execsql_test whereJ-2.1 {
337 CREATE TABLE tab(
338 id INTEGER PRIMARY KEY,
339 minChild INTEGER REFERENCES t1,
340 maxChild INTEGER REFERENCES t1,
341 x INTEGER
342 );
343 EXPLAIN QUERY PLAN
344 SELECT t4.x
345 FROM tab AS t0, tab AS t1, tab AS t2, tab AS t3, tab AS t4
346 WHERE t0.id=0
347 AND t1.id BETWEEN t0.minChild AND t0.maxChild
348 AND t2.id BETWEEN t1.minChild AND t1.maxChild
349 AND t3.id BETWEEN t2.minChild AND t2.maxChild
350 AND t4.id BETWEEN t3.minChild AND t3.maxChild
351 ORDER BY t4.x;
352 } {~/SCAN/}
353 do_execsql_test whereJ-2.2 {
354 EXPLAIN QUERY PLAN
355 SELECT t4.x
356 FROM tab AS t0a, tab AS t0b,
357 tab AS t1a, tab AS t1b,
358 tab AS t2a, tab AS t2b,
359 tab AS t3a, tab AS t3b,
360 tab AS t4
361 WHERE 1
362 AND t0a.id=1
363 AND t1a.id BETWEEN t0a.minChild AND t0a.maxChild
364 AND t2a.id BETWEEN t1a.minChild AND t1a.maxChild
365 AND t3a.id BETWEEN t2a.minChild AND t2a.maxChild
366 AND t0b.id=2
367 AND t1b.id BETWEEN t0b.minChild AND t0b.maxChild
368 AND t2b.id BETWEEN t1b.minChild AND t1b.maxChild
369 AND t3b.id BETWEEN t2b.minChild AND t2b.maxChild
370 AND t4.id BETWEEN t3a.minChild AND t3b.maxChild
371 ORDER BY t4.x;
372 } {~/SCAN/}
373
374 ############################################################################
375
376 # Create and populate table.
377 do_execsql_test 3.1 { CREATE TABLE t1(a, b, c) }
378 for {set i 0} {$i < 32} {incr i 2} {
379 for {set x 0} {$x < 100} {incr x} {
380 execsql { INSERT INTO t1 VALUES($i, $x, $c) }
381 incr c
382 }
383 execsql { INSERT INTO t1 VALUES($i+1, 5, $c) }
384 incr c
385 }
386
387 do_execsql_test 3.2 {
388 SELECT a, count(*) FROM t1 GROUP BY a HAVING a < 8;
389 } {
390 0 100 1 1 2 100 3 1 4 100 5 1 6 100 7 1
391 }
392
393 do_execsql_test 3.3 {
394 CREATE INDEX idx_ab ON t1(a, b);
395 CREATE INDEX idx_c ON t1(c);
396 ANALYZE;
397 } {}
398
399 # This one should use index "idx_c".
400 do_eqp_test 3.4 {
401 SELECT * FROM t1 WHERE
402 a = 4 AND b BETWEEN 20 AND 80 -- Matches 80 rows
403 AND
404 c BETWEEN 150 AND 160 -- Matches 10 rows
405 } {
406 0 0 0 {SEARCH TABLE t1 USING INDEX idx_c (c>? AND c<?)}
407 }
408
409 # This one should use index "idx_ab".
410 do_eqp_test 3.5 {
411 SELECT * FROM t1 WHERE
412 a = 5 AND b BETWEEN 20 AND 80 -- Matches 1 row
413 AND
414 c BETWEEN 150 AND 160 -- Matches 10 rows
415 } {
416 0 0 0 {SEARCH TABLE t1 USING INDEX idx_ab (a=? AND b>? AND b<?)}
417 }
418
419 ################################################################################ ###########
420
421 # Reset the database and setup for a test case derived from actual SQLite users
422 #
423 db close
424 sqlite3 db test.db
425 do_execsql_test 4.1 {
426 CREATE TABLE le(
427 le_id largeint,
428 xid char(31),
429 type smallint,
430 name char(255) DEFAULT '',
431 mtime largeint DEFAULT 0,
432 muuid int DEFAULT 0
433 );
434 CREATE TABLE cx(
435 cx_id largeint,
436 code char(31),
437 type smallint,
438 name char(31),
439 description varchar,
440 role smallint,
441 mtime largeint DEFAULT 0,
442 muuid int DEFAULT 0,
443 le_id largeint DEFAULT 0,
444 imco smallint DEFAULT 0
445 );
446 CREATE TABLE px(
447 px_id largeint,
448 cx_id largeint,
449 px_tid largeint,
450 name char(31),
451 description varchar DEFAULT '',
452 ia smallint,
453 sl smallint,
454 le_id largeint DEFAULT 0,
455 mtime largeint DEFAULT 0,
456 muuid int DEFAULT 0
457 );
458 CREATE INDEX le_id on le (le_id);
459 CREATE INDEX c_id on cx (cx_id);
460 CREATE INDEX c_leid on cx (le_id);
461 CREATE INDEX p_id on px (px_id);
462 CREATE INDEX p_cid0 on px (cx_id);
463 CREATE INDEX p_pt on px (px_tid);
464 CREATE INDEX p_leid on px (le_id);
465 } {}
466 do_execsql_test 4.2 {
467 ANALYZE sqlite_master;
468 INSERT INTO sqlite_stat1 VALUES('le','le_id','1979 1');
469 INSERT INTO sqlite_stat1 VALUES('cx','c_leid','852 171');
470 INSERT INTO sqlite_stat1 VALUES('cx','c_id','852 1');
471 INSERT INTO sqlite_stat1 VALUES('px','p_leid','114443 63');
472 INSERT INTO sqlite_stat1 VALUES('px','p_pt','114443 22889');
473 INSERT INTO sqlite_stat1 VALUES('px','p_cid0','114443 181');
474 INSERT INTO sqlite_stat1 VALUES('px','p_id','114443 1');
475 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','162 162','162 162',X'03020 2013903fb');
476 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','208 208','208 208',X'03020 20253012d');
477 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','219 219','219 219',X'03020 2025e0131');
478 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','248 248','248 248',X'03020 2027b014e');
479 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','265 265','265 265',X'03020 2028c015f');
480 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','358 358','358 358',X'03020 202e901bc');
481 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','439 439','439 439',X'03020 2033a020d');
482 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','657 657','657 657',X'03020 2041402b4');
483 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','659 659','659 659',X'03020 2041602b6');
484 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','681 681','681 681',X'03020 2042c02cc');
485 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','831 831','831 831',X'03020 204c20482');
486 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','852 852','852 852',X'03020 204d70497');
487 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','870 870','870 870',X'03020 204e904a9');
488 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','879 879','879 879',X'03020 204f204b2');
489 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1099 1099','1099 1099',X'0 3020205ce058e');
490 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1273 1273','1273 1273',X'0 30202067c05a9');
491 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1319 1319','1319 1319',X'0 3020206e30730');
492 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1330 1330','1330 1330',X'0 302020700035b');
493 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1539 1539','1539 1539',X'0 3020207d105d8');
494 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1603 1603','1603 1603',X'0 3020208390780');
495 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1759 1759','1759 1759',X'0 30202092f0618');
496 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1843 1843','1843 1843',X'0 3020209880650');
497 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1915 1915','1915 1915',X'0 3020209d0068b');
498 INSERT INTO sqlite_stat4 VALUES('le','le_id','1 1','1927 1927','1927 1927',X'0 3020209dc0697');
499 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 94','0 94',X'0308015f ');
500 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 189','0 189',X'030802 00be');
501 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 284','0 284',X'030802 0120');
502 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 379','0 379',X'030802 017f');
503 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 474','0 474',X'030802 01de');
504 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 569','0 569',X'030802 023d');
505 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 664','0 664',X'030802 029f');
506 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 759','0 759',X'030802 02fe');
507 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','3 1','846 847','1 847',X'030102 4500e6');
508 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','1 1','849 849','2 849',X'030102 46027e');
509 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','1 1','850 850','3 850',X'030102 4700c9');
510 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','1 1','851 851','4 851',X'030102 48027f');
511 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','94 94','94 94',X'03020200b8 01a8');
512 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','113 113','113 113',X'030202 00d101ad');
513 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','171 171','171 171',X'030201 011d2a');
514 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','177 177','177 177',X'030202 012600f2');
515 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','189 189','189 189',X'030202 013501c8');
516 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','206 206','206 206',X'030201 014f2d');
517 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','231 231','231 231',X'030202 016d00fc');
518 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','284 284','284 284',X'030202 01b702d0');
519 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','291 291','291 291',X'030201 01c042');
520 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','311 311','311 311',X'030202 01d801e7');
521 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','339 339','339 339',X'030201 01f74b');
522 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','347 347','347 347',X'030202 02030118');
523 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','379 379','379 379',X'030202 022f01fa');
524 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','393 393','393 393',X'030201 023f55');
525 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','407 407','407 407',X'030202 02500201');
526 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','413 413','413 413',X'030201 02565a');
527 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','468 468','468 468',X'030201 029468');
528 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','474 474','474 474',X'030202 029a0211');
529 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','517 517','517 517',X'030201 02cc76');
530 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','548 548','548 548',X'030202 02f00223');
531 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','569 569','569 569',X'030202 03090087');
532 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','664 664','664 664',X'030202 03740163');
533 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','759 759','759 759',X'030202 03e800b3');
534 INSERT INTO sqlite_stat4 VALUES('cx','c_id','1 1','803 803','803 803',X'030202 041b026f');
535 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 12715','0 12715',X '030802345b');
536 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 25431','0 25431',X '0308026718');
537 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 38147','0 38147',X '030803009a5c');
538 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 50863','0 50863',X '03080300cdbe');
539 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 63579','0 63579',X '0308030100e8');
540 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 76295','0 76295',X '03080301351d');
541 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 89011','0 89011',X '03080301674c');
542 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110728 1','0 101727','0 101727' ,X'030803019b99');
543 INSERT INTO sqlite_stat4 VALUES('px','p_leid','28 1','110824 110843','16 11084 3',X'0301037a0107f1');
544 INSERT INTO sqlite_stat4 VALUES('px','p_leid','53 1','110873 110875','25 11087 5',X'0302020095275a');
545 INSERT INTO sqlite_stat4 VALUES('px','p_leid','32 1','110927 110936','27 11093 6',X'030203009b009b4a');
546 INSERT INTO sqlite_stat4 VALUES('px','p_leid','51 1','110980 111017','30 11101 7',X'03020300a4016c00');
547 INSERT INTO sqlite_stat4 VALUES('px','p_leid','67 1','111047 111059','38 11105 9',X'03020200af2611');
548 INSERT INTO sqlite_stat4 VALUES('px','p_leid','60 1','111136 111156','43 11115 6',X'03020300bc009aeb');
549 INSERT INTO sqlite_stat4 VALUES('px','p_leid','42 1','111222 111239','59 11123 9',X'03020300d200b17b');
550 INSERT INTO sqlite_stat4 VALUES('px','p_leid','36 1','111264 111266','60 11126 6',X'03020200d426d6');
551 INSERT INTO sqlite_stat4 VALUES('px','p_leid','27 1','111733 111757','159 1117 57',X'030203014e017e1b');
552 INSERT INTO sqlite_stat4 VALUES('px','p_leid','36 1','111760 111773','160 1117 73',X'030203014f00a2b9');
553 INSERT INTO sqlite_stat4 VALUES('px','p_leid','29 1','111822 111833','167 1118 33',X'0302030176009c22');
554 INSERT INTO sqlite_stat4 VALUES('px','p_leid','75 1','113031 113095','1190 113 095',X'030203068501912c');
555 INSERT INTO sqlite_stat4 VALUES('px','p_leid','132 1','113230 113263','1252 11 3263',X'0302030711009ee6');
556 INSERT INTO sqlite_stat4 VALUES('px','p_leid','110 1','113851 113918','1572 11 3918',X'03020308e9011ca2');
557 INSERT INTO sqlite_stat4 VALUES('px','p_leid','78 1','114212 114217','1791 114 217',X'03020209e13b24');
558 INSERT INTO sqlite_stat4 VALUES('px','p_leid','112 1','114303 114351','1799 11 4351',X'03020309ea0128f2');
559 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 12715','0 12715',X'03 0802477e');
560 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 25431','0 25431',X'03 08027c20');
561 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 38147','0 38147',X'03 080300c211');
562 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 50863','0 50863',X'03 080300fbe5');
563 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 63579','0 63579',X'03 08030140ff');
564 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 76295','0 76295',X'03 080301792d');
565 INSERT INTO sqlite_stat4 VALUES('px','p_pt','89824 1','0 89011','0 89011',X'03 080301bb68');
566 INSERT INTO sqlite_stat4 VALUES('px','p_pt','24217 1','89824 101727','1 101727 ',X'03090300da12');
567 INSERT INTO sqlite_stat4 VALUES('px','p_pt','154 1','114041 114154','2 114154' ,X'0301030200e5e9');
568 INSERT INTO sqlite_stat4 VALUES('px','p_pt','198 1','114195 114351','3 114351' ,X'03010303015cb1');
569 INSERT INTO sqlite_stat4 VALUES('px','p_pt','50 1','114393 114441','4 114441', X'0301030401b2ef');
570 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','3867 1','3 3736','2 3736',X'030 10337015c6a');
571 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','4194 1','4177 8209','5 8209',X' 0301033b015075');
572 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','4335 1','8371 11129','6 11129', X'0301033d0156fc');
573 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1740 1','12706 12715','7 12715' ,X'0301023e34b9');
574 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1680 1','14446 15487','8 15487' ,X'0301033f011694');
575 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','7163 1','20116 25431','32 25431 ',X'03020300a400ed26');
576 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1525 1','29100 29302','42 29302 ',X'03020200bb00d1');
577 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','3703 1','30655 33323','45 33323 ',X'03020300be013fa5');
578 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','2612 1','37767 38147','61 38147 ',X'03020200e32828');
579 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1882 1','40545 41584','63 41584 ',X'03020300ea01a35a');
580 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','6984 1','44110 50863','73 50863 ',X'0302030102017467');
581 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1728 1','51230 51680','75 51680 ',X'030203010400b3e0');
582 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','2805 1','55491 57936','95 57936 ',X'030203014101a004');
583 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','2837 1','58934 59506','103 5950 6',X'030203015900a283');
584 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','94 1','63492 63579','137 63579' ,X'0302030191016319');
585 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','3573 1','63591 64497','140 6449 7',X'030203019c00822e');
586 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','5037 1','70917 73033','160 7303 3',X'03020301c70091d9');
587 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1940 1','75954 76295','161 7629 5',X'03020201c817f1');
588 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1927 1','83926 84371','209 8437 1',X'03020202114295');
589 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1522 1','86601 88117','213 8811 7',X'030203021b01b7b5');
590 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','210 1','88906 89011','226 89011 ',X'030203022800dbbb');
591 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','6165 1','92125 98066','258 9806 6',X'030203024d0189ac');
592 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','2900 1','100721 101727','293 10 1727',X'030203027500cf39');
593 INSERT INTO sqlite_stat4 VALUES('px','p_cid0','1501 1','110012 110154','503 11 0154',X'0302020380493a');
594 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','11129 11129','11129 11129', X'03030300d84e014d51');
595 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','12715 12715','12715 12715', X'03030200de816f51');
596 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','13030 13030','13030 13030', X'03030200e05b6fc4');
597 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','25431 25431','25431 25431', X'0303030123df00efb0');
598 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','29302 29302','29302 29302', X'030302013a2812c7');
599 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','35463 35463','35463 35463', X'03030301666e00f866');
600 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','38147 38147','38147 38147', X'030302017a391b74');
601 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','38525 38525','38525 38525', X'030303017c6e00fb58');
602 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','50863 50863','50863 50863', X'03030201b68724dd');
603 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','58461 58461','58461 58461', X'03030201d95b2e1e');
604 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','59506 59506','59506 59506', X'03030301dd7000a0fb');
605 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','63468 63468','63468 63468', X'03030301ecea011405');
606 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','63579 63579','63579 63579', X'03030201ed5932d5');
607 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','64497 64497','64497 64497', X'03030301f0ef00a680');
608 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','73033 73033','73033 73033', X'0303030225b90190e5');
609 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','75650 75650','75650 75650', X'030303023a19019362');
610 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','76295 76295','76295 76295', X'030303023e9801940c');
611 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','79152 79152','79152 79152', X'030303024be50196b9');
612 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','83249 83249','83249 83249', X'0303030261750123b1');
613 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','89011 89011','89011 89011', X'030303027b3900c3af');
614 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','98066 98066','98066 98066', X'03030302a76500ce54');
615 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','101590 101590','101590 1015 90',X'03030302b63d00d3b5');
616 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','101727 101727','101727 1017 27',X'03030202b6f24e9b');
617 INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','107960 107960','107960 1079 60',X'03030302d8ce0136ad');
618 ANALYZE sqlite_master;
619 } {}
620
621 # The following query should do a full table scan of cx in the outer loop.
622 # It is not correct to search table px using indx p_pt in the outer loop
623 # with cx in the middle loop. Test case from Bloomberg on 2014-09-05.
624 #
625 do_execsql_test 4.2 {
626 EXPLAIN QUERY PLAN
627 SELECT
628 px.name,
629 px.description
630 FROM
631 le,
632 cx,
633 px
634 WHERE
635 cx.code = '2990'
636 AND cx.type=2
637 AND px.cx_id = cx.cx_id
638 AND px.px_tid = 0
639 AND px.le_id = le.le_id;
640 } {/.*SCAN TABLE cx.*SEARCH TABLE px.*SEARCH TABLE le.*/}
641
642
643 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/sqlite-src-3080704/test/whereI.test ('k') | third_party/sqlite/sqlite-src-3080704/test/wherelimit.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698