[jira] [Commented] (CALCITE-2329) Enhance SubQueryRemoveRule to rewrite IN operator with the constant from the left side more optimally

2019-01-30 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16756630#comment-16756630 ] Vineet Garg commented on CALCITE-2329: -- Sorry to bring up the old issues but I jus

[jira] [Commented] (CALCITE-2329) Enhance SubQueryRemoveRule to rewrite IN operator with the constant from the left side more optimally

2019-01-30 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16756776#comment-16756776 ] Vineet Garg commented on CALCITE-2329: -- [~vvysotskyi] Thanks, I guess it is correc

[jira] [Commented] (CALCITE-2329) Enhance SubQueryRemoveRule to rewrite IN operator with the constant from the left side more optimally

2019-01-31 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16757643#comment-16757643 ] Vineet Garg commented on CALCITE-2329: -- bq. The "more optimal plan" pushes the "de

[jira] [Commented] (CALCITE-1726) Subquery in FILTER is left untransformed

2019-02-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16763303#comment-16763303 ] Vineet Garg commented on CALCITE-1726: -- I took a look into this. Issue is that pla

[jira] [Commented] (CALCITE-1726) Subquery in FILTER is left untransformed

2019-02-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16763306#comment-16763306 ] Vineet Garg commented on CALCITE-1726: -- Created a pull request to fix this at [ht

[jira] [Commented] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774826#comment-16774826 ] Vineet Garg commented on CALCITE-1513: -- The query doesn't throw assertion anymore.

[jira] [Comment Edited] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774826#comment-16774826 ] Vineet Garg edited comment on CALCITE-1513 at 2/22/19 6:18 AM: --

[jira] [Comment Edited] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774826#comment-16774826 ] Vineet Garg edited comment on CALCITE-1513 at 2/22/19 6:21 AM: --

[jira] [Commented] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774829#comment-16774829 ] Vineet Garg commented on CALCITE-1513: -- Although correct the above plan is slightl

[jira] [Assigned] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned CALCITE-1513: Assignee: Vineet Garg > Correlated NOT IN query throws AssertionError >

[jira] [Commented] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16775551#comment-16775551 ] Vineet Garg commented on CALCITE-1513: -- [~julianhyde] I have created a PR to add t

[jira] [Assigned] (CALCITE-2874) NOT IN correlated subquery has un-necessary join

2019-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned CALCITE-2874: Assignee: Vineet Garg > NOT IN correlated subquery has un-necessary join > -

[jira] [Updated] (CALCITE-2874) NOT IN correlated subquery has un-necessary join

2019-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2874: - Labels: sub-query (was: ) > NOT IN correlated subquery has un-necessary join > ---

[jira] [Created] (CALCITE-2874) NOT IN correlated subquery has un-necessary join

2019-02-25 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-2874: Summary: NOT IN correlated subquery has un-necessary join Key: CALCITE-2874 URL: https://issues.apache.org/jira/browse/CALCITE-2874 Project: Calcite Issue Ty

[jira] [Commented] (CALCITE-1513) Correlated NOT IN query throws AssertionError

2019-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16777572#comment-16777572 ] Vineet Garg commented on CALCITE-1513: -- [~julianhyde] Can you please merge the PR?

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16787523#comment-16787523 ] Vineet Garg commented on CALCITE-2857: -- bq. Agree, either IN or NOT IN, a.k.a semi

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16790255#comment-16790255 ] Vineet Garg commented on CALCITE-2857: -- {quote}You're probably right. So, would we

[jira] [Updated] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2948: - Labels: sub-query (was: ) > SqlToRelConverter generates complicated logical plan for subquery

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

2019-03-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16801292#comment-16801292 ] Vineet Garg commented on CALCITE-2948: -- Although this and  CALCITE-1624 are differ

[jira] [Created] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-25 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-2954: Summary: SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id Key: CALCITE-2954 URL: https://issues.apache.org/jira/browse/CA

[jira] [Updated] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2954: - Labels: sub-query (was: ) > SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on em

[jira] [Updated] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

