{"action":"opened","issue":{"url":"https://api.github.com/repos/google/lovefield/issues/68","labels_url":"https://api.github.com/repos/google/lovefield/issues/68/labels{/name}","comments_url":"https://api.github.com/repos/google/lovefield/issues/68/comments","events_url":"https://api.github.com/repos/google/lovefield/issues/68/events","html_url":"https://github.com/google/lovefield/issues/68","id":105655516,"number":68,"title":" Left Outer Join does not handle combined predicate.","user":{"login":"freshp86","id":7547039,"avatar_url":"https://avatars.githubusercontent.com/u/7547039?v=3","gravatar_id":"","url":"https://api.github.com/users/freshp86","html_url":"https://github.com/freshp86","followers_url":"https://api.github.com/users/freshp86/followers","following_url":"https://api.github.com/users/freshp86/following{/other_user}","gists_url":"https://api.github.com/users/freshp86/gists{/gist_id}","starred_url":"https://api.github.com/users/freshp86/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/freshp86/subscriptions","organizations_url":"https://api.github.com/users/freshp86/orgs","repos_url":"https://api.github.com/users/freshp86/repos","events_url":"https://api.github.com/users/freshp86/events{/privacy}","received_events_url":"https://api.github.com/users/freshp86/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-09T18:28:24Z","updated_at":"2015-09-09T18:28:24Z","closed_at":null,"body":"Currently leftOuterJoin() only accepts a single (join) predicate. For example the following query is supported\r\n\r\n```\r\ndb.select().\r\n    from(tableA, tableB).\r\n    leftOuterJoin(tableA, tableA.id.eq(tableB.id)).\r\n    exec();\r\n```\r\n\r\nbut the one below is not (Syntax error: (541) Outer join accepts only join predicate.)\r\n\r\n```\r\ndb.select().\r\n    from(tableA, tableB).\r\n    leftOuterJoin(tableA, lf.op.and(tableA.id.eq(tableB.id), tableA.id.gt(100))).\r\n    exec();\r\n```\r\n"}}