7.8.1 How it works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 433 DML sentence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 433 DDL sentence support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as paging, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements 2} keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS props: sql-show: false Read the YAML configuration to create a data source according

12.9.1 How it works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541 DML sentence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 542 DDL sentence support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as pag‐ ing, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements 2} keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: # Broadcast tables - t_address props: sql-show: false

12.9.1 How it works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 570 DML sentence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 571 xi DDL sentence support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as pag‐ ing, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements 2} keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: # Broadcast tables - t_address props: sql-show: false

527 12.9.1 原理介绍 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 527 DML 语句 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 528 DDL 语句 . . . SQL；路由至多数据节点的 SQL 由于场景复杂，分为稳定支持、实 验性支持和不支持这三种情况。 稳定支持 全面支持 DML、DDL、DCL、TCL 和常用 DAL。支持分页、去重、排序、分组、聚合、表关联等复杂查询。 支持 PostgreSQL 和 openGauss 数据库的 schema DDL 和 DML 语句，当 SQL 中不指定 schema 时，默认 访问 public schema，其他 schema 2} keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: 9.1. ShardingSphere-JDBC 60 Apache ShardingSphere document

501 12.9.1 原理介绍 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 501 DML 语句 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 502 DDL 语句 . . . SQL；路由至多数据节点的 SQL 由于场景复杂，分为稳定支持、实 验性支持和不支持这三种情况。 稳定支持 全面支持 DML、DDL、DCL、TCL 和常用 DAL。支持分页、去重、排序、分组、聚合、表关联等复杂查询。 支持 PostgreSQL 和 openGauss 数据库的 schema DDL 和 DML 语句，当 SQL 中不指定 schema 时，默认 访问 public schema，其他 schema 2} keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: 9.1. ShardingSphere-JDBC 59 Apache ShardingSphere document

480 12.9.1 原理介绍 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 480 DML 语句 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 481 DDL 语句 . . . SQL；路由至多数据节点的 SQL 由于场景复杂，分为稳定支持、实 验性支持和不支持这三种情况。 稳定支持 全面支持 DML、DDL、DCL、TCL 和常用 DAL。支持分页、去重、排序、分组、聚合、表关联等复杂查询。 支持 PostgreSQL 和 openGauss 数据库的 schema DDL 和 DML 语句，当 SQL 中不指定 schema 时，默认 访问 public schema，其他 schema 2} keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: 9.1. ShardingSphere-JDBC 59 Apache ShardingSphere document

7.8.1 How it works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 406 DML sentence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 406 DDL sentence support for DML, DDL, DCL, TCL, and common DALs. Support for complex queries such as paging, de‐duplication, sorting, grouping, aggregation, table association, etc. Support SCHEMA DDL and DML statements ----+-------+ | name | type | props | +------------+-------------------------+-------+ | dml_audit | DML_SHARDING_CONDITIONS | | +------------+-------------------------+-------+ 2 row in set (0.01

372 7.8.1 原理介绍 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 372 DML 语句 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373 xii DDL 语句 SQL；路由至多数据节点的 SQL 由于场景复杂，分为稳定支持、实 验性支持和不支持这三种情况。 稳定支持 全面支持 DML、DDL、DCL、TCL 和常用 DAL。支持分页、去重、排序、分组、聚合、表关联等复杂查 询。支持 PostgreSQL 和 openGauss 数据库 SCHEMA DDL 和 DML 语句。 常规查询 • SELECT 主语句 SELECT select_expr [, select_expr ----+-------+ | name | type | props | +------------+-------------------------+-------+ | dml_audit | DML_SHARDING_CONDITIONS | | +------------+-------------------------+-------+ 2 row in set (0.01

303 7.6.4 Shadow Judgment Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303 DML Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303 DDL Statement as totally supported, experimental supported and un‐ supported. Totally Supported Fully support DML, DDL, DCL, TCL and most regular DAL. Support complex query with pagination, DISTINCT, ORDER BY, GROUP GROUP BY, aggregation and table JOIN. Support PostgreSQL and openGauss database SCHEMA DDL and DML statements. Regular Query • SELECT Clause SELECT select_expr [, select_expr ...] FROM table_reference

292 7.6.4 Shadow Judgment Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 292 DML Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 292 DDL Statement as totally supported, experimental supported and un‐ supported. Totally Supported Fully support DML, DDL, DCL, TCL and most regular DAL. Support complex query with pagination, DISTINCT, ORDER BY, GROUP mode is Cluster. This function is similar as MySQL show processlist. It just apply on DDL and DML statements currently. f a l s e t r u e 5.2. ShardingSphere-Proxy 161 Apache ShardingSphere document