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)
