home / fixtures

fixtures

Test tables description

Custom SQL query returning 50 rows (hide)

Query parameters

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

addropcodep1p2p3p4p5comment
0 Init 0 48 0   0  
1 Noop 3 13 0   0  
2 Integer 101 1 0   0  
3 OpenRead 0 40 0 11 0  
4 Rewind 0 47 0   0  
5 OpenEphemeral 4 1 0 k(1,B) 0  
6 VOpen 1 0 0 vtab:7F632027F668 0  
7 Column 0 7 4   0  
8 Integer 1 2 0   0  
9 Integer 1 3 0   0  
10 VFilter 1 15 2   0  
11 VColumn 1 1 5   0  
12 MakeRecord 5 1 6 A 0  
13 IdxInsert 4 6 5 1 0  
14 VNext 1 11 0   0  
15 Variable 1 6 0 :p0 0  
16 IsNull 6 46 0   0  
17 Affinity 6 1 0 A 0  
18 NotFound 4 46 6 1 0  
19 OpenEphemeral 5 1 0 k(1,B) 0  
20 VOpen 2 0 0 vtab:7F632027F668 0  
21 Column 0 7 9   0  
22 Integer 1 7 0   0  
23 Integer 1 8 0   0  
24 VFilter 2 29 7   0  
25 VColumn 2 1 10   0  
26 MakeRecord 10 1 11 A 0  
27 IdxInsert 5 11 10 1 0  
28 VNext 2 25 0   0  
29 Variable 2 11 0 :p1 0  
30 IsNull 11 46 0   0  
31 Affinity 11 1 0 A 0  
32 NotFound 5 46 11 1 0  
33 Rowid 0 12 0   0  
34 Column 0 1 13   0  
35 Column 0 2 14   0  
36 Column 0 3 15   0  
37 Column 0 4 16   0  
38 Column 0 5 17   0  
39 Column 0 6 18   0  
40 Column 0 7 19   0  
41 Column 0 8 20   0  
42 Column 0 9 21   0  
43 Column 0 10 22   0  
44 ResultRow 12 11 0   0  
45 DecrJumpZero 1 47 0   0  
46 Next 0 5 0   1  
47 Halt 0 0 0   0  
48 Transaction 0 0 34 0 1  
49 Goto 0 1 0   0  
Powered by Datasette