{"action":"created","issue":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2105","labels_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2105/labels{/name}","comments_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2105/comments","events_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2105/events","html_url":"https://github.com/sequelpro/sequelpro/issues/2105","id":70506015,"number":2105,"title":"Sequel Pro badly trips over columns with backtick (`) in name","user":{"login":"dmoagx","id":5793864,"avatar_url":"https://avatars.githubusercontent.com/u/5793864?v=3","gravatar_id":"","url":"https://api.github.com/users/dmoagx","html_url":"https://github.com/dmoagx","followers_url":"https://api.github.com/users/dmoagx/followers","following_url":"https://api.github.com/users/dmoagx/following{/other_user}","gists_url":"https://api.github.com/users/dmoagx/gists{/gist_id}","starred_url":"https://api.github.com/users/dmoagx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dmoagx/subscriptions","organizations_url":"https://api.github.com/users/dmoagx/orgs","repos_url":"https://api.github.com/users/dmoagx/repos","events_url":"https://api.github.com/users/dmoagx/events{/privacy}","received_events_url":"https://api.github.com/users/dmoagx/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sequelpro/sequelpro/labels/Bug","name":"Bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-04-23T20:28:54Z","updated_at":"2015-08-26T16:21:15Z","closed_at":null,"body":"A column named `` `strangename` `` (the backticks are part of the name!) is a valid name in MySQL (written as `` ` ` `strangename` ` ` `` - the spaces are only meant for GitHubs Markdown syntax) but Sequel Pro will error out on such a table and whats worse, will present an endless loop of warning messages when trying to view the table content."},"comment":{"url":"https://api.github.com/repos/sequelpro/sequelpro/issues/comments/135086410","html_url":"https://github.com/sequelpro/sequelpro/issues/2105#issuecomment-135086410","issue_url":"https://api.github.com/repos/sequelpro/sequelpro/issues/2105","id":135086410,"user":{"login":"nacho4d","id":111651,"avatar_url":"https://avatars.githubusercontent.com/u/111651?v=3","gravatar_id":"","url":"https://api.github.com/users/nacho4d","html_url":"https://github.com/nacho4d","followers_url":"https://api.github.com/users/nacho4d/followers","following_url":"https://api.github.com/users/nacho4d/following{/other_user}","gists_url":"https://api.github.com/users/nacho4d/gists{/gist_id}","starred_url":"https://api.github.com/users/nacho4d/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nacho4d/subscriptions","organizations_url":"https://api.github.com/users/nacho4d/orgs","repos_url":"https://api.github.com/users/nacho4d/repos","events_url":"https://api.github.com/users/nacho4d/events{/privacy}","received_events_url":"https://api.github.com/users/nacho4d/received_events","type":"User","site_admin":false},"created_at":"2015-08-26T16:21:15Z","updated_at":"2015-08-26T16:21:15Z","body":"@dmoagx  I have a question. What should be be output of \r\n\r\n    - (NSUInteger) firstOccurrenceOfCharacter:(unichar)character afterIndex:(NSInteger)startIndex skippingBrackets:(BOOL)skipBrackets ignoringQuotedStrings:(BOOL)ignoreQuotedStrings\r\n    \r\nwhen `string` is the first line of:\r\n\r\n    ```LastName``` varchar(255) DEFAULT NULL\r\n    01234567890123 ← These numbers are just for easy visual counting\r\n    \r\nwhen `character` is the quote, `startIndex` is -1, `skippingBrackets` is NO (but in this case we don't have brackets so its doesn't mather) and \r\n\r\n①. ignoreQuotedStrings is YES?\r\n\r\nShould it be 0? or 2?\r\n\r\n②. ignoreQuotedString is NO?\r\n\r\nShould it be 11? or 13?\r\n\r\nI think these answers will give me hints on what should be fixed. \r\n\r\n<hr/>\r\n\r\nI think the reason of this issue is a   \r\n\r\nA. missuse of this method. Or  \r\nB. perhaps the method does not fit this case.\r\n\r\n\r\nIf it is B then I would extract the column name\r\n\r\n    ``LastName``\r\n    \r\n with a new method that uses a regex and update the parser accordingly. Then unscape the result to:\r\n \r\n    `LastName`\r\n\r\nSo I can finally get the desired value.\r\n"}}