ruoyi sql server pagehelper 复杂sql分页问题

报错信息：

### SQL: select count(0) from (SELECT   so.name table_name,   sep.value table_comment,   so.create_date create_time,   so.modify_date update_time   FROM   sys.objects AS so   LEFT JOIN sys.extended_properties AS sep ON so.object_id = sep.major_id   WHERE   so.type = 'U'   AND sep.minor_id = 0   AND so.name NOT LIKE 'qrtz_%' AND so.name NOT LIKE 'gen_%'   AND so.name collate Chinese_PRC_CI_AS NOT IN (select table_name from gen_table)) tmp_count
### Cause: com.github.pagehelper.PageException: 不支持该SQL转换为分页查询!]

升级pagehelper到1.4.0

        <!-- pagehelper 分页插件 -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.4.0</version>
<!--            <version>${pagehelper.spring.boot.starter.version}</version>-->
        </dependency>