1.4.7我没使用分页但自动调用count(0)然后和我的order by冲突报错 #178
Description
The error occurred while setting parameters ### SQL: select count(0) from ( select distinct m.menuId, m.parentId, m.menuName, m.path, m.component, m.[query], m.visible, m.status, isnull(m.perms,'') as perms, m.isFrame, m.isCache, m.menuType, m.icon, m.orderNum, m.createTime from SystemMenu m where m.menuType in ('M', 'C') and m.status = 0 order by m.parentId, m.orderNum ) tmp_count ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。 ;