[jira] [Created] (CALCITE-6493) Improve Calcite development documentation

2024-07-22 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6493: --- Summary: Improve Calcite development documentation Key: CALCITE-6493 URL: https://issues.apache.org/jira/browse/CALCITE-6493 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6489) Add more data types to the Arrow test set

2024-07-20 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6489: --- Summary: Add more data types to the Arrow test set Key: CALCITE-6489 URL: https://issues.apache.org/jira/browse/CALCITE-6489 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6457) The array_contains function return false when arrayComponentType and op1 type are differen

2024-07-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6457: --- Summary: The array_contains function return false when arrayComponentType and op1 type are differen Key: CALCITE-6457 URL: https://issues.apache.org/jira/browse/CALCITE-6457

[jira] [Created] (CALCITE-6456) The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x)

2024-07-02 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6456: --- Summary: The Mysql log function rule LOG(x, base) is equivalent to LOG(base)/LOG(x) Key: CALCITE-6456 URL: https://issues.apache.org/jira/browse/CALCITE-6456 Project:

[jira] [Created] (CALCITE-6440) Add optimization to returns empty when The Order By parameter in the Sort operator is empty

2024-06-16 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6440: --- Summary: Add optimization to returns empty when The Order By parameter in the Sort operator is empty Key: CALCITE-6440 URL: https://issues.apache.org/jira/browse/CALCITE-6440

[jira] [Created] (CALCITE-6439) FILTER_INSTANCE in RelOptRule does not take effect

2024-06-15 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6439: --- Summary: FILTER_INSTANCE in RelOptRule does not take effect Key: CALCITE-6439 URL: https://issues.apache.org/jira/browse/CALCITE-6439 Project: Calcite Issue

[jira] [Created] (CALCITE-6438) Add optimization to returns empty when the filter operator is a false instance

2024-06-15 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6438: --- Summary: Add optimization to returns empty when the filter operator is a false instance Key: CALCITE-6438 URL: https://issues.apache.org/jira/browse/CALCITE-6438

[jira] [Created] (CALCITE-6411) Support Collect in ToLogicalConverter

2024-05-19 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6411: --- Summary: Support Collect in ToLogicalConverter Key: CALCITE-6411 URL: https://issues.apache.org/jira/browse/CALCITE-6411 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6410) dateadd(MONTH, 3, date '2016-02-24') parsing failed

2024-05-12 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6410: --- Summary: dateadd(MONTH, 3, date '2016-02-24') parsing failed Key: CALCITE-6410 URL: https://issues.apache.org/jira/browse/CALCITE-6410 Project: Calcite Issue

[jira] [Created] (CALCITE-6409) Character types and Boolean types are comparable

2024-05-12 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6409: --- Summary: Character types and Boolean types are comparable Key: CALCITE-6409 URL: https://issues.apache.org/jira/browse/CALCITE-6409 Project: Calcite Issue

[jira] [Created] (CALCITE-6400) MAP_ENTRIES is not allowed to be empty

2024-05-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6400: --- Summary: MAP_ENTRIES is not allowed to be empty Key: CALCITE-6400 URL: https://issues.apache.org/jira/browse/CALCITE-6400 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-6398) Spark's ifnull function has only one parameter and the return value is Boolean

2024-05-03 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6398: --- Summary: Spark's ifnull function has only one parameter and the return value is Boolean Key: CALCITE-6398 URL: https://issues.apache.org/jira/browse/CALCITE-6398

[jira] [Created] (CALCITE-6397) Add NVL2 function (enabled in Spark library)

2024-05-03 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6397: --- Summary: Add NVL2 function (enabled in Spark library) Key: CALCITE-6397 URL: https://issues.apache.org/jira/browse/CALCITE-6397 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6396) Add ADD_MONTHS function (enabled in Spark library)

2024-05-03 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6396: --- Summary: Add ADD_MONTHS function (enabled in Spark library) Key: CALCITE-6396 URL: https://issues.apache.org/jira/browse/CALCITE-6396 Project: Calcite Issue

[jira] [Created] (CALCITE-6352) The map_contains_key function may return true when the key and mapkeytype types are different.

2024-04-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6352: --- Summary: The map_contains_key function may return true when the key and mapkeytype types are different. Key: CALCITE-6352 URL: https://issues.apache.org/jira/browse/CALCITE-6352

[jira] [Created] (CALCITE-6326) Add LOG10 and LN function (enabled in Mysql, Spark library)

2024-03-12 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6326: --- Summary: Add LOG10 and LN function (enabled in Mysql, Spark library) Key: CALCITE-6326 URL: https://issues.apache.org/jira/browse/CALCITE-6326 Project: Calcite

[jira] [Created] (CALCITE-6325) Add LOG function (enabled in Mysql, Spark library)

2024-03-12 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6325: --- Summary: Add LOG function (enabled in Mysql, Spark library) Key: CALCITE-6325 URL: https://issues.apache.org/jira/browse/CALCITE-6325 Project: Calcite Issue

[jira] [Created] (CALCITE-6319) Add negative test to pow and power functions

2024-03-10 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6319: --- Summary: Add negative test to pow and power functions Key: CALCITE-6319 URL: https://issues.apache.org/jira/browse/CALCITE-6319 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6300) Function map_values gives exception when inserted element type not equals array component type

2024-03-05 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6300: --- Summary: Function map_values gives exception when inserted element type not equals array component type Key: CALCITE-6300 URL: https://issues.apache.org/jira/browse/CALCITE-6300

[jira] [Created] (CALCITE-6279) Use Null to replace the results of some Math functions that return NaN.

