{"action":"created","issue":{"url":"https://api.github.com/repos/hyrise/hyrise/issues/727","repository_url":"https://api.github.com/repos/hyrise/hyrise","labels_url":"https://api.github.com/repos/hyrise/hyrise/issues/727/labels{/name}","comments_url":"https://api.github.com/repos/hyrise/hyrise/issues/727/comments","events_url":"https://api.github.com/repos/hyrise/hyrise/issues/727/events","html_url":"https://github.com/hyrise/hyrise/pull/727","id":299066701,"number":727,"title":"Add support for subqueries in SELECT and WHERE clause","user":{"login":"p-otto","id":7888427,"avatar_url":"https://avatars1.githubusercontent.com/u/7888427?v=4","gravatar_id":"","url":"https://api.github.com/users/p-otto","html_url":"https://github.com/p-otto","followers_url":"https://api.github.com/users/p-otto/followers","following_url":"https://api.github.com/users/p-otto/following{/other_user}","gists_url":"https://api.github.com/users/p-otto/gists{/gist_id}","starred_url":"https://api.github.com/users/p-otto/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/p-otto/subscriptions","organizations_url":"https://api.github.com/users/p-otto/orgs","repos_url":"https://api.github.com/users/p-otto/repos","events_url":"https://api.github.com/users/p-otto/events{/privacy}","received_events_url":"https://api.github.com/users/p-otto/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-21T17:50:59Z","updated_at":"2018-03-01T12:48:56Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/hyrise/hyrise/pulls/727","html_url":"https://github.com/hyrise/hyrise/pull/727","diff_url":"https://github.com/hyrise/hyrise/pull/727.diff","patch_url":"https://github.com/hyrise/hyrise/pull/727.patch"},"body":"Allows queries such as the following:\r\n*  `SELECT a, (SELECT MAX(b) FROM t2) FROM t1;`\r\n*  `SELECT a FROM t1 WHERE b > (SELECT MAX(a) FROM t2);`\r\n*  `SELECT a FROM t1 WHERE b IN (SELECT a FROM t2);`\r\n\r\nCorrelated subqueries, i.e. ones that use symbols from the outer scope, are not yet supported."},"comment":{"url":"https://api.github.com/repos/hyrise/hyrise/issues/comments/369581342","html_url":"https://github.com/hyrise/hyrise/pull/727#issuecomment-369581342","issue_url":"https://api.github.com/repos/hyrise/hyrise/issues/727","id":369581342,"user":{"login":"mrks","id":575106,"avatar_url":"https://avatars2.githubusercontent.com/u/575106?v=4","gravatar_id":"","url":"https://api.github.com/users/mrks","html_url":"https://github.com/mrks","followers_url":"https://api.github.com/users/mrks/followers","following_url":"https://api.github.com/users/mrks/following{/other_user}","gists_url":"https://api.github.com/users/mrks/gists{/gist_id}","starred_url":"https://api.github.com/users/mrks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrks/subscriptions","organizations_url":"https://api.github.com/users/mrks/orgs","repos_url":"https://api.github.com/users/mrks/repos","events_url":"https://api.github.com/users/mrks/events{/privacy}","received_events_url":"https://api.github.com/users/mrks/received_events","type":"User","site_admin":false},"created_at":"2018-03-01T12:48:56Z","updated_at":"2018-03-01T12:48:56Z","author_association":"OWNER","body":"@f4lco (and the others who Github’s auto completion can’t find): When can we expect your review?"}}
{"actor":{"display_login":"mrks"}}