TiDB is 100% compatible with MySQL 5.7 protocol, functions and syntax commonly used in MySQL 5.7. The system tools (PHPMyAdmin, Navicat, MySQL Workbench, mysqldump and Mydumper/myloader) and clients in the MySQL5.7 ecosystem are all used for TiDB. TiDB is a distributed database. Some features...
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency system variable is set to ON). They can ...
vii viii Chapter 1 Restrictions on Stored Programs • SQL Statements Not Permitted in Stored Routines • Restrictions for Stored Functions • Restrictions for Triggers • Name Conflicts within Stored Routines • Replication Considerations • Debugging Considerations • Unsupported Syntax from the...
If a CDM cluster functions as the agent for a data connection in Management Center, the cluster cannot connect to multiple MRS security clusters. You are advised to plan multiple agents which are mapped to MRS security clusters one by one. ...
Subqueries in DELETE, INSERT, and UPDATE Statements ROWID EXPLAIN PLAN Statement Callback Support See Also: Appendix B, "Supported SQL Syntax and Functions" for more information about restrictions on SQL syntax. 2.7.6.1 WHERE CURRENT OF Clause UPDATE and DELETE statements with the WHERE CURRE...
2.10.7 DDL Statements 2.10.8 SQL Syntax 2.10.8.1 WHERE CURRENT OF Clause 2.10.8.2 CONNECT BY Clause 2.10.8.3 Functions in Subqueries 2.10.8.4 Parameters in Subqueries 2.10.8.5 Data Dictionary Table and Views in UPDATE Statement 2.10.8.6 ROWID 2.10.8.7 TO_DATE 2.10.8.8 EXPLAIN PL...
Temporary tables.Whenbinlog_formatis set toSTATEMENT,CREATE TEMPORARY TABLEandDROP TEMPORARY TABLEstatements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when theenforce_gtid_consistencysystem variable is set toON). They can...
DDL operations up to 2MB in size are supported on the following objects: Clusters Procedures Tablespaces Functions Roles Triggers Indexes Sequences Types Materialized Views Synonyms Users Packages Tables ViewsThe 2MB size limitation includes packages, procedures and functions. ...
Partitioning by expression is restricted to Iceberg transform functions, except bucket[N] and void that are not supported. UPDATE and DELETE are not yet supported. General limitations Before you start using Datalake tables, ensure that you have a system with functionality that is compatible. ...
Lindorm宽表SQL语法包括DDL(Data Definition Language)数据定义语言、DML(Data Manipulation Language)数据操作语言和DCL(Data Control Language)数据控制语言三种。本文介绍Lindorm宽表SQL语法的使用限制和关键字使用说明。 模式限制 Lindorm宽表Serverless模式下不支持SQL语法。