[jira] [Created] (CALCITE-6595) AggregateExpandWithinDistinctRule drops aggregateCall.collation on non-distinct agg

2024-09-25 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-6595: -- Summary: AggregateExpandWithinDistinctRule drops aggregateCall.collation on non-distinct agg Key: CALCITE-6595 URL: https://issues.apache.org/jira/browse/CALCITE-6595

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

2023-11-29 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-6143: --- Description: {code:java} // pseudo-code repro case b.scan("table") .project(b.field(0), b

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

2023-11-29 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-6143: --- Description: {code:java} // pseudo-code repro case b.scan("table") .project(b.field(0), b

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

2023-11-29 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17791376#comment-17791376 ] Steven Talbot commented on CALCITE-6143: Not sure if my first link is quite jum

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

2023-11-29 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-6143: -- Summary: RelBuilder.aggregate pruneInputOfAggregate+dedupAggregateCalls blocks can be wrong if both trigger Key: CALCITE-6143 URL: https://issues.apache.org/jira/browse/CALCIT

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

2023-11-29 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17791371#comment-17791371 ] Steven Talbot commented on CALCITE-6086: Yep, seem like that is the same, thank

[jira] [Commented] (CALCITE-5948) Use explicit casting if element type in ARRAY/MAP does not equal derived component type

2023-11-16 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17786827#comment-17786827 ] Steven Talbot commented on CALCITE-5948: [~taoran] thanks for the response! Our

[jira] [Commented] (CALCITE-5948) Use explicit casting if element type in ARRAY/MAP does not equal derived component type

2023-11-15 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17786545#comment-17786545 ] Steven Talbot commented on CALCITE-5948: Looking through the commit, there does

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

2023-11-01 Thread Steven Talbot (Jira)
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 Iss

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

2023-11-01 Thread Steven Talbot (Jira)
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] [Updated] (CALCITE-5856) ARG0_NULLABLE_IF_EMPTY should consider GROUPING SETS (.., ())

2023-07-17 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-5856: --- Description: Currently, the rule switches off getGroupCount to determine if an aggregation

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

2023-07-17 Thread Steven Talbot (Jira)
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

2023-07-13 Thread Steven Talbot (Jira)
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 Projec

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

2023-05-10 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17721556#comment-17721556 ] Steven Talbot commented on CALCITE-5696: Testing quickly, it would seem the ans

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

2023-05-10 Thread Steven Talbot (Jira)
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 Project:

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

2022-10-12 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-5330: --- Description: The TIMESTAMPDIFF function parses out with TimeUnit, rather than TimeUnitRange

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

2022-10-12 Thread Steven Talbot (Jira)
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 Typ

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

2022-10-12 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot closed CALCITE-4631. -- Resolution: Duplicate Looks like I missed this is actually a dup > sql->rel->sql bug with un

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

2022-10-06 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17613782#comment-17613782 ] Steven Talbot commented on CALCITE-5311: The best fix I can think of is to move

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

2022-10-06 Thread Steven Talbot (Jira)
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: Cal

[jira] [Commented] (CALCITE-5254) Infinite Loop in SubstitutionVisitor.go

2022-09-04 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17600064#comment-17600064 ] Steven Talbot commented on CALCITE-5254: Ah, could be ultimately that. I’m unsu

[jira] [Commented] (CALCITE-5254) Infinite Loop in SubstitutionVisitor.go

2022-08-30 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597961#comment-17597961 ] Steven Talbot commented on CALCITE-5254: Also, given that the "fix" there relie

[jira] [Commented] (CALCITE-5254) Infinite Loop in SubstitutionVisitor.go

2022-08-30 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597958#comment-17597958 ] Steven Talbot commented on CALCITE-5254: The loop gets stuck because it is chec

[jira] [Updated] (CALCITE-5254) Infinite Loop in SubstitutionVisitor.go

2022-08-30 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-5254: --- Description: Happens when you have a materialization "target" of an Aggregate/Scan attempt

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

2022-08-30 Thread Steven Talbot (Jira)
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: Bu

[jira] [Updated] (CALCITE-5254) Infinite Loop in SubstitutionVisitor.go

