[jira] [Commented] (CALCITE-4419) Posix regex operators cannot be used within RelBuilder

2020-12-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17241424#comment-17241424 ] Ruben Q L commented on CALCITE-4419: [~julianhyde] if you have some time, could you please take a

[jira] [Comment Edited] (CALCITE-4419) Posix regex operators cannot be used within RelBuilder

2020-12-02 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4419?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17242208#comment-17242208 ] Ruben Q L edited comment on CALCITE-4419 at 12/2/20, 2:25 PM: -- Thanks

[jira] [Commented] (CALCITE-4437) The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate

2020-12-14 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17248974#comment-17248974 ] Ruben Q L commented on CALCITE-4437: Thanks for explanation [~thomas.rebele]. When you have some

[jira] [Commented] (CALCITE-4432) When the RelNode's input is the same subset as the node belonged to, not choose this node as best.

2020-12-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17251031#comment-17251031 ] Ruben Q L commented on CALCITE-4432: [~Ziwei Liu], [~FatLittle] could you provide more info on this

[jira] [Commented] (CALCITE-4333) The Sort rel should be decorrelated even though it has fetch or limit when its parent is not a Correlate

2020-12-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17248015#comment-17248015 ] Ruben Q L commented on CALCITE-4333: [~danny0405] unfortunately, the proposed fix is insufficient,

[jira] [Comment Edited] (CALCITE-4333) The Sort rel should be decorrelated even though it has fetch or limit when its parent is not a Correlate

2020-12-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17248015#comment-17248015 ] Ruben Q L edited comment on CALCITE-4333 at 12/11/20, 4:30 PM: ---

[jira] [Comment Edited] (CALCITE-4333) The Sort rel should be decorrelated even though it has fetch or limit when its parent is not a Correlate

2020-12-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17248015#comment-17248015 ] Ruben Q L edited comment on CALCITE-4333 at 12/11/20, 4:33 PM: ---

[jira] [Comment Edited] (CALCITE-4333) The Sort rel should be decorrelated even though it has fetch or limit when its parent is not a Correlate

2020-12-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17248015#comment-17248015 ] Ruben Q L edited comment on CALCITE-4333 at 12/11/20, 4:33 PM: ---

[jira] [Commented] (CALCITE-4432) When the RelNode's input is the same subset as the node belonged to, not choose this node as best.

2020-12-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17254136#comment-17254136 ] Ruben Q L commented on CALCITE-4432: UPDATE: finally I discovered the root cause of my

[jira] [Updated] (CALCITE-4437) The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate

2020-12-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4437: --- Description: The fix applied for CALCITE-4206 was "too drastic" and it resulted in Sort with

[jira] [Commented] (CALCITE-4264) The query planner should take CPU cost into account

2020-12-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17250343#comment-17250343 ] Ruben Q L commented on CALCITE-4264: I agree with you [~vladimirsitnikov]. From my point of view

[jira] [Commented] (CALCITE-4264) The query planner should take CPU cost into account

2020-12-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17250309#comment-17250309 ] Ruben Q L commented on CALCITE-4264: Not necessarily [~vladimirsitnikov]. This change just

[jira] [Created] (CALCITE-4437) The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate

2020-12-11 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4437: -- Summary: The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate Key: CALCITE-4437 URL:

[jira] [Updated] (CALCITE-4437) The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate

2020-12-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4437: --- Description: The fix applied for CALCITE-4206 was "too drastic" and it resulted in Sort with

[jira] [Commented] (CALCITE-4333) The Sort rel should be decorrelated even though it has fetch or limit when its parent is not a Correlate

2020-12-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17248134#comment-17248134 ] Ruben Q L commented on CALCITE-4333: Thanks for the feedback [~julianhyde]. The example that I

[jira] [Created] (CALCITE-4393) ExceptionInInitializerError due to NPE in SqlCallBinding caused by circular dependency

2020-11-11 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4393: -- Summary: ExceptionInInitializerError due to NPE in SqlCallBinding caused by circular dependency Key: CALCITE-4393 URL: https://issues.apache.org/jira/browse/CALCITE-4393

[jira] [Updated] (CALCITE-4393) ExceptionInInitializerError due to NPE in SqlCallBinding caused by circular dependency

2020-11-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4393: --- Description: See discussion here:

[jira] [Updated] (CALCITE-4393) ExceptionInInitializerError due to NPE in SqlCallBinding caused by circular dependency

