[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-28 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16917529#comment-16917529 ] Volodymyr Vysotskyi commented on CALCITE-3244: -- [~danny0405], currently I don't have any

[jira] [Comment Edited] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-27 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916763#comment-16916763 ] Volodymyr Vysotskyi edited comment on CALCITE-3244 at 8/27/19 2:45 PM:

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-27 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916763#comment-16916763 ] Volodymyr Vysotskyi commented on CALCITE-3244: -- I have checked your branch, and the

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-27 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16916743#comment-16916743 ] Volodymyr Vysotskyi commented on CALCITE-3244: -- I have also worked on this issue, here is

[jira] [Resolved] (CALCITE-3138) RelStructuredTypeFlattener doesn't restructure ROW type fields

2019-08-21 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-3138. -- Resolution: Fixed Fixed in

[jira] [Comment Edited] (CALCITE-2166) Cumulative cost of RelSubset.best RelNode is increased after calling RelSubset.propagateCostImprovements() for input RelNodes

2019-08-21 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912124#comment-16912124 ] Volodymyr Vysotskyi edited comment on CALCITE-2166 at 8/21/19 11:58 AM:

[jira] [Commented] (CALCITE-2166) Cumulative cost of RelSubset.best RelNode is increased after calling RelSubset.propagateCostImprovements() for input RelNodes

2019-08-21 Thread Volodymyr Vysotskyi (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16912124#comment-16912124 ] Volodymyr Vysotskyi commented on CALCITE-2166: -- Thanks, Xiening Dai, for moving this issue

[jira] [Commented] (CALCITE-3257) Need to clear RelMetaDataQuery cache after dumping RelNodes and Graphviz

2019-08-16 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16909448#comment-16909448 ] Volodymyr Vysotskyi commented on CALCITE-3257: -- I don't know the exact reason for adding

[jira] [Commented] (CALCITE-3257) Need to clear RelMetaDataQuery cache after dumping RelNodes and Graphviz

2019-08-16 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16909375#comment-16909375 ] Volodymyr Vysotskyi commented on CALCITE-3257: -- I don't think that adding a call to

[jira] [Updated] (CALCITE-3138) Restructuring ROW type fields is not supported

2019-08-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-3138: - Fix Version/s: 1.21.0 > Restructuring ROW type fields is not supported >

[jira] [Commented] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907182#comment-16907182 ] Volodymyr Vysotskyi commented on CALCITE-3244: -- [~julianhyde], your assumption about DAG

[jira] [Commented] (CALCITE-3115) Cannot add JdbcRules which have different JdbcConvention to same VolcanoPlanner's RuleSet.

2019-08-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16907165#comment-16907165 ] Volodymyr Vysotskyi commented on CALCITE-3115: -- Other projects including Drill also faced

[jira] [Updated] (CALCITE-3115) Cannot add JdbcRules which have different JdbcConvention to same VolcanoPlanner's RuleSet.

2019-08-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-3115: - Fix Version/s: 1.21.0 > Cannot add JdbcRules which have different

[jira] [Updated] (CALCITE-3244) RelDecorrelator unable to decorrelate expression with filter and aggregate on top

2019-08-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-3244: - Summary: RelDecorrelator unable to decorrelate expression with filter and

[jira] [Comment Edited] (CALCITE-3244) Decorrelating sub-queries - Adding Implicit RowID support

2019-08-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906038#comment-16906038 ] Volodymyr Vysotskyi edited comment on CALCITE-3244 at 8/13/19 10:22 AM:

[jira] [Commented] (CALCITE-3244) Decorrelating sub-queries - Adding Implicit RowID support

2019-08-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906038#comment-16906038 ] Volodymyr Vysotskyi commented on CALCITE-3244: -- Thanks, [~benj641] for reporting this

[jira] [Comment Edited] (CALCITE-3244) Decorrelating sub-queries - Adding Implicit RowID support

2019-08-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16906038#comment-16906038 ] Volodymyr Vysotskyi edited comment on CALCITE-3244 at 8/13/19 10:10 AM:

[jira] [Commented] (CALCITE-3121) VolcanoPlanner hangs due to removing ORDER BY from sub-query

2019-06-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16863367#comment-16863367 ] Volodymyr Vysotskyi commented on CALCITE-3121: -- [~julianhyde], can I merge this PR to

[jira] [Commented] (CALCITE-3121) VolcanoPlanner hangs due to removing ORDER BY from sub-query

2019-06-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16861962#comment-16861962 ] Volodymyr Vysotskyi commented on CALCITE-3121: -- The aim of CALCITE-2798 was to optimize

[jira] [Commented] (CALCITE-3121) VolcanoPlanner hangs due to removing ORDER BY from sub-query

2019-06-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16861249#comment-16861249 ] Volodymyr Vysotskyi commented on CALCITE-3121: -- If there are no objections, I'll merge the

[jira] [Commented] (CALCITE-3117) Distinguish Calcite's public APIs

2019-06-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16859458#comment-16859458 ] Volodymyr Vysotskyi commented on CALCITE-3117: -- Hi all, here is the list of some Calcite

[jira] [Resolved] (CALCITE-3061) Query with WITH clause fails when alias is the same as the table with rolled up column

2019-05-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-3061. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-3061) Query with WITH clause fails when alias is the same as the table with rolled up column

2019-05-12 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16838043#comment-16838043 ] Volodymyr Vysotskyi commented on CALCITE-3061: -- Thanks for the review, I have made

[jira] [Commented] (CALCITE-3061) Query with WITH clause fails when alias is the same as the table with rolled up column

2019-05-10 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16837452#comment-16837452 ] Volodymyr Vysotskyi commented on CALCITE-3061: -- I have created PR with the fix:

[jira] [Created] (CALCITE-3061) Query with WITH clause fails when alias is the same as the table with rolled up column

2019-05-10 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-3061: Summary: Query with WITH clause fails when alias is the same as the table with rolled up column Key: CALCITE-3061 URL:

[jira] [Updated] (CALCITE-3055) TableScan type mismatch in VolcanoPlanner

2019-05-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-3055: - Fix Version/s: 1.20.0 > TableScan type mismatch in VolcanoPlanner >

[jira] [Updated] (CALCITE-3055) TableScan type mismatch in VolcanoPlanner

2019-05-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-3055: - Priority: Blocker (was: Major) > TableScan type mismatch in VolcanoPlanner >

[jira] [Commented] (CALCITE-3055) TableScan type mismatch in VolcanoPlanner

2019-05-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-3055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16836665#comment-16836665 ] Volodymyr Vysotskyi commented on CALCITE-3055: -- [~KazydubB], I was able to reproduce this

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for in subquery with non-equi condition

2019-04-17 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16819972#comment-16819972 ] Volodymyr Vysotskyi commented on CALCITE-2948: -- [~danny0405], the aggregation for these

[jira] [Commented] (CALCITE-2018) Queries failed with AssertionError: rel has lower cost than best cost of subset

2019-04-16 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818872#comment-16818872 ] Volodymyr Vysotskyi commented on CALCITE-2018: -- [~danny0405], thanks for moving this issue

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-02-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16759377#comment-16759377 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- Yes, that's correct that usual cartesian

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-02-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16759024#comment-16759024 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- If I understand the intention of PR-1019

[jira] [Commented] (CALCITE-2329) Enhance SubQueryRemoveRule to rewrite IN operator with the constant from the left side more optimally

2019-01-30 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16756664#comment-16756664 ] Volodymyr Vysotskyi commented on CALCITE-2329: -- [~vgarg], I agree with you that such plan

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-28 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753953#comment-16753953 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- I see you have enabled

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-28 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753889#comment-16753889 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- Perhaps rough, but should be a working

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753391#comment-16753391 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- Yes, that's correct, ignored

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753370#comment-16753370 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- These failures aren't expected. Do these

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-26 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16753049#comment-16753049 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- [~vladimirsitnikov] , thanks a lot for

[jira] [Comment Edited] (CALCITE-2799) Allow alias in having clause for aggregate functions

2019-01-24 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16750961#comment-16750961 ] Volodymyr Vysotskyi edited comment on CALCITE-2799 at 1/24/19 10:03 AM:

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

2019-01-24 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16750961#comment-16750961 ] Volodymyr Vysotskyi commented on CALCITE-2799: -- So since aliases priority is another

[jira] [Commented] (CALCITE-2799) Allow alias in having clause for aggregate functions

2019-01-23 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16750547#comment-16750547 ] Volodymyr Vysotskyi commented on CALCITE-2799: -- I agree with [~vladimirsitnikov] that the

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-20 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16747562#comment-16747562 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- [~vladimirsitnikov], to reproduce this

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2019-01-08 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16737141#comment-16737141 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- [~vladimirsitnikov], sorry, I thought that

[jira] [Resolved] (CALCITE-2463) Silence ERROR logs from CalciteException, SqlValidatorException

2018-12-24 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2463. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-2463) Silence ERROR logs from CalciteException, SqlValidatorException

