{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/7562","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/7562/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/7562/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/7562/events","html_url":"https://github.com/influxdata/influxdb/issues/7562","id":186660407,"number":7562,"title":"Feature-Request: Allow type casts from boolean to int/float (0/1)","user":{"login":"Apollon77","id":11976694,"avatar_url":"https://avatars.githubusercontent.com/u/11976694?v=3","gravatar_id":"","url":"https://api.github.com/users/Apollon77","html_url":"https://github.com/Apollon77","followers_url":"https://api.github.com/users/Apollon77/followers","following_url":"https://api.github.com/users/Apollon77/following{/other_user}","gists_url":"https://api.github.com/users/Apollon77/gists{/gist_id}","starred_url":"https://api.github.com/users/Apollon77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Apollon77/subscriptions","organizations_url":"https://api.github.com/users/Apollon77/orgs","repos_url":"https://api.github.com/users/Apollon77/repos","events_url":"https://api.github.com/users/Apollon77/events{/privacy}","received_events_url":"https://api.github.com/users/Apollon77/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-01T22:02:41Z","updated_at":"2016-11-02T02:43:40Z","closed_at":"2016-11-02T02:43:40Z","body":"__Proposal:__\r\nAllow type casts from boolean fields to int/float and convert true to 1 and false to 0. At leas in queries.\r\nIf it really make sense to also support that automatically on \"insert type conflicts\" (e.g. if field is boolean but value is 0/1 then store as boolean instead of returning a write error and the other way around) may be a bigger question :-)\r\n\r\n__Current behavior:__\r\nType casts are only done currently  between int and float fields.\r\n\r\nMany systems do not really distinguish between int and boolean and 0/1 is often used in a boolean meaning. If you do not take care it can end up in mixtures between 0/1 and false/true, maybe also in the same measurement. When mixed in same measurement it comes to weired effects when querying ... when mixing shards with different types only some values are shown and else \"empty values\" which is very confusing (I needed 1h to come to the clue that this happened) ..."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/257757275","html_url":"https://github.com/influxdata/influxdb/issues/7562#issuecomment-257757275","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/7562","id":257757275,"user":{"login":"jwilder","id":219935,"avatar_url":"https://avatars.githubusercontent.com/u/219935?v=3","gravatar_id":"","url":"https://api.github.com/users/jwilder","html_url":"https://github.com/jwilder","followers_url":"https://api.github.com/users/jwilder/followers","following_url":"https://api.github.com/users/jwilder/following{/other_user}","gists_url":"https://api.github.com/users/jwilder/gists{/gist_id}","starred_url":"https://api.github.com/users/jwilder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwilder/subscriptions","organizations_url":"https://api.github.com/users/jwilder/orgs","repos_url":"https://api.github.com/users/jwilder/repos","events_url":"https://api.github.com/users/jwilder/events{/privacy}","received_events_url":"https://api.github.com/users/jwilder/received_events","type":"User","site_admin":false},"created_at":"2016-11-02T02:43:39Z","updated_at":"2016-11-02T02:43:39Z","body":"Moved to #5930 which consolidates many query language feature requests."}}
{"actor":{"display_login":"jwilder"}}