{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/6459","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/6459/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/6459/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/6459/events","html_url":"https://github.com/influxdata/influxdb/issues/6459","id":150677459,"number":6459,"title":"Where Clause doesn't work properly when you search a string tag","user":{"login":"saadusman17","id":2499742,"avatar_url":"https://avatars.githubusercontent.com/u/2499742?v=3","gravatar_id":"","url":"https://api.github.com/users/saadusman17","html_url":"https://github.com/saadusman17","followers_url":"https://api.github.com/users/saadusman17/followers","following_url":"https://api.github.com/users/saadusman17/following{/other_user}","gists_url":"https://api.github.com/users/saadusman17/gists{/gist_id}","starred_url":"https://api.github.com/users/saadusman17/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saadusman17/subscriptions","organizations_url":"https://api.github.com/users/saadusman17/orgs","repos_url":"https://api.github.com/users/saadusman17/repos","events_url":"https://api.github.com/users/saadusman17/events{/privacy}","received_events_url":"https://api.github.com/users/saadusman17/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":null,"comments":1,"created_at":"2016-04-24T16:17:15Z","updated_at":"2016-05-02T14:51:20Z","closed_at":null,"body":"### Bug report\r\n\r\n__System info:__ [Include InfluxDB version, operating system name, and other relevant details]\r\nLinux Mint 17.3 Cinnamon 64-bit\r\nInfluxDB shell 0.12.2\r\n\r\n__Steps to reproduce:__\r\n\r\nThe where clause sometimes returns no results even though it should. \r\n\r\n1. [First Step]\r\n\r\nEnter this data in the database\r\n\r\n```\r\nname: member_info\r\n-----------------\r\ntime\t\t\tclanRank\tclan_name\t\tclan_tag\tdonations\tdonationsReceived\texpLevel\tleague\t\tmember_name\tmember_tag\tpreviousClanRank\trole\ttrophies\r\n1461512944213232128\t35\t\t\"SkeletonFarmers\"\t\"#YPYR9GQY\"\t2680\t\t2188\t\t\t122\t\tGold League II\t\"sk\"\t\t\"#202GPUY8C\"\t44\t\t\tleader\t1638\r\n1461513001517127936\t35\t\t\"SkeletonFarmers\"\t\"#YPYR9GQY\"\t2680\t\t2188\t\t\t122\t\tGold League II\t\"sk\"\t\t\"#202GPUY8C\"\t44\t\t\tleader\t1638\r\n1461513009273016064\t35\t\t\"SkeletonFarmers\"\t\"#YPYR9GQY\"\t2680\t\t2188\t\t\t122\t\tGold League II\t\"sk\"\t\t\"#202GPUY8C\"\t44\t\t\tleader\t1638\r\n```\r\n\r\nAfter entering the data if I run \r\n```\r\n> select * from member_info where member_name = 'sk'\r\n```\r\nI get no response\r\n\r\nHowever, If I run \r\n```\r\n> select * from member_info where member_name =~ /sk/\r\n```\r\nI get full result \r\n\r\nAnd running this also results in all rows\r\n\r\n```\r\n> select * from member_info where member_name =~ /.*sk.*/\r\n```\r\n\r\n\r\nSo, seems like there is some problem in string matching when = is used in where_clause."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/216256373","html_url":"https://github.com/influxdata/influxdb/issues/6459#issuecomment-216256373","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/6459","id":216256373,"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-05-02T14:51:20Z","updated_at":"2016-05-02T14:51:20Z","body":"@saadusman17 can you convert the data you input into the line protocol? I'm unable to make a simple reproducer of what you did and reproduce your results. The data in line protocol format that I can send to `/write` would greatly help to allow me to try and reproduce the output.\r\n\r\nThanks!"}}