1a23-pangqiu commented on issue #25488: URL: https://github.com/apache/shardingsphere/issues/25488#issuecomment-1543244615
> 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 order by order on mysql successfully, but I can execute this sql on mysql 5.7.34 successfully, the above is a successful screenshot. Unfortunately, it does not work in shardingsphere, so obviously this is a bug. ``` select count(0) from (select test_plan_test_case.id as id, test_case.id as caseId, test_case.name, test_case.priority, test_case.type,test_case.test_id as testId,test_case.node_id, test_case.tags, test_case.maintainer, test_case.custom_fields,u.name as maintainerName,us.name as executorName, test_case.node_path, test_case.method, if(project.custom_num = 0, cast(test_case.num as char), test_case.custom_num) as customNum, test_plan_test_case.executor, test_plan_test_case.status, test_plan_test_case.actual_result,test_plan_test_case.execute_time as executeTime, test_plan_test_case.update_time, test_plan_test_case.`order`, test_plan_test_case.create_time,test_case_node.name as model, project.name as projectName, test_plan_test_case.plan_id as planId from test_plan_test_case inner join test_case on test_plan_test_case.case_id = test_case.id left join test_case_node on test_case_node.id = test_case.node_id inner join project on project.id = test_case.project_id left join user u on u.id = test_case.maintainer left join user us on us.id = test_plan_test_case.executor WHERE (test_case.status != 'Trash' or test_case.status is null) and test_plan_test_case.plan_id = ? order by test_plan_test_case.order desc) tmp_count ``` -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
