[jira] [Created] (IGNITE-4035) SQL: Avoid excessive calls of deterministic functions on same arguments

["Andrew Mashenkov (JIRA)" <ji...@apache.org>]

Andrew Mashenkov created IGNITE-4035:
----------------------------------------

             Summary: SQL: Avoid excessive calls of deterministic functions on same arguments
                 Key: IGNITE-4035
                 URL: https://issues.apache.org/jira/browse/IGNITE-4035
             Project: Ignite
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 1.7, 1.6
            Reporter: Andrew Mashenkov


In sql query example below, heavy "datediff" deterministic function will be called 4 times per row. I'd expect function call once per row. 
It seems deterministic flag semantic is broken.

Example:
{noformat}
Select
  avg(datediff('s',ts1,ts2)) as avg_diff,
  min(datediff('s',ts1,ts2)) as min_diff,
  max(datediff('s',ts1,ts2)) as max_diff
From table
{noformat}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)