[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819780#comment-16819780 ] Forward Xu commented on CALCITE-2846: - Reference blink now is to write its own Flin

[jira] [Assigned] (CALCITE-2453) Enhance the SQL parser in order to optionally support semicolon at the end of the sql statements

[ https://issues.apache.org/jira/browse/CALCITE-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2453: Assignee: Chunwei Lei > Enhance the SQL parser in order to optionally support semicolon

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819701#comment-16819701 ] Lai Zhou commented on CALCITE-2973: --- [~zabetak], great thanks to your suggestion. I'l

[jira] [Resolved] (CALCITE-2343) PushProjector with OVER expression causing infinite loop

[ https://issues.apache.org/jira/browse/CALCITE-2343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang resolved CALCITE-2343. --- Resolution: Fixed Fix Version/s: 1.20.0 Fixed in [b03cdc486cf5c7232bbc6fa9b5f02f564

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

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819700#comment-16819700 ] Haisheng Yuan commented on CALCITE-2948: I think this is still equi condition.

[jira] [Commented] (CALCITE-1531) SqlValidatorException when boolean operators are used with NULL

[ https://issues.apache.org/jira/browse/CALCITE-1531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819698#comment-16819698 ] Lai Zhou commented on CALCITE-1531: --- [~julianhyde], could you reopen this issue , and

[jira] [Commented] (CALCITE-1531) SqlValidatorException when boolean operators are used with NULL

[ https://issues.apache.org/jira/browse/CALCITE-1531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819697#comment-16819697 ] Lai Zhou commented on CALCITE-1531: --- [~julianhyde], Considerin_g_ follow sql:   {co

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

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-2948: Summary: SqlToRelConverter generates complicated logical plan for in subquery with non-equi condi

[jira] [Commented] (CALCITE-947) Allow optional parameters to have default values other than NULL

[ https://issues.apache.org/jira/browse/CALCITE-947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819695#comment-16819695 ] Chunwei Lei commented on CALCITE-947: - [~julianhyde], though it may need a lot more

[jira] [Assigned] (CALCITE-947) Allow optional parameters to have default values other than NULL

[ https://issues.apache.org/jira/browse/CALCITE-947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-947: --- Assignee: Chunwei Lei > Allow optional parameters to have default values other than NULL >

[jira] [Commented] (CALCITE-3009) It should fail if there are duplicate keys in a .xml file

[ https://issues.apache.org/jira/browse/CALCITE-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819676#comment-16819676 ] Chunwei Lei commented on CALCITE-3009: -- cc [~julianhyde]. I would like to take it

[jira] [Created] (CALCITE-3009) It should fail if there are duplicate keys in a .xml file

Chunwei Lei created CALCITE-3009: Summary: It should fail if there are duplicate keys in a .xml file Key: CALCITE-3009 URL: https://issues.apache.org/jira/browse/CALCITE-3009 Project: Calcite

[jira] [Comment Edited] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819666#comment-16819666 ] Chunwei Lei edited comment on CALCITE-3006 at 4/17/19 2:15 AM: --

[jira] [Commented] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

[ https://issues.apache.org/jira/browse/CALCITE-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819666#comment-16819666 ] Chunwei Lei commented on CALCITE-3006: -- Which and where is the test? I would like

[jira] [Comment Edited] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819650#comment-16819650 ] Forward Xu edited comment on CALCITE-3005 at 4/17/19 1:31 AM: ---

[jira] [Commented] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819650#comment-16819650 ] Forward Xu commented on CALCITE-3005: - well, I find this discussion very meaningful

[jira] [Commented] (CALCITE-3008) Making AuxiliaryConverter Pluggable

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819645#comment-16819645 ] Haisheng Yuan commented on CALCITE-3008: Yes, I think so. > Making AuxiliaryCo

[jira] [Created] (CALCITE-3008) Making AuxiliaryConverter Pluggable

Rong Rong created CALCITE-3008: -- Summary: Making AuxiliaryConverter Pluggable Key: CALCITE-3008 URL: https://issues.apache.org/jira/browse/CALCITE-3008 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-3007) Type mismatch for ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819600#comment-16819600 ] Haisheng Yuan commented on CALCITE-3007: Sure, thanks! > Type mismatch for ANY

[jira] [Commented] (CALCITE-3007) Type mismatch for ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819588#comment-16819588 ] Vineet Garg commented on CALCITE-3007: -- I can take a look if you aren't already lo

[jira] [Updated] (CALCITE-3007) Type mismatch for ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3007: --- Summary: Type mismatch for ANY subquery in project (was: Type mismatch for > ANY subquery

[jira] [Created] (CALCITE-3007) Type mismatch for > ANY subquery in project

Haisheng Yuan created CALCITE-3007: -- Summary: Type mismatch for > ANY subquery in project Key: CALCITE-3007 URL: https://issues.apache.org/jira/browse/CALCITE-3007 Project: Calcite Issue Typ

[jira] [Updated] (CALCITE-3007) Type mismatch for > ANY subquery in project

[ https://issues.apache.org/jira/browse/CALCITE-3007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3007: --- Labels: sub-query (was: ) > Type mismatch for > ANY subquery in project >

[jira] [Created] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

Nandor Kollar created CALCITE-3006: -- Summary: Inaccurate information on site, example code doesn't compile Key: CALCITE-3006 URL: https://issues.apache.org/jira/browse/CALCITE-3006 Project: Calcite

[jira] [Commented] (CALCITE-2986) Wrong results with =ANY subquery

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819265#comment-16819265 ] Vineet Garg commented on CALCITE-2986: -- [~hyuan] Right I was talking about <>ANY i

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

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819232#comment-16819232 ] Chunwei Lei commented on CALCITE-2970: -- {quote}Say we generate a sort merge join,

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

[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819201#comment-16819201 ] Haisheng Yuan commented on CALCITE-2970: Without enabling abstract converter (p

[jira] [Commented] (CALCITE-3003) AssertionError when GROUP BY nested field

[ https://issues.apache.org/jira/browse/CALCITE-3003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819166#comment-16819166 ] Chunwei Lei commented on CALCITE-3003: -- {quote}Not sure where it is not clear. {qu

[jira] [Comment Edited] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819151#comment-16819151 ] Chunwei Lei edited comment on CALCITE-3005 at 4/16/19 3:26 PM: --

[jira] [Commented] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819151#comment-16819151 ] Chunwei Lei commented on CALCITE-3005: --  Since it may face some issue as [ CALCIT

[jira] [Comment Edited] (CALCITE-3004) RexOver is incorrectly pushed down in ProjectSetOpTransposeRule and ProjectCorrelateTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819119#comment-16819119 ] Chunwei Lei edited comment on CALCITE-3004 at 4/16/19 3:16 PM: --

[jira] [Commented] (CALCITE-3004) RexOver is incorrectly pushed down in ProjectSetOpTransposeRule and ProjectCorrelateTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16819119#comment-16819119 ] Chunwei Lei commented on CALCITE-3004: -- I opened a PR: [https://github.com/apache/

[jira] [Updated] (CALCITE-3004) RexOver is incorrectly pushed down in ProjectSetOpTransposeRule and ProjectCorrelateTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-3004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3004: Labels: pull-request-available (was: ) > RexOver is incorrectly pushed down in ProjectSe

[jira] [Resolved] (CALCITE-2994) Least restrictive type among structs does not consider nullability

[ https://issues.apache.org/jira/browse/CALCITE-2994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-2994. -- Resolution: Fixed Fixed in [395aa85085e0dad1ba14d8761aeb79b2b11c3809|https:/

[jira] [Commented] (CALCITE-2973) Allow theta joins that have equi conditions to be executed using a hash join algorithm

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818940#comment-16818940 ] Stamatis Zampetakis commented on CALCITE-2973: -- In terms of code re-use, i

[jira] [Commented] (CALCITE-2282) Allow OperatorTable to be pluggable in the parser

[ https://issues.apache.org/jira/browse/CALCITE-2282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818921#comment-16818921 ] Lai Zhou commented on CALCITE-2282: --- +1.[~julianhyde] , is there a good way to solve

[jira] [Comment Edited] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816658#comment-16816658 ] Julian Feinauer edited comment on CALCITE-1935 at 4/16/19 11:20 AM: -

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

[ https://issues.apache.org/jira/browse/CALCITE-2166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan reassigned CALCITE-2166: --- Assignee: Danny Chan > Cumulative cost of RelSubset.best RelNode is increased after callin

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

[ https://issues.apache.org/jira/browse/CALCITE-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818906#comment-16818906 ] Danny Chan commented on CALCITE-2018: - [~vvysotskyi] Ok, i will try to fix CALCITE-

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

[ https://issues.apache.org/jira/browse/CALCITE-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818872#comment-16818872 ] Volodymyr Vysotskyi commented on CALCITE-2018: -- [~danny0405], thanks for m

[jira] [Commented] (CALCITE-2712) Add rule to remove null-generating side of a Join

[ https://issues.apache.org/jira/browse/CALCITE-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818852#comment-16818852 ] Chunwei Lei commented on CALCITE-2712: -- Thanks [~swtalbot]. [~julianhyde], do you

[jira] [Updated] (CALCITE-2992) Enhance implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lai Zhou updated CALCITE-2992: -- Summary: Enhance implicit conversions when generating hash join keys for an equiCondition (was: Make

[jira] [Commented] (CALCITE-2898) RelOptUtil#splitJoinCondition must consider RexFieldAccess referencing RexInputRef

[ https://issues.apache.org/jira/browse/CALCITE-2898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818769#comment-16818769 ] Ruben Quesada Lopez commented on CALCITE-2898: -- [~julianhyde], as you sugg

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:24 AM:

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:24 AM:

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:23 AM:

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:23 AM:

[jira] [Comment Edited] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818765#comment-16818765 ] Lai Zhou edited comment on CALCITE-2992 at 4/16/19 8:23 AM:

[jira] [Commented] (CALCITE-2992) Make implicit conversions when generating hash join keys for an equiCondition

[ https://issues.apache.org/jira/browse/CALCITE-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818765#comment-16818765 ] Lai Zhou commented on CALCITE-2992: --- [~julianhyde], you're right. I add a test case:

[jira] [Updated] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-3005: Description: Some string functions including LEFT, RIGHT are not implemented now. It would be gr

[jira] [Updated] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-3005: Description: Some string functions including LEFT, RIGHT are not implemented now. It would be gr

[jira] [Updated] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu updated CALCITE-3005: Description: Some string functions including REPEAT, SPACE, SOUNDEX, DIFFERENCE are not implement

[jira] [Created] (CALCITE-3005) Implement string functions: LEFT, RIGHT

Forward Xu created CALCITE-3005: --- Summary: Implement string functions: LEFT, RIGHT Key: CALCITE-3005 URL: https://issues.apache.org/jira/browse/CALCITE-3005 Project: Calcite Issue Type: New Fea

[jira] [Assigned] (CALCITE-3005) Implement string functions: LEFT, RIGHT

[ https://issues.apache.org/jira/browse/CALCITE-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Forward Xu reassigned CALCITE-3005: --- Assignee: Forward Xu > Implement string functions: LEFT, RIGHT > -

[jira] [Closed] (CALCITE-2898) RelOptUtil#splitJoinCondition must consider RexFieldAccess referencing RexInputRef

[ https://issues.apache.org/jira/browse/CALCITE-2898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez closed CALCITE-2898. Resolution: Not A Bug > RelOptUtil#splitJoinCondition must consider RexFieldAcces

[jira] [Commented] (CALCITE-2999) Can't get the right column value in LogicalSort

[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818732#comment-16818732 ] Hongze Zhang commented on CALCITE-2999: --- Maybe. I am not sure if someone expects

[jira] [Commented] (CALCITE-2898) RelOptUtil#splitJoinCondition must consider RexFieldAccess referencing RexInputRef

[ https://issues.apache.org/jira/browse/CALCITE-2898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818724#comment-16818724 ] Ruben Quesada Lopez commented on CALCITE-2898: -- As explained in the [maili

[jira] [Commented] (CALCITE-2933) In Druid adapter, expression like "cast(cast(\"timestamp\" as timestamp) as varchar)" returns as epoch millisecond

[ https://issues.apache.org/jira/browse/CALCITE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818719#comment-16818719 ] Danny Chan commented on CALCITE-2933: - [~zhztheplayer] Do you think the patch is ok

[jira] [Commented] (CALCITE-2999) Can't get the right column value in LogicalSort

[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16818714#comment-16818714 ] Danny Chan commented on CALCITE-2999: - [~zhztheplayer] Got your idea, the RelRoot i