Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#18778 closed Bug (invalid)

ForeignKey to a model with a CharField primary key produces unexpected results for an empty-string PK value

Reported by: Ubercore Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords:
Cc: Ubercore Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

class ModelA(models.Model):
    code = models.CharField(max_length=50, primary_key=True)

class ModelB(models.Model):
    model_a = models.ForeignKey(ModelA, blank=True, null=True, max_length=50)

In this case, if there's an instance of ModelA such that instance_a.code == '', ModelB will not be able to reference it properly. Upon save, db.models.fields.related.ForeignKey will change model_a_id from '' to NULL. While this is an odd case, and I don't particularly like the situation of having an empty string as a primary key, I think Django should at least be able to handle it. The offending code is at https://github.com/django/django/blob/master/django/db/models/fields/related.py#L987.

Change History (3)

comment:1 by Ubercore, 12 years ago

Cc: Ubercore added

comment:2 by anonymous, 12 years ago

Resolution: invalid
Status: newclosed

You cannot have a empty primary_key.
Can you provide a failing test for this ?

comment:3 by Ubercore, 12 years ago

Interesting. This project must have gotten into an odd state with migrations. I'll investigate a bit more, but it does look like an invalid ticket. Thanks.

Note: See TracTickets for help on using tickets.
Back to Top