{"action":"created","issue":{"url":"https://api.github.com/repos/xbmc/xbmc/issues/7048","labels_url":"https://api.github.com/repos/xbmc/xbmc/issues/7048/labels{/name}","comments_url":"https://api.github.com/repos/xbmc/xbmc/issues/7048/comments","events_url":"https://api.github.com/repos/xbmc/xbmc/issues/7048/events","html_url":"https://github.com/xbmc/xbmc/pull/7048","id":72754284,"number":7048,"title":"videodb: Don't allow column value length to exceed key size of unique in...","user":{"login":"MilhouseVH","id":805038,"avatar_url":"https://avatars.githubusercontent.com/u/805038?v=3","gravatar_id":"","url":"https://api.github.com/users/MilhouseVH","html_url":"https://github.com/MilhouseVH","followers_url":"https://api.github.com/users/MilhouseVH/followers","following_url":"https://api.github.com/users/MilhouseVH/following{/other_user}","gists_url":"https://api.github.com/users/MilhouseVH/gists{/gist_id}","starred_url":"https://api.github.com/users/MilhouseVH/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MilhouseVH/subscriptions","organizations_url":"https://api.github.com/users/MilhouseVH/orgs","repos_url":"https://api.github.com/users/MilhouseVH/repos","events_url":"https://api.github.com/users/MilhouseVH/events{/privacy}","received_events_url":"https://api.github.com/users/MilhouseVH/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-05-03T05:46:31Z","updated_at":"2015-05-13T02:14:57Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/xbmc/xbmc/pulls/7048","html_url":"https://github.com/xbmc/xbmc/pull/7048","diff_url":"https://github.com/xbmc/xbmc/pull/7048.diff","patch_url":"https://github.com/xbmc/xbmc/pull/7048.patch"},"body":"...dex\r\n\r\nSee https://github.com/xbmc/xbmc/pull/6020#issuecomment-98433699\r\n\r\nWe need to prevent the names of actors exceeding the length of the unique index that will exist on the actor table, otherwise this could result in duplicates where two or more rows match for the key size of the unique index, while being different values when compared in their entirety. This can and does break a v90 to v92 db migration.\r\n\r\n~~Bump videodb schema to v93 and truncate any actors in a v92 db that may already exceed the new name length limit.~~"},"comment":{"url":"https://api.github.com/repos/xbmc/xbmc/issues/comments/101483620","html_url":"https://github.com/xbmc/xbmc/pull/7048#issuecomment-101483620","issue_url":"https://api.github.com/repos/xbmc/xbmc/issues/7048","id":101483620,"user":{"login":"MilhouseVH","id":805038,"avatar_url":"https://avatars.githubusercontent.com/u/805038?v=3","gravatar_id":"","url":"https://api.github.com/users/MilhouseVH","html_url":"https://github.com/MilhouseVH","followers_url":"https://api.github.com/users/MilhouseVH/followers","following_url":"https://api.github.com/users/MilhouseVH/following{/other_user}","gists_url":"https://api.github.com/users/MilhouseVH/gists{/gist_id}","starred_url":"https://api.github.com/users/MilhouseVH/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MilhouseVH/subscriptions","organizations_url":"https://api.github.com/users/MilhouseVH/orgs","repos_url":"https://api.github.com/users/MilhouseVH/repos","events_url":"https://api.github.com/users/MilhouseVH/events{/privacy}","received_events_url":"https://api.github.com/users/MilhouseVH/received_events","type":"User","site_admin":false},"created_at":"2015-05-13T02:14:57Z","updated_at":"2015-05-13T02:14:57Z","body":"There's yet another fricking corner case that needs fixing.\r\n\r\nPlease read my [thread post](http://forum.kodi.tv/showthread.php?tid=223165&pid=2003003#pid2003003) - if you agree the `DISTINCT` statements are required I'll create a new PR that adds them, or I could roll it into this PR as it's still open..."}}