ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Mashenkov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-4035) SQL: Avoid excessive calls of deterministic functions on same arguments
Date Wed, 05 Oct 2016 13:24:21 GMT
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)

Mime
View raw message