[jira] [Commented] (CALCITE-6480) OracleDialect does not support CASE WHEN returning boolean

[ https://issues.apache.org/jira/browse/CALCITE-6480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867165#comment-17867165 ] kate commented on CALCITE-6480: --- [~julianhyde] Maybe I can write the code like this? {cod

[jira] [Updated] (CALCITE-6481) Optimize 'VALUES...UNION ALL...VALUES' to a single 'VALUES' the IN-list contains NULL and it is converted to VALUES

[ https://issues.apache.org/jira/browse/CALCITE-6481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6481: Summary: Optimize 'VALUES...UNION ALL...VALUES' to a single 'VALUES' the IN-list contains NULL an

[jira] [Resolved] (CALCITE-6475) RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES

[ https://issues.apache.org/jira/browse/CALCITE-6475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan resolved CALCITE-6475. - Fix Version/s: 1.38.0 Resolution: Fixed > RelToSql converter fails when the IN-list cont

[jira] [Commented] (CALCITE-6475) RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES

[ https://issues.apache.org/jira/browse/CALCITE-6475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867160#comment-17867160 ] xiong duan commented on CALCITE-6475: - Fixed in [2d955bc9f7|https://github.com/apa

[jira] [Updated] (CALCITE-6475) RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES

[ https://issues.apache.org/jira/browse/CALCITE-6475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6475: Labels: pull-request-available (was: ) > RelToSql converter fails when the IN-list conta

[jira] [Comment Edited] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867133#comment-17867133 ] TJ Banghart edited comment on CALCITE-6452 at 7/18/24 11:12 PM: -

[jira] [Commented] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867133#comment-17867133 ] TJ Banghart commented on CALCITE-6452: -- Okay great, so this makes sense and I thin

[jira] [Commented] (CALCITE-6480) OracleDialect does not support CASE WHEN returning boolean

[ https://issues.apache.org/jira/browse/CALCITE-6480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867127#comment-17867127 ] Julian Hyde commented on CALCITE-6480: -- [~suibianwanwan33], Yes, but add parenthes

[jira] [Comment Edited] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867117#comment-17867117 ] Julian Hyde edited comment on CALCITE-6452 at 7/18/24 9:40 PM: --

[jira] [Commented] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867117#comment-17867117 ] Julian Hyde commented on CALCITE-6452: -- You're right. The value should be 1 for Al

[jira] [Comment Edited] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867114#comment-17867114 ] TJ Banghart edited comment on CALCITE-6452 at 7/18/24 9:07 PM: --

[jira] [Comment Edited] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867114#comment-17867114 ] TJ Banghart edited comment on CALCITE-6452 at 7/18/24 9:03 PM: --

[jira] [Comment Edited] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867114#comment-17867114 ] TJ Banghart edited comment on CALCITE-6452 at 7/18/24 9:03 PM: --

[jira] [Commented] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867114#comment-17867114 ] TJ Banghart commented on CALCITE-6452: -- If {{COUNT(\*)}} should consider {{null}}

[jira] [Commented] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867113#comment-17867113 ] TJ Banghart commented on CALCITE-6452: -- I can see why the first case results in {{

[jira] [Comment Edited] (CALCITE-6452) Scalar sub-query that uses IS NOT DISTINCT FROM returns incorrect result

[ https://issues.apache.org/jira/browse/CALCITE-6452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867113#comment-17867113 ] TJ Banghart edited comment on CALCITE-6452 at 7/18/24 8:54 PM: --

[jira] [Commented] (CALCITE-6465) Rework code generator

[ https://issues.apache.org/jira/browse/CALCITE-6465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867112#comment-17867112 ] James Duong commented on CALCITE-6465: -- I'm still looking into the questions above

[jira] [Updated] (CALCITE-6483) Add length to PostgreSQL function library

[ https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6483: Labels: pull-request-available (was: ) > Add length to PostgreSQL function library > ---

[jira] [Commented] (CALCITE-6293) Support OR condition in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867054#comment-17867054 ] Julian Hyde commented on CALCITE-6293: -- We don't require DNF, for the reasons [~mb

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

[ https://issues.apache.org/jira/browse/CALCITE-6300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867053#comment-17867053 ] Caican Cai commented on CALCITE-6300: - [~julianhyde] Thanks mihai for the question,

[jira] [Assigned] (CALCITE-6372) Support ASOF joins

[ https://issues.apache.org/jira/browse/CALCITE-6372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mihai Budiu reassigned CALCITE-6372: Assignee: Mihai Budiu > Support ASOF joins > -- > > Key:

[jira] [Commented] (CALCITE-6293) Support OR condition in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867050#comment-17867050 ] Mihai Budiu commented on CALCITE-6293: -- In the worst case a Boolean formula may re

[jira] [Comment Edited] (CALCITE-6293) Support OR condition in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867043#comment-17867043 ] Tim Grein edited comment on CALCITE-6293 at 7/18/24 4:08 PM:

[jira] [Commented] (CALCITE-6293) Support OR condition in Arrow adapter

[ https://issues.apache.org/jira/browse/CALCITE-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17867043#comment-17867043 ] Tim Grein commented on CALCITE-6293: Hi, I've started to look into supporting OR a

[jira] [Updated] (CALCITE-6484) Sonar analysis fails intermittently due to OOM

[ https://issues.apache.org/jira/browse/CALCITE-6484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-6484: Labels: pull-request-available (was: ) > Sonar analysis fails intermittently due to OOM

[jira] [Created] (CALCITE-6484) Sonar analysis fails intermittently due to OOM

Alessandro Solimando created CALCITE-6484: - Summary: Sonar analysis fails intermittently due to OOM Key: CALCITE-6484 URL: https://issues.apache.org/jira/browse/CALCITE-6484 Project: Calcite

[jira] [Commented] (CALCITE-6475) RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES

[ https://issues.apache.org/jira/browse/CALCITE-6475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866987#comment-17866987 ] xiong duan commented on CALCITE-6475: - +1 [~asolimando]. > RelToSql converter fail

[jira] [Updated] (CALCITE-6475) RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES

[ https://issues.apache.org/jira/browse/CALCITE-6475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xiong duan updated CALCITE-6475: Summary: RelToSql converter fails when the IN-list contains NULL and it is converted to VALUES (

[jira] [Commented] (CALCITE-6475) RelToSql converter fails when IN-list that the values include NULL is converted to Values

[ https://issues.apache.org/jira/browse/CALCITE-6475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866956#comment-17866956 ] Alessandro Solimando commented on CALCITE-6475: --- Thanks [~nobigo] for the