[jira] [Updated] (CALCITE-6231) ORDINALITY is omitted during the RelToSql stage

2024-01-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6231: Labels: pull-request-available (was: ) > ORDINALITY is omitted during the RelToSql stage

[jira] [Assigned] (CALCITE-6231) ORDINALITY is omitted during the RelToSql stage

2024-01-26 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu reassigned CALCITE-6231: Assignee: EveyWu > ORDINALITY is omitted during the RelToSql stage > --

[jira] [Created] (CALCITE-6231) ORDINALITY is omitted during the RelToSql stage

2024-01-26 Thread EveyWu (Jira)
EveyWu created CALCITE-6231: Summary: ORDINALITY is omitted during the RelToSql stage Key: CALCITE-6231 URL: https://issues.apache.org/jira/browse/CALCITE-6231 Project: Calcite Issue Type: Bug

[jira] [Comment Edited] (CALCITE-6063) If ARRAY subquery has ORDER BY (without LIMIT), rows are not sorted

2024-01-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811465#comment-17811465 ] Ran Tao edited comment on CALCITE-6063 at 1/27/24 3:47 AM: --- F

[jira] [Commented] (CALCITE-6063) If ARRAY subquery has ORDER BY (without LIMIT), rows are not sorted

2024-01-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811465#comment-17811465 ] Ran Tao commented on CALCITE-6063: -- Fixed via [dc4ce8b31c4927f6f43d6b6f81533ac232e1f7

[jira] [Resolved] (CALCITE-6063) If ARRAY subquery has ORDER BY (without LIMIT), rows are not sorted

2024-01-26 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao resolved CALCITE-6063. -- Resolution: Fixed > If ARRAY subquery has ORDER BY (without LIMIT), rows are not sorted > ---

[jira] [Commented] (CALCITE-6222) Mysql does not have to_char function

2024-01-26 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811454#comment-17811454 ] Caican Cai commented on CALCITE-6222: - thank everyone > Mysql does not have to_cha

[jira] [Commented] (CALCITE-6063) If ARRAY subquery has ORDER BY (without LIMIT), rows are not sorted

2024-01-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811392#comment-17811392 ] Julian Hyde commented on CALCITE-6063: -- Looks good. I asked for validator test but

[jira] [Resolved] (CALCITE-6222) Mysql does not have to_char function

2024-01-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-6222. -- Resolution: Invalid > Mysql does not have to_char function >

[jira] [Reopened] (CALCITE-6222) Mysql does not have to_char function

2024-01-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-6222: -- > Mysql does not have to_char function > > >

[jira] [Commented] (CALCITE-6222) Mysql does not have to_char function

2024-01-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811389#comment-17811389 ] Julian Hyde commented on CALCITE-6222: -- The first step in this case should have be

[jira] [Comment Edited] (CALCITE-6230) Jira case collections

2024-01-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811387#comment-17811387 ] Julian Hyde edited comment on CALCITE-6230 at 1/26/24 8:12 PM: --

[jira] [Commented] (CALCITE-6230) Jira case collections

2024-01-26 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811387#comment-17811387 ] Julian Hyde commented on CALCITE-6230: -- Maybe the intention of this case is to gro

[jira] [Resolved] (CALCITE-5649) Produce row count statistics from ReflectiveSchema for array based tables

2024-01-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-5649. -- Fix Version/s: 1.37.0 Resolution: Fixed Fixed in https://github.com/apache/calcite/co

[jira] [Resolved] (CALCITE-6227) ELEMENT(NULL) causes an assertion failure

2024-01-26 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6227. -- Fix Version/s: 1.37.0 Resolution: Fixed Resolved in https://github.com/apache/calcite

[jira] [Commented] (CALCITE-6224) Add LOG2 function (enabled in Mysql, Spark library)

2024-01-26 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811287#comment-17811287 ] Caican Cai commented on CALCITE-6224: - thank you > Add LOG2 function (enabled in M

[jira] [Commented] (CALCITE-6226) Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE

2024-01-26 Thread Rodrigo Rueda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811261#comment-17811261 ] Rodrigo Rueda commented on CALCITE-6226: Thanks, [~tanclary] I ended up fixing

[jira] [Updated] (CALCITE-6226) Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE

2024-01-26 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6226: Labels: pull-request-available (was: ) > Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT

[jira] [Commented] (CALCITE-6222) Mysql does not have to_char function

2024-01-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811250#comment-17811250 ] Jiajun Xie commented on CALCITE-6222: - Calcite has many users, and any compatibilit

[jira] [Commented] (CALCITE-6222) Mysql does not have to_char function

2024-01-26 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811245#comment-17811245 ] Jiajun Xie commented on CALCITE-6222: - MariaDB have it: [https://mariadb.com/kb/en/

[jira] [Updated] (CALCITE-6230) Jira case collections

2024-01-26 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6230: Description: Related thread: [Collection of some jira cases|https://lists.apache.org/thread/tmtq

[jira] [Updated] (CALCITE-6230) Jira case collections

2024-01-26 Thread hongyu guo (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongyu guo updated CALCITE-6230: Description: Relate thread: [Collection of some jira cases|https://lists.apache.org/thread/tmtql

[jira] [Comment Edited] (CALCITE-6230) Jira case collections

2024-01-26 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811192#comment-17811192 ] Alessandro Solimando edited comment on CALCITE-6230 at 1/26/24 9:57 AM: -

[jira] [Commented] (CALCITE-6230) Jira case collections

2024-01-26 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17811192#comment-17811192 ] Alessandro Solimando commented on CALCITE-6230: --- [~hongyuguo], what's the

[jira] [Created] (CALCITE-6230) Jira case collections

2024-01-26 Thread hongyu guo (Jira)
hongyu guo created CALCITE-6230: --- Summary: Jira case collections Key: CALCITE-6230 URL: https://issues.apache.org/jira/browse/CALCITE-6230 Project: Calcite Issue Type: Task Reporter

[jira] [Updated] (CALCITE-6224) Add LOG2 function (enabled in Mysql, Spark library)

2024-01-26 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6224: Summary: Add LOG2 function (enabled in Mysql, Spark library) (was: Add LOG2 function on SqlStdOp