[jira] [Commented] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796516#comment-17796516 ] Caican Cai commented on CALCITE-6164: - [~julianhyde] Hi, maybe I can add avg tests in other places,

[jira] [Closed] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai closed CALCITE-6164. --- Resolution: Not A Problem > add testPushDownProjectAggregateWithAvg on CsvTest >

[jira] [Commented] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796499#comment-17796499 ] Caican Cai commented on CALCITE-6164: - Thank you for your reply, I will close this jira > add

[jira] [Commented] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796497#comment-17796497 ] Julian Hyde commented on CALCITE-6164: -- Not a goal of this test. In fact we should have pushed

[jira] [Comment Edited] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796496#comment-17796496 ] Caican Cai edited comment on CALCITE-6164 at 12/14/23 12:15 AM: My idea

[jira] [Commented] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796496#comment-17796496 ] Caican Cai commented on CALCITE-6164: - My idea is to tell people how the avg operator is handled in

[jira] [Commented] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796495#comment-17796495 ] Caican Cai commented on CALCITE-6164: - I think this test will not cause errors in the future. This

[jira] [Commented] (CALCITE-6162) Add rule(s) to remove joins with constant single tuple relations

2023-12-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796494#comment-17796494 ] Julian Hyde commented on CALCITE-6162: -- I see you have {{cross join}} and {{{}inner join{}}}. Is

[jira] [Commented] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796416#comment-17796416 ] Julian Hyde commented on CALCITE-6164: -- This does not belong in the {{example}} module. The

[jira] [Resolved] (CALCITE-5868) ServerTest#testCreateSchema is unstable

2023-12-13 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-5868. - Fix Version/s: 1.37.0 Resolution: Fixed Fixed via CALCITE-6048 >

[jira] [Resolved] (CALCITE-4824) ServerUnParserTest#testCreateTableVirtualColumn fails

2023-12-13 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-4824. - Fix Version/s: 1.37.0 Resolution: Fixed Fixed via CALCITE-6048 >

[jira] [Resolved] (CALCITE-6048) 'CIRCULAR REFERENCE' exception is throwed in ServerTest#testTruncateTable method

2023-12-13 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li resolved CALCITE-6048. - Fix Version/s: 1.37.0 Resolution: Fixed Fixed via

[jira] [Assigned] (CALCITE-4824) ServerUnParserTest#testCreateTableVirtualColumn fails

2023-12-13 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li reassigned CALCITE-4824: --- Assignee: Benchao Li > ServerUnParserTest#testCreateTableVirtualColumn fails >

[jira] [Updated] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6164: Description: The avg operator in the agg operator is actually different from the aggregation

[jira] [Updated] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6164: Labels: pull-request-available (was: ) > add testPushDownProjectAggregateWithAvg on

[jira] [Updated] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CsvTest

2023-12-13 Thread Caican Cai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Caican Cai updated CALCITE-6164: Summary: add testPushDownProjectAggregateWithAvg on CsvTest (was: add

[jira] [Created] (CALCITE-6164) add testPushDownProjectAggregateWithAvg on CSVTest

2023-12-13 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6164: --- Summary: add testPushDownProjectAggregateWithAvg on CSVTest Key: CALCITE-6164 URL: https://issues.apache.org/jira/browse/CALCITE-6164 Project: Calcite Issue

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-12-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796272#comment-17796272 ] Ulrich Kramer commented on CALCITE-5832: [This

[jira] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-12-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832 ] Ulrich Kramer deleted comment on CALCITE-5832: was (Author: kramerul): It seems that [this

[jira] [Commented] (CALCITE-5832) CyclicMetadataException thrown in complex JOIN

2023-12-13 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17796263#comment-17796263 ] Ulrich Kramer commented on CALCITE-5832: It seems that [this

[jira] [Updated] (CALCITE-6163) The spark ARRAY function gives exception when elements contain row(struct) type and NULL

2023-12-13 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6163: - Description: when we run {noformat} array(row(1,2), null) {noformat} It will give 'Parameters must be

[jira] [Updated] (CALCITE-6163) The spark ARRAY function gives exception when elements contain row(struct) type and NULL

2023-12-13 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6163: - Description: when we run {noformat} array(row(1,2), null) {noformat} It will give 'Parameters must be

[jira] [Updated] (CALCITE-6163) The spark ARRAY function gives exception when elements contain row(struct) type and NULL

2023-12-13 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6163: - Description: when we run {noformat} array(row(1,2), null) {noformat} It will give 'Parameters must be

[jira] [Updated] (CALCITE-6163) The spark ARRAY function gives exception when elements contain row(struct) type and NULL

2023-12-13 Thread Ran Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ran Tao updated CALCITE-6163: - Description: when we run {noformat} array(row(1,2), null) {noformat} It will give 'Parameters must be

[jira] [Created] (CALCITE-6163) The spark ARRAY function gives exception when elements contain row(struct) type and NULL

2023-12-13 Thread Ran Tao (Jira)
Ran Tao created CALCITE-6163: Summary: The spark ARRAY function gives exception when elements contain row(struct) type and NULL Key: CALCITE-6163 URL: https://issues.apache.org/jira/browse/CALCITE-6163