Aman Sinha created CALCITE-695:
----------------------------------
Summary: SqlSingleValueAggFunction is created when it may not be
needed
Key: CALCITE-695
URL: https://issues.apache.org/jira/browse/CALCITE-695
Project: Calcite
Issue Type: Bug
Affects Versions: 1.3.0-incubating
Reporter: Aman Sinha
Assignee: Julian Hyde
In the following query, the subquery is producing a scalar value but the
logical plan still creates a SqlSingleValueAggFunction.
{code}
select r_regionkey from region
where r_regionkey > (select min(n_regionkey) * 2 from nation);
{code}
If the aggregate is just min(n_regionkey) instead of the expression
min(n_regionkey) * 2 then no SqlSingleValueAggFunction is created. Ideally,
both should behave the same.
This is not necessarily a bug but it does create a burden on the underlying
execution engine to support this function even in cases where it may not be
needed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
