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 |
分类:
mybatisplus
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY