[ASTERIXDB-2293] Incorrect results when dividing(affects functions like avg too)

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Component/s: FUN - Functions
• Assignee: Unassigned
• Reporter: James Fang
• Created: 21/Feb/18 02:03
• Updated: 12/Mar/18 21:42
• Resolved: 12/Mar/18 21:42

Description

I receive incorrect results when dividing. The following queries give the incorrect result in AsterixDB and Couchbase, but gives the correct result in Postgres.

For example:

1) array_avg( [1.2,2.3,3.4] ); 
2.3000000000000003
2) array_sum( [1.2,2.3,3.4] ) / 3;
2.3000000000000003
3) 6.9 / 3;
2.3000000000000003
 

Using the [1.1,2.2,3.3] for 1 and 2, and 6.6 instead of 6.9 in for number 3 gives,
2.1999999999999997