ESQL: match full-text search function silently returning wrong results (empty) past LOOKUP JOIN #130561
Description
Description
The following query returns successfully, but wrongly, with no results:
FROM employees | EVAL language_code = languages | LOOKUP JOIN languages_lookup ON language_code | WHERE language_name : "French" | KEEP emp_no, language_code, language_name, first_name For reference, the exact match (| WHERE language_name == "French") returns:
emp_no | language_code | language_name | first_name ---------------+---------------+---------------+--------------- 10001 |2 |French |Georgi 10008 |2 |French |Saniya 10016 |2 |French |Kazuhito 10017 |2 |French |Cristinel 10018 |2 |French |Kazuhide 10037 |2 |French |null 10039 |2 |French |null 10050 |2 |French |Yinghua 10056 |2 |French |Brendon 10059 |2 |French |Alejandro 10060 |2 |French |Breannda 10065 |2 |French |Satosi 10067 |2 |French |Claudi 10071 |2 |French |Hisao 10078 |2 |French |Danel 10079 |2 |French |Kshitij 10081 |2 |French |Zhongwei 10090 |2 |French |Kendra 10099 |2 |French |Valter Related: #129778, we'll likely want to prevent : operator, and MATCH* functions be placed away from the FROM.