Suppose table looks like :
and request :
SELECT NAME FROM products WHERE CAT_ID = (SELECT CAT_ID FROM products WHERE SUBCAT_ID = 10)
for now it correctly executed and returns undefined results, proposal : return ERROR and appropriate message.
- is part of
IGNITE-12248 Apache Calcite based query execution engine
- links to