I was expecting the json_group_array aggregate function to leave out null, behaving like other aggregate functions. Is this to be expected?
sqlite> create table x (a integer); sqlite> insert into x values (1), (2), (null),(4); sqlite> select group_concat(a), json_group_array(a) from x; group_concat(a) json_group_array(a) --------------- ------------------- 1,2,4 [1,2,null,4] TJ O'Donnell
