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

Advanced SQL Functions

Table 1 Restrictions on advanced SQL functions

Item

Restriction

SQL functions
  • PREPARE and EXECUTE syntax is not supported.
  • Customized data types and functions are not supported.
  • Views, stored procedures, triggers, and cursors are not supported.
  • Compound statements such as BEGIN...END, LOOP...END LOOP, REPEAT...UNTIL...END REPEAT, and WHILE...DO...END WHILE are not supported.
  • Process control statements such as IF and WHILE are not supported.
  • The following prepared statements are not supported:

    PREPARE Syntax

    EXECUTE Syntax

  • Comments for indexes are not supported in table creation statements.
Parent topic: SQL Syntax