[jira] [Commented] (CALCITE-4582) The distinct row count and population size should be 1 for deduced constant columns

["Chunwei Lei (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-4582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17334408#comment-17334408 ] 

Chunwei Lei commented on CALCITE-4582:
--------------------------------------

Makes sense.

> The distinct row count and population size should be 1 for deduced constant columns
> -----------------------------------------------------------------------------------
>
>                 Key: CALCITE-4582
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4582
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Liya Fan
>            Priority: Major
>
> As a follow-up issue for CALCITE-4511, we should support more scenarios for which the columns are deduced to have constant values, so they must have the distinct row count equal to 1.
> Some examples of such cases:
> {noformat}
> select one
> from ( select *, 1 as one from emp);
> select deptno
> from emp
> where deptno = 20;
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)