{"action":"created","issue":{"url":"https://api.github.com/repos/thewca/worldcubeassociation.org/issues/2201","repository_url":"https://api.github.com/repos/thewca/worldcubeassociation.org","labels_url":"https://api.github.com/repos/thewca/worldcubeassociation.org/issues/2201/labels{/name}","comments_url":"https://api.github.com/repos/thewca/worldcubeassociation.org/issues/2201/comments","events_url":"https://api.github.com/repos/thewca/worldcubeassociation.org/issues/2201/events","html_url":"https://github.com/thewca/worldcubeassociation.org/issues/2201","id":276690611,"number":2201,"title":"Weirdness with the groupId column of our Scrambles table","user":{"login":"jfly","id":277474,"avatar_url":"https://avatars1.githubusercontent.com/u/277474?v=4","gravatar_id":"","url":"https://api.github.com/users/jfly","html_url":"https://github.com/jfly","followers_url":"https://api.github.com/users/jfly/followers","following_url":"https://api.github.com/users/jfly/following{/other_user}","gists_url":"https://api.github.com/users/jfly/gists{/gist_id}","starred_url":"https://api.github.com/users/jfly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfly/subscriptions","organizations_url":"https://api.github.com/users/jfly/orgs","repos_url":"https://api.github.com/users/jfly/repos","events_url":"https://api.github.com/users/jfly/events{/privacy}","received_events_url":"https://api.github.com/users/jfly/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-11-24T19:53:14Z","updated_at":"2017-11-27T19:21:54Z","closed_at":null,"author_association":"OWNER","body":"Here are the contents of an email I sent the WRT:\r\n\r\nWhile working on issue #2200, I discovered some strange looking groupIds in our database. See:\r\n\r\n```\r\nMariaDB [wca_development]> select distinct groupId from Scrambles where CAST(groupId AS BINARY) NOT REGEXP '^[A-Z]+$';\r\n+---------+\r\n| groupId |\r\n+---------+\r\n| Ext     |\r\n| Rou     |\r\n| Not     |\r\n| Fin     |\r\n| A -     |\r\n| Fir     |\r\n| Sec     |\r\n| 2       |\r\n| 3A      |\r\n| 2A      |\r\n| 1G      |\r\n+---------+\r\n11 rows in set (0.21 sec)\r\n```\r\n\r\nTNoodle should never generate groups with ids like \"Fin\", \"Ext\", or \"Not\". Do you have any idea what these groupIds mean? Here's the list of competitions that had these weird groupIds:\r\n\r\n```\r\nMariaDB [wca_development]> select distinct competitionId from Scrambles where CAST(groupId AS BINARY) NOT REGEXP '^[A-Z]+$';\r\n+--------------------------+\r\n| competitionId            |\r\n+--------------------------+\r\n| ClashOfCubersII2016      |\r\n| ClassicCitySummer2017    |\r\n| ClockNOtherStuff2016     |\r\n| LaFloridaOpen2015        |\r\n| MindanaoChampionship2016 |\r\n| OdessaOpen2017           |\r\n| TrondheimFall2014        |\r\n+--------------------------+\r\n7 rows in set (0.75 sec)\r\n```\r\n\r\nDo you know if there was any weirdness with the scrambles for these 7 competitions? I remember in the past we had to recover scrambles from a PDF file, so maybe there was some weirdness that resulted from that?\r\n"},"comment":{"url":"https://api.github.com/repos/thewca/worldcubeassociation.org/issues/comments/347295947","html_url":"https://github.com/thewca/worldcubeassociation.org/issues/2201#issuecomment-347295947","issue_url":"https://api.github.com/repos/thewca/worldcubeassociation.org/issues/2201","id":347295947,"user":{"login":"jfly","id":277474,"avatar_url":"https://avatars1.githubusercontent.com/u/277474?v=4","gravatar_id":"","url":"https://api.github.com/users/jfly","html_url":"https://github.com/jfly","followers_url":"https://api.github.com/users/jfly/followers","following_url":"https://api.github.com/users/jfly/following{/other_user}","gists_url":"https://api.github.com/users/jfly/gists{/gist_id}","starred_url":"https://api.github.com/users/jfly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jfly/subscriptions","organizations_url":"https://api.github.com/users/jfly/orgs","repos_url":"https://api.github.com/users/jfly/repos","events_url":"https://api.github.com/users/jfly/events{/privacy}","received_events_url":"https://api.github.com/users/jfly/received_events","type":"User","site_admin":false},"created_at":"2017-11-27T19:21:54Z","updated_at":"2017-11-27T19:21:54Z","author_association":"OWNER","body":"The workbook assistant allows setting arbitrary strings for group names, so these all probably came from humans messing around in the WA. \r\n\r\nAs part of fixing this, we could consider adding a check in our results uploading scripts for group names that do not match regex `[A-Z]+`. We could also check for gaps such that (A, B, D, E, ...) is not allowed"}}
{"actor":{"display_login":"jfly"}}