[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),

[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),

[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=17791376#comment-17791376 ] Steven Talbot commented on CALCITE-6143: Not sure if my first link is quite jumping to the

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

[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=17791371#comment-17791371 ] Steven Talbot commented on CALCITE-6086: Yep, seem like that is the same, thanks! >

[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=17786827#comment-17786827 ] Steven Talbot commented on CALCITE-5948: [~taoran] thanks for the response! Our use case is we

[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=17786545#comment-17786545 ] Steven Talbot commented on CALCITE-5948: Looking through the commit, there doesn't seem to be a

[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

[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

[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=17721556#comment-17721556 ] Steven Talbot commented on CALCITE-5696: Testing quickly, it would seem the answer is "no" for

[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

[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

[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

[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

[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=17613782#comment-17613782 ] Steven Talbot commented on CALCITE-5311: The best fix I can think of is to move that special

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

[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=17600064#comment-17600064 ] Steven Talbot commented on CALCITE-5254: Ah, could be ultimately that. I’m unsure about what

[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=17597961#comment-17597961 ] Steven Talbot commented on CALCITE-5254: Also, given that the "fix" there relies on the rule to

[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=17597958#comment-17597958 ] Steven Talbot commented on CALCITE-5254: The loop gets stuck because it is checking if it makes

[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

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

[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

[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=17572979#comment-17572979 ] Steven Talbot commented on CALCITE-5222: Ah, totally, and I see that it was merged, thanks

[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=17572695#comment-17572695 ] Steven Talbot commented on CALCITE-5222: ^^ probably, sorry for missing that, though this would

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

[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

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

[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=17557100#comment-17557100 ] Steven Talbot commented on CALCITE-5183: For the record, I did end up needing to use MULTIPLY

[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=17551198#comment-17551198 ] Steven Talbot commented on CALCITE-5183: ^^ regardless of the ergonomics of that interval

[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

[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=17548613#comment-17548613 ] Steven Talbot commented on CALCITE-5179: And thanks for the quick fix! > AssertionError in

[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=17548579#comment-17548579 ] Steven Talbot commented on CALCITE-5179: Eh, I guess a binary tree would be no good, because I

[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=17548577#comment-17548577 ] Steven Talbot commented on CALCITE-5179: ^^ indeed, in fact in an ideal world UNION ALL would

[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

[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=17534510#comment-17534510 ] Steven Talbot commented on CALCITE-5147: The parser does not accept TIMESTAMP "2018-02-17

[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

[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

[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

[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=17394828#comment-17394828 ] Steven Talbot commented on CALCITE-4485: Change seems good to me. A nit would be that you could

[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=17355281#comment-17355281 ] Steven Talbot commented on CALCITE-4524: [~julianhyde] I believe this fixed a bug. The

[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=17351260#comment-17351260 ] Steven Talbot commented on CALCITE-4620: I think that all makes sense. I certainly like taking

[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=17350655#comment-17350655 ] Steven Talbot commented on CALCITE-4620: Yep, I can repro, here's a test that blows up:    

[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=17350652#comment-17350652 ] Steven Talbot commented on CALCITE-4620: Actually, hold on, let me try to repro with a simple

[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

[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=17347267#comment-17347267 ] Steven Talbot commented on CALCITE-4610: I'm not intimately familiar with SqlImplementor, but

[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

[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=17283830#comment-17283830 ] Steven Talbot commented on CALCITE-4495: [~julianhyde] I think RexLiteral.valueMatchesType must

[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

[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

[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=17194546#comment-17194546 ] Steven Talbot commented on CALCITE-4249: Apologies if this is a dup (many things come up when

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

[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

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

[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=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=17144498#comment-17144498 ] Steven Talbot commented on CALCITE-4090: There is a related case that is important to have a

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

[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=17121395#comment-17121395 ] Steven Talbot edited comment on CALCITE-3975 at 6/1/20, 11:13 PM: -- I

[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=17121395#comment-17121395 ] Steven Talbot commented on CALCITE-3975: I see. That all makes sense. To me at first, before we

[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=17121395#comment-17121395 ] Steven Talbot edited comment on CALCITE-3975 at 6/1/20, 11:13 PM: -- I

[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=17106592#comment-17106592 ] Steven Talbot commented on CALCITE-2997: cc [~julianhyde] I'd move to reopen this. Even if the

[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

[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

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

[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=17091906#comment-17091906 ] Steven Talbot commented on CALCITE-3957: See some discussion where this was originally

[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=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=17086044#comment-17086044 ] Steven Talbot commented on CALCITE-3936: Yes, the only bummer with (1) here is that probably

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

[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=17083514#comment-17083514 ] Steven Talbot commented on CALCITE-3922: Good point. I should probably just rename the result

[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=17068027#comment-17068027 ] Steven Talbot commented on CALCITE-3877: Would that fix mean there is no way to ever create

[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=17067904#comment-17067904 ] Steven Talbot commented on CALCITE-3876: I see. I had not seen *_ProjectToWindowRule_* before.

[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=17067904#comment-17067904 ] Steven Talbot edited comment on CALCITE-3876 at 3/26/20, 5:54 PM: -- I

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

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

[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

[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

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

[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

[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

[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

[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

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

[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=16967094#comment-16967094 ] Steven Talbot commented on CALCITE-3475: Linked a proposed fix in 

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

2019-11-04 Thread Steven Talbot (Jira)
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:

  1   2   >