[jira] [Resolved] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6444. -- Resolution: Fixed Fixed in [cdb6522d|https://github.com/apache/calcite/commit/cdb6522d332077

[jira] [Commented] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860917#comment-17860917 ] Julian Hyde commented on CALCITE-6444: -- [~njordan], I added a fixup commit to your

[jira] [Updated] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6444: - Fix Version/s: 1.38.0 > Add a function library for Amazon Redshift > --

[jira] [Commented] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860675#comment-17860675 ] Julian Hyde commented on CALCITE-6444: -- I reviewed. A few changes needed, but let'

[jira] [Comment Edited] (CALCITE-6369) Expanding "star" gives ArrayIndexOutOfBoundsException with redundant columns and USING

[ https://issues.apache.org/jira/browse/CALCITE-6369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860665#comment-17860665 ] Julian Hyde edited comment on CALCITE-6369 at 6/27/24 11:46 PM: -

[jira] [Commented] (CALCITE-6369) Expanding "star" gives ArrayIndexOutOfBoundsException with redundant columns and USING

[ https://issues.apache.org/jira/browse/CALCITE-6369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860665#comment-17860665 ] Julian Hyde commented on CALCITE-6369: -- [~njordan], Since the bug is in the valida

[jira] [Commented] (CALCITE-5802) In RelBuilder add method aggregateRex, to allow aggregating complex expressions such as "1 + SUM(x + 2)"

[ https://issues.apache.org/jira/browse/CALCITE-5802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860663#comment-17860663 ] Julian Hyde commented on CALCITE-5802: -- I agree, it's a new feature. We don't tend

[jira] [Updated] (CALCITE-5802) In RelBuilder add method aggregateRex, to allow aggregating complex expressions such as "1 + SUM(x + 2)"

[ https://issues.apache.org/jira/browse/CALCITE-5802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5802: - Description: In {{RelBuilder}} add method {{{}aggregateRex{}}}, to allow aggregating complex e

[jira] [Updated] (CALCITE-5802) In RelBuilder add method aggregateRex, to allow aggregating complex expressions such as "1 + SUM(x + 2)"

[ https://issues.apache.org/jira/browse/CALCITE-5802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5802: - Summary: In RelBuilder add method aggregateRex, to allow aggregating complex expressions such a

[jira] [Commented] (CALCITE-6436) JDBC adapter generates SQL with missing round brackets when WHERE clause contains parameter

[ https://issues.apache.org/jira/browse/CALCITE-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860276#comment-17860276 ] Julian Hyde commented on CALCITE-6436: -- I can reproduce this. The generated SQL (f

[jira] [Commented] (CALCITE-6448) FilterReduceExpressionsRule returns empty RelNode for RexLiterals

[ https://issues.apache.org/jira/browse/CALCITE-6448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860251#comment-17860251 ] Julian Hyde commented on CALCITE-6448: -- I surmise that the rule is assuming that t

[jira] [Commented] (CALCITE-6433) SUBSTRING can return incorrect empty result for some parameters

[ https://issues.apache.org/jira/browse/CALCITE-6433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17860192#comment-17860192 ] Julian Hyde commented on CALCITE-6433: -- Thanks for clarification. (I think you mea

[jira] [Commented] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859979#comment-17859979 ] Julian Hyde commented on CALCITE-6444: -- Thanks for doing that analysis. Furthermor

[jira] [Comment Edited] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859734#comment-17859734 ] Julian Hyde edited comment on CALCITE-6444 at 6/25/24 4:31 PM: --

[jira] [Updated] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6444: - Description: Add a function library for Amazon Redshift. People would be able to use this libr

[jira] [Updated] (CALCITE-6444) Add a function library for Amazon Redshift

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6444: - Summary: Add a function library for Amazon Redshift (was: Add an Amazon Redshift SqlLibrary)

[jira] [Commented] (CALCITE-6442) Validator rejects FILTER in OVER windows

[ https://issues.apache.org/jira/browse/CALCITE-6442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859976#comment-17859976 ] Julian Hyde commented on CALCITE-6442: -- Thank you, [~mbudiu], for going the extra

[jira] [Resolved] (CALCITE-768) Hopping windows

[ https://issues.apache.org/jira/browse/CALCITE-768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-768. - Fix Version/s: 1.12.0 Resolution: Duplicate Resolving as duplicate of CALCITE-1615. > Ho

[jira] [Commented] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is null

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859512#comment-17859512 ] Julian Hyde commented on CALCITE-6440: -- A better summary would be 'SortRemoveConst

[jira] [Comment Edited] (CALCITE-6447) extract common expressions for disjunctions in Join

[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859503#comment-17859503 ] Julian Hyde edited comment on CALCITE-6447 at 6/23/24 8:40 PM: --

[jira] [Commented] (CALCITE-6447) extract common expressions for disjunctions in Join

[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17859503#comment-17859503 ] Julian Hyde commented on CALCITE-6447: -- This is related to conjunctive normal form

[jira] [Updated] (CALCITE-6447) extract common expressions for disjunctions in Join

[ https://issues.apache.org/jira/browse/CALCITE-6447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6447: - Description: For SQL: {code:java} select * from tbl_a join tbl_b on tbl_a.id = tbl_b.id where

[jira] [Commented] (CALCITE-6442) Validator rejects FILTER in OVER windows

[ https://issues.apache.org/jira/browse/CALCITE-6442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856954#comment-17856954 ] Julian Hyde commented on CALCITE-6442: -- If you're going to remove it from the docu

[jira] [Commented] (CALCITE-6442) Validator rejects FILTER in OVER windows

[ https://issues.apache.org/jira/browse/CALCITE-6442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856953#comment-17856953 ] Julian Hyde commented on CALCITE-6442: -- That was a copy-edit. The content was adde

[jira] [Commented] (CALCITE-6444) Add an Amazon Redshift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856884#comment-17856884 ] Julian Hyde commented on CALCITE-6444: -- I'm thinking about the effort going forwar

[jira] [Commented] (CALCITE-6444) Add a RedShift SqlLibrary

[ https://issues.apache.org/jira/browse/CALCITE-6444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856879#comment-17856879 ] Julian Hyde commented on CALCITE-6444: -- Can you begin the description with the fea

[jira] [Updated] (CALCITE-6443) Create view based on LookML model

[ https://issues.apache.org/jira/browse/CALCITE-6443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6443: - Description: Create a view based on LookML model (more specifically, based on an explore in a

[jira] [Created] (CALCITE-6443) Create view based on LookML model

Julian Hyde created CALCITE-6443: Summary: Create view based on LookML model Key: CALCITE-6443 URL: https://issues.apache.org/jira/browse/CALCITE-6443 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6442) Validator rejects FILTER in OVER windows

[ https://issues.apache.org/jira/browse/CALCITE-6442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856099#comment-17856099 ] Julian Hyde commented on CALCITE-6442: -- Can you see who added it to the grammar, a

[jira] [Commented] (CALCITE-6440) Add optimization to remove sortkey when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17856089#comment-17856089 ] Julian Hyde commented on CALCITE-6440: -- [~caicancai], No, the rule should not do w

[jira] [Comment Edited] (CALCITE-6441) Add BOOLAGG_AND, BOOLAGG_OR aggregate functions (enabled in Snowflake library)

[ https://issues.apache.org/jira/browse/CALCITE-6441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17855767#comment-17855767 ] Julian Hyde edited comment on CALCITE-6441 at 6/18/24 12:20 AM: -

[jira] [Assigned] (CALCITE-6441) Add BOOLAGG_AND, BOOLAGG_OR aggregate functions (enabled in Snowflake library)

[ https://issues.apache.org/jira/browse/CALCITE-6441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6441: Assignee: Nitish Kumar > Add BOOLAGG_AND, BOOLAGG_OR aggregate functions (enabled in Sno

[jira] [Resolved] (CALCITE-6441) Add BOOLAGG_AND, BOOLAGG_OR aggregate functions (enabled in Snowflake library)

[ https://issues.apache.org/jira/browse/CALCITE-6441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6441. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in [https://github.com/apache/calcite/c

[jira] [Resolved] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6414. -- Fix Version/s: 1.38.0 Resolution: Fixed Fixed in [97d62ac|https://github.com/apache/c

[jira] [Commented] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17855763#comment-17855763 ] Julian Hyde commented on CALCITE-6414: -- I have decomposed this PR into two (one to

[jira] [Created] (CALCITE-6441) Add BOOLAGG_AND, BOOLAGG_OR aggregate functions (enabled in Snowflake library)

Julian Hyde created CALCITE-6441: Summary: Add BOOLAGG_AND, BOOLAGG_OR aggregate functions (enabled in Snowflake library) Key: CALCITE-6441 URL: https://issues.apache.org/jira/browse/CALCITE-6441 Proj

[jira] [Commented] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

[ https://issues.apache.org/jira/browse/CALCITE-6439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17855454#comment-17855454 ] Julian Hyde commented on CALCITE-6439: -- There should be existing code that convert

[jira] [Resolved] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6440. -- Resolution: Fixed {{SortRemoveConstantKeysRule}} (added in CALCITE-873) already does this. >

[jira] [Resolved] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6440. -- Resolution: Duplicate > Add optimization to returns empty when The Order By parameter in the

[jira] [Reopened] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

[ https://issues.apache.org/jira/browse/CALCITE-6440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-6440: -- > Add optimization to returns empty when The Order By parameter in the Sort > operator is empty

[jira] [Updated] (CALCITE-6430) SINGLE_VALUE rewrite to wrong SQL when the sub-query returns one not-NULL value and one NULL value in PostgreSQL, MySQL, HSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-6430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6430: - Summary: SINGLE_VALUE rewrite to wrong SQL when the sub-query returns one not-NULL value and on

[jira] [Updated] (CALCITE-6430) SINGLE_VALUE rewrite to wrong SQL when the sub-query returns one not-NULL value and NULL value in PostgreSQL, MySQL, HSQL dialect

[ https://issues.apache.org/jira/browse/CALCITE-6430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6430: - Summary: SINGLE_VALUE rewrite to wrong SQL when the sub-query returns one not-NULL value and NU

[jira] [Commented] (CALCITE-6433) SUBSTRING can return incorrect empty result for some parameters

[ https://issues.apache.org/jira/browse/CALCITE-6433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17854491#comment-17854491 ] Julian Hyde commented on CALCITE-6433: -- I'm a bit surprised that it's valid to pas

[jira] [Commented] (CALCITE-6434) Specify identifier quoting for HiveSqlDialect and SparkSqlDialect

[ https://issues.apache.org/jira/browse/CALCITE-6434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17854487#comment-17854487 ] Julian Hyde commented on CALCITE-6434: -- The summary seems to describe the fix rath

[jira] [Commented] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17852039#comment-17852039 ] Julian Hyde commented on CALCITE-6414: -- Pr looks mostly good. The commit message s

[jira] [Updated] (CALCITE-6428) Typo in adapter documentation

[ https://issues.apache.org/jira/browse/CALCITE-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6428: - Fix Version/s: 1.38.0 (was: avatica-go-5.4.0) > Typo in adapter document

[jira] [Updated] (CALCITE-6428) Typo in adapter documentation

[ https://issues.apache.org/jira/browse/CALCITE-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6428: - Fix Version/s: avatica-go-5.4.0 > Typo in adapter documentation > -

[jira] [Commented] (CALCITE-6428) Typo in adapter documentation

[ https://issues.apache.org/jira/browse/CALCITE-6428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17852031#comment-17852031 ] Julian Hyde commented on CALCITE-6428: -- Looks good, but the commit message should

[jira] [Updated] (CALCITE-6425) Attributes

[ https://issues.apache.org/jira/browse/CALCITE-6425?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6425: - Description: Add operators and metadata so that columns can have attributes. For example, we w

[jira] [Created] (CALCITE-6425) Attributes

Julian Hyde created CALCITE-6425: Summary: Attributes Key: CALCITE-6425 URL: https://issues.apache.org/jira/browse/CALCITE-6425 Project: Calcite Issue Type: Improvement Reporter:

[jira] [Commented] (CALCITE-6310) Add REGEXP_REPLACE function (enabled in PostgreSQL library)

[ https://issues.apache.org/jira/browse/CALCITE-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17851344#comment-17851344 ] Julian Hyde commented on CALCITE-6310: -- Calcites overload resolution could or shou

[jira] [Commented] (CALCITE-6418) Expression with ALL aggregate return unexpected result.

[ https://issues.apache.org/jira/browse/CALCITE-6418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17851238#comment-17851238 ] Julian Hyde commented on CALCITE-6418: -- Do you intend to use {{ALL}} as a quantifi

[jira] [Commented] (CALCITE-6420) Fix confusing MappingType enum

[ https://issues.apache.org/jira/browse/CALCITE-6420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17850888#comment-17850888 ] Julian Hyde commented on CALCITE-6420: -- [~cat_shark], Thanks for logging this. I w

[jira] [Commented] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17850885#comment-17850885 ] Julian Hyde commented on CALCITE-6414: -- [~nitishkumar], I have assigned this case

[jira] [Assigned] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6414: Assignee: Nitish Kumar > Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG

[jira] [Commented] (CALCITE-6422) Query with '<>' throws NullPointerException during materialized view matching

[ https://issues.apache.org/jira/browse/CALCITE-6422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17850147#comment-17850147 ] Julian Hyde commented on CALCITE-6422: -- Thank you for improving the summary. I sim

[jira] [Updated] (CALCITE-6422) Query with '<>' throws NullPointerException during materialized view matching

[ https://issues.apache.org/jira/browse/CALCITE-6422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6422: - Summary: Query with '<>' throws NullPointerException during materialized view matching (was: N

[jira] [Updated] (CALCITE-6422) NPE in RexLiteral.booleanValue of SubstitutionVisitor.mayBeSatisfiable when materialized view query contains NEQ on nullable column

[ https://issues.apache.org/jira/browse/CALCITE-6422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6422: - Description: If a materialized view compares two nullable columns using '=', and a query on th

[jira] [Commented] (CALCITE-6422) RexLiteral.isNullLiteral should be applied before RexLiteral.booleanValue in SubstitutionVisitor.mayBeSatisfiable

[ https://issues.apache.org/jira/browse/CALCITE-6422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849882#comment-17849882 ] Julian Hyde commented on CALCITE-6422: -- Your summary describes the fix. Can you i

[jira] [Comment Edited] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849032#comment-17849032 ] Julian Hyde edited comment on CALCITE-6414 at 5/23/24 4:40 PM: --

[jira] [Commented] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849032#comment-17849032 ] Julian Hyde commented on CALCITE-6414: -- Makes sense. Looks like a small change to

[jira] [Commented] (CALCITE-6413) SqlValidator does not invoke TypeCoercionImpl::binaryComparisonCoercion for both NATURAL and USING join conditions

[ https://issues.apache.org/jira/browse/CALCITE-6413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848330#comment-17848330 ] Julian Hyde commented on CALCITE-6413: -- One small quibble. I believe the coercion

[jira] [Commented] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17848328#comment-17848328 ] Julian Hyde commented on CALCITE-6414: -- [~jswett], I changed the summary. Let me k

[jira] [Updated] (CALCITE-6414) Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN values

[ https://issues.apache.org/jira/browse/CALCITE-6414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6414: - Summary: Snowflake JDBC adapter should generate BOOLOR_AGG, BOOLAND_AGG for MAX, MIN on BOOLEAN

[jira] [Commented] (CALCITE-6409) Char types and Boolean types are comparable

[ https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17846030#comment-17846030 ] Julian Hyde commented on CALCITE-6409: -- Who said the types need to be comparable?

[jira] [Comment Edited] (CALCITE-6400) MAP_ENTRIES allows null as a map key

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845929#comment-17845929 ] Julian Hyde edited comment on CALCITE-6400 at 5/13/24 1:45 PM: --

[jira] [Commented] (CALCITE-6400) MAP_ENTRIES allows null as a map key

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845929#comment-17845929 ] Julian Hyde commented on CALCITE-6400: -- How about “MAP_ENTRIES should throw if a k

[jira] [Comment Edited] (CALCITE-6409) Char types and Boolean types are comparable

[ https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845744#comment-17845744 ] Julian Hyde edited comment on CALCITE-6409 at 5/12/24 8:42 PM: --

[jira] [Commented] (CALCITE-6409) Char types and Boolean types are comparable

[ https://issues.apache.org/jira/browse/CALCITE-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845744#comment-17845744 ] Julian Hyde commented on CALCITE-6409: -- [~caicancai], Please describe what researc

[jira] [Commented] (CALCITE-6410) dateadd(MONTH, 3, date '2016-02-24') parsing failed

[ https://issues.apache.org/jira/browse/CALCITE-6410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845743#comment-17845743 ] Julian Hyde commented on CALCITE-6410: -- Not a bug. That syntax is only supported i

[jira] [Updated] (CALCITE-6408) Not-null ThreadLocal

[ https://issues.apache.org/jira/browse/CALCITE-6408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6408: - Fix Version/s: 1.38.0 > Not-null ThreadLocal > > > Key: CA

[jira] [Assigned] (CALCITE-6408) Not-null ThreadLocal

[ https://issues.apache.org/jira/browse/CALCITE-6408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6408: Assignee: Julian Hyde > Not-null ThreadLocal > > >

[jira] [Created] (CALCITE-6408) Not-null ThreadLocal

Julian Hyde created CALCITE-6408: Summary: Not-null ThreadLocal Key: CALCITE-6408 URL: https://issues.apache.org/jira/browse/CALCITE-6408 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-6397) Add NVL2 function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-6397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845468#comment-17845468 ] Julian Hyde commented on CALCITE-6397: -- The Spark specification is not always grea

[jira] [Commented] (CALCITE-6403) Rule AGGREGATE_EXPAND_DISTINCT_AGGREGATES is unsound

[ https://issues.apache.org/jira/browse/CALCITE-6403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844800#comment-17844800 ] Julian Hyde commented on CALCITE-6403: -- Does the same problem occur when the input

[jira] [Comment Edited] (CALCITE-6402) Aggregates implied in grouping sets have a wrong nullability at validation stage

[ https://issues.apache.org/jira/browse/CALCITE-6402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844737#comment-17844737 ] Julian Hyde edited comment on CALCITE-6402 at 5/8/24 6:41 PM: ---

[jira] [Commented] (CALCITE-6402) Aggregates implied in grouping sets have a wrong nullability at validation stage

[ https://issues.apache.org/jira/browse/CALCITE-6402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844737#comment-17844737 ] Julian Hyde commented on CALCITE-6402: -- I agree with your analysis. It seems we n

[jira] [Commented] (CALCITE-6400) MAP_ENTRIES does not allow null as a map key

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844732#comment-17844732 ] Julian Hyde commented on CALCITE-6400: -- When I read the current summary, 'MAP_ENTR

[jira] [Commented] (CALCITE-6396) Add ADD_MONTHS function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-6396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844481#comment-17844481 ] Julian Hyde commented on CALCITE-6396: -- The first argument, and the return, should

[jira] [Comment Edited] (CALCITE-6400) MAP_ENTRIES does not allow the key to be empty

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17843477#comment-17843477 ] Julian Hyde edited comment on CALCITE-6400 at 5/4/24 5:27 PM: ---

[jira] [Comment Edited] (CALCITE-6400) MAP_ENTRIES does not allow the key to be empty

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17843477#comment-17843477 ] Julian Hyde edited comment on CALCITE-6400 at 5/4/24 5:26 PM: ---

[jira] [Commented] (CALCITE-6400) MAP_ENTRIES does not allow the key to be empty

[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17843477#comment-17843477 ] Julian Hyde commented on CALCITE-6400: -- Can you improve the summary? It's not clea

[jira] [Updated] (CALCITE-6393) Byte code of SqlFunctions is invalid

[ https://issues.apache.org/jira/browse/CALCITE-6393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6393: - Affects Version/s: 1.36.0 > Byte code of SqlFunctions is invalid >

[jira] [Commented] (CALCITE-4496) Measure columns ("SELECT ... AS MEASURE")

[ https://issues.apache.org/jira/browse/CALCITE-4496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17842472#comment-17842472 ] Julian Hyde commented on CALCITE-4496: -- An update on the development of this featu

[jira] [Commented] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17841666#comment-17841666 ] Julian Hyde commented on CALCITE-6300: -- Maybe it could get away with it, but it pr

[jira] [Updated] (CALCITE-6386) Elasticsearch adapter throws NullPointerException when used with with model.json and no username, password or pathPrefix

[ https://issues.apache.org/jira/browse/CALCITE-6386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6386: - Summary: Elasticsearch adapter throws NullPointerException when used with with model.json and n

[jira] [Commented] (CALCITE-6386) NPE when using ES adapter with model.json and no specified username, password or pathPrefix

[ https://issues.apache.org/jira/browse/CALCITE-6386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17841501#comment-17841501 ] Julian Hyde commented on CALCITE-6386: -- I changed the summary to remove abbreviati

[jira] [Commented] (CALCITE-6373) Distinct optimization produces broken sql query

[ https://issues.apache.org/jira/browse/CALCITE-6373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17841285#comment-17841285 ] Julian Hyde commented on CALCITE-6373: -- I suspect that the fix only fixes the spec

[jira] [Commented] (CALCITE-6383) The class SameOperandTypeChecker is incorrectly documented

[ https://issues.apache.org/jira/browse/CALCITE-6383?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17841062#comment-17841062 ] Julian Hyde commented on CALCITE-6383: -- Pr looks good except than you can’t use “*

[jira] [Commented] (CALCITE-6374) LatticeSuggester throw npe when agg call covered with cast

[ https://issues.apache.org/jira/browse/CALCITE-6374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17838774#comment-17838774 ] Julian Hyde commented on CALCITE-6374: -- [~allendang], Can you please remove the PN

[jira] [Commented] (CALCITE-6375) Fix failing quidem tests for FORMAT in CAST

[ https://issues.apache.org/jira/browse/CALCITE-6375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17838773#comment-17838773 ] Julian Hyde commented on CALCITE-6375: -- [~jerin_john], Jira summaries should not u

[jira] [Commented] (CALCITE-6373) Distinct optimization produces broken sql query

[ https://issues.apache.org/jira/browse/CALCITE-6373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17838248#comment-17838248 ] Julian Hyde commented on CALCITE-6373: -- I agree that any SQL-to-SQL transformation

[jira] [Commented] (CALCITE-6367) Add timezone support for FORMAT clause in CAST (enabled in BigQuery)

[ https://issues.apache.org/jira/browse/CALCITE-6367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837465#comment-17837465 ] Julian Hyde commented on CALCITE-6367: -- [~jerin_john] Can you add links to any rel

[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837462#comment-17837462 ] Julian Hyde commented on CALCITE-6363: -- Thanks for finding JoinConditionPushRule (

[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17837461#comment-17837461 ] Julian Hyde commented on CALCITE-6363: -- On the mailing list [~jamesstarr] replied:

[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836988#comment-17836988 ] Julian Hyde commented on CALCITE-6363: -- I really wish you had logged the case BEFO

[jira] [Commented] (CALCITE-6363) Introduce a rule to derive more filters from inner join condition

[ https://issues.apache.org/jira/browse/CALCITE-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836987#comment-17836987 ] Julian Hyde commented on CALCITE-6363: -- Don’t we have some existing rules (metadat

[jira] [Commented] (CALCITE-6357) Calcite enforces select arguments count to be same as row schema fields which causes aliases to be ignored

[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836338#comment-17836338 ] Julian Hyde commented on CALCITE-6357: -- We added {{RelRoot}} way back in CALCITE-8

[jira] [Commented] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836284#comment-17836284 ] Julian Hyde commented on CALCITE-6358: -- Yes, in theory, it might. I don't have tim

[jira] [Commented] (CALCITE-6358) Support all PostgreSQL 14 date/time patterns

[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836261#comment-17836261 ] Julian Hyde commented on CALCITE-6358: -- In Calcite, the set of format elements is

<    1   2   3   4   5   6   7   8   9   10   >