错误:
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