2019-03-26 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2947: - Labels: sub-query (was: ) > Type mismatch assertion error when converting NOT IN subquery > --

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16803529#comment-16803529 ] Vineet Garg commented on CALCITE-2954: -- [~hyuan] Would you mind taking a look at t

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16805469#comment-16805469 ] Vineet Garg commented on CALCITE-2954: -- Thanks for providing the feedback [~hyuan]

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-03-31 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16806272#comment-16806272 ] Vineet Garg commented on CALCITE-2954: -- [~hyuan] This test case fails even with th

[jira] [Created] (CALCITE-2971) Correlated subquery in JOIN is failing

2019-04-01 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-2971: Summary: Correlated subquery in JOIN is failing Key: CALCITE-2971 URL: https://issues.apache.org/jira/browse/CALCITE-2971 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

2019-04-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16807047#comment-16807047 ] Vineet Garg commented on CALCITE-2954: -- Logged CALCITE-2971 to track the issue wit

[jira] [Updated] (CALCITE-2971) Correlated subquery in JOIN is failing

2019-04-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2971: - Labels: sub-query (was: ) > Correlated subquery in JOIN is failing > -

[jira] [Updated] (CALCITE-2971) Correlated sub-query in JOIN is failing

2019-04-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2971: - Summary: Correlated sub-query in JOIN is failing (was: Correlated subquery in JOIN is failing)

[jira] [Commented] (CALCITE-2971) Correlated sub-query in JOIN is failing

2019-04-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16807055#comment-16807055 ] Vineet Garg commented on CALCITE-2971: -- [~julianhyde] I didn't realize that. I hav

[jira] [Created] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-2986: Summary: Wrong results with =ANY subquery Key: CALCITE-2986 URL: https://issues.apache.org/jira/browse/CALCITE-2986 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2986: - Labels: sub-query (was: ) > Wrong results with =ANY subquery > ---

[jira] [Updated] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-2986: - Description: ANY/SOME subqueries are rewritten using MAX/MIN and cross-join. This is wrong tra

[jira] [Comment Edited] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16812799#comment-16812799 ] Vineet Garg edited comment on CALCITE-2986 at 4/8/19 9:22 PM: ---

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16812799#comment-16812799 ] Vineet Garg commented on CALCITE-2986: -- {{=ANY}} is equivalent to IN therefore suc

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16812867#comment-16812867 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] I have given it some thought and

[jira] [Comment Edited] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-08 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16812867#comment-16812867 ] Vineet Garg edited comment on CALCITE-2986 at 4/8/19 11:23 PM: --

[jira] [Created] (CALCITE-2991) getMaxRowCount should return rowcount 1 for an aggregate with constant keys

2019-04-11 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-2991: Summary: getMaxRowCount should return rowcount 1 for an aggregate with constant keys Key: CALCITE-2991 URL: https://issues.apache.org/jira/browse/CALCITE-2991 Project

[jira] [Commented] (CALCITE-2991) getMaxRowCount should return rowcount 1 for an aggregate with constant keys

2019-04-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16815869#comment-16815869 ] Vineet Garg commented on CALCITE-2991: -- [~hyuan] I am not sure if I understand wha

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816715#comment-16816715 ] Vineet Garg commented on CALCITE-2986: -- I have opened a pull request for {{=ANY}}

[jira] [Comment Edited] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816716#comment-16816716 ] Vineet Garg edited comment on CALCITE-2986 at 4/12/19 10:38 PM: -

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816716#comment-16816716 ] Vineet Garg commented on CALCITE-2986: -- bq  <>ANY should probably be transformed i

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817092#comment-16817092 ] Vineet Garg commented on CALCITE-2986: -- bq. It's not true that IN will be rewritte

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818396#comment-16818396 ] Vineet Garg commented on CALCITE-2986: -- bq. I think the <> ANY must be taken into

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818502#comment-16818502 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] Let's say you have {code:sql}sele

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

2019-04-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819265#comment-16819265 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] Right I was talking about <>ANY i

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

2019-04-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819588#comment-16819588 ] Vineet Garg commented on CALCITE-3007: -- I can take a look if you aren't already lo

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

2019-04-17 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-3011: Summary: Support for outer joins with AggregateJoinTransposeRule Key: CALCITE-3011 URL: https://issues.apache.org/jira/browse/CALCITE-3011 Project: Calcite I

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