2020-11-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4393: --- Description: See discussion here:

[jira] [Updated] (CALCITE-4393) ExceptionInInitializerError due to NPE in SqlCallBinding caused by circular dependency

2020-11-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4393: --- Description: See discussion here:

[jira] [Commented] (CALCITE-4393) ExceptionInInitializerError due to NPE in SqlCallBinding caused by circular dependency

2020-11-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17229998#comment-17229998 ] Ruben Q L commented on CALCITE-4393: {code:title=1) RexToLixTranslator.java} /*90*/ public class

[jira] [Commented] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

2020-11-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17231237#comment-17231237 ] Ruben Q L commented on CALCITE-4364: Thanks [~danny0405] > Simplify "a IN (1, 2) AND a = 1" to "a

[jira] [Created] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4414: -- Summary: RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references Key: CALCITE-4414 URL: https://issues.apache.org/jira/browse/CALCITE-4414

[jira] [Updated] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4414: --- Description: {{RelMdSelectivity#getSelectivity(Calc rel, RelMetadataQuery mq, RexNode

[jira] [Updated] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4414: --- Description: {{RelMdSelectivity#getSelectivity(Calc rel, RelMetadataQuery mq, RexNode

[jira] [Comment Edited] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236176#comment-17236176 ] Ruben Q L edited comment on CALCITE-4414 at 11/20/20, 2:16 PM: --- Test:

[jira] [Updated] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4414: --- Description: {{RelMdSelectivity#getSelectivity(Calc rel, RelMetadataQuery mq, RexNode

[jira] [Updated] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4414: --- Description: {{RelMdSelectivity#getSelectivity(Calc rel, RelMetadataQuery mq, RexNode

[jira] [Commented] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236176#comment-17236176 ] Ruben Q L commented on CALCITE-4414: Test: {code} @Test void test() { final RelBuilder

[jira] [Comment Edited] (CALCITE-4414) RelMdSelectivity#getSelectivity for Calc can propagate a predicate with wrong references

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236176#comment-17236176 ] Ruben Q L edited comment on CALCITE-4414 at 11/20/20, 3:26 PM: --- Test:

[jira] [Updated] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4415: --- Description: {{SqlStdOperatorTable.NOT_LIKE}}'s implementor defined in {{RexImpTable}} is

[jira] [Created] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-20 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4415: -- Summary: SqlStdOperatorTable.NOT_LIKE has a wrong implementor Key: CALCITE-4415 URL: https://issues.apache.org/jira/browse/CALCITE-4415 Project: Calcite Issue

[jira] [Assigned] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4415: -- Assignee: Ruben Q L > SqlStdOperatorTable.NOT_LIKE has a wrong implementor >

[jira] [Updated] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-20 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4415: --- Description: {{SqlStdOperatorTable.NOT_LIKE}}'s implementor defined in {{RexImpTable}} is

[jira] [Resolved] (CALCITE-4402) The equalsDeep of SqlCall returns wrong result

2020-11-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4402. Fix Version/s: 1.27.0 Resolution: Fixed Fixed via

[jira] [Created] (CALCITE-4409) Improve exception when RelBuilder tries to create a field on a non-struct expression

2020-11-19 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4409: -- Summary: Improve exception when RelBuilder tries to create a field on a non-struct expression Key: CALCITE-4409 URL: https://issues.apache.org/jira/browse/CALCITE-4409

[jira] [Assigned] (CALCITE-4409) Improve exception when RelBuilder tries to create a field on a non-struct expression

2020-11-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4409: -- Assignee: Ruben Q L > Improve exception when RelBuilder tries to create a field on a

[jira] [Updated] (CALCITE-4409) Improve exception when RelBuilder tries to create a field on a non-struct expression

2020-11-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4409: --- Description: A simple test like this (to added in RelBuilderTest), where

[jira] [Updated] (CALCITE-4409) Improve exception when RelBuilder tries to create a field on a non-struct expression

2020-11-19 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4409: --- Priority: Trivial (was: Major) > Improve exception when RelBuilder tries to create a field on a

[jira] [Commented] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-21 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17236767#comment-17236767 ] Ruben Q L commented on CALCITE-4415: [~julianhyde], do you mean removing {{NOT_LIKE}} from the map

[jira] [Commented] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17237225#comment-17237225 ] Ruben Q L commented on CALCITE-4415: [~julianhyde], ok, you have persuaded me :) I will carry out

[jira] [Commented] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17237251#comment-17237251 ] Ruben Q L commented on CALCITE-4415: [~julianhyde], unfortunately, a quick test shows that removing

[jira] [Comment Edited] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17237225#comment-17237225 ] Ruben Q L edited comment on CALCITE-4415 at 11/23/20, 8:49 AM: ---

[jira] [Comment Edited] (CALCITE-4415) SqlStdOperatorTable.NOT_LIKE has a wrong implementor

2020-11-23 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17237251#comment-17237251 ] Ruben Q L edited comment on CALCITE-4415 at 11/23/20, 9:44 AM: ---

[jira] [Resolved] (CALCITE-4390) SqlMatchRecognize returns wrong operand list

2020-11-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4390. Fix Version/s: 1.27.0 Resolution: Fixed Fixed via

[jira] [Commented] (CALCITE-4364) Simplify "a IN (1, 2) AND a = 1" to "a = 1"

2020-11-12 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17230632#comment-17230632 ] Ruben Q L commented on CALCITE-4364: Would it be possible that this merge has broken some slow

[jira] [Updated] (CALCITE-4453) RexExecutorImpl#compile should use RexBuilder's type factory if possible

2021-01-05 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4453: --- Issue Type: Improvement (was: Bug) > RexExecutorImpl#compile should use RexBuilder's type factory

[jira] [Updated] (CALCITE-4453) RexExecutorImpl#compile should use RexBuilder's type factory if possible

2021-01-05 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4453: --- Priority: Minor (was: Major) > RexExecutorImpl#compile should use RexBuilder's type factory if

[jira] [Commented] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2021-01-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17262490#comment-17262490 ] Ruben Q L commented on CALCITE-4188: Ok, thanks for the clarifications [~angelzouxin] and

[jira] [Resolved] (CALCITE-4181) Avatica throws exception when select field is a List

2021-01-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4181. Resolution: Fixed Fixed via

[jira] [Updated] (CALCITE-4181) Avatica throws exception when select field is a List

2021-01-11 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4181: --- Fix Version/s: avatica-1.18.0 > Avatica throws exception when select field is a List >

[jira] [Commented] (CALCITE-4475) New Sort SEMI/ANTI Join Transpose optimization

2021-01-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17271670#comment-17271670 ] Ruben Q L commented on CALCITE-4475: Thanks for the clarification [~zabetak]. Do you agree that the

[jira] [Created] (CALCITE-4475) New Sort SEMI/ANTI Join Transpose optimization

2021-01-22 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4475: -- Summary: New Sort SEMI/ANTI Join Transpose optimization Key: CALCITE-4475 URL: https://issues.apache.org/jira/browse/CALCITE-4475 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-4475) New Sort SEMI/ANTI Join Transpose optimization

2021-01-22 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17270081#comment-17270081 ] Ruben Q L commented on CALCITE-4475: Rule action: {noformat} Sort($0, fetch=X, offset=Y)

[jira] [Commented] (CALCITE-4475) New Sort SEMI/ANTI Join Transpose optimization

2021-01-22 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17270083#comment-17270083 ] Ruben Q L commented on CALCITE-4475: I see that {{SortJoinTransposeRule}} puts back the original

[jira] [Commented] (CALCITE-4461) Do not cast to logical node inside Enumerable rules

2021-01-13 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17264002#comment-17264002 ] Ruben Q L commented on CALCITE-4461: [~vozerov] IMO it makes sense. As you say, maybe the new

[jira] [Assigned] (CALCITE-3221) Add a sort-merge union algorithm

2021-01-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-3221: -- Assignee: Ruben Q L > Add a sort-merge union algorithm > >

[jira] [Commented] (CALCITE-3221) Add a sort-merge union algorithm

2021-01-15 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17266047#comment-17266047 ] Ruben Q L commented on CALCITE-3221: FYI I've been working on an initial version of a new

[jira] [Created] (CALCITE-4453) RexExecutorImpl#compile should use RexBuilder's type factory if possible

2021-01-04 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4453: -- Summary: RexExecutorImpl#compile should use RexBuilder's type factory if possible Key: CALCITE-4453 URL: https://issues.apache.org/jira/browse/CALCITE-4453 Project:

[jira] [Assigned] (CALCITE-4453) RexExecutorImpl#compile should use RexBuilder's type factory if possible

2021-01-04 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4453: -- Assignee: Ruben Q L > RexExecutorImpl#compile should use RexBuilder's type factory if

[jira] [Commented] (CALCITE-4188) support EnumerableBatchNestedLoopJoin in JdbcToEnumerableConverter implement

2021-01-04 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17258243#comment-17258243 ] Ruben Q L commented on CALCITE-4188: Sorry I am arriving a bit late to this discussion. I am not

[jira] [Commented] (CALCITE-4437) The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate

2020-12-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17250256#comment-17250256 ] Ruben Q L commented on CALCITE-4437: [~danny0405] could you please take a look at the PR (change

[jira] [Comment Edited] (CALCITE-4437) The Sort rel should be decorrelated even though it has fetch or limit when it is not inside a Correlate

2020-12-16 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17250256#comment-17250256 ] Ruben Q L edited comment on CALCITE-4437 at 12/16/20, 11:46 AM:

[jira] [Commented] (CALCITE-3221) Add a sort-merge union algorithm

2021-01-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17272818#comment-17272818 ] Ruben Q L commented on CALCITE-3221: You're right [~vladimirsitnikov], I have updated the

[jira] [Updated] (CALCITE-3221) Add a sort-merge union algorithm

2021-01-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3221: --- Description: Currently, the union operation offered by Calcite (see 

[jira] [Updated] (CALCITE-3221) Add a sort-merge union algorithm

2021-01-27 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3221: --- Description: Currently, the union operation offered by Calcite (see 

[jira] [Commented] (CALCITE-4475) New Sort SEMI/ANTI Join Transpose optimization

2021-01-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17272025#comment-17272025 ] Ruben Q L commented on CALCITE-4475: You're right [~zabetak], I've being thinking more carefully

[jira] [Closed] (CALCITE-4475) New Sort SEMI/ANTI Join Transpose optimization

2021-01-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L closed CALCITE-4475. -- Resolution: Abandoned > New Sort SEMI/ANTI Join Transpose optimization >

[jira] [Updated] (CALCITE-3221) Add MergeUnion operator in Enumerable convention

2021-01-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3221: --- Description: Currently, the union operation offered by Calcite (see 

[jira] [Updated] (CALCITE-3221) Add MergeUnion operator in Enumerable convention

2021-01-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3221: --- Summary: Add MergeUnion operator in Enumerable convention (was: Add a sort-merge union algorithm)

[jira] [Commented] (CALCITE-3221) Add MergeUnion operator in Enumerable convention

2021-01-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17273409#comment-17273409 ] Ruben Q L commented on CALCITE-3221: [~julianhyde] in terms of complexity, in case of UNION ALL we

[jira] [Updated] (CALCITE-3221) Add MergeUnion operator in Enumerable convention

2021-02-03 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3221: --- Fix Version/s: 1.27.0 > Add MergeUnion operator in Enumerable convention >

[jira] [Assigned] (CALCITE-4656) Broken links on develop page

2021-06-24 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4656: -- Assignee: Ruben Q L (was: duan xiong) > Broken links on develop page >

[jira] [Assigned] (CALCITE-4656) Broken links on develop page

2021-06-24 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4656?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4656: -- Assignee: duan xiong (was: Ruben Q L) > Broken links on develop page >

[jira] [Commented] (CALCITE-4621) SemiJoinRule throws AssertionError on ANTI join

2021-06-18 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17365567#comment-17365567 ] Ruben Q L commented on CALCITE-4621: FYI [~julianhyde] I have created a

[jira] [Updated] (CALCITE-4603) Least restrictive type considers only the last element in collections of collections

2021-05-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4603: --- Fix Version/s: 1.27.0 > Least restrictive type considers only the last element in collections of

[jira] [Resolved] (CALCITE-4603) Least restrictive type considers only the last element in collections of collections

2021-05-17 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L resolved CALCITE-4603. Resolution: Fixed > Least restrictive type considers only the last element in collections of >

[jira] [Commented] (CALCITE-4608) Fix NullPointerException in SqlNumericLiteral.isInteger()

2021-05-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351681#comment-17351681 ] Ruben Q L commented on CALCITE-4608: +1 on changing {{prec}} and {{scale}} fields to {{public final

[jira] [Commented] (CALCITE-4621) SemiJoinRule throws AssertionError on ANTI join

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351045#comment-17351045 ] Ruben Q L commented on CALCITE-4621: [~zabetak] the rule uses the "new" interface

[jira] [Updated] (CALCITE-4621) SemiJoinRule throws AssertionError on ANTI join

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4621: --- Description: Credits to [~thomas.rebele] for discovering the issue. When SemiJoinRule (both

[jira] [Updated] (CALCITE-4608) Fix NullPointerException in SqlNumericLiteral.isInteger()

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4608: --- Description: In 1.26, a NullPointerException is thrown in SqlNumericLiteral.isInteger(), due to

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351062#comment-17351062 ] Ruben Q L commented on CALCITE-4617: Thanks for the clarification [~sylvaincrozon], it makes sense.

[jira] [Created] (CALCITE-4621) SemiJoinRule throws AssertionError on ANTI join

2021-05-25 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4621: -- Summary: SemiJoinRule throws AssertionError on ANTI join Key: CALCITE-4621 URL: https://issues.apache.org/jira/browse/CALCITE-4621 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351616#comment-17351616 ] Ruben Q L commented on CALCITE-4617: Thanks for the clear explanation, [~julianhyde]. Just

[jira] [Commented] (CALCITE-4608) Fix NullPointerException in SqlNumericLiteral.isInteger()

2021-05-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351928#comment-17351928 ] Ruben Q L commented on CALCITE-4608: bq. Wouldn't it be better to just set the SqlTypeName in

[jira] [Created] (CALCITE-4623) Review if SemiJoinRule shall / shall not match SEMI join

2021-05-26 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-4623: -- Summary: Review if SemiJoinRule shall / shall not match SEMI join Key: CALCITE-4623 URL: https://issues.apache.org/jira/browse/CALCITE-4623 Project: Calcite

[jira] [Updated] (CALCITE-4623) Review if SemiJoinRule shall / shall not match SEMI join

2021-05-26 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4623: --- Description: Issue pointed out by [~zabetak] during the review of CALCITE-4621. Currently,

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17350906#comment-17350906 ] Ruben Q L commented on CALCITE-4617: [~sylvaincrozon] could you please add more unit tests to the

[jira] [Updated] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-4617: --- Fix Version/s: 1.27.0 > Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

[jira] [Assigned] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L reassigned CALCITE-4617: -- Assignee: Ruben Q L > Wrong offset when SortJoinTransposeRule pushes a sort node with an

[jira] [Commented] (CALCITE-4608) Fix NullPointerException in SqlNumericLiteral.isInteger()

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17350864#comment-17350864 ] Ruben Q L commented on CALCITE-4608: [~amrishlal] commit messages (and their corresponding Jiras)

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17350926#comment-17350926 ] Ruben Q L commented on CALCITE-4617: BTW, I just found an old (related?) ticket that was supposed

[jira] [Comment Edited] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17350926#comment-17350926 ] Ruben Q L edited comment on CALCITE-4617 at 5/25/21, 9:09 AM: -- BTW, I just

[jira] [Commented] (CALCITE-4608) Fix NullPointerException in SqlNumericLiteral.isInteger()

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17350907#comment-17350907 ] Ruben Q L commented on CALCITE-4608: [~amrishlal] there's a bit of confusion around the NPE that

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351139#comment-17351139 ] Ruben Q L commented on CALCITE-4617: Ok, let's keep the fetch out of the scope of the current

[jira] [Comment Edited] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17351139#comment-17351139 ] Ruben Q L edited comment on CALCITE-4617 at 5/25/21, 3:39 PM: -- Ok, let's

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-06-01 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17354875#comment-17354875 ] Ruben Q L commented on CALCITE-4617: [~nobigo], I'm just describing the current behavior of the

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-29 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17353694#comment-17353694 ] Ruben Q L commented on CALCITE-4617: [~julianhyde], if I am not mistaken, your proposed query 0

[jira] [Commented] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17353095#comment-17353095 ] Ruben Q L commented on CALCITE-4617: [~zabetak] IMO ready to go, I'll proceed with the merge. >

[jira] [Comment Edited] (CALCITE-4617) Wrong offset when SortJoinTransposeRule pushes a sort node with an offset

2021-05-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17353095#comment-17353095 ] Ruben Q L edited comment on CALCITE-4617 at 5/28/21, 9:06 AM: -- [~zabetak]

[jira] [Commented] (CALCITE-4621) SemiJoinRule throws AssertionError on ANTI join

2021-05-28 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17353106#comment-17353106 ] Ruben Q L commented on CALCITE-4621: Thanks for the feedback [~julianhyde]. Those are valid points

<    2   3   4   5   6   7   8   9   10   11   >