2018-12-19 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2463: - Fix Version/s: 1.19.0 > Silence ERROR logs from CalciteException,

[jira] [Commented] (CALCITE-2463) Silence ERROR logs from CalciteException, SqlValidatorException

2018-12-19 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16725009#comment-16725009 ] Volodymyr Vysotskyi commented on CALCITE-2463: -- +1. Good improvement, I will merge it

[jira] [Comment Edited] (CALCITE-2745) RexSimplify fails with ClassCastException when the expression contains comparisons of operands with different types

2018-12-17 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16723361#comment-16723361 ] Volodymyr Vysotskyi edited comment on CALCITE-2745 at 12/17/18 9:11 PM:

[jira] [Commented] (CALCITE-2745) RexSimplify fails with ClassCastException when the expression contains comparisons of operands with different types

2018-12-17 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16723361#comment-16723361 ] Volodymyr Vysotskyi commented on CALCITE-2745: -- Thanks for looking into this. I agree that

[jira] [Comment Edited] (CALCITE-2745) RexSimplify fails with ClassCastException when the expression contains comparisons of operands with different types

2018-12-17 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16723226#comment-16723226 ] Volodymyr Vysotskyi edited comment on CALCITE-2745 at 12/17/18 6:23 PM:

[jira] [Commented] (CALCITE-2745) RexSimplify fails with ClassCastException when the expression contains comparisons of operands with different types

