fixtures

Test tables description

Custom SQL query returning 59 rows (hide)

Parameters

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

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