[ https://issues.apache.org/jira/browse/IGNITE-4035?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov updated IGNITE-4035: ------------------------------------ Labels: performance (was: sql-performance) > 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: Task > Components: sql > Affects Versions: 1.6, 1.7 > Reporter: Andrew Mashenkov > Priority: Major > Labels: performance > > In sql query example below, heavy "datediff" deterministic function will be > called 4 times per row. I'd expected function was called once per row. > 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 (v7.6.3#76005)