Stalled MySQL query with RMySQL in R 2.13.0 on Win 7 (but works with small number of rows)

I have a MySQL query that completes quickly in MySQL workbench (0.28 sec),
but stalls in R 2.13.0 using RMySQL. When the query stalls, I can break and
get the following

db <- dbConnect(dbDriver("MySQL"), dbname = "finance", user = "root",

password = "root")

temp <- dbGetQuery(db, query.compustat)

Warning messages:
1: In mysqlFetch(res, n, ...) :
  RS-DBI driver warning: (error while fetching rows)
2: In mysqlQuickSQL(conn, statement, ...) : pending rows

But, if I limit myself to a much smaller query result, the query completes
just fine (my full query has about 1000 rows, which doesn't strike me as
particularly large).