{"action":"closed","issue":{"url":"https://api.github.com/repos/viadee/sonarQuest/issues/162","repository_url":"https://api.github.com/repos/viadee/sonarQuest","labels_url":"https://api.github.com/repos/viadee/sonarQuest/issues/162/labels{/name}","comments_url":"https://api.github.com/repos/viadee/sonarQuest/issues/162/comments","events_url":"https://api.github.com/repos/viadee/sonarQuest/issues/162/events","html_url":"https://github.com/viadee/sonarQuest/issues/162","id":385375656,"node_id":"MDU6SXNzdWUzODUzNzU2NTY=","number":162,"title":"Column Task.task_key must be case sensitive","user":{"login":"aabeling","id":897641,"node_id":"MDQ6VXNlcjg5NzY0MQ==","avatar_url":"https://avatars1.githubusercontent.com/u/897641?v=4","gravatar_id":"","url":"https://api.github.com/users/aabeling","html_url":"https://github.com/aabeling","followers_url":"https://api.github.com/users/aabeling/followers","following_url":"https://api.github.com/users/aabeling/following{/other_user}","gists_url":"https://api.github.com/users/aabeling/gists{/gist_id}","starred_url":"https://api.github.com/users/aabeling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aabeling/subscriptions","organizations_url":"https://api.github.com/users/aabeling/orgs","repos_url":"https://api.github.com/users/aabeling/repos","events_url":"https://api.github.com/users/aabeling/events{/privacy}","received_events_url":"https://api.github.com/users/aabeling/received_events","type":"User","site_admin":false},"labels":[{"id":673225769,"node_id":"MDU6TGFiZWw2NzMyMjU3Njk=","url":"https://api.github.com/repos/viadee/sonarQuest/labels/bug","name":"bug","color":"ee0701","default":true},{"id":914863706,"node_id":"MDU6TGFiZWw5MTQ4NjM3MDY=","url":"https://api.github.com/repos/viadee/sonarQuest/labels/priority","name":"priority","color":"fbca04","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2018-11-28T17:21:55Z","updated_at":"2018-12-17T06:52:01Z","closed_at":"2018-12-17T06:52:00Z","author_association":"CONTRIBUTOR","body":"We are storing the data in a mysql database.\r\nWhile updating the tasks in sonarquest with the tasks from sonarqube we got a NonUniqueResultException\r\nbecause the search for an existing task by key with value \"AWc3A2KEoXX3DuVBrVTc\" produced two results: one with \r\nAWc3A2KEoXX3DuVBrVTc\r\nand the other one with\r\nAWc3A2KEoXX3DuVBrVTC\r\n\r\nI was able to fix that in our mysql by\r\n\r\n     alter table Task modify task_key varchar(256) character set binary\r\n\r\nbut I am not sure if that is the best solution.\r\nThis is mysql-specific, I think.\r\nHow can this be included in the flyway scripts?"}}
{"actor":{"display_login":"Christoph-Meyer"}}