def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 PostgreSQL The unsupported SQL list for PostgreSQL def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 4.1. DB Compatibility 20 Apache ShardingSphere If there are many continuous ${ expression } or $->{ expression } expressions, according to each sub‐expression result, the ultimate result of the whole expression will be in cartesian combination. For

def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 Source Codes: https://github.com/apache/shardin def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 4.1. DB Compatibility 20 Apache ShardingSphere If there are many continuous ${ expression } or $->{ expression } expressions, according to each sub‐expression result, the ultimate result of the whole expression will be in cartesian combination. For

def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 PostgreSQL PostgreSQL 不支持的 SQL 清单如下： SQL CREATE def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 4.1. 数据库兼容 20 Apache ShardingSphere document, v5

def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 PostgreSQL PostgreSQL 不支持的 SQL 清单如下： SQL CREATE def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 4.1. 数据库兼容 20 Apache ShardingSphere document, v5

def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 源 码：https://github.com/apache/shardingsphere/tr def_test SELECT new.* ALTER TABLE alterlock SET (toast.autovacuum_enabled = off) CREATE PUBLICATION pub1 FOR TABLE alter1.t1, ALL TABLES IN SCHEMA alter2 4.1. 数据库兼容 20 Apache ShardingSphere document, v5

If there are many continuous ${ expression } or $->{ expression } expressions, according to each sub‐expression result, the ultimate result of the whole expression will be in cartesian combination. For version. Sharding Route It is used in the situation to route according to the sharding key, and can be sub‐divided into 3 types, direct route, standard route and Cartesian product route. Direct Route The Therefore, with the highest compatibility, it can execute any SQL in complex situations, including sub‐queries, self‐defined functions. Direct route can also be used in the situation where sharding keys

If there are many continuous ${ expression } or $->{ expression } expressions, according to each sub‐expression result, the ultimate result of the whole expression will be in cartesian combination. For WHERE u. user_id = 1; Unsupported CASE WHEN can not support as following: • CASE WHEN containing sub‐query • CASE WHEN containing logical‐table (instead of table alias) UNION and UNION ALL can not support ShardingSphere document, v5.0.0 Pagination Sub-query Both Oracle and SQLServer pagination need to be processed by sub‐query, ShardingSphere supports pagination related sub‐query. • Oracle Support rownum pagination:

these operations after such a scattered way of data sharding. They need to know from which specific sub‐table can they fetch the data needed. Another challenge is that SQL that works correctly in one single‐node final result of the whole expression will be a Cartesian combination based on the result of each sub‐expression. e.g. The following row expression: ${['online', 'offline']}_table${1..3} Finally, it ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] Sub-query Stable support is provided by the kernel when both the subquery and the outer query specify

these operations after such a scattered way of data sharding. They need to know from which specific sub‐table can they fetch the data needed. Another challenge is that SQL that works correctly in one single‐node final result of the whole expression will be a Cartesian combination based on the result of each sub‐expression. e.g. The following row expression: ${['online', 'offline']}_table${1..3} Finally, it conditional_expr | USING (column_list)] 3.1. Sharding 25 Apache ShardingSphere document, v5.2.0 Sub-query Stable support is provided by the kernel when both the subquery and the outer query specify

these operations after such a scattered way of data sharding. They need to know from which specific sub‐table can they fetch the data needed. Another challenge is that SQL that works correctly in one single‐node final result of the whole expression will be a Cartesian combination based on the result of each sub‐expression. e.g. The following row expression: ${['online', 'offline']}_table${1..3} Finally, it conditional_expr | USING (column_list)] 3.1. Sharding 24 Apache ShardingSphere document, v5.2.1 Sub-query Stable support is provided by the kernel when both the subquery and the outer query specify