#24367: ORA-00918 (column ambiguously defined) when using a combination of
slicing,
distinct, and order_by
-------------------------------------+-------------------------------------
Reporter: skoot | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.7
(models, ORM) |
Severity: Normal | Resolution:
Keywords: ORA-00918 oracle | Triage Stage:
queryset | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Kishor Pawar):
* status: closed => new
* resolution: fixed =>
Comment:
I have models like (result of inspectdb)
{{{
class Profile(models.Model):
id = models.BigIntegerField(primary_key=True)
name = models.CharField(max_length=1024, blank=True, null=True)
class Meta:
managed = False
db_table = 'cpe_profile'
class ResourceMgmt(models.Model):
id = models.BigIntegerField(primary_key=True)
profile = models.ForeignKey(Profile, models.DO_NOTHING,
related_name='cpe_mgmt_profile')
class Meta:
managed = False
db_table = 'cpe_resource_mgmt'
}}}
Serializer like
{{{
class ResourceMgmtSerializer(serializers.ModelSerializer):
profile_name = serializers.StringRelatedField(source='profile.name',
read_only=True)
class Meta:
model = ResourceMgmt
fields = (<tuple of fields including profile_name>)
}}}
View like
{{{
class RunningSchedules(generics.ListCreateAPIView):
serializer_class = ResourceMgmtSerializer
model = ResourceMgmt
filter_backends = (filters.OrderingFilter, filters.SearchFilter,)
ordering_fields = (<tuple of fields including profile_name as
profile__name>)
ordering = ('-schedule_start_time',)
search_fields = ordering_fields
}}}
Now when I hit url like `?ordering=profile__name` I get an error
`ORA-00918: column ambiguously defined`.
--
Ticket URL: <https://code.djangoproject.com/ticket/24367#comment:4>
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/063.8f168867afc79ac0fb1f97c8b898c8e2%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
