_memory

Custom SQL query returning 19 rows (hide)

explain select json_group_array(distinct name)
from pragma_function_list()

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

addropcodep1p2p3p4p5comment
0 Init 0 17 0   0  
1 Null 0 1 2   0  
2 OpenEphemeral 1 0 0 k(1,B) 0  
3 VOpen 0 0 0 vtab:3E9BFC170148 0  
4 Integer 0 3 0   0  
5 Integer 0 4 0   0  
6 VFilter 0 13 3   0  
7 VColumn 0 0 5   0  
8 Found 1 12 5 1 0  
9 MakeRecord 5 1 6   0  
10 IdxInsert 1 6 5 1 16  
11 AggStep 0 5 1 json_group_array(1) 1  
12 VNext 0 7 0   0  
13 AggFinal 1 1 0 json_group_array(1) 0  
14 Copy 1 7 0   0  
15 ResultRow 7 1 0   0  
16 Halt 0 0 0   0  
17 Transaction 0 0 0 0 1  
18 Goto 0 1 0   0