[jira] [Created] (CALCITE-6143) RelBuilder.aggregate pruneInputOfAggregate+dedupAggregateCalls blocks can be wrong if both trigger

Steven Talbot created CALCITE-6143: -- Summary: RelBuilder.aggregate pruneInputOfAggregate+dedupAggregateCalls blocks can be wrong if both trigger Key: CALCITE-6143 URL:

[jira] [Created] (CALCITE-6086) SqlImplementor does not properly handle SAFE_CAST

Steven Talbot created CALCITE-6086: -- Summary: SqlImplementor does not properly handle SAFE_CAST Key: CALCITE-6086 URL: https://issues.apache.org/jira/browse/CALCITE-6086 Project: Calcite

[jira] [Created] (CALCITE-6085) RelBuilder.aggregate_ "pruneInputOfAggregate" logic needs to discard unused top of stack

Steven Talbot created CALCITE-6085: -- Summary: RelBuilder.aggregate_ "pruneInputOfAggregate" logic needs to discard unused top of stack Key: CALCITE-6085 URL: https://issues.apache.org/jira/browse/CALCITE-6085

[jira] [Created] (CALCITE-5856) ARG0_NULLABLE_IF_EMPTY should consider GROUPING SETS (.., ())

Steven Talbot created CALCITE-5856: -- Summary: ARG0_NULLABLE_IF_EMPTY should consider GROUPING SETS (.., ()) Key: CALCITE-5856 URL: https://issues.apache.org/jira/browse/CALCITE-5856 Project: Calcite

[jira] [Created] (CALCITE-5846) AggregateExpandWithinDistinctRule drops filters on non-distinct aggCalls

Steven Talbot created CALCITE-5846: -- Summary: AggregateExpandWithinDistinctRule drops filters on non-distinct aggCalls Key: CALCITE-5846 URL: https://issues.apache.org/jira/browse/CALCITE-5846

[jira] [Created] (CALCITE-5696) Support trailing comma in SELECT list for Babel parser (like BigQuery)

Steven Talbot created CALCITE-5696: -- Summary: Support trailing comma in SELECT list for Babel parser (like BigQuery) Key: CALCITE-5696 URL: https://issues.apache.org/jira/browse/CALCITE-5696

[jira] [Created] (CALCITE-5330) TIMESTAMPDIFF call cannot work with RelJson

Steven Talbot created CALCITE-5330: -- Summary: TIMESTAMPDIFF call cannot work with RelJson Key: CALCITE-5330 URL: https://issues.apache.org/jira/browse/CALCITE-5330 Project: Calcite Issue

[jira] [Created] (CALCITE-5311) SqlNode.parserPosition missing closing ')' for expression subquery

Steven Talbot created CALCITE-5311: -- Summary: SqlNode.parserPosition missing closing ')' for expression subquery Key: CALCITE-5311 URL: https://issues.apache.org/jira/browse/CALCITE-5311 Project:

[jira] [Created] (CALCITE-5254) Infinite Loop in SubstituionVisitor.go

Steven Talbot created CALCITE-5254: -- Summary: Infinite Loop in SubstituionVisitor.go Key: CALCITE-5254 URL: https://issues.apache.org/jira/browse/CALCITE-5254 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-5222) Support more EXTRACT field values (or allow arbitrary in parse?)

Steven Talbot created CALCITE-5222: -- Summary: Support more EXTRACT field values (or allow arbitrary in parse?) Key: CALCITE-5222 URL: https://issues.apache.org/jira/browse/CALCITE-5222 Project:

[jira] [Created] (CALCITE-5207) SubstitutionVisitor should not canonicalize DatetimePlus

Steven Talbot created CALCITE-5207: -- Summary: SubstitutionVisitor should not canonicalize DatetimePlus Key: CALCITE-5207 URL: https://issues.apache.org/jira/browse/CALCITE-5207 Project: Calcite

[jira] [Created] (CALCITE-5200) FILTER_INTO_JOIN rule in RelOptMaterializations is too "smart"

Steven Talbot created CALCITE-5200: -- Summary: FILTER_INTO_JOIN rule in RelOptMaterializations is too "smart" Key: CALCITE-5200 URL: https://issues.apache.org/jira/browse/CALCITE-5200 Project:

[jira] [Created] (CALCITE-5183) Impossible condition in return type inference for SqlIntervalOperator?

Steven Talbot created CALCITE-5183: -- Summary: Impossible condition in return type inference for SqlIntervalOperator? Key: CALCITE-5183 URL: https://issues.apache.org/jira/browse/CALCITE-5183

[jira] [Created] (CALCITE-5179) supportsAliasedValues() false generates assertion-failing UNION ALL SqlNode

