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

Jin Xing created CALCITE-3928: - Summary: Canonicalization doesn't do field trimming before materialized matching Key: CALCITE-3928 URL: https://issues.apache.org/jira/browse/CALCITE-3928 Project: Calcite

[jira] [Created] (CALCITE-3925) Support materialized view matching for LogicalCorrelate in SubsitutionVisitor

Jin Xing created CALCITE-3925: - Summary: Support materialized view matching for LogicalCorrelate in SubsitutionVisitor Key: CALCITE-3925 URL: https://issues.apache.org/jira/browse/CALCITE-3925 Project:

[jira] [Created] (CALCITE-3760) Rewriting function without considering determinism can break query semantics

Jin Xing created CALCITE-3760: - Summary: Rewriting function without considering determinism can break query semantics Key: CALCITE-3760 URL: https://issues.apache.org/jira/browse/CALCITE-3760 Project:

[jira] [Created] (CALCITE-3758) FilterTableScanRule generate wrong mapping for filter condition when underlying is BindableTableScan

Jin Xing created CALCITE-3758: - Summary: FilterTableScanRule generate wrong mapping for filter condition when underlying is BindableTableScan Key: CALCITE-3758 URL: https://issues.apache.org/jira/browse/CALCITE-3758

[jira] [Created] (CALCITE-3729) Filters failed to be pushed down when it's identical to join condition.

Jin Xing created CALCITE-3729: - Summary: Filters failed to be pushed down when it's identical to join condition. Key: CALCITE-3729 URL: https://issues.apache.org/jira/browse/CALCITE-3729 Project: Calcite

[jira] [Created] (CALCITE-3727) Deduce nullability of RelDataTypeField for Join

Jin Xing created CALCITE-3727: - Summary: Deduce nullability of RelDataTypeField for Join Key: CALCITE-3727 URL: https://issues.apache.org/jira/browse/CALCITE-3727 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3667) EnumerableMergeJoin should not use take-while enumerator

Jin Xing created CALCITE-3667: - Summary: EnumerableMergeJoin should not use take-while enumerator Key: CALCITE-3667 URL: https://issues.apache.org/jira/browse/CALCITE-3667 Project: Calcite

[jira] [Created] (CALCITE-3658) TableModify of Update contains correlated variable by mistake.

Jin Xing created CALCITE-3658: - Summary: TableModify of Update contains correlated variable by mistake. Key: CALCITE-3658 URL: https://issues.apache.org/jira/browse/CALCITE-3658 Project: Calcite

[jira] [Created] (CALCITE-3549) Lex config for view expanding is not supported

Jin Xing created CALCITE-3549: - Summary: Lex config for view expanding is not supported Key: CALCITE-3549 URL: https://issues.apache.org/jira/browse/CALCITE-3549 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3536) Wrong semantics in CoalesceImplementor

Jin Xing created CALCITE-3536: - Summary: Wrong semantics in CoalesceImplementor Key: CALCITE-3536 URL: https://issues.apache.org/jira/browse/CALCITE-3536 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

Jin Xing created CALCITE-3505: - Summary: Infinite matching of FilterProjectTransposeRule causes stackoverflow Key: CALCITE-3505 URL: https://issues.apache.org/jira/browse/CALCITE-3505 Project: Calcite

[jira] [Created] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

Jin Xing created CALCITE-3495: - Summary: RelDecorrelator generate plan with different semantics when handle Aggregate Key: CALCITE-3495 URL: https://issues.apache.org/jira/browse/CALCITE-3495 Project:

[jira] [Created] (CALCITE-3478) Reconstructure of materialized view tests.

Jin Xing created CALCITE-3478: - Summary: Reconstructure of materialized view tests. Key: CALCITE-3478 URL: https://issues.apache.org/jira/browse/CALCITE-3478 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3448) AggregateOnProjectToAggregateUnifyRule ignores Project incorrectly when there's missing grouping or mapping breaks ordering

jin xing created CALCITE-3448: - Summary: AggregateOnProjectToAggregateUnifyRule ignores Project incorrectly when there's missing grouping or mapping breaks ordering Key: CALCITE-3448 URL:

[jira] [Created] (CALCITE-3439) Support Intersect and Minus in RelMdPredicates

jin xing created CALCITE-3439: - Summary: Support Intersect and Minus in RelMdPredicates Key: CALCITE-3439 URL: https://issues.apache.org/jira/browse/CALCITE-3439 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is natural distinct on join keys

jin xing created CALCITE-3431: - Summary: SemiJoinRule doesn't work when right-hand side is natural distinct on join keys Key: CALCITE-3431 URL: https://issues.apache.org/jira/browse/CALCITE-3431 Project:

