[jira] [Commented] (CALCITE-2152) SQL parser unable to parse SQL with nested joins produced by RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429120#comment-17429120 ] Julian Hyde commented on CALCITE-2152: -- [~ian.bertolacci], That's a good idea. >

[jira] [Resolved] (CALCITE-4732) date type field group problem

[ https://issues.apache.org/jira/browse/CALCITE-4732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james yang resolved CALCITE-4732. - Resolution: Fixed > date type field group problem > - > >

[jira] [Comment Edited] (CALCITE-4732) date type field group problem

[ https://issues.apache.org/jira/browse/CALCITE-4732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429108#comment-17429108 ] james yang edited comment on CALCITE-4732 at 10/15/21, 4:34 AM: -

[jira] [Commented] (CALCITE-4732) date type field group problem

[ https://issues.apache.org/jira/browse/CALCITE-4732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429108#comment-17429108 ] james yang commented on CALCITE-4732: - hi, I pushed the test case and it works well

[jira] [Closed] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target

[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xurenhe closed CALCITE-4817. Resolution: Duplicate > Expand SubstitutionVisitor of Aggregate with max/min, which column is the > grou

[jira] [Commented] (CALCITE-4817) Expand SubstitutionVisitor of Aggregate with max/min, which column is the group by list of target

[ https://issues.apache.org/jira/browse/CALCITE-4817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429102#comment-17429102 ] Xurenhe commented on CALCITE-4817: -- Close this issue, fixed in  [CALCITE-4735|https://

[jira] [Commented] (CALCITE-4735) SubstitutionVisitor of Aggregate Failed, when aggcalls of query could be expressed by target's grouping

[ https://issues.apache.org/jira/browse/CALCITE-4735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429093#comment-17429093 ] duan xiong commented on CALCITE-4735: - [~yanlin-Lynn] The fixed comment link is not

[jira] [Commented] (CALCITE-4854) SubstitutionVisitor exec aggregate-match fail, which query with grouping literal alone

[ https://issues.apache.org/jira/browse/CALCITE-4854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429092#comment-17429092 ] Xurenhe commented on CALCITE-4854: -- Hi [~xzh_dz] Please review this issue, because it

[jira] [Created] (CALCITE-4854) SubstitutionVisitor exec aggregate-match fail, which query with grouping literal alone

Xurenhe created CALCITE-4854: Summary: SubstitutionVisitor exec aggregate-match fail, which query with grouping literal alone Key: CALCITE-4854 URL: https://issues.apache.org/jira/browse/CALCITE-4854 Proj

[jira] [Resolved] (CALCITE-4735) SubstitutionVisitor of Aggregate Failed, when aggcalls of query could be expressed by target's grouping

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

[jira] [Created] (CALCITE-4853) Gradle could not determine the dependencies of task ':syncPreviewSiteRepo'

Julian Hyde created CALCITE-4853: Summary: Gradle could not determine the dependencies of task ':syncPreviewSiteRepo' Key: CALCITE-4853 URL: https://issues.apache.org/jira/browse/CALCITE-4853 Project:

[jira] [Updated] (CALCITE-3935) Materialization-Failed, meeting to pull up bottom filter of Left/Right Join

[ https://issues.apache.org/jira/browse/CALCITE-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3935: - Fix Version/s: 1.28.0 > Materialization-Failed, meeting to pull up bottom filter of Left/Right

[jira] [Commented] (CALCITE-4420) Some simple arithmetic operations can be simplified

[ https://issues.apache.org/jira/browse/CALCITE-4420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429080#comment-17429080 ] Julian Hyde commented on CALCITE-4420: -- Fixed in [c700e379|https://github.com/apa

[jira] [Updated] (CALCITE-4420) Some simple arithmetic operations can be simplified

[ https://issues.apache.org/jira/browse/CALCITE-4420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4420: - Fix Version/s: 1.28.0 > Some simple arithmetic operations can be simplified > -

[jira] [Updated] (CALCITE-4532) Rex simplification fails with an exception on nested CASTs with ANY

[ https://issues.apache.org/jira/browse/CALCITE-4532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4532: - Fix Version/s: 1.28.0 > Rex simplification fails with an exception on nested CASTs with ANY > -

[jira] [Closed] (CALCITE-4495) Sarg simplification with IS_NULL and unknown type throws IllegalArgumentException

[ https://issues.apache.org/jira/browse/CALCITE-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4495. > Sarg simplification with IS_NULL and unknown type throws > IllegalArgumentException >

[jira] [Updated] (CALCITE-4584) Using function in PARTITION BY list of OVER window causes exception during conversion

[ https://issues.apache.org/jira/browse/CALCITE-4584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4584: - Fix Version/s: 1.28.0 > Using function in PARTITION BY list of OVER window causes exception dur

[jira] [Updated] (CALCITE-4584) Using function in PARTITION BY list of OVER window causes exception during conversion

[ https://issues.apache.org/jira/browse/CALCITE-4584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4584: - Summary: Using function in PARTITION BY list of OVER window causes exception during conversion

[jira] [Updated] (CALCITE-4647) INTERSECT returns wrong results

[ https://issues.apache.org/jira/browse/CALCITE-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4647: - Summary: INTERSECT returns wrong results (was: intersect returns wrong results) > INTERSECT r

[jira] [Closed] (CALCITE-4633) Enable RelFieldTrimmer to trim fields on a distinct UNION

[ https://issues.apache.org/jira/browse/CALCITE-4633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4633. > Enable RelFieldTrimmer to trim fields on a distinct UNION > ---

[jira] [Closed] (CALCITE-4647) INTERSECT returns wrong results

[ https://issues.apache.org/jira/browse/CALCITE-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4647. > INTERSECT returns wrong results > --- > > Key: CALCITE-

[jira] [Closed] (CALCITE-4648) Except returns wrong results

[ https://issues.apache.org/jira/browse/CALCITE-4648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4648. > Except returns wrong results > > > Key: CALCITE-4648 >

[jira] [Commented] (CALCITE-4732) date type field group problem

[ https://issues.apache.org/jira/browse/CALCITE-4732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429078#comment-17429078 ] Julian Hyde commented on CALCITE-4732: -- Is there a test case or a commit that prov

[jira] [Closed] (CALCITE-4697) GROUPING_ID may be distinct from GROUPING

[ https://issues.apache.org/jira/browse/CALCITE-4697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4697. > GROUPING_ID may be distinct from GROUPING > - > >

[jira] [Reopened] (CALCITE-4732) date type field group problem

[ https://issues.apache.org/jira/browse/CALCITE-4732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-4732: -- > date type field group problem > - > > Key: CALCITE-

[jira] [Updated] (CALCITE-4734) If there are duplicate RexNode in MutableCalc, SubstitutionVisitor should return right rebuild RexNode

[ https://issues.apache.org/jira/browse/CALCITE-4734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4734: - Fix Version/s: 1.28.0 > If there are duplicate RexNode in MutableCalc, SubstitutionVisitor shou

[jira] [Commented] (CALCITE-4776) SqlParseException:WEIGHT_STRING('ab' AS CHAR(4))

[ https://issues.apache.org/jira/browse/CALCITE-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429075#comment-17429075 ] Julian Hyde commented on CALCITE-4776: -- I changed the resolution to 'won't fix'. T

[jira] [Closed] (CALCITE-4738) Pattern of RelNode: `Aggregate-Project-Aggregate` executing RelToSqlConverter error.

[ https://issues.apache.org/jira/browse/CALCITE-4738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4738. > Pattern of RelNode: `Aggregate-Project-Aggregate` executing RelToSqlConverter > error. > -

[jira] [Reopened] (CALCITE-4776) SqlParseException:WEIGHT_STRING('ab' AS CHAR(4))

[ https://issues.apache.org/jira/browse/CALCITE-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reopened CALCITE-4776: -- > SqlParseException:WEIGHT_STRING('ab' AS CHAR(4)) > --

[jira] [Resolved] (CALCITE-4776) SqlParseException:WEIGHT_STRING('ab' AS CHAR(4))

[ https://issues.apache.org/jira/browse/CALCITE-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4776. -- Resolution: Won't Fix > SqlParseException:WEIGHT_STRING('ab' AS CHAR(4)) >

[jira] [Updated] (CALCITE-4776) SqlParseException:WEIGHT_STRING('ab' AS CHAR(4))

[ https://issues.apache.org/jira/browse/CALCITE-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4776: - Component/s: (was: server) core > SqlParseException:WEIGHT_STRING('ab' AS

[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 ] Julian Hyde updated CALCITE-4778: - Description: {code:java} // code placeholder org.apache.calcite.plan.RelWriterTest @Test public

[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 ] Julian Hyde updated CALCITE-4778: - Fix Version/s: 1.28.0 > Exchange operator deserialize fail when the RexInput has no RelCollcati

[jira] [Updated] (CALCITE-4816) Make Gradle pass the 'user.timezone' property to the test JVM in Avatica

[ https://issues.apache.org/jira/browse/CALCITE-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-4816: - Fix Version/s: avatica-1.19.0 1.28.0 > Make Gradle pass the 'user.timezone'

[jira] [Closed] (CALCITE-4781) group by index is not support

[ https://issues.apache.org/jira/browse/CALCITE-4781?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-4781. > group by index is not support > - > > Key: CALCITE-4781

[jira] [Updated] (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 ] Julian Hyde updated CALCITE-4779: - Fix Version/s: 1.28.0 > GroupByList contains constant literal, materialized view recognition fa

[jira] [Comment Edited] (CALCITE-3524) Add methods to RelBuilder to create RexSubQuery

[ https://issues.apache.org/jira/browse/CALCITE-3524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429069#comment-17429069 ] Julian Hyde edited comment on CALCITE-3524 at 10/15/21, 12:53 AM: ---

[jira] [Resolved] (CALCITE-3524) Add methods to RelBuilder to create RexSubQuery

[ https://issues.apache.org/jira/browse/CALCITE-3524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3524. -- Resolution: Fixed Fixed in [67b28382|https://github.com/apache/calcite/commit/67b283823d2470

[jira] [Resolved] (CALCITE-4719) Add variants of RexSubQuery that collect sub-queries into MULTISET, ARRAY and MAP collections

[ https://issues.apache.org/jira/browse/CALCITE-4719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-4719. -- Resolution: Fixed Fixed in [9c741e44|https://github.com/apache/calcite/commit/9c741e4415362c

[jira] [Commented] (CALCITE-4843) optimize ALL,SOME sub-query list when op is the <, <=,> or >=

[ https://issues.apache.org/jira/browse/CALCITE-4843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429035#comment-17429035 ] duan xiong commented on CALCITE-4843: - [~Chunwei Lei] . Hi. This SQL maybe is a rar

[jira] [Commented] (CALCITE-2152) SQL parser unable to parse SQL with nested joins produced by RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429029#comment-17429029 ] Ian Bertolacci commented on CALCITE-2152: - We solved this our RelToSqlConverter

[jira] [Closed] (CALCITE-4852) RelToSqlConverter creates unparseable SQL string from right associative multi-way join.

[ https://issues.apache.org/jira/browse/CALCITE-4852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Bertolacci closed CALCITE-4852. --- Resolution: Duplicate > RelToSqlConverter creates unparseable SQL string from right associa

[jira] [Created] (CALCITE-4852) RelToSqlConverter creates unparseable SQL string from right associative multi-way join.

Ian Bertolacci created CALCITE-4852: --- Summary: RelToSqlConverter creates unparseable SQL string from right associative multi-way join. Key: CALCITE-4852 URL: https://issues.apache.org/jira/browse/CALCITE-4852

[jira] [Commented] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428993#comment-17428993 ] Julian Hyde commented on CALCITE-4639: -- [~nobigo], Thanks for the PR. I haven't tr

[jira] [Commented] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428898#comment-17428898 ] duan xiong commented on CALCITE-4639: - [~julianhyde] The PR has been submitted. Ple

[jira] [Updated] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4639: Labels: pull-request-available (was: ) > Broken links on download page > ---

[jira] [Updated] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4639: Component/s: site > Broken links on download page > - > >

[jira] [Updated] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4639: Fix Version/s: 1.28.0 > Broken links on download page > - > >

[jira] [Updated] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong updated CALCITE-4639: Affects Version/s: 1.27.0 > Broken links on download page > - > >

[jira] [Assigned] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] duan xiong reassigned CALCITE-4639: --- Assignee: duan xiong > Broken links on download page > - > >

[jira] [Commented] (CALCITE-4639) Broken links on download page

[ https://issues.apache.org/jira/browse/CALCITE-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428757#comment-17428757 ] Sebb commented on CALCITE-4639: --- If the download page has the wrong name, then please fix

[jira] [Resolved] (CALCITE-4848) Adding a HAVING condition to a query with a dynamic parameter makes the result always empty

[ https://issues.apache.org/jira/browse/CALCITE-4848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4848. Resolution: Fixed Fixed via https://github.com/apache/calcite/commit/23e1b1fcae6614fb9b660095125

[jira] [Commented] (CALCITE-4337) Support PARTITION BY clause in table function call

[ https://issues.apache.org/jira/browse/CALCITE-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428724#comment-17428724 ] JING ZHANG commented on CALCITE-4337: - [~vilo] # Maybe there are only minor differ

[jira] [Updated] (CALCITE-4735) SubstitutionVisitor of Aggregate Failed, when aggcalls of query could be expressed by target's grouping

[ https://issues.apache.org/jira/browse/CALCITE-4735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xurenhe updated CALCITE-4735: - Description: `SubstitutionVisitor` don't work for rewriting query by mv, let me show a example of the

[jira] [Commented] (CALCITE-4849) Query SQL cannot complete materialized view rewrite properly

[ https://issues.apache.org/jira/browse/CALCITE-4849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428706#comment-17428706 ] jhkcool commented on CALCITE-4849: -- [~Chunwei Lei] I can not reproduce it in calcite u

[jira] [Commented] (CALCITE-4774) When predicate conditions are equivalent, materialized view recognition fails.

[ https://issues.apache.org/jira/browse/CALCITE-4774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17428655#comment-17428655 ] Haisheng Yuan commented on CALCITE-4774: Yes, sorry for the confusion, I will a