sql server 分页的时候查询语句有排序字段会出现 除非另外还指定了 TOP、OFFSET 或 FOR XML，否则，ORDER BY 子句在视图、内联函数、派生表、子查询和公用表表达式中无效。 about mybatis-plus HOT 2 CLOSED

public SqlPaginationInnerInterceptor(DbType dbType) {
    super(dbType);
}

@Override
protected String lowLevelCountSql(String originalSql) {
    int index = originalSql.indexOf("order");
    if (index > 0) {
        String sql = originalSql.substring(0, index);
        return super.lowLevelCountSql(sql);
    }
    return super.lowLevelCountSql(originalSql);
}