fixtures

Test tables description

Custom SQL query returning 61 rows (hide)

Query parameters

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

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