As usual, I forgot the promised attachments. Here they are.
Jean-Paul
addr opcode p1
p2 p3
---- -------------- ---------- ---------- -------------
--------------------
0 Noop 0
0
1 Integer 2
0
2 MustBeInt 0
0
3 MemStore 0
1
4 IfMemZero 0
38
5 MemLoad 0
0
6 IfMemPos 0
10
7 Pop 1
0
8 MemInt -1
1
9 Goto 0
11
10 MemStore 1
1
11 OpenEphemeral 2 0
keyinfo(2,BINARY,BINARY)
12 Goto 0
39
13 Integer 0
0
14 OpenRead 3
41 keyinfo(1,BINARY)
15 SetNumColumns 3 2
16 Variable 1
0
17 IsNull -1
37
18 MakeRecord 1
0 d
19 MemStore 2
0
20 MoveGe 3
37
21 MemLoad 2
0
22 IdxGE 3
37 +
23 IdxRowid 3
0
24 Variable 2
0
25 Le 356
36
26 IdxRowid 3
0
27 Column 3
0
28 MakeRecord -2 0
29 Distinct 2
32
30 Pop 3
0
31 Goto 0
36
32 IdxInsert 2
0
33 Callback 2
0
34 MemIncr -1
0
35 IfMemZero 0
37
36 Next 3
21
37 Close 3
0
38 Halt 0
0
39 Transaction 0 0
40 VerifyCookie 0 30
41 Goto 0
13
42 Noop 0
0
addr opcode p1 p2 p3
p4 p5 comment
---- ------------- ---- ---- ---- -------------
-- -------------
0 Trace 0 0
0 00
1 OpenEphemeral 1 4 0
keyinfo(2,BINARY,BINARY) 00
2 Integer 2 1
0 00
3 MustBeInt 1 0
0 00
4 IfZero 1 65
0 00
5 Noop 0 0
0 00
6 Integer 0 5
0 00
7 Integer 0 4
0 00
8 Gosub 7 52
0 00
9 Variable 1 12
2 00
10 Goto 0 66
0 00
11 OpenRead 3 41 0
keyinfo(1,BINARY) 00
12 IsNull 12 30
0 00
13 Affinity 12 1 0
db 00
14 SeekGe 3 30
12 1 00
15 IdxGE 3 30
12 1 01
16 IdxRowid 3 14 0
00
17 Le 13 29
14 6c
18 IdxRowid 3 10 0
00
19 Column 3 0
11 00
20 Compare 8 10
2 keyinfo(2,BINARY,BINARY) 00
21 Jump 22 26
22 00
22 Move 10 8
2 00
23 Gosub 6 35
0 00
24 IfPos 5 55
0 00
25 Gosub 7 52
0 00
26 IdxRowid 3 2
0 00
27 Column 3 0
3 00
28 Integer 1 4
0 00
29 Next 3 15
0 00
30 Close 3 0
0 00
31 Gosub 6 35
0 00
32 Goto 0 55
0 00
33 Integer 1 5
0 00
34 Return 6 0
0 00
35 IfPos 4 37
0 00
36 Return 6 0
0 00
37 SCopy 2 16
0 00
38 SCopy 3 17
0 00
39 MakeRecord 16 2 14
00
40 SCopy 3 18
0 00
41 SCopy 2 19
0 00
42 Sequence 1 20 0
00
43 Move 14 21
1 00
44 MakeRecord 18 4 15
00
45 IdxInsert 1 15 0
00
46 IfZero 1 49
0 00
47 AddImm 1 -1
0 00
48 Goto 0 51
0 00
49 Last 1 0
0 00
50 Delete 1 0
0 00
51 Return 6 0
0 00
52 Null 0 2
0 00
53 Null 0 3
0 00
54 Return 7 0
0 00
55 OpenPseudo 4 1 2
00
56 Sort 1 64
0 00
57 Column 1 3
14 00
58 Integer 1 15
0 00
59 Insert 4 14
15 00
60 Column 4 0
16 00
61 Column 4 1
17 00
62 ResultRow 16 2 0
00
63 Next 1 57
0 00
64 Close 4 0
0 00
65 Halt 0 0
0 00
66 Transaction 0 0 0
00
67 VerifyCookie 0 30 0
00
68 TableLock 0 39 0
item_xmantissa_test_test_scrolltable_datathunkwithindex_v1
00
69 Goto 0 11
0 00
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
