Menu
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.

Copy
SELECT * FROM customers c offset 3;

This statement is converted to the following MySQL statement:

Copy
SELECT * FROM customers c;

Review the converted code, and revise it as necessary.

Related Topics