mybatisPlus分页报警告如何解决

Question

使用分页 插件报警告了,虽然不影响结果,但是看着好难受,有没有厉害的同志解决一下,自己看了好久都找不到问题所在

2022-03-10 15:06:26.214 WARN 14136 --- [nio-8080-exec-2] c.b.m.e.p.i.PaginationInnerInterceptor : optimize this sql to a count sql has exception, sql:"select ucs.id,

    ip_addr,
    username,
    org_name,
    ucs.create_time,
    alarm_info
    from (select * from user_client_status
     WHERE alarm_flag = 1
        
             and user_guid = ?
        
       ) ucs 

    left join (select * from user_client
     WHERE user_guid = ? 
    ) uc using(client_guid)
    left join hr_organization hr on uc.org_code = hr.org_code
     WHERE FROM_UNIXTIME(ucs.create_time,'%Y-%m') = ?", exception:

null

Answer 1

sql中包含子查询会触发这个异常。
可以升级一下版本试试。