Stanilovsky Evgeny created IGNITE-14737: -------------------------------------------
Summary: Calcite. Equals predicate with multiple results from subqueries must fail. Key: IGNITE-14737 URL: https://issues.apache.org/jira/browse/IGNITE-14737 Project: Ignite Issue Type: Improvement Components: sql Reporter: Stanilovsky Evgeny Assignee: Stanilovsky Evgeny Suppose table looks like : *products* ||name||cat_id||subcat_id|| |n1|1|10| |n2|2|10| |n3|3|11| and request : {noformat} SELECT NAME FROM products WHERE CAT_ID = (SELECT CAT_ID FROM products WHERE SUBCAT_ID = 10) {noformat} for now it correctly executed and returns undefined results, proposal : return "ERROR: more than one row returned by a subquery used as an expression". -- This message was sent by Atlassian Jira (v8.3.4#803005)