Investigation into the behavior of arithmetic operators on Decimal type

[Mark Biamonte <Mark.Biamonte@progress.com>]

I created a table with 6 columns in several different databases and one SaaS application. The columns are defined as follows.

 

COLA is Decimal (5,2)

COLB is Decimal (10,4)

XADD is COLA+COLB

XSUB is COLA-COLB

XMULT is COLA*COLB

XDIV is COLA/COLB

 

I populated COLA and COLB with the values 123.45 and 123456.7891 respectively and then fetched the data from all of the columns against the different databases and SaaS application. For the most part the results for all of the columns except XDIV were consistent. The results for XDIV were all over the place with regards to the scale of the result. Here are the results

Database	COLA	COLB	XADD	XSUB	XMULT	XDIV
Oracle	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.00099994500828954411872032074419145896
SQL Server	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.0009999450082
DB2	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.000999945008289544118720
MySQL	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.001000
PostgreSQL	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.00099994500828954412
Sybase	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.0009999450082
Informix	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.00099994500828954
Progress OpenEdge	123.45	123456.7891	123580.2391	-123333.3391	15240740.614395	0.00099995
Salesforce	123.45	123456.7891	123580.2391	-123333.3391	1.5240740614395E7	9.99945008289544E-4

 

I also added this information as a comment to OData-784 however the table does not show up as well in the Jira issue.