Help Center/
Distributed Database Middleware/
User Guide/
SQL Syntax/
Unsupported Objects and Use Constraints
Updated on 2024-07-30 GMT+08:00
Unsupported Objects and Use Constraints
- Triggers
- Temporary tables
- DO statement
- Association with foreign keys
- RESET statement
- FLUSH statement
- BINLOG statement
- HANDLER statement
- SHOW WARNINGS statement
- Assignment operator :=
- Operators less than (<), equal sign (=), and greater than (>)
- Expression IS UNKNOWN
- INSTALL and UNINSTALL PLUGIN statements
- Cross-shard stored procedures and custom functions
- Modifying database names and sharding field names and types is not allowed.
- Most of SHOW statements such as SHOW PROFILES and SHOW ERRORS
- Table maintenance statements, including CHECK, CHECKSUM, OPTIMIZE, and REPAIR TABLE
- Statements for assigning a value to or querying variable session
Example:
set @rowid=0;select @rowid:=@rowid+1,id from user;
- SQL statements that use -- or /*...*/ to comment out a single line or multiple lines of code
- The result of the REPEAT function contains a maximum of 1,000,000 characters (in version 3.0.9 or later).
Permission Levels
- Global level (not supported)
- Database level (supported)
- Table level (supported)
- Column level (not supported)
- Subprogram level (not supported)
Parent topic: SQL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot