This is distinct from #9851:
CockroachDB should be able to add the NOT NULL specifier on a column with ALTER, using a job that asserts that indeed no values are NULL.
Ability to do this (w/o creating and moving data to a new column) would be appreciated!
We would also appreciate having this feature as we also run into this issue and ended up running without this constraint
@awoods187 ^^
Just came here to say +1 馃槃
cc @dt moving to schema change's project board.
+1
@joshimhoff how do you feel about a temporary solution of create table as?
In progress: https://github.com/cockroachdb/cockroach/pull/37554
@awoods187 LGTM, thx for pointer.
Most helpful comment
In progress: https://github.com/cockroachdb/cockroach/pull/37554