[jira] [Updated] (CALCITE-4808) RelOptUtil.getVariablesUsed should assert that correlated variables are used in scope

[ https://issues.apache.org/jira/browse/CALCITE-4808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4808: Labels: pull-request-available (was: ) > RelOptUtil.getVariablesUsed should assert that

[jira] [Created] (CALCITE-4808) RelOptUtil.getVariablesUsed should assert that correlated variables are used in scope

James Starr created CALCITE-4808: Summary: RelOptUtil.getVariablesUsed should assert that correlated variables are used in scope Key: CALCITE-4808 URL: https://issues.apache.org/jira/browse/CALCITE-4808

[jira] [Updated] (CALCITE-4778) Exchange operator deserialize fail when the RexInput has no RelCollcation

[ https://issues.apache.org/jira/browse/CALCITE-4778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xzh_dz updated CALCITE-4778: Summary: Exchange operator deserialize fail when the RexInput has no RelCollcation (was: Exchange

[jira] [Commented] (CALCITE-4800) Add SortToSortUnifyRule in SubstitutionVisitor

[ https://issues.apache.org/jira/browse/CALCITE-4800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421119#comment-17421119 ] xzh_dz commented on CALCITE-4800: - [~wojustme] no, `SortToSortUnifyRule` hasn't been proposed yet.And 

[jira] [Resolved] (CALCITE-4779) GroupByList contains constant literal, materialized view recognition failed

[ https://issues.apache.org/jira/browse/CALCITE-4779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin resolved CALCITE-4779. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3588) JDBC adapter should handle join conditions containing IS TRUE, SIMILAR TO etc. when generating SQL

[ https://issues.apache.org/jira/browse/CALCITE-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421114#comment-17421114 ] xzh_dz commented on CALCITE-3588: - [~julianhyde] [~jinxing6...@126.com] I rerun the unit

[jira] [Commented] (CALCITE-4805) The IN sub-query can't be converted to OR when value list contains Null.

[ https://issues.apache.org/jira/browse/CALCITE-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421105#comment-17421105 ] Julian Hyde commented on CALCITE-4805: -- I think you're saying: 1. It is always valid to convert

[jira] [Commented] (CALCITE-4600) ClassCastException for arrays with date/time/timestamp elements

[ https://issues.apache.org/jira/browse/CALCITE-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421099#comment-17421099 ] Sergey Nuyanzin commented on CALCITE-4600: -- added test for calcite as requested >

[jira] [Commented] (CALCITE-4602) ClassCastException for arrays with int and decimal elements within one array

[ https://issues.apache.org/jira/browse/CALCITE-4602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421098#comment-17421098 ] Sergey Nuyanzin commented on CALCITE-4602: -- added test for calcite as requested >

[jira] [Updated] (CALCITE-4600) ClassCastException for arrays with date/time/timestamp elements

[ https://issues.apache.org/jira/browse/CALCITE-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4600: Labels: pull-request-available (was: ) > ClassCastException for arrays with

[jira] [Updated] (CALCITE-4602) ClassCastException for arrays with int and decimal elements within one array

[ https://issues.apache.org/jira/browse/CALCITE-4602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-4602: Labels: pull-request-available (was: ) > ClassCastException for arrays with int and

[jira] [Commented] (CALCITE-4787) Evaluate use of Immutables instead of ImmutableBeans

[ https://issues.apache.org/jira/browse/CALCITE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421096#comment-17421096 ] Jacques Nadeau commented on CALCITE-4787: - [~vlsi], I appreciate the desire but frankly my

[jira] [Commented] (CALCITE-4806) Lossy CAST is incorrectly simplified

[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421085#comment-17421085 ] Julian Hyde commented on CALCITE-4806: -- [~nobigo], It's a different issue (rounding vs

[jira] [Commented] (CALCITE-4806) Lossy CAST is incorrectly simplified

[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421056#comment-17421056 ] duan xiong commented on CALCITE-4806: - [~julianhyde] [~xuyangzhong] Another problem that needs to

[jira] [Commented] (CALCITE-4602) ClassCastException for arrays with int and decimal elements within one array

[ https://issues.apache.org/jira/browse/CALCITE-4602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421044#comment-17421044 ] duan xiong commented on CALCITE-4602: - Same as CALCITE-4600 need to add an extra PR about the

[jira] [Comment Edited] (CALCITE-4798) Gradle build fails due to deprecated metadata APIs

[ https://issues.apache.org/jira/browse/CALCITE-4798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420741#comment-17420741 ] Stamatis Zampetakis edited comment on CALCITE-4798 at 9/27/21, 9:25 PM:

[jira] [Comment Edited] (CALCITE-4600) ClassCastException for arrays with date/time/timestamp elements

[ https://issues.apache.org/jira/browse/CALCITE-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421042#comment-17421042 ] duan xiong edited comment on CALCITE-4600 at 9/27/21, 9:24 PM: --- [~Sergey

[jira] [Commented] (CALCITE-4600) ClassCastException for arrays with date/time/timestamp elements

[ https://issues.apache.org/jira/browse/CALCITE-4600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17421042#comment-17421042 ] duan xiong commented on CALCITE-4600: - [~Sergey Nuyanzin] Hi. Please add the relative unit tests in

[jira] [Commented] (CALCITE-4787) Evaluate use of Immutables instead of ImmutableBeans

[ https://issues.apache.org/jira/browse/CALCITE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420991#comment-17420991 ] Vladimir Sitnikov commented on CALCITE-4787: One more issue: the code is invalid in IDEA

[jira] [Commented] (CALCITE-4798) Gradle build fails due to deprecated metadata APIs

[ https://issues.apache.org/jira/browse/CALCITE-4798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420980#comment-17420980 ] James Starr commented on CALCITE-4798: -- I am using oracle on Mac. I can not reproduce it with

[jira] [Comment Edited] (CALCITE-4787) Evaluate use of Immutables instead of ImmutableBeans

[ https://issues.apache.org/jira/browse/CALCITE-4787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420413#comment-17420413 ] Jacques Nadeau edited comment on CALCITE-4787 at 9/27/21, 4:17 PM: ---

[jira] [Comment Edited] (CALCITE-4798) Gradle build fails due to deprecated metadata APIs

[ https://issues.apache.org/jira/browse/CALCITE-4798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420741#comment-17420741 ] Stamatis Zampetakis edited comment on CALCITE-4798 at 9/27/21, 1:27 PM:

[jira] [Commented] (CALCITE-4798) Gradle build fails due to deprecated metadata APIs

[ https://issues.apache.org/jira/browse/CALCITE-4798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420741#comment-17420741 ] Stamatis Zampetakis commented on CALCITE-4798: -- I think the {{-Werror}} flag is not

[jira] [Commented] (CALCITE-4798) Gradle build fails due to deprecated metadata APIs

[ https://issues.apache.org/jira/browse/CALCITE-4798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420732#comment-17420732 ] Stamatis Zampetakis commented on CALCITE-4798: -- [~jamesstarr] I thought that the problem

[jira] [Commented] (CALCITE-4805) The IN sub-query can't be converted to OR when value list contains Null.

[ https://issues.apache.org/jira/browse/CALCITE-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420720#comment-17420720 ] duan xiong commented on CALCITE-4805: - Until CALCITE-2604 RexUnknownAs add in calcite. And

[jira] [Comment Edited] (CALCITE-4805) The IN sub-query can't be converted to OR when value list contains Null.

[ https://issues.apache.org/jira/browse/CALCITE-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420706#comment-17420706 ] duan xiong edited comment on CALCITE-4805 at 9/27/21, 12:28 PM:

[jira] [Commented] (CALCITE-4805) The IN sub-query can't be converted to OR when value list contains Null.

[ https://issues.apache.org/jira/browse/CALCITE-4805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420706#comment-17420706 ] duan xiong commented on CALCITE-4805: - [~julianhyde] [~donnyzone] Hi. Thank you reply.

[jira] [Commented] (CALCITE-4800) Add SortToSortUnifyRule in SubstitutionVisitor

[ https://issues.apache.org/jira/browse/CALCITE-4800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420660#comment-17420660 ] Xurenhe commented on CALCITE-4800: -- Is it duplicate with other issues? *

[jira] [Resolved] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-4807. -- Fix Version/s: 1.28.0 Resolution: Duplicate I am closing this as

[jira] [Assigned] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jhkcool reassigned CALCITE-4807: Assignee: jhkcool > Materialized views do not support SQL with limit and order by well >

[jira] [Updated] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jhkcool updated CALCITE-4807: - Affects Version/s: 1.27.0 > Materialized views do not support SQL with limit and order by well >

[jira] [Commented] (CALCITE-4806) When simplifying 'equals', the data type will be ignore

[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420504#comment-17420504 ] xuyangzhong commented on CALCITE-4806: -- In Mysql "select cast(1.1 as signed)=1" is 1. In calcite

[jira] [Updated] (CALCITE-4806) Lossy CAST is incorrectly simplified

[ https://issues.apache.org/jira/browse/CALCITE-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] xuyangzhong updated CALCITE-4806: - Summary: Lossy CAST is incorrectly simplified (was: When simplifying 'equals', the data type

[jira] [Commented] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420503#comment-17420503 ] jhkcool commented on CALCITE-4807: -- But limit operator is also not supported, the problem of `Sort

[jira] [Commented] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420500#comment-17420500 ] xzh_dz commented on CALCITE-4807: - Materialized view recognition of `Sort operator` has not been

[jira] [Updated] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jhkcool updated CALCITE-4807: - Description: I think the current (calcite-1.27.0 tag branch version) of the materialized view SQL

[jira] [Updated] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

[ https://issues.apache.org/jira/browse/CALCITE-4807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jhkcool updated CALCITE-4807: - Description: I think the current (calcite-1.27.0 tag branch version) of the materialized view SQL

[jira] [Created] (CALCITE-4807) Materialized views do not support SQL with limit and order by well

jhkcool created CALCITE-4807: Summary: Materialized views do not support SQL with limit and order by well Key: CALCITE-4807 URL: https://issues.apache.org/jira/browse/CALCITE-4807 Project: Calcite