{"action":"created","issue":{"url":"https://api.github.com/repos/basho/riak_kv/issues/1618","repository_url":"https://api.github.com/repos/basho/riak_kv","labels_url":"https://api.github.com/repos/basho/riak_kv/issues/1618/labels{/name}","comments_url":"https://api.github.com/repos/basho/riak_kv/issues/1618/comments","events_url":"https://api.github.com/repos/basho/riak_kv/issues/1618/events","html_url":"https://github.com/basho/riak_kv/pull/1618","id":203472765,"number":1618,"title":"correct sorting order wrt nulls first/last spec","user":{"login":"hmmr","id":1107079,"avatar_url":"https://avatars.githubusercontent.com/u/1107079?v=3","gravatar_id":"","url":"https://api.github.com/users/hmmr","html_url":"https://github.com/hmmr","followers_url":"https://api.github.com/users/hmmr/followers","following_url":"https://api.github.com/users/hmmr/following{/other_user}","gists_url":"https://api.github.com/users/hmmr/gists{/gist_id}","starred_url":"https://api.github.com/users/hmmr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hmmr/subscriptions","organizations_url":"https://api.github.com/users/hmmr/orgs","repos_url":"https://api.github.com/users/hmmr/repos","events_url":"https://api.github.com/users/hmmr/events{/privacy}","received_events_url":"https://api.github.com/users/hmmr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"javajolt","id":2357996,"avatar_url":"https://avatars.githubusercontent.com/u/2357996?v=3","gravatar_id":"","url":"https://api.github.com/users/javajolt","html_url":"https://github.com/javajolt","followers_url":"https://api.github.com/users/javajolt/followers","following_url":"https://api.github.com/users/javajolt/following{/other_user}","gists_url":"https://api.github.com/users/javajolt/gists{/gist_id}","starred_url":"https://api.github.com/users/javajolt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javajolt/subscriptions","organizations_url":"https://api.github.com/users/javajolt/orgs","repos_url":"https://api.github.com/users/javajolt/repos","events_url":"https://api.github.com/users/javajolt/events{/privacy}","received_events_url":"https://api.github.com/users/javajolt/received_events","type":"User","site_admin":false},"assignees":[{"login":"javajolt","id":2357996,"avatar_url":"https://avatars.githubusercontent.com/u/2357996?v=3","gravatar_id":"","url":"https://api.github.com/users/javajolt","html_url":"https://github.com/javajolt","followers_url":"https://api.github.com/users/javajolt/followers","following_url":"https://api.github.com/users/javajolt/following{/other_user}","gists_url":"https://api.github.com/users/javajolt/gists{/gist_id}","starred_url":"https://api.github.com/users/javajolt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javajolt/subscriptions","organizations_url":"https://api.github.com/users/javajolt/orgs","repos_url":"https://api.github.com/users/javajolt/repos","events_url":"https://api.github.com/users/javajolt/events{/privacy}","received_events_url":"https://api.github.com/users/javajolt/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2017-01-26T19:57:50Z","updated_at":"2017-01-26T21:39:05Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/basho/riak_kv/pulls/1618","html_url":"https://github.com/basho/riak_kv/pull/1618","diff_url":"https://github.com/basho/riak_kv/pull/1618.diff","patch_url":"https://github.com/basho/riak_kv/pull/1618.patch"},"body":"This fixes the ordering logic of ORDER BY for columns with nulls, to conform to the SQL Standard (https://drive.google.com/file/d/0B-2H_9GJ40JpMDAwY0VyWjkwSWc, page 617). Specifically, a column with nulls will be sorted as follows:\r\n\r\nASC NULLS LAST yields\r\n```1, 2, 3, null, null```\r\nASC NULLS FIRST yields\r\n```null, null, 1, 2, 3```\r\nDESC NULLS LAST yields\r\n```null, null, 3, 2, 1```\r\nDESC NULLS FIRST yields\r\n```3, 2, 1, null, null```\r\n\r\nNote that the test was also updated to reflect this change: https://github.com/basho/riak_test/pull/1257/commits/c595fe7e0f5a8d8d53c18f34383bc499f5bae73b."},"comment":{"url":"https://api.github.com/repos/basho/riak_kv/issues/comments/275522194","html_url":"https://github.com/basho/riak_kv/pull/1618#issuecomment-275522194","issue_url":"https://api.github.com/repos/basho/riak_kv/issues/1618","id":275522194,"user":{"login":"DSomogyi","id":9661207,"avatar_url":"https://avatars.githubusercontent.com/u/9661207?v=3","gravatar_id":"","url":"https://api.github.com/users/DSomogyi","html_url":"https://github.com/DSomogyi","followers_url":"https://api.github.com/users/DSomogyi/followers","following_url":"https://api.github.com/users/DSomogyi/following{/other_user}","gists_url":"https://api.github.com/users/DSomogyi/gists{/gist_id}","starred_url":"https://api.github.com/users/DSomogyi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DSomogyi/subscriptions","organizations_url":"https://api.github.com/users/DSomogyi/orgs","repos_url":"https://api.github.com/users/DSomogyi/repos","events_url":"https://api.github.com/users/DSomogyi/events{/privacy}","received_events_url":"https://api.github.com/users/DSomogyi/received_events","type":"User","site_admin":false},"created_at":"2017-01-26T21:39:05Z","updated_at":"2017-01-26T21:39:05Z","body":"create jira issue"}}
{"actor":{"display_login":"DSomogyi"}}