Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
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*.
https://github.com/MariaDB/server/commit/ffc5e00e9c64d64b773178be4a4750ac1613879c