Updated on 2022-09-16 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.
  • Updating sharding keys is not supported.

SELECT statement

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