Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with DATA TYPES

Issue 6673: MySQL doesn't support %s type in the CAST function, and a loss of precision or accuracy of data is possible

Statements that cast values to any of the following data types are converted to statements that cast values to CHAR:

  • BYTEA

  • CIDR

  • JSON

  • int4range

For example, take the following PostgreSQL statements.

Copy
select '1'::BYTEA select CAST('1' AS BYTEA)

These are both converted to the following MySQL statement.

Copy
select CAST('1' AS CHAR)

Review the converted code and revise it if necessary.

Issue 6674: MySQL doesn't support %s type in the CAST function

Statements that cast a value to the TXID_SNAPSHOT data type are converted to statements that cast a value to CHAR. For example, take the following PostgreSQL statements.

Copy
select '2628:2628:'::TXID_SNAPSHOT select CAST('2628:2628:' AS TXID_SNAPSHOT)

These are both converted to the following MySQL statement:

Copy
select CAST('2628:2628:' AS CHAR)

Review the converted code and revise it if necessary.

Related Topics