[ https://issues.apache.org/jira/browse/HAWQ-19?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15374128#comment-15374128 ]
Vineet Goel commented on HAWQ-19: --------------------------------- [~liming01] and [~ftian] - does this JIRA need to be targeted for "2.0.0.0-incubating" release? If not, we should change the Fix Version to "backlog" or another release. Please update the JIRA Fix Version field soon so "2.0.0.0-incubating" is not blocked. > 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 > > > 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)