{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-hawq/issues/323","repository_url":"https://api.github.com/repos/apache/incubator-hawq","labels_url":"https://api.github.com/repos/apache/incubator-hawq/issues/323/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-hawq/issues/323/comments","events_url":"https://api.github.com/repos/apache/incubator-hawq/issues/323/events","html_url":"https://github.com/apache/incubator-hawq/pull/323","id":130726925,"number":323,"title":"[HAWQ-19] Money type overflow fixed by back porting int64 support from Postgres commit 74a4019","user":{"login":"0x0FFF","id":1366872,"avatar_url":"https://avatars.githubusercontent.com/u/1366872?v=3","gravatar_id":"","url":"https://api.github.com/users/0x0FFF","html_url":"https://github.com/0x0FFF","followers_url":"https://api.github.com/users/0x0FFF/followers","following_url":"https://api.github.com/users/0x0FFF/following{/other_user}","gists_url":"https://api.github.com/users/0x0FFF/gists{/gist_id}","starred_url":"https://api.github.com/users/0x0FFF/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/0x0FFF/subscriptions","organizations_url":"https://api.github.com/users/0x0FFF/orgs","repos_url":"https://api.github.com/users/0x0FFF/repos","events_url":"https://api.github.com/users/0x0FFF/events{/privacy}","received_events_url":"https://api.github.com/users/0x0FFF/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-02-02T16:01:18Z","updated_at":"2016-02-02T18:06:07Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/incubator-hawq/pulls/323","html_url":"https://github.com/apache/incubator-hawq/pull/323","diff_url":"https://github.com/apache/incubator-hawq/pull/323.diff","patch_url":"https://github.com/apache/incubator-hawq/pull/323.patch"},"body":"This commit fixes the issue [HAWQ-19](https://issues.apache.org/jira/browse/HAWQ-19) \"Money type overflow\" by back porting commit [74a4019](https://github.com/postgres/postgres/commit/74a40190aabd27b052ea7a63e93f7ed47743755d#diff-7ddd78dd264f8cf2a62cf572baf90b84) to HAWQ. Changes internal representation of \"money\" datatype, input function, cash_words function, adds function to multiply/divide cash by int8. Also changes pg_type to accommodate new internal representation\r\n\r\nBefore this commit:\r\n```\r\ntest=# select '$30000000'::money;\r\n      money      \r\n-----------------\r\n -$12,949,672.96\r\n(1 row)\r\n```\r\nAfter this commit:\r\n```\r\ntest=# select '$30000000'::money;\r\n     money      \r\n----------------\r\n $30,000,000.00\r\n(1 row)\r\n```"},"comment":{"url":"https://api.github.com/repos/apache/incubator-hawq/issues/comments/178726045","html_url":"https://github.com/apache/incubator-hawq/pull/323#issuecomment-178726045","issue_url":"https://api.github.com/repos/apache/incubator-hawq/issues/323","id":178726045,"user":{"login":"cwelton","id":411822,"avatar_url":"https://avatars.githubusercontent.com/u/411822?v=3","gravatar_id":"","url":"https://api.github.com/users/cwelton","html_url":"https://github.com/cwelton","followers_url":"https://api.github.com/users/cwelton/followers","following_url":"https://api.github.com/users/cwelton/following{/other_user}","gists_url":"https://api.github.com/users/cwelton/gists{/gist_id}","starred_url":"https://api.github.com/users/cwelton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cwelton/subscriptions","organizations_url":"https://api.github.com/users/cwelton/orgs","repos_url":"https://api.github.com/users/cwelton/repos","events_url":"https://api.github.com/users/cwelton/events{/privacy}","received_events_url":"https://api.github.com/users/cwelton/received_events","type":"User","site_admin":false},"created_at":"2016-02-02T18:06:07Z","updated_at":"2016-02-02T18:06:07Z","body":"This change as on disk format implications so we must also consider the impact on upgrade."}}