[jira] [Created] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

jin xing created CALCITE-3428: - Summary: Refine RelMdColumnUniqueness for Filter by considering constant columns Key: CALCITE-3428 URL: https://issues.apache.org/jira/browse/CALCITE-3428 Project: Calcite

[jira] [Created] (CALCITE-3409) Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule

jin xing created CALCITE-3409: - Summary: Add an interface in MaterializedViewSubstitutionVisitor to allow registering UnifyRule Key: CALCITE-3409 URL: https://issues.apache.org/jira/browse/CALCITE-3409

[jira] [Created] (CALCITE-3405) Pruning columns for ProjectableFilterable when project is not simple mapping

jin xing created CALCITE-3405: - Summary: Pruning columns for ProjectableFilterable when project is not simple mapping Key: CALCITE-3405 URL: https://issues.apache.org/jira/browse/CALCITE-3405 Project:

[jira] [Created] (CALCITE-3399) RelFieldTrimmer trim fields for UNION, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL

jin xing created CALCITE-3399: - Summary: RelFieldTrimmer trim fields for UNION, INTERSECT, INTERSECT ALL, EXCEPT, EXCEPT ALL Key: CALCITE-3399 URL: https://issues.apache.org/jira/browse/CALCITE-3399

[jira] [Created] (CALCITE-3396) Materialization matching succeeds when query and view are both of UNION but have different 'all' property

jin xing created CALCITE-3396: - Summary: Materialization matching succeeds when query and view are both of UNION but have different 'all' property Key: CALCITE-3396 URL:

[jira] [Created] (CALCITE-3373) Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join

jin xing created CALCITE-3373: - Summary: Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join Key: CALCITE-3373 URL: https://issues.apache.org/jira/browse/CALCITE-3373

[jira] [Created] (CALCITE-3367) Add AntiJoinRule to convert project-filter-join-aggregate into anti-join

jin xing created CALCITE-3367: - Summary: Add AntiJoinRule to convert project-filter-join-aggregate into anti-join Key: CALCITE-3367 URL: https://issues.apache.org/jira/browse/CALCITE-3367 Project:

[jira] [Created] (CALCITE-3366) RelDecorrelator supports Union

jin xing created CALCITE-3366: - Summary: RelDecorrelator supports Union Key: CALCITE-3366 URL: https://issues.apache.org/jira/browse/CALCITE-3366 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-3363) JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join

jin xing created CALCITE-3363: - Summary: JoinUnionTransposeRule.RIGHT_UNION should not match SEMI/ANTI Join Key: CALCITE-3363 URL: https://issues.apache.org/jira/browse/CALCITE-3363 Project: Calcite

[jira] [Created] (CALCITE-3357) Trivial null checking in RelSet#addAbstractConverters

jin xing created CALCITE-3357: - Summary: Trivial null checking in RelSet#addAbstractConverters Key: CALCITE-3357 URL: https://issues.apache.org/jira/browse/CALCITE-3357 Project: Calcite Issue

[jira] [Created] (CALCITE-3334) Refinement for Substitution-Based MV Matching

jin xing created CALCITE-3334: - Summary: Refinement for Substitution-Based MV Matching Key: CALCITE-3334 URL: https://issues.apache.org/jira/browse/CALCITE-3334 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3292) SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate.

jin xing created CALCITE-3292: - Summary: SqlToRelConverter#substituteSubQuery fails with NullPointerException when converting SqlUpdate. Key: CALCITE-3292 URL: https://issues.apache.org/jira/browse/CALCITE-3292

[jira] [Created] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

jin xing created CALCITE-3276: - Summary: Add MV rules to match Join on compensating Project(s) Key: CALCITE-3276 URL: https://issues.apache.org/jira/browse/CALCITE-3276 Project: Calcite Issue

[jira] [Created] (CALCITE-3274) Add FilterOnProjectToFilterUnifyRule for materialization matching

jin xing created CALCITE-3274: - Summary: Add FilterOnProjectToFilterUnifyRule for materialization matching Key: CALCITE-3274 URL: https://issues.apache.org/jira/browse/CALCITE-3274 Project: Calcite

[jira] [Created] (CALCITE-3273) Materialization matching rules that consider compensating MutableProject

jin xing created CALCITE-3273: - Summary: Materialization matching rules that consider compensating MutableProject Key: CALCITE-3273 URL: https://issues.apache.org/jira/browse/CALCITE-3273 Project:

[jira] [Created] (CALCITE-3262) Refine doc of SubstitutionVisitor.java

