Updated on 2022-11-02 GMT+08:00

Unsupported DML Statements

Unsupported DML Statements

Table 1 Syntax restrictions on DML

DML Syntax

Restriction

DELETE statement

PARTITION clauses are not supported.

UPDATE statement

Cross-shard subquery is not supported.

SELECT statement

User-defined sequencing similar to ORDER BY FIELD(id,1,2,3) is not supported.