DRDS SQL usage restrictions

DRDS is compatible with the MySQL protocol and syntax. However, due to certain architectural differences between DRDS and MySQL, the following restrictions apply:

• User-defined data types and user-defined functions are not currently supported.
• Temporary tables, views, stored procedures, triggers and cursors are not currently supported.
• Compound statements such as BEGIN…END, LOOP…END LOOP, REPEAT…UNTIL…END REPEAT, WHILE…DO…END WHILE are not supported yet.

SQL restriction

• Modifying the type of split field is not supported
• Creation, addition, deletion, modification and query of SQL such as schema.table_name are not supported
• Insert statements such as insert into ... select, load data and replace into are not supported
• SQL such as select into outfile/into dumpfile/into is not supported
• rename table is not supported
• Split fields and auto increment fields in rename split tables are not supported
• The split table does not support CREATE TABLE ... LIKE and CREATE TABLE ... SELECT ...

Function limitation

DRDS currently does not support the following types of functions:

• Full text retrieval function.
• XML function.
• GTID function.
• Enterprise encryption function.