Opened 6 years ago

Last modified 5 days ago

#31492 assigned Bug

Changing field type can cause unrelated nullability change in field on Oracle.

Reported by: Mariusz Felisiak Owned by: Itxaso Aizpurua
Component: Database layer (models, ORM) Version: 3.0
Severity: Normal Keywords: oracle null
Cc: Ian Bottomley Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Changing a field type with implicit check constraint (e.g. PositiveIntegerField) to a field without it (e.g. CharField) causes nullability change because Django drops all check constraints in such case, i.e. NOT NULL and "COLUMN" >= 0 constraints (see ​_alter_field()).

Attachments (1)

test.py​ (1.2 KB ) - added by Mariusz Felisiak 6 years ago.

Download all attachments as: .zip

Change History (4)

by Mariusz Felisiak, 6 years ago

Attachment: test.py​ added

comment:1 by Carlton Gibson, 6 years ago

Triage Stage: Unreviewed → Accepted

comment:2 by Ian Bottomley, 6 years ago

Cc: Ian Bottomley added

comment:3 by Itxaso Aizpurua, 5 days ago

Owner: changed from nobody to Itxaso Aizpurua
Status: new → assigned
Note: See TracTickets for help on using tickets.
Back to Top