[jira] [Created] (IMPALA-6300) Decimal modulo sometimes returns incorrect results

["Taras Bobrovytsky (JIRA)" <ji...@apache.org>]

Taras Bobrovytsky created IMPALA-6300:
-----------------------------------------

             Summary: Decimal modulo sometimes returns incorrect results
                 Key: IMPALA-6300
                 URL: https://issues.apache.org/jira/browse/IMPALA-6300
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
            Reporter: Taras Bobrovytsky
            Assignee: Taras Bobrovytsky


The following query returns an incorrect result:
{code}
select cast(11111 as decimal(6,1)) % cast(2 as decimal(8,6))
{code}

Result:
{code}
-1.901888
{code}

We get this result with both decimal_v1 and decimal_v2.

Modifying the query by removing one of the 1's has the following effect:
{code}
select cast(1111 as decimal(6,1)) % cast(2 as decimal(8,6))
{code}

Result:
{code}
1.000000
{code}



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