2018-12-17 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16723226#comment-16723226 ] Volodymyr Vysotskyi commented on CALCITE-2745: -- Similar problem, but with another method 

[jira] [Created] (CALCITE-2745) RexSimplify fails with ClassCastException when the expression contains comparisons of operands with different types

2018-12-17 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-2745: Summary: RexSimplify fails with ClassCastException when the expression contains comparisons of operands with different types Key: CALCITE-2745 URL:

[jira] [Commented] (CALCITE-2507) Aliasing a star in select list should throw a parsing error.

2018-10-28 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1586#comment-1586 ] Volodymyr Vysotskyi commented on CALCITE-2507: -- [~michaelmior], it was just an example of

[jira] [Resolved] (CALCITE-2158) SubQuery with EXISTS clause creates redundant aggregate call

2018-10-25 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2158. -- Resolution: Won't Fix Fix Version/s: 1.18.0 > SubQuery with EXISTS

[jira] [Updated] (CALCITE-2639) FilterReduceExpressionsRule causes ArithmeticException at execution time

2018-10-24 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2639: - Priority: Blocker (was: Major) > FilterReduceExpressionsRule causes

[jira] [Commented] (CALCITE-2639) FilterReduceExpressionsRule causes ArithmeticException at execution time

2018-10-24 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16662060#comment-16662060 ] Volodymyr Vysotskyi commented on CALCITE-2639: -- [~kgyrtkirk], since this bug was caused by

[jira] [Commented] (CALCITE-2507) Aliasing a star in select list should throw a parsing error.

2018-09-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16630295#comment-16630295 ] Volodymyr Vysotskyi commented on CALCITE-2507: -- This PR does not handle a case when column

[jira] [Comment Edited] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2018-09-23 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625226#comment-16625226 ] Volodymyr Vysotskyi edited comment on CALCITE-2223 at 9/23/18 7:49 PM:

[jira] [Commented] (CALCITE-2223) ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule

2018-09-23 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16625226#comment-16625226 ] Volodymyr Vysotskyi commented on CALCITE-2223: -- [~vladimirsitnikov], thanks for looking

[jira] [Resolved] (CALCITE-2514) Add SqlIdentifier conversion to ITEM operator for dynamic tables in ExtendedExpander

2018-09-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2514. -- Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-2497) Update Janino version to 3.0.9

2018-08-28 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2497. -- Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-2497) Update Janino version to 3.0.9

2018-08-28 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-2497: Summary: Update Janino version to 3.0.9 Key: CALCITE-2497 URL: https://issues.apache.org/jira/browse/CALCITE-2497 Project: Calcite Issue

[jira] [Comment Edited] (CALCITE-2470) RelBuilder.project should combine expressions if underlying node is a Project

2018-08-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16594236#comment-16594236 ] Volodymyr Vysotskyi edited comment on CALCITE-2470 at 8/27/18 9:26 PM:

