{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28106","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28106/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28106/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28106/events","html_url":"https://github.com/cockroachdb/cockroach/pull/28106","id":346307421,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA1MjAyODA1","number":28106,"title":"opt: DistinctOn operator","user":{"login":"RaduBerinde","id":16544120,"node_id":"MDQ6VXNlcjE2NTQ0MTIw","avatar_url":"https://avatars1.githubusercontent.com/u/16544120?v=4","gravatar_id":"","url":"https://api.github.com/users/RaduBerinde","html_url":"https://github.com/RaduBerinde","followers_url":"https://api.github.com/users/RaduBerinde/followers","following_url":"https://api.github.com/users/RaduBerinde/following{/other_user}","gists_url":"https://api.github.com/users/RaduBerinde/gists{/gist_id}","starred_url":"https://api.github.com/users/RaduBerinde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RaduBerinde/subscriptions","organizations_url":"https://api.github.com/users/RaduBerinde/orgs","repos_url":"https://api.github.com/users/RaduBerinde/repos","events_url":"https://api.github.com/users/RaduBerinde/events{/privacy}","received_events_url":"https://api.github.com/users/RaduBerinde/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-31T18:30:49Z","updated_at":"2018-07-31T18:30:57Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/cockroachdb/cockroach/pulls/28106","html_url":"https://github.com/cockroachdb/cockroach/pull/28106","diff_url":"https://github.com/cockroachdb/cockroach/pull/28106.diff","patch_url":"https://github.com/cockroachdb/cockroach/pull/28106.patch"},"body":"#### opt: DistinctOn operator\r\n\r\nThis change introduces the DistinctOn operator, which is polymorphic\r\nwith GroupBy and can be used (as appropriate) in the same rules. We\r\nadd a `FirstAgg` aggregate function that is used with this operator.\r\n\r\nChanging the build code for `SELECT DISTINCT` to use this operator.\r\nThere will be follow-up work to support `DISTINCT ON`.\r\n\r\nNote that it's hard to come up with testcases for rules without\r\n`DISTINCT ON`, I plan to add more tests when that is implemented.\r\n\r\nIn this change, `DistinctOn` doesn't provide any ordering; this will\r\nbe improved after we support `DISTINCT ON`.\r\n\r\nRelease note: None"},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/409322606","html_url":"https://github.com/cockroachdb/cockroach/pull/28106#issuecomment-409322606","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28106","id":409322606,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTMyMjYwNg==","user":{"login":"cockroach-teamcity","id":20559710,"node_id":"MDQ6VXNlcjIwNTU5NzEw","avatar_url":"https://avatars0.githubusercontent.com/u/20559710?v=4","gravatar_id":"","url":"https://api.github.com/users/cockroach-teamcity","html_url":"https://github.com/cockroach-teamcity","followers_url":"https://api.github.com/users/cockroach-teamcity/followers","following_url":"https://api.github.com/users/cockroach-teamcity/following{/other_user}","gists_url":"https://api.github.com/users/cockroach-teamcity/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroach-teamcity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroach-teamcity/subscriptions","organizations_url":"https://api.github.com/users/cockroach-teamcity/orgs","repos_url":"https://api.github.com/users/cockroach-teamcity/repos","events_url":"https://api.github.com/users/cockroach-teamcity/events{/privacy}","received_events_url":"https://api.github.com/users/cockroach-teamcity/received_events","type":"User","site_admin":false},"created_at":"2018-07-31T18:30:57Z","updated_at":"2018-07-31T18:30:57Z","author_association":"MEMBER","body":"\n\n<!-- Reviewable:start -->\nThis change is [<img src=\"https://reviewable.io/review_button.png\" height=\"34\" align=\"absmiddle\" alt=\"Reviewable\"/>](https://reviewable.io/reviews/cockroachdb/cockroach/28106)\n<!-- Reviewable:end -->\n"}}
{"actor":{"display_login":"cockroach-teamcity"}}