mybatis的exception:net.sf.jsqlparser.parser.ParseException问题之一解决_exception: net.sf.jsqlparser.parser.parseexception

作者：笔触狂放9 | 2024-07-28 12:24:03

踩

exception: net.sf.jsqlparser.parser.parseexception: encountered unexpected t


optimize this sql to a count sql has exception, sql:"select a.id,
               a.code,
               a.title,
               a.text,
               a.body,
               CONCAT(?,b.img) as img,
               a.commend,
               a.tag,
               (select sum(viewcount) from tb_video_url c where c.video_id = a.id and c.close = 0) as viewcount
        from tb_video a
        left join tb_facepic b on b.obj = 'video' and a.id = b.obj_id and del = 0
        where a.close = 0
             
        order by commend desc ,a.id desc", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "select" <K_SELECT>
    at line 9, column 17.
 
Was expecting one of:
 
    "!"
    "("
    "NOT"

遇到的mybatis的exception:net.sf.jsqlparser.parser.ParseException问题之一解决

解决：把两个close加上``，就不报错了，可能是因为关键字的问题

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/笔触狂放9/article/detail/894168