[jira] [Comment Edited] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326234#comment-17326234 ] yanjing.wang edited comment on CALCITE-4512 at 4/21/21, 4:07 AM: - {{I

[jira] [Comment Edited] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326234#comment-17326234 ] yanjing.wang edited comment on CALCITE-4512 at 4/21/21, 3:39 AM: - {{I

[jira] [Comment Edited] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326234#comment-17326234 ] yanjing.wang edited comment on CALCITE-4512 at 4/21/21, 3:37 AM: - {{I

[jira] [Comment Edited] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326234#comment-17326234 ] yanjing.wang edited comment on CALCITE-4512 at 4/21/21, 3:37 AM: - {{I

[jira] [Commented] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326234#comment-17326234 ] yanjing.wang commented on CALCITE-4512: --- {{I have no idea to verify}} *{{}}* {{that}} *{{SELECT x

[jira] [Updated] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yanjing.wang updated CALCITE-4512: -- Fix Version/s: (was: 1.27.0) > group by expression has argument name same with select

[jira] [Commented] (CALCITE-4549) IndexOutOfBoundsException when group view by a sub query

[ https://issues.apache.org/jira/browse/CALCITE-4549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326185#comment-17326185 ] Haisheng Yuan commented on CALCITE-4549: I don't remember we had seen issue with IN query like

[jira] [Commented] (CALCITE-4561) Wrong results for plan with EnumerableHashJoin (semi) on nullable colunms

[ https://issues.apache.org/jira/browse/CALCITE-4561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326183#comment-17326183 ] Haisheng Yuan commented on CALCITE-4561: Nice finding. it is better to generate not_null filter

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326130#comment-17326130 ] Julian Hyde commented on CALCITE-4557: -- {quote}I don't think it is necessary to simplify{quote}

[jira] [Commented] (CALCITE-4560) Wrong plan when decorrelating EXISTS subquery with COALESCE in the predicate

[ https://issues.apache.org/jira/browse/CALCITE-4560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326121#comment-17326121 ] Haisheng Yuan commented on CALCITE-4560: [~Chunwei Lei] Can you take a look? you might be

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326073#comment-17326073 ] Haisheng Yuan commented on CALCITE-4557: But if "hiredate" is not in the output columns, or not

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326069#comment-17326069 ] Haisheng Yuan commented on CALCITE-4557: I don't think it is necessary to simplify "ORDER BY

[jira] [Commented] (CALCITE-4557) Sort costing should account the number of sort keys: the more keys to compare, the more the cost

[ https://issues.apache.org/jira/browse/CALCITE-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326067#comment-17326067 ] Julian Hyde commented on CALCITE-4557: -- A useful optimization would be to remove sort fields that

[jira] [Commented] (CALCITE-4529) In JoinUnionTransposeRule rule, the string field will be converted to varchar in join, resulting in cannot address expression of different type to set

[ https://issues.apache.org/jira/browse/CALCITE-4529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17326064#comment-17326064 ] Julian Hyde commented on CALCITE-4529: -- Anything that gives an {{AssertionError}} is definitely

[jira] [Commented] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325953#comment-17325953 ] Julian Hyde commented on CALCITE-4512: -- I think it is correct to expand. But the expansion should

[jira] [Commented] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325662#comment-17325662 ] yanjing.wang commented on CALCITE-4512: --- I find the culprit is invoking

[jira] [Resolved] (CALCITE-4586) In piglet, allow creating a PigRelBuilder with custom "config.simplify()"

[ https://issues.apache.org/jira/browse/CALCITE-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-4586. -- Fix Version/s: 1.27.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-4583) Make simplification configurable in "RelBuilder#filter"

[ https://issues.apache.org/jira/browse/CALCITE-4583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325635#comment-17325635 ] Stamatis Zampetakis commented on CALCITE-4583: -- I merged this to master but I just noticed

[jira] [Resolved] (CALCITE-4583) Make simplification configurable in "RelBuilder#filter"

[ https://issues.apache.org/jira/browse/CALCITE-4583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis resolved CALCITE-4583. -- Fix Version/s: 1.27.0 Resolution: Fixed Fixed in

[jira] [Commented] (CALCITE-4529) In JoinUnionTransposeRule rule, the string field will be converted to varchar in join, resulting in cannot address expression of different type to set

[ https://issues.apache.org/jira/browse/CALCITE-4529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17325606#comment-17325606 ] jibiyr commented on CALCITE-4529: -   [~Chunwei Lei] [~julianhyde],Dear community I debug and find

[jira] [Updated] (CALCITE-4512) group by expression has argument name same with select list item alias, causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yanjing.wang updated CALCITE-4512: -- Summary: group by expression has argument name same with select list item alias, causes

[jira] [Updated] (CALCITE-4512) 'case when' project alias equals 'when condition column name or then column name' causes validation error

[ https://issues.apache.org/jira/browse/CALCITE-4512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] yanjing.wang updated CALCITE-4512: -- Description: String sql = "select replace(name, 'a', 'b') as name from users group by

[jira] [Updated] (CALCITE-4583) Make simplification configurable in "RelBuilder#filter"

[ https://issues.apache.org/jira/browse/CALCITE-4583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-4583: Summary: Make simplification configurable in "RelBuilder#filter" (was: Make simplification

[jira] [Updated] (CALCITE-4583) Make simplification configurable by "RelBuilder.Config#simplify()" in "RelBuilder#filter"

[ https://issues.apache.org/jira/browse/CALCITE-4583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiatao Tao updated CALCITE-4583: Summary: Make simplification configurable by "RelBuilder.Config#simplify()" in