[ https://issues.apache.org/jira/browse/HAWQ-19?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lei Chang updated HAWQ-19: -------------------------- Fix Version/s: (was: 2.0.0) 2.0.0.0-incubating > Money type overflow > ------------------- > > Key: HAWQ-19 > URL: https://issues.apache.org/jira/browse/HAWQ-19 > Project: Apache HAWQ > Issue Type: Bug > Components: Catalog > Reporter: Feng Tian > Assignee: Ming LI > Fix For: 2.0.0.0-incubating > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)