fixtures

Test tables description

Custom SQL query returning 54 rows (hide)

Query parameters

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

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