[
https://issues.apache.org/jira/browse/CALCITE-6582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881875#comment-17881875
]
Julian Hyde edited comment on CALCITE-6582 at 9/17/24 6:42 PM:
---------------------------------------------------------------
There are 26 [open bugs marked to fix for
1.38|https://issues.apache.org/jira/issues/?jql=project%20%3D%20CALCITE%20AND%20fixVersion%20%3D%201.38.0%20and%20resolution%20%3D%20Unresolved%20].
The following have a PR available that seems close to ready. If these are good,
let's get these merged!
* CALCITE-6572 Add more tests for NULL arguments to TO_CHAR functions
* CALCITE-6554 nested correlated sub-query in aggregation does not have inner
correlation variable bound to inner projection
* CALCITE-6550 Improve SQL function overloading
* CALCITE-6343 AS alias operator strips MEASUREness from measures
* CALCITE-6161 The equalsDeep of sqlCall should compare sqlOperator's sqlKind
* CALCITE-6226 Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE
* CALCITE-2067 RexLiteral cannot represent accurately floating point values,
including NaN, Infinity
* CALCITE-5156 Support implicit number type cast for IN Sub-query
* CALCITE-6071 RexCall should carry source position information for runtime
error reporting
* CALCITE-6498 Elasticsearch multi-field mappings do not work
* CALCITE-6522 MAP_KEYS and MAP_VALUES function should throw if a key value is
null
* CALCITE-6020 SqlToRelConverter should not replace windowed SUM with
equivalent expression using SUM0
* CALCITE-4512 GROUP BY expression with argument name same with SELECT field
and alias causes validation error
The following cases have a draft PR. Is it ready for 1.38?
* CALCITE-6431 Implement the SINGLE_VALUE aggregation in HiveSqlDialect And
SparkSQLDialect
* CALCITE-6300 Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType
and mapKeyType not equals map Biggest mapKeytype or mapValueType
* CALCITE-6584 Validate prefixed column identifiers in SET clause of UPDATE
statement
* CALCITE-6570 UPDATE with sub-query that requires type cast gives
AssertionError
* CALCITE-6566 JDBC adapter should generate PI function with parentheses in
most dialects
* CALCITE-6560 Add supportsNegativeScale in RelDataTypeSystem
* CALCITE-6527 Add DATE_ADD function (enabled in Spark library)
Need to decide whether to accept or close:
* CALCITE-6207 Improve connection resource in JDBCUtils
* CALCITE-6411 Support Collect in ToLogicalConverter
* CALCITE-6352 The map_contains_key function may return true when the key and
mapkeytype types are different.
The following seem to have no PR. Are there any worth holding the train for?
* CALCITE-6277 About the processing of +infinity parameters and -infinity
parameters in math function
* CALCITE-6203 Avg operator test in SparkAdapterTest
* CALCITE-6326 Add LOG10 and LN function (enabled in Mysql, Spark library)
* CALCITE-6259 The implementation of the Log library operator does not match
the actual dialect behavior.
* CALCITE-5541 Upgrade JavaCC
* CALCITE-6469 Join on condition generates wrong plan when the condition is IN
sub-query
* CALCITE-6463 alias generation issue about correlated subquery handling
Are there any more cases with PR ready?
was (Author: julianhyde):
There are 26 [open bugs marked to fix for
1.38|https://issues.apache.org/jira/issues/?jql=project%20%3D%20CALCITE%20AND%20fixVersion%20%3D%201.38.0%20and%20resolution%20%3D%20Unresolved%20].
The following have a PR available that seems close to ready. If these are good,
let's get these merged!
* CALCITE-6572 Add more tests for NULL arguments to TO_CHAR functions
* CALCITE-6554 nested correlated sub-query in aggregation does not have inner
correlation variable bound to inner projection
* CALCITE-6550 Improve SQL function overloading
* CALCITE-6343 AS alias operator strips MEASUREness from measures
* CALCITE-6161 The equalsDeep of sqlCall should compare sqlOperator's sqlKind
* CALCITE-6226 Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE
* CALCITE-2067 RexLiteral cannot represent accurately floating point values,
including NaN, Infinity
* CALCITE-5156 Support implicit number type cast for IN Sub-query
* CALCITE-6071 RexCall should carry source position information for runtime
error reporting
* CALCITE-6498 Elasticsearch multi-field mappings do not work
* CALCITE-6522 MAP_KEYS and MAP_VALUES function should throw if a key value is
null
* CALCITE-6020 SqlToRelConverter should not replace windowed SUM with
equivalent expression using SUM0
* CALCITE-4512 GROUP BY expression with argument name same with SELECT field
and alias causes validation error
The following cases have a draft PR. Is it ready for 1.38?
* CALCITE-6431 Implement the SINGLE_VALUE aggregation in HiveSqlDialect And
SparkSQLDialect
* CALCITE-6300 Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType
and mapKeyType not equals map Biggest mapKeytype or mapValueType
Need to decide whether to accept or close:
* CALCITE-6207 Improve connection resource in JDBCUtils
* CALCITE-6411 Support Collect in ToLogicalConverter
* CALCITE-6352 The map_contains_key function may return true when the key and
mapkeytype types are different.
The following seem to have no PR. Are there any worth holding the train for?
* CALCITE-6277 About the processing of +infinity parameters and -infinity
parameters in math function
* CALCITE-6203 Avg operator test in SparkAdapterTest
* CALCITE-6326 Add LOG10 and LN function (enabled in Mysql, Spark library)
* CALCITE-6259 The implementation of the Log library operator does not match
the actual dialect behavior.
* CALCITE-5541 Upgrade JavaCC
* CALCITE-6469 Join on condition generates wrong plan when the condition is IN
sub-query
* CALCITE-6463 alias generation issue about correlated subquery handling
Are there any more cases with PR ready?
> Release Calcite 1.38.0
> ----------------------
>
> Key: CALCITE-6582
> URL: https://issues.apache.org/jira/browse/CALCITE-6582
> Project: Calcite
> Issue Type: Improvement
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Priority: Major
> Fix For: 1.38.0
>
>
> Release Calcite 1.38.0.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
