Unable to add "not null" fields
Issue #344
invalid
When adding fields to a table that exists, if NOT NULL is checked, there is an error.
Comments (5)
-
repo owner -
repo owner Please next time you post a bug Report: copy the exact error messge! And read it. Don't just say "there is an error".
-
repo owner - changed status to invalid
-
repo owner Issue
#349was marked as a duplicate of this issue. -
repo owner Issue
#352was marked as a duplicate of this issue. - Log in to comment
If your table already contains rows and you add a column with a NOT NULL constraint, you also need to provide a DEFAULT value (that is not NULL). Otherwise, existng rows violate the NOT NULL constraint and thus you get an Error. This is not a bug, it is a mistake of the user.