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

["Liya Fan (Jira)" <ji...@apache.org>]

Liya Fan created CALCITE-4582:
---------------------------------

             Summary: 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


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)