Help Center> Distributed Database Middleware> User Guide> SQL Syntax> Advanced SQL Functions
Updated on 2023-10-09 GMT+08:00
View PDF

Advanced 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.
  • Configuring user permissions is not supported.

    Example:

    grant all on *.* to 'test'@'%' identified by 'test123';

Parent topic: SQL Syntax