[jira] [Created] (IMPALA-6202) fmod and mod and % are not equivalent

["Jim Apple (JIRA)" <ji...@apache.org>]

Jim Apple created IMPALA-6202:
---------------------------------

             Summary: fmod and mod and % are not equivalent
                 Key: IMPALA-6202
                 URL: https://issues.apache.org/jira/browse/IMPALA-6202
             Project: IMPALA
          Issue Type: Bug
          Components: Docs
    Affects Versions: Impala 2.11.0
            Reporter: Jim Apple


The docs say:

"mod(numeric_type a, same_type b) Purpose: Returns the modulus of a number. Equivalent to the % arithmetic operator."

and

"fmod(double a, double b), fmod(float a, float b) Purpose: Returns the modulus of a floating-point number. Equivalent to the % arithmetic operator."

But these can't both be true:

{noformat}
[localhost:21000] > select typeof(9.9 % 3), typeof(mod(9.9, 3)), typeof(fmod(9.9, 3));
+-----------------+---------------------+----------------------+
| typeof(9.9 % 3) | typeof(mod(9.9, 3)) | typeof(fmod(9.9, 3)) |
+-----------------+---------------------+----------------------+
| DECIMAL(2,1)    | DECIMAL(4,1)        | FLOAT                |
+-----------------+---------------------+----------------------+
{noformat}




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)