Error when updating relational field

[terion-name]

Describe the Bug

In continuation of #13369 (relational structure is there): because of relation duplication bug, decided to make models immutable. Added a condition to relational field and got:

[INTERNAL_SERVER_ERROR] alter table `order_slots` modify `item` int - UNKNOWN_CODE_PLEASE_REPORT: Referencing column 'item' and referenced column 'id' in foreign key constraint 'order_slots_item_foreign' are incompatible.

To Reproduce

See screencast:

screencast.2022-05-18.13-40-48.mp4

Errors Shown

[INTERNAL_SERVER_ERROR] alter table order_slots modify item int - UNKNOWN_CODE_PLEASE_REPORT: Referencing column 'item' and referenced column 'id' in foreign key constraint 'order_slots_item_foreign' are incompatible.

What version of Directus are you using?

9.10.0

What version of Node.js are you using?

v16.14.0

What database are you using?

mysql

What browser are you using?

brave

How are you deploying Directus?

locally

[rijkvanzanten]

Could you confirm that the collation is the same across all tables that are used in this relationship? It reminds me of #9897 which was inherently caused by the referencing table being of a different collation in MySQL.