[SPARK-17494] Floor/ceil of decimal returns wrong result if it's in compact format

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.1, 2.0.0
• Fix Version/s: 2.0.1, 2.1.0
• Component/s: SQL
• Labels: correctness
• Target Version/s: 2.0.1, 2.1.0
• Assignee: Davies Liu Assign to me
• Reporter: Gokhan Civan
• Created: 10/Sep/16 18:12
• Updated: 22/Sep/16 04:02
• Resolved: 22/Sep/16 04:02

Description

If you create tables as follows:

create table a as select 'A' as str, cast(10.5 as decimal(15,6)) as num;
create table b as select 'A' as str;

Then

select floor(num) from a;

returns 10
but

select floor(num) from a join b on a.str = b.str;

returns 11

Issue Links

• links to: [Github] Pull Request #15154 (davies)