2019-04-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3011: - Summary: Support outer joins with AggregateJoinTransposeRule (was: Support for outer joins wit

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

2019-04-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned CALCITE-3007: Assignee: Vineet Garg > Type mismatch for ANY subquery in project >

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

2019-04-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821194#comment-16821194 ] Vineet Garg commented on CALCITE-1624: -- [~danny0405] Sure go ahead. You might want

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

2019-04-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821331#comment-16821331 ] Vineet Garg commented on CALCITE-3011: -- Found a bug with full outer join. {code:s

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

2019-04-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821473#comment-16821473 ] Vineet Garg commented on CALCITE-3011: -- Fixing this issue in {{AggregateJoinTransp

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

2019-04-19 Thread Vineet Garg (JIRA)
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] [Commented] (CALCITE-3011) Support outer joins with AggregateJoinTransposeRule

2019-04-19 Thread Vineet Garg (JIRA)
[ 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-1624) Inefficient plan for NOT IN correlated subqueries

2019-04-19 Thread Vineet Garg (JIRA)
[ 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] [Created] (CALCITE-3028) Support FULL OUTER JOIN with AggregateJoinTransposeRule

2019-04-27 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-3028: Summary: Support FULL OUTER JOIN with AggregateJoinTransposeRule Key: CALCITE-3028 URL: https://issues.apache.org/jira/browse/CALCITE-3028 Project: Calcite I

[jira] [Commented] (CALCITE-3031) AssertionError: correlation id $cor0 not found in correlation list []

2019-04-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16829819#comment-16829819 ] Vineet Garg commented on CALCITE-3031: -- [~hyuan] Support for correlated quantified

[jira] [Commented] (CALCITE-3028) Support FULL OUTER JOIN with AggregateJoinTransposeRule

2019-05-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16841568#comment-16841568 ] Vineet Garg commented on CALCITE-3028: -- Thanks [~hyuan] > Support FULL OUTER JOIN

[jira] [Created] (CALCITE-3132) Simply expressions in LogicalFilter generated for subqueries with quantified predicate

2019-06-17 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-3132: Summary: Simply expressions in LogicalFilter generated for subqueries with quantified predicate Key: CALCITE-3132 URL: https://issues.apache.org/jira/browse/CALCITE-3132

[jira] [Commented] (CALCITE-3132) Simply expressions in LogicalFilter generated for subqueries with quantified predicate

2019-06-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16866063#comment-16866063 ] Vineet Garg commented on CALCITE-3132: -- [~hyuan] I believe since this condition is

[jira] [Commented] (CALCITE-3132) Simply expressions in LogicalFilter generated for subqueries with quantified predicate

2019-06-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16866077#comment-16866077 ] Vineet Garg commented on CALCITE-3132: -- [~hyuan] You are correct. Since this happe

[jira] [Commented] (CALCITE-3031) AssertionError: correlation id $cor0 not found in correlation list []

2019-07-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16886652#comment-16886652 ] Vineet Garg commented on CALCITE-3031: -- Pull request is available at https://githu

[jira] [Updated] (CALCITE-3031) Support for correlated ANY/SOME/ALL sub-query

