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

2021-05-21 Thread Stanilovsky Evgeny (Jira) 


[ 
https://issues.apache.org/jira/browse/IGNITE-14737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17349262#comment-17349262
 ] 

Stanilovsky Evgeny commented on IGNITE-14737:
-

[~alex_pl], [~tledkov-gridgain] guys can u help with merge ? thanks 

> 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: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> 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 and appropriate message.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

2021-05-21 Thread Konstantin Orlov (Jira) 


[ 
https://issues.apache.org/jira/browse/IGNITE-14737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17349107#comment-17349107
 ] 

Konstantin Orlov commented on IGNITE-14737:
---

[~zstan], the patch looks good to me. Please resolve all conflicts and proceed 
with merging.

> 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: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> 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 and appropriate message.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

2021-05-20 Thread Stanilovsky Evgeny (Jira) 


[ 
https://issues.apache.org/jira/browse/IGNITE-14737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17348216#comment-17348216
 ] 

Stanilovsky Evgeny commented on IGNITE-14737:
-

[~korlov], [~alex_pl] thanks, all done.

> 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: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> 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 and appropriate message.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

2021-05-19 Thread Stanilovsky Evgeny (Jira) 


[ 
https://issues.apache.org/jira/browse/IGNITE-14737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17347650#comment-17347650
 ] 

Stanilovsky Evgeny commented on IGNITE-14737:
-

[~alex_pl] fix your comments, check plz.

> 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: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> 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 and appropriate message.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)