{"action":"created","issue":{"url":"https://api.github.com/repos/neos/flow-development-collection/issues/415","repository_url":"https://api.github.com/repos/neos/flow-development-collection","labels_url":"https://api.github.com/repos/neos/flow-development-collection/issues/415/labels{/name}","comments_url":"https://api.github.com/repos/neos/flow-development-collection/issues/415/comments","events_url":"https://api.github.com/repos/neos/flow-development-collection/issues/415/events","html_url":"https://github.com/neos/flow-development-collection/pull/415","id":169645998,"number":415,"title":"!!!TASK: Implicit joins in a query makes the result set distinct by default","user":{"login":"albe","id":4259532,"avatar_url":"https://avatars.githubusercontent.com/u/4259532?v=3","gravatar_id":"","url":"https://api.github.com/users/albe","html_url":"https://github.com/albe","followers_url":"https://api.github.com/users/albe/followers","following_url":"https://api.github.com/users/albe/following{/other_user}","gists_url":"https://api.github.com/users/albe/gists{/gist_id}","starred_url":"https://api.github.com/users/albe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/albe/subscriptions","organizations_url":"https://api.github.com/users/albe/orgs","repos_url":"https://api.github.com/users/albe/repos","events_url":"https://api.github.com/users/albe/events{/privacy}","received_events_url":"https://api.github.com/users/albe/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/neos/flow-development-collection/labels/!!!%20Next%20major","name":"!!! Next major","color":"b60205"},{"url":"https://api.github.com/repos/neos/flow-development-collection/labels/P:%20Flow","name":"P: Flow","color":"0052cc"},{"url":"https://api.github.com/repos/neos/flow-development-collection/labels/T:%20Database","name":"T: Database","color":"009800"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-05T16:30:53Z","updated_at":"2016-08-23T11:53:33Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/neos/flow-development-collection/pulls/415","html_url":"https://github.com/neos/flow-development-collection/pull/415","diff_url":"https://github.com/neos/flow-development-collection/pull/415.diff","patch_url":"https://github.com/neos/flow-development-collection/pull/415.patch"},"body":"Before it was possible that a query with implicit joins created a result set with duplicate entries.\r\nThis change sets the `distinct` flag on the query object to true when an implicit join is created.\r\n\r\nFLOW-21 #close"},"comment":{"url":"https://api.github.com/repos/neos/flow-development-collection/issues/comments/241707538","html_url":"https://github.com/neos/flow-development-collection/pull/415#issuecomment-241707538","issue_url":"https://api.github.com/repos/neos/flow-development-collection/issues/415","id":241707538,"user":{"login":"kdambekalns","id":95873,"avatar_url":"https://avatars.githubusercontent.com/u/95873?v=3","gravatar_id":"","url":"https://api.github.com/users/kdambekalns","html_url":"https://github.com/kdambekalns","followers_url":"https://api.github.com/users/kdambekalns/followers","following_url":"https://api.github.com/users/kdambekalns/following{/other_user}","gists_url":"https://api.github.com/users/kdambekalns/gists{/gist_id}","starred_url":"https://api.github.com/users/kdambekalns/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kdambekalns/subscriptions","organizations_url":"https://api.github.com/users/kdambekalns/orgs","repos_url":"https://api.github.com/users/kdambekalns/repos","events_url":"https://api.github.com/users/kdambekalns/events{/privacy}","received_events_url":"https://api.github.com/users/kdambekalns/received_events","type":"User","site_admin":false},"created_at":"2016-08-23T11:53:33Z","updated_at":"2016-08-23T11:53:33Z","body":"Hm, maybe there is no better way, but `DISTINCT` has it's issues… Some writeups about what I mean:\r\n- http://www.bimonkey.com/2011/01/why-to-avoid-distinct-and-group-by-to-get-unique-records/\r\n- http://weblogs.sqlteam.com/markc/archive/2008/11/11/60752.aspx"}}
{"actor":{"display_login":"kdambekalns"}}