Union all 分页查询生成的语句不正确

[cdlinsen]

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

<mybatis-plus-join.version>1.4.8.1</mybatis-plus-join.version>

该问题是如何引起的？(确定最新版也有问题再提!!!)

Union all分页查询生成的语句不正确，SqlServer数据库

重现步骤(如果有就写完整)

Java代码如下：

MPJLambdaWrapper<M0Org> a=new MPJLambdaWrapper<M0Org>(M0Org.class)
        .eq(!StringUtil.isNullOrEmpty(dataGroupOrgId), M0Dept::getDataGroupOrgID, dataGroupOrgId)
        .selectAs(M0Org::getOrgID, A1Org::getOrgId)
        .unionAll(M0Dept.class,u->u
                .eq(!StringUtil.isNullOrEmpty(dataGroupOrgId), M0Dept::getDataGroupOrgID, dataGroupOrgId)
                .selectAs(M0Org::getOrgID, A1Org::getOrgId)
        );
Page<A1Org> pageData = a.page(new Page<A1Org>(current, pageSize), A1Org.class);

生成的Sql语句如下：

WITH selectTemp AS (
	SELECT 
		TOP 100 
		PERCENT ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as __row_number__, 
		t.OrgID AS orgId 
	FROM 
		M0Org t 
	UNION ALL 
	SELECT 
		t.OrgID AS orgId 
	FROM 
		M0Dept t
) 
SELECT * FROM selectTemp WHERE __row_number__ BETWEEN 1 AND 10000 ORDER BY __row_number__

Union的第一个表为什么会生成Top 100，然后row_number生成的为位置也不对

Union之后获取Count，生成的语句也不对

Java代码如下：

        MPJLambdaWrapper<M0Org> mpjLambdaWrapper = new MPJLambdaWrapper<M0Org>(M0Org.class)
                .eq(!StringUtil.isNullOrEmpty(dataGroupOrgId), M0Org::getDataGroupOrgID, dataGroupOrgId)
                .unionAll(M0Dept.class, union -> union
                        .eq(!StringUtil.isNullOrEmpty(dataGroupOrgId), M0Dept::getDataGroupOrgID, dataGroupOrgId)
                );
        long count=mpjLambdaWrapper.count();

生成的Sql语句如下：

SELECT COUNT( * ) FROM M0Org t

获取count(*)的时候，生成的语句没有union all的表