* using log directory 'd:/Rcompile/CRANpkg/local/3.6/RSQL.Rcheck' * using R version 3.6.3 (2020-02-29) * using platform: x86_64-w64-mingw32 (64-bit) * using session charset: ISO8859-1 * checking for file 'RSQL/DESCRIPTION' ... OK * checking extension type ... Package * this is package 'RSQL' version '0.1.4' * package encoding: UTF-8 * checking package namespace information ... OK * checking package dependencies ... OK * checking if this is a source package ... OK * checking if there is a namespace ... OK * checking for hidden files and directories ... OK * checking for portable file names ... OK * checking whether package 'RSQL' can be installed ... OK * checking installed package size ... OK * checking package directory ... OK * checking 'build' directory ... OK * checking DESCRIPTION meta-information ... OK * checking top-level files ... OK * checking for left-over files ... OK * checking index information ... OK * checking package subdirectories ... OK * checking R files for non-ASCII characters ... OK * checking R files for syntax errors ... OK * checking whether the package can be loaded ... OK * checking whether the package can be loaded with stated dependencies ... OK * checking whether the package can be unloaded cleanly ... OK * checking whether the namespace can be loaded with stated dependencies ... OK * checking whether the namespace can be unloaded cleanly ... OK * checking loading without being on the library search path ... OK * checking use of S3 registration ... OK * checking dependencies in R code ... OK * checking S3 generic/method consistency ... OK * checking replacement functions ... OK * checking foreign function calls ... OK * checking R code for possible problems ... [5s] OK * checking Rd files ... OK * checking Rd metadata ... OK * checking Rd cross-references ... OK * checking for missing documentation entries ... OK * checking for code/documentation mismatches ... OK * checking Rd \usage sections ... OK * checking Rd contents ... OK * checking for unstated dependencies in examples ... OK * checking installed files from 'inst/doc' ... OK * checking files in 'vignettes' ... OK * checking examples ... [2s] OK * checking for unstated dependencies in 'tests' ... OK * checking tests ... [4s] ERROR Running 'testthat.R' [4s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(DBI) > library(RSQLite) > library(RSQL) > library(lgr) > library(dplyr) Attaching package: 'dplyr' The following object is masked from 'package:testthat': matches The following objects are masked from 'package:stats': filter, lag The following objects are masked from 'package:base': intersect, setdiff, setequal, union > > log.levels <- lgr::get_log_levels() > > lgr$set_threshold(log.levels["debug"]) > > > > test_check("RSQL") Finalizing object and disconnecting == Failed tests ================================================================ Finalizing object and disconnecting -- Error (test_sql_lib.R:138:5): sql_lib select, insert, update and delete with dataframe and stuffed apostrophe -- Error: 'nchar()' requires a character vector Backtrace: x 1. \-rsql$gen_update("mtcars", values = update_values, where_values = where_values_df) test_sql_lib.R:138:4 2. \-RSQL:::sql_gen_update(...) 3. \-RSQL::stuff_df_quoted(text.df = values.df) 4. \-base::sapply(text.df[i, ], FUN = rm_quotes) 5. \-base::lapply(X = X, FUN = FUN, ...) 6. \-RSQL:::FUN(X[[i]], ...) 7. \-base::substr(text, nchar(text), nchar(text)) [ FAIL 1 | WARN 7 | SKIP 0 | PASS 20 ] Error: Test failures Execution halted * checking for unstated dependencies in vignettes ... OK * checking package vignettes in 'inst/doc' ... OK * checking re-building of vignette outputs ... [1s] OK * checking PDF version of manual ... OK * DONE Status: 1 ERROR