[R] RMySQL fetch defaults to N=500?

Jay Pfaffman pfaffman at relaxpc.com
Fri Aug 9 02:07:43 CEST 2002


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.

-- 
Jay Pfaffman                           pfaffman at relaxpc.com
+1-415-821-7507 (H)                    +1-415-810-2238 (M)

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list