|
create table t20 (a varchar(10), b int);
|
insert into t20 values ('red', 1), ('blue', 2), ('red',1001), ('blue', 1002);
|
|
select json_objectagg(a,b) over (order by a ) from t20;
|
ERROR 1235 (42000): This version of MariaDB doesn't yet support 'GROUP_CONCAT() aggregate as window function'
|
Note that error message says GROUP_CONCAT.
This is because:
class Item_func_json_objectagg : public Item_sum
|
{
|
...
|
enum Sumfunctype sum_func () const {return GROUP_CONCAT_FUNC;}
|
const char *func_name() const { return "json_objectagg("; }
|
It is also potentially bad to have sum_func() to return name of another
function, because somebody somewhere might check its value and typecast
a pointer to Item_func_group_concat to Item_func_group_concat*.
|