[jira] [Assigned] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing reassigned CALCITE-3495: - Assignee: Wang Yanlin > RelDecorrelator generate plan with different semantics when handle

[jira] [Commented] (CALCITE-3387) Query with GROUP BY and JOIN ... USING wrongly fails with "Column 'DEPTNO' is ambiguous" error

[ https://issues.apache.org/jira/browse/CALCITE-3387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16997997#comment-16997997 ] Jin Xing commented on CALCITE-3387: --- Given tables like below {code:java} emp: empno deptno dept:

[jira] [Commented] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16997940#comment-16997940 ] Jin Xing commented on CALCITE-3466: --- Hi [~wangweidong] I checked the PR and agree that the problem is

[jira] [Comment Edited] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16997906#comment-16997906 ] Jin Xing edited comment on CALCITE-3495 at 12/17/19 5:52 AM: -

[jira] [Commented] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16997906#comment-16997906 ] Jin Xing commented on CALCITE-3495: --- [~yanlin-Lynn] If you are interested in this issue, feel free

[jira] [Commented] (CALCITE-3605) Semantics of relation operator changed after decorrelated

[ https://issues.apache.org/jira/browse/CALCITE-3605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16997841#comment-16997841 ] Jin Xing commented on CALCITE-3605: --- Related with https://issues.apache.org/jira/browse/CALCITE-3495

[jira] [Commented] (CALCITE-3588) Support more operators in Join condition when convert RelNode to SqlNode

[ https://issues.apache.org/jira/browse/CALCITE-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16995302#comment-16995302 ] Jin Xing commented on CALCITE-3588: --- Thanks for feedback, Julian ~ Yeah, the test and exception is

[jira] [Updated] (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:all-tabpanel ] Jin Xing updated CALCITE-3588: -- Summary: JDBC adapter should handle join conditions containing IS TRUE, SIMILAR TO etc. when

[jira] [Commented] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994734#comment-16994734 ] Jin Xing commented on CALCITE-3589: --- Yes, [~bingfeng] Different conformances define different

[jira] [Comment Edited] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994702#comment-16994702 ] Jin Xing edited comment on CALCITE-3593 at 12/12/19 2:01 PM: - Seems two

[jira] [Commented] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994702#comment-16994702 ] Jin Xing commented on CALCITE-3593: --- Seems two things to fix: # Currently property of isHavingAlias

[jira] [Commented] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994270#comment-16994270 ] Jin Xing commented on CALCITE-3589: --- In the case given by [~bingfeng], I think Calcite throws the

[jira] [Comment Edited] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994219#comment-16994219 ] Jin Xing edited comment on CALCITE-3589 at 12/12/19 6:11 AM: - Running below

[jira] [Commented] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994219#comment-16994219 ] Jin Xing commented on CALCITE-3589: --- I think the case [~bingfeng] gave in Jira description might be a

[jira] [Commented] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994159#comment-16994159 ] Jin Xing commented on CALCITE-3589: --- So both MySQL and PostgreSQL group by the underlying column, and

[jira] [Comment Edited] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994158#comment-16994158 ] Jin Xing edited comment on CALCITE-3589 at 12/12/19 4:08 AM: - Run below

[jira] [Commented] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

[ https://issues.apache.org/jira/browse/CALCITE-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16994158#comment-16994158 ] Jin Xing commented on CALCITE-3589: --- Run below SQL in MySQL and PostgreSQL; {code:java} CREATE TABLE

[jira] [Created] (CALCITE-3588) Support more operators in Join condition when convert RelNode to SqlNode

Jin Xing created CALCITE-3588: - Summary: Support more operators in Join condition when convert RelNode to SqlNode Key: CALCITE-3588 URL: https://issues.apache.org/jira/browse/CALCITE-3588 Project:

[jira] [Closed] (CALCITE-3270) Close resources

[ https://issues.apache.org/jira/browse/CALCITE-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing closed CALCITE-3270. - Resolution: Invalid > Close resources > --- > > Key: CALCITE-3270 >

[jira] [Commented] (CALCITE-1640) SqlImplementor (RelToSql) doesn't handle join cond same as filter

[ https://issues.apache.org/jira/browse/CALCITE-1640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992463#comment-16992463 ] Jin Xing commented on CALCITE-1640: --- Resolved and duplicated to CALCITE-3207. > SqlImplementor

[jira] [Resolved] (CALCITE-1640) SqlImplementor (RelToSql) doesn't handle join cond same as filter

[ https://issues.apache.org/jira/browse/CALCITE-1640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing resolved CALCITE-1640. --- Resolution: Fixed > SqlImplementor (RelToSql) doesn't handle join cond same as filter >

[jira] [Commented] (CALCITE-3582) Make RelStructuredTypeFlattener configurable in PlannerImpl

[ https://issues.apache.org/jira/browse/CALCITE-3582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992279#comment-16992279 ] Jin Xing commented on CALCITE-3582: --- I'm curious that if we allow user to control field trimming and

[jira] [Comment Edited] (CALCITE-3488) Interpreter does not implement LogicalCorelate.

[ https://issues.apache.org/jira/browse/CALCITE-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992239#comment-16992239 ] Jin Xing edited comment on CALCITE-3488 at 12/10/19 6:52 AM: - [~zolyfarkas]

[jira] [Commented] (CALCITE-3488) Interpreter does not implement LogicalCorelate.

[ https://issues.apache.org/jira/browse/CALCITE-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992239#comment-16992239 ] Jin Xing commented on CALCITE-3488: --- [~zolyfarkas] The main functionality for decorrelation is in

[jira] [Commented] (CALCITE-3549) Lex config for view expanding is not supported

[ https://issues.apache.org/jira/browse/CALCITE-3549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1699#comment-1699 ] Jin Xing commented on CALCITE-3549: --- Julian ~ Sorry that I squashed the commits of PR#1641

[jira] [Comment Edited] (CALCITE-3549) Lex config for view expanding is not supported

[ https://issues.apache.org/jira/browse/CALCITE-3549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992215#comment-16992215 ] Jin Xing edited comment on CALCITE-3549 at 12/10/19 6:15 AM: - Thanks a lot

[jira] [Commented] (CALCITE-3549) Lex config for view expanding is not supported

[ https://issues.apache.org/jira/browse/CALCITE-3549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992219#comment-16992219 ] Jin Xing commented on CALCITE-3549: --- In current change of PR#1641, lex config are transformed between

[jira] [Commented] (CALCITE-3549) Lex config for view expanding is not supported

[ https://issues.apache.org/jira/browse/CALCITE-3549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16992215#comment-16992215 ] Jin Xing commented on CALCITE-3549: --- Thanks a lot for feedback ~ [~julianhyde] Yes, it seems lots of

[jira] [Commented] (CALCITE-3478) Restructure tests for materialized views

[ https://issues.apache.org/jira/browse/CALCITE-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16989326#comment-16989326 ] Jin Xing commented on CALCITE-3478: --- Thanks [~julianhyde] I updated the commit messag and Jira

[jira] [Comment Edited] (CALCITE-3478) Restructure tests for materialized views

[ https://issues.apache.org/jira/browse/CALCITE-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16989326#comment-16989326 ] Jin Xing edited comment on CALCITE-3478 at 12/6/19 2:21 AM: Thanks

[jira] [Commented] (CALCITE-3570) Support MutableSnapshot in MutableRel

[ https://issues.apache.org/jira/browse/CALCITE-3570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16988480#comment-16988480 ] Jin Xing commented on CALCITE-3570: --- Can you explain in what scenario MutableSnapshot is needed ?

[jira] [Commented] (CALCITE-3549) Lex config for view expanding is not supported

[ https://issues.apache.org/jira/browse/CALCITE-3549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16988477#comment-16988477 ] Jin Xing commented on CALCITE-3549: --- IIUC we should separate the lex when define a view and use a

[jira] [Updated] (CALCITE-3478) Restructure tests for materialized views

[ https://issues.apache.org/jira/browse/CALCITE-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3478: -- Summary: Restructure tests for materialized views (was: Reconstructure of materialized view tests.)

[jira] [Comment Edited] (CALCITE-3124) Infinite rule matching when AggregateRemoveRule is enabled for SUM0

[ https://issues.apache.org/jira/browse/CALCITE-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979110#comment-16979110 ] Jin Xing edited comment on CALCITE-3124 at 12/4/19 11:44 AM: - Sql in 

[jira] [Created] (CALCITE-3549) Lex config for view expanding is not supported

Jin Xing created CALCITE-3549: - Summary: Lex config for view expanding is not supported Key: CALCITE-3549 URL: https://issues.apache.org/jira/browse/CALCITE-3549 Project: Calcite Issue Type:

[jira] [Comment Edited] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

[ https://issues.apache.org/jira/browse/CALCITE-3535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985079#comment-16985079 ] Jin Xing edited comment on CALCITE-3535 at 11/29/19 3:46 PM: - I have an

[jira] [Comment Edited] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

[ https://issues.apache.org/jira/browse/CALCITE-3535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985079#comment-16985079 ] Jin Xing edited comment on CALCITE-3535 at 11/29/19 3:46 PM: - I have an

[jira] [Comment Edited] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

[ https://issues.apache.org/jira/browse/CALCITE-3535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985079#comment-16985079 ] Jin Xing edited comment on CALCITE-3535 at 11/29/19 3:44 PM: - I have an

[jira] [Commented] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

[ https://issues.apache.org/jira/browse/CALCITE-3535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985079#comment-16985079 ] Jin Xing commented on CALCITE-3535: --- I have an idea but not strongly related to this issue ~

[jira] [Commented] (CALCITE-3537) Can't apply materialized view with a simple filter

[ https://issues.apache.org/jira/browse/CALCITE-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984709#comment-16984709 ] Jin Xing commented on CALCITE-3537: --- [~xzh_dz] FYI ~ do you want to take a look at CASE-3 ? > Can't

[jira] [Closed] (CALCITE-3545) How to change calcite syntax

[ https://issues.apache.org/jira/browse/CALCITE-3545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing closed CALCITE-3545. - Resolution: Not A Problem > How to change calcite syntax > > >

[jira] [Commented] (CALCITE-3537) Can't apply materialized view with a simple filter

[ https://issues.apache.org/jira/browse/CALCITE-3537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983591#comment-16983591 ] Jin Xing commented on CALCITE-3537: --- Hi [~anha] Did you run your tests on

[jira] [Commented] (CALCITE-3521) CalciteSystemProperty can't load config file

[ https://issues.apache.org/jira/browse/CALCITE-3521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982191#comment-16982191 ] Jin Xing commented on CALCITE-3521: --- PR by [~hyuan] [https://github.com/apache/calcite/pull/1604] >

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3536: -- Description: Currently, COALESCE expression specified in sql string will be rewrite to CASE by

[jira] [Commented] (CALCITE-3536) Wrong semantics in CoalesceImplementor

[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982104#comment-16982104 ] Jin Xing commented on CALCITE-3536: --- Yes, I added in the description and proposed a PR to illustrate

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3536: -- Description: Currently, COALESCE expression specified in sql string will be rewrite to CASE by

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3536: -- Description: Currently, COALESCE expression specified in sql string will be rewrite to CASE by

[jira] [Created] (CALCITE-3536) Wrong semantics in CoalesceImplementor

Jin Xing created CALCITE-3536: - Summary: Wrong semantics in CoalesceImplementor Key: CALCITE-3536 URL: https://issues.apache.org/jira/browse/CALCITE-3536 Project: Calcite Issue Type: Bug

[jira] [Issue Comment Deleted] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3505: -- Comment: was deleted (was: Currently, Calcite checks whether to skip a rule match by [link|#L520]].

[jira] [Resolved] (CALCITE-3273) Materialization matching rules that consider compensating MutableProject

[ https://issues.apache.org/jira/browse/CALCITE-3273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing resolved CALCITE-3273. --- Resolution: Fixed > Materialization matching rules that consider compensating MutableProject >

[jira] [Reopened] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct on join keys

[ https://issues.apache.org/jira/browse/CALCITE-3431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing reopened CALCITE-3431: --- > SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct > on join keys >

[jira] [Closed] (CALCITE-3431) SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct on join keys

[ https://issues.apache.org/jira/browse/CALCITE-3431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing closed CALCITE-3431. - Resolution: Won't Fix > SemiJoinRule doesn't work when right-hand side is not Aggregate but distinct

[jira] [Comment Edited] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979934#comment-16979934 ] Jin Xing edited comment on CALCITE-3505 at 11/22/19 7:36 AM: - I strongly

[jira] [Comment Edited] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979934#comment-16979934 ] Jin Xing edited comment on CALCITE-3505 at 11/22/19 7:35 AM: - I strongly

[jira] [Commented] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979934#comment-16979934 ] Jin Xing commented on CALCITE-3505: --- I strongly think we should resolve the infinite rule matching

[jira] [Comment Edited] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979934#comment-16979934 ] Jin Xing edited comment on CALCITE-3505 at 11/22/19 7:34 AM: - I strongly

[jira] [Comment Edited] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979925#comment-16979925 ] Jin Xing edited comment on CALCITE-3505 at 11/22/19 7:18 AM: - Currently,

[jira] [Commented] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979925#comment-16979925 ] Jin Xing commented on CALCITE-3505: --- Currently, Calcite checks whether to skip a rule match by 

[jira] [Comment Edited] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979910#comment-16979910 ] Jin Xing edited comment on CALCITE-3505 at 11/22/19 6:51 AM: - [~hyuan] I

[jira] [Commented] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979910#comment-16979910 ] Jin Xing commented on CALCITE-3505: --- [~hyuan] I commented in CALCITE-3142 and gave my understanding

[jira] [Commented] (CALCITE-3124) Infinite rule matching when AggregateRemoveRule is enabled for SUM0

[ https://issues.apache.org/jira/browse/CALCITE-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979126#comment-16979126 ] Jin Xing commented on CALCITE-3124: --- If we look at the above process, we will find that there's no

[jira] [Comment Edited] (CALCITE-3124) Infinite rule matching when AggregateRemoveRule is enabled for SUM0

[ https://issues.apache.org/jira/browse/CALCITE-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979110#comment-16979110 ] Jin Xing edited comment on CALCITE-3124 at 11/21/19 9:17 AM: - Sql in 

[jira] [Comment Edited] (CALCITE-3124) Infinite rule matching when AggregateRemoveRule is enabled for SUM0

[ https://issues.apache.org/jira/browse/CALCITE-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979110#comment-16979110 ] Jin Xing edited comment on CALCITE-3124 at 11/21/19 9:17 AM: - Sql in 

[jira] [Comment Edited] (CALCITE-3124) Infinite rule matching when AggregateRemoveRule is enabled for SUM0

[ https://issues.apache.org/jira/browse/CALCITE-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979110#comment-16979110 ] Jin Xing edited comment on CALCITE-3124 at 11/21/19 9:09 AM: - Sql in 

[jira] [Commented] (CALCITE-3124) Infinite rule matching when AggregateRemoveRule is enabled for SUM0

[ https://issues.apache.org/jira/browse/CALCITE-3124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16979110#comment-16979110 ] Jin Xing commented on CALCITE-3124: --- Sql in testHavingNot2 and its corresponding plan are as below:  

[jira] [Commented] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16974336#comment-16974336 ] Jin Xing commented on CALCITE-3505: --- >From the graphviz.svg attachment, I found input-cycles as below

[jira] [Updated] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3505: -- Attachment: graphviz.svg > Infinite matching of FilterProjectTransposeRule causes stackoverflow >

[jira] [Updated] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3505: -- Description: Run ScannableTableTest#testProjectableFilterableTableJoin with minor change to

[jira] [Updated] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

[ https://issues.apache.org/jira/browse/CALCITE-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3505: -- Description: Run ScannableTableTest#testProjectableFilterableTableJoin with minor change to

[jira] [Created] (CALCITE-3505) Infinite matching of FilterProjectTransposeRule causes stackoverflow

Jin Xing created CALCITE-3505: - Summary: Infinite matching of FilterProjectTransposeRule causes stackoverflow Key: CALCITE-3505 URL: https://issues.apache.org/jira/browse/CALCITE-3505 Project: Calcite

[jira] [Commented] (CALCITE-3497) Calcite TimestampString should provide getNanosInSecond interface

[ https://issues.apache.org/jira/browse/CALCITE-3497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16973040#comment-16973040 ] Jin Xing commented on CALCITE-3497: --- When do we need this function ? > Calcite TimestampString

[jira] [Assigned] (CALCITE-3285) EnumerableMergeJoin should support non-equi join conditions

[ https://issues.apache.org/jira/browse/CALCITE-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing reassigned CALCITE-3285: - Assignee: Jin Xing > EnumerableMergeJoin should support non-equi join conditions >

[jira] [Commented] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16972314#comment-16972314 ] Jin Xing commented on CALCITE-3495: --- By nested loop join, when deptno=0 in dept, it will generate a

[jira] [Updated] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3495: -- Description: Given below Sql and data {code:java} SELECT deptno FROM dept A where deptno in

[jira] [Created] (CALCITE-3495) RelDecorrelator generate plan with different semantics when handle Aggregate

Jin Xing created CALCITE-3495: - Summary: RelDecorrelator generate plan with different semantics when handle Aggregate Key: CALCITE-3495 URL: https://issues.apache.org/jira/browse/CALCITE-3495 Project:

[jira] [Commented] (CALCITE-3488) Interpreter does not implement LogicalCorelate.

[ https://issues.apache.org/jira/browse/CALCITE-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16970716#comment-16970716 ] Jin Xing commented on CALCITE-3488: --- Currently RelDecorrelator doesn't support a

[jira] [Updated] (CALCITE-3478) Reconstructure of materialized view tests.

[ https://issues.apache.org/jira/browse/CALCITE-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3478: -- Description: h2. *Motivation* Currently there are two strategies for materialized view matching:

[jira] [Updated] (CALCITE-3478) Reconstructure of materialized view tests.

[ https://issues.apache.org/jira/browse/CALCITE-3478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3478: -- Description: h2. *Motivation* Currently there are two strategies for materialized view matching:

[jira] [Created] (CALCITE-3478) Reconstructure of materialized view tests.

Jin Xing created CALCITE-3478: - Summary: Reconstructure of materialized view tests. Key: CALCITE-3478 URL: https://issues.apache.org/jira/browse/CALCITE-3478 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-3469) Fix typo in SubstitutionVisitor#rowTypesAreEquivalent

[ https://issues.apache.org/jira/browse/CALCITE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964681#comment-16964681 ] Jin Xing commented on CALCITE-3469: --- BTW, we don't need to include 'Fix' in the Jira title. > Fix

[jira] [Commented] (CALCITE-3469) Fix typo in SubstitutionVisitor#rowTypesAreEquivalent

[ https://issues.apache.org/jira/browse/CALCITE-3469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964679#comment-16964679 ] Jin Xing commented on CALCITE-3469: --- +1 and sorry for my mistake in CALCITE-3113 > Fix typo in

[jira] [Resolved] (CALCITE-3276) Add MV rules to match Join on compensating Project(s)

[ https://issues.apache.org/jira/browse/CALCITE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing resolved CALCITE-3276. --- Resolution: Duplicate > Add MV rules to match Join on compensating Project(s) >

[jira] [Resolved] (CALCITE-3203) When matching materializations, match Project with child of Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-3203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing resolved CALCITE-3203. --- Resolution: Duplicate > When matching materializations, match Project with child of Aggregate >

[jira] [Resolved] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing resolved CALCITE-3256. --- Resolution: Duplicate > Add ProjectOnProjectToProjectUnifyRule for materialization matching. >

[jira] [Resolved] (CALCITE-3274) Add FilterOnProjectToFilterUnifyRule for materialization matching

[ https://issues.apache.org/jira/browse/CALCITE-3274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing resolved CALCITE-3274. --- Resolution: Duplicate > Add FilterOnProjectToFilterUnifyRule for materialization matching >

[jira] [Commented] (CALCITE-3256) Add ProjectOnProjectToProjectUnifyRule for materialization matching.

[ https://issues.apache.org/jira/browse/CALCITE-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16964677#comment-16964677 ] Jin Xing commented on CALCITE-3256: --- Duplicate with CALCITE-3334, close it. > Add

[jira] [Updated] (CALCITE-3448) AggregateOnCalcToAggregateUnifyRule ignores Project incorrectly when there's missing grouping or mapping breaks ordering

[ https://issues.apache.org/jira/browse/CALCITE-3448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3448: -- Summary: AggregateOnCalcToAggregateUnifyRule ignores Project incorrectly when there's missing

[jira] [Commented] (CALCITE-3455) Redundant rule firing for both logical and physical nodes

[ https://issues.apache.org/jira/browse/CALCITE-3455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16962648#comment-16962648 ] jin xing commented on CALCITE-3455: --- +1 for this Jira and I think there are lots of rules only need

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16962014#comment-16962014 ] jin xing commented on CALCITE-2970: --- [~xndai] Thanks a lot for your kind help ~ Your commit is

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16962007#comment-16962007 ] jin xing commented on CALCITE-2970: --- [~zabetak] [~hyuan] Thanks a lot for your shepherd and sorry for

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961995#comment-16961995 ] jin xing commented on CALCITE-2970: --- I migrate my PR description from github as below:   Currently 

[jira] [Updated] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-2970: -- Description: If we enable the use of abstract converter for {{EnumerableConvention}}, by making

[jira] [Commented] (CALCITE-3447) Fix equivalents in method SubstitutionVisitor#go

[ https://issues.apache.org/jira/browse/CALCITE-3447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16960848#comment-16960848 ] jin xing commented on CALCITE-3447: --- Though this bug is bypassed, but +1 to fix. > Fix equivalents

[jira] [Updated] (CALCITE-3448) AggregateOnProjectToAggregateUnifyRule ignores Project incorrectly when there's missing grouping or mapping breaks ordering

[ https://issues.apache.org/jira/browse/CALCITE-3448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jin xing updated CALCITE-3448: -- Description: CALCITE-3087 fixed AggregateOnProjectToAggregateUnifyRule when mapping under Aggregate

[jira] [Created] (CALCITE-3448) AggregateOnProjectToAggregateUnifyRule ignores Project incorrectly when there's missing grouping or mapping breaks ordering

jin xing created CALCITE-3448: - Summary: AggregateOnProjectToAggregateUnifyRule ignores Project incorrectly when there's missing grouping or mapping breaks ordering Key: CALCITE-3448 URL:

[jira] [Commented] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16958477#comment-16958477 ] jin xing commented on CALCITE-3428: --- Thanks a lot for merging ! > Refine RelMdColumnUniqueness for

[jira] [Created] (CALCITE-3439) Support Intersect and Minus in RelMdPredicates

jin xing created CALCITE-3439: - Summary: Support Intersect and Minus in RelMdPredicates Key: CALCITE-3439 URL: https://issues.apache.org/jira/browse/CALCITE-3439 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16956792#comment-16956792 ] jin xing commented on CALCITE-3428: --- Sorry [~julianhyde] ~ I will be careful next time and will not

[jira] [Comment Edited] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16955719#comment-16955719 ] jin xing edited comment on CALCITE-3428 at 10/21/19 2:23 PM: - Thanks a lot

[jira] [Commented] (CALCITE-3428) Refine RelMdColumnUniqueness for Filter by considering constant columns

[ https://issues.apache.org/jira/browse/CALCITE-3428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16955719#comment-16955719 ] jin xing commented on CALCITE-3428: --- Thanks a lot [~julianhyde] ~ I will refine the PR by your

<    1   2   3   4   >