net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: ":" ":"

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

[2022-07-21 14:13:23.051][WARN ][30][com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.autoCountSql:329] optimize this sql to a count sql has exception, sql:"select * from (             select d.* from             (SELECT id              FROM (SELECT t1.id,                           CASE WHEN FIND_IN_SET(parent_id, @pids) > 0 THEN @pids := CONCAT( @pids, ',', id )ELSE 0 END  AS ischild                    FROM (SELECT id, parent_id FROM sys_user t ORDER BY parent_id, id) t1,                         (SELECT @pids := ?) t2                   ) t3              WHERE ischild !=0              union              SELECT ?) s LEFT JOIN device d on s.id = d.user_id where d.id IS NOT NULL and d.del_flag = 0         ) a  ORDER BY create_time DESC", exception: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: ":" ":"     at line 5, column 82.   Was expecting one of:       "&"     "&&"     "."     "::"     "<<"     ">>"     "AND"     "COLLATE"     "ELSE"     "END"     "WHEN"     "["     "^"     "|"

　　这个异常 net.sf.jsqlparser.parser.ParseException 百度了很多，都无法解决，与mybatisplus 什么多租户没关系

　　问题：缺少sql解析工具的jar包

　　解决：引入jsqlparser依赖

<dependency>
   <groupId>com.github.jsqlparser</groupId>
   <artifactId>jsqlparser</artifactId>
   <version>4.2</version>
</dependency>

?

1