Help Center> Distributed Database Middleware> User Guide> SQL Syntax> DML> Unsupported DML Statements
Updated on 2024-04-01 GMT+08:00
View PDF

Unsupported DML Statements

Unsupported DML Statements

Table 1 Syntax restrictions on DML

DML Syntax

Constraint

DELETE statement

PARTITION clauses are not supported.

UPDATE statement

Cross-shard subquery is not supported.

SELECT statement

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

NOTE:

When the queried table is a sharded table, you cannot obtain the expected result
Parent topic: DML