fixtures

Test tables description

Custom SQL query returning 61 rows (hide)

Query parameters

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

addropcodep1p2p3p4p5comment
0 Init 0 58 0   0  
1 OpenEphemeral 1 13 0 k(1,B) 0  
2 Integer 101 1 0   0  
3 OpenRead 0 42 0 11 0  
4 Integer 16 3 0   0  
5 Once 0 16 0   0  
6 OpenEphemeral 2 1 0 k(1,) 0  
7 Variable 2 4 0 :p1 0  
8 MakeRecord 4 1 5 D 0  
9 IdxInsert 2 5 4 1 0  
10 Variable 3 4 0 :p2 0  
11 MakeRecord 4 1 5 D 0  
12 IdxInsert 2 5 4 1 0  
13 Variable 4 4 0 :p3 0  
14 MakeRecord 4 1 5 D 0  
15 IdxInsert 2 5 4 1 0  
16 Return 3 0 0   0  
17 Rewind 2 43 0   0  
18 Column 2 0 2   0  
19 IsNull 2 42 0   0  
20 SeekRowid 0 42 2   0  
21 Column 0 1 7   0  
22 Function 0 7 6 date(-1) 0  
23 Ne 8 42 6   80  
24 Column 0 4 9   0  
25 Sequence 1 10 0   0  
26 IfNotZero 1 30 0   0  
27 Last 1 0 0   0  
28 IdxLE 1 42 9 1 0  
29 Delete 1 0 0   0  
30 Rowid 0 11 0   0  
31 Column 0 1 12   0  
32 Column 0 2 13   0  
33 Column 0 3 14   0  
34 Column 0 5 15   0  
35 Column 0 6 16   0  
36 Column 0 7 17   0  
37 Column 0 8 18   0  
38 Column 0 9 19   0  
39 Column 0 10 20   0  
40 MakeRecord 9 12 22   0  
41 IdxInsert 1 22 9 12 0  
42 Next 2 18 0   0  
43 Sort 1 57 0   0  
44 Column 1 11 21   0  
45 Column 1 10 20   0  
46 Column 1 9 19   0  
47 Column 1 8 18   0  
48 Column 1 7 17   0  
49 Column 1 6 16   0  
50 Column 1 0 15   0  
51 Column 1 5 14   0  
52 Column 1 4 13   0  
53 Column 1 3 12   0  
54 Column 1 2 11   0  
55 ResultRow 11 11 0   0  
56 Next 1 44 0   0  
57 Halt 0 0 0   0  
58 Transaction 0 0 34 0 1  
59 Variable 1 8 0 :p0 0  
60 Goto 0 1 0   0