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
 
posted @   wobzd  阅读(5918)  评论(1编辑  收藏  举报
相关博文:
阅读排行:
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
点击右上角即可分享
微信分享提示