{"action":"created","issue":{"url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/issues/121","repository_url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage","labels_url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/issues/121/labels{/name}","comments_url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/issues/121/comments","events_url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/issues/121/events","html_url":"https://github.com/Particular/NServiceBus.Persistence.AzureStorage/pull/121","id":195440736,"number":121,"title":"Simplify and further restrict timeout query fix","user":{"login":"boblangley","id":2546913,"avatar_url":"https://avatars.githubusercontent.com/u/2546913?v=3","gravatar_id":"","url":"https://api.github.com/users/boblangley","html_url":"https://github.com/boblangley","followers_url":"https://api.github.com/users/boblangley/followers","following_url":"https://api.github.com/users/boblangley/following{/other_user}","gists_url":"https://api.github.com/users/boblangley/gists{/gist_id}","starred_url":"https://api.github.com/users/boblangley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boblangley/subscriptions","organizations_url":"https://api.github.com/users/boblangley/orgs","repos_url":"https://api.github.com/users/boblangley/repos","events_url":"https://api.github.com/users/boblangley/events{/privacy}","received_events_url":"https://api.github.com/users/boblangley/received_events","type":"User","site_admin":false},"labels":[{"id":497055381,"url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/labels/in%20progress","name":"in progress","color":"ededed","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-14T04:58:36Z","updated_at":"2016-12-16T09:07:34Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/pulls/121","html_url":"https://github.com/Particular/NServiceBus.Persistence.AzureStorage/pull/121","diff_url":"https://github.com/Particular/NServiceBus.Persistence.AzureStorage/pull/121.diff","patch_url":"https://github.com/Particular/NServiceBus.Persistence.AzureStorage/pull/121.patch"},"body":"This PR simplifies the query assignment and adds additional restrictions on the valid primary keys when `lastSuccessFullRead` is not found.\r\n\r\nThe greater than / less than primary key conditions will still return some extra rows where the timeoutid or sagaid guid value falls within the string sort range of the conditional dates, this will just reduce the number of extra rows returned. The latter part of the function will further eliminate them."},"comment":{"url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/issues/comments/267549116","html_url":"https://github.com/Particular/NServiceBus.Persistence.AzureStorage/pull/121#issuecomment-267549116","issue_url":"https://api.github.com/repos/Particular/NServiceBus.Persistence.AzureStorage/issues/121","id":267549116,"user":{"login":"yvesgoeleven","id":471354,"avatar_url":"https://avatars.githubusercontent.com/u/471354?v=3","gravatar_id":"","url":"https://api.github.com/users/yvesgoeleven","html_url":"https://github.com/yvesgoeleven","followers_url":"https://api.github.com/users/yvesgoeleven/followers","following_url":"https://api.github.com/users/yvesgoeleven/following{/other_user}","gists_url":"https://api.github.com/users/yvesgoeleven/gists{/gist_id}","starred_url":"https://api.github.com/users/yvesgoeleven/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yvesgoeleven/subscriptions","organizations_url":"https://api.github.com/users/yvesgoeleven/orgs","repos_url":"https://api.github.com/users/yvesgoeleven/repos","events_url":"https://api.github.com/users/yvesgoeleven/events{/privacy}","received_events_url":"https://api.github.com/users/yvesgoeleven/received_events","type":"User","site_admin":false},"created_at":"2016-12-16T09:07:34Z","updated_at":"2016-12-16T09:07:34Z","body":"👍 for me, this is still a better approach than #122"}}
{"actor":{"display_login":"yvesgoeleven"}}