配置

代码

报错

SELECT COUNT(1) FROM (SELECT bill_no,fQty,user_id,status,delete_state,order_name,color,zodiac_sings,isnoempty_url,warehouse,sorting,duration,site_code,site_name,check_result,pass,create_date,update_date,send_status FROM [order_form] ORDER BY create_date DESC) TOTAL

Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。] with root cause

因为MP优化分页将排序带入到count的子查询里面，sqlserver 报错

未解决，头大