{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/15748","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/15748/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/15748/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/15748/events","html_url":"https://github.com/cockroachdb/cockroach/issues/15748","id":226879336,"number":15748,"title":"sql: jdbc DECIMAL wrong precision and scale","user":{"login":"arduanov","id":8693029,"avatar_url":"https://avatars0.githubusercontent.com/u/8693029?v=3","gravatar_id":"","url":"https://api.github.com/users/arduanov","html_url":"https://github.com/arduanov","followers_url":"https://api.github.com/users/arduanov/followers","following_url":"https://api.github.com/users/arduanov/following{/other_user}","gists_url":"https://api.github.com/users/arduanov/gists{/gist_id}","starred_url":"https://api.github.com/users/arduanov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arduanov/subscriptions","organizations_url":"https://api.github.com/users/arduanov/orgs","repos_url":"https://api.github.com/users/arduanov/repos","events_url":"https://api.github.com/users/arduanov/events{/privacy}","received_events_url":"https://api.github.com/users/arduanov/received_events","type":"User","site_admin":false},"labels":[{"id":514075047,"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/community-questions","name":"community-questions","color":"bfd4f2","default":false}],"state":"open","locked":false,"assignee":{"login":"mjibson","id":41181,"avatar_url":"https://avatars2.githubusercontent.com/u/41181?v=3","gravatar_id":"","url":"https://api.github.com/users/mjibson","html_url":"https://github.com/mjibson","followers_url":"https://api.github.com/users/mjibson/followers","following_url":"https://api.github.com/users/mjibson/following{/other_user}","gists_url":"https://api.github.com/users/mjibson/gists{/gist_id}","starred_url":"https://api.github.com/users/mjibson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjibson/subscriptions","organizations_url":"https://api.github.com/users/mjibson/orgs","repos_url":"https://api.github.com/users/mjibson/repos","events_url":"https://api.github.com/users/mjibson/events{/privacy}","received_events_url":"https://api.github.com/users/mjibson/received_events","type":"User","site_admin":false},"assignees":[{"login":"mjibson","id":41181,"avatar_url":"https://avatars2.githubusercontent.com/u/41181?v=3","gravatar_id":"","url":"https://api.github.com/users/mjibson","html_url":"https://github.com/mjibson","followers_url":"https://api.github.com/users/mjibson/followers","following_url":"https://api.github.com/users/mjibson/following{/other_user}","gists_url":"https://api.github.com/users/mjibson/gists{/gist_id}","starred_url":"https://api.github.com/users/mjibson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjibson/subscriptions","organizations_url":"https://api.github.com/users/mjibson/orgs","repos_url":"https://api.github.com/users/mjibson/repos","events_url":"https://api.github.com/users/mjibson/events{/privacy}","received_events_url":"https://api.github.com/users/mjibson/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2017-05-07T17:48:03Z","updated_at":"2017-05-09T18:46:21Z","closed_at":null,"body":"I use IDEA PHPStorm for test, but other java libs thru jdbc works exactly\r\n\r\n```CREATE TABLE test\r\n(\r\n    dec DECIMAL(2,1)\r\n);\r\n\r\ninsert into test VALUES (1);\r\n\r\nSELECT * from test;\r\n\r\n```\r\n\r\nResult\r\n\r\n```\r\n1.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\r\n```\r\n\r\nand jdbc generated DDL\r\n\r\n```\r\n-- auto-generated definition\r\ncreate table test\r\n(\r\n\tdec numeric(131089)\r\n)"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/300264557","html_url":"https://github.com/cockroachdb/cockroach/issues/15748#issuecomment-300264557","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/15748","id":300264557,"user":{"login":"jordanlewis","id":43821,"avatar_url":"https://avatars2.githubusercontent.com/u/43821?v=3","gravatar_id":"","url":"https://api.github.com/users/jordanlewis","html_url":"https://github.com/jordanlewis","followers_url":"https://api.github.com/users/jordanlewis/followers","following_url":"https://api.github.com/users/jordanlewis/following{/other_user}","gists_url":"https://api.github.com/users/jordanlewis/gists{/gist_id}","starred_url":"https://api.github.com/users/jordanlewis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jordanlewis/subscriptions","organizations_url":"https://api.github.com/users/jordanlewis/orgs","repos_url":"https://api.github.com/users/jordanlewis/repos","events_url":"https://api.github.com/users/jordanlewis/events{/privacy}","received_events_url":"https://api.github.com/users/jordanlewis/received_events","type":"User","site_admin":false},"created_at":"2017-05-09T18:46:20Z","updated_at":"2017-05-09T18:46:20Z","body":"@robert-s-lee, nice find! That's likely a different incompatibility than the one mentioned in the OP, though. The problem here seems to be a type mismatch in the output of `SUM`. Also, it looks like this only occurs over `pgwire`, as I can't repro via the sql shell, so it's probably an issue with our type hinting.\r\n\r\nCan you open a new issue to track this? Thanks!\r\n\r\nI agree with @mjibson that we need some more detail to solve the original issue."}}
{"actor":{"display_login":"jordanlewis"}}