[jira] [Commented] (CALCITE-6399) The predicate IN is transformed by the sqltorelConverter into join

2024-05-07 Thread kate (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844558#comment-17844558 ] kate commented on CALCITE-6399: --- Sry,I found the problem, this optimisation depends on th

[jira] [Created] (CALCITE-6402) Aggregates implied in grouping sets have a wrong nullability at validation stage

2024-05-07 Thread Claude Brisson (Jira)
Claude Brisson created CALCITE-6402: --- Summary: Aggregates implied in grouping sets have a wrong nullability at validation stage Key: CALCITE-6402 URL: https://issues.apache.org/jira/browse/CALCITE-6402

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

2024-05-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844481#comment-17844481 ] Julian Hyde commented on CALCITE-6396: -- The first argument, and the return, should

[jira] [Updated] (CALCITE-6389) RexBuilder.removeCastFromLiteral does not preserve semantics for some types of literals

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6389: - Labels: pull-request-available (was: ) > RexBuilder.removeCastFromLiteral does not preserve se

[jira] [Updated] (CALCITE-6382) Type inference for SqlLeadLagAggFunction is incorrect

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6382: - Description: Currently the LeadLag operator does not use the default value when inferring the

[jira] [Resolved] (CALCITE-6361) Uncollect.deriveUncollectRowType throws AssertionFailure if the input data is not a collection

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6361. -- Fix Version/s: 1.38.0 Assignee: Mihai Budiu Resolution: Fixed Fixed in https

[jira] [Updated] (CALCITE-6361) Uncollect.deriveUncollectRowType throws AssertionFailure if the input data is not a collection

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu updated CALCITE-6361: - Summary: Uncollect.deriveUncollectRowType throws AssertionFailure if the input data is not a co

[jira] [Resolved] (CALCITE-6383) The class SameOperandTypeChecker is incorrectly documented

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6383. -- Fix Version/s: 1.38.0 Resolution: Fixed Resolved in https://github.com/apache/calcite

[jira] [Commented] (CALCITE-6207) Improve connection resource in JDBCUtils

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844363#comment-17844363 ] Mihai Budiu commented on CALCITE-6207: -- The version change just mean that we haven

[jira] [Resolved] (CALCITE-6376) Selecting 6 columns with QUALIFY operation results in exception

2024-05-07 Thread Mihai Budiu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu resolved CALCITE-6376. -- Fix Version/s: 1.38.0 Assignee: Mihai Budiu (was: ShenDa) Resolution: Fixed

[jira] [Updated] (CALCITE-6401) JDBC adapter cannot push down joins with complex JOIN condition

2024-05-07 Thread Ulrich Kramer (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ulrich Kramer updated CALCITE-6401: --- Description: JDBC adapter (in JdbcJoinRule) cannot push down joins with conditions which i

[jira] [Created] (CALCITE-6401) JDBC adapter cannot push down joins with complex JOIN condition

2024-05-07 Thread Ulrich Kramer (Jira)
Ulrich Kramer created CALCITE-6401: -- Summary: JDBC adapter cannot push down joins with complex JOIN condition Key: CALCITE-6401 URL: https://issues.apache.org/jira/browse/CALCITE-6401 Project: Calcit

[jira] [Commented] (CALCITE-2040) Create adapter for Apache Arrow

2024-05-07 Thread Michael Mior (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844246#comment-17844246 ] Michael Mior commented on CALCITE-2040: --- Thanks to all who managed to push this o

[jira] [Commented] (CALCITE-6207) Improve connection resource in JDBCUtils

2024-05-07 Thread xy (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844177#comment-17844177 ] xy commented on CALCITE-6207: - Need [~mbudiu] [~julianhyde] decide for it cc [~Sergey Nuyan

[jira] [Comment Edited] (CALCITE-6207) Improve connection resource in JDBCUtils

2024-05-07 Thread xy (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844174#comment-17844174 ] xy edited comment on CALCITE-6207 at 5/7/24 7:22 AM: - [~mbudiu] [~j

[jira] [Commented] (CALCITE-6207) Improve connection resource in JDBCUtils

2024-05-07 Thread xy (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17844174#comment-17844174 ] xy commented on CALCITE-6207: - [~mbudiu] [~julianhyde] I saw someone had change the version

[jira] [Updated] (CALCITE-2067) RexLiteral cannot represent accurately floating point values, including NaN, Infinity

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-2067: - Fix Version/s: 1.38.0 (was: 1.37.0) > RexLiteral cannot represen

[jira] [Updated] (CALCITE-3522) Sql validator limits decimal literals to 64 bits

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-3522: - Fix Version/s: 1.38.0 (was: 1.37.0) > Sql validator limits decim

[jira] [Updated] (CALCITE-6340) RelBuilder drops set conventions when aggregating over duplicate projected fields

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6340: - Fix Version/s: 1.38.0 (was: 1.37.0) > RelBuilder drops set conve

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

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6325: - Fix Version/s: 1.38.0 (was: 1.37.0) > Add LOG function (enabled

[jira] [Updated] (CALCITE-6388) PsTableFunction throws NumberFormatException when the 'user' column has spaces

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6388: - Fix Version/s: 1.38.0 (was: 1.37.0) > PsTableFunction throws Num

[jira] [Updated] (CALCITE-6071) RexCall should carry source position information for runtime error reporting

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6071?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6071: - Fix Version/s: 1.38.0 (was: 1.37.0) > RexCall should carry sourc

[jira] [Updated] (CALCITE-6207) Improve connection resource in JDBCUtils

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6207: - Fix Version/s: 1.38.0 (was: 1.37.0) > Improve connection resourc

[jira] [Updated] (CALCITE-6169) EnumUtils.convert does not implement the correct SQL cast semantics

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6169: - Fix Version/s: 1.38.0 (was: 1.37.0) > EnumUtils.convert does not

[jira] [Updated] (CALCITE-6161) The equalsDeep of sqlCall should compare sqlOperator's sqlKind

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6161: - Fix Version/s: 1.38.0 (was: 1.37.0) > The equalsDeep of sqlCall

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

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6352: - Fix Version/s: 1.38.0 (was: 1.37.0) > The map_contains_key funct

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

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6203: - Fix Version/s: 1.38.0 (was: 1.37.0) > Avg operator test in Spark

[jira] [Updated] (CALCITE-6226) Wrong ISOWEEK and no ISOYEAR on BigQuery FORMAT_DATE

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6226: - Fix Version/s: 1.38.0 (was: 1.37.0) > Wrong ISOWEEK and no ISOYE

[jira] [Updated] (CALCITE-6259) The implementation of the Log library operator does not match the actual dialect behavior.

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6259: - Fix Version/s: 1.38.0 (was: 1.37.0) > The implementation of the

[jira] [Updated] (CALCITE-6244) Improve `Expressions#constant` to allow passing models with non-public fields

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6244: - Fix Version/s: 1.38.0 (was: 1.37.0) > Improve `Expressions#const

[jira] [Updated] (CALCITE-6300) Function MAP_VALUES/MAP_KEYS gives exception when mapVauleType and mapKeyType not equals map Biggest mapKeytype or mapValueType

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6300: - Fix Version/s: 1.38.0 (was: 1.37.0) > Function MAP_VALUES/MAP_KE

[jira] [Updated] (CALCITE-6302) Release Calcite 1.37.0

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6302: - Fix Version/s: 1.38.0 (was: 1.37.0) > Release Calcite 1.37.0 > -

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

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6277: - Fix Version/s: 1.38.0 (was: 1.37.0) > About the processing of +i

[jira] [Updated] (CALCITE-6322) Casts to DECIMAL types are ignored

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6322: - Fix Version/s: 1.38.0 (was: 1.37.0) > Casts to DECIMAL types are

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

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6326: - Fix Version/s: 1.38.0 (was: 1.37.0) > Add LOG10 and LN function

[jira] [Updated] (CALCITE-6343) AS alias operator strips MEASUREness from measures

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6343: - Fix Version/s: 1.38.0 (was: 1.37.0) > AS alias operator strips M

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

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6396: - Fix Version/s: 1.38.0 (was: 1.37.0) > Add ADD_MONTHS function (e

[jira] [Updated] (CALCITE-6400) MAP_ENTRIES does not allow null as a map key value #3787

2024-05-07 Thread Sergey Nuyanzin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Nuyanzin updated CALCITE-6400: - Fix Version/s: 1.38.0 (was: 1.37.0) > MAP_ENTRIES does not allow