{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/2568","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/2568/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/2568/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/2568/events","html_url":"https://github.com/cockroachdb/cockroach/pull/2568","id":107351776,"number":2568,"title":"Add COUNT(DISTINCT ...), SUM(DISTINCT ...), AVG(DISTINCT ...)","user":{"login":"vivekmenezes","id":11774212,"avatar_url":"https://avatars.githubusercontent.com/u/11774212?v=3","gravatar_id":"","url":"https://api.github.com/users/vivekmenezes","html_url":"https://github.com/vivekmenezes","followers_url":"https://api.github.com/users/vivekmenezes/followers","following_url":"https://api.github.com/users/vivekmenezes/following{/other_user}","gists_url":"https://api.github.com/users/vivekmenezes/gists{/gist_id}","starred_url":"https://api.github.com/users/vivekmenezes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vivekmenezes/subscriptions","organizations_url":"https://api.github.com/users/vivekmenezes/orgs","repos_url":"https://api.github.com/users/vivekmenezes/repos","events_url":"https://api.github.com/users/vivekmenezes/events{/privacy}","received_events_url":"https://api.github.com/users/vivekmenezes/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-09-19T19:25:55Z","updated_at":"2015-09-21T19:32:36Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/cockroachdb/cockroach/pulls/2568","html_url":"https://github.com/cockroachdb/cockroach/pull/2568","diff_url":"https://github.com/cockroachdb/cockroach/pull/2568.diff","patch_url":"https://github.com/cockroachdb/cockroach/pull/2568.patch"},"body":"closes #2248"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/142086240","html_url":"https://github.com/cockroachdb/cockroach/pull/2568#issuecomment-142086240","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/2568","id":142086240,"user":{"login":"vivekmenezes","id":11774212,"avatar_url":"https://avatars.githubusercontent.com/u/11774212?v=3","gravatar_id":"","url":"https://api.github.com/users/vivekmenezes","html_url":"https://github.com/vivekmenezes","followers_url":"https://api.github.com/users/vivekmenezes/followers","following_url":"https://api.github.com/users/vivekmenezes/following{/other_user}","gists_url":"https://api.github.com/users/vivekmenezes/gists{/gist_id}","starred_url":"https://api.github.com/users/vivekmenezes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vivekmenezes/subscriptions","organizations_url":"https://api.github.com/users/vivekmenezes/orgs","repos_url":"https://api.github.com/users/vivekmenezes/repos","events_url":"https://api.github.com/users/vivekmenezes/events{/privacy}","received_events_url":"https://api.github.com/users/vivekmenezes/received_events","type":"User","site_admin":false},"created_at":"2015-09-21T19:32:36Z","updated_at":"2015-09-21T19:32:36Z","body":"I was struggling to find a query that will return a tuple and not return an error. The test I have used to return a different error before the change.\r\n\r\nSELECT (2, 3) IN (SELECT DISTINCT (y, z) FROM xyz) doesn't work \r\nnor does\r\nSELECT ((2, 3)) IN (SELECT DISTINCT (y, z) FROM xyz)\r\n\r\nIf we don't have a query available, I'll create a bug report and fix it in a different PR.\r\n"}}