search

ankane / dbx

A fast, easy-to-use database library for R
Other
187 stars 15 forks source link

500 records returned by default? #2

Closed cspenn closed 6 years ago

cspenn commented 6 years ago

When using: 

getquery <-
    c(
      "SELECT * from MYTABLE order by `Date` ASC"
    )

with dbx, it returns a dataframe of 500 rows.

When using RMySQL, it returns the full 32,625 rows that are in the DB.

Is this intended behavior?

ankane commented 6 years ago

Hey @cspenn, thanks for reporting 👍 Fixed now.