Opened 23 months ago
Closed 23 months ago
#34225 closed Bug (invalid)
bulk_create() raises IntegrityError when another constraint exists on set of fields.
Reported by: | Victor J. Fuente | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 4.1 |
Severity: | Normal | Keywords: | #bulk_create |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
bulk_create on 4.1 perform a bulk_update when a unique constraint fails.
But on this example, when the constraint fails, an integrity Error occur and no update is in place
class Test(models.Model): field1 = models.IntegerField(null=True, blank=True) field2 = models.IntegerField(null=True, blank=True) count = models.IntegerField(null=True, blank=True) class Meta: db_table = "test" constraints = [ models.UniqueConstraint( models.functions.Coalesce("field1", 0), models.functions.Coalesce("field2", 0), name="test_coal_unique", ), models.UniqueConstraint( "field1", "field2", name="test_unique", ), ] t1 = Test(field1=1,field2=None,count=1) t2 = Test(field1=1,field2=None,count=2) Test.objects.bulk_create([t1, t2], ignore_conflicts=False, update_conflicts=True, unique_fields=['field1','field2'], update_fields = ['count'])
django.db.utils.IntegrityError: duplicate key value violates unique constraint "test_coal_unique" DETAIL: Key (COALESCE(field1, 0), COALESCE(field2, 0))=(1, 0) already exists.
Change History (1)
comment:1 by , 23 months ago
Resolution: | → invalid |
---|---|
Status: | new → closed |
Summary: | django 4.1.x - bulk_create - django.db.utils.IntegrityError: duplicate key value violates unique constraint → bulk_create() raises IntegrityError when another constraint exists on set of fields. |
Note:
See TracTickets
for help on using tickets.
Thanks for the report, however Django is not at fault.
NULL
values don't violate unique constraints so set of unique fields passed to theON CONFLICT(...)
is not violated i.e. thetest_unique
constraint. The second constraint (test_coal_unique
) is violated but it's not taken into account byON CONFLICT
statement. If you're having trouble understanding how this statement is evaluated by your database, see TicketClosingReasons/UseSupportChannels for ways to get help.