[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752288#comment-17752288 ] JingDas commented on CALCITE-5894: -- It's good to do this work together. Maybe I can re

[jira] [Commented] (CALCITE-5904) The result should be empty list when table sample rate is 0

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752268#comment-17752268 ] LakeShen commented on CALCITE-5904: --- Hi [~jiajunbernoulli] ,yes, I will create new PR

[jira] [Updated] (CALCITE-5896) Document TLS client certificate JDBC URL options

2023-08-08 Thread Istvan Toth (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Istvan Toth updated CALCITE-5896: - Summary: Document TLS client certificate JDBC URL options (was: Document client certificate JD

[jira] [Commented] (CALCITE-5904) The result should be empty list when table sample rate is 0

2023-08-08 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752264#comment-17752264 ] Jiajun Xie commented on CALCITE-5904: - You closed it, do you plan to create new PR?

[jira] [Commented] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752261#comment-17752261 ] LakeShen commented on CALCITE-5913: --- Maybe Functional dependencies is challenging to

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752258#comment-17752258 ] LakeShen commented on CALCITE-5894: --- FunctionalDependency is a very important optimiz

[jira] [Closed] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas closed CALCITE-5844. Resolution: Not A Problem > Make RelMdColumnOrigins to be extendable for getting columnOrigins from > vi

[jira] [Commented] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752242#comment-17752242 ] JingDas commented on CALCITE-5844: -- Current capacity already support to get metadata f

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Comment Edited] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752235#comment-17752235 ] JingDas edited comment on CALCITE-5894 at 8/9/23 3:09 AM: -- As

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752235#comment-17752235 ] JingDas commented on CALCITE-5894: -- As said in the book [《Exploiting Functional Depend

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Updated] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5913: - Description: Functional dependency analysis can be applied to various problems in query optimization:

[jira] [Created] (CALCITE-5913) Support to get functional dependency metadata in RelMetadataQuery

2023-08-08 Thread JingDas (Jira)
JingDas created CALCITE-5913: Summary: Support to get functional dependency metadata in RelMetadataQuery Key: CALCITE-5913 URL: https://issues.apache.org/jira/browse/CALCITE-5913 Project: Calcite

[jira] [Updated] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent by other sort fields

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JingDas updated CALCITE-5894: - Summary: Add SortRemoveRedundantRule to remove redundant sort fields if they are functionally dependent

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

2023-08-08 Thread JingDas (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752234#comment-17752234 ] JingDas commented on CALCITE-5894: -- [~julianhyde] I see your point and aggre with you,

[jira] [Updated] (CALCITE-5912) Add an implementation of TABLESAMPLE in enumerable mode.

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5912: -- Description: In Calcite, the TableSample SQL statement will be converted to Sample RelNode plan tree

[jira] [Updated] (CALCITE-5912) Add an implementation of TABLESAMPLE in enumerable mode.

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5912: -- Description: In Calcite, the TableSample SQL statement will be converted to Sample RelNode plan tree

[jira] [Updated] (CALCITE-5912) Add an implementation of TABLESAMPLE in enumerable mode.

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5912: -- Description: In Calcite, the TableSample SQL statement will be converted to Sample RelNode plan tree

[jira] [Created] (CALCITE-5912) Add an implementation of TABLESAMPLE in enumerable mode.

2023-08-08 Thread LakeShen (Jira)
LakeShen created CALCITE-5912: - Summary: Add an implementation of TABLESAMPLE in enumerable mode. Key: CALCITE-5912 URL: https://issues.apache.org/jira/browse/CALCITE-5912 Project: Calcite Issue

[jira] [Commented] (CALCITE-5895) The result of table sample rate 0 is incorrect result and should return the empty result

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752224#comment-17752224 ] LakeShen commented on CALCITE-5895: --- Hi,[~julianhyde] ,thank you very much for your p

[jira] [Commented] (CALCITE-5909) Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords fails in the IDE but passes when run from the command line

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752223#comment-17752223 ] Julian Hyde commented on CALCITE-5909: -- I've reopened it, because a flaky test is

[jira] [Updated] (CALCITE-5909) Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords fails in the IDE but passes when run from the command line

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5909: - Summary: Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords fails in the IDE but passe

[jira] [Updated] (CALCITE-5909) Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords fails in the IDE but passes when run from the command line

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5909: - Priority: Minor (was: Major) > Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords fai

[jira] [Updated] (CALCITE-5909) Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords fails in the IDE but passes when run from the command line

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-5909: - Fix Version/s: (was: 1.36.0) > Sometimes SqlParserTest.testNoUnintendedNewReservedKeywords

[jira] [Reopened] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-5909: -- > SqlParserTest has a failed unit test, but the Calcite pipeline passed all of > them >

[jira] [Closed] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen closed CALCITE-5909. - Resolution: Not A Problem > SqlParserTest has a failed unit test, but the Calcite pipeline passed all o

[jira] [Commented] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1775#comment-1775 ] LakeShen commented on CALCITE-5909: --- Hi [~jhyde] [~taoran] ,thanks for your reply, I

[jira] [Commented] (CALCITE-5895) The result of table sample rate 0 is incorrect result and should return the empty result

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752205#comment-17752205 ] Julian Hyde commented on CALCITE-5895: -- I agree this is a bug, and we should fix i

[jira] [Resolved] (CALCITE-5869) LEAST_RESTRICTIVE does not use inner type of MEASURE for comparisons

2023-08-08 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-5869. --- Fix Version/s: 1.36.0 Resolution: Fixed Merged via [95c4ac|https://github.com/apach

[jira] [Updated] (CALCITE-5910) Add REGEXP_EXTRACT and REGEXP_SUBSTR functions (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Description: Add support for [REGEXP_EXTRACT|https://cloud.google.com/bigquery/docs/reference/st

[jira] [Updated] (CALCITE-5910) Add REGEXP_EXTRACT function (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Description: Add support for [REGEXP_EXTRACT|https://cloud.google.com/bigquery/docs/reference/st

[jira] [Updated] (CALCITE-5910) Add REGEXP_EXTRACT and REGEXP_SUBSTR functions (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Summary: Add REGEXP_EXTRACT and REGEXP_SUBSTR functions (enabled in BigQuery library) (was: Add

[jira] [Comment Edited] (CALCITE-5910) Add REGEXP_EXTRACT function (enabled in BigQuery library)

2023-08-08 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752187#comment-17752187 ] Mihai Budiu edited comment on CALCITE-5910 at 8/8/23 9:58 PM: ---

[jira] [Commented] (CALCITE-5910) Add REGEXP_EXTRACT function (enabled in BigQuery library)

2023-08-08 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752187#comment-17752187 ] Mihai Budiu commented on CALCITE-5910: -- First, let me make the disclaimer that I a

[jira] [Commented] (CALCITE-5910) Add REGEXP_EXTRACT function (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752184#comment-17752184 ] Jerin John commented on CALCITE-5910: - Thanks for the pointer [~mbudiu], I tried im

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752182#comment-17752182 ] Julian Hyde commented on CALCITE-5894: -- Here is a sketch for the new metadata: {co

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752179#comment-17752179 ] Julian Hyde commented on CALCITE-5894: -- We can generalize a little. If we have "OR

[jira] [Commented] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752177#comment-17752177 ] Julian Hyde commented on CALCITE-5894: -- [~libenchao], There is a significant benef

[jira] [Comment Edited] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752168#comment-17752168 ] Julian Hyde edited comment on CALCITE-5889 at 8/8/23 8:13 PM: ---

[jira] [Commented] (CALCITE-5889) Add the RelRule that converts Minus into UNION ALL..GROUP BY...WHERE

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752168#comment-17752168 ] Julian Hyde commented on CALCITE-5889: -- You're right. For regular EXCEPT the condi

[jira] [Updated] (CALCITE-5905) Documentation for CREATE TYPE is incorrect

2023-08-08 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5905: Labels: pull-request-available (was: ) > Documentation for CREATE TYPE is incorrect > --

[jira] [Assigned] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-08-08 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5290: Assignee: Guillaume Massé (was: TJ Banghart) > Add DATE_TRUNC function consistent with

[jira] [Updated] (CALCITE-5858) Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5858: Summary: Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE an

[jira] [Updated] (CALCITE-5910) Add REGEXP_EXTRACT function (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Summary: Add REGEXP_EXTRACT function (enabled in BigQuery library) (was: Implement BigQuery func

[jira] [Updated] (CALCITE-5873) Add REGEXP_CONTAINS function (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5873: Summary: Add REGEXP_CONTAINS function (enabled in BigQuery library) (was: Add REGEXP_EXTRACT_ALL

[jira] [Updated] (CALCITE-5873) Add REGEXP_EXTRACT_ALL function (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5873: Summary: Add REGEXP_EXTRACT_ALL function (enabled in BigQuery library) (was: Implement BigQuery

[jira] [Updated] (CALCITE-5911) Add REGEXP_EXTRACT_ALL function (enabled in BigQuery library)

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5911: Summary: Add REGEXP_EXTRACT_ALL function (enabled in BigQuery library) (was: Implement BigQuery

[jira] [Updated] (CALCITE-5910) Implement BigQuery function REGEXP_EXTRACT

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Description: Add support for [REGEXP_EXTRACT|https://cloud.google.com/bigquery/docs/reference/st

[jira] [Updated] (CALCITE-5910) Implement BigQuery function REGEXP_EXTRACT

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Description: Add support for [REGEXP_EXTRACT|https://cloud.google.com/bigquery/docs/reference/st

[jira] [Updated] (CALCITE-5911) Implement BigQuery function REGEXP_EXTRACT_ALL

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5911: Parent: (was: CALCITE-5858) Issue Type: Task (was: Sub-task) > Implement BigQuery fu

[jira] [Updated] (CALCITE-5911) Implement BigQuery function REGEXP_EXTRACT_ALL

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5911: Parent: CALCITE-5858 Issue Type: Sub-task (was: Task) > Implement BigQuery function REGE

[jira] [Updated] (CALCITE-5911) Implement BigQuery function REGEXP_EXTRACT_ALL

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5911: Description: Add support for [REGEXP_EXTRACT_ALL|https://cloud.google.com/bigquery/docs/referenc

[jira] [Updated] (CALCITE-5910) Implement BigQuery functions REGEXP_EXTRACT and REGEXP_EXTRACT_ALL

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Description: Add support for [REGEXP_EXTRACT|https://cloud.google.com/bigquery/docs/reference/st

[jira] [Created] (CALCITE-5911) Implement BigQuery function REGEXP_EXTRACT_ALL

2023-08-08 Thread Jerin John (Jira)
Jerin John created CALCITE-5911: --- Summary: Implement BigQuery function REGEXP_EXTRACT_ALL Key: CALCITE-5911 URL: https://issues.apache.org/jira/browse/CALCITE-5911 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-5910) Implement BigQuery function REGEXP_EXTRACT

2023-08-08 Thread Jerin John (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jerin John updated CALCITE-5910: Summary: Implement BigQuery function REGEXP_EXTRACT (was: Implement BigQuery functions REGEXP_EX

[jira] [Commented] (CALCITE-5910) Implement BigQuery functions REGEXP_EXTRACT and REGEXP_EXTRACT_ALL

2023-08-08 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752146#comment-17752146 ] Mihai Budiu commented on CALCITE-5910: -- There are many languages that describe reg

[jira] [Created] (CALCITE-5910) Implement BigQuery functions REGEXP_EXTRACT and REGEXP_EXTRACT_ALL

2023-08-08 Thread Jerin John (Jira)
Jerin John created CALCITE-5910: --- Summary: Implement BigQuery functions REGEXP_EXTRACT and REGEXP_EXTRACT_ALL Key: CALCITE-5910 URL: https://issues.apache.org/jira/browse/CALCITE-5910 Project: Calcite

[jira] [Comment Edited] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752141#comment-17752141 ] Ran Tao edited comment on CALCITE-5908 at 8/8/23 5:32 PM: -- Sor

[jira] [Reopened] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao reopened CALCITE-5908: -- > Remove unnecessary NULL checks in CalciteSchema > --- > >

[jira] [Closed] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao closed CALCITE-5908. Resolution: Not A Problem > Remove unnecessary NULL checks in CalciteSchema > ---

[jira] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908 ] Ran Tao deleted comment on CALCITE-5908: -- was (Author: lemonjing): [~jhyde] I have checked it. it's a very old version in 1.13 make this change. [https://github.com/apache/calcite/pull/421/fil

[jira] [Closed] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao closed CALCITE-5908. Resolution: Not A Problem > Remove unnecessary NULL checks in CalciteSchema > ---

[jira] [Comment Edited] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752141#comment-17752141 ] Ran Tao edited comment on CALCITE-5908 at 8/8/23 5:28 PM: -- I d

[jira] [Comment Edited] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752141#comment-17752141 ] Ran Tao edited comment on CALCITE-5908 at 8/8/23 5:28 PM: -- I I

[jira] [Reopened] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao reopened CALCITE-5908: -- > Remove unnecessary NULL checks in CalciteSchema > --- > >

[jira] [Commented] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752141#comment-17752141 ] Ran Tao commented on CALCITE-5908: -- I'm not go deep into the commit to understand why,

[jira] [Closed] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao closed CALCITE-5908. Resolution: Not A Problem > Remove unnecessary NULL checks in CalciteSchema > ---

[jira] [Updated] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Guillaume Massé updated CALCITE-5909: - Description: When I run the SqlParserTest,the testNoUnintendedNewReservedKeywords metho

[jira] [Commented] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-08-08 Thread Jira
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752128#comment-17752128 ] Guillaume Massé commented on CALCITE-5290: -- [~tjbanghart] yup you can re-assig

[jira] [Commented] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-08-08 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752127#comment-17752127 ] TJ Banghart commented on CALCITE-5290: -- [~MasseGuillaume] that would be great! I h

[jira] [Comment Edited] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752121#comment-17752121 ] Ran Tao edited comment on CALCITE-5909 at 8/8/23 4:15 PM: -- [~s

[jira] [Commented] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752121#comment-17752121 ] Ran Tao commented on CALCITE-5909: -- [~shenlang]  +1 The IDE sometimes fail to execute

[jira] [Comment Edited] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752118#comment-17752118 ] Ran Tao edited comment on CALCITE-5908 at 8/8/23 4:11 PM: -- [~j

[jira] [Comment Edited] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752118#comment-17752118 ] Ran Tao edited comment on CALCITE-5908 at 8/8/23 4:07 PM: -- [~j

[jira] [Commented] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752118#comment-17752118 ] Ran Tao commented on CALCITE-5908: -- [~jhyde] I have checked it. it's a very old versio

[jira] [Commented] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752113#comment-17752113 ] Julian Hyde commented on CALCITE-5909: -- I’ve seen this happen, too. I think the ID

[jira] [Updated] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5908: Labels: pull-request-available (was: ) > Remove unnecessary NULL checks in CalciteSchema

[jira] [Updated] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5909: -- Description: When I run the SqlParserTest,the testNoUnintendedNewReservedKeywords method failed,the

[jira] [Updated] (CALCITE-5908) Remove unnecessary NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5908: - Summary: Remove unnecessary NULL checks in CalciteSchema (was: Remove misleading NULL checks in Calcit

[jira] [Commented] (CALCITE-5908) Remove misleading NULL checks in CalciteSchema

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752102#comment-17752102 ] Julian Hyde commented on CALCITE-5908: -- Do you understand why those checks were ad

[jira] [Updated] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5909: -- Attachment: image-2023-08-08-23-32-55-466.png Component/s: tests Fix Version/s: 1.36.0

[jira] [Created] (CALCITE-5909) SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them

2023-08-08 Thread LakeShen (Jira)
LakeShen created CALCITE-5909: - Summary: SqlParserTest has a failed unit test, but the Calcite pipeline passed all of them Key: CALCITE-5909 URL: https://issues.apache.org/jira/browse/CALCITE-5909 Project

[jira] [Created] (CALCITE-5908) Remove misleading NULL checks in CalciteSchema

2023-08-08 Thread Ran Tao (Jira)
Ran Tao created CALCITE-5908: Summary: Remove misleading NULL checks in CalciteSchema Key: CALCITE-5908 URL: https://issues.apache.org/jira/browse/CALCITE-5908 Project: Calcite Issue Type: Improv

[jira] [Commented] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-08 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752095#comment-17752095 ] Julian Hyde commented on CALCITE-5907: -- I agree with[~kgyrtkirk]. The RexCall to E

[jira] [Comment Edited] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-08 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752094#comment-17752094 ] Zoltan Haindrich edited comment on CALCITE-5907 at 8/8/23 3:17 PM: --

[jira] [Commented] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-08 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752094#comment-17752094 ] Zoltan Haindrich commented on CALCITE-5907: --- I believe both operands should b

[jira] [Assigned] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen reassigned CALCITE-5906: - Assignee: LakeShen > RelToSqlConverter throw AssertionError when RelNode tree has the Sample

[jira] [Updated] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode

2023-08-08 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-5906: Labels: pull-request-available (was: ) > RelToSqlConverter throw AssertionError when Rel

[jira] [Resolved] (CALCITE-5827) Add IS_INF and IS_NAN functions (enabled in BigQuery library)

2023-08-08 Thread Tanner Clary (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tanner Clary resolved CALCITE-5827. --- Fix Version/s: 1.36.0 Resolution: Fixed Merged via [25f326c|https://github.com/apac

[jira] [Resolved] (CALCITE-5903) RelMdCollation does not define collations for EnumerableLimit

2023-08-08 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5903. Resolution: Fixed Fixed via   [{{0cea91b}}|https://github.com/apache/calcite/commit/0cea91b8426d4

[jira] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5906 ] LakeShen deleted comment on CALCITE-5906: --- was (Author: shenlang): Because of the TableSample percentage is float datatype, like this : !image-2023-08-08-20-16-27-188.png|width=322,height=133!

[jira] [Updated] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-08 Thread Yunhong Zheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yunhong Zheng updated CALCITE-5907: --- Description: As FLINK-27402  shown. If we have a table  MyTable(a Int, b Boolean, c String)

[jira] [Commented] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-08 Thread Yunhong Zheng (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752022#comment-17752022 ] Yunhong Zheng commented on CALCITE-5907: Hi, [~julianhyde] . This looks like th

[jira] [Commented] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752021#comment-17752021 ] LakeShen commented on CALCITE-5906: --- Because of the TableSample percentage is float d

[jira] [Updated] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5906: -- Attachment: image-2023-08-08-20-19-01-269.png > RelToSqlConverter throw AssertionError when RelNode t

[jira] [Created] (CALCITE-5907) Unexpected boolean expression simplification for And expression

2023-08-08 Thread Yunhong Zheng (Jira)
Yunhong Zheng created CALCITE-5907: -- Summary: Unexpected boolean expression simplification for And expression Key: CALCITE-5907 URL: https://issues.apache.org/jira/browse/CALCITE-5907 Project: Calcit

[jira] [Updated] (CALCITE-5906) RelToSqlConverter throw AssertionError when RelNode tree has the Sample RelNode

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LakeShen updated CALCITE-5906: -- Attachment: image-2023-08-08-20-16-27-188.png > RelToSqlConverter throw AssertionError when RelNode t

[jira] [Commented] (CALCITE-5870) Allow literals like DECIMAL '12.3' (consistent with Postgres)

2023-08-08 Thread LakeShen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17751941#comment-17751941 ] LakeShen commented on CALCITE-5870: --- This PR is Ready, if others have time, please he

  1   2   >