{"action":"created","issue":{"url":"https://api.github.com/repos/tootsuite/mastodon/issues/6837","repository_url":"https://api.github.com/repos/tootsuite/mastodon","labels_url":"https://api.github.com/repos/tootsuite/mastodon/issues/6837/labels{/name}","comments_url":"https://api.github.com/repos/tootsuite/mastodon/issues/6837/comments","events_url":"https://api.github.com/repos/tootsuite/mastodon/issues/6837/events","html_url":"https://github.com/tootsuite/mastodon/issues/6837","id":306607470,"number":6837,"title":"Usernames are case-sensitive on local database, but not on remote domain (even with the same id)","user":{"login":"trwnh","id":10606431,"avatar_url":"https://avatars2.githubusercontent.com/u/10606431?v=4","gravatar_id":"","url":"https://api.github.com/users/trwnh","html_url":"https://github.com/trwnh","followers_url":"https://api.github.com/users/trwnh/followers","following_url":"https://api.github.com/users/trwnh/following{/other_user}","gists_url":"https://api.github.com/users/trwnh/gists{/gist_id}","starred_url":"https://api.github.com/users/trwnh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trwnh/subscriptions","organizations_url":"https://api.github.com/users/trwnh/orgs","repos_url":"https://api.github.com/users/trwnh/repos","events_url":"https://api.github.com/users/trwnh/events{/privacy}","received_events_url":"https://api.github.com/users/trwnh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":19,"created_at":"2018-03-19T19:45:45Z","updated_at":"2018-05-16T13:52:33Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Earlier today, Krita made an account on mastodon.art, and I followed `@krita@mastodon.art` from `mastodon.social`. The account followed me back. But later in my home column, I see a boost from `@Krita@mastodon.art`, and attempting to load it in the webapp seems to be treating it as a different account that is neither following me nor am I following it. However, loading the profile URLs `mastodon.art/@krita` or `mastodon.art/@Krita` both resolve to the same account. \r\n\r\nkrita in webapp: \r\n![chrome_2018-03-19_14-38-25](https://user-images.githubusercontent.com/10606431/37618339-f87b1678-2b83-11e8-89da-d59bad4ab96f.png)\r\n\r\nKrita in webapp\r\n![chrome_2018-03-19_14-38-40](https://user-images.githubusercontent.com/10606431/37618367-0b49c448-2b84-11e8-9439-496a79892712.png)\r\n\r\nkrita in profile\r\n![chrome_2018-03-19_14-37-49](https://user-images.githubusercontent.com/10606431/37618408-28c83fea-2b84-11e8-9526-27680c2dc7b7.png)\r\n\r\nKrita in profile\r\n![chrome_2018-03-19_14-37-55](https://user-images.githubusercontent.com/10606431/37618418-2f00864c-2b84-11e8-96b3-1008ae47e4bc.png)\r\n\r\n* * * *\r\n\r\n- [x] I searched or browsed the repo’s other issues to ensure this is not a duplicate.\r\n- [x] This bug happens on a [tagged release](https://github.com/tootsuite/mastodon/releases) and not on `master` (If you're a user, don't worry about this).\r\n"},"comment":{"url":"https://api.github.com/repos/tootsuite/mastodon/issues/comments/389526240","html_url":"https://github.com/tootsuite/mastodon/issues/6837#issuecomment-389526240","issue_url":"https://api.github.com/repos/tootsuite/mastodon/issues/6837","id":389526240,"user":{"login":"Gargron","id":184731,"avatar_url":"https://avatars3.githubusercontent.com/u/184731?v=4","gravatar_id":"","url":"https://api.github.com/users/Gargron","html_url":"https://github.com/Gargron","followers_url":"https://api.github.com/users/Gargron/followers","following_url":"https://api.github.com/users/Gargron/following{/other_user}","gists_url":"https://api.github.com/users/Gargron/gists{/gist_id}","starred_url":"https://api.github.com/users/Gargron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gargron/subscriptions","organizations_url":"https://api.github.com/users/Gargron/orgs","repos_url":"https://api.github.com/users/Gargron/repos","events_url":"https://api.github.com/users/Gargron/events{/privacy}","received_events_url":"https://api.github.com/users/Gargron/received_events","type":"User","site_admin":false},"created_at":"2018-05-16T13:52:33Z","updated_at":"2018-05-16T13:52:33Z","author_association":"MEMBER","body":"Scrolling up I'm not seeing if I described it anywhere but the actual issue that there exists a case-insensitive index on the username/domain tuple but it's a non-unique index for some reason (mistake). There exists a case-*sensitive* unique index on the same table as well. It's a mistake."}}
{"actor":{"display_login":"Gargron"}}