django.models.Manager.get and get_or_create Do Not Work With Null Fields

[cristian.esquivias@…]

Maybe this is a greater issue, but Django cannot find fields that are None.

Example:

from django.db import models

class Test(models.Model):
    title = models.CharField(max_length=30)
    description = models.CharField(max_length=200, null=True)

def test_run():
    # After running "manage.py syncdb"
    foo1, created = Test.objects.get_or_create(title='Foo', description=None)
    # created == True (good...)
    foo2, created = Test.objects.get_or_create(title='Foo', description=None)
    # created == True (that shouldn't be!)
    nrows = Test.objects.all().count()
    # nrows == 2

Django should be able able to search for None fields.

[Russell Keith-Magee]

Check the documentation. There is a difference between field=None and fieldisnull=True.