fixtures

Test tables description

Custom SQL query returning 71 rows (hide)

Parameters

This data as json, testall, testnone, testresponse, CSV

addropcodep1p2p3p4p5comment
0 Init 0 69 0   0  
1 OpenEphemeral 2 13 0 k(1,B) 0  
2 Integer 101 1 0   0  
3 OpenRead 0 40 0 11 0  
4 Integer 16 3 0   0  
5 Once 0 16 0   0  
6 OpenEphemeral 3 1 0 k(1,) 0  
7 Variable 1 4 0 :p0 0  
8 MakeRecord 4 1 5 D 0  
9 IdxInsert 3 5 4 1 0  
10 Variable 2 4 0 :p1 0  
11 MakeRecord 4 1 5 D 0  
12 IdxInsert 3 5 4 1 0  
13 Variable 3 4 0 :p2 0  
14 MakeRecord 4 1 5 D 0  
15 IdxInsert 3 5 4 1 0  
16 Return 3 0 0   0  
17 Rewind 3 54 0   0  
18 Column 3 0 2   0  
19 IsNull 2 53 0   0  
20 SeekRowid 0 53 2   0  
21 OpenEphemeral 4 1 0 k(1,B) 0  
22 VOpen 1 0 0 vtab:7FEFE809B4D8 0  
23 Column 0 7 8   0  
24 Integer 1 6 0   0  
25 Integer 1 7 0   0  
26 VFilter 1 31 6   0  
27 VColumn 1 1 9   0  
28 MakeRecord 9 1 10 A 0  
29 IdxInsert 4 10 9 1 0  
30 VNext 1 27 0   0  
31 Variable 4 10 0 :p3 0  
32 IsNull 10 53 0   0  
33 Affinity 10 1 0 A 0  
34 NotFound 4 53 10 1 0  
35 Column 0 4 11   0  
36 Sequence 2 12 0   0  
37 IfNotZero 1 41 0   0  
38 Last 2 0 0   0  
39 IdxLE 2 53 11 1 0  
40 Delete 2 0 0   0  
41 Rowid 0 13 0   0  
42 Column 0 1 14   0  
43 Column 0 2 15   0  
44 Column 0 3 16   0  
45 Column 0 5 17   0  
46 Column 0 6 18   0  
47 Column 0 7 19   0  
48 Column 0 8 20   0  
49 Column 0 9 21   0  
50 Column 0 10 22   0  
51 MakeRecord 11 12 24   0  
52 IdxInsert 2 24 11 12 0  
53 Next 3 18 0   0  
54 Sort 2 68 0   0  
55 Column 2 11 23   0  
56 Column 2 10 22   0  
57 Column 2 9 21   0  
58 Column 2 8 20   0  
59 Column 2 7 19   0  
60 Column 2 6 18   0  
61 Column 2 0 17   0  
62 Column 2 5 16   0  
63 Column 2 4 15   0  
64 Column 2 3 14   0  
65 Column 2 2 13   0  
66 ResultRow 13 11 0   0  
67 Next 2 55 0   0  
68 Halt 0 0 0   0  
69 Transaction 0 0 34 0 1  
70 Goto 0 1 0   0