当前使用版本(必须填写清楚,否则不予处理)

3.3.1

该问题是怎么引起的?(最新版上已修复的会直接close掉)

请问如下语句中,为什么出现group by就不去除orderBy?

// 添加包含groupBy 不去除orderBy
            if (null == groupBy && CollectionUtils.isNotEmpty(orderBy)) {
                plainSelect.setOrderByElements(null);
                sqlInfo.setOrderBy(false);
            }

能否举例什么情况下去除orderBy会出错?比如下列的语句优化好像没啥问题? select count(1) from (select name,count(1) from user GROUP BY name order by age desc, update_time desc)a 优化后为 select count(1) from (select name,count(1) from user GROUP BY name )a

重现步骤

报错信息

Comment From: nieqiurong

看到你在码云上提过了. https://gitee.com/baomidou/mybatis-plus/issues/I1B7RJ

Comment From: summer9989

@nieqiurong 目前码云上还没答案哦,麻烦安排看下