[sqlite] Performace regression bug of sqlite 3.6.18

[Hub Dog]

*I just checked the **explain result  of **sql below under 3.6.17 and
3.6.22, the result is quite different.
SQL:
-- romermb's incredible combination of events, shared events plus 'marriage'
and alternate names as Facts 2010-01-06
-- revised by ve3meo to to bring out RoleName from RoleTableand Sharee's
Names from NameTable, tried to speed up using UNION ALL - not much gain -
still ~270 secs on a 50,000 event, 16,000 person table.
-- revised by romermb on 2010-01-07 to incorporate COUNT, GROUP BY

-- start with a table of nominally female spouses for the nominally male
partners (RIN in FatherID) as a 'fact' for the latter - a Family, even if no
actual Marriage
SELECT FactTypeTable.Name COLLATE NOCASE AS Fact, 'Principal' AS 'Role
Type', NameTable1.OwnerID AS RIN, NameTable1.Surname COLLATE NOCASE AS
Surname, NameTable1.Suffix COLLATE NOCASE AS Suffix, NameTable1.Prefix
COLLATE NOCASE AS Prefix, NameTable1.Given COLLATE NOCASE AS 'Given Name',
NameTable2.OwnerID AS 'Sharer RIN', NameTable2.Surname COLLATE NOCASE AS
'Sharer Surname', NameTable2.Suffix COLLATE NOCASE AS 'Sharer Suffix',
NameTable2.Prefix COLLATE NOCASE AS 'Sharer Prefix', NameTable2.Given
COLLATE NOCASE AS 'Sharer Given Name', COUNT(1) AS Count
FROM EventTable
INNER JOIN FactTypeTable ON EventTable.EventType = FactTypeTable.FactTypeID
INNER JOIN FamilyTable ON EventTable.OwnerID = FamilyTable.FamilyID
INNER JOIN NameTable AS NameTable1 ON FamilyTable.FatherID =
NameTable1.OwnerID
INNER JOIN NameTable AS NameTable2 ON FamilyTable.MotherID =
NameTable2.OwnerID
WHERE EventTable.OwnerType = 1 AND NameTable1.IsPrimary = 1 AND
NameTable2.IsPrimary = 1
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

UNION ALL
-- add nominally male spouses of nominally female partners (RIN in MotherID)
as a 'fact' for the latter - a family even if no actual Marriage
SELECT FactTypeTable.Name COLLATE NOCASE, 'Principal', NameTable2.OwnerID,
NameTable2.Surname COLLATE NOCASE, NameTable2.Suffix COLLATE NOCASE,
NameTable2.Prefix COLLATE NOCASE, NameTable2.Given COLLATE NOCASE,
NameTable1.OwnerID, NameTable1.Surname COLLATE NOCASE, NameTable1.Suffix
COLLATE NOCASE, NameTable1.Prefix COLLATE NOCASE, NameTable1.Given COLLATE
NOCASE, COUNT(1)
FROM EventTable
INNER JOIN FactTypeTable ON EventTable.EventType = FactTypeTable.FactTypeID
INNER JOIN FamilyTable ON EventTable.OwnerID = FamilyTable.FamilyID
INNER JOIN NameTable AS NameTable1 ON FamilyTable.FatherID =
NameTable1.OwnerID
INNER JOIN NameTable AS NameTable2 ON FamilyTable.MotherID =
NameTable2.OwnerID
WHERE EventTable.OwnerType = 1 AND NameTable1.IsPrimary = 1 AND
NameTable2.IsPrimary = 1
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

UNION ALL
-- add all events for Individual
SELECT FactTypeTable.Name COLLATE NOCASE, 'Principal', NameTable.OwnerID,
NameTable.Surname COLLATE NOCASE, NameTable.Suffix COLLATE NOCASE,
NameTable.Prefix COLLATE NOCASE, NameTable.Given COLLATE NOCASE, NULL, NULL,
NULL, NULL, NULL, COUNT(1)
FROM EventTable
INNER JOIN FactTypeTable ON EventTable.EventType = FactTypeTable.FactTypeID
INNER JOIN NameTable ON EventTable.OwnerID = NameTable.OwnerID
WHERE EventTable.OwnerType = 0 AND NameTable.IsPrimary = 1
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

UNION ALL
-- add Alternate Name as a 'Fact'
SELECT 'Alternate name', 'Principal', OwnerID, Surname COLLATE NOCASE,
Suffix COLLATE NOCASE, Prefix COLLATE NOCASE, Given COLLATE NOCASE, NULL,
NULL, NULL, NULL, NULL, COUNT(1)
FROM NameTable
WHERE IsPrimary = 0
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

UNION ALL
-- add shared events other than family as 'Facts' - revised by ve3meo to
bring out RoleName from RoleTableand Sharee's Names from NameTable
SELECT FactTypeTable.Name COLLATE NOCASE, RoleName COLLATE NOCASE,
NameTable1.OwnerID, NameTable1.Surname COLLATE NOCASE, NameTable1.Suffix
COLLATE NOCASE, NameTable1.Prefix COLLATE NOCASE, NameTable1.Given COLLATE
NOCASE, EventTable.OwnerID, NameTable2.Surname COLLATE NOCASE,
NameTable2.Suffix COLLATE NOCASE, NameTable2.Prefix COLLATE NOCASE,
NameTable2.Given COLLATE NOCASE, COUNT(1)
FROM WitnessTable
INNER JOIN roletable ON Role = RoleID
INNER JOIN EventTable ON WitnessTable.EventID = EventTable.EventID
INNER JOIN NameTable AS NameTable1 ON WitnessTable.PersonID =
NameTable1.OwnerID
INNER JOIN NameTable AS NameTable2 ON EventTable.OwnerID =
NameTable2.OwnerID
INNER JOIN FactTypeTable ON EventTable.EventType = FactTypeTable.FactTypeID
WHERE NameTable1.IsPrimary = 1
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12

ORDER BY RIN;

