Skip to content
Prev 22519 / 398502 Next

RMySQL fetch defaults to N=500?

It appears that fetch() gets only the first 500 rows by default.  I
don't see this in the documentation, but 

    timeinfo <- fetch(rs)

gets only 500 rows where

    timeinfo <- fetch(rs,n=-1)

gets (correctly) 736 for the same query.  Is this an undocumented
feature?  I played with this data for an alarming amount of time
before I realized that I was missing a third of the data.  I appear to
be using version 0.4-5.  I'll upgrade to 0.4-6 Real Soon Now.  My
first attempt failed for some reason.