* using log directory ‘/Users/ripley/R/packages/tests-devel/odbc.Rcheck’ * using R Under development (unstable) (2024-04-09 r86373) * using platform: aarch64-apple-darwin23.4.0 * R was compiled by Apple clang version 15.0.0 (clang-1500.3.9.4) GNU Fortran (GCC) 12.2.0 * running under: macOS Sonoma 14.4.1 * using session charset: UTF-8 * using option ‘--no-stop-on-test-error’ * checking for file ‘odbc/DESCRIPTION’ ... OK * this is package ‘odbc’ version ‘1.4.2’ * 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 executable files ... OK * checking for hidden files and directories ... OK * checking for portable file names ... OK * checking for sufficient/correct file permissions ... OK * checking whether package ‘odbc’ can be installed ... [23s/24s] WARNING Found the following significant warnings: connection.cpp:299:3: warning: 'SQLSetConnectAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:370:26: warning: 'SQLGetDiagRec' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:388:26: warning: 'SQLGetDiagRec' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:734:21: warning: 'SQLFreeHandle' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:746:21: warning: 'SQLAllocHandle' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:753:13: warning: 'SQLSetEnvAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:778:25: warning: 'SQLAllocHandle' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:944:25: warning: 'SQLSetConnectAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1055:26: warning: 'SQLConnect' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1127:26: warning: 'SQLDriverConnect' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1152:29: warning: 'SQLDisconnect' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1184:26: warning: 'SQLGetConnectAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1238:22: warning: 'SQLGetInfo' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1308:17: warning: 'SQLSetConnectAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1332:30: warning: 'SQLEndTran' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1337:17: warning: 'SQLSetConnectAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1353:29: warning: 'SQLEndTran' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1450:26: warning: 'SQLCancel' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1460:25: warning: 'SQLAllocHandle' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1482:29: warning: 'SQLCancel' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1497:25: warning: 'SQLCancel' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1522:26: warning: 'SQLPrepare' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1539:13: warning: 'SQLSetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1696:13: warning: 'SQLSetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1708:26: warning: 'SQLExecDirect' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1745:29: warning: 'SQLFreeStmt' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1758:13: warning: 'SQLSetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1769:25: warning: 'SQLExecute' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1792:26: warning: 'SQLProcedureColumns' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1814:25: warning: 'SQLRowCount' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1830:25: warning: 'SQLNumResultCols' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1839:22: warning: 'SQLFreeStmt' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1851:25: warning: 'SQLNumParams' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1869:13: warning: 'SQLDescribeParam' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1924:17: warning: 'SQLDescribeParam' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2077:13: warning: 'SQLBindParameter' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2148:9: warning: 'SQLBindParameter' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2350:13: warning: 'SQLSetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2360:13: warning: 'SQLSetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2463:13: warning: 'SQLGetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2494:13: warning: 'SQLGetStmtAttr' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2617:25: warning: 'SQLMoreResults' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2646:17: warning: 'SQLBindCol' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2800:25: warning: 'SQLFetchScroll' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2840:30: warning: 'SQLDescribeCol' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2953:21: warning: 'SQLBindCol' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:2968:21: warning: 'SQLBindCol' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:3088:21: warning: 'SQLGetData' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:3146:21: warning: 'SQLGetData' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:3358:21: warning: 'SQLGetData' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:3508:26: warning: 'SQLDrivers' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:3575:26: warning: 'SQLDataSources' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4605:22: warning: 'SQLTables' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4638:22: warning: 'SQLTablePrivileges' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4663:22: warning: 'SQLColumns' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4689:22: warning: 'SQLPrimaryKeys' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4714:22: warning: 'SQLTables' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4748:22: warning: 'SQLTables' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:4777:22: warning: 'SQLTables' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1225:34: warning: 'SQLGetInfo' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:1974:13: warning: 'SQLBindParameter' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] nanodbc/nanodbc.cpp:3413:9: warning: 'SQLGetData' is deprecated: first deprecated in macOS 10.8 [-Wdeprecated-declarations] See ‘/Users/ripley/R/packages/tests-devel/odbc.Rcheck/00install.out’ for details. * used C++ compiler: ‘Apple clang version 15.0.0 (clang-1500.3.9.4)’ * used SDK: ‘MacOSX14.4.sdk’ * 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 code 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 whether startup messages can be suppressed ... 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 ... 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 line endings in shell scripts ... OK * checking line endings in C/C++/Fortran sources/headers ... OK * checking line endings in Makefiles ... OK * checking compilation flags in Makevars ... OK * checking for GNU extensions in Makefiles ... OK * checking for portable use of $(BLAS_LIBS) and $(LAPACK_LIBS) ... OK * checking use of PKG_*FLAGS in Makefiles ... OK * checking include directives in Makefiles ... OK * checking pragmas in C/C++ headers and code ... OK * checking compilation flags used ... OK * checking compiled code ... OK * checking installed files from ‘inst/doc’ ... OK * checking files in ‘vignettes’ ... OK * checking examples ... OK * checking for unstated dependencies in ‘tests’ ... OK * checking tests ... Running ‘testthat.R’ ERROR Running the tests in ‘tests/testthat.R’ failed. Complete output: > # This file is part of the standard setup for testthat. > # It is recommended that you do not modify it. > # > # Where should you do additional test configuration? > # Learn more about the roles of various files in: > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview > # * https://testthat.r-lib.org/articles/special-files.html > > library(testthat) > library(odbc) > > test_check("odbc") [ FAIL 1 | WARN 0 | SKIP 50 | PASS 66 ] ══ Skipped tests (50) ══════════════════════════════════════════════════════════ • On CRAN (49): 'test-dbi-connection.R:8:3', 'test-dbi-connection.R:17:3', 'test-dbi-connection.R:26:3', 'test-driver-databricks.R:36:3', 'test-driver-databricks.R:41:3', 'test-driver-databricks.R:59:3', 'test-driver-databricks.R:71:3', 'test-driver-mysql.R:2:3', 'test-driver-mysql.R:87:3', 'test-driver-mysql.R:91:3', 'test-driver-mysql.R:102:3', 'test-driver-oracle.R:2:3', 'test-driver-oracle.R:13:3', 'test-driver-postgres.R:2:3', 'test-driver-postgres.R:98:3', 'test-driver-postgres.R:104:3', 'test-driver-postgres.R:112:3', 'test-driver-postgres.R:136:3', 'test-driver-postgres.R:155:3', 'test-driver-sql-server.R:2:3', 'test-driver-sql-server.R:85:3', 'test-driver-sql-server.R:121:3', 'test-driver-sql-server.R:134:3', 'test-driver-sql-server.R:143:3', 'test-driver-sql-server.R:151:3', 'test-driver-sql-server.R:173:3', 'test-driver-sql-server.R:194:3', 'test-driver-sql-server.R:221:3', 'test-driver-sql-server.R:232:3', 'test-driver-sql-server.R:238:3', 'test-driver-sql-server.R:248:3', 'test-driver-sql-server.R:258:3', 'test-driver-sql-server.R:268:3', 'test-driver-sql-server.R:290:3', 'test-driver-sqlite.R:2:3', 'test-driver-sqlite.R:134:3', 'test-driver-sqlite.R:141:3', 'test-odbc-config.R:25:3', 'test-odbc-config.R:33:3', 'test-odbc-connection.R:17:3', 'test-odbc-connection.R:24:3', 'test-odbc-connection.R:32:3', 'test-odbc-connection.R:64:3', 'test-odbc-connection.R:70:3', 'test-odbc-connection.R:75:3', 'test-odbc-data-sources.R:2:3', 'test-odbc-drivers.R:2:3', 'test-odbc-drivers.R:11:3', 'test-utils.R:34:3' • odbcinst not available. (1): 'test-odbc-config.R:3:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Failure ('test-driver-sql-server.R:336:7'): captures multiline errors message ── grepl("\n", e$message) is not TRUE `actual`: FALSE `expected`: TRUE Backtrace: ▆ 1. └─base::tryCatch(...) at test-driver-sql-server.R:329:3 2. └─base (local) tryCatchList(expr, classes, parentenv, handlers) 3. └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 4. └─value[[3L]](cond) 5. └─testthat::expect_true(grepl("\n", e$message)) at test-driver-sql-server.R:336:7 [ FAIL 1 | WARN 0 | SKIP 50 | PASS 66 ] Error: Test failures Execution halted * checking for unstated dependencies in vignettes ... OK * checking package vignettes ... OK * checking re-building of vignette outputs ... OK * checking PDF version of manual ... OK * checking HTML version of manual ... OK * checking for detritus in the temp directory ... OK * DONE Status: 1 ERROR, 1 WARNING See ‘/Users/ripley/R/packages/tests-devel/odbc.Rcheck/00check.log’ for details. 55.58 real 42.03 user 7.60 sys