Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ DML/ Unsupported DML Statements
Updated on 2022-09-16 GMT+08:00
View PDF

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.
Parent topic: DML