{"action":"opened","issue":{"url":"https://api.github.com/repos/codeschool/sqlite-parser/issues/39","repository_url":"https://api.github.com/repos/codeschool/sqlite-parser","labels_url":"https://api.github.com/repos/codeschool/sqlite-parser/issues/39/labels{/name}","comments_url":"https://api.github.com/repos/codeschool/sqlite-parser/issues/39/comments","events_url":"https://api.github.com/repos/codeschool/sqlite-parser/issues/39/events","html_url":"https://github.com/codeschool/sqlite-parser/issues/39","id":188985823,"number":39,"title":"Trailing spaces in table or column names deleted","user":{"login":"kibtidec","id":23402159,"avatar_url":"https://avatars.githubusercontent.com/u/23402159?v=3","gravatar_id":"","url":"https://api.github.com/users/kibtidec","html_url":"https://github.com/kibtidec","followers_url":"https://api.github.com/users/kibtidec/followers","following_url":"https://api.github.com/users/kibtidec/following{/other_user}","gists_url":"https://api.github.com/users/kibtidec/gists{/gist_id}","starred_url":"https://api.github.com/users/kibtidec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kibtidec/subscriptions","organizations_url":"https://api.github.com/users/kibtidec/orgs","repos_url":"https://api.github.com/users/kibtidec/repos","events_url":"https://api.github.com/users/kibtidec/events{/privacy}","received_events_url":"https://api.github.com/users/kibtidec/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-13T18:32:26Z","updated_at":"2016-11-13T18:32:26Z","closed_at":null,"body":"It's probably more an academic problem than a real life issue ... trailing spaces from table or column names do not make it into the AST, e.g.\r\n\r\n```\r\nselect \"a \" from \"b \"\r\n```\r\n\r\nleads to\r\n\r\n```\r\n{\r\n  \"type\": \"statement\",\r\n  \"variant\": \"list\",\r\n  \"statement\": [\r\n    {\r\n      \"type\": \"statement\",\r\n      \"variant\": \"select\",\r\n      \"result\": [\r\n        {\r\n          \"type\": \"identifier\",\r\n          \"variant\": \"column\",\r\n          \"name\": \"a\"\r\n        }\r\n      ],\r\n      \"from\": {\r\n        \"type\": \"identifier\",\r\n        \"variant\": \"table\",\r\n        \"name\": \"b\"\r\n      }\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\nAlthough it doesn't make too much sense to define identifiers with trailing spaces it works in sqlite, therefore the created AST should reflect this."}}
{"actor":{"display_login":"kibtidec"}}