{"action":"opened","issue":{"url":"https://api.github.com/repos/cakephp/bake/issues/135","labels_url":"https://api.github.com/repos/cakephp/bake/issues/135/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/bake/issues/135/comments","events_url":"https://api.github.com/repos/cakephp/bake/issues/135/events","html_url":"https://github.com/cakephp/bake/issues/135","id":95603600,"number":135,"title":"Adding joinType LEFT for nullable foreign keys","user":{"login":"GuidoHendriks","id":5393965,"avatar_url":"https://avatars.githubusercontent.com/u/5393965?v=3","gravatar_id":"","url":"https://api.github.com/users/GuidoHendriks","html_url":"https://github.com/GuidoHendriks","followers_url":"https://api.github.com/users/GuidoHendriks/followers","following_url":"https://api.github.com/users/GuidoHendriks/following{/other_user}","gists_url":"https://api.github.com/users/GuidoHendriks/gists{/gist_id}","starred_url":"https://api.github.com/users/GuidoHendriks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GuidoHendriks/subscriptions","organizations_url":"https://api.github.com/users/GuidoHendriks/orgs","repos_url":"https://api.github.com/users/GuidoHendriks/repos","events_url":"https://api.github.com/users/GuidoHendriks/events{/privacy}","received_events_url":"https://api.github.com/users/GuidoHendriks/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-17T07:24:40Z","updated_at":"2015-07-17T07:24:40Z","closed_at":null,"body":"When baking models currently there's no `joinType` added. For non-nullable fields that's good, since it's always good to inner join those. For nullable foreign keys on the other hand, it will not return any records if there are no associated.\r\n\r\nMy suggestion is adding a `'joinType' => 'LEFT',' if the foreign key field is nullable.\r\n\r\nI'm willing to implement it myself if you guys agree on this."}}