1a23-pangqiu

Results 7 comments of 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. ![image](https://user-images.githubusercontent.com/77379714/237039109-7e813bb4-e120-4c1d-968f-ff015c265939.png) ![image](https://user-images.githubusercontent.com/77379714/237039918-2dc120a8-6960-459c-8b6f-cc8a74dbce7c.png) 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?