You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hawq.apache.org by "Yi Jin (JIRA)" <ji...@apache.org> on 2015/10/02 13:33:26 UTC

[jira] [Commented] (HAWQ-19) Money type overflow

    [ https://issues.apache.org/jira/browse/HAWQ-19?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14941037#comment-14941037 ] 

Yi Jin commented on HAWQ-19:
----------------------------

Test this comment here. By Yi

> Money type overflow
> -------------------
>
>                 Key: HAWQ-19
>                 URL: https://issues.apache.org/jira/browse/HAWQ-19
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: core
>            Reporter: Feng Tian
>            Assignee: Lei Chang
>
> 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)