fixtures

Test tables description

Custom SQL query returning 68 rows (hide)

Parameters

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

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