{"action":"created","issue":{"url":"https://api.github.com/repos/FINRAOS/DataGenerator/issues/270","labels_url":"https://api.github.com/repos/FINRAOS/DataGenerator/issues/270/labels{/name}","comments_url":"https://api.github.com/repos/FINRAOS/DataGenerator/issues/270/comments","events_url":"https://api.github.com/repos/FINRAOS/DataGenerator/issues/270/events","html_url":"https://github.com/FINRAOS/DataGenerator/issues/270","id":125850792,"number":270,"title":"The %number macro does not interpret (precision, scale) consistent with ANSI SQL","user":{"login":"jeanmusinski","id":12383588,"avatar_url":"https://avatars.githubusercontent.com/u/12383588?v=3","gravatar_id":"","url":"https://api.github.com/users/jeanmusinski","html_url":"https://github.com/jeanmusinski","followers_url":"https://api.github.com/users/jeanmusinski/followers","following_url":"https://api.github.com/users/jeanmusinski/following{/other_user}","gists_url":"https://api.github.com/users/jeanmusinski/gists{/gist_id}","starred_url":"https://api.github.com/users/jeanmusinski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeanmusinski/subscriptions","organizations_url":"https://api.github.com/users/jeanmusinski/orgs","repos_url":"https://api.github.com/users/jeanmusinski/repos","events_url":"https://api.github.com/users/jeanmusinski/events{/privacy}","received_events_url":"https://api.github.com/users/jeanmusinski/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-10T22:44:21Z","updated_at":"2016-01-15T14:45:58Z","closed_at":null,"body":"Precision is the total number of the digits in a number. Scale is the number of digits to the right of the decimal point.\r\n\r\nIn dg-example-default, samplemachine.xml defines var_2_6 as expr=\"%number(5,2)\". DG generates values such as 85829.40 and 61140.01. To be consistent with the ANSI definition, the generated values should be like 858.29 and 611.40 "},"comment":{"url":"https://api.github.com/repos/FINRAOS/DataGenerator/issues/comments/171979037","html_url":"https://github.com/FINRAOS/DataGenerator/issues/270#issuecomment-171979037","issue_url":"https://api.github.com/repos/FINRAOS/DataGenerator/issues/270","id":171979037,"user":{"login":"mibrahim","id":408342,"avatar_url":"https://avatars.githubusercontent.com/u/408342?v=3","gravatar_id":"","url":"https://api.github.com/users/mibrahim","html_url":"https://github.com/mibrahim","followers_url":"https://api.github.com/users/mibrahim/followers","following_url":"https://api.github.com/users/mibrahim/following{/other_user}","gists_url":"https://api.github.com/users/mibrahim/gists{/gist_id}","starred_url":"https://api.github.com/users/mibrahim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mibrahim/subscriptions","organizations_url":"https://api.github.com/users/mibrahim/orgs","repos_url":"https://api.github.com/users/mibrahim/repos","events_url":"https://api.github.com/users/mibrahim/events{/privacy}","received_events_url":"https://api.github.com/users/mibrahim/received_events","type":"User","site_admin":false},"created_at":"2016-01-15T14:45:58Z","updated_at":"2016-01-15T14:45:58Z","body":"Tasks:\r\n1. Update the docs at https://github.com/FINRAOS/DataGenerator/blob/master/docs/transformers/EquivalenceClass.rst\r\n2. @leeny34 update the implementation of number to reflect the correct interpretation of precision / scale\r\n\r\nReferences:\r\nhttps://docs.oracle.com/javase/7/docs/api/java/math/BigDecimal.html\r\nhttps://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Decimals"}}