• The data definition language (DDL) currently supports tables and indexes only.

  • During the DDL operation, the transaction isolation level is set to READ UNCOMMITTED.

  • The ADD COLUMN BEFORE|AFTER XXXXXX statement is not supported.

  • The ALTER TABLE ADD|DROP INDEX syntax should not be used to change an index. This syntax is blocking, and affects normal operations of data manipulation language (DML) statements. Instead, CREATE|DROP INDEX ON should be used.

  • Currently, no system libraries or system tables are available, such as information_schema.

  • The following advanced features are not supported:

    • Tablespaces.

    • MySQL syntax for partitioned tables.

    • Stored procedures and user-defined functions.

    • Triggers.

    • Events.

    • Cursors.

  • The following constraints are not supported:

    • The uniqueness constraint. You can create a primary key and a unique index. Only the uniqueness of the auto increment primary key can be guaranteed.

    • The foreign key constraint.

    • The CHECK constraint.