Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
Describe the issue:
i am using the IN operator in text field with multiple conditions as given below. if am using the equal operator is it returning the result but if am trying with in operator it is not working
NOT WORKING
SELECT merchant_id FROM inventory where merchant_id IN (‘123’) and (txn_id like ‘%COM%’ or (match(search_param,‘COM’,operator=‘and’) or search_param like ‘%COM%’))
working without IN operator:
SELECT merchant_id FROM inventory where merchant_id = ‘123’ and (txn_id like ‘%COM%’ or (match(search_param,‘COM’,operator=‘and’) or search_param like ‘%COM%’))
Configuration:
Relevant Logs or Screenshots:
{\n "reason": "Invalid SQL query",\n "details": "syntax error, expect AGAINST, actual OR",\n "type": "ParserException"\n },\n "status": 400\n}
