Hi,
i use like in SQL at Elasticsearch 6.4.7 is OK, but upgrade to ES 6.5.0 , it can not working.....
_xpack/sql?format=txt
{"query":"SELECT star_demo_city,sum(amt) FROM demo_test WHERE (star_demo_city like 'MEMPHIS%' or star_demo_dbo_city like 'SHELBY%') group by star_demo_city "}
the error message :
{ "error": { "root_cause": [ { "type": "sql_illegal_argument_exception", "reason": "Cannot evaluate script for expression LikePattern[MEMPHIS%,\u0000]" } ], "type": "sql_illegal_argument_exception", "reason": "Cannot evaluate script for expression LikePattern[MEMPHIS%,\u0000]" }, "status": 500 }
if i delete "SUM(amt)" , the sql is working......
is there any way to solve it?