{"action":"created","issue":{"url":"https://api.github.com/repos/hyrise/hyrise/issues/1373","repository_url":"https://api.github.com/repos/hyrise/hyrise","labels_url":"https://api.github.com/repos/hyrise/hyrise/issues/1373/labels{/name}","comments_url":"https://api.github.com/repos/hyrise/hyrise/issues/1373/comments","events_url":"https://api.github.com/repos/hyrise/hyrise/issues/1373/events","html_url":"https://github.com/hyrise/hyrise/issues/1373","id":391647962,"node_id":"MDU6SXNzdWUzOTE2NDc5NjI=","number":1373,"title":"exists (select 1) returns one element instead of all","user":{"login":"pascalhpi","id":12249958,"node_id":"MDQ6VXNlcjEyMjQ5OTU4","avatar_url":"https://avatars1.githubusercontent.com/u/12249958?v=4","gravatar_id":"","url":"https://api.github.com/users/pascalhpi","html_url":"https://github.com/pascalhpi","followers_url":"https://api.github.com/users/pascalhpi/followers","following_url":"https://api.github.com/users/pascalhpi/following{/other_user}","gists_url":"https://api.github.com/users/pascalhpi/gists{/gist_id}","starred_url":"https://api.github.com/users/pascalhpi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pascalhpi/subscriptions","organizations_url":"https://api.github.com/users/pascalhpi/orgs","repos_url":"https://api.github.com/users/pascalhpi/repos","events_url":"https://api.github.com/users/pascalhpi/events{/privacy}","received_events_url":"https://api.github.com/users/pascalhpi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"mrzzzrm","id":2679018,"node_id":"MDQ6VXNlcjI2NzkwMTg=","avatar_url":"https://avatars3.githubusercontent.com/u/2679018?v=4","gravatar_id":"","url":"https://api.github.com/users/mrzzzrm","html_url":"https://github.com/mrzzzrm","followers_url":"https://api.github.com/users/mrzzzrm/followers","following_url":"https://api.github.com/users/mrzzzrm/following{/other_user}","gists_url":"https://api.github.com/users/mrzzzrm/gists{/gist_id}","starred_url":"https://api.github.com/users/mrzzzrm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrzzzrm/subscriptions","organizations_url":"https://api.github.com/users/mrzzzrm/orgs","repos_url":"https://api.github.com/users/mrzzzrm/repos","events_url":"https://api.github.com/users/mrzzzrm/events{/privacy}","received_events_url":"https://api.github.com/users/mrzzzrm/received_events","type":"User","site_admin":false},"assignees":[{"login":"mrzzzrm","id":2679018,"node_id":"MDQ6VXNlcjI2NzkwMTg=","avatar_url":"https://avatars3.githubusercontent.com/u/2679018?v=4","gravatar_id":"","url":"https://api.github.com/users/mrzzzrm","html_url":"https://github.com/mrzzzrm","followers_url":"https://api.github.com/users/mrzzzrm/followers","following_url":"https://api.github.com/users/mrzzzrm/following{/other_user}","gists_url":"https://api.github.com/users/mrzzzrm/gists{/gist_id}","starred_url":"https://api.github.com/users/mrzzzrm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrzzzrm/subscriptions","organizations_url":"https://api.github.com/users/mrzzzrm/orgs","repos_url":"https://api.github.com/users/mrzzzrm/repos","events_url":"https://api.github.com/users/mrzzzrm/events{/privacy}","received_events_url":"https://api.github.com/users/mrzzzrm/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-12-17T10:30:42Z","updated_at":"2018-12-17T20:36:17Z","closed_at":null,"author_association":"NONE","body":"in hyriseConsole: `select * from customer where exists (select 1)` should return all customers but returns only one customer. this seems to be true for all uncorrelated subqueries: if the subquery returns anything we get the first element instead of all, if it does not return anything we get nothing."},"comment":{"url":"https://api.github.com/repos/hyrise/hyrise/issues/comments/447989803","html_url":"https://github.com/hyrise/hyrise/issues/1373#issuecomment-447989803","issue_url":"https://api.github.com/repos/hyrise/hyrise/issues/1373","id":447989803,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0Nzk4OTgwMw==","user":{"login":"mrzzzrm","id":2679018,"node_id":"MDQ6VXNlcjI2NzkwMTg=","avatar_url":"https://avatars3.githubusercontent.com/u/2679018?v=4","gravatar_id":"","url":"https://api.github.com/users/mrzzzrm","html_url":"https://github.com/mrzzzrm","followers_url":"https://api.github.com/users/mrzzzrm/followers","following_url":"https://api.github.com/users/mrzzzrm/following{/other_user}","gists_url":"https://api.github.com/users/mrzzzrm/gists{/gist_id}","starred_url":"https://api.github.com/users/mrzzzrm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrzzzrm/subscriptions","organizations_url":"https://api.github.com/users/mrzzzrm/orgs","repos_url":"https://api.github.com/users/mrzzzrm/repos","events_url":"https://api.github.com/users/mrzzzrm/events{/privacy}","received_events_url":"https://api.github.com/users/mrzzzrm/received_events","type":"User","site_admin":false},"created_at":"2018-12-17T20:36:17Z","updated_at":"2018-12-17T20:36:17Z","author_association":"CONTRIBUTOR","body":"#1375 should fix this. One question though:\r\n> this seems to be true for all uncorrelated subqueries: if the subquery returns anything we get the first element instead of all, if it does not return anything we get nothing.\r\n\r\nis this referring specifically to subqueries in EXISTS or to subqueries in general. Because the aforementioned fix only addresses EXISTS, if you encountered problems with them anywhere else, please let me know."}}
{"actor":{"display_login":"mrzzzrm"}}