[jira] [Commented] (CALCITE-2470) RelBuilder.project should combine expressions if underlying node is a Project

2018-08-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16594236#comment-16594236 ] Volodymyr Vysotskyi commented on CALCITE-2470: -- It would be good to add an ability somehow

[jira] [Commented] (CALCITE-2470) RelBuilder.project should combine expressions if underlying node is a Project

2018-08-27 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16593732#comment-16593732 ] Volodymyr Vysotskyi commented on CALCITE-2470: -- [~julianhyde], thanks for pointing to

[jira] [Commented] (CALCITE-2440) SQL with UNNEST fail in volcano planner in some cases

2018-08-20 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16585616#comment-16585616 ] Volodymyr Vysotskyi commented on CALCITE-2440: -- I think the problem is that one of the

[jira] [Commented] (CALCITE-2440) SQL with UNNEST fail in volcano planner in some cases

2018-08-18 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16584750#comment-16584750 ] Volodymyr Vysotskyi commented on CALCITE-2440: -- [~suez1224], thanks for the clarification.

[jira] [Commented] (CALCITE-2455) simplifyCoalesce of constant should match nullability

2018-08-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16574560#comment-16574560 ] Volodymyr Vysotskyi commented on CALCITE-2455: -- Thanks for the explanation. >

[jira] [Commented] (CALCITE-2455) simplifyCoalesce of constant should match nullability

2018-08-09 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16574369#comment-16574369 ] Volodymyr Vysotskyi commented on CALCITE-2455: -- [~danny0405], I'm wondering why initially

[jira] [Commented] (CALCITE-2440) SQL with UNNEST fail in volcano planner in some cases

2018-08-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16567657#comment-16567657 ] Volodymyr Vysotskyi commented on CALCITE-2440: -- [~suez1224], the line of code you have

[jira] [Resolved] (CALCITE-2422) Query with unnest of column from nested subquery fails when dynamic table is used

2018-07-30 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2422. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-2422) Query with unnest of column from nested subquery fails when dynamic table is used

2018-07-26 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16558486#comment-16558486 ] Volodymyr Vysotskyi commented on CALCITE-2422: -- I have created PR with the fix for this

[jira] [Updated] (CALCITE-2422) Query with unnest of column from nested subquery fails when dynamic table is used

2018-07-26 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2422: - Fix Version/s: 1.18.0 > Query with unnest of column from nested subquery fails

[jira] [Created] (CALCITE-2422) Query with unnest of column from nested subquery fails when dynamic table is used

2018-07-20 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-2422: Summary: Query with unnest of column from nested subquery fails when dynamic table is used Key: CALCITE-2422 URL:

[jira] [Closed] (CALCITE-2337) Release Calcite 1.17.0

2018-07-20 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi closed CALCITE-2337. Resolved in release 1.17.0 (2018-07-20) > Release Calcite 1.17.0 >

[jira] [Resolved] (CALCITE-2337) Release Calcite 1.17.0

2018-07-20 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2337. -- Resolution: Done > Release Calcite 1.17.0 > -- > >

[jira] [Resolved] (CALCITE-2331) Evaluation of predicate "(A or B) and C" fails for Elasticsearch adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2331. -- Resolution: Fixed > Evaluation of predicate "(A or B) and C" fails for

[jira] [Commented] (CALCITE-2331) Evaluation of predicate "(A or B) and C" fails for Elasticsearch adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16544526#comment-16544526 ] Volodymyr Vysotskyi commented on CALCITE-2331: -- I have split this Jira into two parts to

[jira] [Updated] (CALCITE-2331) Evaluation of predicate "(A or B) and C" fails for Elasticsearch adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2331: - Fix Version/s: 1.17.0 > Evaluation of predicate "(A or B) and C" fails for

[jira] [Updated] (CALCITE-2331) Evaluation of predicate "(A or B) and C" fails for Elasticsearch adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2331: - Description: h2. Queries that are working {code:java} select count(*) from

[jira] [Updated] (CALCITE-2331) Evaluation of predicate "(A or B) and C" fails for Elasticsearch adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2331: - Summary: Evaluation of predicate "(A or B) and C" fails for Elasticsearch

[jira] [Updated] (CALCITE-2331) Evaluation of predicate "(A or B) and C" fails for Elasticsearch adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2331: - Component/s: (was: mongodb) (was: geode) > Evaluation

