代码生成器 oracle like查询报错 网上查询||两边都得加空格

bug反馈 未结 70
过客
过客 VIP2 2022-06-13 12:31:54   最后修改:2022-06-13 15:32:45
收藏
产品:vue 版本:9.33
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT t.TABLE_NAME AS name, c.COMMENTS AS comments FROM user_tables t, user_tab_comments c WHERE t.table_name = c.table_name AND t.TABLE_NAME like '%'||?||'%' ORDER BY t.TABLE_NAME at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39) ~[mybatis-plus-core-3.4.1.jar:3.4.1] at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:37) ~[mybatis-plus-extension-3.4.1.jar:3.4.1] at com.baomidou.mybatisplus.extension.plugins.inner.DataPermissionInterceptor.beforeQuery(DataPermissionInterceptor.java:53) ~[mybatis-plus-extension-3.4.1.jar:3.4.1] at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:62) ~[mybatis-plus-extension-3.4.1.jar:3.4.1] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.5.jar:3.5.5] at com.sun.proxy.$Proxy286.query(Unknown Source) ~[na:na] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.5.jar:3.5.5] ... 126 common frames omitted Caused by: net.sf.jsqlparser.JSQLParserException: null at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:65) ~[jsqlparser-3.2.jar:na] at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:40) ~[jsqlparser-3.2.jar:na] at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:34) ~[mybatis-plus-extension-3.4.1.jar:3.4.1] ... 131 common frames omitted Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "||" <OP_CONCAT> at line 7, column 42.
回帖
  • 消灭零回复