{"action":"opened","issue":{"url":"https://api.github.com/repos/linq2db/linq2db/issues/1210","repository_url":"https://api.github.com/repos/linq2db/linq2db","labels_url":"https://api.github.com/repos/linq2db/linq2db/issues/1210/labels{/name}","comments_url":"https://api.github.com/repos/linq2db/linq2db/issues/1210/comments","events_url":"https://api.github.com/repos/linq2db/linq2db/issues/1210/events","html_url":"https://github.com/linq2db/linq2db/issues/1210","id":336575796,"node_id":"MDU6SXNzdWUzMzY1NzU3OTY=","number":1210,"title":"Join extensions generates wrong queries","user":{"login":"ili","id":787292,"node_id":"MDQ6VXNlcjc4NzI5Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/787292?v=4","gravatar_id":"","url":"https://api.github.com/users/ili","html_url":"https://github.com/ili","followers_url":"https://api.github.com/users/ili/followers","following_url":"https://api.github.com/users/ili/following{/other_user}","gists_url":"https://api.github.com/users/ili/gists{/gist_id}","starred_url":"https://api.github.com/users/ili/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ili/subscriptions","organizations_url":"https://api.github.com/users/ili/orgs","repos_url":"https://api.github.com/users/ili/repos","events_url":"https://api.github.com/users/ili/events{/privacy}","received_events_url":"https://api.github.com/users/ili/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"sdanyliv","id":783759,"node_id":"MDQ6VXNlcjc4Mzc1OQ==","avatar_url":"https://avatars1.githubusercontent.com/u/783759?v=4","gravatar_id":"","url":"https://api.github.com/users/sdanyliv","html_url":"https://github.com/sdanyliv","followers_url":"https://api.github.com/users/sdanyliv/followers","following_url":"https://api.github.com/users/sdanyliv/following{/other_user}","gists_url":"https://api.github.com/users/sdanyliv/gists{/gist_id}","starred_url":"https://api.github.com/users/sdanyliv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sdanyliv/subscriptions","organizations_url":"https://api.github.com/users/sdanyliv/orgs","repos_url":"https://api.github.com/users/sdanyliv/repos","events_url":"https://api.github.com/users/sdanyliv/events{/privacy}","received_events_url":"https://api.github.com/users/sdanyliv/received_events","type":"User","site_admin":false},"assignees":[{"login":"sdanyliv","id":783759,"node_id":"MDQ6VXNlcjc4Mzc1OQ==","avatar_url":"https://avatars1.githubusercontent.com/u/783759?v=4","gravatar_id":"","url":"https://api.github.com/users/sdanyliv","html_url":"https://github.com/sdanyliv","followers_url":"https://api.github.com/users/sdanyliv/followers","following_url":"https://api.github.com/users/sdanyliv/following{/other_user}","gists_url":"https://api.github.com/users/sdanyliv/gists{/gist_id}","starred_url":"https://api.github.com/users/sdanyliv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sdanyliv/subscriptions","organizations_url":"https://api.github.com/users/sdanyliv/orgs","repos_url":"https://api.github.com/users/sdanyliv/repos","events_url":"https://api.github.com/users/sdanyliv/events{/privacy}","received_events_url":"https://api.github.com/users/sdanyliv/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-06-28T11:07:35Z","updated_at":"2018-06-28T11:07:35Z","closed_at":null,"author_association":"MEMBER","body":"Join extensions combines subquery where condition and join conditions to SQL ON predicate.\r\nFor ex:\r\n\r\n```cs\r\nvar qry1 = db.Table.Where(condition1);\r\nvar qry2 = db.Table.Where(condition2);\r\n\r\nvar res = \r\n    from q1 in qry1\r\n    from q2 in qry2.FullJoin(condition3)\r\n```\r\n\r\nand it would look like:\r\n\r\n```sql\r\nselct * \r\nfrom (select * from table where condition1) q1 \r\nfull  join (select * from table) q2 on condition1 & confition3\r\n```\r\n\r\nwhile should be\r\n```sql\r\nselct * \r\nfrom (select * from table where condition1) q1 \r\nfull  join (select * from table where condition2) q2 on confition3\r\n```\r\n\r\n\r\n\r\n### Environment details\r\nlinq2db version: *2.0.0*\r\nDatabase Server: *MS SQL Server*\r\nOperating system: *E.g. Windows 10*\r\nFramework version: *.NET Core 2*\r\n"}}
{"actor":{"display_login":"ili"}}