为什么查询会出现Was expecting one of: <EOF> "," ...

最新推荐文章于 2024-03-30 10:00:55 发布
最新推荐文章于 2024-03-30 10:00:55 发布
阅读量1.7w 收藏
点赞数 2
CC 4.0 BY-SA版权
分类专栏： bug收集 文章标签： mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_44018093/article/details/92796904
博客指出MyBatis查询时会遇到特定情况，原因是mapper.xml文件 < if > 判断中出现中文或!= 后面的值不正确，建议检查解决。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

查询会遇到下面这种情况

Was expecting one of:
    <EOF> 
    "," ...
    "=" ...
    "?" ...
    "||" ...
    "or" ...
    "&&" ...
    "and" ...
    "|" ...
    "bor" ...
    "^" ...
    "xor" ...
    "&" ...
    "band" ...
    "==" ...
    "eq" ...
    "!=" ...
    "neq" ...
    "<" ...
    "lt" ...
    ">" ...
    "gt" ...
    "<=" ...
    "lte" ...
    ">=" ...
    "gte" ...
    "in" ...
    "not" ...
    "<<" ...
    "shl" ...
    ">>" ...
    "shr" ...
    ">>>" ...
    "ushr" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "%" ...
    "instanceof" ...
    "." ...
    "(" ...
    "[" ...
    <DYNAMIC_SUBSCRIPT> ...
    ]] with root cause

org.apache.ibatis.ognl.ParseException: Encountered " <IDENT> "HaCustom "" at line 1, column 26.
Was expecting one of:
    <EOF> 
    "," ...
    "=" ...
    "?" ...
    "||" ...
    "or" ...
    "&&" ...
    "and" ...
    "|" ...
    "bor" ...
    "^" ...
    "xor" ...
    "&" ...
    "band" ...
    "==" ...
    "eq" ...
    "!=" ...
    "neq" ...
    "<" ...
    "lt" ...
    ">" ...
    "gt" ...
    "<=" ...
    "lte" ...
    ">=" ...
    "gte" ...
    "in" ...
    "not" ...
    "<<" ...
    "shl" ...
    ">>" ...
    "shr" ...
    ">>>" ...
    "ushr" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "%" ...
    "instanceof" ...
    "." ...
    "(" ...
    "[" ...
    <DYNAMIC_SUBSCRIPT> ...
  • 这说明你的mapper.xml文件 < if > 判断中出现了中文或者 != 后面的值不正确，检查一下就好了
