报错，＞ 1064 - You have an error in your SQL syntax； check the manual that corresponds to your MySQL

错误：idea：2020-12-23 15:26:13.885 ERROR 17972 --- [MessageBroker-2] o.h.engine.jdbc.spi.SqlExceptionHelper: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v

泗水六年

931人浏览 · 2021-10-29 20:14:00

泗水六年 · 2021-10-29 20:14:00 发布

错误：
idea：
2020-12-23 15:26:13.885 ERROR 17972 --- [MessageBroker-2] o.h.engine.jdbc.spi.SqlExceptionHelper : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'count >=(select pla_config.cfg_value from pla_config where pla_config.cfg_name='' at line 1
2020-12-23 15:26:13.892 ERROR 17972 --- [MessageBroker-2] c.y.a.controller.v1.trans.TransMonitor : 获取连续交易失败：[could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet]

mysql:
select tran_code,any_value(tran_name)as tran_name ,any_value(tran_date) as tran_date ,any_value(tran_time) as tran_time,any_value(id) as id,count(tran_code)as count from app_cash_trans_log group by tran_codehaving count >=(select pla_config.cfg_value from pla_config where pla_config.cfg_name='tranMaxContinuity') order by id desc limit 5
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'count >=(select pla_config.cfg_value from pla_config where pla_config.cfg_name='' at line 1
> 时间: 0.001s

解决：
tran_codehaving count修改为 tran_code having count