Encountered unexpected token: “union“ “UNION“

最新推荐文章于 2024-07-10 18:18:57 发布
原创 最新推荐文章于 2024-07-10 18:18:57 发布 · 2k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java #mybatis

本文探讨了在Java开发中，如何使用`@InterceptorIgnore(tenantLine=1)`注解来避免在mapper方法中添加租户过滤条件，从而不将租户ID字段拼接到SQL查询后面。这一特性在多租户系统的特定场景下显得尤为重要，允许开发者在某些查询中跳过租户隔离，提高代码的灵活性。

在这里插入图片描述
在mapper方法上加上

 @InterceptorIgnore(tenantLine = "1")

不添加租户过滤；就是说不在sql后面拼租户id字段

JSqlParser解析SQL时SUM包裹IF出错
苦行僧
10-08 935
SQL SELECT SUM(IF(1=1,1,0)) AS `result` FROM sys_user sql``` 这种会报错的。 # 错误信息 Caused by: net.sf.jsqlparser.JSQLParserException: null at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:154) at com.baomidou.mybatisplus.core.pa
在遇到insert时某个字段添加失败，并没找到其他错
weixin_49643344的博客
04-02 2003
有时会遇到 这个字段在数据库中是特殊字段 会报以下的错 net.sf.jsqlparser.parser.ParseException: Encountered unexpected token ：“某个字段” 你把Sql语句粘贴到 mysql中时会发现 这个字段颜色和其他字段不一样，就表示这个字段是特殊字段 1 你需要修改此字段，因为在数据库中这个字段是特殊的 2 你不想修改这个字段，可以在实体类中加入 @TableField(" 特殊字段 ")这个注解就好了 注意里面是 `` 注意：实体类是curre
mysql的一些小技巧（遇到过的坑）
cb_520
06-12 3575
在实际开发过程中，各种问题千奇百怪，这里记录一些遇到的问题，和一些数据库的方法，不定期更新，给自己也给他人方便。 1、mysql获取前一个月的日期和前一年的日期 set @dt = now(); select extract(year_month from date_add(@dt, interval -1 month)); select extract(year_month from date_add(@dt, interval -1 year)); 前一个月的日期： 前一年的日期： 数据库中@代表
unexcepted token ^ in JSON at position ....
苟且。的博客
03-10 2233
翻译： 不能捕获的语法错误：json数据位置3处发现不能识别的标记× 原因：json格式错误 JSON将对象转化为字符串存储在本地是有严格要求的，比如符号，或是非法字符串之类的，都可能影响后面JOSN.parse的解析，从而导致出错。 JOSN.parse()将json字符串转化为对象。 导致报错的原因有以下几点： 1.发出请求的时候，params之类的参数里面，有了多余的字符，检查，删除掉多余字符即可。 2.params之类的参数里面，看看有没有注释，一般最好不要在里面加注释，有时候会出错。 3.请求
ParseException: Encountered unexpected token: “UNION“ “UNION“，sql正常执行，mybatis报错，原因之一
weixin_42750629的博客
07-10 1257
网络和ai给出的答案是语法或标签有问题，然而并不是。2024年7月10日。
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “:“ “:“
zh_chong的博客
12-22 1万+
先把我的SQL贴出来看一下： <select id="getAnnualReport" resultType="map"> SELECT b.* FROM ( SELECT @rownum := @rownum + 1 AS sort, a.* FROM (SELECT @rownum := 0) r, ( SELECT user_id AS userId, SUM(d
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "UNION" "UNION" at line 8, column 5.
最新发布
11-27
throw new net.sf.jsqlparser.parser.ParseException("Encountered unexpected token: \"UNION\" at line 8, column 5"); }); try { future.get(); } catch (InterruptedException | ExecutionException e) { ...
Encountered unexpected token: "UNION" "UNION" at line 51, column 15.
07-20
错误信息显示了 "UNION"，这意味着在该位置使用了不正确的语法。 请确保您的 SQL 查询语句正确，并且在使用 UNION 语句时遵循以下几个要点： 1. UNION 语句用于合并两个或多个 SELECT 语句的结果集。 2. UNION ...
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," at line 17, column 182.
07-18
- 关键提示：`Encountered unexpected token: "," ","`，说明 SQL 语句中存在多余的逗号或逗号使用不当。 2. **常见场景**： - **多余逗号**：在 `SELECT` 列表、`INSERT` 列名或 `VALUES` 的最后多写了逗号。 ...
执行SQL失败：“Error while preparing statement [select T1.仓库编码, T1.收货时间, T1.09码, /*T1.退货提交时间,*/ T2.拣料时间, T2.备注, CASE WHEN T1.质检结果= '合格' and T1.lpn状态 ='上架完成' AND T2.备注 LIKE '%CK业务%' THEN round(COALESCE( TIMESTAMPDIFF(SECOND, T1.收货时间, T2.拣料时间), TIMESTAMPDIFF(SECOND, T1.收货时间, NOW()))/ 3600.0, 2 ) WHEN T1.质检结果 IS NULL AND T1.lpn状态 ='上架完成' AND T2.备注 LIKE '%CK业务%' THEN round(COALESCE( TIMESTAMPDIFF(SECOND, T1.收货时间,T2.拣料时间), TIMESTAMPDIFF(SECOND, T1.收货时间, NOW()))/ 3600.0, 2 ) /*WHEN T1.质检结果 = '不合格' THEN round(TIMESTAMPDIFF(SECOND, T1.收货时间, T1.退货提交时间) / 3600.0, 2) ELSE NULL*/ end as ck_time from cwms3_receive_kpi_rmcc_v as T1 INNER JOIN cwms3_pick_task_d_rmcc_v AS T2 ON T1.lpn=T2.自lpn WHERE T1.质检结果 = '不合格' OR T2.备注 LIKE '%CK业务%' OR T1.09码 LIKE '%R25%']”cdjd.com.dremio.exec.rpc.RpcException: cdjd.com.dremio.common.exceptions.UserRemoteException: SYSTEM ERROR: DataServiceRunTimeException: Encountered unexpected token: ".09" at line 7, column 3. Was expecting one of: "&" "," "::" ";" "<<" ">>" "ACTION" "ANY" "AS" "BYTE" "CASCADE" "CAST" "CHANGE" "CHAR" "CHARACTER" "COLLATE" "COLUMN" "COLUMNS" "COMMENT" "COMMIT" "CONNECT" "CYCLE" "DESC" "DESCRIBE" "DISABLE" "DIV" "DO" "DUPLICATE" "ENABLE" "END" "EXCEPT" "EXCLUDE" "EXTRACT" "FALSE" "FIRST" "FN" "FOLLOWING" "FOR" "FORMAT" "FROM" "GROUP" "HAVING" "INDEX" "INSERT" "INTERSECT" "INTERVAL" "INTO" "ISNULL" "KEY" "LAST" "MATERIALIZED" "MINUS" "NEXTVAL" "NO" "NOLOCK" "NULLS" "OF" "OPEN" "ORDER" "OVER" "PARTITION" "PATH" "PERCENT" "PRECISION" "PRIMARY" "PRIOR" "RANGE" "READ" "REPLACE" "ROW" "ROWS" "SCHEMA" "SEPARATOR" "SEQUENCE" "SESSION" "SIBLINGS" "SIZE" "START" "TABLE" "TEMP" "TEMPORARY" "TO" "TOP" "TRUE" "TRUNCATE" "TYPE" "UNION" "UNSIGNED" "VALIDATE" "VALUE" "VALUES" "VIEW" "WHERE" "WINDOW" "XML" "ZONE" "[" "^" "|" [Error Id: 023dbc2e-4776-4ad9-b417-e177fbee13bd on :0] (cdjd.com.dremio.exec.rpc.UserRpcException) com.huawei.roma.data.service.common.exception.DataServiceRunTimeException: Encountered unexpected token: ".09" at line 7, column 3. Was expecting one of: "&" "," "::" ";" "<<" ">>" "ACTION" "ANY" "AS" "BYTE" "CASCADE" "CAST" "CHANGE" "CHAR" "CHARACTER" "COLLATE" "COLUMN" "COLUMNS" "COMMENT" "COMMIT" "CONNECT" "CYCLE" "DESC" "DESCRIBE" "DISABLE" "DIV" "DO" "DUPLICATE" "ENABLE" "END" "EXCEPT" "EXCLUDE" "EXTRACT" "FALSE" "FIRST" "FN" "FOLLOWING" "FOR" "FORMAT" "FROM" "GROUP" "HAVING" "INDEX" "INSERT" "INTERSECT" "INTERVAL" "INTO" "ISNULL" "KEY" "LAST" "MATERIALIZED" "MINUS" "NEXTVAL" "NO" "NOLOCK" "NULLS" "OF" "OPEN" "ORDER" "OVER" "PARTITION" "PATH" "PERCENT" "PRECISION" "PRIMARY" "PRIOR" "RANGE" "READ" "REPLACE" "ROW" "ROWS" "SCHEMA" "SEPARATOR" "SEQUENCE" "SESSION" "SIBLINGS" "SIZE" "START" "TABLE" "TEMP" "TEMPORARY" "TO" "TOP" "TRUE" "TRUNCATE" "TYPE" "UNION" "UNSIGNED" "VALIDATE" "VALUE" "VALUES" "VIEW" "WHERE" "WINDOW" "XML" "ZONE" "[" "^" "|" com.huawei.roma.data.service.worker.proxy.InboundHandler.lambda$decode$0():113 java.util.concurrent.Executors$RunnableAdapter.call():511 java.util.concurrent.FutureTask.run():266 java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():745 Caused By (com.huawei.roma.data.service.common.exception.DataServiceRunTimeException) Encountered unexpected token: ".09" at line 7, column 3. Was expecting one of: "&" "," "::" ";" "<<" ">>" "ACTION" "ANY" "AS" "BYTE" "CASCADE" "CAST" "CHANGE" "CHAR" "CHARACTER" "COLLATE" "COLUMN" "COLUMNS" "COMMENT" "COMMIT" "CONNECT" "CYCLE" "DESC" "DESCRIBE" "DISABLE" "DIV" "DO" "DUPLICATE" "ENABLE" "END" "EXCEPT" "EXCLUDE" "EXTRACT" "FALSE" "FIRST" "FN" "FOLLOWING" "FOR" "FORMAT" "FROM" "GROUP" "HAVING" "INDEX" "INSERT" "INTERSECT" "INTERVAL" "INTO" "ISNULL" "KEY" "LAST" "MATERIALIZED" "MINUS" "NEXTVAL" "NO" "NOLOCK" "NULLS" "OF" "OPEN" "ORDER" "OVER" "PARTITION" "PATH" "PERCENT" "PRECISION" "PRIMARY" "PRIOR" "RANGE" "READ" "REPLACE" "ROW" "ROWS" "SCHEMA" "SEPARATOR" "SEQUENCE" "SESSION" "SIBLINGS" "SIZE" "START" "TABLE" "TEMP" "TEMPORARY" "TO" "TOP" "TRUE" "TRUNCATE" "TYPE" "UNION" "UNSIGNED" "VALIDATE" "VALUE" "VALUES" "VIEW" "WHERE" "WINDOW" "XML" "ZONE" "[" "^" "|" com.huawei.roma.data.service.worker.jdbc.RepoService.handleSql():563 com.huawei.roma.data.service.worker.proxy.InboundHandler.checkSql():224 com.huawei.roma.data.service.worker.proxy.InboundHandler.feedWork():190 com.huawei.roma.data.service.worker.proxy.InboundHandler.lambda$decode$0():109 java.util.concurrent.Executors$RunnableAdapter.call():511 java.util.concurrent.FutureTask.run():266 java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():745 报错
08-15
我们遇到了一个SQL语法错误：`Encountered unexpected token: .09 at line 7, column 3`。这个错误通常是由于字段名中包含特殊字符（例如数字开头、点号等）而导致的。在SQL中，如果字段名包含特殊字符或与关键字...
unexcept token. token is : 'union', at line 33 column 2, token type is 'Keyword'
张柏的专栏
10-16 7808
两表合并时 使用union all 必须给表设置别名、还得注意明确字段e.g:select userInfo1.userName as uName,userInfo2.passWord  as pw from (select * from user) userInfo1union allselect userInfo2.userName as uName,userInfo2.pas
sql异常：Encountered unexpected token: “.“ “.“
热门推荐
mashangzhifu的博客
07-20 3万+
一、问题描述 在用mybatis-plus的过程中，没排序就好好的，一旦排序，报如下错误： net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "." "." at line 14, column 11. Was expecting one of: "&" "," "::" ";" "<<" ">>" "ACTION"
报错：Encountered unexpected token: “explain“ “EXPLAIN“
weixin_45521812的博客
03-07 2909
报错：Encountered unexpected token: "explain" "EXPLAIN"
Jest encountered an unexpected token This usually means that you are trying to import a file which J
weixin_41973410的博客
07-17 6868
配置jest的时候出现了rt问题，解决方案： npm install --save-dev babel-jest babel-core@^7.0.0-0 @babel/core 在根目录创建babel.config.js： module.exports = { plugins: [ "@babel/plugin-proposal-class-properties", "babel-plugin-styled-components", "@babel/plugin-syntax
Antlr.Runtime.NoViableAltException:Unexpected token: from
小鹰信息技术服务部
02-01 1万+
今天写一个稍微复杂的Hibernate 查询，在启动项目的时候报错：Antlr.Runtime.NoViableAltException:Unexpected token: from  意思很明显，是hql语句有问题，语句如下： @NamedQuery(name = "Detect.CountByUnitAndResultDx", query = "select " + "a.detec
SQL报错:Encountered unexpected token: “FUNCTION“ “FUNCTION“at line 5, column 10.Was expecting one of:
qq_38837032的博客
08-09 3255
写代码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"
@InterceptorIgnore(illegalSql = “true“, tenantLine = “true“)解决MyBaits ParseException unexpected toke
weixin_50592059的博客
12-14 3943
此时在mapper方法上方加上注解@InterceptorIgnore(tenantLine = "true")即可避开报错，如果不写注解，方法仍然可以执行，只是日志会提示错误，实际不影响程序运行。在MyBatis的xml中如果写了UNION比较复杂的查询，有时候报错optimize this sql to a count sql has exception。
错误：QuerySyntaxException: unexpected token；
kaidishi的专栏
07-24 3244
错误提示 Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token org.springframework.orm.hibernate3.HibernateQueryException: unexpected token   造成原因：数据库访问语句出错
sql异常Encountered unexpected token BINARY
bit的博客
11-06 937
问题在 BINARY s.command 这里, 不符合标准语法, 使用替换即可。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值