[Django] #35462: ArrayAgg and others for MariaDB

[Django]

#35462: ArrayAgg and others for MariaDB
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
robertsilen |
Type: New | Status: new
feature |
Component: | Version: 5.0
Uncategorized | Keywords: aggregation,
Severity: Normal | ArrayAgg
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
I suggest to add ArrayAgg and related (aggregation) functions for MariaDB
to Django. It has been noted in MariaDB Foundation ticket:
https://jira.mariadb.org/browse/MDEV-340967

E.g. ArrayAgg is mentioned on PostgreSQL specific aggregation functions:
https://docs.djangoproject.com/en/dev/ref/contrib/postgres/aggregates/#arrayagg

The equivalent in MariaDB is presumably this:
https://mariadb.com/kb/en/json_arrayagg/

More equivalent MariaDB aggregate functions are listed at the following
address.
https://mariadb.com/kb/en/aggregate-functions/
Some have same name 1:1. I'm guessing e.g. StringAgg could be done with
GROUP_CONCAT.

Feel free to ask more here, or in the MariaDB Foundation ticket.
--
Ticket URL: <https://code.djangoproject.com/ticket/35462>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#35462: ArrayAgg and others for MariaDB
-------------------------------------+-------------------------------------

Reporter: robertsilen | Owner: nobody
Type: New feature | Status: new
Component: Uncategorized | Version: 5.0
Severity: Normal | Resolution:
Keywords: aggregation, | Triage Stage:
ArrayAgg | Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Description changed by robertsilen:

Old description:

> I suggest to add ArrayAgg and related (aggregation) functions for MariaDB
> to Django. It has been noted in MariaDB Foundation ticket:
> https://jira.mariadb.org/browse/MDEV-340967
>
> E.g. ArrayAgg is mentioned on PostgreSQL specific aggregation functions:
> https://docs.djangoproject.com/en/dev/ref/contrib/postgres/aggregates/#arrayagg
>
> The equivalent in MariaDB is presumably this:
> https://mariadb.com/kb/en/json_arrayagg/
>
> More equivalent MariaDB aggregate functions are listed at the following
> address.
> https://mariadb.com/kb/en/aggregate-functions/
> Some have same name 1:1. I'm guessing e.g. StringAgg could be done with
> GROUP_CONCAT.
>
> Feel free to ask more here, or in the MariaDB Foundation ticket.

New description:

I suggest to add ArrayAgg and related (aggregation) functions for MariaDB
to Django. It has been noted in MariaDB Foundation ticket:

https://jira.mariadb.org/browse/MDEV-34097

E.g. ArrayAgg is mentioned on PostgreSQL specific aggregation functions:
https://docs.djangoproject.com/en/dev/ref/contrib/postgres/aggregates/#arrayagg

The equivalent in MariaDB is presumably this:
https://mariadb.com/kb/en/json_arrayagg/

More equivalent MariaDB aggregate functions are listed at the following
address.
https://mariadb.com/kb/en/aggregate-functions/
Some have same name 1:1. I'm guessing e.g. StringAgg could be done with
GROUP_CONCAT.

Feel free to ask more here, or in the MariaDB Foundation ticket.

--

--
Ticket URL: <https://code.djangoproject.com/ticket/35462#comment:1>

[Django]

#35462: ArrayAgg and others for MariaDB
-------------------------------------+-------------------------------------
Reporter: robertsilen | Owner: nobody
Type: New feature | Status: new
Component: Uncategorized | Version: 5.0
Severity: Normal | Resolution:
Keywords: aggregation, | Triage Stage:
ArrayAgg | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by robertsilen:

Old description:

> I suggest to add ArrayAgg and related (aggregation) functions for MariaDB
> to Django. It has been noted in MariaDB Foundation ticket:

> https://jira.mariadb.org/browse/MDEV-34097
>
> E.g. ArrayAgg is mentioned on PostgreSQL specific aggregation functions:
> https://docs.djangoproject.com/en/dev/ref/contrib/postgres/aggregates/#arrayagg
>
> The equivalent in MariaDB is presumably this:
> https://mariadb.com/kb/en/json_arrayagg/
>
> More equivalent MariaDB aggregate functions are listed at the following
> address.
> https://mariadb.com/kb/en/aggregate-functions/
> Some have same name 1:1. I'm guessing e.g. StringAgg could be done with
> GROUP_CONCAT.
>
> Feel free to ask more here, or in the MariaDB Foundation ticket.

New description:

I suggest to add ArrayAgg and related (aggregation) functions for MariaDB
to Django. It has been noted in MariaDB Foundation ticket:

https://jira.mariadb.org/browse/MDBF-690

E.g. ArrayAgg is mentioned on PostgreSQL specific aggregation functions:
https://docs.djangoproject.com/en/dev/ref/contrib/postgres/aggregates/#arrayagg

The equivalent in MariaDB is presumably this:
https://mariadb.com/kb/en/json_arrayagg/

More equivalent MariaDB aggregate functions are listed at the following
address.
https://mariadb.com/kb/en/aggregate-functions/
Some have same name 1:1. I'm guessing e.g. StringAgg could be done with
GROUP_CONCAT.

Feel free to ask more here, or in the MariaDB Foundation ticket.

--
--

Ticket URL: <https://code.djangoproject.com/ticket/35462#comment:2>