R Under development (unstable) (2026-03-04 r89536 ucrt) -- "Unsuffered Consequences"
Copyright (C) 2026 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library(testthat)
> 
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm
! In a coming version, dm will no longer reexport dplyr functions. For best
  results, run `library("dplyr")` before `library("dm")`.
ℹ To suppress this message unconditionally, set
  `options(dm.suppress_dplyr_startup_message = TRUE)`.

Attaching package: 'dm'

The following object is masked from 'package:stats':

    filter

Testing on df
Deferring my_test_src_fun
Deferring my_test_src_cache
Deferring duckdb_test_src
Deferring data_card_1
Deferring data_card_1_duckdb
Deferring data_card_2
Deferring data_card_3
Deferring data_card_4
Deferring data_card_5
Deferring data_card_6
Deferring data_card_7
Deferring data_card_8
Deferring data_card_9
Deferring data_card_10
Deferring data_card_11
Deferring data_card_12
Deferring data_card_13
Deferring dm_for_card
Deferring data_mcard
Deferring data_mcard_1
Deferring data_mcard_2
Deferring data_mcard_3
Deferring data_ts
Deferring data_ts_child
Deferring data_ts_parent
Deferring list_of_data_ts_parent_and_child
Deferring tf_1
Deferring tf_2_simple
Deferring tf_2
Deferring tf_3_simple
Deferring tf_3
Deferring tf_4
Deferring tf_5
Deferring tf_6
Deferring tf_7
Deferring dm_for_filter_w_cycle
Deferring dm_for_filter
Deferring dm_for_filter_db
Deferring dm_for_filter_df
Deferring dm_for_filter_duckdb
Deferring dm_for_filter_rev
Deferring dm_for_filter_simple
Deferring dm_for_filter_simple_db
Deferring dm_test_obj
Deferring dm_test_obj_2
Deferring dm_more_complex_part
Deferring dm_more_complex
Deferring iris_1
Deferring iris_2
Deferring iris_3
Deferring iris_1_dis
Deferring iris_2_dis
Deferring iris_3_dis
Deferring dm_for_disambiguate
Deferring fact
Deferring fact_clean
Deferring fact_clean_new
Deferring dim_1
Deferring dim_1_clean
Deferring dim_1_clean_new
Deferring dim_2
Deferring dim_2_clean
Deferring dim_2_clean_new
Deferring dim_3
Deferring dim_3_clean
Deferring dim_3_clean_new
Deferring dim_4
Deferring dim_4_clean
Deferring dim_4_clean_new
Deferring entangled_dm
Deferring entangled_dm_2
Deferring dm_for_flatten
Deferring result_from_flatten
Deferring result_from_flatten_new
Deferring tbl_1
Deferring tbl_2
Deferring tbl_3
Deferring bad_dm_base
Deferring bad_dm
Deferring dm_nycflights_small_base
Deferring dm_nycflights_small
Deferring dm_nycflights_small_cycle
Deferring nyc_comp
Deferring dm_for_autoinc_1
`on_delete = "cascade"` not supported for duckdb
Note: method with signature 'DBIConnection#Id' chosen for function 'dbExistsTable',
 target signature 'duckdb_connection#Id'.
 "duckdb_connection#ANY" would also be valid
Keys queried successfully.
i Use `learn_keys = TRUE` to enforce querying keys and to mute this message.
`on_delete = "cascade"` not supported for duckdb
The duckplyr package is configured to fall back to dplyr when it encounters an incompatibility. Fallback events can be collected and uploaded for analysis to guide future development. By default, data will be collected but no data will be uploaded.
i Automatic fallback uploading is not controlled and therefore disabled, see `?duckplyr::fallback()`.
v Number of reports ready for upload: 1.
> Review with `duckplyr::fallback_review()`, upload with `duckplyr::fallback_upload()`.
i Configure automatic uploading with `duckplyr::fallback_config()`.
[ FAIL 0 | WARN 5 | SKIP 388 | PASS 1664 ]

══ Skipped tests (388) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:216:3'
• Dependent on database version, find better way to record this info (1):
  'test-meta.R:19:3'
