[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16888558#comment-16888558
]
Danny Chan commented on CALCITE-3128:
-
[~julianhyde] Because you seem to have objections for this
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16874592#comment-16874592
]
Danny Chan commented on CALCITE-3128:
-
[~julianhyde] thanks,
{quote}if the condition is '(t1.c is
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16874480#comment-16874480
]
Julian Hyde commented on CALCITE-3128:
--
Does this problem occur if and only if the condition is
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16873015#comment-16873015
]
Danny Chan commented on CALCITE-3128:
-
[~mgelbana] Thanks for your test case, i have applied a PRĀ
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16872709#comment-16872709
]
Julian Hyde commented on CALCITE-3128:
--
Current behavior is wrong. Cartesian product of one row to
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871116#comment-16871116
]
Feng Zhu commented on CALCITE-3128:
---
[~danny0405] I ever executed the query in PG. It will produce a
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16871051#comment-16871051
]
Danny Chan commented on CALCITE-3128:
-
While i execute the query in MYSQL 5.6:
{code:sql}
SELECT
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16870827#comment-16870827
]
Feng Zhu commented on CALCITE-3128:
---
The generated code for query seems to be OK.
{code:java}
public
[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16864265#comment-16864265
]
Muhammad Gelbana commented on CALCITE-3128:
---
My analysis so far is that {{leftKeys}} and