[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

[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=17811465#comment-17811465 ] Ran Tao edited comment on CALCITE-6063 at 1/27/24 3:47 AM: --- Fixed via

[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=17811465#comment-17811465 ] Ran Tao commented on CALCITE-6063: -- Fixed via

[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=17811454#comment-17811454 ] Caican Cai commented on CALCITE-6222: - thank everyone > Mysql does not have to_char function >

[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=17811392#comment-17811392 ] Julian Hyde commented on CALCITE-6063: -- Looks good. I asked for validator test but I see you added

[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=17811389#comment-17811389 ] Julian Hyde commented on CALCITE-6222: -- The first step in this case should have been to contact

[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=17811387#comment-17811387 ] Julian Hyde edited comment on CALCITE-6230 at 1/26/24 8:12 PM: --- Maybe the

[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=17811387#comment-17811387 ] Julian Hyde commented on CALCITE-6230: -- Maybe the intention of this case is to group cases to make

[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

[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

[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=17811287#comment-17811287 ] Caican Cai commented on CALCITE-6224: - thank you > Add LOG2 function (enabled in Mysql, Spark

[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=17811261#comment-17811261 ] Rodrigo Rueda commented on CALCITE-6226: Thanks, [~tanclary] I ended up fixing another issue

[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

[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=17811250#comment-17811250 ] Jiajun Xie commented on CALCITE-6222: - Calcite has many users, and any compatibility changes should

[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=17811245#comment-17811245 ] Jiajun Xie commented on CALCITE-6222: - MariaDB have it: [https://mariadb.com/kb/en/to_char/] If

[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

[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

[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=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=17811192#comment-17811192 ] Alessandro Solimando commented on CALCITE-6230: --- [~hongyuguo], what's the purpose of this

[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

[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