I'm trying to change a column type from an enum to an array of enums. When I run

prisma migragte dev

, or even with the flag

--create-only

, I get an error:

Error: P3006

Migration

20220913190558_updated_user_types_type

failed to apply cleanly to the shadow database.

Error:

db error: ERROR: column "userType" cannot be cast automatically to type "USER_TYPE"[]

HINT: You might need to specify "USING "userType"::"USER_TYPE"[]".

0: sql_migration_connector::validate_migrations

at migration-engine/connectors/sql-migration-connector/src/lib.rs:270

1: migration_core:state:DevDiagnostic

at migration-engine/core/src/state.rs:250

Can you please report this issue here: https://github.com/prisma/prisma/issues/new?assignees=&labels=kind%2Fbug&template=bug_report.yml