[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532594#comment-17532594 ] itxiangkui commented on CALCITE-5133: - [~nobigo]  Hi Sorry to bother you again. I want to set

[jira] [Commented] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532587#comment-17532587 ] itxiangkui commented on CALCITE-5132: - Sorry for misunderstanding.. > When the IN-list including a

[jira] [Commented] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-05 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532583#comment-17532583 ] xiong duan commented on CALCITE-5132: - [~itxiangkui] Hi, I want to know why need to link this? It's

[jira] [Commented] (CALCITE-5130) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when union VARCHAR literal and CAST(null AS INTEGER)

2022-05-05 Thread Yingyu Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532380#comment-17532380 ] Yingyu Wang commented on CALCITE-5130: -- [~jiajunbernoulli] I just tried 

[jira] [Commented] (CALCITE-5134) Queries with subquery inside select list does not work if subquery uses table from left join

2022-05-05 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532268#comment-17532268 ] Benchao Li commented on CALCITE-5134: - the pr is ready for review:

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532204#comment-17532204 ] xiong duan commented on CALCITE-5133: - The title "The IN-list values converted to SQL will fail

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532163#comment-17532163 ] itxiangkui commented on CALCITE-5133: - [~nobigo] Hi I earnestly hope that a new issue can be

[jira] [Commented] (CALCITE-5130) AssertionError: "Conversion to relational algebra failed to preserve datatypes" when union VARCHAR literal and CAST(null AS INTEGER)

2022-05-05 Thread Jiajun Xie (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532159#comment-17532159 ] Jiajun Xie commented on CALCITE-5130: - [~yingyu] The problem looks the same as

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532156#comment-17532156 ] xiong duan commented on CALCITE-5133: - I have reproduced the ISSUE and prepare to redescription it.

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Affects Version/s: 1.30.0 > JdbcValues lost some values when the value of in was more than 20 >

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Fix Version/s: (was: 1.30.0) > JdbcValues lost some values when the value of in was more

[jira] [Comment Edited] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532149#comment-17532149 ] itxiangkui edited comment on CALCITE-5133 at 5/5/22 8:54 AM: -   [~nobigo] 

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532150#comment-17532150 ] itxiangkui commented on CALCITE-5133: - calcite :  1.30.0 > JdbcValues lost some values when the

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532149#comment-17532149 ] itxiangkui commented on CALCITE-5133: - {code:java} 0: jdbc:avatica:remote:url=http://localhost:6>

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Fix Version/s: 1.30.0 > JdbcValues lost some values when the value of in was more than 20 >

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532145#comment-17532145 ] xiong duan commented on CALCITE-5133: - [~itxiangkui] Hi, Sorry to bother you again, I want to know

[jira] [Resolved] (CALCITE-5003) MergeUnion on types with different collators produces wrong result

2022-05-05 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-5003. Resolution: Fixed Fixed via

[jira] [Assigned] (CALCITE-5134) Queries with subquery inside select list does not work if subquery uses table from left join

2022-05-05 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Benchao Li reassigned CALCITE-5134: --- Assignee: Benchao Li > Queries with subquery inside select list does not work if subquery

[jira] [Commented] (CALCITE-5127) Error when executing query with subquery in select list that uses outer column of array type

2022-05-05 Thread Dmitry Sysolyatin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532114#comment-17532114 ] Dmitry Sysolyatin commented on CALCITE-5127: [~libenchao] It would be very nice if you can

[jira] [Created] (CALCITE-5134) Queries with subquery inside select list does not work if subquery uses table from left join

2022-05-05 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5134: -- Summary: Queries with subquery inside select list does not work if subquery uses table from left join Key: CALCITE-5134 URL:

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532108#comment-17532108 ] xiong duan commented on CALCITE-5133: - [~itxiangkui] The description is enough to reproduce the

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532098#comment-17532098 ] itxiangkui commented on CALCITE-5133: - [~nobigo]   Sorry, just added some info... > JdbcValues

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Component/s: core > JdbcValues lost some values when the value of in was more than 20 >

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:   I have a piece of data, the example is as follows: ||channel||gettime||

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:   I have a piece of data, the example is as follows: ||channel||gettime||

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:   I have a piece of data, the example is as follows: ||channel||gettime||

[jira] [Updated] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] itxiangkui updated CALCITE-5133: Description:     ||channel||gettime|| |c1|2022-04-27 00:00:00| |c2|2022-04-27 00:00:00|

[jira] [Commented] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread xiong duan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17532087#comment-17532087 ] xiong duan commented on CALCITE-5133: - [~itxiangkui] Hi. If the description has SQL to reproduce

[jira] [Created] (CALCITE-5133) JdbcValues lost some values when the value of in was more than 20

2022-05-05 Thread itxiangkui (Jira)
itxiangkui created CALCITE-5133: --- Summary: JdbcValues lost some values when the value of in was more than 20 Key: CALCITE-5133 URL: https://issues.apache.org/jira/browse/CALCITE-5133 Project: Calcite

[jira] [Updated] (CALCITE-5132) When the IN-list including a NULL value is converted to Values as a SCALAR subquery will return wrong result

2022-05-05 Thread Alessandro Solimando (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alessandro Solimando updated CALCITE-5132: -- Summary: When the IN-list including a NULL value is converted to Values as a