{"action":"created","comment":{"url":"https://api.github.com/repos/ContinuumIO/blaze/pulls/comments/32183271","id":32183271,"diff_hunk":"@@ -1577,6 +1614,13 @@ def test_timedelta_arith(sql_with_dts):\n     ).all()\n \n \n+def test_sort_compose():\n+    expr = t.name[:5].sort()\n+    result = compute(expr, s)\n+    expected = \"\"\"with anon_1 as (select accounts.name as name from accounts limit :param_1 offset :param_2) select anon_1.name from anon_1 order by anon_1.name asc\"\"\"","path":"blaze/compute/tests/test_sql_compute.py","position":64,"original_position":64,"commit_id":"470adadde388c0fb80c47dafe6355b81ca79d305","original_commit_id":"470adadde388c0fb80c47dafe6355b81ca79d305","user":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"body":"note to self: format this","created_at":"2015-06-11T01:27:01Z","updated_at":"2015-06-11T01:27:01Z","html_url":"https://github.com/ContinuumIO/blaze/pull/1125#discussion_r32183271","pull_request_url":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125","_links":{"self":{"href":"https://api.github.com/repos/ContinuumIO/blaze/pulls/comments/32183271"},"html":{"href":"https://github.com/ContinuumIO/blaze/pull/1125#discussion_r32183271"},"pull_request":{"href":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125"}}},"pull_request":{"url":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125","id":37420735,"html_url":"https://github.com/ContinuumIO/blaze/pull/1125","diff_url":"https://github.com/ContinuumIO/blaze/pull/1125.diff","patch_url":"https://github.com/ContinuumIO/blaze/pull/1125.patch","issue_url":"https://api.github.com/repos/ContinuumIO/blaze/issues/1125","number":1125,"state":"open","locked":false,"title":"Add sql slicing and make sort use a CTE so that the semantics are similar to numpy","user":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"body":"closes #1072\n\n@Will-So\n\nThis PR has all of your commits as well as a few extras to fix the order of\noperations for sort on the SQL backend.","created_at":"2015-06-11T01:10:13Z","updated_at":"2015-06-11T01:27:01Z","closed_at":null,"merged_at":null,"merge_commit_sha":"6cfdd27cdea50de18dca98a42a924e304e0d4488","assignee":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ContinuumIO/blaze/milestones/10","html_url":"https://github.com/ContinuumIO/blaze/milestones/0.8.1","labels_url":"https://api.github.com/repos/ContinuumIO/blaze/milestones/10/labels","id":1078155,"number":10,"title":"0.8.1","description":"","creator":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"open_issues":20,"closed_issues":46,"state":"open","created_at":"2015-04-22T02:01:15Z","updated_at":"2015-06-11T01:11:22Z","due_on":"2015-07-24T04:00:00Z","closed_at":null},"commits_url":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125/commits","review_comments_url":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125/comments","review_comment_url":"https://api.github.com/repos/ContinuumIO/blaze/pulls/comments{/number}","comments_url":"https://api.github.com/repos/ContinuumIO/blaze/issues/1125/comments","statuses_url":"https://api.github.com/repos/ContinuumIO/blaze/statuses/470adadde388c0fb80c47dafe6355b81ca79d305","head":{"label":"cpcloud:sort-compose","ref":"sort-compose","sha":"470adadde388c0fb80c47dafe6355b81ca79d305","user":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"repo":{"id":21789010,"name":"blaze","full_name":"cpcloud/blaze","owner":{"login":"cpcloud","id":417981,"avatar_url":"https://avatars.githubusercontent.com/u/417981?v=3","gravatar_id":"","url":"https://api.github.com/users/cpcloud","html_url":"https://github.com/cpcloud","followers_url":"https://api.github.com/users/cpcloud/followers","following_url":"https://api.github.com/users/cpcloud/following{/other_user}","gists_url":"https://api.github.com/users/cpcloud/gists{/gist_id}","starred_url":"https://api.github.com/users/cpcloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpcloud/subscriptions","organizations_url":"https://api.github.com/users/cpcloud/orgs","repos_url":"https://api.github.com/users/cpcloud/repos","events_url":"https://api.github.com/users/cpcloud/events{/privacy}","received_events_url":"https://api.github.com/users/cpcloud/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cpcloud/blaze","description":"Blaze is NumPy and Pandas for Big Data","fork":true,"url":"https://api.github.com/repos/cpcloud/blaze","forks_url":"https://api.github.com/repos/cpcloud/blaze/forks","keys_url":"https://api.github.com/repos/cpcloud/blaze/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cpcloud/blaze/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cpcloud/blaze/teams","hooks_url":"https://api.github.com/repos/cpcloud/blaze/hooks","issue_events_url":"https://api.github.com/repos/cpcloud/blaze/issues/events{/number}","events_url":"https://api.github.com/repos/cpcloud/blaze/events","assignees_url":"https://api.github.com/repos/cpcloud/blaze/assignees{/user}","branches_url":"https://api.github.com/repos/cpcloud/blaze/branches{/branch}","tags_url":"https://api.github.com/repos/cpcloud/blaze/tags","blobs_url":"https://api.github.com/repos/cpcloud/blaze/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cpcloud/blaze/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cpcloud/blaze/git/refs{/sha}","trees_url":"https://api.github.com/repos/cpcloud/blaze/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cpcloud/blaze/statuses/{sha}","languages_url":"https://api.github.com/repos/cpcloud/blaze/languages","stargazers_url":"https://api.github.com/repos/cpcloud/blaze/stargazers","contributors_url":"https://api.github.com/repos/cpcloud/blaze/contributors","subscribers_url":"https://api.github.com/repos/cpcloud/blaze/subscribers","subscription_url":"https://api.github.com/repos/cpcloud/blaze/subscription","commits_url":"https://api.github.com/repos/cpcloud/blaze/commits{/sha}","git_commits_url":"https://api.github.com/repos/cpcloud/blaze/git/commits{/sha}","comments_url":"https://api.github.com/repos/cpcloud/blaze/comments{/number}","issue_comment_url":"https://api.github.com/repos/cpcloud/blaze/issues/comments{/number}","contents_url":"https://api.github.com/repos/cpcloud/blaze/contents/{+path}","compare_url":"https://api.github.com/repos/cpcloud/blaze/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cpcloud/blaze/merges","archive_url":"https://api.github.com/repos/cpcloud/blaze/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cpcloud/blaze/downloads","issues_url":"https://api.github.com/repos/cpcloud/blaze/issues{/number}","pulls_url":"https://api.github.com/repos/cpcloud/blaze/pulls{/number}","milestones_url":"https://api.github.com/repos/cpcloud/blaze/milestones{/number}","notifications_url":"https://api.github.com/repos/cpcloud/blaze/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cpcloud/blaze/labels{/name}","releases_url":"https://api.github.com/repos/cpcloud/blaze/releases{/id}","created_at":"2014-07-13T11:40:34Z","updated_at":"2015-05-08T01:08:01Z","pushed_at":"2015-06-11T01:00:51Z","git_url":"git://github.com/cpcloud/blaze.git","ssh_url":"git@github.com:cpcloud/blaze.git","clone_url":"https://github.com/cpcloud/blaze.git","svn_url":"https://github.com/cpcloud/blaze","homepage":"blaze.pydata.org","size":21204,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"ContinuumIO:master","ref":"master","sha":"4bae37de324a6dae07b90b4d4ebf3fbeb2310fbf","user":{"login":"ContinuumIO","id":1158637,"avatar_url":"https://avatars.githubusercontent.com/u/1158637?v=3","gravatar_id":"","url":"https://api.github.com/users/ContinuumIO","html_url":"https://github.com/ContinuumIO","followers_url":"https://api.github.com/users/ContinuumIO/followers","following_url":"https://api.github.com/users/ContinuumIO/following{/other_user}","gists_url":"https://api.github.com/users/ContinuumIO/gists{/gist_id}","starred_url":"https://api.github.com/users/ContinuumIO/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ContinuumIO/subscriptions","organizations_url":"https://api.github.com/users/ContinuumIO/orgs","repos_url":"https://api.github.com/users/ContinuumIO/repos","events_url":"https://api.github.com/users/ContinuumIO/events{/privacy}","received_events_url":"https://api.github.com/users/ContinuumIO/received_events","type":"Organization","site_admin":false},"repo":{"id":6404963,"name":"blaze","full_name":"ContinuumIO/blaze","owner":{"login":"ContinuumIO","id":1158637,"avatar_url":"https://avatars.githubusercontent.com/u/1158637?v=3","gravatar_id":"","url":"https://api.github.com/users/ContinuumIO","html_url":"https://github.com/ContinuumIO","followers_url":"https://api.github.com/users/ContinuumIO/followers","following_url":"https://api.github.com/users/ContinuumIO/following{/other_user}","gists_url":"https://api.github.com/users/ContinuumIO/gists{/gist_id}","starred_url":"https://api.github.com/users/ContinuumIO/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ContinuumIO/subscriptions","organizations_url":"https://api.github.com/users/ContinuumIO/orgs","repos_url":"https://api.github.com/users/ContinuumIO/repos","events_url":"https://api.github.com/users/ContinuumIO/events{/privacy}","received_events_url":"https://api.github.com/users/ContinuumIO/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ContinuumIO/blaze","description":"NumPy and Pandas interface to Big Data","fork":false,"url":"https://api.github.com/repos/ContinuumIO/blaze","forks_url":"https://api.github.com/repos/ContinuumIO/blaze/forks","keys_url":"https://api.github.com/repos/ContinuumIO/blaze/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ContinuumIO/blaze/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ContinuumIO/blaze/teams","hooks_url":"https://api.github.com/repos/ContinuumIO/blaze/hooks","issue_events_url":"https://api.github.com/repos/ContinuumIO/blaze/issues/events{/number}","events_url":"https://api.github.com/repos/ContinuumIO/blaze/events","assignees_url":"https://api.github.com/repos/ContinuumIO/blaze/assignees{/user}","branches_url":"https://api.github.com/repos/ContinuumIO/blaze/branches{/branch}","tags_url":"https://api.github.com/repos/ContinuumIO/blaze/tags","blobs_url":"https://api.github.com/repos/ContinuumIO/blaze/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ContinuumIO/blaze/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ContinuumIO/blaze/git/refs{/sha}","trees_url":"https://api.github.com/repos/ContinuumIO/blaze/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ContinuumIO/blaze/statuses/{sha}","languages_url":"https://api.github.com/repos/ContinuumIO/blaze/languages","stargazers_url":"https://api.github.com/repos/ContinuumIO/blaze/stargazers","contributors_url":"https://api.github.com/repos/ContinuumIO/blaze/contributors","subscribers_url":"https://api.github.com/repos/ContinuumIO/blaze/subscribers","subscription_url":"https://api.github.com/repos/ContinuumIO/blaze/subscription","commits_url":"https://api.github.com/repos/ContinuumIO/blaze/commits{/sha}","git_commits_url":"https://api.github.com/repos/ContinuumIO/blaze/git/commits{/sha}","comments_url":"https://api.github.com/repos/ContinuumIO/blaze/comments{/number}","issue_comment_url":"https://api.github.com/repos/ContinuumIO/blaze/issues/comments{/number}","contents_url":"https://api.github.com/repos/ContinuumIO/blaze/contents/{+path}","compare_url":"https://api.github.com/repos/ContinuumIO/blaze/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ContinuumIO/blaze/merges","archive_url":"https://api.github.com/repos/ContinuumIO/blaze/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ContinuumIO/blaze/downloads","issues_url":"https://api.github.com/repos/ContinuumIO/blaze/issues{/number}","pulls_url":"https://api.github.com/repos/ContinuumIO/blaze/pulls{/number}","milestones_url":"https://api.github.com/repos/ContinuumIO/blaze/milestones{/number}","notifications_url":"https://api.github.com/repos/ContinuumIO/blaze/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ContinuumIO/blaze/labels{/name}","releases_url":"https://api.github.com/repos/ContinuumIO/blaze/releases{/id}","created_at":"2012-10-26T14:25:22Z","updated_at":"2015-06-10T06:44:38Z","pushed_at":"2015-06-11T01:10:15Z","git_url":"git://github.com/ContinuumIO/blaze.git","ssh_url":"git@github.com:ContinuumIO/blaze.git","clone_url":"https://github.com/ContinuumIO/blaze.git","svn_url":"https://github.com/ContinuumIO/blaze","homepage":"blaze.pydata.org","size":31021,"stargazers_count":1128,"watchers_count":1128,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":151,"mirror_url":null,"open_issues_count":112,"forks":151,"open_issues":112,"watchers":1128,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125"},"html":{"href":"https://github.com/ContinuumIO/blaze/pull/1125"},"issue":{"href":"https://api.github.com/repos/ContinuumIO/blaze/issues/1125"},"comments":{"href":"https://api.github.com/repos/ContinuumIO/blaze/issues/1125/comments"},"review_comments":{"href":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125/comments"},"review_comment":{"href":"https://api.github.com/repos/ContinuumIO/blaze/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/ContinuumIO/blaze/pulls/1125/commits"},"statuses":{"href":"https://api.github.com/repos/ContinuumIO/blaze/statuses/470adadde388c0fb80c47dafe6355b81ca79d305"}}}}