fixtures

Test tables description

Custom SQL query returning 62 rows (hide)

Parameters

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

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