The IF function with nested locate function doesn't work in Query Workbench

[nicolaslledo]

The query

SELECT IF(LOCATE('o', 'hello')>0, 'found', 'no found') AS ifTrue FROM siouxsso* limit 10;

results in ": no response" the result pane

[chloe-zh]

Hi @nicolaslledo , thanks for reporting this issue! The old engine does not support nested functions in many cases, neither string functions nor conditional functions, even though both locate and if work fine separately. This issue results from the implementation of the functions in the old engine is to push the hard coded painless script to the es engine, but it is ineligible when the functions are nested. The good thing is our new engine is eligible fo nested functions, and the case you mentioned would also be supported once the IF and LOCATE are supported. We will keep you updated when the features are good to release. Thanks!

[dai-chen]

IF function is already added in new query engine. LOCATE function is pending.