2019-07-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3031: - Summary: Support for correlated ANY/SOME/ALL sub-query (was: AssertionError: correlation id $c

[jira] [Commented] (CALCITE-3031) Support for correlated ANY/SOME/ALL sub-query

2019-07-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16887416#comment-16887416 ] Vineet Garg commented on CALCITE-3031: -- [~julianhyde] I have updated the Jira titl

[jira] [Commented] (CALCITE-3031) Support for correlated ANY/SOME/ALL sub-query

2019-07-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16889587#comment-16889587 ] Vineet Garg commented on CALCITE-3031: -- [~hyuan] [~julianhyde] Can you take a look

[jira] [Created] (CALCITE-3222) Fix code style issues introduced by CALCITE-3031

2019-07-31 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-3222: Summary: Fix code style issues introduced by CALCITE-3031 Key: CALCITE-3222 URL: https://issues.apache.org/jira/browse/CALCITE-3222 Project: Calcite Issue Ty

[jira] [Commented] (CALCITE-3031) Support for correlated ANY/SOME/ALL sub-query

2019-07-31 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16897627#comment-16897627 ] Vineet Garg commented on CALCITE-3031: -- [~julianhyde] I have created CALCITE-3222

[jira] [Created] (CALCITE-3733) MySQL JDBC rewrite should rewrite CAST as TIMESTAMP to CAST as DATETIME

2020-01-14 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3733: Summary: MySQL JDBC rewrite should rewrite CAST as TIMESTAMP to CAST as DATETIME Key: CALCITE-3733 URL: https://issues.apache.org/jira/browse/CALCITE-3733 Project: Ca

[jira] [Created] (CALCITE-3734) MySQL JDBC rewrite is producing queries with CHAR with range beyond 255

2020-01-14 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3734: Summary: MySQL JDBC rewrite is producing queries with CHAR with range beyond 255 Key: CALCITE-3734 URL: https://issues.apache.org/jira/browse/CALCITE-3734 Project: Ca

[jira] [Commented] (CALCITE-3734) MySQL JDBC rewrite is producing queries with CHAR with range beyond 255

2020-02-25 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17044870#comment-17044870 ] Vineet Garg commented on CALCITE-3734: -- bq. let's add a mechanism to add per-provi

[jira] [Created] (CALCITE-3824) JoinProjectTransposeRule should skip Projects containing windowing expression

2020-02-25 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3824: Summary: JoinProjectTransposeRule should skip Projects containing windowing expression Key: CALCITE-3824 URL: https://issues.apache.org/jira/browse/CALCITE-3824 Proje

[jira] [Commented] (CALCITE-3824) JoinProjectTransposeRule should skip Projects containing windowing expression

2020-02-25 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17045077#comment-17045077 ] Vineet Garg commented on CALCITE-3824: -- [~jcamachorodriguez] Did you mean to close

[jira] [Commented] (CALCITE-3824) JoinProjectTransposeRule should skip Projects containing windowing expression

2020-02-28 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17047860#comment-17047860 ] Vineet Garg commented on CALCITE-3824: -- [~jcamachorodriguez] Pull request for this

[jira] [Commented] (CALCITE-3824) JoinProjectTransposeRule should skip Projects containing windowing expression

2020-02-28 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17047901#comment-17047901 ] Vineet Garg commented on CALCITE-3824: -- That sounds ok to me, we can keep the pull

[jira] [Created] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3848: Summary: Materialized view rewriting fails for mv consisting of group by on join keys Key: CALCITE-3848 URL: https://issues.apache.org/jira/browse/CALCITE-3848 Projec

[jira] [Updated] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3848: - Description: Test case {code:java} + @Test public void testAggregateOnJoinKeys() { +checkM

[jira] [Commented] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17055457#comment-17055457 ] Vineet Garg commented on CALCITE-3848: -- Please ignore the first pull request #1851

[jira] [Commented] (CALCITE-3848) Materialized view rewriting fails for mv consisting of group by on join keys

2020-03-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17055459#comment-17055459 ] Vineet Garg commented on CALCITE-3848: -- [~jcamachorodriguez] can you take a look p

[jira] [Created] (CALCITE-3862) Rewriting for materialized view consisting of group by on join keys with aggregate fails

2020-03-15 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3862: Summary: Rewriting for materialized view consisting of group by on join keys with aggregate fails Key: CALCITE-3862 URL: https://issues.apache.org/jira/browse/CALCITE-3862

[jira] [Updated] (CALCITE-3862) Rewriting for materialized view consisting of group by on join keys with aggregate fails

2020-03-15 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3862: - Description: *Repro* {code:sql} +sql("select \"deptno\", \"empid\", \"salary\", sum(1) " +

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-04-01 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073268#comment-17073268 ] Vineet Garg commented on CALCITE-3890: -- As [~kgyrtkirk] pointed out we have doing

[jira] [Created] (CALCITE-3914) Improve SubsitutionVisitor to consider RexCall of type PLUS and TIMES for canonicalization

2020-04-10 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3914: Summary: Improve SubsitutionVisitor to consider RexCall of type PLUS and TIMES for canonicalization Key: CALCITE-3914 URL: https://issues.apache.org/jira/browse/CALCITE-3914

[jira] [Commented] (CALCITE-3918) SubQueryFilterRemoveRule failed to decorrelate subquery for TPCH q17

2020-04-19 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17087313#comment-17087313 ] Vineet Garg commented on CALCITE-3918: -- [~hyuan] How do I disable the RelDecorrela

[jira] [Commented] (CALCITE-3918) SubQueryFilterRemoveRule failed to decorrelate subquery for TPCH q17

2020-04-19 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17087316#comment-17087316 ] Vineet Garg commented on CALCITE-3918: -- Thanks [~hyuan]. I am confused about this.

[jira] [Commented] (CALCITE-3918) SubQueryFilterRemoveRule failed to decorrelate subquery for TPCH q17

2020-04-19 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17087319#comment-17087319 ] Vineet Garg commented on CALCITE-3918: -- SubQueryFilterRemoveRule can not decorrela

[jira] [Commented] (CALCITE-3928) Canonicalization doesn't do field trimming before materialized view matching

2020-04-19 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17087322#comment-17087322 ] Vineet Garg commented on CALCITE-3928: -- [~jinxing6...@126.com] Can you provide the

[jira] [Updated] (CALCITE-3928) Canonicalization doesn't do field trimming before materialized view matching

2020-04-19 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated CALCITE-3928: - Labels: materializedviews (was: ) > Canonicalization doesn't do field trimming before material

[jira] [Created] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-22 Thread Vineet Garg (Jira)
Vineet Garg created CALCITE-3952: Summary: Improve SortRemoveRule to remove Sort based on rowcount Key: CALCITE-3952 URL: https://issues.apache.org/jira/browse/CALCITE-3952 Project: Calcite I

[jira] [Commented] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17090219#comment-17090219 ] Vineet Garg commented on CALCITE-3952: -- [~hyuan] In that case we shouldn't remove

[jira] [Commented] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17090222#comment-17090222 ] Vineet Garg commented on CALCITE-3952: -- BTW do you know how can I add test to {{Re

[jira] [Commented] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17090238#comment-17090238 ] Vineet Garg commented on CALCITE-3952: -- No problem [~hyuan] :) It looks like calc

[jira] [Commented] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17090992#comment-17090992 ] Vineet Garg commented on CALCITE-3952: -- Thanks for the feedback [~julianhyde]. I h

[jira] [Commented] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17090994#comment-17090994 ] Vineet Garg commented on CALCITE-3952: -- bq. Given a rel which emit at most 1 row (

[jira] [Commented] (CALCITE-3952) Improve SortRemoveRule to remove Sort based on rowcount

2020-04-25 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17092313#comment-17092313 ] Vineet Garg commented on CALCITE-3952: -- I have updated the pull request. Appreciat

[jira] [Commented] (CALCITE-2071) Query with IN operators in WHERE clause returns wrong result

2017-12-06 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16280673#comment-16280673 ] Vineet Garg commented on CALCITE-2071: -- HI [~julianhyde] Sure let me take a look at

[jira] [Commented] (CALCITE-2071) Query with IN operators in WHERE clause returns wrong result

2017-12-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16283098#comment-16283098 ] Vineet Garg commented on CALCITE-2071: -- Sorry I haven't gotten time to look at it y

[jira] [Commented] (CALCITE-2071) Query with IN operators in WHERE clause returns wrong result

2017-12-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16286874#comment-16286874 ] Vineet Garg commented on CALCITE-2071: -- I took a look at it. I believe the issue is

[jira] [Commented] (CALCITE-2071) Query with IN and OR in WHERE clause returns wrong result

2017-12-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16288103#comment-16288103 ] Vineet Garg commented on CALCITE-2071: -- [~julianhyde] Thanks for looking at it. Thi

[jira] [Commented] (CALCITE-2071) Query with IN and OR in WHERE clause returns wrong result

2017-12-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16288206#comment-16288206 ] Vineet Garg commented on CALCITE-2071: -- [~julianhyde] [~vvysotskyi] I have updated

  1   2   >