[jira] [Created] (IGNITE-14737) Calcite. Equals predicate with multiple results from subqueries must fail.

["Stanilovsky Evgeny (Jira)" <ji...@apache.org>]

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)