[jira] [Commented] (CALCITE-4338) Support MERGE INTO Clause

[ https://issues.apache.org/jira/browse/CALCITE-4338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17476513#comment-17476513 ] duan xiong commented on CALCITE-4338: - According to ISO 2003:SQL: *14.9 .* It is a standard syntax.

[jira] [Commented] (CALCITE-4980) Babel parser support MySQL NULL-safe equal operator '<=>'

[ https://issues.apache.org/jira/browse/CALCITE-4980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17476504#comment-17476504 ] duan xiong commented on CALCITE-4980: - Hi [~wojustme] , I noticed the Calcite has [IS NOT DISTINCT

[jira] [Commented] (CALCITE-4987) JDBC adapter generates incorrect query when order by alias collides with field in select item

[ https://issues.apache.org/jira/browse/CALCITE-4987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17476078#comment-17476078 ] duan xiong commented on CALCITE-4987: - I think CALCITE-2552 is a related issue. And Please

[jira] [Commented] (CALCITE-4985) Elasticsearch Adapter fails to execute a prepared statement

[ https://issues.apache.org/jira/browse/CALCITE-4985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17475015#comment-17475015 ] duan xiong commented on CALCITE-4985: - Hi, This summary is not very clear, According to the

[jira] [Commented] (CALCITE-4910) Enhance simplify to reduce ((A OR D) AND (A OR C) AND A AND B) to (A AND B)

[ https://issues.apache.org/jira/browse/CALCITE-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17475014#comment-17475014 ] duan xiong commented on CALCITE-4910: - I spent some time on this issue. So please let me confirm

[jira] [Commented] (CALCITE-4982) NonNull field is pushed down into leaf of outer-join in 'ProjectJoinTransposeRule'

[ https://issues.apache.org/jira/browse/CALCITE-4982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17472672#comment-17472672 ] duan xiong commented on CALCITE-4982: - [~wojustme] Hi, I review the code, Maybe we should change

[jira] [Commented] (CALCITE-4977) Support Snapshot in RelMdColumnOrigins

[ https://issues.apache.org/jira/browse/CALCITE-4977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17472491#comment-17472491 ] duan xiong commented on CALCITE-4977: - Fixed in

[jira] [Resolved] (CALCITE-4977) Support Snapshot in RelMdColumnOrigins

[ https://issues.apache.org/jira/browse/CALCITE-4977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4977. - Fix Version/s: 1.30.0 Resolution: Fixed > Support Snapshot in RelMdColumnOrigins >

[jira] [Commented] (CALCITE-4980) Babel parser support MySQL equal operator '<=>'

[ https://issues.apache.org/jira/browse/CALCITE-4980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17471951#comment-17471951 ] duan xiong commented on CALCITE-4980: - Hi [~wojustme] , I read MySQL's illustration, The different

[jira] [Resolved] (CALCITE-4962) Protobuf debug does not show request/response type

[ https://issues.apache.org/jira/browse/CALCITE-4962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4962. - Fix Version/s: avatica-1.21.0 Resolution: Fixed > Protobuf debug does not show

[jira] [Commented] (CALCITE-4962) Protobuf debug does not show request/response type

[ https://issues.apache.org/jira/browse/CALCITE-4962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17468310#comment-17468310 ] duan xiong commented on CALCITE-4962: - Fixed in

[jira] [Updated] (CALCITE-4924) REGR_SXX and similar aggregate functions return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Description: The SQL: {code:java} SELECT regr_sxx(SAL, COMM) as "REGR_SXX(SAL, COMM)" from

[jira] [Updated] (CALCITE-4924) REGR_SXX and similar aggregate functions return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Summary: REGR_SXX and similar aggregate functions return the wrong data type (was: The

[jira] [Commented] (CALCITE-4889) Double join is created for NOT IN when IN-list is converted to Values

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17466913#comment-17466913 ] duan xiong commented on CALCITE-4889: - After reading the code, I find this generates the Double

[jira] [Commented] (CALCITE-4966) org.apache.calcite.adapter.file.CsvEnumerator.RowConverter should be public

[ https://issues.apache.org/jira/browse/CALCITE-4966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17465286#comment-17465286 ] duan xiong commented on CALCITE-4966: - I suggest using "In class CsvEnumerator, the inner class

[jira] [Commented] (CALCITE-4924) The aggregate functions about Covariance return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17465117#comment-17465117 ] duan xiong commented on CALCITE-4924: - Any feedback from you will be highly appreciated.:D  this

[jira] [Commented] (CALCITE-4959) Throw a error when precision is greater than maxPrecision

[ https://issues.apache.org/jira/browse/CALCITE-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17464528#comment-17464528 ] duan xiong commented on CALCITE-4959: - [~ana4]  Looks like the force override is intentional

[jira] [Commented] (CALCITE-4958) bad performance execute plan when use dynamic parameters in query

[ https://issues.apache.org/jira/browse/CALCITE-4958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17463752#comment-17463752 ] duan xiong commented on CALCITE-4958: - As far as I know, The IN_SUB_QUERY_THRESHOLD decided the

[jira] [Assigned] (CALCITE-4924) The aggregate functions about Covariance return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong reassigned CALCITE-4924: --- Assignee: duan xiong > The aggregate functions about Covariance return the wrong data

[jira] [Resolved] (CALCITE-4700) AggregateUnionTransposeRule produces wrong group sets for the top Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4700. - Fix Version/s: 1.29.0 Resolution: Fixed > AggregateUnionTransposeRule produces wrong

[jira] [Commented] (CALCITE-4700) AggregateUnionTransposeRule produces wrong group sets for the top Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17461868#comment-17461868 ] duan xiong commented on CALCITE-4700: - Fixed in

[jira] [Commented] (CALCITE-4860) In Elasticsearch adapter, support NULLS FIRST and NULLS LAST query

[ https://issues.apache.org/jira/browse/CALCITE-4860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17461745#comment-17461745 ] duan xiong commented on CALCITE-4860: - Removing fixVersion=1.29.0. The PR is not ready. > In

[jira] [Updated] (CALCITE-4860) In Elasticsearch adapter, support NULLS FIRST and NULLS LAST query

[ https://issues.apache.org/jira/browse/CALCITE-4860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4860: Fix Version/s: (was: 1.29.0) > In Elasticsearch adapter, support NULLS FIRST and NULLS LAST

[jira] [Commented] (CALCITE-4924) The aggregate functions about Covariance return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17460392#comment-17460392 ] duan xiong commented on CALCITE-4924: - [~julianhyde] [~zabetak] Hi. I need some advices about how

[jira] [Updated] (CALCITE-4871) CAST a literal to DECIMAL type return wrong result

[ https://issues.apache.org/jira/browse/CALCITE-4871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4871: Fix Version/s: (was: 1.29.0) > CAST a literal to DECIMAL type return wrong result >

[jira] [Commented] (CALCITE-4871) CAST a literal to DECIMAL type return wrong result

[ https://issues.apache.org/jira/browse/CALCITE-4871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17459530#comment-17459530 ] duan xiong commented on CALCITE-4871: - Because blocked by CALCITE-4929. So I will move it to

[jira] [Resolved] (CALCITE-4906) Wrong result for scalar subquery (single value aggregation) from empty input

[ https://issues.apache.org/jira/browse/CALCITE-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4906. - Resolution: Fixed > Wrong result for scalar subquery (single value aggregation) from empty

[jira] [Assigned] (CALCITE-4906) Wrong result for scalar subquery (single value aggregation) from empty input

[ https://issues.apache.org/jira/browse/CALCITE-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong reassigned CALCITE-4906: --- Assignee: Aleksey Plekhanov (was: duan xiong) > Wrong result for scalar subquery (single

[jira] [Commented] (CALCITE-4906) Wrong result for scalar subquery (single value aggregation) from empty input

[ https://issues.apache.org/jira/browse/CALCITE-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17459527#comment-17459527 ] duan xiong commented on CALCITE-4906: - Fixed in

[jira] [Assigned] (CALCITE-4906) Wrong result for scalar subquery (single value aggregation) from empty input

[ https://issues.apache.org/jira/browse/CALCITE-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong reassigned CALCITE-4906: --- Assignee: duan xiong (was: Aleksey Plekhanov) > Wrong result for scalar subquery (single

[jira] [Commented] (CALCITE-4799) SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE

[ https://issues.apache.org/jira/browse/CALCITE-4799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17458926#comment-17458926 ] duan xiong commented on CALCITE-4799: - Yes. Fixed in

[jira] [Updated] (CALCITE-4799) SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE

[ https://issues.apache.org/jira/browse/CALCITE-4799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4799: Fix Version/s: 1.29.0 > SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE >

[jira] [Commented] (CALCITE-4927) Remove deprecated RelBuilder#groupKey(ImmutableBitSet, ImmutableList) clashing with new replacement API

[ https://issues.apache.org/jira/browse/CALCITE-4927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17456449#comment-17456449 ] duan xiong commented on CALCITE-4927: - Fixed in

[jira] [Commented] (CALCITE-4924) The aggregate functions about Covariance return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17456045#comment-17456045 ] duan xiong commented on CALCITE-4924: - [~julianhyde] Hi. According to the ISO-SQL-2016, this is a

[jira] [Commented] (CALCITE-4851) Build gives lots of 'Execution optimizations have been disabled' warnings

[ https://issues.apache.org/jira/browse/CALCITE-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17455291#comment-17455291 ] duan xiong commented on CALCITE-4851: - Fixed in

[jira] [Resolved] (CALCITE-4851) Build gives lots of 'Execution optimizations have been disabled' warnings

[ https://issues.apache.org/jira/browse/CALCITE-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4851. - Assignee: duan xiong Resolution: Fixed > Build gives lots of 'Execution optimizations

[jira] [Updated] (CALCITE-4851) Build gives lots of 'Execution optimizations have been disabled' warnings

[ https://issues.apache.org/jira/browse/CALCITE-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4851: Summary: Build gives lots of 'Execution optimizations have been disabled' warnings (was: Lots

[jira] [Commented] (CALCITE-4924) The aggregate functions about Covariance return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17454327#comment-17454327 ] duan xiong commented on CALCITE-4924: - [~julianhyde]  I have changed the summary and described the

[jira] [Updated] (CALCITE-4924) The aggregate functions about Covariance return the wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Summary: The aggregate functions about Covariance return the wrong data type (was: The

[jira] [Updated] (CALCITE-4924) The aggregate functions about Covariance returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Summary: The aggregate functions about Covariance returns a wrong data type (was: The aggregate

[jira] [Updated] (CALCITE-4924) The aggregate function about Covariance returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Summary: The aggregate function about Covariance returns a wrong data type (was: The COVAR

[jira] [Updated] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Description: The SQL: {code:java} SELECT regr_sxx(SAL, COMM) as "REGR_SXX(SAL, COMM)" from

[jira] [Comment Edited] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17454009#comment-17454009 ] duan xiong edited comment on CALCITE-4924 at 12/6/21, 1:29 PM: --- I do some

[jira] [Comment Edited] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17454009#comment-17454009 ] duan xiong edited comment on CALCITE-4924 at 12/6/21, 1:28 PM: --- I do some

[jira] [Comment Edited] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17454009#comment-17454009 ] duan xiong edited comment on CALCITE-4924 at 12/6/21, 1:19 PM: --- I do some

[jira] [Commented] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17454009#comment-17454009 ] duan xiong commented on CALCITE-4924: - I do some research about this type of aggregate function.

[jira] [Commented] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17453506#comment-17453506 ] duan xiong commented on CALCITE-4924: - Thanks for your reply. The Covar is an aggregator which

[jira] [Updated] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

[ https://issues.apache.org/jira/browse/CALCITE-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4924: Description: According agg.iq unit test: {code:java} # [CALCITE-1776, CALCITE-2402] REGR_SXX,

[jira] [Created] (CALCITE-4924) The COVAR aggregate function returns a wrong data type

duan xiong created CALCITE-4924: --- Summary: The COVAR aggregate function returns a wrong data type Key: CALCITE-4924 URL: https://issues.apache.org/jira/browse/CALCITE-4924 Project: Calcite

[jira] [Resolved] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4911. - Resolution: Not A Problem > CAST operation should throw an exception when cast DECIMAL type

[jira] [Commented] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17452968#comment-17452968 ] duan xiong commented on CALCITE-4911: - I have tried some unit tests in PostgreSQL: {code:java}

[jira] [Comment Edited] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17452683#comment-17452683 ] duan xiong edited comment on CALCITE-4911 at 12/3/21, 9:06 AM: --- According

[jira] [Commented] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17452687#comment-17452687 ] duan xiong commented on CALCITE-4911: - [~julianhyde]  Do you have suggestions about this issue? I

[jira] [Commented] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17452683#comment-17452683 ] duan xiong commented on CALCITE-4911: - According to the implementation, RelDataTypeSystemImpl to

[jira] [Commented] (CALCITE-4907) JdbcJoin does not convert Join with always true/false RexNode

[ https://issues.apache.org/jira/browse/CALCITE-4907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17452100#comment-17452100 ] duan xiong commented on CALCITE-4907: - How about this summary "When Join condition is TRUE or FALSE

[jira] [Comment Edited] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17451437#comment-17451437 ] duan xiong edited comment on CALCITE-4911 at 11/30/21, 11:12 PM: - This

[jira] [Commented] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17451437#comment-17451437 ] duan xiong commented on CALCITE-4911: - This is caused by AggregateReduceFunctionsRule to replace

[jira] [Updated] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4911: Description: In Calcite: {code:java} select avg(comm) as a from "scott".emp{code} This SQL

[jira] [Updated] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

[ https://issues.apache.org/jira/browse/CALCITE-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4911: Description: In Calcite: {code:java} select avg(comm) as a from "scott".emp{code} This SQL

[jira] [Created] (CALCITE-4911) CAST operation should throw an exception when cast DECIMAL type lose significant digits

duan xiong created CALCITE-4911: --- Summary: CAST operation should throw an exception when cast DECIMAL type lose significant digits Key: CALCITE-4911 URL: https://issues.apache.org/jira/browse/CALCITE-4911

[jira] [Commented] (CALCITE-4910) Enhance simplify to reduce ((a or d) and (a or c) and a and b) to (a and b)

[ https://issues.apache.org/jira/browse/CALCITE-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17450824#comment-17450824 ] duan xiong commented on CALCITE-4910: - [~Ziwei Liu] Please reformat the description about the code

[jira] [Comment Edited] (CALCITE-4889) Double join is created for NOT IN when IN-list is converted to Values

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17450765#comment-17450765 ] duan xiong edited comment on CALCITE-4889 at 11/29/21, 11:21 PM: -

[jira] [Updated] (CALCITE-4889) Double join is created for NOT IN when IN-list is converted to Values

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4889: Description: The following queries yield several joins in the plan. I think double joins are

[jira] [Commented] (CALCITE-4889) Double join is created for NOT IN when IN-list is converted to Values

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17450765#comment-17450765 ] duan xiong commented on CALCITE-4889: - update. > Double join is created for NOT IN when IN-list

[jira] [Updated] (CALCITE-4889) Double join is created for NOT IN when IN-list is converted to Values

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4889: Summary: Double join is created for NOT IN when IN-list is converted to Values (was: Double

[jira] [Commented] (CALCITE-4888) Fix type inferring when call RelBuilder.in with arguments that are different types.

[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17449552#comment-17449552 ] duan xiong commented on CALCITE-4888: - [~jingzhang] The RelNode can be directly run by  {noformat}

[jira] [Comment Edited] (CALCITE-4889) Double join is created for NOT IN

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17449531#comment-17449531 ] duan xiong edited comment on CALCITE-4889 at 11/26/21, 10:56 AM: -

[jira] [Commented] (CALCITE-4889) Double join is created for NOT IN

[ https://issues.apache.org/jira/browse/CALCITE-4889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17449531#comment-17449531 ] duan xiong commented on CALCITE-4889: - [~jingzhang] You can reproduce this issue by setting 

[jira] [Commented] (CALCITE-4903) Avatica pads values returned from values-clause to same length

[ https://issues.apache.org/jira/browse/CALCITE-4903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17448876#comment-17448876 ] duan xiong commented on CALCITE-4903: - This is a duplicate of CALCITE-4590.  > Avatica pads values

[jira] [Comment Edited] (CALCITE-4888) Unify type inferring logical for Sarg RexLiteral

[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17448682#comment-17448682 ] duan xiong edited comment on CALCITE-4888 at 11/24/21, 3:38 PM: If you

[jira] [Commented] (CALCITE-4888) Unify type inferring logical for Sarg RexLiteral

[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17448682#comment-17448682 ] duan xiong commented on CALCITE-4888: - If you don't think this is a problem, Please add extra SQL

[jira] [Commented] (CALCITE-4901) RelToSqlConverter adds redundant order by output column for the result sql

[ https://issues.apache.org/jira/browse/CALCITE-4901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17448677#comment-17448677 ] duan xiong commented on CALCITE-4901: - Yes. The Calcite-Dialect can get the expected SQL.  The

[jira] [Commented] (CALCITE-4888) Unexpected `RexNode` when call `RelBuilder.in` to create an `IN` predicate with a list of varchar literals which have different length

[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17447738#comment-17447738 ] duan xiong commented on CALCITE-4888: - [~qingru zhang]  Thanks for your reply. After my test, the

[jira] [Resolved] (CALCITE-4876) Converting RelNode to SQL with CalciteSqlDialect gets wrong result while EnumerableIntersect is followed by EnumerableLimit

[ https://issues.apache.org/jira/browse/CALCITE-4876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4876. - Fix Version/s: 1.29.0 Resolution: Fixed > Converting RelNode to SQL with

[jira] [Commented] (CALCITE-4876) Converting RelNode to SQL with CalciteSqlDialect gets wrong result while EnumerableIntersect is followed by EnumerableLimit

[ https://issues.apache.org/jira/browse/CALCITE-4876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17447222#comment-17447222 ] duan xiong commented on CALCITE-4876: - Fixed in

[jira] [Commented] (CALCITE-4888) Unexpected `RexNode` when call `RelBuilder.in` to create an `IN` predicate with a list of varchar literals which have different length

[ https://issues.apache.org/jira/browse/CALCITE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17445959#comment-17445959 ] duan xiong commented on CALCITE-4888: - [~qingru zhang] Hi. I'm very glad about you're interested in

[jira] [Resolved] (CALCITE-4846) IN-list that includes NULL converted to Values throws exception

[ https://issues.apache.org/jira/browse/CALCITE-4846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4846. - Fix Version/s: 1.29.0 Resolution: Fixed > IN-list that includes NULL converted to

[jira] [Commented] (CALCITE-4846) IN-list that includes NULL converted to Values throws exception

[ https://issues.apache.org/jira/browse/CALCITE-4846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17444561#comment-17444561 ] duan xiong commented on CALCITE-4846: - Fixed in

[jira] [Commented] (CALCITE-4887) Filter subQuery remove not fully optimized

[ https://issues.apache.org/jira/browse/CALCITE-4887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17443327#comment-17443327 ] duan xiong commented on CALCITE-4887: - [~bingfeng]  If you can find an easy SQL to describe this

[jira] [Comment Edited] (CALCITE-4886) When converting SQL to RelNode, SqlOrderBy is missing in sub-query that contains SqlSetOperator

[ https://issues.apache.org/jira/browse/CALCITE-4886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17443326#comment-17443326 ] duan xiong edited comment on CALCITE-4886 at 11/14/21, 12:35 PM: -

[jira] [Commented] (CALCITE-4886) When converting SQL to RelNode, SqlOrderBy is missing in sub-query that contains SqlSetOperator

[ https://issues.apache.org/jira/browse/CALCITE-4886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17443326#comment-17443326 ] duan xiong commented on CALCITE-4886: - According to Sql Std 2006: {noformat} Table -> An unordered

[jira] [Commented] (CALCITE-4846) IN-list that includes NULL converted to Values throws exception

[ https://issues.apache.org/jira/browse/CALCITE-4846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17442996#comment-17442996 ] duan xiong commented on CALCITE-4846: - The PR has been updated. And ready to rewiew. > IN-list

[jira] [Updated] (CALCITE-4846) IN-list that includes NULL converted to Values throws exception

[ https://issues.apache.org/jira/browse/CALCITE-4846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4846: Summary: IN-list that includes NULL converted to Values throws exception (was: When convert ROW

[jira] [Resolved] (CALCITE-4844) IN-list that references columns is wrongly converted to Values, and gives incorrect results

[ https://issues.apache.org/jira/browse/CALCITE-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4844. - Fix Version/s: (was: 1.29.0) Resolution: Fixed > IN-list that references columns is

[jira] [Commented] (CALCITE-4844) IN-list that references columns is wrongly converted to Values, and gives incorrect results

[ https://issues.apache.org/jira/browse/CALCITE-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17442573#comment-17442573 ] duan xiong commented on CALCITE-4844: - Fixed in

[jira] [Updated] (CALCITE-4768) Upgrade DataStax Driver for Apache Cassandra® version to latest 4.x

[ https://issues.apache.org/jira/browse/CALCITE-4768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4768: Fix Version/s: (was: 1.29.0) > Upgrade DataStax Driver for Apache Cassandra® version to

[jira] [Updated] (CALCITE-4131) the XmlFunctions exception handled by System.out

[ https://issues.apache.org/jira/browse/CALCITE-4131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4131: Fix Version/s: (was: 1.29.0) > the XmlFunctions exception handled by System.out >

[jira] [Updated] (CALCITE-4877) Make the exception information of class not found more explicit

[ https://issues.apache.org/jira/browse/CALCITE-4877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4877: Fix Version/s: (was: 1.29.0) > Make the exception information of class not found more

[jira] [Updated] (CALCITE-4799) SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE

[ https://issues.apache.org/jira/browse/CALCITE-4799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4799: Fix Version/s: (was: 1.29.0) > SqlXmlFunctionsTest testXmlTransform unit test failed caused

[jira] [Commented] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

[ https://issues.apache.org/jira/browse/CALCITE-4875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17442155#comment-17442155 ] duan xiong commented on CALCITE-4875: - [~Chunwei Lei]  Sorry. Thanks for your reminder. I will

[jira] [Updated] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

[ https://issues.apache.org/jira/browse/CALCITE-4875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4875: Affects Version/s: 1.28.0 > NVL Function Incorrectly changes nullability field of its operands >

[jira] [Resolved] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

[ https://issues.apache.org/jira/browse/CALCITE-4875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4875. - Fix Version/s: 1.29.0 Resolution: Fixed > NVL Function Incorrectly changes nullability

[jira] [Commented] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

[ https://issues.apache.org/jira/browse/CALCITE-4875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17442101#comment-17442101 ] duan xiong commented on CALCITE-4875: - Fixed in

[jira] [Updated] (CALCITE-4799) SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE

[ https://issues.apache.org/jira/browse/CALCITE-4799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4799: Affects Version/s: 1.28.0 > SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE

[jira] [Resolved] (CALCITE-4799) SqlXmlFunctionsTest testXmlTransform unit test failed caused by NPE

[ https://issues.apache.org/jira/browse/CALCITE-4799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong resolved CALCITE-4799. - Fix Version/s: 1.29.0 Resolution: Fixed > SqlXmlFunctionsTest testXmlTransform unit

[jira] [Commented] (CALCITE-4131) the XmlFunctions exception handled by System.out

[ https://issues.apache.org/jira/browse/CALCITE-4131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17439668#comment-17439668 ] duan xiong commented on CALCITE-4131: - [~julianhyde] The PR has been updated.  > the XmlFunctions

[jira] [Commented] (CALCITE-4877) Make the exception information of class not found more explicit

[ https://issues.apache.org/jira/browse/CALCITE-4877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17439559#comment-17439559 ] duan xiong commented on CALCITE-4877: - [~sunjincheng121] Please use log info to replace the image. 

[jira] [Updated] (CALCITE-4875) NVL Function Incorrectly changes nullability field of its operands

[ https://issues.apache.org/jira/browse/CALCITE-4875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4875: Description: We rewrite the NVL function in 

[jira] [Commented] (CALCITE-4462) `ROUND` SQL function throws exception on Infinite or NaN arguments

[ https://issues.apache.org/jira/browse/CALCITE-4462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17439099#comment-17439099 ] duan xiong commented on CALCITE-4462: - Looks like CALCITE-4589 is a related ISSUE. > `ROUND` SQL

[jira] [Commented] (CALCITE-4462) `ROUND` SQL function throws exception on Infinite or NaN arguments

[ https://issues.apache.org/jira/browse/CALCITE-4462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17439098#comment-17439098 ] duan xiong commented on CALCITE-4462: - [~ysazonets] Please reformat the exception log by

  1   2   3   4   5   >