{"action":"opened","issue":{"url":"https://api.github.com/repos/vrogier/ocilib/issues/29","repository_url":"https://api.github.com/repos/vrogier/ocilib","labels_url":"https://api.github.com/repos/vrogier/ocilib/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/vrogier/ocilib/issues/29/comments","events_url":"https://api.github.com/repos/vrogier/ocilib/issues/29/events","html_url":"https://github.com/vrogier/ocilib/issues/29","id":133266134,"number":29,"title":"Set Fetch\\Prefetch not working with Execute","user":{"login":"alexeyvo","id":2393951,"avatar_url":"https://avatars.githubusercontent.com/u/2393951?v=3","gravatar_id":"","url":"https://api.github.com/users/alexeyvo","html_url":"https://github.com/alexeyvo","followers_url":"https://api.github.com/users/alexeyvo/followers","following_url":"https://api.github.com/users/alexeyvo/following{/other_user}","gists_url":"https://api.github.com/users/alexeyvo/gists{/gist_id}","starred_url":"https://api.github.com/users/alexeyvo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexeyvo/subscriptions","organizations_url":"https://api.github.com/users/alexeyvo/orgs","repos_url":"https://api.github.com/users/alexeyvo/repos","events_url":"https://api.github.com/users/alexeyvo/events{/privacy}","received_events_url":"https://api.github.com/users/alexeyvo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-12T15:17:32Z","updated_at":"2016-02-12T15:17:32Z","closed_at":null,"body":"Hi I noticed that when I do this:\r\n```\r\n  Statement st(cn);\r\n  st.SetFetchSize(2);\r\n  st.SetPrefetchSize(5);\r\n  st.Execute(\"SELECT * from mytable\");\r\n```\r\ngetters returns values I set, however rows fetched using default values(20, 20) I used wireshark to confirm that.\r\n\r\nBut when I do this:\r\n```\r\n  Statement st(cn);\r\n  st.Prepare(\"SELECT * from mytable\");\r\n  st.SetFetchSize(2);\r\n  st.SetPrefetchSize(5);\r\n  st.ExecutePrepared();\r\n```\r\nit fetch rows as expected. It think this should be fixed, or at least doc for setters should notice they should be called after prepare and getters should return actual values used."}}