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)