记录Spring boot 项目中druid SQL验证报错但是系统功能正常报后端报 merge sql error 前端数据查询正常

最新推荐文章于 2024-09-11 10:07:01 发布

cg_ssh

最新推荐文章于 2024-09-11 10:07:01 发布

阅读量7k

点赞数 6

分类专栏： Oracle Mybatis Druid 文章标签： spring boot sql 后端

本文链接：https://blog.csdn.net/cg_ssh/article/details/122642952

版权

在Spring Boot项目中，遇到Druid SQL验证错误，前端数据查询正常，但后端报'merge sql error'。通过升级Druid版本无效后，发现是SQL语句在特定环境中存在不严谨之处。通过修改application.yaml中的Druid配置（将`merge-sql`设为`false`）解决问题，但实际应勇敢面对问题，检查并修正SQL语句。最终，发现SQL语法问题并修复，系统恢复正常。

摘要由CSDN通过智能技术生成

异常代码:

20:17:49.331 [http-nio-8081-exec-6] ERROR c.a.d.f.s.StatFilter - [mergeSql,169] - merge sql error, dbType oracle, druid-1.2.8, sql : WITH
        orgn AS(SELECT w.dwid,w.qk,w.qkdm,w.jhid FROM cd_orgn_source_attr w WHERE w.dwid='xAJLaafdjei321jlaj13nanfasX000113'),
        pclog AS(SELECT p.orgn_id,p.sand_layer_group_name AS cw ,p.soak_volume,p.thickness,p.soak_thickness,p.perforate_orgn_top_depth top FROM pc_log_desc_infuse p WHERE p.soak_volume>0 AND p.sand_layer_group_name IS NOT NULL ORDER BY top ASC),
res AS(SELECT *FROM orgn w INNER JOIN pclog p ON w.jhid=p.orgn_id),
cwres AS (SELECT cw,orgn_id FROM res GROUP BY orgn_id,cw ORDER BY cw),
layerdata AS(SELECT distinct(cw) AS "cw",SUM(thickness) AS "sy",SUM(soak_thickness) AS "yx",(SELECT COUNT(c.orgn_id) FROM cwres c WHERE c.cw=r.cw ) AS "cs" FROM res r WHERE r.QKDM=? GROUP BY cw),
        sumdata AS(SELECT SUM(&#