mysql-cdc: text column cannot be applied to integer column

[nrainer-materialize]

What version of Materialize are you using?

a8068e6

What is the issue?

Unlike pg-cdc, mysql-cdc does not allow to apply text column to an integer column.

CREATE TABLE table_f (pk INTEGER PRIMARY KEY, f2 ENUM ('var0', 'var1'));
INSERT INTO table_f VALUES (1, 'var0');
INSERT INTO table_f VALUES (2, 'var1');

> ALTER SOURCE mz_source ADD SUBSOURCE public.table_f WITH (TEXT COLUMNS [public.table_f.f2, public.table_f.pk]);

'int' for pk."public"."table_f": ERROR: MYSQL source validation: referenced tables use unsupported types