[jira] [Created] (CALCITE-695) SqlSingleValueAggFunction is created when it may not be needed

["Aman Sinha (JIRA)" <ji...@apache.org>]

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)