#29679: select_related not working as expected with Oracle 12C and Python 3.6
-------------------------------------+-------------------------------------
Reporter: zap_kid | Owner: nobody
Type: Bug | Status: new
Component: Database | Version: 2.1
layer (models, ORM) | Keywords: orm, oracle,
Severity: Normal | select_related
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Suppose I have `ModelA` and `ModelB` where `ModelA` has a `ForeignKey`
field `model_b` with `ModelB` and in addition `ModelA` and `ModelB` share
another non-foreign key field with the same name. Then
`ModelA.objects.filter(...).select_related('model_b')` throws
`django.db.utils.DatabaseError: ORA-00918: column ambiguously defined`
even though Django is generating the correct `SQL`. See
[https://stackoverflow.com/questions/51879477/django-2-1-and-select-
related]
discovered using Oracle 12C and Python 3.6
--
Ticket URL: <https://code.djangoproject.com/ticket/29679>
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/050.1f4282d9cd88385e38ad3a598343d862%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
