{"action":"opened","issue":{"url":"https://api.github.com/repos/quasar-analytics/quasar/issues/1470","repository_url":"https://api.github.com/repos/quasar-analytics/quasar","labels_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/1470/labels{/name}","comments_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/1470/comments","events_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/1470/events","html_url":"https://github.com/quasar-analytics/quasar/issues/1470","id":179317912,"number":1470,"title":"Subselect in WHERE clause doesn't work","user":{"login":"damonLL","id":7375598,"avatar_url":"https://avatars.githubusercontent.com/u/7375598?v=3","gravatar_id":"","url":"https://api.github.com/users/damonLL","html_url":"https://github.com/damonLL","followers_url":"https://api.github.com/users/damonLL/followers","following_url":"https://api.github.com/users/damonLL/following{/other_user}","gists_url":"https://api.github.com/users/damonLL/gists{/gist_id}","starred_url":"https://api.github.com/users/damonLL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/damonLL/subscriptions","organizations_url":"https://api.github.com/users/damonLL/orgs","repos_url":"https://api.github.com/users/damonLL/repos","events_url":"https://api.github.com/users/damonLL/events{/privacy}","received_events_url":"https://api.github.com/users/damonLL/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-09-26T19:36:22Z","updated_at":"2016-09-26T19:36:22Z","closed_at":null,"body":"At @jdegoes's direction, closed [SlamData Issue #1048](https://github.com/slamdata/slamdata/issues/1048) and reopening here.  Initial summary below:\r\n<hr>\r\n\r\nThe following query:\r\n\r\n```\r\nSELECT * FROM `/devguide/devdb/patients` AS p\r\nWHERE state IN (SELECT state FROM `/devguide/devdb/states`)\r\n```\r\n\r\ngives the error:\r\n\r\n```\r\nAn unknown error ocurred: 500 \"{ \\\"error\\\": { \\\"status\\\": \\\"Unsupported function.\\\",\r\n\\\"detail\\\":{ \\\"message\\\": \\\"The function 'WHERE' is recognized but not supported\r\nby this back-end. (in JS planner)\\\", \\\"functionName\\\": \\\"WHERE\\\", \\\"logicalPlan\\\": {\r\n....\r\n```\r\n\r\nCurrent usable workaround provided by @sellout:\r\n```\r\nSELECT p.* FROM `/devguide/devdb/patients` AS p\r\nINNER JOIN `/devguide/devdb/states` AS s\r\nON p.state = s.state\r\n```\r\n"}}
{"actor":{"display_login":"damonLL"}}