agent中exesql中执行sql报错

[mxj-1107]

SELECT SUM((CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(Effect, ';', 1), ':', -1), 'kWh', 1) AS DECIMAL(10,1)) - CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(Effect, ';', -1), ':', -1), 'kWh', 1) AS DECIMAL(10,1))) ) AS 总节电量 FROM effect WHERE effect.ZuoYeQu like '%哈南油田%' AND effect.RiQi = "2025-02-24"这个sql在数据库里执行没有问题，但使用agent里的ExeSQl执行会报错：Can't query the correct data via SQL statement。