Help Center/ Distributed Database Middleware/ User Guide (Kuala Lumpur Region)/ SQL Syntax/ Advanced SQL Functions
Updated on 2022-08-17 GMT+08:00
View PDF
Share

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

    For example, user privilege settings such as grant all on *.* to 'test'@'%' and identified by 'test123' are not supported. User privileges can be set on the console.
Parent topic: SQL Syntax