sql查询在mysql中工作正常，但在spring引导测试中使用BadSqlGrammarException的HSQL失败

I have a spring-boot service that I am writing unit tests. The service executes following method as part of API. I tested API manually through Rest Client and I could see it working. service that I am writing