Can't set default value for fields

[rashidpathiyil]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

Can't update default value for fields on a fresh 9.5.2 Directus with Cockroach DB.

To Reproduce

2022-02-24.12-36-12-1.mp4

Errors Shown

What version of Directus are you using?

9.5.2

What version of Node.js are you using?

16.14.0

What database are you using?

cockroachdb

What browser are you using?

Edge

What operating system are you using?

Windows 11

How are you deploying Directus?

PaaS

[licitdev]

I believe this has been be resolved since v9.10.0 through the update of Knex to 2.0.0 in #13051.

Knex 1.0.0 includes a workaround to enable the experimental use of alter column in knex/knex#4874.

For more details on the experimental alter column, please refer to the PR in CockroachDB cockroachdb/cockroach#49329.