UDF in where clause

[integerx]

executing:

echo "select smiles from products_structure_query where match_substructure(screen, molecule, 'CCC');" | sudo php run_query --ini=bootstrap.ini

results in:

ERRORS RETURNED BY OPERATION:
Array
(
[0] => While getting coordinator columns: 1054Unknown column 'screenmolecule' in 'where clause'
[1] => [message:Failed to execute query on node:1054Unknown column 'screenmolecule' in 'where clause'] [node:shard1] [arc:0] [insert_id:0]
...
)

Doesn't seem to see a comma between arguments in the function call.

Let me know what further info you need.
Thank you.

[greenlion]

I think you will have to add the function to the SQL parser so that it is recognized. Right now I am on disability and not working, so I can't help with the changes myself.

[greenlion]

I will need to take a look at this. Parser modification may not actually be required for UDF in the WHERE clause. There might just be a bug here.

[greenlion]

Indeed the arbitrary UDF function needs to be manually added to the parser. Should be noted in the documentation.