joinhappy81 commented on issue #5252:
URL: https://github.com/apache/shardingsphere/issues/5252#issuecomment-617499156
in the m1,m2 has a table
CREATE TABLE `user` (
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT '用户名',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
NULL DEFAULT NULL COMMENT '密码',
`datasource_id` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '数据源信息ID',
`create_time` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
`type` smallint(4) NULL DEFAULT NULL COMMENT '用户类型 1:租户 2:普通用户',
`status` smallint(4) NULL DEFAULT NULL COMMENT '用户状态 1:正常 0:删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci
COMMENT = '用户' ROW_FORMAT = Dynamic;
the sql is: select * from user
I want HintManager getInstance (). SetDatabaseShardingValue ("m1") switch m1
and HintManager getInstance (). SetDatabaseShardingValue ("m2") switch m2
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