MyBatisPlus报错：Encountered unexpected token: “=“ “=“ at line 7, column 26. Was expecting one of:
Counter-Strike大牛
08-07 1550
在编写查表结构的SQL语句时，遇到了意外的“=”符号报错。经过排查，发现并非常见的SQL解析器版本冲突、MyBatis-Plus版本问题或MySQL关键字冲突所致。最终成功解决了问题。
Encountered </#list>, but was expecting one of
无知人生，记录点滴
07-11 1万+
freemarker.core.ParseException: Syntax error in template "mapper/${className}Mapper.xml" in line 205, column 25: Encountered "&lt;/#list&gt;", but was expecting one of: &lt;ATTEMPT&gt; &lt;IF&...
Was expecting one of: ＜EOF＞ “,“ ... “=“ ... “?“ ... “||“ ... “or“ ...
weixin_58688924的博客
02-07 1831
出现的问题是！=之间不要有空格
Was expecting one of: ＜EOF＞ “,“ ... “=“ ... “?“ ...
weixin_49005088的博客
03-30 598
在写ssm时第一次出现这种错误，经过检查发现是自己的动态SQL语句语法写错了，出现这种错误提示一般要检查自己的xml语句。
Was expecting one of:<EOF> "," ... "=" ...异常
是貟啊的博客
02-19 2697
检查一下mapper 里面 if标签后面 是否有问题 我这里是两个单引号没删干净。。
Was expecting one of:异常处理并解决
热门推荐
好巧~我看到你了
04-16 1万+
今天在写SpringMvc中出现这个异常，异常如下: Was expecting one of: <EOF> "," ... "=" ... "?" ... "||" ... "or" ... "&&" ... "and" ... "|" ... "bor" ... "^" ......
spring boot 运行junit 出现Was expecting one of: "," ...
qq_44746074的博客
02-05 1557
Was expecting one of: “,” … “=” … “?” … “||” … “or” … “&&” … “and” … “|” … “bor” … “^” … “xor” … “&” … “band” … “==” … “eq” … “!=” … “neq” … “<” … “lt” … “>” … “gt” … “<=” … “lte...
nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'typeName != null and typeName ! ='''. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: typeName != null and typeName ! ='' [org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 31. Was expecting one of: <EOF> "," ... "=" ... "?" ... "||" ... "or" ... "&&" ... "and" ... "|" ... "bor" ... "^" ... "xor" ... "&" ... "band" ... "==" ... "eq" ... "!=" ... "neq" ... "<" ... "lt" ... ">" ... "gt" ... "<=" ... "lte" ... ">=" ... "gte" ... "in" ... "not" ... "<<" ... "shl" ... ">>" ... "shr" ... ">>>" ... "ushr" ... "+" ... "-" ... "*" ... "/" ... "%" ... "instanceof" ... "." ... "(" ... "[" ... <DYNAMIC_SUBSCRIPT> ... "(" ... ]
最新发布
08-07
QueryWrapper<User> wrapper = new QueryWrapper<>(); wrapper.eq("type_name", typeName); List<User> users = userMapper.selectList(wrapper); ``` #### 4. 升级或降级 MyBatis/MyBatis-Plus 版本 部分版本的 ...
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "and" "AND" at line 1, column 70. Was expecting one of: "::" "LIMIT" "ORDER" "RETURN" "RETURNING" "[" "^" <EOF> <ST_SEMICOLON> 是什么报错
07-16
Was expecting: <EOF>`。这个错误通常发生在MyBatis动态SQL生成过程中，尤其是在使用`<trim>`标签时，如果处理不当，可能会在生成的SQL语句开头或结尾留下多余的连接词（如AND、OR），导致SQL语法错误。 根据引用...
2025-06-18 19:46:10,831 - INFO - Using Any for unsupported type: typing.Sequence[~T] 2025-06-18 19:46:11,071 - INFO - No module named google.cloud.bigquery_storage_v1. As a result, the ReadFromBigQuery transform *CANNOT* be used with `method=DIRECT_READ`. 2025-06-18 19:46:13,954 - ERROR - Error executing catalog: CREATE CATALOG IF NOT EXISTS hive_catalog WITH ( 'type' = 'hive', 'hive-conf-dir' = '/opt/hive/conf' ) An error occurred while calling o100.executeSql. : org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered "NOT" at line 2, column 23. Was expecting one of: <EOF> "WITH" ... ";" ... at org.apache.flink.table.planner.parse.CalciteParser.parseSqlList(CalciteParser.java:82) at org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:102) at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:758) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.flink.api.python.shaded.py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) at org.apache.flink.api.python.shaded.py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:374) at org.apache.flink.api.python.shaded.py4j.Gateway.invoke(Gateway.java:282) at org.apache.flink.api.python.shaded.py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) at org.apache.flink.api.python.shaded.py4j.commands.CallCommand.execute(CallCommand.java:79) at org.apache.flink.api.python.shaded.py4j.GatewayConnection.run(GatewayConnection.java:238) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered "NOT" at line 2, column 23. Was expecting one of: <EOF> "WITH" ... ";" ... at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.convertException(FlinkSqlParserImpl.java:490) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.normalizeException(FlinkSqlParserImpl.java:254) at org.apache.calcite.sql.parser.SqlParser.handleException(SqlParser.java:145) at org.apache.calcite.sql.parser.SqlParser.parseStmtList(SqlParser.java:200) at org.apache.flink.table.planner.parse.CalciteParser.parseSqlList(CalciteParser.java:77) ... 13 more Caused by: org.apache.flink.sql.parser.impl.ParseException: Encountered "NOT" at line 2, column 23. Was expecting one of: <EOF> "WITH" ... ";" ... at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.generateParseException(FlinkSqlParserImpl.java:46382) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.jj_consume_token(FlinkSqlParserImpl.java:46190) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.SqlStmtList(FlinkSqlParserImpl.java:3522) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.parseSqlStmtList(FlinkSqlParserImpl.java:306) at org.apache.calcite.sql.parser.SqlParser.parseStmtList(SqlParser.java:198) ... 14 more Traceback (most recent call last): File "/home/hadoop/PycharmProjects/SparkProject/src/flinkCDC.py", line 237, in <module> main() File "/home/hadoop/PycharmProjects/SparkProject/src/flinkCDC.py", line 97, in main t_env.execute_sql("CREATE CATALOG IF NOT EXISTS default_catalog") File "/home/hadoop/桌面/pyflink/lib/python3.8/site-packages/pyflink/table/table_environment.py", line 837, in execute_sql return TableResult(self._j_tenv.executeSql(stmt)) File "/home/hadoop/桌面/pyflink/lib/python3.8/site-packages/py4j/java_gateway.py", line 1322, in __call__ return_value = get_return_value( File "/home/hadoop/桌面/pyflink/lib/python3.8/site-packages/pyflink/util/exceptions.py", line 146, in deco return f(*a, **kw) File "/home/hadoop/桌面/pyflink/lib/python3.8/site-packages/py4j/protocol.py", line 326, in get_return_value raise Py4JJavaError( py4j.protocol.Py4JJavaError: An error occurred while calling o100.executeSql. : org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered "NOT" at line 1, column 19. Was expecting one of: <EOF> "WITH" ... ";" ... at org.apache.flink.table.planner.parse.CalciteParser.parseSqlList(CalciteParser.java:82) at org.apache.flink.table.planner.delegation.ParserImpl.parse(ParserImpl.java:102) at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeSql(TableEnvironmentImpl.java:758) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.flink.api.python.shaded.py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244) at org.apache.flink.api.python.shaded.py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:374) at org.apache.flink.api.python.shaded.py4j.Gateway.invoke(Gateway.java:282) at org.apache.flink.api.python.shaded.py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132) at org.apache.flink.api.python.shaded.py4j.commands.CallCommand.execute(CallCommand.java:79) at org.apache.flink.api.python.shaded.py4j.GatewayConnection.run(GatewayConnection.java:238) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered "NOT" at line 1, column 19. Was expecting one of: <EOF> "WITH" ... ";" ... at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.convertException(FlinkSqlParserImpl.java:490) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.normalizeException(FlinkSqlParserImpl.java:254) at org.apache.calcite.sql.parser.SqlParser.handleException(SqlParser.java:145) at org.apache.calcite.sql.parser.SqlParser.parseStmtList(SqlParser.java:200) at org.apache.flink.table.planner.parse.CalciteParser.parseSqlList(CalciteParser.java:77) ... 13 more Caused by: org.apache.flink.sql.parser.impl.ParseException: Encountered "NOT" at line 1, column 19. Was expecting one of: <EOF> "WITH" ... ";" ... at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.generateParseException(FlinkSqlParserImpl.java:46382) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.jj_consume_token(FlinkSqlParserImpl.java:46190) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.SqlStmtList(FlinkSqlParserImpl.java:3522) at org.apache.flink.sql.parser.impl.FlinkSqlParserImpl.parseSqlStmtList(FlinkSqlParserImpl.java:306) at org.apache.calcite.sql.parser.SqlParser.parseStmtList(SqlParser.java:198) ... 14 more
06-19
Was expecting one of: <EOF> "WITH" ... ";" ... ``` 这表明： 1. Flink SQL 解析器无法识别 `IF NOT EXISTS` 子句 2. 问题出现在创建 Catalog 的 SQL 语句中 3. 语法解析器期望的是 `WITH` 或结束符，但遇到...
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "with" "WITH" at line 42, column 9. Was expecting one of: "&" "::" "<<" ">>" "EMIT" "HAVING" "WINDOW" "[" "^" "|" <EOF> <ST_SEMICOLON>
04-03
<think>嗯，我现在需要解决JSQLParser在解析SQL时遇到'with'关键字导致的ParseException错误。用户提到他们在项目迁移到新框架后出现了这个问题，而原先的SQL是没有问题的。首先，我得想想可能的原因。 首先，...
es脚本异常：unexpected token ['('] was expecting one of [{<EOF>, ';'}].怎么解决
06-22
<think>我们正在处理用户关于Elasticsearch脚本语法异常的问题。用户遇到的错误信息是："unexpectedtoken'('expectingEOFor';'"这个错误通常发生在Painless脚本中，表示脚本语法不正确，特别是在使用括号时不符合...
SQL parse failed. Encountered “result“ at line 1, column 28.Was expecting one of:
weixin_46005650的博客
04-01 1万+
在使用flink的TableAPI和SQL写一个sql语言时，出现如下错误： Exception in thread "main" org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered "result" at line 1, column 28. Was expecting one of: "LATERAL" ... "TABLE" ... "UNNEST" ... <...
SQL报错:Encountered unexpected token: “FUNCTION“ “FUNCTION“at line 5, column 10.Was expecting one of:
qq_38837032的博客
08-09 3137
写代码SQL报错，做下记录： Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "FUNCTION" "FUNCTION" at line 5, column 10. Was expecting one of: "ACTION" "ANY" "BYTE" "CASCADE" "CAST" "CHANGE" "CHAR"
Encountered &lt;/#list&gt;, but was expecting one of
weixin_33709219的博客
07-11 1996
版权声明：本文为 testcs_dn(微wx笑) 原创文章，非商用自由转载-保持署名-注明出处，谢谢。 https://blog.csdn.net/testcs_dn/article/details/81001864 freemarker...
secect语句报错expecting(，eof或;
werty23333的博客
05-02 2939
有可能是整个的select语句中，有哪个语句是要加括号才能执行的。但它并不会给你找出是哪个语句… 目前需要加括号的有 内联结的using 字段连接的concat 多条件筛选的in 插入行insert into 表名（列名）多个列名逗号分割 插入行中的insert后跟的value（）（）中跟的是所插入记录对应的各个列值，中间用，隔开，并且插入的字符串日期等要用单引号括住。值与列名的顺序要一致 查看最...
mybatis报错 [org.apache.ibatis.ognl.ParseException: Encountered “＜EOF＞“ at line 1, column 0.
烛照@123的博客
12-03 1179
mybatis对于简化，jdbc开发能够起到很大的帮助。
FlinkSQL中关键字冲突引发的异常:Encountered “result“ at line 1, column 15.Was expecting one of
bokzmm的博客
08-26 6518
1、异常信息 在用Flink Table &sql 跑一个demo案例时，报了如下异常： Caused by: org.apache.flink.sql.parser.impl.ParseException:Encountered "result" at line 1, column 15.Was expecting one of 2、原因及解决 原因自己编写的sql语句中存在表名或字段名和Flink Table&sql 中的关键字一样的冲突，这里我的是sql中的表名 "resul
pyflink sql 方式创建数据源表报错 SQL parse failed. Encountered “time“ at line 2, column 5. Was expecting one
采集啄米记录贴
10-15 1万+
背景： 这周在尝试将之前以JAVA开发的flink stream模式脚本，迁移到开发打包更方便的pyflink 的sql 模式脚本。但是在进行逻辑迁移的时候，pyflink报错，具体报错信息如下： py4j.protocol.Py4JJavaError: An error occurred while calling o6.executeSql.: org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered "
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值