fixtures

Test tables description

Custom SQL query returning 73 rows (hide)

Parameters

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

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