Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with ORDER BY

Issue 6610: AI nulls first/last transformation was performed

MySQL doesn't support the NULLS FIRST or NULLS LAST options with the SELECT statement. Instances of this language are converted to use the isnull() function instead. For example, take the following PostgreSQL statements.

Copy
SELECT * FROM customers c order by id nulls last; SELECT * FROM customers c order by id desc nulls first;

These statements are converted to the following MySQL statements.

Copy
SELECT * FROM customers c order by isnull(id), id; SELECT * FROM customers c order by isnull(id) desc, id desc;

Review the converted code, and revise it if necessary.

Issue 6609: ORDER option was omitted because MySQL doesn't support key word USING in order by clause

MySQL doesn't support the ORDER BY field_name USING clause, for example SELECT * FROM customers c order by id using >;. During conversion, the ORDER BY clause is dropped. Review this code and revise it if necessary.

Related Topics