{"action":"created","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/3000","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/3000/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/3000/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/3000/events","html_url":"https://github.com/influxdb/influxdb/issues/3000","id":88737367,"number":3000,"title":"Problem with simple arithmetic expressions on integers","user":{"login":"bblodfon","id":10909555,"avatar_url":"https://avatars.githubusercontent.com/u/10909555?v=3","gravatar_id":"","url":"https://api.github.com/users/bblodfon","html_url":"https://github.com/bblodfon","followers_url":"https://api.github.com/users/bblodfon/followers","following_url":"https://api.github.com/users/bblodfon/following{/other_user}","gists_url":"https://api.github.com/users/bblodfon/gists{/gist_id}","starred_url":"https://api.github.com/users/bblodfon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bblodfon/subscriptions","organizations_url":"https://api.github.com/users/bblodfon/orgs","repos_url":"https://api.github.com/users/bblodfon/repos","events_url":"https://api.github.com/users/bblodfon/events{/privacy}","received_events_url":"https://api.github.com/users/bblodfon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdb/influxdb/labels/category/queries","name":"category/queries","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/influxdb/influxdb/milestones/40","html_url":"https://github.com/influxdb/influxdb/milestones/0.9.1","labels_url":"https://api.github.com/repos/influxdb/influxdb/milestones/40/labels","id":1101424,"number":40,"title":"0.9.1","description":"","creator":{"login":"toddboom","id":53132,"avatar_url":"https://avatars.githubusercontent.com/u/53132?v=3","gravatar_id":"","url":"https://api.github.com/users/toddboom","html_url":"https://github.com/toddboom","followers_url":"https://api.github.com/users/toddboom/followers","following_url":"https://api.github.com/users/toddboom/following{/other_user}","gists_url":"https://api.github.com/users/toddboom/gists{/gist_id}","starred_url":"https://api.github.com/users/toddboom/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toddboom/subscriptions","organizations_url":"https://api.github.com/users/toddboom/orgs","repos_url":"https://api.github.com/users/toddboom/repos","events_url":"https://api.github.com/users/toddboom/events{/privacy}","received_events_url":"https://api.github.com/users/toddboom/received_events","type":"User","site_admin":false},"open_issues":44,"closed_issues":28,"state":"open","created_at":"2015-05-08T06:32:29Z","updated_at":"2015-06-16T23:33:52Z","due_on":"2015-07-22T07:00:00Z","closed_at":null},"comments":2,"created_at":"2015-06-16T14:01:47Z","updated_at":"2015-06-16T23:41:18Z","closed_at":null,"body":"Hi,\r\n\r\nIn influxdb 0.9.0, I have inserted many cpu data data like this:\r\ncurl -i -XPOST 'http://localhost:8086/write?db=stats&precision=u' -d 'cpu_user value=32.9 1434383413397157'\r\nand many memory data (value is in bytes) like this:\r\ncurl -i -XPOST 'http://localhost:8086/write?db=stats&precision=u' -d 'available_memory value=38744784896 1434383413397213'\r\n\r\nInside the CLI, when I query:\r\nselect value, 2*value from cpu_user\r\nI get the results:\r\n2015-06-16T07:55:33.199964Z\t18       36\r\n2015-06-16T07:56:34.524977Z\t19.1    38.2\r\n... (all OK)\r\n\r\nbut when I query the other measurement, the arithmetic expression (2*value) becomes null:\r\nselect value, value/2 from available_memory\r\n2015-06-16T07:51:27.876727Z\t44327944192\r\n2015-06-16T07:52:29.205774Z\t44333027328\r\n\r\nIs this a limitation of the current version?\r\n"},"comment":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/comments/112603697","html_url":"https://github.com/influxdb/influxdb/issues/3000#issuecomment-112603697","issue_url":"https://api.github.com/repos/influxdb/influxdb/issues/3000","id":112603697,"user":{"login":"bblodfon","id":10909555,"avatar_url":"https://avatars.githubusercontent.com/u/10909555?v=3","gravatar_id":"","url":"https://api.github.com/users/bblodfon","html_url":"https://github.com/bblodfon","followers_url":"https://api.github.com/users/bblodfon/followers","following_url":"https://api.github.com/users/bblodfon/following{/other_user}","gists_url":"https://api.github.com/users/bblodfon/gists{/gist_id}","starred_url":"https://api.github.com/users/bblodfon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bblodfon/subscriptions","organizations_url":"https://api.github.com/users/bblodfon/orgs","repos_url":"https://api.github.com/users/bblodfon/repos","events_url":"https://api.github.com/users/bblodfon/events{/privacy}","received_events_url":"https://api.github.com/users/bblodfon/received_events","type":"User","site_admin":false},"created_at":"2015-06-16T23:41:18Z","updated_at":"2015-06-16T23:41:18Z","body":"Hi @beckettsean, no errors in the CLI or logs: the values are just nullified only that I can see...the thing is why influxdb puts a number like 34 as int64 and not one like 326723166323 - which has 12 digits and I believe it is inside the range of int64! I mean as you saw from above, I insert no floats at all!"}}