[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

[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] [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] [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

[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

[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:

[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:

[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

[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] [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

[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] [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

[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

[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] [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:

[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

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

2017-03-28 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1726: Summary: Subquery in FILTER is left untransformed Key: CALCITE-1726 URL: https://issues.apache.org/jira/browse/CALCITE-1726 Project: Calcite Issue Type:

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

2017-02-08 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1624: Summary: Inefficient plan for NOT IN correlated subqueries Key: CALCITE-1624 URL: https://issues.apache.org/jira/browse/CALCITE-1624 Project: Calcite Issue

[jira] [Created] (CALCITE-1605) Wrong result/plan for correlated subquery with windowing

2017-01-25 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1605: Summary: Wrong result/plan for correlated subquery with windowing Key: CALCITE-1605 URL: https://issues.apache.org/jira/browse/CALCITE-1605 Project: Calcite

[jira] [Created] (CALCITE-1583) Wrong results for query with correlated subqueries with aggregate subquery expression

2017-01-17 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1583: Summary: Wrong results for query with correlated subqueries with aggregate subquery expression Key: CALCITE-1583 URL: https://issues.apache.org/jira/browse/CALCITE-1583

[jira] [Created] (CALCITE-1546) Wrong result/plan for NOT IN subqueries with disjunction

2016-12-19 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1546: Summary: Wrong result/plan for NOT IN subqueries with disjunction Key: CALCITE-1546 URL: https://issues.apache.org/jira/browse/CALCITE-1546 Project: Calcite

[jira] [Created] (CALCITE-1542) Update RelShuttle interface to work on Filter, Join etc instead of Logical rel nodes

2016-12-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1542: Summary: Update RelShuttle interface to work on Filter, Join etc instead of Logical rel nodes Key: CALCITE-1542 URL: https://issues.apache.org/jira/browse/CALCITE-1542

[jira] [Created] (CALCITE-1541) Update RelDecorrelator to work on Filter, Join, Project etc

2016-12-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1541: Summary: Update RelDecorrelator to work on Filter, Join, Project etc Key: CALCITE-1541 URL: https://issues.apache.org/jira/browse/CALCITE-1541 Project: Calcite

[jira] [Created] (CALCITE-1537) Un-necessary project expression in multi-subquery plan

2016-12-12 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1537: Summary: Un-necessary project expression in multi-subquery plan Key: CALCITE-1537 URL: https://issues.apache.org/jira/browse/CALCITE-1537 Project: Calcite

[jira] [Created] (CALCITE-1511) RelDecorrelator's allLessThan failing for NOT EXISTS subquery

2016-11-28 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1511: Summary: RelDecorrelator's allLessThan failing for NOT EXISTS subquery Key: CALCITE-1511 URL: https://issues.apache.org/jira/browse/CALCITE-1511 Project: Calcite

[jira] [Created] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

2016-11-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1495: Summary: Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN Key: CALCITE-1495 URL: https://issues.apache.org/jira/browse/CALCITE-1495

[jira] [Created] (CALCITE-1494) Inefficient plan for co-related subqueries

2016-11-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1494: Summary: Inefficient plan for co-related subqueries Key: CALCITE-1494 URL: https://issues.apache.org/jira/browse/CALCITE-1494 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-1493) Wrong plan for NOT IN correlated queries

2016-11-15 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1493: Summary: Wrong plan for NOT IN correlated queries Key: CALCITE-1493 URL: https://issues.apache.org/jira/browse/CALCITE-1493 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-1483) Suboptimal plan for NOT IN query

2016-11-07 Thread Vineet Garg (JIRA)
Vineet Garg created CALCITE-1483: Summary: Suboptimal plan for NOT IN query Key: CALCITE-1483 URL: https://issues.apache.org/jira/browse/CALCITE-1483 Project: Calcite Issue Type: Bug