{"action":"closed","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1795","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1795/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1795/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/1795/events","html_url":"https://github.com/cockroachdb/cockroach/issues/1795","id":96939981,"number":1795,"title":"sql: investigate using arbitrary precision constants","user":{"login":"petermattis","id":6201335,"avatar_url":"https://avatars.githubusercontent.com/u/6201335?v=3","gravatar_id":"","url":"https://api.github.com/users/petermattis","html_url":"https://github.com/petermattis","followers_url":"https://api.github.com/users/petermattis/followers","following_url":"https://api.github.com/users/petermattis/following{/other_user}","gists_url":"https://api.github.com/users/petermattis/gists{/gist_id}","starred_url":"https://api.github.com/users/petermattis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermattis/subscriptions","organizations_url":"https://api.github.com/users/petermattis/orgs","repos_url":"https://api.github.com/users/petermattis/repos","events_url":"https://api.github.com/users/petermattis/events{/privacy}","received_events_url":"https://api.github.com/users/petermattis/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/cockroachdb/cockroach/labels/sql-semantics","name":"sql-semantics","color":"0052cc"}],"state":"closed","locked":false,"assignee":{"login":"nvanbenschoten","id":5438456,"avatar_url":"https://avatars.githubusercontent.com/u/5438456?v=3","gravatar_id":"","url":"https://api.github.com/users/nvanbenschoten","html_url":"https://github.com/nvanbenschoten","followers_url":"https://api.github.com/users/nvanbenschoten/followers","following_url":"https://api.github.com/users/nvanbenschoten/following{/other_user}","gists_url":"https://api.github.com/users/nvanbenschoten/gists{/gist_id}","starred_url":"https://api.github.com/users/nvanbenschoten/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvanbenschoten/subscriptions","organizations_url":"https://api.github.com/users/nvanbenschoten/orgs","repos_url":"https://api.github.com/users/nvanbenschoten/repos","events_url":"https://api.github.com/users/nvanbenschoten/events{/privacy}","received_events_url":"https://api.github.com/users/nvanbenschoten/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/4","html_url":"https://github.com/cockroachdb/cockroach/milestones/Q2","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/milestones/4/labels","id":1690471,"number":4,"title":"Q2","description":"","creator":{"login":"petermattis","id":6201335,"avatar_url":"https://avatars.githubusercontent.com/u/6201335?v=3","gravatar_id":"","url":"https://api.github.com/users/petermattis","html_url":"https://github.com/petermattis","followers_url":"https://api.github.com/users/petermattis/followers","following_url":"https://api.github.com/users/petermattis/following{/other_user}","gists_url":"https://api.github.com/users/petermattis/gists{/gist_id}","starred_url":"https://api.github.com/users/petermattis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/petermattis/subscriptions","organizations_url":"https://api.github.com/users/petermattis/orgs","repos_url":"https://api.github.com/users/petermattis/repos","events_url":"https://api.github.com/users/petermattis/events{/privacy}","received_events_url":"https://api.github.com/users/petermattis/received_events","type":"User","site_admin":false},"open_issues":96,"closed_issues":93,"state":"open","created_at":"2016-04-07T18:25:48Z","updated_at":"2016-05-16T19:43:10Z","due_on":"2016-06-30T04:00:00Z","closed_at":null},"comments":2,"created_at":"2015-07-24T01:23:02Z","updated_at":"2016-05-16T19:43:10Z","closed_at":"2016-05-16T19:43:10Z","body":"Currently, `SELECT 1 + 1.0` does not work because `1` is parsed as an int and `1.0` is parsed as a float and we disallow implicit conversions between int and float. An alternative is to borrow from the Go playbook and support arbitrary precision constants and allow implicit conversions of these constants and expressions involving them when the conversion does not lose precision. This would be quite a bit more involved than the current system, making this issue low priority. Can draw inspiration and ideas from https://godoc.org/golang.org/x/tools/go/exact."}}