Xurenhe created CALCITE-5038:
--------------------------------
Summary: Making AGGREGATE_ANY_PULL_UP_CONSTANTS's test case more
rigorous
Key: CALCITE-5038
URL: https://issues.apache.org/jira/browse/CALCITE-5038
Project: Calcite
Issue Type: Test
Components: tests
Reporter: Xurenhe
Assignee: Xurenhe
Some test cases for AGGREGATE_ANY_PULL_UP_CONSTANTS aren't rigorous.
{code:java}
//sql in testAggregateDynamicFunction
select hiredate
from sales.emp
where sal is null and hiredate = current_timestamp
group by sal, hiredate
having count(*) > 3
{code}
But we know that sal in table of sales.emp is not null, so this case should be
changed to
{code:java}
//代码占位符
select hiredate
from sales.emp
where mrg is null and hiredate = current_timestamp
group by sal, hiredate
having count(*) > 3 {code}
Test case of *_testAggregateConstantKeyRule3_* has the same problem.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
