Kun Ren
Kun Ren
@jennybc Thanks a lot!
That's great!
Executing via `Rscript`, I tried `dbColumnInfo` but this ends up with the following error: ``` Loading required package: methods Error in .local(dbObj, ...) : internal error in RS_DBI_getConnection: corrupt connection...
Through some experiments, I find that when `select *` or `select A, B, C, ...` where * or the specified columns represent more than 144 `DECIMAL` columns, the error will...
When I adjust `MySQL()` to `MySQL(fetch.default.rec = 10000)` then the error is magically gone.
`MySQL(fetch.default.rec = 10000)` only works in RStudio, not in R terminal. The same code works fine in RStudio but crashes every time in R terminal. When the script is added...
I capture the error and stacktrace as following: ``` Available environments had calls: 1: source("R/test.R") 2: withVisible(eval(ei, envir)) 3: eval(ei, envir) 4: eval(ei, envir) 5: test.R#6: dbGetQuery(con, "select * from...
In the same session, when I create the connection and disconnect, and connect again, then the error disappears magically. But when multiple tables are queried, the error still occurs like...
It is CRAN version.
I switch to `RMariaDB` and this problem is gone.