[jira] [Resolved] (CALCITE-6050) Add interface ImmutablePairList

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

[jira] [Updated] (CALCITE-6050) Add interface ImmutablePairList

[ https://issues.apache.org/jira/browse/CALCITE-6050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6050: - Fix Version/s: 1.36.0 > Add interface ImmutablePairList > --- > >

[jira] [Assigned] (CALCITE-6050) Add interface ImmutablePairList

[ https://issues.apache.org/jira/browse/CALCITE-6050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6050: Assignee: Julian Hyde > Add interface ImmutablePairList > --

[jira] [Created] (CALCITE-6050) Add interface ImmutablePairList

Julian Hyde created CALCITE-6050: Summary: Add interface ImmutablePairList Key: CALCITE-6050 URL: https://issues.apache.org/jira/browse/CALCITE-6050 Project: Calcite Issue Type: Improvement

[jira] [Resolved] (CALCITE-5950) DEFAULT expression is ignored during INSERT

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

[jira] [Updated] (CALCITE-5950) DEFAULT expression is ignored during INSERT

[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5950: - Summary: DEFAULT expression is ignored during INSERT (was: Default column expression does not

[jira] [Commented] (CALCITE-6046) quoteStringLiteralUnicode returns unparsed string with u&' prefix, which will cause the SqlLiteral

[ https://issues.apache.org/jira/browse/CALCITE-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17775096#comment-17775096 ] Julian Hyde commented on CALCITE-6046: -- Standard SQL > quoteStringLiteralUnicode

[jira] [Commented] (CALCITE-6038) Remove 'Order By x Limit n' when the input is guaranteed that is at most one row

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774619#comment-17774619 ] Julian Hyde commented on CALCITE-6038: -- Do you think the following is a good summa

[jira] [Commented] (CALCITE-5950) Default column constraint is erroneously processed.

[ https://issues.apache.org/jira/browse/CALCITE-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774579#comment-17774579 ] Julian Hyde commented on CALCITE-5950: -- Can you improve the summary? A few points:

[jira] [Commented] (CALCITE-6044) Column uniqueness for single-row relations

[ https://issues.apache.org/jira/browse/CALCITE-6044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774298#comment-17774298 ] Julian Hyde commented on CALCITE-6044: -- I see; every other combination of columns

[jira] [Updated] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6021: - Fix Version/s: 1.36.0 > Add CURRENT_DATETIME function (enabled in BigQuery library) > -

[jira] [Commented] (CALCITE-6044) Column uniqueness for single-row relations

[ https://issues.apache.org/jira/browse/CALCITE-6044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774267#comment-17774267 ] Julian Hyde commented on CALCITE-6044: -- This sounds right. However, beware trying

[jira] [Commented] (CALCITE-6045) CURRENT_TIMESTAMP has incorrect return type

[ https://issues.apache.org/jira/browse/CALCITE-6045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774265#comment-17774265 ] Julian Hyde commented on CALCITE-6045: -- This all sounds right. I have been feeling

[jira] [Commented] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774237#comment-17774237 ] Julian Hyde commented on CALCITE-6009: -- The way that this was combined with SORT_R

[jira] [Commented] (CALCITE-6038) Remove 'Limit n' when the input is guaranteed to never return more than 'n' rows

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774234#comment-17774234 ] Julian Hyde commented on CALCITE-6038: -- I am thoroughly confused. Does 'TopN' mean

[jira] [Commented] (CALCITE-6046) quoteStringLiteralUnicode returns unparsed string with u&' prefix, which will cause the SqlLiteral

[ https://issues.apache.org/jira/browse/CALCITE-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774227#comment-17774227 ] Julian Hyde commented on CALCITE-6046: -- Can you talk about the behavior rather tha

[jira] [Updated] (CALCITE-6038) Remove 'Limit n' when the input is guaranteed to never return more than 'n' rows

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6038: - Summary: Remove 'Limit n' when the input is guaranteed to never return more than 'n' rows (was

[jira] [Commented] (CALCITE-6038) Remove redundant TopN when its input's row count is provably at most one row.

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774225#comment-17774225 ] Julian Hyde commented on CALCITE-6038: -- I changed the summary from "Remove redunda

[jira] [Commented] (CALCITE-6038) Add optimization to remove redundant TopN when its input's row number is less or equal to one

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772700#comment-17772700 ] Julian Hyde commented on CALCITE-6038: -- The idea is a good one. I just don't think

[jira] [Commented] (CALCITE-6039) PERCENTILE_CONT for BigQuery dialect has different syntax and is parsed incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-6039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772681#comment-17772681 ] Julian Hyde commented on CALCITE-6039: -- I suspect the best way to implement this i

[jira] [Commented] (CALCITE-6013) Unnecessary measures added as projects during rel construction

[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772559#comment-17772559 ] Julian Hyde commented on CALCITE-6013: -- That makes sense. > Unnecessary measures

[jira] [Commented] (CALCITE-6037) The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT/EXISTSNODE is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772558#comment-17772558 ] Julian Hyde commented on CALCITE-6037: -- Can you describe the problem in the first

[jira] [Commented] (CALCITE-6038) Add optimization to remove redundant TopN when its input's row number is less or equal to one

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772555#comment-17772555 ] Julian Hyde commented on CALCITE-6038: -- Why do you mention the number 1? Surely it

[jira] [Commented] (CALCITE-6034) Add `isAutoIncrement` and `isGenerated` arguments to MetaColumn constructor

[ https://issues.apache.org/jira/browse/CALCITE-6034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772434#comment-17772434 ] Julian Hyde commented on CALCITE-6034: -- Adding two parameters to the constructor i

[jira] [Commented] (CALCITE-5955) BigQuery PERCENTILE functions are unparsed incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-5955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17772049#comment-17772049 ] Julian Hyde commented on CALCITE-5955: -- [~oliverlee], Your analysis seems right. B

[jira] [Commented] (CALCITE-5979) Add REGEXP_REPLACE function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17771608#comment-17771608 ] Julian Hyde commented on CALCITE-5979: -- Backslashes are going to make the test cas

[jira] [Comment Edited] (CALCITE-5979) Add REGEXP_REPLACE function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17771593#comment-17771593 ] Julian Hyde edited comment on CALCITE-5979 at 10/3/23 6:26 PM: --

[jira] [Commented] (CALCITE-5979) Add REGEXP_REPLACE function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17771593#comment-17771593 ] Julian Hyde commented on CALCITE-5979: -- Of the databases that support REGEXP_REPLA

[jira] [Commented] (CALCITE-6032) Multilevel correlated query is failing in RelDecorrelator code path

[ https://issues.apache.org/jira/browse/CALCITE-6032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17771533#comment-17771533 ] Julian Hyde commented on CALCITE-6032: -- I found CALCITE-5390 with a simple search

[jira] [Commented] (CALCITE-6032) Multilevel correlated query is failing in RelDecorrelator code path

[ https://issues.apache.org/jira/browse/CALCITE-6032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17771240#comment-17771240 ] Julian Hyde commented on CALCITE-6032: -- Is this a duplicate? > Multilevel correla

[jira] [Commented] (CALCITE-5955) BigQuery PERCENTILE functions are unparsed incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-5955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17769918#comment-17769918 ] Julian Hyde commented on CALCITE-5955: -- I take your point. The ISO SQL "SELECT PER

[jira] [Comment Edited] (CALCITE-6027) Add the rule to rewrite cardinality on map_keys and map_values functions

[ https://issues.apache.org/jira/browse/CALCITE-6027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17769917#comment-17769917 ] Julian Hyde edited comment on CALCITE-6027 at 9/28/23 6:15 AM: --

[jira] [Commented] (CALCITE-6027) Add the rule to rewrite cardinality on map_keys and map_values functions

[ https://issues.apache.org/jira/browse/CALCITE-6027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17769917#comment-17769917 ] Julian Hyde commented on CALCITE-6027: -- You don't need a special rule. Just do con

[jira] [Commented] (CALCITE-6029) SqlOperatorTest cannot test operators that require the Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-6029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17769916#comment-17769916 ] Julian Hyde commented on CALCITE-6029: -- SqlOperatorTest runs in a gradle module (c

[jira] [Resolved] (CALCITE-5982) Allow overloading the created enumerable in Calcite when calling getTables() or getColumns()

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

[jira] [Resolved] (CALCITE-6007) CTE as subquery without alias doesn't have correct alias setup

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

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17769671#comment-17769671 ] Julian Hyde commented on CALCITE-6020: -- I agree that the subset of algebra we targ

[jira] [Resolved] (CALCITE-6003) JSON_ARRAY() with no arguments does not unparse correctly

[ https://issues.apache.org/jira/browse/CALCITE-6003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6003. -- Fix Version/s: 1.36.0 Resolution: Fixed Fixed in [509e8c17|https://github.com/apache/

[jira] [Commented] (CALCITE-6025) Simplify DECODE function

[ https://issues.apache.org/jira/browse/CALCITE-6025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768875#comment-17768875 ] Julian Hyde commented on CALCITE-6025: -- I don't think we should simplify DECODE. W

[jira] [Assigned] (CALCITE-6024) ListSqlOperatorTable is inefficient

[ https://issues.apache.org/jira/browse/CALCITE-6024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6024: Assignee: Julian Hyde > ListSqlOperatorTable is inefficient > --

[jira] [Commented] (CALCITE-6024) ListSqlOperatorTable is inefficient

[ https://issues.apache.org/jira/browse/CALCITE-6024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768872#comment-17768872 ] Julian Hyde commented on CALCITE-6024: -- I'm working on it already. > ListSqlOpera

[jira] [Commented] (CALCITE-6023) Error in SqlToRelConverter.convertQuery, possibly due to unqualified column reference

[ https://issues.apache.org/jira/browse/CALCITE-6023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768825#comment-17768825 ] Julian Hyde commented on CALCITE-6023: -- Regarding formatting. I recommend using \{

[jira] [Updated] (CALCITE-6023) Error in SqlToRelConverter.convertQuery, possibly due to unqualified column reference

[ https://issues.apache.org/jira/browse/CALCITE-6023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6023: - Description: Hello all, I believe I have found a bug in SqlToRelConverter. The symptom and rep

[jira] [Commented] (CALCITE-6017) The content of github link about the released versions in history doc is empty

[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768815#comment-17768815 ] Julian Hyde commented on CALCITE-6017: -- I agree with [~rubenql]. The tags will hav

[jira] [Resolved] (CALCITE-6005) POLYGON string representation has changed on Apple silicon

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

[jira] [Assigned] (CALCITE-6005) POLYGON string representation has changed on Apple silicon

[ https://issues.apache.org/jira/browse/CALCITE-6005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6005: Assignee: Julian Hyde > POLYGON string representation has changed on Apple silicon > ---

[jira] [Updated] (CALCITE-6005) POLYGON string representation has changed on Apple silicon

[ https://issues.apache.org/jira/browse/CALCITE-6005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6005: - Description: I am getting a test error when I run RelOptRulesTest on JDK 19 and Apple silicon

[jira] [Updated] (CALCITE-6005) POLYGON string representation has changed on Apple silicon

[ https://issues.apache.org/jira/browse/CALCITE-6005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6005: - Summary: POLYGON string representation has changed on Apple silicon (was: POLYGON string repre

[jira] [Commented] (CALCITE-5987) SqlImplementor loses type information for literals

[ https://issues.apache.org/jira/browse/CALCITE-5987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768183#comment-17768183 ] Julian Hyde commented on CALCITE-5987: -- I agree this might be useful. You are corr

[jira] [Commented] (CALCITE-6007) CTE as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768178#comment-17768178 ] Julian Hyde commented on CALCITE-6007: -- I'm saying make it work the same way as ex

[jira] [Commented] (CALCITE-6023) Possible bug found in SqlToRelConverter

[ https://issues.apache.org/jira/browse/CALCITE-6023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768177#comment-17768177 ] Julian Hyde commented on CALCITE-6023: -- A query similar to yours works just fine:

[jira] [Created] (CALCITE-6024) ListSqlOperatorTable is inefficient

Julian Hyde created CALCITE-6024: Summary: ListSqlOperatorTable is inefficient Key: CALCITE-6024 URL: https://issues.apache.org/jira/browse/CALCITE-6024 Project: Calcite Issue Type: Improveme

[jira] [Commented] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768150#comment-17768150 ] Julian Hyde commented on CALCITE-6021: -- I have a partial fix in [6021-datetime|ht

[jira] [Commented] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768130#comment-17768130 ] Julian Hyde commented on CALCITE-6021: -- Setting the syntax didn't fix the problem.

[jira] [Commented] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17768125#comment-17768125 ] Julian Hyde commented on CALCITE-6021: -- The test you have highlighted, {{{}SqlVali

[jira] [Commented] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767768#comment-17767768 ] Julian Hyde commented on CALCITE-6020: -- {{SUM0}} stores less information than {{SU

[jira] [Comment Edited] (CALCITE-6020) SqlToRelConverter should not replace windowed SUM with equivalent expression using SUM0

[ https://issues.apache.org/jira/browse/CALCITE-6020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767768#comment-17767768 ] Julian Hyde edited comment on CALCITE-6020 at 9/22/23 1:12 AM: --

[jira] [Commented] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767767#comment-17767767 ] Julian Hyde commented on CALCITE-6021: -- Note that the {{CURRENT_TIMESTAMP}}, {{LOC

[jira] [Commented] (CALCITE-6007) CTE as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767766#comment-17767766 ] Julian Hyde commented on CALCITE-6007: -- Good; and now find out how the "EXPR$0" al

[jira] [Commented] (CALCITE-5955) BigQuery PERCENTILE functions are unparsed incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-5955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767667#comment-17767667 ] Julian Hyde commented on CALCITE-5955: -- I see that {{allowsFraming}} is already de

[jira] [Commented] (CALCITE-5955) BigQuery PERCENTILE functions are unparsed incorrectly

[ https://issues.apache.org/jira/browse/CALCITE-5955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767660#comment-17767660 ] Julian Hyde commented on CALCITE-5955: -- Can you define in the doc what you mean by

[jira] [Resolved] (CALCITE-5974) Elasticsearch adapter throws ClassCastException when index mapping sets dynamic_templates without properties

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

[jira] [Commented] (CALCITE-6017) The content of github link about the released versions in history doc is empty

[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767443#comment-17767443 ] Julian Hyde commented on CALCITE-6017: -- What happened on GitHub so that the list o

[jira] [Resolved] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-5960. -- Fix Version/s: 1.36.0 Resolution: Fixed Fixed in [3775307e|https://github.com/apache/

[jira] [Resolved] (CALCITE-5995) Add cache to the dejsonize functions (JSON_VALUE, JSON_EXISTS, JSON_QUERY)

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

[jira] [Updated] (CALCITE-5995) Add cache to the dejsonize functions (JSON_VALUE, JSON_EXISTS, JSON_QUERY)

[ https://issues.apache.org/jira/browse/CALCITE-5995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5995: - Summary: Add cache to the dejsonize functions (JSON_VALUE, JSON_EXISTS, JSON_QUERY) (was: add

[jira] [Commented] (CALCITE-6008) ARRAY_AGG should returns ARRAY NULL when there's no input rows

[ https://issues.apache.org/jira/browse/CALCITE-6008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767410#comment-17767410 ] Julian Hyde commented on CALCITE-6008: -- Please ask for reviewers on the dev list.

[jira] [Commented] (CALCITE-5984) Cannot fully disable trimming unused fields using Calcite configs

[ https://issues.apache.org/jira/browse/CALCITE-5984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767352#comment-17767352 ] Julian Hyde commented on CALCITE-5984: -- As I said, I don't know. > Cannot fully d

[jira] [Commented] (CALCITE-5978) Add REGEXP_INSTR function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767342#comment-17767342 ] Julian Hyde commented on CALCITE-5978: -- [~jerin_john], A few late review comments.

[jira] [Commented] (CALCITE-5960) CAST failed if SqlTypeFamily of targetType is NULL

[ https://issues.apache.org/jira/browse/CALCITE-5960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767326#comment-17767326 ] Julian Hyde commented on CALCITE-5960: -- I saw that it is a simple fix. Can you add

[jira] [Commented] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767324#comment-17767324 ] Julian Hyde commented on CALCITE-6012: -- Wow, by sheer coincidence, a duplicate see

[jira] [Commented] (CALCITE-5995) add cache to dejsonize function in JsonFunctions

[ https://issues.apache.org/jira/browse/CALCITE-5995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767323#comment-17767323 ] Julian Hyde commented on CALCITE-5995: -- Please ask on the dev list. > add cache t

[jira] [Commented] (CALCITE-6011) Add the RelRule that pushes the Filter past a Window

[ https://issues.apache.org/jira/browse/CALCITE-6011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767321#comment-17767321 ] Julian Hyde commented on CALCITE-6011: -- Sounds awesome; looking forward to it. Can

[jira] [Commented] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767319#comment-17767319 ] Julian Hyde commented on CALCITE-6012: -- [~oliverlee], Cancel that. It seems that t

[jira] [Updated] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6012: - Affects Version/s: 1.35.0 > CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE sinc

[jira] [Commented] (CALCITE-6012) CAST($t4):JavaType(class java.lang.Object) NOT NULL causes NPE since 1.27

[ https://issues.apache.org/jira/browse/CALCITE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767316#comment-17767316 ] Julian Hyde commented on CALCITE-6012: -- [~oliverlee], Would you mind taking a look

[jira] [Commented] (CALCITE-6007) CTE as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767311#comment-17767311 ] Julian Hyde commented on CALCITE-6007: -- What happens with the example query I gave

[jira] [Commented] (CALCITE-6016) Cannot execute SQL on Snowflake connection with error : java.lang.IllegalArgumentException: Multiple entries with same key: CLASSES=JdbcTable {CLASSES} and CLASSES=Jd

[ https://issues.apache.org/jira/browse/CALCITE-6016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767310#comment-17767310 ] Julian Hyde commented on CALCITE-6016: -- Based on the error message, it looks as if

[jira] [Updated] (CALCITE-6016) Cannot execute SQL on Snowflake connection with error : java.lang.IllegalArgumentException: Multiple entries with same key: CLASSES=JdbcTable {CLASSES} and CLASSES=Jdbc

[ https://issues.apache.org/jira/browse/CALCITE-6016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6016: - Description: Might be similar to : DRILL-7415 I am connected to Snowflake datasource using cal

[jira] [Commented] (CALCITE-6017) The content of github link about the released versions in history doc is empty

[ https://issues.apache.org/jira/browse/CALCITE-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767249#comment-17767249 ] Julian Hyde commented on CALCITE-6017: -- The page used to contain releases, e.g. [r

[jira] [Comment Edited] (CALCITE-6013) Unnecessary measures added as projects during rel construction

[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767236#comment-17767236 ] Julian Hyde edited comment on CALCITE-6013 at 9/20/23 7:06 PM: --

[jira] [Updated] (CALCITE-6013) Unnecessary measures added as projects during rel construction

[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-6013: - Description: If you have a test like the following (modified from {{SqlToRelConverterTest#test

[jira] [Commented] (CALCITE-6013) Unnecessary measures added as projects during rel construction

[ https://issues.apache.org/jira/browse/CALCITE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767236#comment-17767236 ] Julian Hyde commented on CALCITE-6013: -- Does this scenario give an error? The plan

[jira] [Commented] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17766033#comment-17766033 ] Julian Hyde commented on CALCITE-6007: -- The problem is that the generated SQL is i

[jira] [Commented] (CALCITE-6008) ARRAY_AGG should returns ARRAY NULL when there's no input rows

[ https://issues.apache.org/jira/browse/CALCITE-6008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17766032#comment-17766032 ] Julian Hyde commented on CALCITE-6008: -- Done. Please expand to include the other

[jira] [Assigned] (CALCITE-6008) ARRAY_AGG should returns ARRAY NULL when there's no input rows

[ https://issues.apache.org/jira/browse/CALCITE-6008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-6008: Assignee: Jiabao Sun > ARRAY_AGG should returns ARRAY NULL when there's no input rows >

[jira] [Comment Edited] (CALCITE-6009) Add the optimize for removing the redundant Limit when a Limit's input max row cnt less than limit fetch

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17766031#comment-17766031 ] Julian Hyde edited comment on CALCITE-6009 at 9/16/23 11:21 PM: -

[jira] [Commented] (CALCITE-6009) Add the optimize for removing the redundant Limit when a Limit's input max row cnt less than limit fetch

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17766031#comment-17766031 ] Julian Hyde commented on CALCITE-6009: -- I don't think using abbreviations such as

[jira] [Comment Edited] (CALCITE-4189) Simplify 'p OR (p IS NOT TRUE)' to 'TRUE'

[ https://issues.apache.org/jira/browse/CALCITE-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17763447#comment-17763447 ] Julian Hyde edited comment on CALCITE-4189 at 9/15/23 8:29 PM: --

[jira] [Commented] (CALCITE-6000) There should be a SqlParserFixture which parses again after unparsing

[ https://issues.apache.org/jira/browse/CALCITE-6000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765841#comment-17765841 ] Julian Hyde commented on CALCITE-6000: -- There's a real bug here - that "convert('a

[jira] [Commented] (CALCITE-5995) add cache to dejsonize function in JsonFunctions

[ https://issues.apache.org/jira/browse/CALCITE-5995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765837#comment-17765837 ] Julian Hyde commented on CALCITE-5995: -- You are using a global (static) cache. Can

[jira] [Commented] (CALCITE-4335) Aggregate functions for BigQuery

[ https://issues.apache.org/jira/browse/CALCITE-4335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765835#comment-17765835 ] Julian Hyde commented on CALCITE-4335: -- [~jiabao.sun], Thanks for raising this. Ha

[jira] [Commented] (CALCITE-6001) Add useUtf8AsDefaultCharset flag to SqlConformanceEnum to allow encoding of non-ISO-8859-1 characters

[ https://issues.apache.org/jira/browse/CALCITE-6001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765832#comment-17765832 ] Julian Hyde commented on CALCITE-6001: -- Can we generalize, changing {{boolean useU

[jira] [Commented] (CALCITE-5986) The typeFamily property of SqlTypeName is used inconsistently

[ https://issues.apache.org/jira/browse/CALCITE-5986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765821#comment-17765821 ] Julian Hyde commented on CALCITE-5986: -- > > I think that the getFamily method shou

[jira] [Comment Edited] (CALCITE-5979) Add REGEXP_REPLACE function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765812#comment-17765812 ] Julian Hyde edited comment on CALCITE-5979 at 9/15/23 6:58 PM: --

[jira] [Commented] (CALCITE-5979) Add REGEXP_REPLACE function (enabled in BigQuery library)

[ https://issues.apache.org/jira/browse/CALCITE-5979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765812#comment-17765812 ] Julian Hyde commented on CALCITE-5979: -- Maybe the difference is in the character l

[jira] [Commented] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765809#comment-17765809 ] Julian Hyde commented on CALCITE-6007: -- Which component generates this SQL query -

[jira] [Updated] (CALCITE-5938) Update HSQLDB to Version 2.7.2

[ https://issues.apache.org/jira/browse/CALCITE-5938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5938: - Fix Version/s: 1.36.0 > Update HSQLDB to Version 2.7.2 > -- > >

[jira] [Updated] (CALCITE-5938) Update HSQLDB to Version 2.7.2

[ https://issues.apache.org/jira/browse/CALCITE-5938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5938: - Summary: Update HSQLDB to Version 2.7.2 (was: Update HSQLDB to Version 2.7.12) > Update HSQLD

[jira] [Commented] (CALCITE-5974) Elasticsearch adapter throws ClassCastException when index mapping sets dynamic_templates without properties

[ https://issues.apache.org/jira/browse/CALCITE-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17765807#comment-17765807 ] Julian Hyde commented on CALCITE-5974: -- Looks good; add a unit test and I will mer

<    4   5   6   7   8   9   10   11   12   13   >