{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/6034","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/6034/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/6034/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/6034/events","html_url":"https://github.com/influxdata/influxdb/issues/6034","id":141385486,"number":6034,"title":"empty query result in version 0.11.0rc1","user":{"login":"r0bj","id":1297747,"avatar_url":"https://avatars.githubusercontent.com/u/1297747?v=3","gravatar_id":"","url":"https://api.github.com/users/r0bj","html_url":"https://github.com/r0bj","followers_url":"https://api.github.com/users/r0bj/followers","following_url":"https://api.github.com/users/r0bj/following{/other_user}","gists_url":"https://api.github.com/users/r0bj/gists{/gist_id}","starred_url":"https://api.github.com/users/r0bj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r0bj/subscriptions","organizations_url":"https://api.github.com/users/r0bj/orgs","repos_url":"https://api.github.com/users/r0bj/repos","events_url":"https://api.github.com/users/r0bj/events{/privacy}","received_events_url":"https://api.github.com/users/r0bj/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/influxdata/influxdb/labels/category/queries","name":"category/queries","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"jsternberg","id":1212129,"avatar_url":"https://avatars.githubusercontent.com/u/1212129?v=3","gravatar_id":"","url":"https://api.github.com/users/jsternberg","html_url":"https://github.com/jsternberg","followers_url":"https://api.github.com/users/jsternberg/followers","following_url":"https://api.github.com/users/jsternberg/following{/other_user}","gists_url":"https://api.github.com/users/jsternberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jsternberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsternberg/subscriptions","organizations_url":"https://api.github.com/users/jsternberg/orgs","repos_url":"https://api.github.com/users/jsternberg/repos","events_url":"https://api.github.com/users/jsternberg/events{/privacy}","received_events_url":"https://api.github.com/users/jsternberg/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/influxdata/influxdb/milestones/46","html_url":"https://github.com/influxdata/influxdb/milestones/0.11.0","labels_url":"https://api.github.com/repos/influxdata/influxdb/milestones/46/labels","id":1559540,"number":46,"title":"0.11.0","description":"","creator":{"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},"open_issues":1,"closed_issues":127,"state":"open","created_at":"2016-02-02T20:50:35Z","updated_at":"2016-03-16T20:33:31Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-03-16T19:59:01Z","updated_at":"2016-03-16T20:57:11Z","closed_at":null,"body":"influxdb 0.10.3:\r\n```\r\n> SELECT io_time FROM diskio WHERE \"host\" = 'vmhost-r49' AND \"name\" = 'sda' AND time > now() - 3m limit 3\r\nname: diskio\r\n------------\r\ntime\t\t\tio_time\r\n1458157819000000000\t1115096\r\n1458157829000000000\t1115096\r\n1458157839000000000\t1117576\r\n```\r\n\r\ninfluxdb 0.11.0rc1:\r\n```\r\n> SELECT io_time FROM diskio WHERE \"host\" = 'devhost-p3' AND \"name\" = 'sda' AND time > now() - 3m limit 3\r\n```\r\nempty result\r\n\r\nData actually is there:\r\n```\r\n> SELECT * FROM diskio WHERE \"host\" = 'devhost-p3' AND time > now() - 3m limit 3\r\nname: diskio\r\n------------\r\n1458157955000000000\tPOZ\tdev\tdevhost-p3\t488504\tdm-2\t17029354496\t223480\t\t926521\tunknown\t\t\t\t\t82550124544\t22913756\t2172201\r\n1458157955000000000\tPOZ\tdev\tdevhost-p3\t500344\tsda\t17330686976\t230360\t\t946457\t360030480064cc100187f20151596a28f\t83924434944\t22942752\t2100230\r\n1458157955000000000\tPOZ\tdev\tdevhost-p3\t132\tsda1\t3203072\t\t132\t\t782\t360030480064cc100187f20151596a28f\t0\t\t0\t\t0\r\n```\r\n\r\nSo adding `\"name\" = 'sda'` cause empty result."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/197546336","html_url":"https://github.com/influxdata/influxdb/issues/6034#issuecomment-197546336","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/6034","id":197546336,"user":{"login":"jsternberg","id":1212129,"avatar_url":"https://avatars.githubusercontent.com/u/1212129?v=3","gravatar_id":"","url":"https://api.github.com/users/jsternberg","html_url":"https://github.com/jsternberg","followers_url":"https://api.github.com/users/jsternberg/followers","following_url":"https://api.github.com/users/jsternberg/following{/other_user}","gists_url":"https://api.github.com/users/jsternberg/gists{/gist_id}","starred_url":"https://api.github.com/users/jsternberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsternberg/subscriptions","organizations_url":"https://api.github.com/users/jsternberg/orgs","repos_url":"https://api.github.com/users/jsternberg/repos","events_url":"https://api.github.com/users/jsternberg/events{/privacy}","received_events_url":"https://api.github.com/users/jsternberg/received_events","type":"User","site_admin":false},"created_at":"2016-03-16T20:57:11Z","updated_at":"2016-03-16T20:57:11Z","body":"Caused by 41dde61. @benbjohnson I think the easiest way to tackle this is to modify the series key used here to `_name` similar to what's done with `SHOW TAG VALUES` and make `SHOW SERIES` use `_name` as the condition instead of `name`.\r\n\r\nI'll try to put up a PR soon for how I envision it being done."}}