* using log directory ‘/Volumes/Builds/packages/big-sur-x86_64/results/4.4/dbplyr.Rcheck’
* using R version 4.4.1 (2024-06-14)
* using platform: x86_64-apple-darwin20
* R was compiled by
    Apple clang version 14.0.0 (clang-1400.0.29.202)
    GNU Fortran (GCC) 12.2.0
* running under: macOS Ventura 13.3.1
* using session charset: UTF-8
* checking for file ‘dbplyr/DESCRIPTION’ ... OK
* checking extension type ... Package
* this is package ‘dbplyr’ version ‘2.5.0’
* 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 ‘dbplyr’ can be installed ... [15s/28s] OK
See 'https://www.r-project.org/nosvn/R.check/r-oldrel-macos-x86_64/dbplyr-00install.html' for details.
* 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 ... [1s/2s] OK
* checking whether the package can be loaded with stated dependencies ... [1s/1s] OK
* checking whether the package can be unloaded cleanly ... [1s/1s] OK
* checking whether the namespace can be loaded with stated dependencies ... [1s/1s] OK
* checking whether the namespace can be unloaded cleanly ... [1s/2s] OK
* checking loading without being on the library search path ... [1s/1s] OK
* checking whether startup messages can be suppressed ... [1s/1s] 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 ... [16s/30s] OK
* checking Rd files ... [1s/1s] 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 ... [9s/17s] OK
* checking for unstated dependencies in ‘tests’ ... OK
* checking tests ... [102s/102s] ERROR
  Running ‘testthat.R’ [101s/101s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(dbplyr)
  > 
  > test_check("dbplyr")
  Starting 2 test processes
  [ FAIL 5 | WARN 0 | SKIP 358 | PASS 1578 ]
  
  ══ Skipped tests (358) ═════════════════════════════════════════════════════════
  • Need at least two srcs to compare (5): 'test-verb-compute.R:34:3',
    'test-verb-copy-to.R:18:3', 'test-verb-copy-to.R:27:3',
    'test-verb-set-ops.R:49:3', 'test-verb-set-ops.R:93:3'
  • No MariaDB (5): 'test-backend-mysql.R:104:3', 'test-backend-mysql.R:109:3',
    'test-backend-mysql.R:114:3', 'test-backend-mysql.R:125:3',
    'test-backend-mysql.R:153:3'
  • No mssql (13): 'test-backend-mssql.R:375:3', 'test-backend-mssql.R:407:3',
    'test-backend-mssql.R:426:3', 'test-backend-mssql.R:442:3',
    'test-backend-mssql.R:468:3', 'test-backend-mssql.R:495:3',
    'test-backend-mssql.R:519:3', 'test-backend-mssql.R:544:3',
    'test-backend-mssql.R:570:3', 'test-backend-mssql.R:597:3',
    'test-backend-mssql.R:622:3', 'test-backend-mssql.R:649:3',
    'test-backend-mssql.R:674:3'
  • No postgres (9): 'test-backend-postgres.R:190:3',
    'test-backend-postgres.R:198:3', 'test-backend-postgres.R:205:3',
    'test-backend-postgres.R:219:3', 'test-backend-postgres.R:280:3',
    'test-backend-postgres.R:295:3', 'test-backend-postgres.R:350:3',
    'test-backend-postgres.R:410:3', 'test-verb-joins.R:103:3'
  • On CRAN (320): 'test-backend-access.R:69:3', 'test-backend-hana.R:4:3',
    'test-backend-hana.R:17:3', 'test-backend-hive.R:13:3',
    'test-backend-impala.R:22:3', 'test-backend-.R:75:3', 'test-backend-.R:84:3',
    'test-backend-.R:90:3', 'test-backend-.R:107:3', 'test-backend-.R:170:3',
    'test-backend-.R:182:3', 'test-backend-mysql.R:49:3',
    'test-backend-mysql.R:73:3', 'test-backend-oracle.R:23:3',
    'test-backend-oracle.R:31:3', 'test-backend-oracle.R:43:3',
    'test-backend-oracle.R:59:3', 'test-backend-oracle.R:76:3',
    'test-backend-postgres.R:115:3', 'test-backend-postgres.R:123:3',
    'test-backend-postgres.R:139:3', 'test-backend-postgres.R:173:3',
    'test-backend-mssql.R:64:3', 'test-backend-mssql.R:105:3',
    'test-backend-mssql.R:125:3', 'test-backend-mssql.R:176:3',
    'test-backend-mssql.R:191:3', 'test-backend-mssql.R:197:3',
    'test-backend-mssql.R:209:3', 'test-backend-mssql.R:219:3',
    'test-backend-mssql.R:231:3', 'test-backend-mssql.R:254:3',
    'test-backend-mssql.R:276:3', 'test-backend-mssql.R:296:3',
    'test-backend-mssql.R:319:3', 'test-backend-mssql.R:339:3',
    'test-backend-mssql.R:355:3', 'test-backend-mssql.R:367:3',
    'test-backend-mssql.R:394:3', 'test-backend-redshift.R:51:3',
    'test-backend-snowflake.R:158:3', 'test-backend-snowflake.R:168:3',
    'test-backend-sqlite.R:41:3', 'test-backend-sqlite.R:51:3',
    'test-backend-sqlite.R:57:3', 'test-backend-sqlite.R:105:3',
    'test-backend-teradata.R:55:3', 'test-backend-teradata.R:62:3',
    'test-backend-teradata.R:68:3', 'test-backend-teradata.R:78:3',
    'test-backend-teradata.R:85:3', 'test-backend-teradata.R:92:3',
    'test-build-sql.R:3:3', 'test-build-sql.R:58:3', 'test-build-sql.R:70:3',
    'test-db-io.R:6:3', 'test-db-io.R:24:3', 'test-db-io.R:49:3',
    'test-db-sql.R:8:3', 'test-db-sql.R:28:3', 'test-ident.R:14:3',
    'test-lazy-join-query.R:18:3', 'test-lazy-select-query.R:4:3',
    'test-escape.R:112:3', 'test-escape.R:123:3', 'test-pillar.R:2:3',
    'test-query-join.R:6:3', 'test-query-join.R:16:3', 'test-query-join.R:25:3',
    'test-query-join.R:32:3', 'test-query-join.R:40:3',
    'test-query-semi-join.R:4:3', 'test-query-semi-join.R:11:3',
    'test-query-select.R:7:3', 'test-query-select.R:16:3',
    'test-query-select.R:20:3', 'test-query-set-op.R:5:3',
    'test-query-set-op.R:10:3', 'test-schema.R:2:3', 'test-sql-build.R:3:3',
    'test-sql.R:8:3', 'test-table-name.R:2:3', 'test-table-name.R:14:3',
    'test-table-name.R:83:3', 'test-table-name.R:93:3', 'test-tbl-lazy.R:7:3',
    'test-tbl-lazy.R:11:3', 'test-tbl-lazy.R:22:3', 'test-tbl-lazy.R:45:3',
    'test-tbl-lazy.R:52:3', 'test-tbl-sql.R:33:3', 'test-tbl-sql.R:58:3',
    'test-tbl-sql.R:68:3', 'test-rows.R:7:3', 'test-rows.R:53:3',
    'test-rows.R:66:3', 'test-rows.R:121:3', 'test-rows.R:162:3',
    'test-rows.R:193:3', 'test-rows.R:222:3', 'test-rows.R:230:3',
    'test-rows.R:277:3', 'test-rows.R:317:3', 'test-rows.R:337:3',
    'test-rows.R:352:3', 'test-rows.R:436:3', 'test-rows.R:477:3',
    'test-rows.R:524:3', 'test-rows.R:542:3', 'test-rows.R:590:3',
    'test-rows.R:616:3', 'test-rows.R:657:3', 'test-rows.R:699:3',
    'test-rows.R:743:3', 'test-rows.R:781:3', 'test-rows.R:835:3',
    'test-rows.R:875:3', 'test-rows.R:916:3', 'test-rows.R:962:3',
    'test-rows.R:978:3', 'test-tidyeval.R:78:3',
    'test-translate-sql-conditional.R:3:3',
    'test-translate-sql-conditional.R:10:3',
    'test-translate-sql-conditional.R:15:3',
    'test-translate-sql-conditional.R:27:3',
    'test-translate-sql-conditional.R:62:3',
    'test-translate-sql-conditional.R:70:3',
    'test-translate-sql-conditional.R:165:3',
    'test-translate-sql-conditional.R:234:3',
    'test-translate-sql-conditional.R:251:3',
    'test-translate-sql-conditional.R:283:3',
    'test-translate-sql-conditional.R:290:3', 'test-translate-sql-cut.R:103:3',
    'test-translate-sql-cut.R:146:3', 'test-translate-sql-helpers.R:2:3',
    'test-translate-sql-helpers.R:26:3', 'test-translate-sql-helpers.R:43:3',
    'test-translate-sql-helpers.R:47:3', 'test-translate-sql-helpers.R:84:3',
    'test-translate-sql-helpers.R:110:3', 'test-tidyeval-across.R:57:3',
    'test-tidyeval-across.R:101:3', 'test-tidyeval-across.R:222:3',
    'test-tidyeval-across.R:229:3', 'test-tidyeval-across.R:237:3',
    'test-tidyeval-across.R:371:3', 'test-tidyeval-across.R:380:3',
    'test-tidyeval-across.R:387:3', 'test-tidyeval-across.R:430:3',
    'test-tidyeval-across.R:447:3', 'test-tidyeval-across.R:463:3',
    'test-tidyeval-across.R:470:3', 'test-tidyeval-across.R:477:3',
    'test-tidyeval-across.R:512:3', 'test-tidyeval-across.R:540:3',
    'test-tidyeval-across.R:548:3', 'test-tidyeval-across.R:628:3',
    'test-tidyeval-across.R:634:3', 'test-tidyeval-across.R:640:3',
    'test-tidyeval-across.R:650:3', 'test-translate-sql-quantile.R:3:3',
    'test-translate-sql-string.R:15:3', 'test-translate-sql-window.R:102:3',
    'test-translate-sql-window.R:151:3', 'test-translate-sql-window.R:158:3',
    'test-translate-sql-window.R:209:3', 'test-translate-sql-window.R:230:3',
    'test-translate-sql.R:6:3', 'test-translate-sql.R:17:3',
    'test-verb-arrange.R:16:3', 'test-verb-arrange.R:21:3',
    'test-verb-arrange.R:45:3', 'test-verb-arrange.R:64:3',
    'test-verb-compute.R:58:3', 'test-verb-compute.R:107:3',
    'test-verb-compute.R:116:3', 'test-verb-compute.R:125:3',
    'test-verb-copy-to.R:55:3', 'test-verb-copy-to.R:71:3',
    'test-verb-copy-to.R:94:3', 'test-verb-copy-to.R:102:3',
    'test-verb-copy-to.R:128:3', 'test-verb-count.R:4:3',
    'test-verb-count.R:64:3', 'test-verb-do.R:33:3', 'test-verb-do.R:71:3',
    'test-verb-distinct.R:149:3', 'test-verb-distinct.R:191:3',
    'test-verb-distinct.R:200:3', 'test-verb-fill.R:45:3',
    'test-verb-fill.R:58:3', 'test-verb-fill.R:71:3', 'test-verb-fill.R:84:3',
    'test-verb-fill.R:98:3', 'test-verb-fill.R:104:3', 'test-verb-expand.R:7:3',
    'test-verb-expand.R:19:3', 'test-verb-expand.R:24:3',
    'test-verb-expand.R:30:3', 'test-verb-expand.R:50:3',
    'test-verb-expand.R:54:3', 'test-verb-expand.R:58:3',
    'test-verb-expand.R:63:3', 'test-verb-expand.R:104:3',
    'test-verb-expand.R:110:3', 'test-verb-expand.R:132:3',
    'test-verb-group_by.R:12:3', 'test-verb-group_by.R:19:3',
    'test-verb-group_by.R:26:3', 'test-verb-group_by.R:34:3',
    'test-verb-group_by.R:157:3', 'test-verb-filter.R:22:3',
    'test-verb-filter.R:57:3', 'test-verb-filter.R:63:3',
    'test-verb-filter.R:170:3', 'test-verb-filter.R:186:3',
    'test-verb-filter.R:221:3', 'test-verb-filter.R:295:3',
    'test-verb-filter.R:331:3', 'test-verb-filter.R:341:3',
    'test-verb-mutate.R:30:3', 'test-verb-mutate.R:43:3',
    'test-verb-mutate.R:57:3', 'test-verb-mutate.R:64:3',
    'test-verb-mutate.R:105:3', 'test-verb-mutate.R:129:3',
    'test-verb-mutate.R:156:3', 'test-verb-mutate.R:176:3',
    'test-verb-mutate.R:188:3', 'test-verb-mutate.R:416:3',
    'test-verb-mutate.R:423:3', 'test-verb-mutate.R:474:3',
    'test-verb-mutate.R:481:3', 'test-verb-mutate.R:488:3',
    'test-verb-pivot-longer.R:13:3', 'test-verb-pivot-longer.R:31:3',
    'test-verb-pivot-longer.R:40:3', 'test-verb-pivot-longer.R:44:3',
    'test-verb-pivot-longer.R:81:3', 'test-verb-pivot-longer.R:88:3',
    'test-verb-pivot-longer.R:142:3', 'test-verb-pivot-longer.R:158:3',
    'test-verb-pivot-longer.R:235:3', 'test-verb-pivot-longer.R:251:3',
    'test-verb-pivot-longer.R:259:3', 'test-verb-joins.R:31:3',
    'test-verb-joins.R:54:3', 'test-verb-joins.R:71:3',
    'test-verb-joins.R:172:3', 'test-verb-joins.R:284:3',
    'test-verb-joins.R:366:3', 'test-verb-joins.R:503:3',
    'test-verb-joins.R:537:3', 'test-verb-joins.R:581:3',
    'test-verb-joins.R:633:3', 'test-verb-joins.R:653:3',
    'test-verb-joins.R:680:3', 'test-verb-joins.R:695:3',
    'test-verb-joins.R:858:3', 'test-verb-joins.R:905:3',
    'test-verb-joins.R:975:3', 'test-verb-joins.R:985:3',
    'test-verb-joins.R:1007:3', 'test-verb-joins.R:1016:3',
    'test-verb-joins.R:1026:3', 'test-verb-joins.R:1066:3',
    'test-verb-joins.R:1112:3', 'test-verb-joins.R:1317:3',
    'test-verb-pull.R:45:3', 'test-verb-select.R:28:3',
    'test-verb-select.R:65:3', 'test-verb-select.R:122:3',
    'test-verb-select.R:183:3', 'test-verb-select.R:206:3',
    'test-verb-select.R:242:3', 'test-verb-select.R:281:3',
    'test-verb-select.R:307:3', 'test-verb-select.R:321:3',
    'test-verb-select.R:344:3', 'test-verb-select.R:352:3',
    'test-verb-select.R:367:3', 'test-verb-set-ops.R:63:3',
    'test-verb-pivot-wider.R:23:3', 'test-verb-pivot-wider.R:48:3',
    'test-verb-pivot-wider.R:60:3', 'test-verb-pivot-wider.R:237:3',
    'test-verb-pivot-wider.R:245:3', 'test-verb-pivot-wider.R:267:3',
    'test-verb-pivot-wider.R:279:3', 'test-verb-pivot-wider.R:328:3',
    'test-verb-pivot-wider.R:347:3', 'test-verb-pivot-wider.R:378:3',
    'test-verb-pivot-wider.R:417:3', 'test-verb-pivot-wider.R:476:3',
    'test-verb-pivot-wider.R:481:3', 'test-verb-pivot-wider.R:486:3',
    'test-verb-pivot-wider.R:493:3', 'test-verb-pivot-wider.R:500:3',
    'test-verb-slice.R:3:3', 'test-verb-slice.R:17:3', 'test-verb-slice.R:27:3',
    'test-verb-slice.R:35:3', 'test-verb-slice.R:49:3', 'test-verb-slice.R:64:3',
    'test-verb-slice.R:75:3', 'test-verb-slice.R:103:3',
    'test-verb-slice.R:118:3', 'test-verb-summarise.R:2:3',
    'test-verb-summarise.R:27:3', 'test-verb-summarise.R:50:3',
    'test-verb-summarise.R:72:3', 'test-verb-summarise.R:82:3',
    'test-verb-summarise.R:113:3', 'test-verb-summarise.R:122:3',
    'test-verb-summarise.R:133:3', 'test-verb-uncount.R:5:3',
    'test-verb-window.R:2:3', 'test-verb-window.R:13:3',
    'test-verb-window.R:19:3', 'test-verb-window.R:33:3'
  • `grouped_df()` needs a `name_repair` argument (1):
    'test-verb-pivot-wider.R:81:3'
  • empty test (1): 'test-verb-set-ops.R:110:1'
  • identical(Sys.getenv("GITHUB_POSTGRES"), "true") is not TRUE (1):
    'test-backend-postgres-old.R:2:3'
  • not clear whether test makes sense (2): 'test-verb-arrange.R:2:3',
    'test-verb-arrange.R:131:3'
  • not yet correctly supported (1): 'test-tidyeval-across.R:272:3'
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-verb-pivot-longer.R:59:3'): can handle missing combinations ────
  Error: vector memory limit of 16.0 Gb reached, see mem.maxVSize()
  Backtrace:
      ▆
   1. ├─tidyr::pivot_longer(...) at test-verb-pivot-longer.R:59:3
   2. └─dbplyr:::pivot_longer.tbl_lazy(...)
   3.   └─tidyr::build_longer_spec(...)
   4.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   5.       └─tidyr:::str_split_fixed(...)
   6.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  ── Error ('test-verb-pivot-longer.R:97:3'): `values_transform` works with single functions (#1284) ──
  Error: vector memory limit of 16.0 Gb reached, see mem.maxVSize()
  Backtrace:
      ▆
   1. ├─... %>% collect() at test-verb-pivot-longer.R:97:3
   2. ├─dplyr::collect(.)
   3. ├─tidyr::pivot_longer(...)
   4. └─dbplyr:::pivot_longer.tbl_lazy(...)
   5.   └─tidyr::build_longer_spec(...)
   6.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   7.       └─tidyr:::str_split_fixed(...)
   8.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  ── Error ('test-verb-pivot-longer.R:113:3'): `names_ptypes` and `names_transform` ──
  Error: vector memory limit of 16.0 Gb reached, see mem.maxVSize()
  Backtrace:
      ▆
   1. ├─... %>% collect() at test-verb-pivot-longer.R:113:3
   2. ├─dplyr::collect(.)
   3. ├─tidyr::pivot_longer(...)
   4. └─dbplyr:::pivot_longer.tbl_lazy(...)
   5.   └─tidyr::build_longer_spec(...)
   6.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   7.       └─tidyr:::str_split_fixed(...)
   8.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  ── Error ('test-verb-pivot-longer.R:169:3'): original col order is preserved ───
  Error: vector memory limit of 16.0 Gb reached, see mem.maxVSize()
  Backtrace:
       ▆
    1. ├─testthat::expect_equal(...) at test-verb-pivot-longer.R:169:3
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─... %>% colnames()
    5. ├─base::colnames(.)
    6. │ └─base::is.data.frame(x)
    7. ├─tidyr::pivot_longer(., -id, names_to = c(".value", "n"), names_sep = "_")
    8. └─dbplyr:::pivot_longer.tbl_lazy(...)
    9.   └─tidyr::build_longer_spec(...)
   10.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   11.       └─tidyr:::str_split_fixed(...)
   12.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  ── Error ('test-verb-pivot-longer.R:186:3'): .value can be at any position in `names_to` ──
  Error: vector memory limit of 16.0 Gb reached, see mem.maxVSize()
  Backtrace:
      ▆
   1. ├─tidyr::pivot_longer(...) at test-verb-pivot-longer.R:186:3
   2. └─dbplyr:::pivot_longer.tbl_lazy(...)
   3.   └─tidyr::build_longer_spec(...)
   4.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   5.       └─tidyr:::str_split_fixed(...)
   6.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  
  [ FAIL 5 | WARN 0 | SKIP 358 | PASS 1578 ]
  Error: Test failures
  Execution halted
* checking for unstated dependencies in vignettes ... OK
* checking package vignettes ... OK
* checking re-building of vignette outputs ... [37s/55s] OK
* checking PDF version of manual ... [8s/10s] OK
* DONE
Status: 1 ERROR
* using check arguments '--no-clean-on-error '

* elapsed time (check, wall clock): 4:59