[jira] [Comment Edited] (CALCITE-6193) If a query has more than one subexpression that matches a materialized view, only the first is substituted

2024-02-29 Thread Mou Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822429#comment-17822429 ] Mou Wu edited comment on CALCITE-6193 at 3/1/24 7:51 AM: - [~jiajunbernoulli]

[jira] [Comment Edited] (CALCITE-6193) If a query has more than one subexpression that matches a materialized view, only the first is substituted

2024-02-29 Thread Mou Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822429#comment-17822429 ] Mou Wu edited comment on CALCITE-6193 at 3/1/24 7:48 AM: - [~jiajunbernoulli]

[jira] [Commented] (CALCITE-6193) If a query has more than one subexpression that matches a materialized view, only the first is substituted

2024-02-29 Thread Mou Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822429#comment-17822429 ] Mou Wu commented on CALCITE-6193: - [~jiajunbernoulli] The reason of issue 1 is issue 2. It's still

[jira] [Updated] (CALCITE-5976) Use explicit CAST if inserted element type in ArrayPrepend/ArrayAppend/ArrayInsert does not equal derived component type

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-5976: - Summary: Use explicit CAST if inserted element type in ArrayPrepend/ArrayAppend/ArrayInsert does not

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822359#comment-17822359 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 3:11 AM: -- Yes, agree with

[jira] [Assigned] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao reassigned CALCITE-6285: Assignee: Ran Tao > Function ARRAY_INSERT produces an incorrect result for negative indices >

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822355#comment-17822355 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 3:06 AM: -- Since spark-3.4.2

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822359#comment-17822359 ] Ran Tao commented on CALCITE-6285: -- Yes, it should be a bugfix. > Function ARRAY_INSERT produces an

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822359#comment-17822359 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 3:05 AM: -- Yes, agree with

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 3:04 AM: -- [~mbudiu] the

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822356#comment-17822356 ] Mihai Budiu commented on CALCITE-6285: -- I would say "correct". "Optimize" would imply that it's

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822355#comment-17822355 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 3:01 AM: -- Since spark-3.4.2

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822355#comment-17822355 ] Ran Tao commented on CALCITE-6285: -- Since spark-3.4.2 and the latest 3.5.0 version have been fixed, I

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822355#comment-17822355 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 3:00 AM: -- Since spark-3.4.2

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 2:58 AM: -- [~mbudiu] the

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822354#comment-17822354 ] Mihai Budiu commented on CALCITE-6285: -- [~taoran] this makes sense, I will let you decide what

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 2:57 AM: -- [~mbudiu] the

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 2:55 AM: -- [~mbudiu]the

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 2:55 AM: -- [~mbudiu] the

[jira] [Comment Edited] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao edited comment on CALCITE-6285 at 3/1/24 2:55 AM: -- [~mbudiu] the

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822353#comment-17822353 ] Ran Tao commented on CALCITE-6285: -- [~mbudiu]the calcite implementation is compatibled with <=

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822351#comment-17822351 ] Mihai Budiu commented on CALCITE-6285: -- True, but many people don't always upgrade to the latest

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822349#comment-17822349 ] EveyWu commented on CALCITE-6285: -- I agree with you > Function ARRAY_INSERT produces an incorrect

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822347#comment-17822347 ] EveyWu commented on CALCITE-6285: -- Another simpler way, can we keep consistent with the latest

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822348#comment-17822348 ] Mihai Budiu commented on CALCITE-6285: -- https://issues.apache.org/jira/browse/SPARK-44840 suggests

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822346#comment-17822346 ] Mihai Budiu commented on CALCITE-6285: -- Spark didn't bump the minor version for this change, so I

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822344#comment-17822344 ] Mihai Budiu commented on CALCITE-6285: -- The only solution I can imagine is having two spark

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822343#comment-17822343 ] EveyWu commented on CALCITE-6285: -- I think the Spark version update causes the problem,  -1 for which

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: (was: image-2024-03-01-10-35-11-673.png) > Function ARRAY_INSERT produces an incorrect

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: image-2024-03-01-10-35-11-673.png > Function ARRAY_INSERT produces an incorrect result for

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: (was: image-2024-03-01-10-31-55-853.png) > Function ARRAY_INSERT produces an incorrect

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822341#comment-17822341 ] Mihai Budiu commented on CALCITE-6285: -- Is this the image you intended to attach? > Function

[jira] [Updated] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread EveyWu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] EveyWu updated CALCITE-6285: Attachment: image-2024-03-01-10-31-55-853.png > Function ARRAY_INSERT produces an incorrect result for

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

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6286: - Description: The following RelOptRulesTest causes an assertion failure: {code:java} @Test

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

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6286: - Summary: Optimizing ARRAY_REPEAT expression causes an assertion failure (was: Optimizing

[jira] [Created] (CALCITE-6286) Optimizing ARRAY_INSERT expression causes an assertion failure

2024-02-29 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6286: Summary: Optimizing ARRAY_INSERT expression causes an assertion failure Key: CALCITE-6286 URL: https://issues.apache.org/jira/browse/CALCITE-6286 Project: Calcite

[jira] [Commented] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822256#comment-17822256 ] Mihai Budiu commented on CALCITE-6285: -- [~taoran] you seem to have added these tests not that long

[jira] [Created] (CALCITE-6285) Function ARRAY_INSERT produces an incorrect result for negative indices

2024-02-29 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6285: Summary: Function ARRAY_INSERT produces an incorrect result for negative indices Key: CALCITE-6285 URL: https://issues.apache.org/jira/browse/CALCITE-6285 Project:

[jira] [Comment Edited] (CALCITE-6193) If a query has more than one subexpression that matches a materialized view, only the first is substituted

2024-02-29 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822079#comment-17822079 ] Jiajun Xie edited comment on CALCITE-6193 at 2/29/24 11:01 AM: --- [~4wei]

[jira] [Commented] (CALCITE-6193) If a query has more than one subexpression that matches a materialized view, only the first is substituted

2024-02-29 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822079#comment-17822079 ] Jiajun Xie commented on CALCITE-6193: - [~4wei] Your thinking is too one-sided.   There are two

[jira] [Resolved] (CALCITE-6280) Jetty version number leaked by Avatica http server

2024-02-29 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando resolved CALCITE-6280. --- Resolution: Fixed > Jetty version number leaked by Avatica http server >

[jira] [Reopened] (CALCITE-6280) Jetty version number leaked by Avatica http server

2024-02-29 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando reopened CALCITE-6280: --- > Jetty version number leaked by Avatica http server >

[jira] [Commented] (CALCITE-6280) Jetty version number leaked by Avatica http server

2024-02-29 Thread Vaibhav Joshi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17822005#comment-17822005 ] Vaibhav Joshi commented on CALCITE-6280: Thanks [~stoty] for reviewing and merging the PR. >