Update from 4.1.12 to 4.2.3 is incompatible with MySQL

[Pequem]

Summary

The RemoveWorkflowAwareEntitiesQuery class in the Oro\Bundle\WorkflowBundle\Migration namespace is called in Oro\Bundle\CheckoutBundle\Migrations\Schema\v1_12\RemoveAlternativeCheckoutWorkflow Migration, but this class has a "CAST(wi.entity_id as integer)" in the Select Statement, but Mysql doesnt has support of integer type.

Steps to reproduce

Try to update oro application from 4.1.12 to 4.2.3

Actual Result

CheckoutBundle migration fails

Expected Result

CheckoutBundle migration must execute without error

Details about your environment

• OroCommerce version: 4.2.3
• PHP version: 7.4.21
• Database (MySQL, PostgreSQL) version: MySQL 8

Additional information
I converted my database from MySQL to Postgres and the upgrade worked, then the problem is MySQL compatibility.

[XaBe20]

Same issue : https://github.com/oroinc/orocommerce/issues/131

[chrisaligent]

This was fixed in 5.0.2: https://github.com/oroinc/orocommerce-application/releases/tag/5.0.2

* Syntax error produced by RemoveAlternativeCheckoutWorkflow migration when upgrading to 4.2 [BB-20466]