[jira] [Commented] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

2024-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836014#comment-17836014 ] Julian Hyde commented on CALCITE-6361: -- By the way, please don't say 'crashes'. Sa

[jira] [Commented] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

2024-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17836013#comment-17836013 ] Julian Hyde commented on CALCITE-6361: -- Is there a SQL query that reproduces this

[jira] [Created] (CALCITE-6361) Uncollect.deriveUncollectRowType crashes if the input data is not a collection

2024-04-10 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6361: Summary: Uncollect.deriveUncollectRowType crashes if the input data is not a collection Key: CALCITE-6361 URL: https://issues.apache.org/jira/browse/CALCITE-6361 Proj

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

2024-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835918#comment-17835918 ] Julian Hyde commented on CALCITE-6358: -- [~njordan], To be clear, which functions a

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

2024-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835917#comment-17835917 ] Julian Hyde commented on CALCITE-6357: -- [~brachi_packter], It might be useful to r

[jira] [Resolved] (CALCITE-6360) Add .asf.yaml to calcite-avatica-go repository

2024-04-10 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-6360. - Resolution: Fixed > Add .asf.yaml to calcite-avatica-go repository > --

[jira] [Created] (CALCITE-6360) Add .asf.yaml to calcite-avatica-go repository

2024-04-10 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-6360: --- Summary: Add .asf.yaml to calcite-avatica-go repository Key: CALCITE-6360 URL: https://issues.apache.org/jira/browse/CALCITE-6360 Project: Calcite Issu

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

2024-04-10 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835912#comment-17835912 ] Norman Jordan commented on CALCITE-6358: https://www.postgresql.org/docs/14/fun

[jira] [Resolved] (CALCITE-6359) Update GitHub Actions workflows to use docker compose v2

2024-04-10 Thread Francis Chuang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Francis Chuang resolved CALCITE-6359. - Resolution: Fixed > Update GitHub Actions workflows to use docker compose v2 >

[jira] [Updated] (CALCITE-6359) Update GitHub Actions workflows to use docker compose v2

2024-04-10 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6359: Labels: pull-request-available (was: ) > Update GitHub Actions workflows to use docker c

[jira] [Created] (CALCITE-6359) Update GitHub Actions workflows to use docker compose v2

2024-04-10 Thread Francis Chuang (Jira)
Francis Chuang created CALCITE-6359: --- Summary: Update GitHub Actions workflows to use docker compose v2 Key: CALCITE-6359 URL: https://issues.apache.org/jira/browse/CALCITE-6359 Project: Calcite

[jira] [Resolved] (CALCITE-6327) getValidatedNodeTypeIfKnown should never throw

2024-04-10 Thread James Duong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Duong resolved CALCITE-6327. -- Resolution: Fixed This was fixed in CALCITE-6015 > getValidatedNodeTypeIfKnown should never

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

2024-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835893#comment-17835893 ] Julian Hyde commented on CALCITE-6357: -- *Caveat*: I haven't read every word you've

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

2024-04-10 Thread Norman Jordan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Norman Jordan updated CALCITE-6358: --- Description: Many of the date/time format patterns supported by PostgreSQL 14 are not supp

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

2024-04-10 Thread Kenneth Knowles (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835868#comment-17835868 ] Kenneth Knowles commented on CALCITE-6357: -- [~julianhyde] - are we "holding it

[jira] [Resolved] (CALCITE-6355) RelToSqlConverter[ORDER BY] generates an incorrect order by when NULLS LAST is used in non-projected field

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

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

2024-04-10 Thread Brachi Packter (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835858#comment-17835858 ] Brachi Packter edited comment on CALCITE-6357 at 4/10/24 7:09 PM: ---

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

2024-04-10 Thread Brachi Packter (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835858#comment-17835858 ] Brachi Packter edited comment on CALCITE-6357 at 4/10/24 7:09 PM: ---

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

2024-04-10 Thread Brachi Packter (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835858#comment-17835858 ] Brachi Packter commented on CALCITE-6357: - > If the number of fields does not m

[jira] [Comment Edited] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

2024-04-10 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835836#comment-17835836 ] James Starr edited comment on CALCITE-5743 at 4/10/24 5:54 PM: --

[jira] [Comment Edited] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

2024-04-10 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835836#comment-17835836 ] James Starr edited comment on CALCITE-5743 at 4/10/24 5:51 PM: --

[jira] [Commented] (CALCITE-5743) Query gives incorrect result when COUNT appears in the correlated subquery select list

2024-04-10 Thread James Starr (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835836#comment-17835836 ] James Starr commented on CALCITE-5743: -- I think you have to join the value generat

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

2024-04-10 Thread Norman Jordan (Jira)
Norman Jordan created CALCITE-6358: -- Summary: Support all PostgreSQL 14 date/time patterns Key: CALCITE-6358 URL: https://issues.apache.org/jira/browse/CALCITE-6358 Project: Calcite Issue Ty

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

2024-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835833#comment-17835833 ] Julian Hyde commented on CALCITE-6357: -- If the number of fields does not match, th

[jira] [Resolved] (CALCITE-6286) Optimizing ARRAY_REPEAT expression causes an assertion failure

2024-04-10 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6286. -- Fix Version/s: 1.37.0 Resolution: Fixed > Optimizing ARRAY_REPEAT expression causes an

[jira] [Resolved] (CALCITE-6210) Cast to VARBINARY causes an assertion failure

2024-04-10 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6210. -- Resolution: Fixed > Cast to VARBINARY causes an assertion failure > -

[jira] [Commented] (CALCITE-6210) Cast to VARBINARY causes an assertion failure

2024-04-10 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835830#comment-17835830 ] Mihai Budiu commented on CALCITE-6210: -- Fixed in https://github.com/apache/calcit

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

2024-04-10 Thread Brachi Packter (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brachi Packter updated CALCITE-6357: Description: Calcite RelBuilder.ProjectNamed checks if row size in the select is identica

[jira] [Commented] (CALCITE-5390) RelDecorrelator throws NullPointerException

2024-04-10 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17835683#comment-17835683 ] Ruben Q L commented on CALCITE-5390: Recently I stumbled upon this bug, in my case

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

2024-04-10 Thread Brachi Packter (Jira)
Brachi Packter created CALCITE-6357: --- Summary: Calcite enforces select argument count to be same as row schema fields which causes aliases to be ignored Key: CALCITE-6357 URL: https://issues.apache.org/jira/brow

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

2024-04-10 Thread Brachi Packter (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brachi Packter updated CALCITE-6357: Summary: Calcite enforces select arguments count to be same as row schema fields which ca