AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with LIMIT

Issue 6611: LIMIT/OFFSET option was omitted

MySQL doesn't support use of the LIMIT or OFFSET options with the SELECT statement. These options are dropped during conversion. For example, take the following PostgreSQL statement.

SELECT * FROM customers c offset 3;

This statement is converted to the following MySQL statement:

SELECT * FROM customers c;

Review the converted code, and revise it as necessary.

Related Topics