dynamobi/dynamobi — Issue #722: [FRG-150] modulo function takes real values as arguments and returns wrong results
Author: dynamobi-build
Created: 2011-12-30 03:45:12+00:00
State: open
Labels: FRG, Java Calc Codegen

[reporter="kvu", created="Fri, 9 Jun 2006 11:47:17 -0500 (GMT-05:00)"]
SQL2003 Part2 Section 6.27, Syntax Rules 9:

"If is specified, then the declared type of each shall be

exact numeric with scale 0 (zero). The declared type of the result is the declared type of the immediately

contained ."

-- on luciddb:

values mod(2.3,5), mod(2.4,5), mod(2.5,5), mod(2.6,5);

-- results:

+---------+

| EXPR$0 |

+---------+

| 3 |

| 4 |

| 0 |

| 1 |

+---------+