Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with Error Handling

Issue 6665: MySQL doesn't support the GET [ CURRENT ] DIAGNOSTICS command

Perform a manual conversion.

Issue 6664: MySQL doesn't support the condition information %s

Some of the condition information items that are used with the GET STACKED DIAGNOSTICS statement in PostgreSQL are not supported by MySQL. These include the following:

  • PG_DATATYPE_NAME

  • TABLE_NAME

  • SCHEMA_NAME

  • PG_EXCEPTION_DETAIL

  • PG_EXCEPTION_HINT

  • PG_EXCEPTION_CONTEXT

Manually convert the code wherever you use these condition information items.

Issue 6329: MySQL doesn't support the RAISE exception

Review the RAISE exception used, and if possible convert it to an exception using the SIGNAL or RESIGNAL statement.

Related Topics