Opened 6 weeks ago

Last modified 4 weeks ago

#35671 closed Cleanup/optimization

Field.null=False on string-based fields behaves inconsistently with the typical usage of Field.null. — at Initial Version

Reported by: Clifford Gama Owned by:
Component: Database layer (models, ORM) Version: 5.1
Severity: Normal Keywords: Field.null; IntegrityError; NotNullConstraint; Field.default
Cc: Clifford Gama Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

When Field.null=False and Field.default is not set for string-based fields—such as CharField, TextField, and SlugFieldField.null does not raise the expected IntegrityError: NOT NULL constraint failed when a value is not provided for the field.

Django saves empty strings for these fields, and since the database does not (always?) interpret an empty string as NULL, they are accepted without raising the IntegrityError. This behavior is not clearly documented and is inconsistent with the typical usage of Field.null as a NOT NULL constraint.

The [documentation](https://docs.djangoproject.com/en/5.1/ref/models/fields/#django.db.models.Field.null) on Field.null specifies:

Avoid using null on string-based fields such as CharField and TextField. If a string-based field has null=True, that means it has two possible values for “no data”: NULL and the empty string. In most cases, it’s redundant to have two possible values for “no data;” the Django convention is to use the empty string, not NULL.

What is not specified here or in the documentation for Field.default is that Django effectively sets the empty string as the default for these string-based fields when none is provided. If you wish to truly disallow empty values for those fields, you need to set Field.default=None and null=False.

Since Django relies on the database to raise IntegrityErrors when a required field is not provided, it is inconsistent that Django does not treat the empty string as “no data” (i.e., NULL) in this context or that they use the empty string as “no data” when the database will interpret it as actual data.

The issue is particularly evident when a model instance is created using the model Manager's create() and get_or_create() methods or by direct instantiation.

Change History (0)

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