{"action":"created","issue":{"url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/issues/29","labels_url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/issues/29/comments","events_url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/issues/29/events","html_url":"https://github.com/fsprojects/DynamoDb.SQL/issues/29","id":109522075,"number":29,"title":"Querying on index with very long number","user":{"login":"zairnamlas","id":11578627,"avatar_url":"https://avatars.githubusercontent.com/u/11578627?v=3","gravatar_id":"","url":"https://api.github.com/users/zairnamlas","html_url":"https://github.com/zairnamlas","followers_url":"https://api.github.com/users/zairnamlas/followers","following_url":"https://api.github.com/users/zairnamlas/following{/other_user}","gists_url":"https://api.github.com/users/zairnamlas/gists{/gist_id}","starred_url":"https://api.github.com/users/zairnamlas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zairnamlas/subscriptions","organizations_url":"https://api.github.com/users/zairnamlas/orgs","repos_url":"https://api.github.com/users/zairnamlas/repos","events_url":"https://api.github.com/users/zairnamlas/events{/privacy}","received_events_url":"https://api.github.com/users/zairnamlas/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"theburningmonk","id":546969,"avatar_url":"https://avatars.githubusercontent.com/u/546969?v=3","gravatar_id":"","url":"https://api.github.com/users/theburningmonk","html_url":"https://github.com/theburningmonk","followers_url":"https://api.github.com/users/theburningmonk/followers","following_url":"https://api.github.com/users/theburningmonk/following{/other_user}","gists_url":"https://api.github.com/users/theburningmonk/gists{/gist_id}","starred_url":"https://api.github.com/users/theburningmonk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theburningmonk/subscriptions","organizations_url":"https://api.github.com/users/theburningmonk/orgs","repos_url":"https://api.github.com/users/theburningmonk/repos","events_url":"https://api.github.com/users/theburningmonk/events{/privacy}","received_events_url":"https://api.github.com/users/theburningmonk/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-10-02T16:08:52Z","updated_at":"2015-10-08T00:01:56Z","closed_at":null,"body":"Hi Yan,\r\nThis could be the same as I mentioned before which you fixed it with long numbers. This time when I'm querying on index with a long number then it is not returning any results and with small number it does. I debugged it a little and found that it is jumping one number up. Following is the query I'm trying and the snapshot of the converted filter\r\n\r\nThis works\r\nSELECT * FROM pd_cs_friendshiprequest WHERE ForUserId = 578318698 WITH(Index(ForUserIdIndex, false), NoConsistentRead)\r\n\r\nThis doesn't work\r\nSELECT * FROM pd_cs_friendshiprequest WHERE ForUserId = 10205471065416239 WITH(Index(ForUserIdIndex, false), NoConsistentRead)\r\n\r\nhttp://screencast.com/t/Ti4tizS51\r\n\r\nI guess, it will be again a simple fix while converting string to number.\r\nHoping to hear from you soon."},"comment":{"url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/issues/comments/146371069","html_url":"https://github.com/fsprojects/DynamoDb.SQL/issues/29#issuecomment-146371069","issue_url":"https://api.github.com/repos/fsprojects/DynamoDb.SQL/issues/29","id":146371069,"user":{"login":"theburningmonk","id":546969,"avatar_url":"https://avatars.githubusercontent.com/u/546969?v=3","gravatar_id":"","url":"https://api.github.com/users/theburningmonk","html_url":"https://github.com/theburningmonk","followers_url":"https://api.github.com/users/theburningmonk/followers","following_url":"https://api.github.com/users/theburningmonk/following{/other_user}","gists_url":"https://api.github.com/users/theburningmonk/gists{/gist_id}","starred_url":"https://api.github.com/users/theburningmonk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theburningmonk/subscriptions","organizations_url":"https://api.github.com/users/theburningmonk/orgs","repos_url":"https://api.github.com/users/theburningmonk/repos","events_url":"https://api.github.com/users/theburningmonk/events{/privacy}","received_events_url":"https://api.github.com/users/theburningmonk/received_events","type":"User","site_admin":false},"created_at":"2015-10-08T00:01:56Z","updated_at":"2015-10-08T00:01:56Z","body":"@zairnamlas - did the fix work for you guys? If so, I'll close the issue"}}