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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Labels: calcite
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 18/May/21 14:16
• Updated: 21/May/21 15:27
• Resolved: 21/May/21 13:58

Description

Suppose table looks like :

products

name	cat_id	subcat_id
n1	1	10
n2	2	10
n3	3	11

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.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #9109