1a23-pangqiu
1a23-pangqiu
配置不对, 缺timer ``` "clusterType":"MASTER_SLAVE", "heartbeat":{ "heartbeatTimeout":1000, "maxRetryCount":3, "minSwitchTimeInterval":300, "showLog":false, "slaveThreshold":0.0 }, "masters":[ "corp_dw0","corp_dw1" ], "maxCon":2000, "name":"corp", "readBalanceType":"BALANCE_ALL", "replicas":[ "corp_dr0","corp_dr1" ], "switchType":"SWITCH", "timer":{ "initialDelay": 30, "period":5, "timeUnit":"SECONDS" } ```
> `order by test_plan_test_case.order desc` @1a23-pangqiu Hi, the `order` is the keyword of MySQL, this sql can not be executed in mysql too.   the `order` is the keyword...
> 我测试了这个sql在mysql5.7中无法执行。 -- metersphere_prod_and_corp.test_case definition ``` CREATE TABLE `test_case` ( `id` varchar(50) NOT NULL COMMENT 'Test case ID', `node_id` varchar(50) NOT NULL COMMENT 'Node ID this case belongs to', `test_id`...
> Can you try to change order to `order` Because the order is dynamically passed in as a String type, no matter whether the passed value is "order" or "'order'",...
> I think this is not a problem with ShardingSphere, can you execute `select * from test order by order;` on mysql successfully? I can't execute `select * from test...
> Ok, thanks, it's a bug. Another unrelated question, will 5.4.0 read-write separation support multiple masters?
> @1a23-pangqiu will not support in 5.4.0. This bug still exists in version 5.4.0,when will it be fixed?