2022-08-30 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-5254: --- Summary: Infinite Loop in SubstitutionVisitor.go (was: Infinite Loop in SubstituionVisitor

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

2022-07-29 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot resolved CALCITE-5222. Resolution: Duplicate > Support more EXTRACT field values (or allow arbitrary in parse?)

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

2022-07-29 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17572979#comment-17572979 ] Steven Talbot commented on CALCITE-5222: Ah, totally, and I see that it was mer

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

2022-07-28 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17572695#comment-17572695 ] Steven Talbot commented on CALCITE-5222: ^^ probably, sorry for missing that, t

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

2022-07-28 Thread Steven Talbot (Jira)
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: Calci

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

2022-07-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-5207: --- Description: >From CALCITE-3914, "canonicalizeNode" attempts to canonicalize any >SqlKind.

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

2022-07-11 Thread Steven Talbot (Jira)
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"

2022-06-26 Thread Steven Talbot (Jira)
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: Calcite

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

2022-06-21 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17557100#comment-17557100 ] Steven Talbot commented on CALCITE-5183: For the record, I did end up needing t

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

2022-06-07 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17551198#comment-17551198 ] Steven Talbot commented on CALCITE-5183: ^^ regardless of the ergonomics of tha

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

2022-06-06 Thread Steven Talbot (Jira)
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 Project:

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

2022-06-06 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-5183: --- Description: I could be wrong here, but I don't see how to make this work, and I don't see

[jira] [Commented] (CALCITE-5179) AssertionError in values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-04 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17548613#comment-17548613 ] Steven Talbot commented on CALCITE-5179: And thanks for the quick fix! > Asser

[jira] [Commented] (CALCITE-5179) AssertionError in values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-04 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17548579#comment-17548579 ] Steven Talbot commented on CALCITE-5179: Eh, I guess a binary tree would be no

[jira] [Commented] (CALCITE-5179) AssertionError in values with more than two items when SqlDialect#supportsAliasedValues is false

2022-06-04 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17548577#comment-17548577 ] Steven Talbot commented on CALCITE-5179: ^^ indeed, in fact in an ideal world U

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

2022-06-03 Thread Steven Talbot (Jira)
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 Pro

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

2022-05-10 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534510#comment-17534510 ] Steven Talbot commented on CALCITE-5147: The parser does not accept TIMESTAMP "

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

2022-05-10 Thread Steven Talbot (Jira)
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 Project:

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

2021-09-01 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4760: --- Description: We just tracked down a nasty issue with Calcite being shaded as a dependency i

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

2021-09-01 Thread Steven Talbot (Jira)
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 Projec

[jira] [Commented] (CALCITE-4485) Invalid SQL being produced by RelToSqlConverter when the join condition is tautology

2021-08-06 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17394828#comment-17394828 ] Steven Talbot commented on CALCITE-4485: Change seems good to me. A nit would b

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

2021-06-02 Thread Steven Talbot (Jira)
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] [Updated] (CALCITE-4631) sql->rel->sql bug with unparsing timestampdiff

2021-06-02 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4631: --- Description: e.g. the following test in RelToSqlConverter.java demonstrates the end-to-end

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

2021-06-02 Thread Steven Talbot (Jira)
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] [Commented] (CALCITE-4524) Make some fields non-nullable (SqlSelect.selectList, DataContext.getTypeFactory)

2021-06-01 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17355281#comment-17355281 ] Steven Talbot commented on CALCITE-4524: [~julianhyde] I believe this fixed a b

[jira] [Commented] (CALCITE-4620) Join on CASE causes AssertionError in RelToSqlConverter

2021-05-25 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17351260#comment-17351260 ] Steven Talbot commented on CALCITE-4620: I think that all makes sense. I certai

[jira] [Commented] (CALCITE-4620) join on non-reducible CASE causes AssertionError in RelToSqlConverter

2021-05-24 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17350655#comment-17350655 ] Steven Talbot commented on CALCITE-4620: Yep, I can repro, here's a test that b

[jira] [Commented] (CALCITE-4620) join on non-reducible CASE causes AssertionError in RelToSqlConverter

2021-05-24 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17350652#comment-17350652 ] Steven Talbot commented on CALCITE-4620: Actually, hold on, let me try to repro

[jira] [Updated] (CALCITE-4620) join on non-reducible CASE causes AssertionError in RelToSqlConverter

2021-05-24 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4620: --- Description: Basically  CALCITE-4610  but this time with a CASE WHEN.  I can provide a rep

[jira] [Created] (CALCITE-4620) join on non-reducible CASE causes AssertionError in RelToSqlConverter

2021-05-24 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-4620: -- Summary: join on non-reducible CASE causes AssertionError in RelToSqlConverter Key: CALCITE-4620 URL: https://issues.apache.org/jira/browse/CALCITE-4620 Project:

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

2021-05-18 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17347267#comment-17347267 ] Steven Talbot commented on CALCITE-4610: I'm not intimately familiar with SqlIm

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

2021-05-18 Thread Steven Talbot (Jira)
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 I

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

2021-02-12 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17283830#comment-17283830 ] Steven Talbot commented on CALCITE-4495: [~julianhyde] I think RexLiteral.value

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

2021-02-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4495: --- Description: Apologies. After spending an hour or so trying to write a simple repro for thi

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

2021-02-11 Thread Steven Talbot (Jira)
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] [Updated] (CALCITE-4249) Assertion error for NOT operator in join condition in Rel2SqlConverter

