Opened 10 months ago

Last modified 3 months ago

#35462 assigned New feature

ArrayAgg and others for MariaDB — at Initial Version

Reported by: Robert Silén Owned by: nobody
Component: Database layer (models, ORM) Version: 5.0
Severity: Normal Keywords: aggregation, ArrayAgg
Cc: Hisham Mahmood, Sage Abdullah Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: yes
Easy pickings: no UI/UX: no
Pull Requests:18351 build:failure

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.

According to the ticket's flags, the next step(s) to move this issue forward are:

  • To improve the patch as described in the pull request review comments or on this ticket, then uncheck "Patch needs improvement".

  • If creating a new pull request, include a link to the pull request in the ticket comment when making that update. The usual format is: [https://github.com/django/django/pull/#### PR].

Change History (0)

Note: See TracTickets for help on using tickets.
Back to Top