[jira] [Updated] (CALCITE-2415) Evaluation of predicate "(A or B) and C" fails for MongoDB adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2415: - Summary: Evaluation of predicate "(A or B) and C" fails for MongoDB adapter

[jira] [Updated] (CALCITE-2415) Evaluation of predicate "(A or B) and C" is failing for MongoDB adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2415: - Component/s: (was: geode) (was: elasticsearch-adapter)

[jira] [Updated] (CALCITE-2415) Evaluation of predicate "(A or B) and C" is failing for MongoDB adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2415: - Description: h2. Queries that are working {code:java} select count(*) from

[jira] [Created] (CALCITE-2415) Evaluation of predicate "(A or B) and C" is failing for MongoDB adapter

2018-07-15 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-2415: Summary: Evaluation of predicate "(A or B) and C" is failing for MongoDB adapter Key: CALCITE-2415 URL: https://issues.apache.org/jira/browse/CALCITE-2415

[jira] [Updated] (CALCITE-2410) Enable ProjectSetOpTransposeRule for UNION (distinct) SetOp operator

2018-07-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2410: - Fix Version/s: 1.17.0 > Enable ProjectSetOpTransposeRule for UNION (distinct)

[jira] [Updated] (CALCITE-2409) SparkAdapterTest fails on Windows when '/tmp' directory does not exist

2018-07-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2409: - Summary: SparkAdapterTest fails on Windows when '/tmp' directory does not

[jira] [Resolved] (CALCITE-2409) SparkAdapterTest fails on Windows

2018-07-14 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2409. -- Resolution: Fixed Fix Version/s: 1.17.0 Thanks, [~Sergey Nuyanzin],

[jira] [Resolved] (CALCITE-2366) Add support for ANY_VALUE function

2018-07-13 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2366. -- Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-2366) Add support for ANY_VALUE function

2018-07-11 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16539747#comment-16539747 ] Volodymyr Vysotskyi commented on CALCITE-2366: -- [~julianhyde], [~amansinha100], since

[jira] [Resolved] (CALCITE-2342) use of assert with side-effect in Schemas

2018-07-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2342. -- Resolution: Fixed Fixed in 

[jira] [Updated] (CALCITE-2342) use of assert with side-effect in Schemas

2018-07-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2342: - Fix Version/s: 1.17.0 > use of assert with side-effect in Schemas >

[jira] [Resolved] (CALCITE-2255) Test against JDK 11

2018-07-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2255. -- Resolution: Fixed Resolving this Jira since both PRs were merged into

[jira] [Updated] (CALCITE-2392) Query with JOIN and USING on dynamic table fails with IndexOutOfBoundsException

2018-07-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi updated CALCITE-2392: - Fix Version/s: 1.17.0 > Query with JOIN and USING on dynamic table fails with

[jira] [Resolved] (CALCITE-2392) Query with JOIN and USING on dynamic table fails with IndexOutOfBoundsException

2018-07-05 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2392. -- Resolution: Fixed [~julianhyde], thanks for the review! Fixed in

[jira] [Commented] (CALCITE-2392) Query with JOIN and USING on dynamic table fails with IndexOutOfBoundsException

2018-07-04 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16532665#comment-16532665 ] Volodymyr Vysotskyi commented on CALCITE-2392: -- I have created CALCITE-2400 to fix and

[jira] [Created] (CALCITE-2400) Allow standards-compliant column ordering for NATURAL JOIN and JOIN USING when dynamic tables are used

2018-07-04 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-2400: Summary: Allow standards-compliant column ordering for NATURAL JOIN and JOIN USING when dynamic tables are used Key: CALCITE-2400 URL:

[jira] [Commented] (CALCITE-2392) Query with JOIN and USING on dynamic table fails with IndexOutOfBoundsException

2018-07-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16531668#comment-16531668 ] Volodymyr Vysotskyi commented on CALCITE-2392: -- Agree, it is complex to implement it for

[jira] [Commented] (CALCITE-2392) Query with JOIN and USING on dynamic table fails with IndexOutOfBoundsException

2018-07-03 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16531613#comment-16531613 ] Volodymyr Vysotskyi commented on CALCITE-2392: -- I have analyzed the problem and it is a

[jira] [Resolved] (CALCITE-2379) CVSS dependency-check-maven fails for calcite-spark module

2018-07-02 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Volodymyr Vysotskyi resolved CALCITE-2379. -- Resolution: Fixed Fixed in

  1   2   3   >