[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=16826331#comment-16826331 ] Haisheng Yuan commented on CALCITE-2948: [~danny0405] For the following query, {code:java}

[jira] [Commented] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16826323#comment-16826323 ] Haisheng Yuan commented on CALCITE-3021: Understood. I will try to comment in JIRA and check

[jira] [Commented] (CALCITE-3021) ArrayEqualityComparer should use Arrays#deepEquals/deepHashCode instead of Arrays#equals/hashCode

[ https://issues.apache.org/jira/browse/CALCITE-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16826228#comment-16826228 ] Haisheng Yuan commented on CALCITE-3021: Sorry, I just notice the discussion in JIRA after I

[jira] [Assigned] (CALCITE-2913) add a KafkaAdapter for Stream

[ https://issues.apache.org/jira/browse/CALCITE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reassigned CALCITE-2913: -- Assignee: (was: James Xu) > add a KafkaAdapter for Stream >

[jira] [Resolved] (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 ] Haisheng Yuan resolved CALCITE-3004. Resolution: Fixed Fix Version/s: 1.20.0 Fixed in commit

[jira] [Commented] (CALCITE-3015) Add rule to remove constants in group keys

[ https://issues.apache.org/jira/browse/CALCITE-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16823107#comment-16823107 ] Haisheng Yuan commented on CALCITE-3015: Nah, if the table is empty, you are screwed up. > Add

[jira] [Commented] (CALCITE-2801) Check input type in AggregateUnionAggregateRule when remove the bottom Aggregate

[ https://issues.apache.org/jira/browse/CALCITE-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16822732#comment-16822732 ] Haisheng Yuan commented on CALCITE-2801: It looks like the PR may introduce another issue. For

[jira] [Updated] (CALCITE-3009) Duplicate key is not detected in xml answer file

[ https://issues.apache.org/jira/browse/CALCITE-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3009: --- Summary: Duplicate key is not detected in xml answer file (was: Duplicate test cases in

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

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

[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=16822278#comment-16822278 ] Haisheng Yuan commented on CALCITE-2948: [~danny0405] Did you try

[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=16822133#comment-16822133 ] Haisheng Yuan commented on CALCITE-2973: Every physical join, no matter inner join or outer

[jira] [Resolved] (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 resolved CALCITE-3007. Resolution: Fixed Fix Version/s: 1.20.0 Fixed in

[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=16822079#comment-16822079 ] Haisheng Yuan commented on CALCITE-2973: EnumerableJoin and EnumerableThetaJoin are not good

[jira] [Comment Edited] (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=16821654#comment-16821654 ] Haisheng Yuan edited comment on CALCITE-2973 at 4/19/19 4:56 AM: -

[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=16821654#comment-16821654 ] Haisheng Yuan commented on CALCITE-2973: {quote} For the record, here is a non-equi join where

[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=16821642#comment-16821642 ] Haisheng Yuan commented on CALCITE-2973: I don't like the idea of breaking theta join into

[jira] [Resolved] (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:all-tabpanel ] Haisheng Yuan resolved CALCITE-3006. Resolution: Fixed Fix Version/s: 1.20.0 Fixed in

[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=16820669#comment-16820669 ] Haisheng Yuan commented on CALCITE-2948: The EMPNO is primary key of table emp, so it is

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

[ https://issues.apache.org/jira/browse/CALCITE-3008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16820604#comment-16820604 ] Haisheng Yuan commented on CALCITE-3008: {quote} That's actually a good point.

[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=16819700#comment-16819700 ] Haisheng Yuan commented on CALCITE-2948: I think this is still equi condition. I am just

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

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

[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=16819600#comment-16819600 ] Haisheng Yuan commented on CALCITE-3007: Sure, thanks! > Type mismatch for ANY subquery in

[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

[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] [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=16819201#comment-16819201 ] Haisheng Yuan commented on CALCITE-2970: Without enabling abstract converter (property

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

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818511#comment-16818511 ] Haisheng Yuan edited comment on CALCITE-2986 at 4/16/19 2:08 AM: - I got

[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=16818511#comment-16818511 ] Haisheng Yuan commented on CALCITE-2986: I got it. I thought you are say <>ANY in where clause.

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

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818490#comment-16818490 ] Haisheng Yuan edited comment on CALCITE-2986 at 4/16/19 1:05 AM: -

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

[ https://issues.apache.org/jira/browse/CALCITE-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818490#comment-16818490 ] Haisheng Yuan edited comment on CALCITE-2986 at 4/16/19 1:04 AM: - >>

[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=16818490#comment-16818490 ] Haisheng Yuan commented on CALCITE-2986: > Problem with semi join transformation is that it

[jira] [Commented] (CALCITE-2991) getMaxRowCount should return rowcount 1 for an aggregate with constant keys

[ https://issues.apache.org/jira/browse/CALCITE-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816744#comment-16816744 ] Haisheng Yuan commented on CALCITE-2991: OK, thanks! > getMaxRowCount should return rowcount 1

[jira] [Commented] (CALCITE-2977) Exception is not thrown out when there are ambiguous field in select list

[ https://issues.apache.org/jira/browse/CALCITE-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816732#comment-16816732 ] Haisheng Yuan commented on CALCITE-2977: Pushed to master

[jira] [Resolved] (CALCITE-2977) Exception is not thrown out when there are ambiguous field in select list

[ https://issues.apache.org/jira/browse/CALCITE-2977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2977. Resolution: Fixed > Exception is not thrown out when there are ambiguous field in

[jira] [Resolved] (CALCITE-2739) NPE will thrown if the DEFINE statement contains IN in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-2739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2739. Resolution: Fixed Fix Version/s: 1.20.0 Pushed to master

[jira] [Commented] (CALCITE-2969) Improve design of join-like relational expressions

[ https://issues.apache.org/jira/browse/CALCITE-2969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816681#comment-16816681 ] Haisheng Yuan commented on CALCITE-2969: I was assuming this is just an umbrella issue and

[jira] [Resolved] (CALCITE-896) Remove Aggregate if grouping columns are unique and all functions are splittable

[ https://issues.apache.org/jira/browse/CALCITE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-896. --- Resolution: Fixed Assignee: Haisheng Yuan Fix Version/s: 1.20.0 Pushed to

[jira] [Commented] (CALCITE-2991) getMaxRowCount should return rowcount 1 for an aggregate with constant keys

[ https://issues.apache.org/jira/browse/CALCITE-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16815888#comment-16815888 ] Haisheng Yuan commented on CALCITE-2991: I see your concern. For count(*), it will indeed

[jira] [Commented] (CALCITE-2991) getMaxRowCount should return rowcount 1 for an aggregate with constant keys

[ https://issues.apache.org/jira/browse/CALCITE-2991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16815859#comment-16815859 ] Haisheng Yuan commented on CALCITE-2991: I would prefer to do the simplification of removing

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

[ https://issues.apache.org/jira/browse/CALCITE-2973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813766#comment-16813766 ] Haisheng Yuan commented on CALCITE-2973: I don't see the necessity to execute non-equi join

[jira] [Resolved] (CALCITE-2456) VolcanoRuleCall#match works incorrectly for unordered child operand

[ https://issues.apache.org/jira/browse/CALCITE-2456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2456. Resolution: Fixed Fix Version/s: 1.20.0 Pushed to master, thanks for the PR,

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813013#comment-16813013 ] Haisheng Yuan commented on CALCITE-1338: Good idea, that seems much simpler. >

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812997#comment-16812997 ] Haisheng Yuan commented on CALCITE-1338: I don't know if there is any better solution than

[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=16812830#comment-16812830 ] Haisheng Yuan commented on CALCITE-2986: Sorry, I mean <> ALL is equivalent to NOT IN. for <>

[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=16812824#comment-16812824 ] Haisheng Yuan commented on CALCITE-2986: You are right, <> ANY is equivalent to NOT IN. >

[jira] [Commented] (CALCITE-299) Divide the join graph into partitions that can be optimized separately

[ https://issues.apache.org/jira/browse/CALCITE-299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811737#comment-16811737 ] Haisheng Yuan commented on CALCITE-299: --- [~julianhyde] Is this still an issue? > Divide the join

[jira] [Resolved] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2954. Resolution: Fixed Fix Version/s: 1.20.0 Pushed to master, thanks, [~vgarg]! >

[jira] [Resolved] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2754. Resolution: Fixed > LISTAGG support > --- > > Key:

[jira] [Commented] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16810473#comment-16810473 ] Haisheng Yuan commented on CALCITE-2754: Pushed to master

[jira] [Resolved] (CALCITE-1172) Add rule to flatten two Aggregate operators into one

[ https://issues.apache.org/jira/browse/CALCITE-1172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-1172. Resolution: Fixed Fix Version/s: 1.20.0 Pushed to master, thanks for the review,

[jira] [Closed] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2978. -- Resolution: Invalid Closing this issue, since this is an intended behavior. > sorting not

[jira] [Updated] (CALCITE-2427) Sub-queries not supported in DML statements

[ https://issues.apache.org/jira/browse/CALCITE-2427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2427: --- Labels: sub-query (was: ) > Sub-queries not supported in DML statements >

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809003#comment-16809003 ] Haisheng Yuan commented on CALCITE-2965: Can we have a Shared SqlOperatorTable that doesn't

[jira] [Closed] (CALCITE-2960) CalciteCatalogReader use a hard-coding config to get functions

[ https://issues.apache.org/jira/browse/CALCITE-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2960. -- Resolution: Duplicate > CalciteCatalogReader use a hard-coding config to get functions >

[jira] [Resolved] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2947. Resolution: Fixed Fix Version/s: 1.20.0 Resolved by patch in

[jira] [Resolved] (CALCITE-2893) Type mismatch assertion error when creating join condition

[ https://issues.apache.org/jira/browse/CALCITE-2893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2893. Resolution: Fixed Fix Version/s: 1.20.0 Resolved by patch in

[jira] [Resolved] (CALCITE-2004) The TableFunction left outer join was improperly translated

[ https://issues.apache.org/jira/browse/CALCITE-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2004. Resolution: Fixed Fix Version/s: 1.20.0 > The TableFunction left outer join was

[jira] [Commented] (CALCITE-2004) The TableFunction left outer join was improperly translated

[ https://issues.apache.org/jira/browse/CALCITE-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807871#comment-16807871 ] Haisheng Yuan commented on CALCITE-2004: Pushed to master, thanks for the review,

[jira] [Commented] (CALCITE-2592) EnumerableMergeJoin is never taken

[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807350#comment-16807350 ] Haisheng Yuan commented on CALCITE-2592: No other issues besides the performance, AFAIK. But if

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

Haisheng Yuan created CALCITE-2970: -- Summary: Performance issue when enabling abstract converter for EnumerableConvertion Key: CALCITE-2970 URL: https://issues.apache.org/jira/browse/CALCITE-2970

[jira] [Closed] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2964. -- Resolution: Not A Bug > testEmptyFilterProjectUnion fails when copyPorject is disabled in >

[jira] [Commented] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806398#comment-16806398 ] Haisheng Yuan commented on CALCITE-2964: Looks like we just need to add

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806327#comment-16806327 ] Haisheng Yuan commented on CALCITE-2954: OK > SubQueryJoinRemoveRule and

[jira] [Updated] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2964: --- Description: Changing {code:java} public static final FilterProjectTransposeRule INSTANCE

[jira] [Created] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

Haisheng Yuan created CALCITE-2964: -- Summary: testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule Key: CALCITE-2964 URL:

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805907#comment-16805907 ] Haisheng Yuan commented on CALCITE-2954: [~vgarg] Can you add this query to the test case? This

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805516#comment-16805516 ] Haisheng Yuan commented on CALCITE-2954: Do you have case for {{SubQueryJoinRemoveRule}}? I

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805362#comment-16805362 ] Haisheng Yuan commented on CALCITE-2954: The code change looks good to me. Can you add tests in

[jira] [Resolved] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2658. Resolution: Fixed Fix Version/s: 1.20.0 > Introducing more ReduceExpressionRules

[jira] [Commented] (CALCITE-2865) FilterProjectTransposeRule generates wrong traitSet when copyFilter/Project is true

[ https://issues.apache.org/jira/browse/CALCITE-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804041#comment-16804041 ] Haisheng Yuan commented on CALCITE-2865: I am curious why does it provide copyFilter and

[jira] [Resolved] (CALCITE-2729) Introducing WindowReduceExpressionRule

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2729. Resolution: Fixed Fix Version/s: 1.20.0 > Introducing WindowReduceExpressionRule

[jira] [Commented] (CALCITE-2729) Introducing WindowReduceExpressionRule

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16803581#comment-16803581 ] Haisheng Yuan commented on CALCITE-2729: Pushed to master. Thanks, [~Chunwei Lei]! >

[jira] [Commented] (CALCITE-2954) SubQueryJoinRemoveRule and SubQueryProjectRemoveRule passing on empty set instead of set of correlation id

[ https://issues.apache.org/jira/browse/CALCITE-2954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16803545#comment-16803545 ] Haisheng Yuan commented on CALCITE-2954: Will take a look. > SubQueryJoinRemoveRule and

[jira] [Resolved] (CALCITE-2903) Exception thrown when decorrelating query with TEMPORAL TABLE

[ https://issues.apache.org/jira/browse/CALCITE-2903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2903. Resolution: Fixed Fix Version/s: 1.20.0 > Exception thrown when decorrelating

[jira] [Commented] (CALCITE-2959) Support collation on struct fields

[ https://issues.apache.org/jira/browse/CALCITE-2959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16803178#comment-16803178 ] Haisheng Yuan commented on CALCITE-2959: Good question. e.g. we create a b-tree index on

[jira] [Commented] (CALCITE-2953) LatticeTest.testTileAlgorithm2 and LatticeTest.testTileAlgorithm3 fail intermittently

[ https://issues.apache.org/jira/browse/CALCITE-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16802445#comment-16802445 ] Haisheng Yuan commented on CALCITE-2953: I am OK with temporary change. But I suspect maybe the

[jira] [Commented] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16801384#comment-16801384 ] Haisheng Yuan commented on CALCITE-2947: It is duplicate with

[jira] [Commented] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16801381#comment-16801381 ] Haisheng Yuan commented on CALCITE-2947: Found it, it is related with

[jira] [Commented] (CALCITE-2953) LatticeTest.testTileAlgorithm3 failed

[ https://issues.apache.org/jira/browse/CALCITE-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16801321#comment-16801321 ] Haisheng Yuan commented on CALCITE-2953: Weird, it always fails on my machine. >

[jira] [Updated] (CALCITE-2953) LatticeTest.testTileAlgorithm3 failed

[ https://issues.apache.org/jira/browse/CALCITE-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2953: --- Description:

[jira] [Updated] (CALCITE-2953) LatticeTest.testTileAlgorithm3 failed

[ https://issues.apache.org/jira/browse/CALCITE-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2953: --- Description:

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16801285#comment-16801285 ] Haisheng Yuan commented on CALCITE-2948: [~danny0405] Feel free to take it. Thanks for your

[jira] [Updated] (CALCITE-2953) LatticeTest.testTileAlgorithm3 failed

[ https://issues.apache.org/jira/browse/CALCITE-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2953: --- Description:

[jira] [Updated] (CALCITE-2953) LatticeTest.testTileAlgorithm3 failed

[ https://issues.apache.org/jira/browse/CALCITE-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-2953: --- Summary: LatticeTest.testTileAlgorithm3 failed (was: Lattice) >

[jira] [Created] (CALCITE-2953) Lattice

Haisheng Yuan created CALCITE-2953: -- Summary: Lattice Key: CALCITE-2953 URL: https://issues.apache.org/jira/browse/CALCITE-2953 Project: Calcite Issue Type: Bug Reporter:

[jira] [Reopened] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan reopened CALCITE-2948: > SqlToRelConverter generates complicated logical plan for subquery >

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800209#comment-16800209 ] Haisheng Yuan commented on CALCITE-2948: It looks like the problem still exists. {code:java}

[jira] [Commented] (CALCITE-2944) Lack of test for Aggregate.indicator

[ https://issues.apache.org/jira/browse/CALCITE-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800190#comment-16800190 ] Haisheng Yuan commented on CALCITE-2944: Cool, nice to see it going. It has been used by us

[jira] [Commented] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

[ https://issues.apache.org/jira/browse/CALCITE-2947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800154#comment-16800154 ] Haisheng Yuan commented on CALCITE-2947: Perhaps not the same issue. At least with your

[jira] [Commented] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

[ https://issues.apache.org/jira/browse/CALCITE-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800140#comment-16800140 ] Haisheng Yuan commented on CALCITE-2948: I am not sure. Subquery unnesting is a big topic.

[jira] [Closed] (CALCITE-2949) Double aggregate generated for in subquery with distinct

[ https://issues.apache.org/jira/browse/CALCITE-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan closed CALCITE-2949. -- Resolution: Fixed > Double aggregate generated for in subquery with distinct >

[jira] [Commented] (CALCITE-2949) Double aggregate generated for in subquery with distinct

[ https://issues.apache.org/jira/browse/CALCITE-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800132#comment-16800132 ] Haisheng Yuan commented on CALCITE-2949: Agree. I just noticed that AggregateRemoveRule can

[jira] [Created] (CALCITE-2949) Double aggregate generated for in subquery with distinct

Haisheng Yuan created CALCITE-2949: -- Summary: Double aggregate generated for in subquery with distinct Key: CALCITE-2949 URL: https://issues.apache.org/jira/browse/CALCITE-2949 Project: Calcite

[jira] [Created] (CALCITE-2948) SqlToRelConverter generates complicated logical plan for subquery

Haisheng Yuan created CALCITE-2948: -- Summary: SqlToRelConverter generates complicated logical plan for subquery Key: CALCITE-2948 URL: https://issues.apache.org/jira/browse/CALCITE-2948 Project:

[jira] [Created] (CALCITE-2947) Type mismatch assertion error when converting NOT IN subquery

Haisheng Yuan created CALCITE-2947: -- Summary: Type mismatch assertion error when converting NOT IN subquery Key: CALCITE-2947 URL: https://issues.apache.org/jira/browse/CALCITE-2947 Project: Calcite

[jira] [Commented] (CALCITE-2944) Lack of test for Aggregate.indicator

[ https://issues.apache.org/jira/browse/CALCITE-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16799272#comment-16799272 ] Haisheng Yuan commented on CALCITE-2944: Yeah, the field and constructor using indicator should

[jira] [Commented] (CALCITE-2936) Simplify EXISTS or NOT EXISTS sub-query that has "GROUP BY ()"

[ https://issues.apache.org/jira/browse/CALCITE-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16799268#comment-16799268 ] Haisheng Yuan commented on CALCITE-2936: [~danny0405] Let's continue discussion here. I

[jira] [Commented] (CALCITE-2936) Simplify EXISTS or NOT EXISTS sub-query that has "GROUP BY ()"

[ https://issues.apache.org/jira/browse/CALCITE-2936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16799254#comment-16799254 ] Haisheng Yuan commented on CALCITE-2936: In order to remove semijoin, we have to determine that

[jira] [Created] (CALCITE-2944) Lack of test for Aggregate.indicator

Haisheng Yuan created CALCITE-2944: -- Summary: Lack of test for Aggregate.indicator Key: CALCITE-2944 URL: https://issues.apache.org/jira/browse/CALCITE-2944 Project: Calcite Issue Type:

[jira] [Issue Comment Deleted] (CALCITE-896) Remove Aggregate if grouping columns are unique and all functions are splittable

[ https://issues.apache.org/jira/browse/CALCITE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-896: -- Comment: was deleted (was: It seems like the patch in this PR triggered a bug in rule

<    5   6   7   8   9   10   11   >