[Django] #27789: Simplified get sequence value on Oracle.

[Django]

#27789: Simplified get sequence value on Oracle.
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: | Status: assigned
Cleanup/optimization |
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: 1
UI/UX: 0 |
-------------------------------------+-------------------------------------
I propose to use explicit
{{{#!sql
seq_value := sequence.nextval;
}}}
instead of
{{{#!sql
SELECT sequence.nextval INTO seq_value FROM dual
}}}
It is valid since Oracle 11g.

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

[Django]

#27789: Simplified get sequence value on Oracle.
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm
Type: | Status: assigned
Cleanup/optimization |

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Ready for
| checkin
Has patch: 0 | Needs documentation: 0

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

Changes (by Tim Graham):

* stage: Unreviewed => Ready for checkin

Comment:

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

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

[Django]

#27789: Simplified get sequence value on Oracle.
-------------------------------------+-------------------------------------
Reporter: felixxm | Owner: felixxm

Type: | Status: closed

Cleanup/optimization |
Component: Database layer | Version: master
(models, ORM) |

Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin

Has patch: 0 | Needs documentation: 0

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

Changes (by Tim Graham <timograham@…>):

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

Comment:

In [changeset:"89501d9298494d732f56cf577e70d4203f45467b" 89501d92]:
{{{
#!CommitTicketReference repository=""
revision="89501d9298494d732f56cf577e70d4203f45467b"
Fixed #27789 -- Simplified query for sequence value on Oracle.
}}}

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