Steven Talbot created CALCITE-5179: -- Summary: supportsAliasedValues() false generates assertion-failing UNION ALL SqlNode Key: CALCITE-5179 URL: https://issues.apache.org/jira/browse/CALCITE-5179

[jira] [Created] (CALCITE-5147) Parser configured with BigQuery dialect cannot parse timestamp literal

Steven Talbot created CALCITE-5147: -- Summary: Parser configured with BigQuery dialect cannot parse timestamp literal Key: CALCITE-5147 URL: https://issues.apache.org/jira/browse/CALCITE-5147

[jira] [Created] (CALCITE-4760) Should not need to initialize a jdbc:calcite driver to make a RelBuilder

Steven Talbot created CALCITE-4760: -- Summary: Should not need to initialize a jdbc:calcite driver to make a RelBuilder Key: CALCITE-4760 URL: https://issues.apache.org/jira/browse/CALCITE-4760

[jira] [Created] (CALCITE-4632) Exception in RelToSqlConverter: "Cannot convert x to DECIMAL(n, m) due to overflow"

Steven Talbot created CALCITE-4632: -- Summary: Exception in RelToSqlConverter: "Cannot convert x to DECIMAL(n, m) due to overflow" Key: CALCITE-4632 URL: https://issues.apache.org/jira/browse/CALCITE-4632

[jira] [Created] (CALCITE-4631) sql->rel->sql bug with unparsing timestampdiff

Steven Talbot created CALCITE-4631: -- Summary: sql->rel->sql bug with unparsing timestampdiff Key: CALCITE-4631 URL: https://issues.apache.org/jira/browse/CALCITE-4631 Project: Calcite Issue

[jira] [Created] (CALCITE-4610) Sarg in JOIN -> AssertionError in RelToSqlConverter

Steven Talbot created CALCITE-4610: -- Summary: Sarg in JOIN -> AssertionError in RelToSqlConverter Key: CALCITE-4610 URL: https://issues.apache.org/jira/browse/CALCITE-4610 Project: Calcite

[jira] [Created] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

Steven Talbot created CALCITE-4495: -- Summary: Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException Key: CALCITE-4495 URL: https://issues.apache.org/jira/browse/CALCITE-4495

[jira] [Created] (CALCITE-4249) Assertion error for NOT operator in Rel2SqlConverter

Steven Talbot created CALCITE-4249: -- Summary: Assertion error for NOT operator in Rel2SqlConverter Key: CALCITE-4249 URL: https://issues.apache.org/jira/browse/CALCITE-4249 Project: Calcite

[jira] [Created] (CALCITE-4209) RelBuilder: ability to avoid generating empty() on limit 0

Steven Talbot created CALCITE-4209: -- Summary: RelBuilder: ability to avoid generating empty() on limit 0 Key: CALCITE-4209 URL: https://issues.apache.org/jira/browse/CALCITE-4209 Project: Calcite

[jira] [Created] (CALCITE-4165) RelToSqlConverter fails on literal, untyped nulls

Steven Talbot created CALCITE-4165: -- Summary: RelToSqlConverter fails on literal, untyped nulls Key: CALCITE-4165 URL: https://issues.apache.org/jira/browse/CALCITE-4165 Project: Calcite

[jira] [Created] (CALCITE-4159) RexSimplify should simplify more always true OR expressions

Steven Talbot created CALCITE-4159: -- Summary: RexSimplify should simplify more always true OR expressions Key: CALCITE-4159 URL: https://issues.apache.org/jira/browse/CALCITE-4159 Project: Calcite

[jira] [Created] (CALCITE-4148) MaterializedViewAggregateRule invalid optimization with time unit "rollupable" column in query

Steven Talbot created CALCITE-4148: -- Summary: MaterializedViewAggregateRule invalid optimization with time unit "rollupable" column in query Key: CALCITE-4148 URL:

[jira] [Created] (CALCITE-4090) DB2 aliasing breaks with a complex select above a subselect

Steven Talbot created CALCITE-4090: -- Summary: DB2 aliasing breaks with a complex select above a subselect Key: CALCITE-4090 URL: https://issues.apache.org/jira/browse/CALCITE-4090 Project: Calcite

[jira] [Created] (CALCITE-4081) Round-tripping a DECIMAL literal through Planner -> RelToSqlConverter -> Planner throws validation error

Steven Talbot created CALCITE-4081: -- Summary: Round-tripping a DECIMAL literal through Planner -> RelToSqlConverter -> Planner throws validation error Key: CALCITE-4081 URL:

[jira] [Created] (CALCITE-3975) ProjectFilterTransposeRule should fire for project that happens to reference all input columns