run under 3.6.17
addr,opcode,p1,p2,p3,p4,p5,comment
0,Trace,0,0,0,,00,,
1,Goto,0,901,0,,00,,
2,Goto,0,700,0,,00,,
3,Goto,0,550,0,,00,,
4,Goto,0,378,0,,00,,
5,OpenEphemeral,20,3,0,"keyinfo(1,BINARY)",00,,
6,OpenEphemeral,21,13,0,"keyinfo(12,NOCASE,BINARY)",00,,
7,Integer,0,38,0,,00,,
8,Integer,0,37,0,,00,,
9,Gosub,40,145,0,,00,,
10,Integer,1,65,0,,00,,
11,Integer,1,66,0,,00,,
12,Integer,1,67,0,,00,,
13,Goto,0,911,0,,00,,
14,OpenRead,18,32,0,11,00,,
15,OpenRead,22,38,0,"keyinfo(1,BINARY)",00,,
16,OpenRead,17,5,0,3,00,,
17,OpenRead,23,6,0,"keyinfo(1,BINARY)",00,,
18,OpenRead,15,14,0,4,00,,
19,OpenRead,24,17,0,"keyinfo(2,BINARY,BINARY)",00,,
20,OpenRead,16,20,0,3,00,,
21,OpenRead,19,32,0,11,00,,
22,OpenRead,25,38,0,"keyinfo(1,BINARY)",00,,
23,IsNull,66,75,0,,00,,
24,Affinity,66,1,0,db,00,,
25,SeekGe,22,75,66,1,00,,
26,IdxGE,22,75,66,1,01,,
27,IdxRowid,22,68,0,,00,,
28,Seek,18,68,0,,00,,
29,Column,18,1,69,,00,,
30,IsNull,69,74,0,,00,,
31,Affinity,69,1,0,db,00,,
32,SeekGe,23,74,69,1,00,,
33,IdxGE,23,74,69,1,01,,
34,IdxRowid,23,70,0,,00,,
35,Seek,17,70,0,,00,,
36,IsNull,70,73,0,,00,,
37,Affinity,70,1,0,ddb,00,,
38,SeekGe,24,73,70,1,00,,
39,IdxGE,24,73,70,1,01,,
40,IdxRowid,24,71,0,,00,,
41,Seek,15,71,0,,00,,
42,Column,15,2,72,,00,,
43,Ne,65,72,72,collseq(BINARY),6c,,
44,Column,15,1,73,,00,,
45,MustBeInt,73,72,0,,00,,
46,NotExists,16,72,73,,00,,
47,IsNull,67,72,0,,00,,
48,Affinity,67,1,0,db,00,,
49,SeekGe,25,72,67,1,00,,
50,IdxGE,25,72,67,1,01,,
51,IdxRowid,25,74,0,,00,,
52,Seek,19,74,0,,00,,
53,Column,17,2,75,,00,,
54,Column,19,1,76,,00,,
55,Ne,76,71,75,collseq(BINARY),6b,,
56,Column,16,2,77,,00,,
57,String8,0,78,0,Principal,00,,
58,Column,18,1,79,,00,,
59,Column,18,2,80,,00,,
60,Column,18,5,81,,00,,
61,Column,18,4,82,,00,,
62,Column,18,3,83,,00,,
63,Column,19,1,84,,00,,
64,Column,19,2,85,,00,,
65,Column,19,5,86,,00,,
66,Column,19,4,87,,00,,
67,Column,19,3,88,,00,,
68,Sequence,21,89,0,,00,,
69,MakeRecord,77,13,76,,00,,
70,IdxInsert,21,76,0,,00,,
71,Next,25,50,0,,00,,
72,Next,24,39,0,,00,,
73,Next,23,33,0,,00,,
74,Next,22,26,0,,00,,
75,Close,18,0,0,,00,,
76,Close,22,0,0,,00,,
77,Close,17,0,0,,00,,
78,Close,23,0,0,,00,,
79,Close,15,0,0,,00,,
80,Close,24,0,0,,00,,
81,Close,16,0,0,,00,,
82,Close,19,0,0,,00,,
83,Close,25,0,0,,00,,
84,Sort,21,158,0,,00,,
85,Column,21,0,53,,00,,
86,Column,21,1,54,,00,,
87,Column,21,2,55,,00,,
88,Column,21,3,56,,00,,
89,Column,21,4,57,,00,,
90,Column,21,5,58,,00,,
91,Column,21,6,59,,00,,
92,Column,21,7,60,,00,,
93,Column,21,8,61,,00,,
94,Column,21,9,62,,00,,
95,Column,21,10,63,,00,,
96,Column,21,11,64,,00,,
97,Compare,41,53,12,"keyinfo(12,NOCASE,BINARY)",00,,
98,Jump,99,103,99,,00,,
99,Move,53,41,12,,00,,
100,Gosub,39,122,0,,00,,
101,IfPos,38,158,0,,00,,
102,Gosub,40,145,0,,00,,
103,Integer,1,77,0,,00,,
104,AggStep,0,77,36,count(1),01,,
105,Column,21,0,25,,00,,
106,Column,21,2,26,,00,,
107,Column,21,3,27,,00,,
108,Column,21,4,28,,00,,
109,Column,21,5,29,,00,,
110,Column,21,6,30,,00,,
111,Column,21,7,31,,00,,
112,Column,21,8,32,,00,,
113,Column,21,9,33,,00,,
114,Column,21,10,34,,00,,
115,Column,21,11,35,,00,,
116,Integer,1,37,0,,00,,
117,Next,21,85,0,,00,,
118,Gosub,39,122,0,,00,,
119,Goto,0,158,0,,00,,
120,Integer,1,38,0,,00,,
121,Return,39,0,0,,00,,
122,IfPos,37,124,0,,00,,
123,Return,39,0,0,,00,,
124,AggFinal,36,1,0,count(1),00,,
125,SCopy,25,90,0,,00,,
126,String8,0,91,0,Principal,00,,
127,SCopy,26,92,0,,00,,
128,SCopy,27,93,0,,00,,
129,SCopy,28,94,0,,00,,
130,SCopy,29,95,0,,00,,
131,SCopy,30,96,0,,00,,
132,SCopy,31,97,0,,00,,
133,SCopy,32,98,0,,00,,
134,SCopy,33,99,0,,00,,
135,SCopy,34,100,0,,00,,
136,SCopy,35,101,0,,00,,
137,SCopy,36,102,0,,00,,
138,MakeRecord,90,13,76,,00,,
139,SCopy,26,78,0,,00,,
140,Sequence,20,79,0,,00,,
141,Move,76,80,1,,00,,
142,MakeRecord,78,3,75,,00,,
143,IdxInsert,20,75,0,,00,,
144,Return,39,0,0,,00,,
145,Null,0,25,0,,00,,
146,Null,0,26,0,,00,,
147,Null,0,27,0,,00,,
148,Null,0,28,0,,00,,
149,Null,0,29,0,,00,,
150,Null,0,30,0,,00,,
151,Null,0,31,0,,00,,
152,Null,0,32,0,,00,,
153,Null,0,33,0,,00,,
154,Null,0,34,0,,00,,
155,Null,0,35,0,,00,,
156,Null,0,36,0,,00,,
157,Return,40,0,0,,00,,
158,OpenPseudo,26,0,13,,00,,
159,Sort,20,178,0,,00,,
160,Column,20,2,76,,00,,
161,Integer,1,75,0,,00,,
162,Insert,26,76,75,,00,,
163,Column,26,0,90,,00,,
164,Column,26,1,91,,00,,
165,Column,26,2,92,,00,,
166,Column,26,3,93,,00,,
167,Column,26,4,94,,00,,
168,Column,26,5,95,,00,,
169,Column,26,6,96,,00,,
170,Column,26,7,97,,00,,
171,Column,26,8,98,,00,,
172,Column,26,9,99,,00,,
173,Column,26,10,100,,00,,
174,Column,26,11,101,,00,,
175,Column,26,12,102,,00,,
176,Yield,19,0,0,,00,,
177,Next,20,160,0,,00,,
178,Close,26,0,0,,00,,
179,Integer,1,20,0,,00,,
180,Yield,19,0,0,,00,,
181,OpenEphemeral,27,3,0,"keyinfo(1,BINARY)",00,,
182,OpenEphemeral,28,13,0,"keyinfo(12,NOCASE,BINARY)",00,,
183,Integer,0,116,0,,00,,
184,Integer,0,115,0,,00,,
185,Gosub,118,320,0,,00,,
186,Integer,1,143,0,,00,,
187,Integer,1,144,0,,00,,
188,Integer,1,145,0,,00,,
189,OpenRead,13,32,0,11,00,,
190,OpenRead,29,38,0,"keyinfo(1,BINARY)",00,,
191,OpenRead,12,5,0,3,00,,
192,OpenRead,30,6,0,"keyinfo(1,BINARY)",00,,
193,OpenRead,10,14,0,4,00,,
194,OpenRead,31,17,0,"keyinfo(2,BINARY,BINARY)",00,,
195,OpenRead,11,20,0,3,00,,
196,OpenRead,14,32,0,11,00,,
197,OpenRead,32,38,0,"keyinfo(1,BINARY)",00,,
198,IsNull,144,250,0,,00,,
199,Affinity,144,1,0,db,00,,
200,SeekGe,29,250,144,1,00,,
201,IdxGE,29,250,144,1,01,,
202,IdxRowid,29,146,0,,00,,
203,Seek,13,146,0,,00,,
204,Column,13,1,147,,00,,
205,IsNull,147,249,0,,00,,
206,Affinity,147,1,0,db,00,,
207,SeekGe,30,249,147,1,00,,
208,IdxGE,30,249,147,1,01,,
209,IdxRowid,30,75,0,,00,,
210,Seek,12,75,0,,00,,
211,IsNull,75,248,0,,00,,
212,Affinity,75,1,0,ddb,00,,
213,SeekGe,31,248,75,1,00,,
214,IdxGE,31,248,75,1,01,,
215,IdxRowid,31,148,0,,00,,
216,Seek,10,148,0,,00,,
217,Column,10,2,76,,00,,
218,Ne,143,247,76,collseq(BINARY),6c,,
219,Column,10,1,74,,00,,
220,MustBeInt,74,247,0,,00,,
221,NotExists,11,247,74,,00,,
222,IsNull,145,247,0,,00,,
223,Affinity,145,1,0,db,00,,
224,SeekGe,32,247,145,1,00,,
225,IdxGE,32,247,145,1,01,,
226,IdxRowid,32,149,0,,00,,
227,Seek,14,149,0,,00,,
228,Column,12,2,73,,00,,
229,Column,14,1,72,,00,,
230,Ne,72,246,73,collseq(BINARY),6b,,
231,Column,11,2,150,,00,,
232,String8,0,151,0,Principal,00,,
233,Column,14,1,152,,00,,
234,Column,14,2,153,,00,,
235,Column,14,5,154,,00,,
236,Column,14,4,155,,00,,
237,Column,14,3,156,,00,,
238,Column,13,1,157,,00,,
239,Column,13,2,158,,00,,
240,Column,13,5,159,,00,,
241,Column,13,4,160,,00,,
242,Column,13,3,161,,00,,
243,Sequence,28,162,0,,00,,
244,MakeRecord,150,13,73,,00,,
245,IdxInsert,28,73,0,,00,,
246,Next,32,225,0,,00,,
247,Next,31,214,0,,00,,
248,Next,30,208,0,,00,,
249,Next,29,201,0,,00,,
250,Close,13,0,0,,00,,
251,Close,29,0,0,,00,,
252,Close,12,0,0,,00,,
253,Close,30,0,0,,00,,
254,Close,10,0,0,,00,,
255,Close,31,0,0,,00,,
256,Close,11,0,0,,00,,
257,Close,14,0,0,,00,,
258,Close,32,0,0,,00,,
259,Sort,28,333,0,,00,,
260,Column,28,0,131,,00,,
261,Column,28,1,132,,00,,
262,Column,28,2,133,,00,,
263,Column,28,3,134,,00,,
264,Column,28,4,135,,00,,
265,Column,28,5,136,,00,,
266,Column,28,6,137,,00,,
267,Column,28,7,138,,00,,
268,Column,28,8,139,,00,,
269,Column,28,9,140,,00,,
270,Column,28,10,141,,00,,
271,Column,28,11,142,,00,,
272,Compare,119,131,12,"keyinfo(12,NOCASE,BINARY)",00,,
273,Jump,274,278,274,,00,,
274,Move,131,119,12,,00,,
275,Gosub,117,297,0,,00,,
276,IfPos,116,333,0,,00,,
277,Gosub,118,320,0,,00,,
278,Integer,1,150,0,,00,,
279,AggStep,0,150,114,count(1),01,,
280,Column,28,0,103,,00,,
281,Column,28,2,104,,00,,
282,Column,28,3,105,,00,,
283,Column,28,4,106,,00,,
284,Column,28,5,107,,00,,
285,Column,28,6,108,,00,,
286,Column,28,7,109,,00,,
287,Column,28,8,110,,00,,
288,Column,28,9,111,,00,,
289,Column,28,10,112,,00,,
290,Column,28,11,113,,00,,
291,Integer,1,115,0,,00,,
292,Next,28,260,0,,00,,
293,Gosub,117,297,0,,00,,
294,Goto,0,333,0,,00,,
295,Integer,1,116,0,,00,,
296,Return,117,0,0,,00,,
297,IfPos,115,299,0,,00,,
298,Return,117,0,0,,00,,
299,AggFinal,114,1,0,count(1),00,,
300,SCopy,103,163,0,,00,,
301,String8,0,164,0,Principal,00,,
302,SCopy,104,165,0,,00,,
303,SCopy,105,166,0,,00,,
304,SCopy,106,167,0,,00,,
305,SCopy,107,168,0,,00,,
306,SCopy,108,169,0,,00,,
307,SCopy,109,170,0,,00,,
308,SCopy,110,171,0,,00,,
309,SCopy,111,172,0,,00,,
310,SCopy,112,173,0,,00,,
311,SCopy,113,174,0,,00,,
312,SCopy,114,175,0,,00,,
313,MakeRecord,163,13,73,,00,,
314,SCopy,104,151,0,,00,,
315,Sequence,27,152,0,,00,,
316,Move,73,153,1,,00,,
317,MakeRecord,151,3,149,,00,,
318,IdxInsert,27,149,0,,00,,
319,Return,117,0,0,,00,,
320,Null,0,103,0,,00,,
321,Null,0,104,0,,00,,
322,Null,0,105,0,,00,,
323,Null,0,106,0,,00,,
324,Null,0,107,0,,00,,
325,Null,0,108,0,,00,,
326,Null,0,109,0,,00,,
327,Null,0,110,0,,00,,
328,Null,0,111,0,,00,,
329,Null,0,112,0,,00,,
330,Null,0,113,0,,00,,
331,Null,0,114,0,,00,,
332,Return,118,0,0,,00,,
333,OpenPseudo,33,0,13,,00,,
334,Sort,27,353,0,,00,,
335,Column,27,2,73,,00,,
336,Integer,1,149,0,,00,,
337,Insert,33,73,149,,00,,
338,Column,33,0,163,,00,,
339,Column,33,1,164,,00,,
340,Column,33,2,165,,00,,
341,Column,33,3,166,,00,,
342,Column,33,4,167,,00,,
343,Column,33,5,168,,00,,
344,Column,33,6,169,,00,,
345,Column,33,7,170,,00,,
346,Column,33,8,171,,00,,
347,Column,33,9,172,,00,,
348,Column,33,10,173,,00,,
349,Column,33,11,174,,00,,
350,Column,33,12,175,,00,,
351,Yield,21,0,0,,00,,
352,Next,27,335,0,,00,,
353,Close,33,0,0,,00,,
354,Integer,1,22,0,,00,,
355,Yield,21,0,0,,00,,
356,Move,90,176,13,,00,,
357,Yield,13,0,0,,00,,
358,Return,23,0,0,,00,,
359,Move,163,176,13,,00,,
360,Yield,13,0,0,,00,,
361,Return,24,0,0,,00,,
362,If,22,387,0,,00,,
363,Gosub,24,359,0,,00,,
364,Yield,21,0,0,,00,,
365,Goto,0,362,0,,00,,
366,If,20,387,0,,00,,
367,Gosub,23,356,0,,00,,
368,Yield,19,0,0,,00,,
369,Goto,0,366,0,,00,,
370,Gosub,23,356,0,,00,,
371,Yield,19,0,0,,00,,
372,If,20,362,0,,00,,
373,Goto,0,384,0,,00,,
374,Gosub,24,359,0,,00,,
375,Yield,21,0,0,,00,,
376,If,22,366,0,,00,,
377,Goto,0,384,0,,00,,
378,Integer,0,20,0,,00,,
379,Integer,0,22,0,,00,,
380,Gosub,19,5,0,,00,,
381,Gosub,21,181,0,,00,,
382,If,20,362,0,,00,,
383,If,22,366,0,,00,,
384,Permutation,0,0,0,intarray,00,,
385,Compare,90,163,1,"keyinfo(1,BINARY)",00,,
386,Jump,370,370,374,,00,,
387,Integer,1,14,0,,00,,
388,Yield,13,0,0,,00,,
389,OpenEphemeral,34,3,0,"keyinfo(1,BINARY)",00,,
390,OpenEphemeral,35,13,0,"keyinfo(12,NOCASE,BINARY)",00,,
391,Integer,0,197,0,,00,,
392,Integer,0,196,0,,00,,
393,Gosub,199,497,0,,00,,
394,Integer,0,224,0,,00,,
395,Integer,1,225,0,,00,,
396,OpenRead,9,32,0,11,00,,
397,OpenRead,36,38,0,"keyinfo(1,BINARY)",00,,
398,OpenRead,7,14,0,4,00,,
399,OpenRead,37,17,0,"keyinfo(2,BINARY,BINARY)",00,,
400,OpenRead,8,20,0,3,00,,
401,IsNull,225,436,0,,00,,
402,Affinity,225,1,0,db,00,,
403,SeekGe,36,436,225,1,00,,
404,IdxGE,36,436,225,1,01,,
405,IdxRowid,36,149,0,,00,,
406,Seek,9,149,0,,00,,
407,Column,9,1,227,,00,,
408,IsNull,227,435,0,,00,,
409,Affinity,227,1,0,ddb,00,,
410,SeekGe,37,435,227,1,00,,
411,IdxGE,37,435,227,1,01,,
412,IdxRowid,37,73,0,,00,,
413,Seek,7,73,0,,00,,
414,Column,7,2,74,,00,,
415,Ne,224,434,74,collseq(BINARY),6c,,
416,Column,7,1,76,,00,,
417,MustBeInt,76,434,0,,00,,
418,NotExists,8,434,76,,00,,
419,Column,8,2,228,,00,,
420,String8,0,229,0,Principal,00,,
421,Column,9,1,230,,00,,
422,Column,9,2,231,,00,,
423,Column,9,5,232,,00,,
424,Column,9,4,233,,00,,
425,Column,9,3,234,,00,,
426,Null,0,235,0,,00,,
427,Null,0,236,0,,00,,
428,Null,0,237,0,,00,,
429,Null,0,238,0,,00,,
430,Null,0,239,0,,00,,
431,Sequence,35,240,0,,00,,
432,MakeRecord,228,13,76,,00,,
433,IdxInsert,35,76,0,,00,,
434,Next,37,411,0,,00,,
435,Next,36,404,0,,00,,
436,Close,9,0,0,,00,,
437,Close,36,0,0,,00,,
438,Close,7,0,0,,00,,
439,Close,37,0,0,,00,,
440,Close,8,0,0,,00,,
441,Sort,35,505,0,,00,,
442,Column,35,0,212,,00,,
443,Column,35,1,213,,00,,
444,Column,35,2,214,,00,,
445,Column,35,3,215,,00,,
446,Column,35,4,216,,00,,
447,Column,35,5,217,,00,,
448,Column,35,6,218,,00,,
449,Column,35,7,219,,00,,
450,Column,35,8,220,,00,,
451,Column,35,9,221,,00,,
452,Column,35,10,222,,00,,
453,Column,35,11,223,,00,,
454,Compare,200,212,12,"keyinfo(12,NOCASE,BINARY)",00,,
455,Jump,456,460,456,,00,,
456,Move,212,200,12,,00,,
457,Gosub,198,474,0,,00,,
458,IfPos,197,505,0,,00,,
459,Gosub,199,497,0,,00,,
460,Integer,1,228,0,,00,,
461,AggStep,0,228,195,count(1),01,,
462,Column,35,0,189,,00,,
463,Column,35,2,190,,00,,
464,Column,35,3,191,,00,,
465,Column,35,4,192,,00,,
466,Column,35,5,193,,00,,
467,Column,35,6,194,,00,,
468,Integer,1,196,0,,00,,
469,Next,35,442,0,,00,,
470,Gosub,198,474,0,,00,,
471,Goto,0,505,0,,00,,
472,Integer,1,197,0,,00,,
473,Return,198,0,0,,00,,
474,IfPos,196,476,0,,00,,
475,Return,198,0,0,,00,,
476,AggFinal,195,1,0,count(1),00,,
477,SCopy,189,241,0,,00,,
478,String8,0,242,0,Principal,00,,
479,SCopy,190,243,0,,00,,
480,SCopy,191,244,0,,00,,
481,SCopy,192,245,0,,00,,
482,SCopy,193,246,0,,00,,
483,SCopy,194,247,0,,00,,
484,Null,0,248,0,,00,,
485,Null,0,249,0,,00,,
486,Null,0,250,0,,00,,
487,Null,0,251,0,,00,,
488,Null,0,252,0,,00,,
489,SCopy,195,253,0,,00,,
490,MakeRecord,241,13,76,,00,,
491,SCopy,190,229,0,,00,,
492,Sequence,34,230,0,,00,,
493,Move,76,231,1,,00,,
494,MakeRecord,229,3,74,,00,,
495,IdxInsert,34,74,0,,00,,
496,Return,198,0,0,,00,,
497,Null,0,189,0,,00,,
498,Null,0,190,0,,00,,
499,Null,0,191,0,,00,,
500,Null,0,192,0,,00,,
501,Null,0,193,0,,00,,
502,Null,0,194,0,,00,,
503,Null,0,195,0,,00,,
504,Return,199,0,0,,00,,
505,OpenPseudo,38,0,13,,00,,
506,Sort,34,525,0,,00,,
507,Column,34,2,76,,00,,
508,Integer,1,74,0,,00,,
509,Insert,38,76,74,,00,,
510,Column,38,0,241,,00,,
511,Column,38,1,242,,00,,
512,Column,38,2,243,,00,,
513,Column,38,3,244,,00,,
514,Column,38,4,245,,00,,
515,Column,38,5,246,,00,,
516,Column,38,6,247,,00,,
517,Column,38,7,248,,00,,
518,Column,38,8,249,,00,,
519,Column,38,9,250,,00,,
520,Column,38,10,251,,00,,
521,Column,38,11,252,,00,,
522,Column,38,12,253,,00,,
523,Yield,15,0,0,,00,,
524,Next,34,507,0,,00,,
525,Close,38,0,0,,00,,
526,Integer,1,16,0,,00,,
527,Yield,15,0,0,,00,,
528,Move,176,254,13,,00,,
529,Yield,7,0,0,,00,,
530,Return,17,0,0,,00,,
531,Move,241,254,13,,00,,
532,Yield,7,0,0,,00,,
533,Return,18,0,0,,00,,
534,If,16,559,0,,00,,
535,Gosub,18,531,0,,00,,
536,Yield,15,0,0,,00,,
537,Goto,0,534,0,,00,,
538,If,14,559,0,,00,,
539,Gosub,17,528,0,,00,,
540,Yield,13,0,0,,00,,
541,Goto,0,538,0,,00,,
542,Gosub,17,528,0,,00,,
543,Yield,13,0,0,,00,,
544,If,14,534,0,,00,,
545,Goto,0,556,0,,00,,
546,Gosub,18,531,0,,00,,
547,Yield,15,0,0,,00,,
548,If,16,538,0,,00,,
549,Goto,0,556,0,,00,,
550,Integer,0,14,0,,00,,
551,Integer,0,16,0,,00,,
552,Gosub,13,4,0,,00,,
553,Gosub,15,389,0,,00,,
554,If,14,534,0,,00,,
555,If,16,538,0,,00,,
556,Permutation,0,0,0,intarray,00,,
557,Compare,176,241,1,"keyinfo(1,BINARY)",00,,
558,Jump,542,542,546,,00,,
559,Integer,1,8,0,,00,,
560,Yield,7,0,0,,00,,
561,OpenEphemeral,39,3,0,"keyinfo(1,BINARY)",00,,
562,OpenEphemeral,40,13,0,"keyinfo(12,BINARY,BINARY)",00,,
563,Integer,0,274,0,,00,,
564,Integer,0,273,0,,00,,
565,Gosub,276,648,0,,00,,
566,Integer,0,301,0,,00,,
567,OpenRead,6,32,0,11,00,,
568,OpenRead,41,38,0,"keyinfo(1,BINARY)",00,,
569,IsNull,301,591,0,,00,,
570,Affinity,301,1,0,db,00,,
571,SeekGe,41,591,301,1,00,,
572,IdxGE,41,591,301,1,01,,
573,IdxRowid,41,74,0,,00,,
574,Seek,6,74,0,,00,,
575,String8,0,303,0,Alternate name,00,,
576,String8,0,304,0,Principal,00,,
577,Column,6,1,305,,00,,
578,Column,6,2,306,,00,,
579,Column,6,5,307,,00,,
580,Column,6,4,308,,00,,
581,Column,6,3,309,,00,,
582,Null,0,310,0,,00,,
583,Null,0,311,0,,00,,
584,Null,0,312,0,,00,,
585,Null,0,313,0,,00,,
586,Null,0,314,0,,00,,
587,Sequence,40,315,0,,00,,
588,MakeRecord,303,13,74,,00,,
589,IdxInsert,40,74,0,,00,,
590,Next,41,572,0,,00,,
591,Close,6,0,0,,00,,
592,Close,41,0,0,,00,,
593,Sort,40,655,0,,00,,
594,Column,40,0,289,,00,,
595,Column,40,1,290,,00,,
596,Column,40,2,291,,00,,
597,Column,40,3,292,,00,,
598,Column,40,4,293,,00,,
599,Column,40,5,294,,00,,
600,Column,40,6,295,,00,,
601,Column,40,7,296,,00,,
602,Column,40,8,297,,00,,
603,Column,40,9,298,,00,,
604,Column,40,10,299,,00,,
605,Column,40,11,300,,00,,
606,Compare,277,289,12,"keyinfo(12,BINARY,BINARY)",00,,
607,Jump,608,612,608,,00,,
608,Move,289,277,12,,00,,
609,Gosub,275,625,0,,00,,
610,IfPos,274,655,0,,00,,
611,Gosub,276,648,0,,00,,
612,Integer,1,303,0,,00,,
613,AggStep,0,303,272,count(1),01,,
614,Column,40,2,267,,00,,
615,Column,40,3,268,,00,,
616,Column,40,4,269,,00,,
617,Column,40,5,270,,00,,
618,Column,40,6,271,,00,,
619,Integer,1,273,0,,00,,
620,Next,40,594,0,,00,,
621,Gosub,275,625,0,,00,,
622,Goto,0,655,0,,00,,
623,Integer,1,274,0,,00,,
624,Return,275,0,0,,00,,
625,IfPos,273,627,0,,00,,
626,Return,275,0,0,,00,,
627,AggFinal,272,1,0,count(1),00,,
628,String8,0,316,0,Alternate name,00,,
629,String8,0,317,0,Principal,00,,
630,SCopy,267,318,0,,00,,
631,SCopy,268,319,0,,00,,
632,SCopy,269,320,0,,00,,
633,SCopy,270,321,0,,00,,
634,SCopy,271,322,0,,00,,
635,Null,0,323,0,,00,,
636,Null,0,324,0,,00,,
637,Null,0,325,0,,00,,
638,Null,0,326,0,,00,,
639,Null,0,327,0,,00,,
640,SCopy,272,328,0,,00,,
641,MakeRecord,316,13,74,,00,,
642,SCopy,267,304,0,,00,,
643,Sequence,39,305,0,,00,,
644,Move,74,306,1,,00,,
645,MakeRecord,304,3,76,,00,,
646,IdxInsert,39,76,0,,00,,
647,Return,275,0,0,,00,,
648,Null,0,267,0,,00,,
649,Null,0,268,0,,00,,
650,Null,0,269,0,,00,,
651,Null,0,270,0,,00,,
652,Null,0,271,0,,00,,
653,Null,0,272,0,,00,,
654,Return,276,0,0,,00,,
655,OpenPseudo,42,0,13,,00,,
656,Sort,39,675,0,,00,,
657,Column,39,2,74,,00,,
658,Integer,1,76,0,,00,,
659,Insert,42,74,76,,00,,
660,Column,42,0,316,,00,,
661,Column,42,1,317,,00,,
662,Column,42,2,318,,00,,
663,Column,42,3,319,,00,,
664,Column,42,4,320,,00,,
665,Column,42,5,321,,00,,
666,Column,42,6,322,,00,,
667,Column,42,7,323,,00,,
668,Column,42,8,324,,00,,
669,Column,42,9,325,,00,,
670,Column,42,10,326,,00,,
671,Column,42,11,327,,00,,
672,Column,42,12,328,,00,,
673,Yield,9,0,0,,00,,
674,Next,39,657,0,,00,,
675,Close,42,0,0,,00,,
676,Integer,1,10,0,,00,,
677,Yield,9,0,0,,00,,
678,Move,254,329,13,,00,,
679,Yield,1,0,0,,00,,
680,Return,11,0,0,,00,,
681,Move,316,329,13,,00,,
682,Yield,1,0,0,,00,,
683,Return,12,0,0,,00,,
684,If,10,709,0,,00,,
685,Gosub,12,681,0,,00,,
686,Yield,9,0,0,,00,,
687,Goto,0,684,0,,00,,
688,If,8,709,0,,00,,
689,Gosub,11,678,0,,00,,
690,Yield,7,0,0,,00,,
691,Goto,0,688,0,,00,,
692,Gosub,11,678,0,,00,,
693,Yield,7,0,0,,00,,
694,If,8,684,0,,00,,
695,Goto,0,706,0,,00,,
696,Gosub,12,681,0,,00,,
697,Yield,9,0,0,,00,,
698,If,10,688,0,,00,,
699,Goto,0,706,0,,00,,
700,Integer,0,8,0,,00,,
701,Integer,0,10,0,,00,,
702,Gosub,7,3,0,,00,,
703,Gosub,9,561,0,,00,,
704,If,8,684,0,,00,,
705,If,10,688,0,,00,,
706,Permutation,0,0,0,intarray,00,,
707,Compare,254,316,1,"keyinfo(1,BINARY)",00,,
708,Jump,692,692,696,,00,,
709,Integer,1,2,0,,00,,
710,Yield,1,0,0,,00,,
711,OpenEphemeral,43,3,0,"keyinfo(1,BINARY)",00,,
712,OpenEphemeral,44,13,0,"keyinfo(12,NOCASE,NOCASE)",00,,
713,Integer,0,356,0,,00,,
714,Integer,0,355,0,,00,,
715,Gosub,358,844,0,,00,,
716,Integer,1,383,0,,00,,
717,OpenRead,3,32,0,11,00,,
718,OpenRead,45,38,0,"keyinfo(1,BINARY)",00,,
719,OpenRead,0,53,0,5,00,,
720,OpenRead,46,56,0,"keyinfo(1,BINARY)",00,,
721,OpenRead,1,60,0,2,00,,
722,OpenRead,2,14,0,4,00,,
723,OpenRead,5,20,0,3,00,,
724,OpenRead,4,32,0,6,00,,
725,OpenRead,47,34,0,"keyinfo(1,BINARY)",00,,
726,IsNull,383,773,0,,00,,
727,Affinity,383,1,0,db,00,,
728,SeekGe,45,773,383,1,00,,
729,IdxGE,45,773,383,1,01,,
730,IdxRowid,45,76,0,,00,,
731,Seek,3,76,0,,00,,
732,Column,3,1,385,,00,,
733,IsNull,385,772,0,,00,,
734,Affinity,385,1,0,db,00,,
735,SeekGe,46,772,385,1,00,,
736,IdxGE,46,772,385,1,01,,
737,IdxRowid,46,74,0,,00,,
738,Seek,0,74,0,,00,,
739,Column,0,4,73,,00,,
740,MustBeInt,73,771,0,,00,,
741,NotExists,1,771,73,,00,,
742,Column,0,1,149,,00,,
743,MustBeInt,149,771,0,,00,,
744,NotExists,2,771,149,,00,,
745,Column,2,1,148,,00,,
746,MustBeInt,148,771,0,,00,,
747,NotExists,5,771,148,,00,,
748,Column,2,3,386,,00,,
749,IsNull,386,771,0,,00,,
750,Affinity,386,1,0,db,00,,
751,SeekGe,47,771,386,1,00,,
752,IdxGE,47,771,386,1,01,,
753,IdxRowid,47,146,0,,00,,
754,Seek,4,146,0,,00,,
755,Column,5,2,387,,00,,
756,Column,1,1,388,,00,,
757,Column,3,1,389,,00,,
758,Column,3,2,390,,00,,
759,Column,3,5,391,,00,,
760,Column,3,4,392,,00,,
761,Column,3,3,393,,00,,
762,Column,2,3,394,,00,,
763,Column,4,2,395,,00,,
764,Column,4,5,396,,00,,
765,Column,4,4,397,,00,,
766,Column,4,3,398,,00,,
767,Sequence,44,399,0,,00,,
768,MakeRecord,387,13,148,,00,,
769,IdxInsert,44,148,0,,00,,
770,Next,47,752,0,,00,,
771,Next,46,736,0,,00,,
772,Next,45,729,0,,00,,
773,Close,3,0,0,,00,,
774,Close,45,0,0,,00,,
775,Close,0,0,0,,00,,
776,Close,46,0,0,,00,,
777,Close,1,0,0,,00,,
778,Close,2,0,0,,00,,
779,Close,5,0,0,,00,,
780,Close,4,0,0,,00,,
781,Close,47,0,0,,00,,
782,Sort,44,858,0,,00,,
783,Column,44,0,371,,00,,
784,Column,44,1,372,,00,,
785,Column,44,2,373,,00,,
786,Column,44,3,374,,00,,
787,Column,44,4,375,,00,,
788,Column,44,5,376,,00,,
789,Column,44,6,377,,00,,
790,Column,44,7,378,,00,,
791,Column,44,8,379,,00,,
792,Column,44,9,380,,00,,
793,Column,44,10,381,,00,,
794,Column,44,11,382,,00,,
795,Compare,359,371,12,"keyinfo(12,NOCASE,NOCASE)",00,,
796,Jump,797,801,797,,00,,
797,Move,371,359,12,,00,,
798,Gosub,357,821,0,,00,,
799,IfPos,356,858,0,,00,,
800,Gosub,358,844,0,,00,,
801,Integer,1,387,0,,00,,
802,AggStep,0,387,354,count(1),01,,
803,Column,44,0,342,,00,,
804,Column,44,1,343,,00,,
805,Column,44,2,344,,00,,
806,Column,44,3,345,,00,,
807,Column,44,4,346,,00,,
808,Column,44,5,347,,00,,
809,Column,44,6,348,,00,,
810,Column,44,7,349,,00,,
811,Column,44,8,350,,00,,
812,Column,44,9,351,,00,,
813,Column,44,10,352,,00,,
814,Column,44,11,353,,00,,
815,Integer,1,355,0,,00,,
816,Next,44,783,0,,00,,
817,Gosub,357,821,0,,00,,
818,Goto,0,858,0,,00,,
819,Integer,1,356,0,,00,,
820,Return,357,0,0,,00,,
821,IfPos,355,823,0,,00,,
822,Return,357,0,0,,00,,
823,AggFinal,354,1,0,count(1),00,,
824,SCopy,342,400,0,,00,,
825,SCopy,343,401,0,,00,,
826,SCopy,344,402,0,,00,,
827,SCopy,345,403,0,,00,,
828,SCopy,346,404,0,,00,,
829,SCopy,347,405,0,,00,,
830,SCopy,348,406,0,,00,,
831,SCopy,349,407,0,,00,,
832,SCopy,350,408,0,,00,,
833,SCopy,351,409,0,,00,,
834,SCopy,352,410,0,,00,,
835,SCopy,353,411,0,,00,,
836,SCopy,354,412,0,,00,,
837,MakeRecord,400,13,148,,00,,
838,SCopy,344,388,0,,00,,
839,Sequence,43,389,0,,00,,
840,Move,148,390,1,,00,,
841,MakeRecord,388,3,149,,00,,
842,IdxInsert,43,149,0,,00,,
843,Return,357,0,0,,00,,
844,Null,0,342,0,,00,,
845,Null,0,343,0,,00,,
846,Null,0,344,0,,00,,
847,Null,0,345,0,,00,,
848,Null,0,346,0,,00,,
849,Null,0,347,0,,00,,
850,Null,0,348,0,,00,,
851,Null,0,349,0,,00,,
852,Null,0,350,0,,00,,
853,Null,0,351,0,,00,,
854,Null,0,352,0,,00,,
855,Null,0,353,0,,00,,
856,Null,0,354,0,,00,,
857,Return,358,0,0,,00,,
858,OpenPseudo,48,0,13,,00,,
859,Sort,43,878,0,,00,,
860,Column,43,2,148,,00,,
861,Integer,1,149,0,,00,,
862,Insert,48,148,149,,00,,
863,Column,48,0,400,,00,,
864,Column,48,1,401,,00,,
865,Column,48,2,402,,00,,
866,Column,48,3,403,,00,,
867,Column,48,4,404,,00,,
868,Column,48,5,405,,00,,
869,Column,48,6,406,,00,,
870,Column,48,7,407,,00,,
871,Column,48,8,408,,00,,
872,Column,48,9,409,,00,,
873,Column,48,10,410,,00,,
874,Column,48,11,411,,00,,
875,Column,48,12,412,,00,,
876,Yield,3,0,0,,00,,
877,Next,43,860,0,,00,,
878,Close,48,0,0,,00,,
879,Integer,1,4,0,,00,,
880,Yield,3,0,0,,00,,
881,ResultRow,329,13,0,,00,,
882,Return,5,0,0,,00,,
883,ResultRow,400,13,0,,00,,
884,Return,6,0,0,,00,,
885,If,4,910,0,,00,,
886,Gosub,6,883,0,,00,,
887,Yield,3,0,0,,00,,
888,Goto,0,885,0,,00,,
889,If,2,910,0,,00,,
890,Gosub,5,881,0,,00,,
891,Yield,1,0,0,,00,,
892,Goto,0,889,0,,00,,
893,Gosub,5,881,0,,00,,
894,Yield,1,0,0,,00,,
895,If,2,885,0,,00,,
896,Goto,0,907,0,,00,,
897,Gosub,6,883,0,,00,,
898,Yield,3,0,0,,00,,
899,If,4,889,0,,00,,
900,Goto,0,907,0,,00,,
901,Integer,0,2,0,,00,,
902,Integer,0,4,0,,00,,
903,Gosub,1,2,0,,00,,
904,Gosub,3,711,0,,00,,
905,If,2,885,0,,00,,
906,If,4,889,0,,00,,
907,Permutation,0,0,0,intarray,00,,
908,Compare,329,400,1,"keyinfo(1,BINARY)",00,,
909,Jump,893,893,897,,00,,
910,Halt,0,0,0,,00,,
911,Transaction,0,0,0,,00,,
912,VerifyCookie,0,60,0,,00,,
913,TableLock,0,32,0,NameTable,00,,
914,TableLock,0,5,0,FamilyTable,00,,
915,TableLock,0,14,0,EventTable,00,,
916,TableLock,0,20,0,FactTypeTable,00,,
917,TableLock,0,53,0,WitnessTable,00,,
918,TableLock,0,60,0,RoleTable,00,,
919,Goto,0,14,0,,00,,