2024-02-23 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6279: --- Summary: Use Null to replace the results of some Math functions that return NaN. Key: CALCITE-6279 URL: https://issues.apache.org/jira/browse/CALCITE-6279 Project:

[jira] [Created] (CALCITE-6277) About the processing of +infinity parameters and -infinity parameters in math function

2024-02-20 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6277: --- Summary: About the processing of +infinity parameters and -infinity parameters in math function Key: CALCITE-6277 URL: https://issues.apache.org/jira/browse/CALCITE-6277

[jira] [Created] (CALCITE-6273) Add sqrt negative test in SqlOperatorTest

2024-02-18 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6273: --- Summary: Add sqrt negative test in SqlOperatorTest Key: CALCITE-6273 URL: https://issues.apache.org/jira/browse/CALCITE-6273 Project: Calcite Issue Type: Test

[jira] [Created] (CALCITE-6272) Improved LogicalPlan representation of distinct keyword

2024-02-17 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6272: --- Summary: Improved LogicalPlan representation of distinct keyword Key: CALCITE-6272 URL: https://issues.apache.org/jira/browse/CALCITE-6272 Project: Calcite

[jira] [Created] (CALCITE-6267) Add subquery test and cte test in ToLogicalConverterTest

2024-02-15 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6267: --- Summary: Add subquery test and cte test in ToLogicalConverterTest Key: CALCITE-6267 URL: https://issues.apache.org/jira/browse/CALCITE-6267 Project: Calcite

[jira] [Created] (CALCITE-6259) Using log10 and log functions with arguments 0

2024-02-11 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6259: --- Summary: Using log10 and log functions with arguments 0 Key: CALCITE-6259 URL: https://issues.apache.org/jira/browse/CALCITE-6259 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6237) Using fractions in LOG function does not return correct results

2024-02-01 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6237: --- Summary: Using fractions in LOG function does not return correct results Key: CALCITE-6237 URL: https://issues.apache.org/jira/browse/CALCITE-6237 Project: Calcite

[jira] [Created] (CALCITE-6235) MAP_CONTAINS_KEY function results correspond to Spark results

2024-01-30 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6235: --- Summary: MAP_CONTAINS_KEY function results correspond to Spark results Key: CALCITE-6235 URL: https://issues.apache.org/jira/browse/CALCITE-6235 Project: Calcite

[jira] [Created] (CALCITE-6234) Add Test on SqlOperatorTest for format_date function(enable Bigquery and pg)

2024-01-30 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6234: --- Summary: Add Test on SqlOperatorTest for format_date function(enable Bigquery and pg) Key: CALCITE-6234 URL: https://issues.apache.org/jira/browse/CALCITE-6234

[jira] [Created] (CALCITE-6232) Using fractions and 0 in LOG function does not return correct results

2024-01-27 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6232: --- Summary: Using fractions and 0 in LOG function does not return correct results Key: CALCITE-6232 URL: https://issues.apache.org/jira/browse/CALCITE-6232 Project:

[jira] [Created] (CALCITE-6224) Add LOG2 function on SqlStdOperatorTable

2024-01-25 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6224: --- Summary: Add LOG2 function on SqlStdOperatorTable Key: CALCITE-6224 URL: https://issues.apache.org/jira/browse/CALCITE-6224 Project: Calcite Issue Type: New

[jira] [Created] (CALCITE-6223) Add MAP_CONTAINS_KEY function (enabled in Spark library)

2024-01-25 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6223: --- Summary: Add MAP_CONTAINS_KEY function (enabled in Spark library) Key: CALCITE-6223 URL: https://issues.apache.org/jira/browse/CALCITE-6223 Project: Calcite

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

2024-01-24 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6222: --- Summary: Mysql does not have to_char function Key: CALCITE-6222 URL: https://issues.apache.org/jira/browse/CALCITE-6222 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-6215) Support century format datetime/timestamp in pg

2024-01-21 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6215: --- Summary: Support century format datetime/timestamp in pg Key: CALCITE-6215 URL: https://issues.apache.org/jira/browse/CALCITE-6215 Project: Calcite Issue

[jira] [Created] (CALCITE-6203) Avg operator test in SparkAdapterTest

2024-01-15 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6203: --- Summary: Avg operator test in SparkAdapterTest Key: CALCITE-6203 URL: https://issues.apache.org/jira/browse/CALCITE-6203 Project: Calcite Issue Type: Test

[jira] [Created] (CALCITE-6185) Support more date format

2024-01-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6185: --- Summary: Support more date format Key: CALCITE-6185 URL: https://issues.apache.org/jira/browse/CALCITE-6185 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-6184) Add checkNullTest on SqlOperatorTest

2024-01-04 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6184: --- Summary: Add checkNullTest on SqlOperatorTest Key: CALCITE-6184 URL: https://issues.apache.org/jira/browse/CALCITE-6184 Project: Calcite Issue Type: Test

[jira] [Created] (CALCITE-6179) Support weekofmonth function format

2023-12-26 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6179: --- Summary: Support weekofmonth function format Key: CALCITE-6179 URL: https://issues.apache.org/jira/browse/CALCITE-6179 Project: Calcite Issue Type:

[jira] [Created] (CALCITE-6177) Support datetime type

2023-12-25 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6177: --- Summary: Support datetime type Key: CALCITE-6177 URL: https://issues.apache.org/jira/browse/CALCITE-6177 Project: Calcite Issue Type: Improvement

[jira] [Created] (CALCITE-6165) Add

2023-12-14 Thread Caican Cai (Jira)
Caican Cai created CALCITE-6165: --- Summary: Add Key: CALCITE-6165 URL: https://issues.apache.org/jira/browse/CALCITE-6165 Project: Calcite Issue Type: Improvement Reporter: Caican

[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