#25049: Oracle constraints case sensitivity
-------------------------------------+-------------------------------------
Reporter: Pogsquog | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.8
(models, ORM) | Keywords: Oracle constraints
Severity: Normal | migration case
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
When using Oracle, migrations which alter the unique constraints of a
model do not migrate correctly. This appears to be due to a case
sensitivity difference in Oracle vs other databases.
Tested on Django 1.8 and 1.7 with Oracle 12c
example: models.py
from django.db import models
class DoorCount(models.Model):
Day = models.DateField()
MinuteOfTheDay = models.PositiveIntegerField()
DoorId = models.PositiveIntegerField(null=False, blank=False)
LineId = models.PositiveIntegerField(null=False, blank=False,
default=0)
Count = models.PositiveIntegerField(default=0)
class Meta:
# unique_together = ("Day", "MinuteOfTheDay", "DoorId", "LineId")
# migration initial 0001
unique_together = ("Day", "MinuteOfTheDay", "DoorId", "LineId") #
migration 0002
run makemigration with initial
run makemigration with 0002
run migrate
gets "Found wrong number (0) of constraints for TestApp_doorcount(Day,
MinuteOfTheDay, DoorId)"
Problem appears to be case sensitivity when looking for field names, so it
does not find the relevant constraint in the database.
Currently I have a workaround to patch site-packages/django/db/schema.py
with a .lower() on constraints, but this is very annoying for deploying,
and is probably better fixed in the oracle specific code.
--
Ticket URL: <https://code.djangoproject.com/ticket/25049>
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/051.fbab846713a67239a195ca033317af39%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
