sql: support ALTER TABLE ALTER COLUMN SET NOT NULL DEFAULT

[xorth]

#28751 added altering a column to now allow nulls, but if you have a massive table full of nulls, there is no way to move those to a default value.

We need:

alter table alter column set not null default 0;

Jira issue: CRDB-19638

[blathers-crl[bot]]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @jordanlewis (commented on cockroachdb/cockroach#28751)
• @joshimhoff (commented on cockroachdb/cockroach#28751)
• @awoods187 (commented on cockroachdb/cockroach#28751)
• @knz (author of cockroachdb/cockroach#28751)
• @cockroachdb/sql-schema (found keywords: alter table)
• @dt (commented on cockroachdb/cockroach#28751)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!