[PIG-2952] Division of an integer by an integer returns an integer

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.3.0, 0.4.0, 0.5.0, 0.6.0, 0.7.0, 0.8.0, 0.8.1, 0.9.0, 0.9.1, 0.9.2, 0.10.0
• Component/s: impl
• Assignee: Unassigned
• Reporter: Ashutosh Chauhan
• Created: 07/Oct/12 20:14
• Updated: 08/Oct/12 03:47
• Resolved: 08/Oct/12 03:47

Description

Currently,

a = load 'data' as (i:int); 
b = foreach a generate i / 23;

will result in values in b being truncated to nearest int.
SQL standard says correct behavior in such cases is to return double. MySQL does this correctly as well.