tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id 8.1. Sharding 31 Apache ShardingSphere document WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id 8.1. Sharding 31 Apache ShardingSphere document WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

v5.1.1 User & Role SQL CREATE USER ‘finley’@‘localhost’IDENTIFIED BY ‘password’ ALTER USER ‘finley’@‘localhost’IDENTIFIED BY ‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; Authorization SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS

sharding tables with multiple data nodes, and no binding table rules are configured, t_user and t_user_role are single tables that distributed on different database instances. Federation ex- ecution engine t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; 4.2. Sharding 35 Apache ShardingSphere document 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

follows: User & Role SQL CREATE USER ‘finley’@‘localhost’IDENTIFIED BY ‘password’ ALTER USER ‘finley’@‘localhost’IDENTIFIED BY ‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; Authorization SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS

当关联查询中的多个表分布在不同的数据库实例上时，由 Federation 执行引擎提供支持。假设 t_order 和 t_order_item 是多数据节点的分片表，并且未配置绑定表规则，t_user 和 t_user_role 是分布 在不同的数据库实例上的单表，那么 Federation 执行引擎能够支持如下常用的关联查询： SELECT * FROM t_order o INNER JOIN t_order_item t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; 8.1. 数据分片 28 Apache ShardingSphere document SELECT 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

当关联查询中的多个表分布在不同的数据库实例上时，由 Federation 执行引擎提供支持。假设 t_order 和 t_order_item 是多数据节点的分片表，并且未配置绑定表规则，t_user 和 t_user_role 是分布 在不同的数据库实例上的单表，那么 Federation 执行引擎能够支持如下常用的关联查询： SELECT * FROM t_order o INNER JOIN t_order_item t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; 8.1. 数据分片 28 Apache ShardingSphere document SELECT 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

当关联查询中的多个表分布在不同的数据库实例上时，由 Federation 执行引擎提供支持。假设 t_order 和 t_order_item 是多数据节点的分片表，并且未配置绑定表规则，t_user 和 t_user_role 是分布 在不同的数据库实例上的单表，那么 Federation 执行引擎能够支持如下常用的关联查询： SELECT * FROM t_order o INNER JOIN t_order_item t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; 8.1. 数据分片 28 Apache ShardingSphere document SELECT 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;