• Markus Mäkelä's avatar
    MDEV-16620: Add JSON_ARRAYAGG function · d0fc07c8
    Markus Mäkelä authored
    The JSON_ARRAYAGG function extends the GROUP_CONCAT function and provides
    a method of aggregating JSON results. The current implementation supports
    DISTINCT and LIMIT but not ORDER BY (Oracle supports GROUP BY).
    
    Adding GROUP BY support is possible but it requires some extra work as the
    grouping appears to be done inside a temporary table that complicates
    matters.
    
    Added test cases that covert aggregation of all JSON types and JSON
    validation for the generated results.
    d0fc07c8
item_jsonfunc.h 15.1 KB