jin xing created CALCITE-3262: - Summary: Refine doc of SubstitutionVisitor.java Key: CALCITE-3262 URL: https://issues.apache.org/jira/browse/CALCITE-3262 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

jin xing created CALCITE-3256: - Summary: Add ProjectOnProjectToProjectUnifyRule for materialization matching. Key: CALCITE-3256 URL: https://issues.apache.org/jira/browse/CALCITE-3256 Project: Calcite

[jira] [Created] (CALCITE-3249) Substitution#getRexShuttle does not consider RexLiteral

jin xing created CALCITE-3249: - Summary: Substitution#getRexShuttle does not consider RexLiteral Key: CALCITE-3249 URL: https://issues.apache.org/jira/browse/CALCITE-3249 Project: Calcite Issue

[jira] [Created] (CALCITE-3239) Calc#accept(RexShuttle shuttle) does not update rowType

jin xing created CALCITE-3239: - Summary: Calc#accept(RexShuttle shuttle) does not update rowType Key: CALCITE-3239 URL: https://issues.apache.org/jira/browse/CALCITE-3239 Project: Calcite Issue

[jira] [Created] (CALCITE-3226) RelBuilder doesn't keep the alias when scan from an expanded view

jin xing created CALCITE-3226: - Summary: RelBuilder doesn't keep the alias when scan from an expanded view Key: CALCITE-3226 URL: https://issues.apache.org/jira/browse/CALCITE-3226 Project: Calcite

[jira] [Created] (CALCITE-3223) Non-RexInputRef may fails the matching of FilterToProjectUnifyRule during 'invert' by mistake.

jin xing created CALCITE-3223: - Summary: Non-RexInputRef may fails the matching of FilterToProjectUnifyRule during 'invert' by mistake. Key: CALCITE-3223 URL: https://issues.apache.org/jira/browse/CALCITE-3223

[jira] [Created] (CALCITE-3214) Add UnionToUnionRule for materialization matching

jin xing created CALCITE-3214: - Summary: Add UnionToUnionRule for materialization matching Key: CALCITE-3214 URL: https://issues.apache.org/jira/browse/CALCITE-3214 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-3211) MutableRel returned from MutableRels::toMutables may lose reference to parent

jin xing created CALCITE-3211: - Summary: MutableRel returned from MutableRels::toMutables may lose reference to parent Key: CALCITE-3211 URL: https://issues.apache.org/jira/browse/CALCITE-3211 Project:

[jira] [Created] (CALCITE-3209) Store inputs of MutableMultiRel by ArrayList rather than ImmutableList

jin xing created CALCITE-3209: - Summary: Store inputs of MutableMultiRel by ArrayList rather than ImmutableList Key: CALCITE-3209 URL: https://issues.apache.org/jira/browse/CALCITE-3209 Project: Calcite

[jira] [Created] (CALCITE-3206) Better error message when param type incompatibility

jin xing created CALCITE-3206: - Summary: Better error message when param type incompatibility Key: CALCITE-3206 URL: https://issues.apache.org/jira/browse/CALCITE-3206 Project: Calcite Issue

[jira] [Created] (CALCITE-3203) When matching materializations, match Project with child of Aggregate

jin xing created CALCITE-3203: - Summary: When matching materializations, match Project with child of Aggregate Key: CALCITE-3203 URL: https://issues.apache.org/jira/browse/CALCITE-3203 Project: Calcite

[jira] [Created] (CALCITE-3197) Convert data of Timestamp/Time/Date as original form when enumerating from ArrayTable

jin xing created CALCITE-3197: - Summary: Convert data of Timestamp/Time/Date as original form when enumerating from ArrayTable Key: CALCITE-3197 URL: https://issues.apache.org/jira/browse/CALCITE-3197

[jira] [Created] (CALCITE-3182) Trim unused fields for plan of materialized-view before matching.

jin xing created CALCITE-3182: - Summary: Trim unused fields for plan of materialized-view before matching. Key: CALCITE-3182 URL: https://issues.apache.org/jira/browse/CALCITE-3182 Project: Calcite

[jira] [Created] (CALCITE-3167) Remove redundant overriding methods of equals in EnumerableTableScan.java

jin xing created CALCITE-3167: - Summary: Remove redundant overriding methods of equals in EnumerableTableScan.java Key: CALCITE-3167 URL: https://issues.apache.org/jira/browse/CALCITE-3167 Project:

[jira] [Created] (CALCITE-2997) Avoid pushing down join condition in SqlToRelConverter

jin xing created CALCITE-2997: - Summary: Avoid pushing down join condition in SqlToRelConverter Key: CALCITE-2997 URL: https://issues.apache.org/jira/browse/CALCITE-2997 Project: Calcite Issue