#29630: Oracle crash querying multiple tables with the same column name when
limit/offset is used.
-------------------------------------+-------------------------------------
Reporter: zelfor5436 | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 2.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: oracle, admin, | Triage Stage: Accepted
exception |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Simon Charette):
* severity: Normal => Release blocker
Comment:
From https://docs.oracle.com/en/database/oracle/oracle-
database/18/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C6
> **Restrictions on the row_limiting_clause**
>
> This clause is subject to the following restrictions:
>
> ** If the select list contains columns with identical names and you
specify the row_limiting_clause, then an ORA-00918 error occurs**. This
error occurs whether the identically named columns are in the same table
or in different tables. You can work around this issue by specifying
unique column aliases for the identically named columns.
It looks like we'll have to either alias these columns as the reporter did
or use the old limiting mechanism on column name collision. This is
something that should be backported to 2.1 so I'll turn it into a release
blocker.
--
Ticket URL: <https://code.djangoproject.com/ticket/29630#comment:9>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/068.f8e3deaeb8e3456252f77a7adb9f7452%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
