fixtures

Test tables description

Custom SQL query returning 58 rows (hide)

Query parameters

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

addropcodep1p2p3p4p5comment
0 Init 0 55 0   0  
1 OpenEphemeral 2 13 0 k(1,-B) 0  
2 Integer 101 1 0   0  
3 OpenRead 0 41 0 11 0  
4 Rewind 0 40 0   0  
5 Column 0 6 2   0  
6 Ne 3 39 2 BINARY-8 82  
7 OpenEphemeral 3 1 0 k(1,B) 0  
8 VOpen 1 0 0 vtab:3ECBB01A8CF8 0  
9 Column 0 7 6   0  
10 Integer 1 4 0   0  
11 Integer 1 5 0   0  
12 VFilter 1 17 4   0  
13 VColumn 1 1 7   0  
14 MakeRecord 7 1 2 A 0  
15 IdxInsert 3 2 7 1 0  
16 VNext 1 13 0   0  
17 Variable 2 2 0 :p1 0  
18 IsNull 2 39 0   0  
19 Affinity 2 1 0 A 0  
20 NotFound 3 39 2 1 0  
21 Column 0 8 8   0  
22 Sequence 2 9 0   0  
23 IfNotZero 1 27 0   0  
24 Last 2 0 0   0  
25 IdxLE 2 39 8 1 0  
26 Delete 2 0 0   0  
27 Rowid 0 10 0   0  
28 Column 0 1 11   0  
29 Column 0 2 12   0  
30 Column 0 3 13   0  
31 Column 0 4 14   0  
32 Column 0 5 15   0  
33 Column 0 6 16   0  
34 Column 0 7 17   0  
35 Column 0 9 18   0  
36 Column 0 10 19   0  
37 MakeRecord 8 12 21   0  
38 IdxInsert 2 21 8 12 0  
39 Next 0 5 0   1  
40 Sort 2 54 0   0  
41 Column 2 11 20   0  
42 Column 2 10 19   0  
43 Column 2 0 18   0  
44 Column 2 9 17   0  
45 Column 2 8 16   0  
46 Column 2 7 15   0  
47 Column 2 6 14   0  
48 Column 2 5 13   0  
49 Column 2 4 12   0  
50 Column 2 3 11   0  
51 Column 2 2 10   0  
52 ResultRow 10 11 0   0  
53 Next 2 41 0   0  
54 Halt 0 0 0   0  
55 Transaction 0 0 34 0 1  
56 Variable 1 3 0 :p0 0  
57 Goto 0 1 0   0