[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822343#comment-16822343 ] Danny Chan commented on CALCITE-2948: - [~hyuan] yes, i add `testRemoveSemiJoin1()`

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822278#comment-16822278 ] Haisheng Yuan commented on CALCITE-2948: [~danny0405] Did you try checkSubQuer

[jira] [Commented] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822248#comment-16822248 ] Vineet Garg commented on CALCITE-1624: -- [~danny0405] The plan looks correct to me.

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822176#comment-16822176 ] Rong Rong commented on CALCITE-3008: In the public interface change way, we have to

[jira] [Commented] (CALCITE-3011) Support outer joins with AggregateJoinTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822147#comment-16822147 ] Vineet Garg commented on CALCITE-3011: -- [~jcamachorodriguez], [~hyuan] I have upda

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822133#comment-16822133 ] Haisheng Yuan commented on CALCITE-2973: Every physical join, no matter inner j

[jira] [Created] (CALCITE-3012) areColumnsUnique for FULL OUTER JOIN could return wrong answer when ignoreNulls is false

Vineet Garg created CALCITE-3012: Summary: areColumnsUnique for FULL OUTER JOIN could return wrong answer when ignoreNulls is false Key: CALCITE-3012 URL: https://issues.apache.org/jira/browse/CALCITE-3012

[jira] [Resolved] (CALCITE-3007) Type mismatch for ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3007. Resolution: Fixed Fix Version/s: 1.20.0 Fixed in https://github.com/apache/calcit

[jira] [Comment Edited] (CALCITE-2985) Add the JSON_STORAGE_SIZE function

[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822011#comment-16822011 ] Hongze Zhang edited comment on CALCITE-2985 at 4/19/19 5:44 PM: -

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822079#comment-16822079 ] Haisheng Yuan commented on CALCITE-2973: EnumerableJoin and EnumerableThetaJoin

[jira] [Comment Edited] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822035#comment-16822035 ] Rong Rong edited comment on CALCITE-3008 at 4/19/19 4:50 PM:

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822035#comment-16822035 ] Rong Rong commented on CALCITE-3008: Did a bit of look up, Seems like in this conte

[jira] [Commented] (CALCITE-2985) Add the JSON_STORAGE_SIZE function

[ https://issues.apache.org/jira/browse/CALCITE-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16822011#comment-16822011 ] Hongze Zhang commented on CALCITE-2985: --- [~julianhyde] - I've opened CALCITE-3010

[jira] [Updated] (CALCITE-3010) In SQL parser, move JsonValueExpression into Expression

[ https://issues.apache.org/jira/browse/CALCITE-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3010: Labels: pull-request-available (was: ) > In SQL parser, move JsonValueExpression into Ex

[jira] [Commented] (CALCITE-2996) using column label as column name

[ https://issues.apache.org/jira/browse/CALCITE-2996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821941#comment-16821941 ] masterclock commented on CALCITE-2996: -- yes, I think I'm wrong. It's not a good me

[jira] [Commented] (CALCITE-1624) Inefficient plan for NOT IN correlated subqueries

[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821775#comment-16821775 ] Danny Chan commented on CALCITE-1624: - Hei, [~vgarg], when i attach the test case t