Use Limitation
Last Updated：2020-07-20
The following table shows the general SQL syntaxes currently not supported by the DRDS:
| Unsupported types | Details |
|---|---|
| Unsupported points | It does not support modification of the partition key value, not between, explain command, distributed transactions (transactions routed to different tablet server instances), join of a crossing tablet server instance, and join of the data all in a single tablet server instance. However, when writing a join statement, it is required to give an alias to the table and use it for the subsequent table reference. Otherwise, a syntax error takes place. Also, it does not support the storage process, and partial fuctions, and you can see Unsupported Functions List. It does not support the multi_statement, Custom functions, Context relationship query, such as last_insert_id, and found_rows. |
| Unsupported data definition statements | ALTER DATABASE ALTER TABLE CREATE DATABASE CREATE INDEX CREATE TABLE DROP DATABASE DROP INDEX DROP TABLE RENAME TABLE |
| Unsupported data operation statements | Call Do Handler Load data infile |
| Unsupported transaction processing and locking statements | Savepoint Rollback to savepoint Release savepoint Lock tables Unlock tables Set transaction Isolation level XA transaction |
| Unsupported account management statements | CREATE USER DROP USER GRANT and REVOKE RENAME USER SET PASSWORD |
| Unsupported table maintenance statements | ANALYZE TABLE BACKUP TABLE CHECK TABLE CHECKSUM TABLE OPTIMIZE TABLE REPAIR TABLE RESTORE TABLE |
| Unsupported other management statements | CACHE INDEX FLUSH KILL LOAD INDEX INTO CACHE RESET |
| Unsupported SQL statements used to control the master server. | PURGE MASTER LOGS RESET MASTER SET SQL_LOG_BIN SHOW BINLOG EVENTS SHOW MASTER LOGS SHOW MASTER STATUS SHOW SLAVE HOSTS |
| Unsupported SQL statements used to control the slave server | CHANGE MASTER TO LOAD DATA FROM MASTER LOAD TABLE tbl_name FROM MASTER MASTER_POS_WAIT() RESET SLAVE SET GLOBAL SQL_SLAVE_SKIP_COUNTER SHOW SLAVE STATUS START SLAVE STOP SLAVE |