2020-09-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4249: --- Description: The following test shows the bug if you put it in RelToSqlConverter {code:java

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

2020-09-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17194546#comment-17194546 ] Steven Talbot commented on CALCITE-4249: Apologies if this is a dup (many thing

[jira] [Updated] (CALCITE-4249) Assertion error for NOT operator in join condition in Rel2SqlConverter

2020-09-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-4249: --- Summary: Assertion error for NOT operator in join condition in Rel2SqlConverter (was: Asse

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

2020-09-11 Thread Steven Talbot (Jira)
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

2020-09-01 Thread Steven Talbot (Jira)
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

2020-08-06 Thread Steven Talbot (Jira)
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 Iss

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

2020-08-05 Thread Steven Talbot (Jira)
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

2020-07-29 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-4148: -- Summary: MaterializedViewAggregateRule invalid optimization with time unit "rollupable" column in query Key: CALCITE-4148 URL: https://issues.apache.org/jira/browse/CALCITE-41

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

2020-06-24 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144498#comment-17144498 ] Steven Talbot edited comment on CALCITE-4090 at 6/24/20, 11:52 PM: --

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

2020-06-24 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17144498#comment-17144498 ] Steven Talbot commented on CALCITE-4090: There is a related case that is import

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

2020-06-24 Thread Steven Talbot (Jira)
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

2020-06-22 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-4081: -- Summary: Round-tripping a DECIMAL literal through Planner -> RelToSqlConverter -> Planner throws validation error Key: CALCITE-4081 URL: https://issues.apache.org/jira/browse/

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

2020-06-01 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17121395#comment-17121395 ] Steven Talbot commented on CALCITE-3975: I see. That all makes sense. To me at

[jira] [Comment Edited] (CALCITE-3975) ProjectFilterTransposeRule should succeed for project that happens to reference all input columns

2020-06-01 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17121395#comment-17121395 ] Steven Talbot edited comment on CALCITE-3975 at 6/1/20, 11:13 PM: ---

[jira] [Comment Edited] (CALCITE-3975) ProjectFilterTransposeRule should succeed for project that happens to reference all input columns

2020-06-01 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17121395#comment-17121395 ] Steven Talbot edited comment on CALCITE-3975 at 6/1/20, 11:13 PM: ---

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

2020-05-13 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17106592#comment-17106592 ] Steven Talbot commented on CALCITE-2997: cc [~julianhyde] I'd move to reopen t

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

2020-05-06 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3975: --- Description: ... that is, I think If I make the trivial fix of just "only skip trivial pro

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

2020-05-06 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3975: --- Summary: ProjectFilterTransposeRule should succeed for project that happens to reference al

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

2020-05-06 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-3975: -- Summary: ProjectFilterTransposeRule should fire for project that happens to reference all input columns Key: CALCITE-3975 URL: https://issues.apache.org/jira/browse/CALCITE-39

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

2020-04-24 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3957?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17091906#comment-17091906 ] Steven Talbot commented on CALCITE-3957: See some discussion where this was ori

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

2020-04-24 Thread Steven Talbot (Jira)
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] [Comment Edited] (CALCITE-3936) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

2020-04-17 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17086044#comment-17086044 ] Steven Talbot edited comment on CALCITE-3936 at 4/17/20, 8:24 PM: ---

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

2020-04-17 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17086044#comment-17086044 ] Steven Talbot commented on CALCITE-3936: Yes, the only bummer with (1) here is

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

2020-04-17 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-3936: -- Summary: RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate Key: CALCITE-3936 URL: https://issues.apache.org/jira/browse/CALCITE

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

2020-04-14 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17083514#comment-17083514 ] Steven Talbot commented on CALCITE-3922: Good point. I should probably just ren

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

2020-04-14 Thread Steven Talbot (Jira)
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] [Commented] (CALCITE-3877) Null lowerBound/upperBond in RexWindow causes NPE in RexShuttle

2020-03-26 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17068027#comment-17068027 ] Steven Talbot commented on CALCITE-3877: Would that fix mean there is no way to

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

2020-03-26 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17067904#comment-17067904 ] Steven Talbot edited comment on CALCITE-3876 at 3/26/20, 5:54 PM: ---

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

2020-03-26 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17067904#comment-17067904 ] Steven Talbot commented on CALCITE-3876: I see. I had not seen *_ProjectToWindo

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

2020-03-25 Thread Steven Talbot (Jira)
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: Calcit

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

2020-03-25 Thread Steven Talbot (Jira)
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: https://issues.apache.org

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

2020-02-26 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3831: --- Description: Note that this only happens when a rollup is required ("forceRollup" in the t

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

2020-02-26 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3831: --- Description: Note that this only happens when a rollup is required ("forceRollup" in the t

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

2020-02-26 Thread Steven Talbot (Jira)
Steven Talbot created CALCITE-3831: -- Summary: AbstractMaterializedViewRule throws exception with an Aggregate on a Project projecting duplicate RexNodes Key: CALCITE-3831 URL: https://issues.apache.org/jira/brows

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

2019-12-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3593: --- Description: Best shown with the shell of a test in RelToSqlConverter test.  The following

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

2019-12-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3593: --- Summary: RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filt

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

2019-12-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3593: --- Description: Best shown with the shell of a test in RelToSqlConverter test.  The following

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

2019-12-11 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Talbot updated CALCITE-3593: --- Description: Best shown with the shell of a test in RelToSqlConverter test.  The following

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

2019-12-11 Thread Steven Talbot (Jira)
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: https://issues.apache.org/jira/browse/CALCITE

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

2019-11-04 Thread Steven Talbot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967094#comment-16967094 ] Steven Talbot commented on CALCITE-3475: Linked a proposed fix in [https://gith

  1   2   >