fixtures

Test tables description

Custom SQL query returning 65 rows (hide)

Query parameters

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

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