RMySQL报错In .local(conn, statement, ...) : Decimal MySQL column 116 imported as numeric
> sessionInfo()
R version 3.6.3 (2020-02-29)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Deepin 20 Beta
Matrix products: default
BLAS: /usr/lib/x86_64-linux-gnu/blas/libblas.so.3.8.0
LAPACK: /usr/lib/x86_64-linux-gnu/lapack/liblapack.so.3.8.0
locale:
[1] LC_CTYPE=zh_CN.UTF-8 LC_NUMERIC=C LC_TIME=zh_CN.UTF-8 LC_COLLATE=zh_CN.UTF-8 LC_MONETARY=zh_CN.UTF-8
[6] LC_MESSAGES=zh_CN.UTF-8 LC_PAPER=zh_CN.UTF-8 LC_NAME=C LC_ADDRESS=C LC_TELEPHONE=C
[11] LC_MEASUREMENT=zh_CN.UTF-8 LC_IDENTIFICATION=C
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] db_0.0.0.9000
loaded via a namespace (and not attached):
[1] compiler_3.6.3 R6_2.4.1 DBI_1.1.0 tools_3.6.3 RMySQL_0.10.20
我查了:
https://github.com/r-dbi/RMySQL/issues/37
https://github.com/r-dbi/RMySQL/issues/69
都没有给出解决办法(在使用RMySQL的前提下)
请问原因和解决办法分别是什么啊?谢谢.
