fixtures

Test tables description

Custom SQL query returning 42 rows (hide)

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

addropcodep1p2p3p4p5comment
0 Init 0 37 0   0  
1 SorterOpen 2 5 0 k(2,B,B) 0  
2 OpenRead 0 1 0 2 0  
3 VOpen 1 0 0 vtab:7F94C422D068 0  
4 Rewind 0 29 0   0  
5 Column 0 0 1   0  
6 Eq 1 8 2 BINARY-8 66  
7 Ne 1 28 3 BINARY-8 82  
8 Column 0 1 6   0  
9 Function 1 5 4 like(2) 0  
10 If 4 28 1   0  
11 Integer 0 7 0   0  
12 Column 0 1 10   0  
13 Integer 0 8 0   0  
14 Integer 1 9 0   0  
15 VFilter 1 25 8   0  
16 Column 0 1 4   0  
17 VColumn 1 1 11   0  
18 Eq 11 24 4 BINARY-8 81  
19 Integer 1 7 0   0  
20 Column 0 1 12   0  
21 VColumn 1 1 13   0  
22 MakeRecord 12 2 16   0  
23 SorterInsert 2 16 12 2 0  
24 VNext 1 16 0   0  
25 IfPos 7 28 0   0  
26 NullRow 1 0 0   0  
27 Goto 0 19 0   0  
28 Next 0 5 0   1  
29 OpenPseudo 4 17 5   0  
30 SorterSort 2 36 0   0  
31 SorterData 2 17 4   0  
32 Column 4 1 15   0  
33 Column 4 0 14   0  
34 ResultRow 14 2 0   0  
35 SorterNext 2 31 0   0  
36 Halt 0 0 0   0  
37 Transaction 0 0 34 0 1  
38 String8 0 2 0 table 0  
39 String8 0 3 0 view 0  
40 String8 0 5 0 sqlite_% 0  
41 Goto 0 1 0   0