You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/04/22 01:50:23 UTC
[GitHub] [shardingsphere] joinhappy81 commented on issue #5252: In version 4.0.1, HintManager getInstance (). SetDatabaseShardingValue () can't use, don't enter DataSourceTypeHintShardingAlgorithm
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:
users@infra.apache.org