Steven Talbot created CALCITE-3975: -- Summary: ProjectFilterTransposeRule should fire for project that happens to reference all input columns Key: CALCITE-3975 URL:

[jira] [Created] (CALCITE-3957) AggregateMergeRule should be able to merge SUM0 into COUNT even with empty group by

Steven Talbot created CALCITE-3957: -- Summary: AggregateMergeRule should be able to merge SUM0 into COUNT even with empty group by Key: CALCITE-3957 URL: https://issues.apache.org/jira/browse/CALCITE-3957

[jira] [Created] (CALCITE-3936) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

Steven Talbot created CALCITE-3936: -- Summary: RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate Key: CALCITE-3936 URL:

[jira] [Created] (CALCITE-3922) ProjectRemoveRule drops aliases when used with HepPlanner

Steven Talbot created CALCITE-3922: -- Summary: ProjectRemoveRule drops aliases when used with HepPlanner Key: CALCITE-3922 URL: https://issues.apache.org/jira/browse/CALCITE-3922 Project: Calcite

[jira] [Created] (CALCITE-3877) Null lowerBound/upperBond in RexWindow causes NPE in RexShuttle

Steven Talbot created CALCITE-3877: -- Summary: Null lowerBound/upperBond in RexWindow causes NPE in RexShuttle Key: CALCITE-3877 URL: https://issues.apache.org/jira/browse/CALCITE-3877 Project:

[jira] [Created] (CALCITE-3876) Should not combine projects when top project contains window function referencing window function from bottom project

Steven Talbot created CALCITE-3876: -- Summary: Should not combine projects when top project contains window function referencing window function from bottom project Key: CALCITE-3876 URL:

[jira] [Created] (CALCITE-3831) AbstractMaterializedViewRule throws exception with an Aggregate on a Project projecting duplicate RexNodes

Steven Talbot created CALCITE-3831: -- Summary: AbstractMaterializedViewRule throws exception with an Aggregate on a Project projecting duplicate RexNodes Key: CALCITE-3831 URL:

[jira] [Created] (CALCITE-3593) RelToSqlConverter changes target of ambiguous having clause with a Project on top of an Aggregate

Steven Talbot created CALCITE-3593: -- Summary: RelToSqlConverter changes target of ambiguous having clause with a Project on top of an Aggregate Key: CALCITE-3593 URL:

[jira] [Created] (CALCITE-3475) BigQuery SQL dialect unparseCall override broken for UNION ALL

Steven Talbot created CALCITE-3475: -- Summary: BigQuery SQL dialect unparseCall override broken for UNION ALL Key: CALCITE-3475 URL: https://issues.apache.org/jira/browse/CALCITE-3475 Project:

[jira] [Created] (CALCITE-3440) RelToSqlConverter does not properly alias ambiguous ORDER BY

Steven Talbot created CALCITE-3440: -- Summary: RelToSqlConverter does not properly alias ambiguous ORDER BY Key: CALCITE-3440 URL: https://issues.apache.org/jira/browse/CALCITE-3440 Project: Calcite

[jira] [Created] (CALCITE-3416) SQL Dialects "DEFAULT"s should be more extensible

Steven Talbot created CALCITE-3416: -- Summary: SQL Dialects "DEFAULT"s should be more extensible Key: CALCITE-3416 URL: https://issues.apache.org/jira/browse/CALCITE-3416 Project: Calcite

[jira] [Created] (CALCITE-3147) BigQuery (standard SQL) quoting and identifier issues

Steven Talbot created CALCITE-3147: -- Summary: BigQuery (standard SQL) quoting and identifier issues Key: CALCITE-3147 URL: https://issues.apache.org/jira/browse/CALCITE-3147 Project: Calcite

[jira] [Created] (CALCITE-3145) Aggregate duplicate detection bug with group fields

Steven Talbot created CALCITE-3145: -- Summary: Aggregate duplicate detection bug with group fields Key: CALCITE-3145 URL: https://issues.apache.org/jira/browse/CALCITE-3145 Project: Calcite

[jira] [Created] (CALCITE-3097) GROUPING SETS breaks on sets of size > 1 due to precedence issues

Steven Talbot created CALCITE-3097: -- Summary: GROUPING SETS breaks on sets of size > 1 due to precedence issues Key: CALCITE-3097 URL: https://issues.apache.org/jira/browse/CALCITE-3097 Project:

[jira] [Created] (CALCITE-2912) MaterializedViewAggregateRule.pushFilterToOriginalViewPlan fails to use valid materialization given query with certain kinds of filter constants

Steven Talbot created CALCITE-2912: -- Summary: MaterializedViewAggregateRule.pushFilterToOriginalViewPlan fails to use valid materialization given query with certain kinds of filter constants Key: CALCITE-2912