Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with Indexes

Issue 6091: MySQL doesn't support %s index method

The InnoDB engine in MySQL doesn't support HASH and ON table_name indexes. Perform a manual conversion in these cases.

Issue 6090: MySQL doesn't support indexes on expressions

Perform a manual conversion.

Issue 6092: MySQL doesn't support explicit sort ordering in the index definition

Indexes that use explicit sort ordering are converted to use the default (ascending) sort order instead. If this conversion causes performance degradation, revise the converted code as necessary.

Issue 6093: MySQL doesn't support partial indexes

Partial indexes are converted to full indexes instead. For example, take the following PostgreSQL statement.

Copy
CREATE INDEX i_indexed_partial ON test_pg_mysql.indexed_partial USING btree ( n ) WHERE ( n < 100 );

The preceding statement is converted to the following MySQL statement:

Copy
CREATE INDEX i_indexed_partial USING BTREE ON test_pg_mysql.indexed_partial ( n );

If this conversion causes performance degradation, revise the converted code as necessary.

Related Topics