{"action":"closed","issue":{"url":"https://api.github.com/repos/influxdb/influxdb/issues/1995","labels_url":"https://api.github.com/repos/influxdb/influxdb/issues/1995/labels{/name}","comments_url":"https://api.github.com/repos/influxdb/influxdb/issues/1995/comments","events_url":"https://api.github.com/repos/influxdb/influxdb/issues/1995/events","html_url":"https://github.com/influxdb/influxdb/issues/1995","id":62653057,"number":1995,"title":"Special Characters in INNER JOIN","user":{"login":"pedrojimenez","id":1044532,"avatar_url":"https://avatars.githubusercontent.com/u/1044532?v=3","gravatar_id":"","url":"https://api.github.com/users/pedrojimenez","html_url":"https://github.com/pedrojimenez","followers_url":"https://api.github.com/users/pedrojimenez/followers","following_url":"https://api.github.com/users/pedrojimenez/following{/other_user}","gists_url":"https://api.github.com/users/pedrojimenez/gists{/gist_id}","starred_url":"https://api.github.com/users/pedrojimenez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pedrojimenez/subscriptions","organizations_url":"https://api.github.com/users/pedrojimenez/orgs","repos_url":"https://api.github.com/users/pedrojimenez/repos","events_url":"https://api.github.com/users/pedrojimenez/events{/privacy}","received_events_url":"https://api.github.com/users/pedrojimenez/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-18T10:26:02Z","updated_at":"2015-03-18T14:31:56Z","closed_at":"2015-03-18T14:31:56Z","body":"Hi i have been looking for info about special characters in your Issues. I have found the #267 one and it is working perfectly in a select statement.\r\n\r\nI am using `influxdb 0.8.8` and the problematic is this:\r\n\r\nI want to SUM the values of several series to show a single value, i mean, 2 differents traffic_in series and show the sum value of both.\r\n\r\nI have found that when **forward slash** is contained in the interface name i can't perform the **inner join**. I will expose it with 2 examples:\r\n\r\nWorking Example:\r\n```\r\nselect s1.value + s2.value\r\nfrom \"device01.Traffic_GigabitEthernet0.GigabitEthernet0_traffic_in\" as s1\r\ninner join \"device01.Traffic_GigabitEthernet9.GigabitEthernet9_traffic_in\" as s2\r\nwhere time > now() -1h\r\n```\r\n\r\nNot Working Example:\r\n```\r\nselect s1.value + s2.value\r\nfrom \"device02.Traffic_GigabitEthernet0_1.GigabitEthernet0/1_traffic_in\" as s1\r\ninner join \"device02.Traffic_GigabitEthernet0_2.GigabitEthernet0/2_traffic_in\" as s2\r\nwhere time > now() -1h\r\n```\r\n\r\nThe query does not return a error message, just return nothing. I have added quotes to different parts of the query but nothing returned either.\r\n\r\nCould you help me ?"}}