Cannot migrate v8 tables to v9 with 'CURRENT_TIMESTAMP'

[tshan007]

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

All the existing tables with datetime/timestamp fields which contains default values as CURRENT_TIMESTAMP are failed to migrate and getting following error.

ER_INVALID_DEFAULT: Invalid default value for 'createdAt'

To Reproduce

Host directus v9.
Migrate v8 to v9 via migration tool.

What version of Directus are you using?

9.0.0-rc.87

What version of Node.js are you using?

16.6.0

What database are you using?

mysql 8.0.22

What browser are you using?

Chrome

What operating system are you using?

Windows

How are you deploying Directus?

locally

[paescuj]

Can you post this issue on the migration-tool repository instead?

[tshan007]

Can you post this issue on the migration-tool repository instead?

Well... Yes I can post there, but errors are getting from the directus v9 end. I didn't see any error on migration tool.

[paescuj]

Yes, but it is something which should be handled by the migration-tool. Thanks!