CRAN Package Check Results for Package dbplyr

Last updated on 2025-09-10 12:49:36 CEST.

Flavor Version Tinstall Tcheck Ttotal Status Flags
r-devel-linux-x86_64-debian-clang 2.5.0 25.38 299.89 325.27 NOTE
r-devel-linux-x86_64-debian-gcc 2.5.0 14.33 200.24 214.57 NOTE
r-devel-linux-x86_64-fedora-clang 2.5.0 489.76 OK
r-devel-linux-x86_64-fedora-gcc 2.5.0 478.93 OK
r-devel-windows-x86_64 2.5.0 24.00 215.00 239.00 NOTE
r-patched-linux-x86_64 2.5.0 24.06 289.45 313.51 NOTE
r-release-linux-x86_64 2.5.0 22.16 279.19 301.35 NOTE
r-release-macos-arm64 2.5.0 118.00 OK
r-release-macos-x86_64 2.5.0 245.00 OK
r-release-windows-x86_64 2.5.0 25.00 216.00 241.00 NOTE
r-oldrel-macos-arm64 2.5.0 130.00 OK
r-oldrel-macos-x86_64 2.5.1 260.00 ERROR
r-oldrel-windows-x86_64 2.5.0 34.00 293.00 327.00 OK

Check Details

Version: 2.5.0
Check: Rd cross-references
Result: NOTE Found the following Rd file(s) with Rd \link{} targets missing package anchors: arrange.tbl_lazy.Rd: arrange, show_query backend-hana.Rd: copy_to collapse.tbl_sql.Rd: collapse, compute, collect complete.tbl_lazy.Rd: show_query copy_inline.Rd: copy_to copy_to.src_sql.Rd: copy_to, show_query count.tbl_lazy.Rd: count, tally db-sql.Rd: copy_to dbplyr-slice.Rd: slice_min, slice_max, slice_sample distinct.tbl_lazy.Rd: distinct, show_query expand.tbl_lazy.Rd: show_query filter.tbl_lazy.Rd: show_query get_returned_rows.Rd: rows_insert, rows_append, rows_update, rows_upsert, rows_delete group_by.tbl_lazy.Rd: group_by head.tbl_lazy.Rd: show_query join.tbl_sql.Rd: join, show_query memdb_frame.Rd: !!, !!!, .data, .env mutate.tbl_lazy.Rd: mutate, transmute, show_query nycflights13.Rd: src_postgres pivot_wider.tbl_lazy.Rd: expand pull.tbl_sql.Rd: pull replace_na.tbl_lazy.Rd: show_query rows-db.Rd: rows_insert, rows_append, rows_update, rows_patch, rows_upsert, rows_delete, tbl, compute select.tbl_lazy.Rd: select, rename, relocate summarise.tbl_lazy.Rd: summarise, show_query tbl.src_dbi.Rd: compute, collect, show_query, explain, do win_over.Rd: group_by, arrange Please provide package anchors for all Rd \link{} targets not in the package itself and the base packages. Flavors: r-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-windows-x86_64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-windows-x86_64

Version: 2.5.1
Check: tests
Result: ERROR Running ‘testthat.R’ [99s/92s] 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 374 | PASS 1553 ] ══ Skipped tests (374) ═════════════════════════════════════════════════════════ • 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:411:3', 'test-backend-mssql.R:443:3', 'test-backend-mssql.R:462:3', 'test-backend-mssql.R:478:3', 'test-backend-mssql.R:504:3', 'test-backend-mssql.R:531:3', 'test-backend-mssql.R:555:3', 'test-backend-mssql.R:580:3', 'test-backend-mssql.R:606:3', 'test-backend-mssql.R:633:3', 'test-backend-mssql.R:658:3', 'test-backend-mssql.R:685:3', 'test-backend-mssql.R:710:3' • No postgres (9): 'test-backend-postgres.R:216:3', 'test-backend-postgres.R:224:3', 'test-backend-postgres.R:231:3', 'test-backend-postgres.R:245:3', 'test-backend-postgres.R:305:3', 'test-backend-postgres.R:320:3', 'test-backend-postgres.R:375:3', 'test-backend-postgres.R:434:3', 'test-verb-joins.R:103:3' • On CRAN (336): 'test-backend-access.R:37:3', 'test-backend-access.R:78: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:18: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-oracle.R:101:3', 'test-backend-postgres.R:55:3', 'test-backend-postgres.R:79:3', 'test-backend-postgres.R:109:3', 'test-backend-postgres.R:124:3', 'test-backend-postgres.R:137:3', 'test-backend-postgres.R:149:3', 'test-backend-postgres.R:165:3', 'test-backend-postgres.R:199:3', 'test-backend-redshift.R:51:3', 'test-backend-redshift.R:76:3', 'test-backend-redshift.R:91:3', 'test-backend-mssql.R:76:3', 'test-backend-mssql.R:117:3', 'test-backend-mssql.R:137:3', 'test-backend-mssql.R:159:3', 'test-backend-mssql.R:174:3', 'test-backend-mssql.R:207:3', 'test-backend-mssql.R:222:3', 'test-backend-mssql.R:228:3', 'test-backend-mssql.R:240:3', 'test-backend-mssql.R:250:3', 'test-backend-mssql.R:262:3', 'test-backend-mssql.R:285:3', 'test-backend-mssql.R:307:3', 'test-backend-mssql.R:327:3', 'test-backend-mssql.R:350:3', 'test-backend-mssql.R:370:3', 'test-backend-mssql.R:386:3', 'test-backend-mssql.R:398:3', 'test-backend-mssql.R:405:3', 'test-backend-mssql.R:430:3', 'test-backend-spark-sql.R:16:3', 'test-backend-spark-sql.R:31:3', 'test-backend-snowflake.R:17:3', 'test-backend-snowflake.R:180:3', 'test-backend-snowflake.R:190:3', 'test-backend-sqlite.R:54:3', 'test-backend-sqlite.R:60:3', 'test-backend-sqlite.R:108:3', 'test-backend-teradata.R:56:3', 'test-backend-teradata.R:63:3', 'test-backend-teradata.R:69:3', 'test-backend-teradata.R:79:3', 'test-backend-teradata.R:86:3', 'test-backend-teradata.R:93: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-escape.R:112:3', 'test-escape.R:123:3', 'test-lazy-select-query.R:4: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-set-op.R:5:3', 'test-query-set-op.R:10:3', 'test-query-select.R:7:3', 'test-query-select.R:16:3', 'test-query-select.R:20: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:14:3', 'test-translate-sql-helpers.R:30:3', 'test-translate-sql-helpers.R:47:3', 'test-translate-sql-helpers.R:51:3', 'test-translate-sql-helpers.R:88:3', 'test-translate-sql-helpers.R:114: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-uncount.R:5: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:119:3', 'test-verb-summarise.R:126:3', 'test-verb-summarise.R:135:3', 'test-verb-summarise.R:146: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 374 | PASS 1553 ] Error: Test failures Execution halted Flavor: r-oldrel-macos-x86_64