run under 3.6.22
addr,opcode,p1,p2,p3,p4,p5,comment
0,Trace,0,0,0,,00,,
1,Goto,0,875,0,,00,,
2,Goto,0,678,0,,00,,
3,Goto,0,532,0,,00,,
4,Goto,0,364,0,,00,,
5,OpenEphemeral,20,3,0,"keyinfo(1,BINARY)",00,,
6,OpenEphemeral,21,13,0,"keyinfo(12,NOCASE,BINARY)",00,,
7,Integer,0,38,0,,00,,
8,Integer,0,37,0,,00,,
9,Gosub,40,140,0,,00,,
10,Integer,1,65,0,,00,,
11,Integer,1,66,0,,00,,
12,Integer,1,67,0,,00,,
13,Goto,0,885,0,,00,,
14,OpenRead,18,32,0,11,00,,
15,OpenRead,22,38,0,"keyinfo(1,BINARY)",00,,
16,OpenRead,19,32,0,11,00,,
17,OpenRead,23,38,0,"keyinfo(1,BINARY)",00,,
18,OpenRead,17,5,0,3,00,,
19,OpenRead,24,8,0,"keyinfo(1,BINARY)",00,,
20,OpenRead,15,14,0,4,00,,
21,OpenRead,25,17,0,"keyinfo(2,BINARY,BINARY)",00,,
22,OpenRead,16,20,0,3,00,,
23,SeekGe,22,70,66,1,00,,
24,IdxGE,22,70,66,1,01,,
25,IdxRowid,22,68,0,,00,,
26,Seek,18,68,0,,00,,
27,SeekGe,23,69,67,1,00,,
28,IdxGE,23,69,67,1,01,,
29,IdxRowid,23,69,0,,00,,
30,Seek,19,69,0,,00,,
31,Column,19,1,70,,00,,
32,IsNull,70,68,0,,00,,
33,Affinity,70,1,0,d,00,,
34,SeekGe,24,68,70,1,00,,
35,IdxGE,24,68,70,1,01,,
36,IdxRowid,24,71,0,,00,,
37,Seek,17,71,0,,00,,
38,Column,17,1,72,,00,,
39,Column,18,1,73,,00,,
40,Ne,73,67,72,collseq(BINARY),6b,,
41,IsNull,71,67,0,,00,,
42,SeekGe,25,67,71,1,00,,
43,IdxGE,25,67,71,1,01,,
44,IdxRowid,25,74,0,,00,,
45,Seek,15,74,0,,00,,
46,Column,15,2,73,,00,,
47,Ne,65,66,73,collseq(BINARY),6c,,
48,Column,15,1,73,,00,,
49,MustBeInt,73,66,0,,00,,
50,NotExists,16,66,73,,00,,
51,Column,16,2,75,,00,,
52,String8,0,76,0,Principal,00,,
53,Column,18,1,77,,00,,
54,Column,18,2,78,,00,,
55,Column,18,5,79,,00,,
56,Column,18,4,80,,00,,
57,Column,18,3,81,,00,,
58,Column,19,1,82,,00,,
59,Column,19,2,83,,00,,
60,Column,19,5,84,,00,,
61,Column,19,4,85,,00,,
62,Column,19,3,86,,00,,
63,Sequence,21,87,0,,00,,
64,MakeRecord,75,13,73,,00,,
65,IdxInsert,21,73,0,,00,,
66,Next,25,43,0,,00,,
67,Next,24,35,0,,00,,
68,Next,23,28,0,,00,,
69,Next,22,24,0,,00,,
70,Close,18,0,0,,00,,
71,Close,22,0,0,,00,,
72,Close,19,0,0,,00,,
73,Close,23,0,0,,00,,
74,Close,17,0,0,,00,,
75,Close,24,0,0,,00,,
76,Close,15,0,0,,00,,
77,Close,25,0,0,,00,,
78,Close,16,0,0,,00,,
79,Sort,21,153,0,,00,,
80,Column,21,0,53,,00,,
81,Column,21,1,54,,00,,
82,Column,21,2,55,,00,,
83,Column,21,3,56,,00,,
84,Column,21,4,57,,00,,
85,Column,21,5,58,,00,,
86,Column,21,6,59,,00,,
87,Column,21,7,60,,00,,
88,Column,21,8,61,,00,,
89,Column,21,9,62,,00,,
90,Column,21,10,63,,00,,
91,Column,21,11,64,,00,,
92,Compare,41,53,12,"keyinfo(12,NOCASE,BINARY)",00,,
93,Jump,94,98,94,,00,,
94,Move,53,41,12,,00,,
95,Gosub,39,117,0,,00,,
96,IfPos,38,153,0,,00,,
97,Gosub,40,140,0,,00,,
98,Integer,1,75,0,,00,,
99,AggStep,0,75,36,count(1),01,,
100,Column,21,0,25,,00,,
101,Column,21,2,26,,00,,
102,Column,21,3,27,,00,,
103,Column,21,4,28,,00,,
104,Column,21,5,29,,00,,
105,Column,21,6,30,,00,,
106,Column,21,7,31,,00,,
107,Column,21,8,32,,00,,
108,Column,21,9,33,,00,,
109,Column,21,10,34,,00,,
110,Column,21,11,35,,00,,
111,Integer,1,37,0,,00,,
112,Next,21,80,0,,00,,
113,Gosub,39,117,0,,00,,
114,Goto,0,153,0,,00,,
115,Integer,1,38,0,,00,,
116,Return,39,0,0,,00,,
117,IfPos,37,119,0,,00,,
118,Return,39,0,0,,00,,
119,AggFinal,36,1,0,count(1),00,,
120,SCopy,25,88,0,,00,,
121,String8,0,89,0,Principal,00,,
122,SCopy,26,90,0,,00,,
123,SCopy,27,91,0,,00,,
124,SCopy,28,92,0,,00,,
125,SCopy,29,93,0,,00,,
126,SCopy,30,94,0,,00,,
127,SCopy,31,95,0,,00,,
128,SCopy,32,96,0,,00,,
129,SCopy,33,97,0,,00,,
130,SCopy,34,98,0,,00,,
131,SCopy,35,99,0,,00,,
132,SCopy,36,100,0,,00,,
133,MakeRecord,88,13,73,,00,,
134,SCopy,26,76,0,,00,,
135,Sequence,20,77,0,,00,,
136,Move,73,78,1,,00,,
137,MakeRecord,76,3,74,,00,,
138,IdxInsert,20,74,0,,00,,
139,Return,39,0,0,,00,,
140,Null,0,25,0,,00,,
141,Null,0,26,0,,00,,
142,Null,0,27,0,,00,,
143,Null,0,28,0,,00,,
144,Null,0,29,0,,00,,
145,Null,0,30,0,,00,,
146,Null,0,31,0,,00,,
147,Null,0,32,0,,00,,
148,Null,0,33,0,,00,,
149,Null,0,34,0,,00,,
150,Null,0,35,0,,00,,
151,Null,0,36,0,,00,,
152,Return,40,0,0,,00,,
153,OpenPseudo,26,73,13,,00,,
154,Sort,20,171,0,,00,,
155,Column,20,2,73,,00,,
156,Column,26,0,88,,20,,
157,Column,26,1,89,,00,,
158,Column,26,2,90,,00,,
159,Column,26,3,91,,00,,
160,Column,26,4,92,,00,,
161,Column,26,5,93,,00,,
162,Column,26,6,94,,00,,
163,Column,26,7,95,,00,,
164,Column,26,8,96,,00,,
165,Column,26,9,97,,00,,
166,Column,26,10,98,,00,,
167,Column,26,11,99,,00,,
168,Column,26,12,100,,00,,
169,Yield,19,0,0,,00,,
170,Next,20,155,0,,00,,
171,Close,26,0,0,,00,,
172,Integer,1,20,0,,00,,
173,Yield,19,0,0,,00,,
174,OpenEphemeral,27,3,0,"keyinfo(1,BINARY)",00,,
175,OpenEphemeral,28,13,0,"keyinfo(12,NOCASE,BINARY)",00,,
176,Integer,0,114,0,,00,,
177,Integer,0,113,0,,00,,
178,Gosub,116,308,0,,00,,
179,Integer,1,141,0,,00,,
180,Integer,1,142,0,,00,,
181,Integer,1,143,0,,00,,
182,OpenRead,13,32,0,11,00,,
183,OpenRead,29,38,0,"keyinfo(1,BINARY)",00,,
184,OpenRead,14,32,0,11,00,,
185,OpenRead,30,38,0,"keyinfo(1,BINARY)",00,,
186,OpenRead,12,5,0,3,00,,
187,OpenRead,31,8,0,"keyinfo(1,BINARY)",00,,
188,OpenRead,10,14,0,4,00,,
189,OpenRead,32,17,0,"keyinfo(2,BINARY,BINARY)",00,,
190,OpenRead,11,20,0,3,00,,
191,SeekGe,29,238,142,1,00,,
192,IdxGE,29,238,142,1,01,,
193,IdxRowid,29,144,0,,00,,
194,Seek,13,144,0,,00,,
195,SeekGe,30,237,143,1,00,,
196,IdxGE,30,237,143,1,01,,
197,IdxRowid,30,145,0,,00,,
198,Seek,14,145,0,,00,,
199,Column,14,1,146,,00,,
200,IsNull,146,236,0,,00,,
201,Affinity,146,1,0,d,00,,
202,SeekGe,31,236,146,1,00,,
203,IdxGE,31,236,146,1,01,,
204,IdxRowid,31,73,0,,00,,
205,Seek,12,73,0,,00,,
206,Column,12,1,74,,00,,
207,Column,13,1,69,,00,,
208,Ne,69,235,74,collseq(BINARY),6b,,
209,IsNull,73,235,0,,00,,
210,SeekGe,32,235,73,1,00,,
211,IdxGE,32,235,73,1,01,,
212,IdxRowid,32,147,0,,00,,
213,Seek,10,147,0,,00,,
214,Column,10,2,69,,00,,
215,Ne,141,234,69,collseq(BINARY),6c,,
216,Column,10,1,69,,00,,
217,MustBeInt,69,234,0,,00,,
218,NotExists,11,234,69,,00,,
219,Column,11,2,148,,00,,
220,String8,0,149,0,Principal,00,,
221,Column,14,1,150,,00,,
222,Column,14,2,151,,00,,
223,Column,14,5,152,,00,,
224,Column,14,4,153,,00,,
225,Column,14,3,154,,00,,
226,Column,13,1,155,,00,,
227,Column,13,2,156,,00,,
228,Column,13,5,157,,00,,
229,Column,13,4,158,,00,,
230,Column,13,3,159,,00,,
231,Sequence,28,160,0,,00,,
232,MakeRecord,148,13,69,,00,,
233,IdxInsert,28,69,0,,00,,
234,Next,32,211,0,,00,,
235,Next,31,203,0,,00,,
236,Next,30,196,0,,00,,
237,Next,29,192,0,,00,,
238,Close,13,0,0,,00,,
239,Close,29,0,0,,00,,
240,Close,14,0,0,,00,,
241,Close,30,0,0,,00,,
242,Close,12,0,0,,00,,
243,Close,31,0,0,,00,,
244,Close,10,0,0,,00,,
245,Close,32,0,0,,00,,
246,Close,11,0,0,,00,,
247,Sort,28,321,0,,00,,
248,Column,28,0,129,,00,,
249,Column,28,1,130,,00,,
250,Column,28,2,131,,00,,
251,Column,28,3,132,,00,,
252,Column,28,4,133,,00,,
253,Column,28,5,134,,00,,
254,Column,28,6,135,,00,,
255,Column,28,7,136,,00,,
256,Column,28,8,137,,00,,
257,Column,28,9,138,,00,,
258,Column,28,10,139,,00,,
259,Column,28,11,140,,00,,
260,Compare,117,129,12,"keyinfo(12,NOCASE,BINARY)",00,,
261,Jump,262,266,262,,00,,
262,Move,129,117,12,,00,,
263,Gosub,115,285,0,,00,,
264,IfPos,114,321,0,,00,,
265,Gosub,116,308,0,,00,,
266,Integer,1,148,0,,00,,
267,AggStep,0,148,112,count(1),01,,
268,Column,28,0,101,,00,,
269,Column,28,2,102,,00,,
270,Column,28,3,103,,00,,
271,Column,28,4,104,,00,,
272,Column,28,5,105,,00,,
273,Column,28,6,106,,00,,
274,Column,28,7,107,,00,,
275,Column,28,8,108,,00,,
276,Column,28,9,109,,00,,
277,Column,28,10,110,,00,,
278,Column,28,11,111,,00,,
279,Integer,1,113,0,,00,,
280,Next,28,248,0,,00,,
281,Gosub,115,285,0,,00,,
282,Goto,0,321,0,,00,,
283,Integer,1,114,0,,00,,
284,Return,115,0,0,,00,,
285,IfPos,113,287,0,,00,,
286,Return,115,0,0,,00,,
287,AggFinal,112,1,0,count(1),00,,
288,SCopy,101,161,0,,00,,
289,String8,0,162,0,Principal,00,,
290,SCopy,102,163,0,,00,,
291,SCopy,103,164,0,,00,,
292,SCopy,104,165,0,,00,,
293,SCopy,105,166,0,,00,,
294,SCopy,106,167,0,,00,,
295,SCopy,107,168,0,,00,,
296,SCopy,108,169,0,,00,,
297,SCopy,109,170,0,,00,,
298,SCopy,110,171,0,,00,,
299,SCopy,111,172,0,,00,,
300,SCopy,112,173,0,,00,,
301,MakeRecord,161,13,69,,00,,
302,SCopy,102,149,0,,00,,
303,Sequence,27,150,0,,00,,
304,Move,69,151,1,,00,,
305,MakeRecord,149,3,147,,00,,
306,IdxInsert,27,147,0,,00,,
307,Return,115,0,0,,00,,
308,Null,0,101,0,,00,,
309,Null,0,102,0,,00,,
310,Null,0,103,0,,00,,
311,Null,0,104,0,,00,,
312,Null,0,105,0,,00,,
313,Null,0,106,0,,00,,
314,Null,0,107,0,,00,,
315,Null,0,108,0,,00,,
316,Null,0,109,0,,00,,
317,Null,0,110,0,,00,,
318,Null,0,111,0,,00,,
319,Null,0,112,0,,00,,
320,Return,116,0,0,,00,,
321,OpenPseudo,33,69,13,,00,,
322,Sort,27,339,0,,00,,
323,Column,27,2,69,,00,,
324,Column,33,0,161,,20,,
325,Column,33,1,162,,00,,
326,Column,33,2,163,,00,,
327,Column,33,3,164,,00,,
328,Column,33,4,165,,00,,
329,Column,33,5,166,,00,,
330,Column,33,6,167,,00,,
331,Column,33,7,168,,00,,
332,Column,33,8,169,,00,,
333,Column,33,9,170,,00,,
334,Column,33,10,171,,00,,
335,Column,33,11,172,,00,,
336,Column,33,12,173,,00,,
337,Yield,21,0,0,,00,,
338,Next,27,323,0,,00,,
339,Close,33,0,0,,00,,
340,Integer,1,22,0,,00,,
341,Yield,21,0,0,,00,,
342,Move,88,174,13,,00,,
343,Yield,13,0,0,,00,,
344,Return,23,0,0,,00,,
345,Move,161,174,13,,00,,
346,Yield,13,0,0,,00,,
347,Return,24,0,0,,00,,
348,If,22,373,0,,00,,
349,Gosub,24,345,0,,00,,
350,Yield,21,0,0,,00,,
351,Goto,0,348,0,,00,,
352,If,20,373,0,,00,,
353,Gosub,23,342,0,,00,,
354,Yield,19,0,0,,00,,
355,Goto,0,352,0,,00,,
356,Gosub,23,342,0,,00,,
357,Yield,19,0,0,,00,,
358,If,20,348,0,,00,,
359,Goto,0,370,0,,00,,
360,Gosub,24,345,0,,00,,
361,Yield,21,0,0,,00,,
362,If,22,352,0,,00,,
363,Goto,0,370,0,,00,,
364,Integer,0,20,0,,00,,
365,Integer,0,22,0,,00,,
366,Gosub,19,5,0,,00,,
367,Gosub,21,174,0,,00,,
368,If,20,348,0,,00,,
369,If,22,352,0,,00,,
370,Permutation,0,0,0,intarray,00,,
371,Compare,88,161,1,"keyinfo(1,BINARY)",00,,
372,Jump,356,356,360,,00,,
373,Integer,1,14,0,,00,,
374,Yield,13,0,0,,00,,
375,OpenEphemeral,34,3,0,"keyinfo(1,BINARY)",00,,
376,OpenEphemeral,35,13,0,"keyinfo(12,NOCASE,BINARY)",00,,
377,Integer,0,195,0,,00,,
378,Integer,0,194,0,,00,,
379,Gosub,197,481,0,,00,,
380,Integer,0,222,0,,00,,
381,Integer,1,223,0,,00,,
382,OpenRead,9,32,0,11,00,,
383,OpenRead,36,38,0,"keyinfo(1,BINARY)",00,,
384,OpenRead,7,14,0,4,00,,
385,OpenRead,37,17,0,"keyinfo(2,BINARY,BINARY)",00,,
386,OpenRead,8,20,0,3,00,,
387,SeekGe,36,420,223,1,00,,
388,IdxGE,36,420,223,1,01,,
389,IdxRowid,36,224,0,,00,,
390,Seek,9,224,0,,00,,
391,Column,9,1,225,,00,,
392,IsNull,225,419,0,,00,,
393,Affinity,225,1,0,d,00,,
394,SeekGe,37,419,225,1,00,,
395,IdxGE,37,419,225,1,01,,
396,IdxRowid,37,69,0,,00,,
397,Seek,7,69,0,,00,,
398,Column,7,2,147,,00,,
399,Ne,222,418,147,collseq(BINARY),6c,,
400,Column,7,1,147,,00,,
401,MustBeInt,147,418,0,,00,,
402,NotExists,8,418,147,,00,,
403,Column,8,2,226,,00,,
404,String8,0,227,0,Principal,00,,
405,Column,9,1,228,,00,,
406,Column,9,2,229,,00,,
407,Column,9,5,230,,00,,
408,Column,9,4,231,,00,,
409,Column,9,3,232,,00,,
410,Null,0,233,0,,00,,
411,Null,0,234,0,,00,,
412,Null,0,235,0,,00,,
413,Null,0,236,0,,00,,
414,Null,0,237,0,,00,,
415,Sequence,35,238,0,,00,,
416,MakeRecord,226,13,147,,00,,
417,IdxInsert,35,147,0,,00,,
418,Next,37,395,0,,00,,
419,Next,36,388,0,,00,,
420,Close,9,0,0,,00,,
421,Close,36,0,0,,00,,
422,Close,7,0,0,,00,,
423,Close,37,0,0,,00,,
424,Close,8,0,0,,00,,
425,Sort,35,489,0,,00,,
426,Column,35,0,210,,00,,
427,Column,35,1,211,,00,,
428,Column,35,2,212,,00,,
429,Column,35,3,213,,00,,
430,Column,35,4,214,,00,,
431,Column,35,5,215,,00,,
432,Column,35,6,216,,00,,
433,Column,35,7,217,,00,,
434,Column,35,8,218,,00,,
435,Column,35,9,219,,00,,
436,Column,35,10,220,,00,,
437,Column,35,11,221,,00,,
438,Compare,198,210,12,"keyinfo(12,NOCASE,BINARY)",00,,
439,Jump,440,444,440,,00,,
440,Move,210,198,12,,00,,
441,Gosub,196,458,0,,00,,
442,IfPos,195,489,0,,00,,
443,Gosub,197,481,0,,00,,
444,Integer,1,226,0,,00,,
445,AggStep,0,226,193,count(1),01,,
446,Column,35,0,187,,00,,
447,Column,35,2,188,,00,,
448,Column,35,3,189,,00,,
449,Column,35,4,190,,00,,
450,Column,35,5,191,,00,,
451,Column,35,6,192,,00,,
452,Integer,1,194,0,,00,,
453,Next,35,426,0,,00,,
454,Gosub,196,458,0,,00,,
455,Goto,0,489,0,,00,,
456,Integer,1,195,0,,00,,
457,Return,196,0,0,,00,,
458,IfPos,194,460,0,,00,,
459,Return,196,0,0,,00,,
460,AggFinal,193,1,0,count(1),00,,
461,SCopy,187,239,0,,00,,
462,String8,0,240,0,Principal,00,,
463,SCopy,188,241,0,,00,,
464,SCopy,189,242,0,,00,,
465,SCopy,190,243,0,,00,,
466,SCopy,191,244,0,,00,,
467,SCopy,192,245,0,,00,,
468,Null,0,246,0,,00,,
469,Null,0,247,0,,00,,
470,Null,0,248,0,,00,,
471,Null,0,249,0,,00,,
472,Null,0,250,0,,00,,
473,SCopy,193,251,0,,00,,
474,MakeRecord,239,13,147,,00,,
475,SCopy,188,227,0,,00,,
476,Sequence,34,228,0,,00,,
477,Move,147,229,1,,00,,
478,MakeRecord,227,3,69,,00,,
479,IdxInsert,34,69,0,,00,,
480,Return,196,0,0,,00,,
481,Null,0,187,0,,00,,
482,Null,0,188,0,,00,,
483,Null,0,189,0,,00,,
484,Null,0,190,0,,00,,
485,Null,0,191,0,,00,,
486,Null,0,192,0,,00,,
487,Null,0,193,0,,00,,
488,Return,197,0,0,,00,,
489,OpenPseudo,38,147,13,,00,,
490,Sort,34,507,0,,00,,
491,Column,34,2,147,,00,,
492,Column,38,0,239,,20,,
493,Column,38,1,240,,00,,
494,Column,38,2,241,,00,,
495,Column,38,3,242,,00,,
496,Column,38,4,243,,00,,
497,Column,38,5,244,,00,,
498,Column,38,6,245,,00,,
499,Column,38,7,246,,00,,
500,Column,38,8,247,,00,,
501,Column,38,9,248,,00,,
502,Column,38,10,249,,00,,
503,Column,38,11,250,,00,,
504,Column,38,12,251,,00,,
505,Yield,15,0,0,,00,,
506,Next,34,491,0,,00,,
507,Close,38,0,0,,00,,
508,Integer,1,16,0,,00,,
509,Yield,15,0,0,,00,,
510,Move,174,252,13,,00,,
511,Yield,7,0,0,,00,,
512,Return,17,0,0,,00,,
513,Move,239,252,13,,00,,
514,Yield,7,0,0,,00,,
515,Return,18,0,0,,00,,
516,If,16,541,0,,00,,
517,Gosub,18,513,0,,00,,
518,Yield,15,0,0,,00,,
519,Goto,0,516,0,,00,,
520,If,14,541,0,,00,,
521,Gosub,17,510,0,,00,,
522,Yield,13,0,0,,00,,
523,Goto,0,520,0,,00,,
524,Gosub,17,510,0,,00,,
525,Yield,13,0,0,,00,,
526,If,14,516,0,,00,,
527,Goto,0,538,0,,00,,
528,Gosub,18,513,0,,00,,
529,Yield,15,0,0,,00,,
530,If,16,520,0,,00,,
531,Goto,0,538,0,,00,,
532,Integer,0,14,0,,00,,
533,Integer,0,16,0,,00,,
534,Gosub,13,4,0,,00,,
535,Gosub,15,375,0,,00,,
536,If,14,516,0,,00,,
537,If,16,520,0,,00,,
538,Permutation,0,0,0,intarray,00,,
539,Compare,174,239,1,"keyinfo(1,BINARY)",00,,
540,Jump,524,524,528,,00,,
541,Integer,1,8,0,,00,,
542,Yield,7,0,0,,00,,
543,OpenEphemeral,39,3,0,"keyinfo(1,BINARY)",00,,
544,OpenEphemeral,40,13,0,"keyinfo(12,BINARY,BINARY)",00,,
545,Integer,0,272,0,,00,,
546,Integer,0,271,0,,00,,
547,Gosub,274,628,0,,00,,
548,Integer,0,299,0,,00,,
549,OpenRead,6,32,0,11,00,,
550,OpenRead,41,38,0,"keyinfo(1,BINARY)",00,,
551,SeekGe,41,571,299,1,00,,
552,IdxGE,41,571,299,1,01,,
553,IdxRowid,41,147,0,,00,,
554,Seek,6,147,0,,00,,
555,String8,0,301,0,Alternate name,00,,
556,String8,0,302,0,Principal,00,,
557,Column,6,1,303,,00,,
558,Column,6,2,304,,00,,
559,Column,6,5,305,,00,,
560,Column,6,4,306,,00,,
561,Column,6,3,307,,00,,
562,Null,0,308,0,,00,,
563,Null,0,309,0,,00,,
564,Null,0,310,0,,00,,
565,Null,0,311,0,,00,,
566,Null,0,312,0,,00,,
567,Sequence,40,313,0,,00,,
568,MakeRecord,301,13,147,,00,,
569,IdxInsert,40,147,0,,00,,
570,Next,41,552,0,,00,,
571,Close,6,0,0,,00,,
572,Close,41,0,0,,00,,
573,Sort,40,635,0,,00,,
574,Column,40,0,287,,00,,
575,Column,40,1,288,,00,,
576,Column,40,2,289,,00,,
577,Column,40,3,290,,00,,
578,Column,40,4,291,,00,,
579,Column,40,5,292,,00,,
580,Column,40,6,293,,00,,
581,Column,40,7,294,,00,,
582,Column,40,8,295,,00,,
583,Column,40,9,296,,00,,
584,Column,40,10,297,,00,,
585,Column,40,11,298,,00,,
586,Compare,275,287,12,"keyinfo(12,BINARY,BINARY)",00,,
587,Jump,588,592,588,,00,,
588,Move,287,275,12,,00,,
589,Gosub,273,605,0,,00,,
590,IfPos,272,635,0,,00,,
591,Gosub,274,628,0,,00,,
592,Integer,1,301,0,,00,,
593,AggStep,0,301,270,count(1),01,,
594,Column,40,2,265,,00,,
595,Column,40,3,266,,00,,
596,Column,40,4,267,,00,,
597,Column,40,5,268,,00,,
598,Column,40,6,269,,00,,
599,Integer,1,271,0,,00,,
600,Next,40,574,0,,00,,
601,Gosub,273,605,0,,00,,
602,Goto,0,635,0,,00,,
603,Integer,1,272,0,,00,,
604,Return,273,0,0,,00,,
605,IfPos,271,607,0,,00,,
606,Return,273,0,0,,00,,
607,AggFinal,270,1,0,count(1),00,,
608,String8,0,314,0,Alternate name,00,,
609,String8,0,315,0,Principal,00,,
610,SCopy,265,316,0,,00,,
611,SCopy,266,317,0,,00,,
612,SCopy,267,318,0,,00,,
613,SCopy,268,319,0,,00,,
614,SCopy,269,320,0,,00,,
615,Null,0,321,0,,00,,
616,Null,0,322,0,,00,,
617,Null,0,323,0,,00,,
618,Null,0,324,0,,00,,
619,Null,0,325,0,,00,,
620,SCopy,270,326,0,,00,,
621,MakeRecord,314,13,147,,00,,
622,SCopy,265,302,0,,00,,
623,Sequence,39,303,0,,00,,
624,Move,147,304,1,,00,,
625,MakeRecord,302,3,69,,00,,
626,IdxInsert,39,69,0,,00,,
627,Return,273,0,0,,00,,
628,Null,0,265,0,,00,,
629,Null,0,266,0,,00,,
630,Null,0,267,0,,00,,
631,Null,0,268,0,,00,,
632,Null,0,269,0,,00,,
633,Null,0,270,0,,00,,
634,Return,274,0,0,,00,,
635,OpenPseudo,42,147,13,,00,,
636,Sort,39,653,0,,00,,
637,Column,39,2,147,,00,,
638,Column,42,0,314,,20,,
639,Column,42,1,315,,00,,
640,Column,42,2,316,,00,,
641,Column,42,3,317,,00,,
642,Column,42,4,318,,00,,
643,Column,42,5,319,,00,,
644,Column,42,6,320,,00,,
645,Column,42,7,321,,00,,
646,Column,42,8,322,,00,,
647,Column,42,9,323,,00,,
648,Column,42,10,324,,00,,
649,Column,42,11,325,,00,,
650,Column,42,12,326,,00,,
651,Yield,9,0,0,,00,,
652,Next,39,637,0,,00,,
653,Close,42,0,0,,00,,
654,Integer,1,10,0,,00,,
655,Yield,9,0,0,,00,,
656,Move,252,327,13,,00,,
657,Yield,1,0,0,,00,,
658,Return,11,0,0,,00,,
659,Move,314,327,13,,00,,
660,Yield,1,0,0,,00,,
661,Return,12,0,0,,00,,
662,If,10,687,0,,00,,
663,Gosub,12,659,0,,00,,
664,Yield,9,0,0,,00,,
665,Goto,0,662,0,,00,,
666,If,8,687,0,,00,,
667,Gosub,11,656,0,,00,,
668,Yield,7,0,0,,00,,
669,Goto,0,666,0,,00,,
670,Gosub,11,656,0,,00,,
671,Yield,7,0,0,,00,,
672,If,8,662,0,,00,,
673,Goto,0,684,0,,00,,
674,Gosub,12,659,0,,00,,
675,Yield,9,0,0,,00,,
676,If,10,666,0,,00,,
677,Goto,0,684,0,,00,,
678,Integer,0,8,0,,00,,
679,Integer,0,10,0,,00,,
680,Gosub,7,3,0,,00,,
681,Gosub,9,543,0,,00,,
682,If,8,662,0,,00,,
683,If,10,666,0,,00,,
684,Permutation,0,0,0,intarray,00,,
685,Compare,252,314,1,"keyinfo(1,BINARY)",00,,
686,Jump,670,670,674,,00,,
687,Integer,1,2,0,,00,,
688,Yield,1,0,0,,00,,
689,OpenEphemeral,43,3,0,"keyinfo(1,BINARY)",00,,
690,OpenEphemeral,44,13,0,"keyinfo(12,NOCASE,NOCASE)",00,,
691,Integer,0,354,0,,00,,
692,Integer,0,353,0,,00,,
693,Gosub,356,820,0,,00,,
694,Integer,1,381,0,,00,,
695,OpenRead,3,32,0,11,00,,
696,OpenRead,45,38,0,"keyinfo(1,BINARY)",00,,
697,OpenRead,0,53,0,5,00,,
698,OpenRead,46,56,0,"keyinfo(1,BINARY)",00,,
699,OpenRead,1,60,0,2,00,,
700,OpenRead,2,14,0,4,00,,
701,OpenRead,5,20,0,3,00,,
702,OpenRead,4,32,0,6,00,,
703,OpenRead,47,34,0,"keyinfo(1,BINARY)",00,,
704,SeekGe,45,749,381,1,00,,
705,IdxGE,45,749,381,1,01,,
706,IdxRowid,45,147,0,,00,,
707,Seek,3,147,0,,00,,
708,Column,3,1,383,,00,,
709,IsNull,383,748,0,,00,,
710,Affinity,383,1,0,d,00,,
711,SeekGe,46,748,383,1,00,,
712,IdxGE,46,748,383,1,01,,
713,IdxRowid,46,69,0,,00,,
714,Seek,0,69,0,,00,,
715,Column,0,4,224,,00,,
716,MustBeInt,224,747,0,,00,,
717,NotExists,1,747,224,,00,,
718,Column,0,1,145,,00,,
719,MustBeInt,145,747,0,,00,,
720,NotExists,2,747,145,,00,,
721,Column,2,1,144,,00,,
722,MustBeInt,144,747,0,,00,,
723,NotExists,5,747,144,,00,,
724,Column,2,3,384,,00,,
725,IsNull,384,747,0,,00,,
726,Affinity,384,1,0,d,00,,
727,SeekGe,47,747,384,1,00,,
728,IdxGE,47,747,384,1,01,,
729,IdxRowid,47,74,0,,00,,
730,Seek,4,74,0,,00,,
731,Column,5,2,385,,00,,
732,Column,1,1,386,,00,,
733,Column,3,1,387,,00,,
734,Column,3,2,388,,00,,
735,Column,3,5,389,,00,,
736,Column,3,4,390,,00,,
737,Column,3,3,391,,00,,
738,Column,2,3,392,,00,,
739,Column,4,2,393,,00,,
740,Column,4,5,394,,00,,
741,Column,4,4,395,,00,,
742,Column,4,3,396,,00,,
743,Sequence,44,397,0,,00,,
744,MakeRecord,385,13,74,,00,,
745,IdxInsert,44,74,0,,00,,
746,Next,47,728,0,,00,,
747,Next,46,712,0,,00,,
748,Next,45,705,0,,00,,
749,Close,3,0,0,,00,,
750,Close,45,0,0,,00,,
751,Close,0,0,0,,00,,
752,Close,46,0,0,,00,,
753,Close,1,0,0,,00,,
754,Close,2,0,0,,00,,
755,Close,5,0,0,,00,,
756,Close,4,0,0,,00,,
757,Close,47,0,0,,00,,
758,Sort,44,834,0,,00,,
759,Column,44,0,369,,00,,
760,Column,44,1,370,,00,,
761,Column,44,2,371,,00,,
762,Column,44,3,372,,00,,
763,Column,44,4,373,,00,,
764,Column,44,5,374,,00,,
765,Column,44,6,375,,00,,
766,Column,44,7,376,,00,,
767,Column,44,8,377,,00,,
768,Column,44,9,378,,00,,
769,Column,44,10,379,,00,,
770,Column,44,11,380,,00,,
771,Compare,357,369,12,"keyinfo(12,NOCASE,NOCASE)",00,,
772,Jump,773,777,773,,00,,
773,Move,369,357,12,,00,,
774,Gosub,355,797,0,,00,,
775,IfPos,354,834,0,,00,,
776,Gosub,356,820,0,,00,,
777,Integer,1,385,0,,00,,
778,AggStep,0,385,352,count(1),01,,
779,Column,44,0,340,,00,,
780,Column,44,1,341,,00,,
781,Column,44,2,342,,00,,
782,Column,44,3,343,,00,,
783,Column,44,4,344,,00,,
784,Column,44,5,345,,00,,
785,Column,44,6,346,,00,,
786,Column,44,7,347,,00,,
787,Column,44,8,348,,00,,
788,Column,44,9,349,,00,,
789,Column,44,10,350,,00,,
790,Column,44,11,351,,00,,
791,Integer,1,353,0,,00,,
792,Next,44,759,0,,00,,
793,Gosub,355,797,0,,00,,
794,Goto,0,834,0,,00,,
795,Integer,1,354,0,,00,,
796,Return,355,0,0,,00,,
797,IfPos,353,799,0,,00,,
798,Return,355,0,0,,00,,
799,AggFinal,352,1,0,count(1),00,,
800,SCopy,340,398,0,,00,,
801,SCopy,341,399,0,,00,,
802,SCopy,342,400,0,,00,,
803,SCopy,343,401,0,,00,,
804,SCopy,344,402,0,,00,,
805,SCopy,345,403,0,,00,,
806,SCopy,346,404,0,,00,,
807,SCopy,347,405,0,,00,,
808,SCopy,348,406,0,,00,,
809,SCopy,349,407,0,,00,,
810,SCopy,350,408,0,,00,,
811,SCopy,351,409,0,,00,,
812,SCopy,352,410,0,,00,,
813,MakeRecord,398,13,74,,00,,
814,SCopy,342,386,0,,00,,
815,Sequence,43,387,0,,00,,
816,Move,74,388,1,,00,,
817,MakeRecord,386,3,144,,00,,
818,IdxInsert,43,144,0,,00,,
819,Return,355,0,0,,00,,
820,Null,0,340,0,,00,,
821,Null,0,341,0,,00,,
822,Null,0,342,0,,00,,
823,Null,0,343,0,,00,,
824,Null,0,344,0,,00,,
825,Null,0,345,0,,00,,
826,Null,0,346,0,,00,,
827,Null,0,347,0,,00,,
828,Null,0,348,0,,00,,
829,Null,0,349,0,,00,,
830,Null,0,350,0,,00,,
831,Null,0,351,0,,00,,
832,Null,0,352,0,,00,,
833,Return,356,0,0,,00,,
834,OpenPseudo,48,74,13,,00,,
835,Sort,43,852,0,,00,,
836,Column,43,2,74,,00,,
837,Column,48,0,398,,20,,
838,Column,48,1,399,,00,,
839,Column,48,2,400,,00,,
840,Column,48,3,401,,00,,
841,Column,48,4,402,,00,,
842,Column,48,5,403,,00,,
843,Column,48,6,404,,00,,
844,Column,48,7,405,,00,,
845,Column,48,8,406,,00,,
846,Column,48,9,407,,00,,
847,Column,48,10,408,,00,,
848,Column,48,11,409,,00,,
849,Column,48,12,410,,00,,
850,Yield,3,0,0,,00,,
851,Next,43,836,0,,00,,
852,Close,48,0,0,,00,,
853,Integer,1,4,0,,00,,
854,Yield,3,0,0,,00,,
855,ResultRow,327,13,0,,00,,
856,Return,5,0,0,,00,,
857,ResultRow,398,13,0,,00,,
858,Return,6,0,0,,00,,
859,If,4,884,0,,00,,
860,Gosub,6,857,0,,00,,
861,Yield,3,0,0,,00,,
862,Goto,0,859,0,,00,,
863,If,2,884,0,,00,,
864,Gosub,5,855,0,,00,,
865,Yield,1,0,0,,00,,
866,Goto,0,863,0,,00,,
867,Gosub,5,855,0,,00,,
868,Yield,1,0,0,,00,,
869,If,2,859,0,,00,,
870,Goto,0,881,0,,00,,
871,Gosub,6,857,0,,00,,
872,Yield,3,0,0,,00,,
873,If,4,863,0,,00,,
874,Goto,0,881,0,,00,,
875,Integer,0,2,0,,00,,
876,Integer,0,4,0,,00,,
877,Gosub,1,2,0,,00,,
878,Gosub,3,689,0,,00,,
879,If,2,859,0,,00,,
880,If,4,863,0,,00,,
881,Permutation,0,0,0,intarray,00,,
882,Compare,327,398,1,"keyinfo(1,BINARY)",00,,
883,Jump,867,867,871,,00,,
884,Halt,0,0,0,,00,,
885,Transaction,0,0,0,,00,,
886,VerifyCookie,0,60,0,,00,,
887,TableLock,0,32,0,NameTable,00,,
888,TableLock,0,5,0,FamilyTable,00,,
889,TableLock,0,14,0,EventTable,00,,
890,TableLock,0,20,0,FactTypeTable,00,,
891,TableLock,0,53,0,WitnessTable,00,,
892,TableLock,0,60,0,RoleTable,00,,
893,Goto,0,14,0,,00,,


If  you need the sample database, please tell me where to upload it (4M)

best regards
chinshou
*
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users