Last updated on 2024-11-20 10:13:08 CET.
| Flavor | Version | Tinstall | Tcheck | Ttotal | Status | Flags |
|---|---|---|---|---|---|---|
| r-devel-linux-x86_64-debian-clang | 1.0.10 | 17.96 | 343.73 | 361.69 | ERROR | |
| r-devel-linux-x86_64-debian-gcc | 1.0.10 | 9.13 | 226.79 | 235.92 | ERROR | |
| r-devel-linux-x86_64-fedora-clang | 1.0.10 | 610.45 | ERROR | |||
| r-devel-linux-x86_64-fedora-gcc | 1.0.10 | 417.41 | ERROR | |||
| r-devel-windows-x86_64 | 1.0.10 | 20.00 | 263.00 | 283.00 | ERROR | |
| r-patched-linux-x86_64 | 1.0.10 | 24.03 | 317.39 | 341.42 | ERROR | |
| r-release-linux-x86_64 | 1.0.10 | 15.80 | 326.83 | 342.63 | ERROR | |
| r-release-macos-arm64 | 1.0.10 | 141.00 | OK | |||
| r-release-macos-x86_64 | 1.0.10 | 240.00 | OK | |||
| r-release-windows-x86_64 | 1.0.10 | 19.00 | 259.00 | 278.00 | ERROR | |
| r-oldrel-macos-arm64 | 1.0.10 | 149.00 | OK | |||
| r-oldrel-macos-x86_64 | 1.0.10 | 307.00 | OK | |||
| r-oldrel-windows-x86_64 | 1.0.10 | 23.00 | 342.00 | 365.00 | ERROR |
Version: 1.0.10
Check: Rd cross-references
Result: NOTE
Found the following Rd file(s) with Rd \link{} targets missing package
anchors:
dm_examine_cardinalities.Rd: as_tibble
dm_examine_constraints.Rd: as_tibble
dm_from_con.Rd: src
dm_zoom_to.Rd: nest_join
json_nest.Rd: tidyr_tidy_select
json_pack.Rd: tidyr_tidy_select
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
Version: 1.0.10
Check: tests
Result: ERROR
Running ‘testthat.R’ [160s/86s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-deconstruct.R:6:3',
'test-deconstruct.R:16:3', 'test-deconstruct.R:26:3',
'test-deconstruct.R:55:3', 'test-deconstruct.R:72:3',
'test-deconstruct.R:120:3', 'test-deconstruct.R:144:3',
'test-deconstruct.R:160:3', 'test-deconstruct.R:181:3',
'test-deconstruct.R:198:3', 'test-deconstruct.R:222:3',
'test-deconstruct.R:246:3', 'test-deconstruct.R:270:3',
'test-deconstruct.R:294:3', 'test-deconstruct.R:320:3',
'test-deconstruct.R:346:3', 'test-deconstruct.R:372:3',
'test-deconstruct.R:398:3', 'test-deconstruct.R:420:3',
'test-deconstruct.R:479:3', 'test-deconstruct.R:492:3',
'test-deconstruct.R:507:3', 'test-deconstruct.R:525:3',
'test-deconstruct.R:572:3', 'test-deconstruct.R:586:3',
'test-deconstruct.R:599:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-duckdb.R:2:3', 'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3',
'test-enum-ops.R:103:3', 'test-enum-ops.R:176:3',
'test-enumerate_all_paths.R:2:3', 'test-error-helpers.R:2:3',
'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-key-helpers.R:4:3',
'test-key-helpers.R:327:3', 'test-key-helpers.R:333:3',
'test-key-helpers.R:342:3', 'test-key-helpers.R:350:3',
'test-postgres.R:2:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-select-tbl.R:30:3', 'test-select.R:2:3', 'test-select.R:10:3',
'test-select.R:18:3', 'test-select.R:47:3', 'test-select.R:88:3',
'test-sqlite.R:2:3', 'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-tidyr.R:54:3', 'test-tidyr.R:92:3', 'test-unique-keys.R:2:3',
'test-unique-keys.R:175:3', 'test-upgrade.R:3:3', 'test-upgrade.R:15:3',
'test-upgrade.R:26:3', 'test-upgrade.R:42:3', 'test-upgrade.R:53:3',
'test-upgrade.R:72:3', 'test-upgrade.R:86:3', 'test-upgrade.R:102:3',
'test-upgrade.R:116:3', 'test-waldo.R:8:3', 'test-zoom.R:30:3',
'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('dbplyr_4SvmaXQE3b', 'dbplyr_9Z6ApgIqQo', 'dbplyr_EW6WRFpF64', 'dbplyr_NBm6zoRrMa', 'dbplyr_qpkCJMTQ86', ...)
`expected` is an S4 object of class <character> ('dbplyr_4SvmaXQE3b', 'dbplyr_9Z6ApgIqQo', 'dbplyr_EW6WRFpF64', 'dbplyr_NBm6zoRrMa', 'dbplyr_qpkCJMTQ86', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-devel-linux-x86_64-debian-clang
Version: 1.0.10
Check: tests
Result: ERROR
Running ‘testthat.R’ [104s/61s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-dm_pixarfilms.R:2:3',
'test-deconstruct.R:6:3', 'test-deconstruct.R:16:3',
'test-deconstruct.R:26:3', 'test-deconstruct.R:55:3',
'test-deconstruct.R:72:3', 'test-deconstruct.R:120:3',
'test-deconstruct.R:144:3', 'test-deconstruct.R:160:3',
'test-deconstruct.R:181:3', 'test-deconstruct.R:198:3',
'test-deconstruct.R:222:3', 'test-deconstruct.R:246:3',
'test-deconstruct.R:270:3', 'test-deconstruct.R:294:3',
'test-deconstruct.R:320:3', 'test-deconstruct.R:346:3',
'test-deconstruct.R:372:3', 'test-deconstruct.R:398:3',
'test-deconstruct.R:420:3', 'test-deconstruct.R:479:3',
'test-deconstruct.R:492:3', 'test-deconstruct.R:507:3',
'test-deconstruct.R:525:3', 'test-deconstruct.R:572:3',
'test-deconstruct.R:586:3', 'test-deconstruct.R:599:3', 'test-dm_sql.R:4:3',
'test-duckdb.R:2:3', 'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3',
'test-enum-ops.R:103:3', 'test-enum-ops.R:176:3',
'test-enumerate_all_paths.R:2:3', 'test-error-helpers.R:2:3',
'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
'test-key-helpers.R:350:3', 'test-postgres.R:2:3', 'test-select-tbl.R:30:3',
'test-select.R:2:3', 'test-select.R:10:3', 'test-select.R:18:3',
'test-select.R:47:3', 'test-select.R:88:3', 'test-sqlite.R:2:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-tidyr.R:54:3', 'test-tidyr.R:92:3', 'test-unique-keys.R:2:3',
'test-unique-keys.R:175:3', 'test-upgrade.R:3:3', 'test-upgrade.R:15:3',
'test-upgrade.R:26:3', 'test-upgrade.R:42:3', 'test-upgrade.R:53:3',
'test-upgrade.R:72:3', 'test-upgrade.R:86:3', 'test-upgrade.R:102:3',
'test-upgrade.R:116:3', 'test-waldo.R:8:3', 'test-zoom.R:30:3',
'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('test_table_123_9_20241119_150640774685_2677654', 'test_table_321_9_20241119_150640774685_2677654', 'tf_1_3_20241119_150602752337_2677654', 'tf_1_4_20241119_150603440289_2677654', 'tf_1_5_20241119_150604883693_2677654', ...)
`expected` is an S4 object of class <character> ('test_table_123_9_20241119_150640774685_2677654', 'test_table_321_9_20241119_150640774685_2677654', 'tf_1_3_20241119_150602752337_2677654', 'tf_1_4_20241119_150603440289_2677654', 'tf_1_5_20241119_150604883693_2677654', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-devel-linux-x86_64-debian-gcc
Version: 1.0.10
Check: tests
Result: ERROR
Running ‘testthat.R’ [267s/144s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-deconstruct.R:6:3',
'test-deconstruct.R:16:3', 'test-deconstruct.R:26:3',
'test-deconstruct.R:55:3', 'test-deconstruct.R:72:3',
'test-deconstruct.R:120:3', 'test-deconstruct.R:144:3',
'test-deconstruct.R:160:3', 'test-deconstruct.R:181:3',
'test-deconstruct.R:198:3', 'test-deconstruct.R:222:3',
'test-deconstruct.R:246:3', 'test-deconstruct.R:270:3',
'test-deconstruct.R:294:3', 'test-deconstruct.R:320:3',
'test-deconstruct.R:346:3', 'test-deconstruct.R:372:3',
'test-deconstruct.R:398:3', 'test-deconstruct.R:420:3',
'test-deconstruct.R:479:3', 'test-deconstruct.R:492:3',
'test-deconstruct.R:507:3', 'test-deconstruct.R:525:3',
'test-deconstruct.R:572:3', 'test-deconstruct.R:586:3',
'test-deconstruct.R:599:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_pixarfilms.R:2:3', 'test-dm_nest_tbl.R:17:3', 'test-dm_sql.R:4:3',
'test-duckdb.R:2:3', 'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3',
'test-enum-ops.R:103:3', 'test-enum-ops.R:176:3',
'test-enumerate_all_paths.R:2:3', 'test-error-helpers.R:2:3',
'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-key-helpers.R:4:3',
'test-key-helpers.R:327:3', 'test-key-helpers.R:333:3',
'test-key-helpers.R:342:3', 'test-key-helpers.R:350:3', 'test-paste.R:10:3',
'test-paste.R:93:3', 'test-postgres.R:2:3', 'test-select-tbl.R:30:3',
'test-select.R:2:3', 'test-select.R:10:3', 'test-select.R:18:3',
'test-select.R:47:3', 'test-select.R:88:3', 'test-sqlite.R:2:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-tidyr.R:54:3', 'test-tidyr.R:92:3', 'test-unique-keys.R:2:3',
'test-unique-keys.R:175:3', 'test-upgrade.R:3:3', 'test-upgrade.R:15:3',
'test-upgrade.R:26:3', 'test-upgrade.R:42:3', 'test-upgrade.R:53:3',
'test-upgrade.R:72:3', 'test-upgrade.R:86:3', 'test-upgrade.R:102:3',
'test-upgrade.R:116:3', 'test-waldo.R:8:3', 'test-zoom.R:30:3',
'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('dbplyr_86MnI4zYIy', 'dbplyr_AN6J6gonP5', 'dbplyr_M4JyrF5IbE', 'dbplyr_blzpIQLDxu', 'dbplyr_jsTwfWC0vx', ...)
`expected` is an S4 object of class <character> ('dbplyr_86MnI4zYIy', 'dbplyr_AN6J6gonP5', 'dbplyr_M4JyrF5IbE', 'dbplyr_blzpIQLDxu', 'dbplyr_jsTwfWC0vx', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-devel-linux-x86_64-fedora-clang
Version: 1.0.10
Check: tests
Result: ERROR
Running ‘testthat.R’ [169s/84s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-deconstruct.R:6:3', 'test-deconstruct.R:16:3',
'test-deconstruct.R:26:3', 'test-deconstruct.R:55:3',
'test-deconstruct.R:72:3', 'test-deconstruct.R:120:3',
'test-deconstruct.R:144:3', 'test-deconstruct.R:160:3',
'test-deconstruct.R:181:3', 'test-deconstruct.R:198:3',
'test-deconstruct.R:222:3', 'test-deconstruct.R:246:3',
'test-deconstruct.R:270:3', 'test-deconstruct.R:294:3',
'test-deconstruct.R:320:3', 'test-deconstruct.R:346:3',
'test-deconstruct.R:372:3', 'test-deconstruct.R:398:3',
'test-deconstruct.R:420:3', 'test-deconstruct.R:479:3',
'test-deconstruct.R:492:3', 'test-deconstruct.R:507:3',
'test-deconstruct.R:525:3', 'test-deconstruct.R:572:3',
'test-deconstruct.R:586:3', 'test-deconstruct.R:599:3', 'test-duckdb.R:2:3',
'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3', 'test-enum-ops.R:103:3',
'test-enum-ops.R:176:3', 'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3',
'test-enumerate_all_paths.R:2:3', 'test-examine-cardinalities.R:2:3',
'test-examine-cardinalities.R:16:3', 'test-examine-cardinalities.R:23:3',
'test-error-helpers.R:2:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-postgres.R:2:3', 'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
'test-key-helpers.R:350:3', 'test-select-tbl.R:30:3',
'test-primary-keys.R:25:3', 'test-primary-keys.R:94:3',
'test-primary-keys.R:178:3', 'test-primary-keys.R:198:3',
'test-primary-keys.R:229:3', 'test-primary-keys.R:246:3',
'test-primary-keys.R:253:3', 'test-sqlite.R:2:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-select.R:2:3',
'test-select.R:10:3', 'test-select.R:18:3', 'test-select.R:47:3',
'test-select.R:88:3', 'test-tidyr.R:54:3', 'test-tidyr.R:92:3',
'test-unique-keys.R:2:3', 'test-unique-keys.R:175:3', 'test-upgrade.R:3:3',
'test-upgrade.R:15:3', 'test-upgrade.R:26:3', 'test-upgrade.R:42:3',
'test-upgrade.R:53:3', 'test-upgrade.R:72:3', 'test-upgrade.R:86:3',
'test-upgrade.R:102:3', 'test-upgrade.R:116:3', 'test-waldo.R:8:3',
'test-zoom.R:30:3', 'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('test_table_123_8_20241118_081259881284_3686945', 'test_table_321_8_20241118_081259881284_3686945', 'tf_1_3_20241118_081204190905_3686945', 'tf_1_4_20241118_081204638843_3686945', 'tf_1_5_20241118_08120622889_3686945', ...)
`expected` is an S4 object of class <character> ('test_table_123_8_20241118_081259881284_3686945', 'test_table_321_8_20241118_081259881284_3686945', 'tf_1_3_20241118_081204190905_3686945', 'tf_1_4_20241118_081204638843_3686945', 'tf_1_5_20241118_08120622889_3686945', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-devel-linux-x86_64-fedora-gcc
Version: 1.0.10
Check: tests
Result: ERROR
Running 'testthat.R' [67s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-deconstruct.R:6:3', 'test-deconstruct.R:16:3',
'test-deconstruct.R:26:3', 'test-deconstruct.R:55:3',
'test-deconstruct.R:72:3', 'test-deconstruct.R:120:3',
'test-deconstruct.R:144:3', 'test-deconstruct.R:160:3',
'test-deconstruct.R:181:3', 'test-deconstruct.R:198:3',
'test-deconstruct.R:222:3', 'test-deconstruct.R:246:3',
'test-deconstruct.R:270:3', 'test-deconstruct.R:294:3',
'test-deconstruct.R:320:3', 'test-deconstruct.R:346:3',
'test-deconstruct.R:372:3', 'test-deconstruct.R:398:3',
'test-deconstruct.R:420:3', 'test-deconstruct.R:479:3',
'test-deconstruct.R:492:3', 'test-deconstruct.R:507:3',
'test-deconstruct.R:525:3', 'test-deconstruct.R:572:3',
'test-deconstruct.R:586:3', 'test-deconstruct.R:599:3',
'test-dm_nest_tbl.R:17:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-duckdb.R:2:3', 'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3',
'test-enum-ops.R:103:3', 'test-enum-ops.R:176:3',
'test-enumerate_all_paths.R:2:3', 'test-dm_wrap.R:12:3',
'test-dm_wrap.R:79:3', 'test-error-helpers.R:2:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
'test-key-helpers.R:350:3', 'test-postgres.R:2:3', 'test-select-tbl.R:30:3',
'test-select.R:2:3', 'test-select.R:10:3', 'test-select.R:18:3',
'test-select.R:47:3', 'test-select.R:88:3', 'test-sqlite.R:2:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-tidyr.R:54:3', 'test-tidyr.R:92:3', 'test-unique-keys.R:2:3',
'test-unique-keys.R:175:3', 'test-upgrade.R:3:3', 'test-upgrade.R:15:3',
'test-upgrade.R:26:3', 'test-upgrade.R:42:3', 'test-upgrade.R:53:3',
'test-upgrade.R:72:3', 'test-upgrade.R:86:3', 'test-upgrade.R:102:3',
'test-upgrade.R:116:3', 'test-waldo.R:8:3', 'test-zoom.R:30:3',
'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('dbplyr_ETxqsPxtlC', 'dbplyr_MrotU1B4lo', 'dbplyr_l3JOI7I3HB', 'dbplyr_lJYbcAEOzZ', 'dbplyr_me7jnFXnWY', ...)
`expected` is an S4 object of class <character> ('dbplyr_ETxqsPxtlC', 'dbplyr_MrotU1B4lo', 'dbplyr_l3JOI7I3HB', 'dbplyr_lJYbcAEOzZ', 'dbplyr_me7jnFXnWY', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-devel-windows-x86_64
Version: 1.0.10
Check: tests
Result: ERROR
Running ‘testthat.R’ [146s/76s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-deconstruct.R:6:3', 'test-deconstruct.R:16:3',
'test-deconstruct.R:26:3', 'test-deconstruct.R:55:3',
'test-deconstruct.R:72:3', 'test-deconstruct.R:120:3',
'test-deconstruct.R:144:3', 'test-deconstruct.R:160:3',
'test-deconstruct.R:181:3', 'test-deconstruct.R:198:3',
'test-deconstruct.R:222:3', 'test-deconstruct.R:246:3',
'test-deconstruct.R:270:3', 'test-deconstruct.R:294:3',
'test-deconstruct.R:320:3', 'test-deconstruct.R:346:3',
'test-deconstruct.R:372:3', 'test-deconstruct.R:398:3',
'test-deconstruct.R:420:3', 'test-deconstruct.R:479:3',
'test-deconstruct.R:492:3', 'test-deconstruct.R:507:3',
'test-deconstruct.R:525:3', 'test-deconstruct.R:572:3',
'test-deconstruct.R:586:3', 'test-deconstruct.R:599:3', 'test-duckdb.R:2:3',
'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3', 'test-enum-ops.R:103:3',
'test-enum-ops.R:176:3', 'test-enumerate_all_paths.R:2:3',
'test-error-helpers.R:2:3', 'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
'test-key-helpers.R:350:3', 'test-postgres.R:2:3', 'test-select-tbl.R:30:3',
'test-select.R:2:3', 'test-select.R:10:3', 'test-select.R:18:3',
'test-select.R:47:3', 'test-select.R:88:3', 'test-sqlite.R:2:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-tidyr.R:54:3', 'test-tidyr.R:92:3', 'test-unique-keys.R:2:3',
'test-unique-keys.R:175:3', 'test-upgrade.R:3:3', 'test-upgrade.R:15:3',
'test-upgrade.R:26:3', 'test-upgrade.R:42:3', 'test-upgrade.R:53:3',
'test-upgrade.R:72:3', 'test-upgrade.R:86:3', 'test-upgrade.R:102:3',
'test-upgrade.R:116:3', 'test-waldo.R:8:3', 'test-zoom.R:30:3',
'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('test_table_123_9_20241119_221514461138_767044', 'test_table_321_9_20241119_221514461138_767044', 'tf_1_3_20241119_221429480261_767044', 'tf_1_4_20241119_22142994135_767044', 'tf_1_5_20241119_221431910562_767044', ...)
`expected` is an S4 object of class <character> ('test_table_123_9_20241119_221514461138_767044', 'test_table_321_9_20241119_221514461138_767044', 'tf_1_3_20241119_221429480261_767044', 'tf_1_4_20241119_22142994135_767044', 'tf_1_5_20241119_221431910562_767044', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-patched-linux-x86_64
Version: 1.0.10
Check: tests
Result: ERROR
Running ‘testthat.R’ [153s/82s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-deconstruct.R:6:3',
'test-deconstruct.R:16:3', 'test-deconstruct.R:26:3',
'test-deconstruct.R:55:3', 'test-deconstruct.R:72:3',
'test-deconstruct.R:120:3', 'test-deconstruct.R:144:3',
'test-deconstruct.R:160:3', 'test-deconstruct.R:181:3',
'test-deconstruct.R:198:3', 'test-deconstruct.R:222:3',
'test-deconstruct.R:246:3', 'test-deconstruct.R:270:3',
'test-deconstruct.R:294:3', 'test-deconstruct.R:320:3',
'test-deconstruct.R:346:3', 'test-deconstruct.R:372:3',
'test-deconstruct.R:398:3', 'test-deconstruct.R:420:3',
'test-deconstruct.R:479:3', 'test-deconstruct.R:492:3',
'test-deconstruct.R:507:3', 'test-deconstruct.R:525:3',
'test-deconstruct.R:572:3', 'test-deconstruct.R:586:3',
'test-deconstruct.R:599:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-duckdb.R:2:3', 'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3',
'test-enum-ops.R:103:3', 'test-enum-ops.R:176:3',
'test-enumerate_all_paths.R:2:3', 'test-error-helpers.R:2:3',
'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-postgres.R:2:3', 'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
'test-key-helpers.R:350:3', 'test-select-tbl.R:30:3', 'test-select.R:2:3',
'test-select.R:10:3', 'test-select.R:18:3', 'test-select.R:47:3',
'test-select.R:88:3', 'test-sqlite.R:2:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-tidyr.R:54:3',
'test-tidyr.R:92:3', 'test-unique-keys.R:2:3', 'test-unique-keys.R:175:3',
'test-upgrade.R:3:3', 'test-upgrade.R:15:3', 'test-upgrade.R:26:3',
'test-upgrade.R:42:3', 'test-upgrade.R:53:3', 'test-upgrade.R:72:3',
'test-upgrade.R:86:3', 'test-upgrade.R:102:3', 'test-upgrade.R:116:3',
'test-waldo.R:8:3', 'test-zoom.R:30:3', 'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('dbplyr_25F26REuJw', 'dbplyr_9sP7SOerpS', 'dbplyr_NQKq20QuDQ', 'dbplyr_Sz0IQyJ3mA', 'dbplyr_cw48DdjClh', ...)
`expected` is an S4 object of class <character> ('dbplyr_25F26REuJw', 'dbplyr_9sP7SOerpS', 'dbplyr_NQKq20QuDQ', 'dbplyr_Sz0IQyJ3mA', 'dbplyr_cw48DdjClh', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-release-linux-x86_64
Version: 1.0.10
Check: tests
Result: ERROR
Running 'testthat.R' [67s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-deconstruct.R:6:3',
'test-deconstruct.R:16:3', 'test-deconstruct.R:26:3',
'test-deconstruct.R:55:3', 'test-deconstruct.R:72:3',
'test-deconstruct.R:120:3', 'test-deconstruct.R:144:3',
'test-deconstruct.R:160:3', 'test-deconstruct.R:181:3',
'test-deconstruct.R:198:3', 'test-deconstruct.R:222:3',
'test-deconstruct.R:246:3', 'test-deconstruct.R:270:3',
'test-deconstruct.R:294:3', 'test-deconstruct.R:320:3',
'test-deconstruct.R:346:3', 'test-deconstruct.R:372:3',
'test-deconstruct.R:398:3', 'test-deconstruct.R:420:3',
'test-deconstruct.R:479:3', 'test-deconstruct.R:492:3',
'test-deconstruct.R:507:3', 'test-deconstruct.R:525:3',
'test-deconstruct.R:572:3', 'test-deconstruct.R:586:3',
'test-deconstruct.R:599:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-duckdb.R:2:3', 'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3',
'test-enum-ops.R:103:3', 'test-enum-ops.R:176:3',
'test-enumerate_all_paths.R:2:3', 'test-dm_wrap.R:12:3',
'test-dm_wrap.R:79:3', 'test-error-helpers.R:2:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-paste.R:10:3', 'test-paste.R:93:3',
'test-postgres.R:2:3', 'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
'test-key-helpers.R:350:3', 'test-select-tbl.R:30:3',
'test-primary-keys.R:25:3', 'test-primary-keys.R:94:3',
'test-primary-keys.R:178:3', 'test-primary-keys.R:198:3',
'test-primary-keys.R:229:3', 'test-primary-keys.R:246:3',
'test-primary-keys.R:253:3', 'test-select.R:2:3', 'test-select.R:10:3',
'test-select.R:18:3', 'test-select.R:47:3', 'test-select.R:88:3',
'test-sqlite.R:2:3', 'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-tidyr.R:54:3',
'test-tidyr.R:92:3', 'test-unique-keys.R:2:3', 'test-unique-keys.R:175:3',
'test-upgrade.R:3:3', 'test-upgrade.R:15:3', 'test-upgrade.R:26:3',
'test-upgrade.R:42:3', 'test-upgrade.R:53:3', 'test-upgrade.R:72:3',
'test-upgrade.R:86:3', 'test-upgrade.R:102:3', 'test-upgrade.R:116:3',
'test-waldo.R:8:3', 'test-zoom.R:30:3', 'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('test_table_123_9_20241119_071924308802_63708', 'test_table_321_9_20241119_071924308802_63708', 'tf_1_3_20241119_071843160722_63708', 'tf_1_4_20241119_071843527125_63708', 'tf_1_5_20241119_071845171743_63708', ...)
`expected` is an S4 object of class <character> ('test_table_123_9_20241119_071924308802_63708', 'test_table_321_9_20241119_071924308802_63708', 'tf_1_3_20241119_071843160722_63708', 'tf_1_4_20241119_071843527125_63708', 'tf_1_5_20241119_071845171743_63708', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-release-windows-x86_64
Version: 1.0.10
Check: tests
Result: ERROR
Running 'testthat.R' [100s]
Running the tests in 'tests/testthat.R' failed.
Complete output:
> library(testthat)
>
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
Attaching package: 'dm'
The following object is masked from 'package:stats':
filter
Starting 2 test processes
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
══ Skipped tests (242) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
'test-meta.R:19:3'
• FIXME (2): 'test-learn.R:154:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (191): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
'test-draw-dm.R:104:3', 'test-draw-dm.R:117:3', 'test-draw-dm.R:153:3',
'test-draw-dm.R:182:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
'test-bind.R:125:3', 'test-learn.R:444:3', 'test-add-tbl.R:92:3',
'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
'test-autoincrement.R:26:3', 'test-build_copy_queries.R:14:3',
'test-build_copy_queries.R:33:3', 'test-build_copy_queries.R:76:3',
'test-rows-dm.R:2:3', 'test-rows-dm.R:28:3', 'test-rows-dm.R:117:3',
'test-rows-dm.R:167:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
'test-dm_nest_tbl.R:17:3', 'test-dm_pixarfilms.R:2:3', 'test-dm_sql.R:4:3',
'test-deconstruct.R:6:3', 'test-deconstruct.R:16:3',
'test-deconstruct.R:26:3', 'test-deconstruct.R:55:3',
'test-deconstruct.R:72:3', 'test-deconstruct.R:120:3',
'test-deconstruct.R:144:3', 'test-deconstruct.R:160:3',
'test-deconstruct.R:181:3', 'test-deconstruct.R:198:3',
'test-deconstruct.R:222:3', 'test-deconstruct.R:246:3',
'test-deconstruct.R:270:3', 'test-deconstruct.R:294:3',
'test-deconstruct.R:320:3', 'test-deconstruct.R:346:3',
'test-deconstruct.R:372:3', 'test-deconstruct.R:398:3',
'test-deconstruct.R:420:3', 'test-deconstruct.R:479:3',
'test-deconstruct.R:492:3', 'test-deconstruct.R:507:3',
'test-deconstruct.R:525:3', 'test-deconstruct.R:572:3',
'test-deconstruct.R:586:3', 'test-deconstruct.R:599:3', 'test-duckdb.R:2:3',
'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3', 'test-enum-ops.R:103:3',
'test-enum-ops.R:176:3', 'test-enumerate_all_paths.R:2:3',
'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3', 'test-error-helpers.R:2:3',
'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
'test-pack_join.R:16:3', 'test-key-helpers.R:4:3',
'test-key-helpers.R:327:3', 'test-key-helpers.R:333:3',
'test-key-helpers.R:342:3', 'test-key-helpers.R:350:3', 'test-paste.R:10:3',
'test-paste.R:93:3', 'test-postgres.R:2:3', 'test-select-tbl.R:30:3',
'test-select.R:2:3', 'test-select.R:10:3', 'test-select.R:18:3',
'test-select.R:47:3', 'test-select.R:88:3', 'test-sqlite.R:2:3',
'test-standalone-check_suggested.R:3:3',
'test-standalone-check_suggested.R:17:3', 'test-primary-keys.R:25:3',
'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
'test-tidyr.R:54:3', 'test-tidyr.R:92:3', 'test-unique-keys.R:2:3',
'test-unique-keys.R:175:3', 'test-upgrade.R:3:3', 'test-upgrade.R:15:3',
'test-upgrade.R:26:3', 'test-upgrade.R:42:3', 'test-upgrade.R:53:3',
'test-upgrade.R:72:3', 'test-upgrade.R:86:3', 'test-upgrade.R:102:3',
'test-upgrade.R:116:3', 'test-waldo.R:8:3', 'test-zoom.R:30:3',
'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
'test-primary-keys.R:158:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:206:3', 'test-learn.R:282:3',
'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
'test-learn.R:69:3', 'test-learn.R:364:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
'test-tidyselect.R:23:3'
══ Failed tests ════════════════════════════════════════════════════════════════
── Failure ('test_dm_from_con.R:70:3'): table identifiers are quoted with learn_keys = FALSE ──
gsub("^.*\\.", "", unname(remote_names)) (`actual`) not equal to unclass(DBI::dbQuoteIdentifier(con, names(dm))) (`expected`).
`actual` is a character vector ('test_table_123_9_20241118_060944436858_92496', 'test_table_321_9_20241118_060944436858_92496', 'tf_1_3_20241118_06084176588_92496', 'tf_1_4_20241118_060842267814_92496', 'tf_1_5_20241118_060844562846_92496', ...)
`expected` is an S4 object of class <character> ('test_table_123_9_20241118_060944436858_92496', 'test_table_321_9_20241118_060944436858_92496', 'tf_1_3_20241118_06084176588_92496', 'tf_1_4_20241118_060842267814_92496', 'tf_1_5_20241118_060844562846_92496', ...)
[ FAIL 1 | WARN 0 | SKIP 242 | PASS 1355 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Flavor: r-oldrel-windows-x86_64