[Django] #31403: MariaDB 10.5+ supports INSERT..RETURNING

10 views
Skip to first unread message

Django

unread,
Mar 25, 2020, 6:05:04 PM3/25/20
to django-...@googlegroups.com
#31403: MariaDB 10.5+ supports INSERT..RETURNING
-------------------------------------+-------------------------------------
Reporter: Adam | Owner: nobody
(Chainz) Johnson |
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
One of MariaDB 10.5's headline features is `INSERT..RETURNING` support:
https://mariadb.com/kb/en/changes-improvements-in-mariadb-105/

We should reflect this in the MySQL/MariaDB backend to allow
`bulk_create()`, that uses this, to work.

--
Ticket URL: <https://code.djangoproject.com/ticket/31403>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Mar 25, 2020, 6:05:28 PM3/25/20
to django-...@googlegroups.com
#31403: MariaDB 10.5+ supports INSERT..RETURNING
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Adam (Chainz) Johnson):

* owner: nobody => Adam (Chainz) Johnson
* status: new => assigned


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

Django

unread,
Mar 26, 2020, 1:13:08 AM3/26/20
to django-...@googlegroups.com
#31403: Add support for INSERT..RETURNING on MariaDB 10.5+.

-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):

* has_patch: 0 => 1
* stage: Unreviewed => Accepted


Comment:

[https://github.com/django/django/pull/12628 PR]

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

Django

unread,
Mar 26, 2020, 2:20:44 AM3/26/20
to django-...@googlegroups.com
#31403: Add support for INSERT..RETURNING on MariaDB 10.5+.
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 1

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):

* needs_docs: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/31403#comment:3>

Django

unread,
Mar 29, 2020, 5:49:54 AM3/29/20
to django-...@googlegroups.com
#31403: Add support for INSERT..RETURNING on MariaDB 10.5+.
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Adam (Chainz) Johnson):

* needs_docs: 1 => 0


--
Ticket URL: <https://code.djangoproject.com/ticket/31403#comment:4>

Django

unread,
Mar 31, 2020, 1:33:27 AM3/31/20
to django-...@googlegroups.com
#31403: Add support for INSERT..RETURNING on MariaDB 10.5+.
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by felixxm):

* stage: Accepted => Ready for checkin


--
Ticket URL: <https://code.djangoproject.com/ticket/31403#comment:5>

Django

unread,
Mar 31, 2020, 2:57:44 AM3/31/20
to django-...@googlegroups.com
#31403: Add support for INSERT..RETURNING on MariaDB 10.5+.
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

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

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"c06d7c92392c799d5a17f2620f8e280e119409bf" c06d7c92]:
{{{
#!CommitTicketReference repository=""
revision="c06d7c92392c799d5a17f2620f8e280e119409bf"
Refs #31403 -- Made SQLInsertCompiler.execute_sql() always return an
iterable of rows.

List of tuples.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/31403#comment:6>

Django

unread,
Mar 31, 2020, 2:57:45 AM3/31/20
to django-...@googlegroups.com
#31403: Add support for INSERT..RETURNING on MariaDB 10.5+.
-------------------------------------+-------------------------------------
Reporter: Adam (Chainz) | Owner: Adam
Johnson | (Chainz) Johnson
Type: New feature | Status: closed

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

* status: assigned => closed
* resolution: => fixed


Comment:

In [changeset:"93ed71e05802a47774b52503cdc3442686d686c1" 93ed71e0]:
{{{
#!CommitTicketReference repository=""
revision="93ed71e05802a47774b52503cdc3442686d686c1"
Fixed #31403 -- Added support for returning fields from INSERT statements
on MariaDB 10.5+.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/31403#comment:7>

Reply all
Reply to author
Forward
0 new messages