{"action":"opened","issue":{"url":"https://api.github.com/repos/mkleehammer/pyodbc/issues/360","repository_url":"https://api.github.com/repos/mkleehammer/pyodbc","labels_url":"https://api.github.com/repos/mkleehammer/pyodbc/issues/360/labels{/name}","comments_url":"https://api.github.com/repos/mkleehammer/pyodbc/issues/360/comments","events_url":"https://api.github.com/repos/mkleehammer/pyodbc/issues/360/events","html_url":"https://github.com/mkleehammer/pyodbc/issues/360","id":303613175,"number":360,"title":"capped at 100k entries when using fetchall()","user":{"login":"eloiup","id":20978596,"avatar_url":"https://avatars2.githubusercontent.com/u/20978596?v=4","gravatar_id":"","url":"https://api.github.com/users/eloiup","html_url":"https://github.com/eloiup","followers_url":"https://api.github.com/users/eloiup/followers","following_url":"https://api.github.com/users/eloiup/following{/other_user}","gists_url":"https://api.github.com/users/eloiup/gists{/gist_id}","starred_url":"https://api.github.com/users/eloiup/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eloiup/subscriptions","organizations_url":"https://api.github.com/users/eloiup/orgs","repos_url":"https://api.github.com/users/eloiup/repos","events_url":"https://api.github.com/users/eloiup/events{/privacy}","received_events_url":"https://api.github.com/users/eloiup/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-08T20:04:13Z","updated_at":"2018-03-08T20:04:13Z","closed_at":null,"author_association":"NONE","body":"### Environment\r\n\r\nwindows 64 bit\r\n\r\n- Python:  2.7\r\n- pyodbc: most recent\r\n- DB: MS SQL\r\n\r\n### Issue\r\n\r\nhi\r\n\r\ni am making a cursor and executing a fetchall on a simple query such as :\r\n\r\n`select id from users`\r\n\r\ni was expecting about 120k entries, but i get exact 100k entries.\r\n\r\ni tried to skip some rows by:\r\n\r\n`select id from users except top X id from users`\r\n\r\nbut i get 100k - X entries.\r\n\r\nive checked the db and it does indeed have ~120k entries\r\ni wld expect fetchall to be uncapped since there are the fetchmany() and fetchval() commands.\r\n\r\nwhat cld be happening? thx"}}
{"actor":{"display_login":"eloiup"}}