• FIXME (1): 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:519:3'
• Need to think about it (1): 'test-key-helpers.R:68:3'
• On CRAN (338): '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-zzx-deprecated.R:384:1',
  'test-flatten.R:1:1', 'test-flatten.R:97:1', 'test-dplyr.R:283:1',
  'test-dplyr.R:533:1', 'test-dplyr.R:569:1', 'test-dplyr.R:584:1',
  'test-dplyr.R:595:1', 'test-dplyr.R:623:1', 'test-dplyr.R:640:1',
  'test-dplyr.R:830:1', 'test-dplyr.R:1018:3', 'test-dplyr.R:1195:1',
  'test-filter-dm.R:44:1', 'test-filter-dm.R:59:1', 'test-filter-dm.R:164:1',
  'test-filter-dm.R:178:1', 'test-filter-dm.R:187:1', 'test-filter-dm.R:237:1',
  'test-draw-dm.R:16:1', 'test-draw-dm.R:106:1', 'test-draw-dm.R:116:1',
  'test-draw-dm.R:154:1', 'test-draw-dm.R:188:1', 'test-draw-dm.R:206:1',
  'test-draw-dm.R:222:1', 'test-draw-dm.R:234:1', 'test-bind.R:39:1',
  'test-bind.R:92:1', 'test-bind.R:104:1', 'test-bind.R:123:1',
  'test-rows-dm.R:1:1', 'test-rows-dm.R:7:1', 'test-rows-dm.R:90:1',
  'test-rows-dm.R:149:1', 'test-rows-dm.R:200:1', 'test-rows-dm.R:328:1',
  'test-learn.R:173:1', 'test-learn.R:202:1', 'test-learn.R:538:3',
  'test-add-tbl.R:88:1', 'test-add-tbl.R:136:1', 'test-autoincrement.R:16:1',
  'test-autoincrement.R:20:1', 'test-build_copy_queries.R:1:1',
  'test-build_copy_queries.R:28:1', 'test-build_copy_queries.R:48:1',
  'test-check-cardinalities.R:47:1', 'test-check-cardinalities.R:438:1',
  'test-check-cardinalities.R:449:1', 'test-check-cardinalities.R:564:1',
  'test-code-generation.R:1:1', 'test-datamodelr-code.R:1:1',
  'test-datamodelr-code.R:10:1', 'test-datamodelr-code.R:20:1',
  'test-datamodelr-code.R:40:1', 'test-datamodelr-code.R:60:1',
  'test-datamodelr-code.R:81:1', 'test-datamodelr-code.R:102:1',
  'test-datamodelr-code.R:124:1', 'test-db-interface.R:22:1',
  'test-db-interface.R:31:1', 'test-deconstruct.R:5:1',
  'test-deconstruct.R:15:1', 'test-deconstruct.R:25:1',
  'test-deconstruct.R:52:1', 'test-deconstruct.R:63:1',
  'test-deconstruct.R:99:1', 'test-deconstruct.R:125:1',
  'test-deconstruct.R:149:1', 'test-deconstruct.R:169:1',
  'test-deconstruct.R:186:1', 'test-deconstruct.R:230:1',
  'test-deconstruct.R:253:1', 'test-deconstruct.R:277:1',
  'test-deconstruct.R:301:1', 'test-deconstruct.R:325:1',
  'test-deconstruct.R:349:1', 'test-deconstruct.R:375:1',
  'test-deconstruct.R:401:1', 'test-deconstruct.R:427:1',
  'test-deconstruct.R:453:1', 'test-deconstruct.R:505:1',
  'test-deconstruct.R:533:1', 'test-deconstruct.R:543:1',
  'test-deconstruct.R:565:1', 'test-deconstruct.R:611:1',
  'test-deconstruct.R:624:1', 'test-deconstruct.R:638:1',
  'test-disambiguate.R:1:1', 'test-disentangle.R:1:1',
  'test-dm-flatten.R:43:1', 'test-dm-flatten.R:55:1', 'test-dm-flatten.R:62:1',
  'test-dm-flatten.R:198:1', 'test-dm-flatten.R:220:1',
  'test-dm-flatten.R:227:1', 'test-dm-flatten.R:488:1', 'test-dm.R:1:1',
  'test-dm.R:17:1', 'test-dm.R:108:1', 'test-dm.R:149:1', 'test-dm.R:193:1',
  'test-dm.R:203:1', 'test-dm.R:219:1', 'test-dm.R:225:1', 'test-dm.R:231:1',
  'test-dm.R:247:1', 'test-dm.R:326:1', 'test-dm.R:377:1', 'test-dm.R:531:1',
  'test-dm.R:550:1', 'test-dm.R:585:1', 'test-dm.R:619:1',
  'test-dm_deconstruct.R:1:1', 'test-dm_deconstruct.R:8:1',
  'test-dm_nest_tbl.R:1:1', 'test-dm_nest_tbl.R:22:1',
  'test-dm_nest_tbl.R:50:1', 'test-dm_pixarfilms.R:1:1', 'test-dm_sql.R:1:1',
  'test-dm_wrap.R:1:1', 'test-dm_wrap.R:112:1', 'test-dm_wrap.R:123:1',
  'test-duckdb.R:1:1', 'test-duckplyr.R:6:1', 'test-enum-ops.R:10:1',
  'test-enum-ops.R:29:1', 'test-enum-ops.R:102:1', 'test-enum-ops.R:175:1',
  'test-enumerate_all_paths.R:1:1', 'test-error-helpers.R:1:1',
  'test-error-helpers.R:65:1', 'test-error-ownership.R:5:1',
  'test-error-ownership.R:14:1', 'test-error-ownership.R:23:1',
  'test-error-ownership.R:32:1', 'test-error-ownership.R:41:1',
  'test-error-ownership.R:52:1', 'test-error-ownership.R:61:1',
  'test-error-ownership.R:70:1', 'test-error-ownership.R:79:1',
  'test-error-ownership.R:88:1', 'test-error-ownership.R:97:1',
  'test-error-ownership.R:106:1', 'test-error-ownership.R:116:1',
  'test-error-ownership.R:126:1', 'test-error-ownership.R:135:1',
  'test-error-ownership.R:144:1', 'test-error-ownership.R:153:1',
  'test-error-ownership.R:162:1', 'test-error-ownership.R:171:1',
  'test-error-ownership.R:180:1', 'test-error-ownership.R:188:1',
  'test-error-ownership.R:197:1', 'test-error-ownership.R:206:1',
  'test-error-ownership.R:215:1', 'test-error-ownership.R:226:1',
  'test-error-ownership.R:237:1', 'test-error-ownership.R:246:1',
  'test-error-ownership.R:255:1', 'test-error-ownership.R:264:1',
  'test-error-ownership.R:274:1', 'test-error-ownership.R:283:1',
  'test-error-ownership.R:292:1', 'test-error-ownership.R:301:1',
  'test-error-ownership.R:310:1', 'test-error-ownership.R:319:1',
  'test-error-ownership.R:328:1', 'test-error-ownership.R:339:1',
  'test-error-ownership.R:352:1', 'test-error-ownership.R:360:1',
  'test-error-ownership.R:369:1', 'test-error-ownership.R:378:1',
  'test-error-ownership.R:387:1', 'test-error-ownership.R:396:1',
  'test-error-ownership.R:405:1', 'test-error-ownership.R:414:1',
  'test-error-ownership.R:425:1', 'test-error-ownership.R:436:1',
  'test-error-ownership.R:445:1', 'test-error-ownership.R:456:1',
  'test-error-ownership.R:465:1', 'test-error-ownership.R:474:1',
  'test-error-ownership.R:485:1', 'test-error-ownership.R:497:1',
  'test-error-ownership.R:506:1', 'test-error-ownership.R:517:1',
  'test-error-ownership.R:526:1', 'test-error-ownership.R:535:1',
  'test-error-ownership.R:544:1', 'test-error-ownership.R:553:1',
  'test-error-ownership.R:562:1', 'test-error-ownership.R:571:1',
  'test-error-ownership.R:582:1', 'test-error-ownership.R:591:1',
  'test-error-ownership.R:607:1', 'test-error-ownership.R:616:1',
  'test-error-ownership.R:625:1', 'test-error-ownership.R:635:1',
  'test-error-ownership.R:645:1', 'test-examine-cardinalities.R:1:1',
  'test-examine-cardinalities.R:13:1', 'test-examine-cardinalities.R:22:1',
  'test-examine-constraints.R:73:1', 'test-examine-constraints.R:85:1',
  'test-examine-constraints.R:93:1', 'test-examine-constraints.R:102:1',
  'test-foreign-keys.R:1:1', 'test-foreign-keys.R:144:1',
  'test-foreign-keys.R:266:1', 'test-foreign-keys.R:274:1',
  'test-foreign-keys.R:301:1', 'test-format.R:1:1', 'test-graph.R:1:1',
  'test-graph.R:34:1', 'test-igraph.R:32:1', 'test-igraph.R:50:1',
  'test-json.R:1:1', 'test-json_nest.R:1:1', 'test-json_nest.R:13:1',
  'test-json_nest.R:56:1', 'test-json_pack.R:1:1', 'test-json_pack.R:36:1',
  'test-key-helpers.R:1:1', 'test-key-helpers.R:378:1',
  'test-key-helpers.R:384:1', 'test-key-helpers.R:393:1',
  'test-key-helpers.R:399:1', 'test-maria.R:1:1', 'test-meta.R:1:1',
  'test-mssql.R:1:1', 'test-pack_join.R:1:1', 'test-pack_join.R:11:1',
  'test-paste.R:7:1', 'test-paste.R:89:1', 'test-paste.R:109:1',
  'test-postgres.R:1:1', 'test-primary-keys.R:1:1', 'test-primary-keys.R:93:1',
  'test-primary-keys.R:177:1', 'test-primary-keys.R:197:1',
  'test-primary-keys.R:225:1', 'test-primary-keys.R:245:1',
  'test-primary-keys.R:252:1', 'test-select-tbl.R:29:1', 'test-select.R:1:1',
  'test-select.R:9:1', 'test-select.R:17:1', 'test-select.R:46:1',
  'test-select.R:87:1', 'test-sqlite.R:1:1',
  'test-standalone-check_suggested.R:1:1',
  'test-standalone-check_suggested.R:15:1', 'test-tidyr.R:52:1',
  'test-tidyr.R:88:1', 'test-tidyr.R:123:3', 'test-unique-keys.R:1:1',
  'test-unique-keys.R:174:1', 'test-upgrade.R:1:1', 'test-upgrade.R:8:1',
  'test-upgrade.R:24:1', 'test-upgrade.R:35:1', 'test-upgrade.R:51:1',
  'test-upgrade.R:62:1', 'test-upgrade.R:84:1', 'test-upgrade.R:95:1',
  'test-upgrade.R:114:1', 'test-waldo.R:3:1', 'test-zoom.R:29:1',
  'test-zoom.R:129:1', 'test-zoom2.R:126:1', 'test-zoom2.R:174:1',
  'test-zoom2.R:191:1', 'test-zoom2.R:208:1', 'test-zoom2.R:225:1',
  'test-zoom2.R:242:1', 'test-zoom2.R:259:1', 'test-zoom2.R:277:1',
  'test-zoom2.R:295:1', 'test-zoom2.R:312:1', 'test-zoom2.R:329:1',
  'test-zoom2.R:346:1', 'test-zoom2.R:363:1', 'test-zoom2.R:380:1',
  'test-zoom2.R:397:1', 'test-zoom2.R:419:1', 'test-zoom2.R:441:1',
  'test-zoom2.R:463:1', 'test-zoom2.R:485:1', 'test-zoom2.R:507:1',
  'test-zoom2.R:529:1', 'test-zoom2.R:551:1', 'test-zoom2.R:575:1',
  'test-zoom2.R:592:1', 'test-zoom2.R:609:1', 'test-zoom2.R:626:1',
  'test-zoom2.R:643:1', 'test-zoom2.R:660:1', 'test-zoom2.R:677:1',
  'test-zoom2.R:694:1', 'test-zoom2.R:711:1', 'test-zoom2.R:728:1',
  'test-zoom2.R:745:1', 'test-zoom2.R:762:1', 'test-zoom2.R:779:1',
  'test-zoom2.R:796:1', 'test-zoom2.R:813:1', 'test-zoom2.R:830:1',
  'test-zoom2.R:847:1', 'test-zoom2.R:865:1', 'test-zoom2.R:883:1',
  'test-zoom2.R:900:1', 'test-zoom2.R:919:1', 'test-zoom2.R:936:1',
  'test-zoom2.R:958:1', 'test-zoom2.R:975:1'
• Slow test. To run, set CI=true (7): '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-examine-constraints.R:62:3',
  'test-foreign-keys.R:195: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:238:3'
• keyed = TRUE (1): 'test-deconstruct.R:90: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 `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:277:3', 'test-learn.R:358:3',
  'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
  'test-schema.R:128:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:73:3',
  'test-db-interface.R:86:3', 'test-db-interface.R:117:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
  'test-learn.R:75:3', 'test-learn.R:447:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:136:3',
  'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:98:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:21:3',
  'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:234:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
  'test-db-interface.R:175:3'
• only works on `sqlite` (3): 'test-schema.R:204:3', 'test-sqlite.R:9:3',
  'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
  'test-foreign-keys.R:319:3', 'test-primary-keys.R:215:3',
  'test-tidyselect.R:23:3'

[ FAIL 0 | WARN 5 | SKIP 388 | PASS 1664 ]
Warning message:
call dbDisconnect() when finished working with a connection 
> 
> proc.time()
   user  system elapsed 
 104.09    4.54  107.93