You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ignite.apache.org by "Sergey Kozlov (JIRA)" <ji...@apache.org> on 2017/02/20 10:24:45 UTC

[jira] [Created] (IGNITE-4724) AVG function always returns double type instead of the argument type

Sergey Kozlov created IGNITE-4724:
-------------------------------------

             Summary: AVG function always returns double type instead of the argument type
                 Key: IGNITE-4724
                 URL: https://issues.apache.org/jira/browse/IGNITE-4724
             Project: Ignite
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.9
            Reporter: Sergey Kozlov
             Fix For: 1.9


For H2:
SELECT AVG(intCol) FROM cache_part_2 AS part_2 WHERE (10*shortCol/100) > longCol
-[472]

For Ignite:
SELECT AVG(intCol) FROM AllTypes AS part_2 WHERE (10*shortCol/100) > longCol
+[472.2307692307692]




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)