[HAWQ-19] Money type overflow

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Catalog
• Assignee: Ming Li
• Reporter: Feng Tian
• Created: 30/Sep/15 09:10
• Updated: 12/Aug/20 23:02
• Resolved: 13/Jul/16 02:06

Description

Use tpch schema, but change l_extendedprice to use MONEY type, run Q1, you should see negative amounts.

I believe this is due to overflow.

Side mark, postgres 9 money type use 8 bytes and will return correct result.