* using log directory 'd:/Rcompile/CRANpkg/local/4.3/dm.Rcheck'
* using R version 4.3.3 (2024-02-29 ucrt)
* using platform: x86_64-w64-mingw32 (64-bit)
* R was compiled by
    gcc.exe (GCC) 12.3.0
    GNU Fortran (GCC) 12.3.0
* running under: Windows Server 2022 x64 (build 20348)
* using session charset: UTF-8
* checking for file 'dm/DESCRIPTION' ... OK
* this is package 'dm' version '1.0.10'
* package encoding: UTF-8
* checking package namespace information ... OK
* checking package dependencies ... OK
* checking if this is a source package ... OK
* checking if there is a namespace ... OK
* checking for hidden files and directories ... OK
* checking for portable file names ... OK
* checking whether package 'dm' can be installed ... OK
* checking installed package size ... OK
* checking package directory ... OK
* checking 'build' directory ... OK
* checking DESCRIPTION meta-information ... OK
* checking top-level files ... OK
* checking for left-over files ... OK
* checking index information ... OK
* checking package subdirectories ... OK
* checking R files for non-ASCII characters ... OK
* checking R files for syntax errors ... OK
* checking whether the package can be loaded ... [2s] OK
* checking whether the package can be loaded with stated dependencies ... [2s] OK
* checking whether the package can be unloaded cleanly ... [2s] OK
* checking whether the namespace can be loaded with stated dependencies ... [2s] OK
* checking whether the namespace can be unloaded cleanly ... [2s] OK
* checking loading without being on the library search path ... [2s] OK
* checking startup messages can be suppressed ... [2s] OK
* checking use of S3 registration ... OK
* checking dependencies in R code ... OK
* checking S3 generic/method consistency ... OK
* checking replacement functions ... OK
* checking foreign function calls ... OK
* checking R code for possible problems ... [27s] OK
* checking Rd files ... [2s] OK
* checking Rd metadata ... OK
* checking Rd cross-references ... OK
* checking for missing documentation entries ... OK
* checking for code/documentation mismatches ... OK
* checking Rd \usage sections ... OK
* checking Rd contents ... OK
* checking for unstated dependencies in examples ... OK
* checking installed files from 'inst/doc' ... OK
* checking files in 'vignettes' ... OK
* checking examples ... [44s] OK
* checking for unstated dependencies in 'tests' ... OK
* checking tests ... [96s] ERROR
  Running 'testthat.R' [95s]
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-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-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-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 ('test_table_123_9_20241112_093722124421_84900', 'test_table_321_9_20241112_093722124421_84900', 'tf_1_3_20241112_093623420223_84900', 'tf_1_4_20241112_093623966281_84900', 'tf_1_5_20241112_093626160355_84900', ...)
  `expected` is an S4 object of class <character> ('test_table_123_9_20241112_093722124421_84900', 'test_table_321_9_20241112_093722124421_84900', 'tf_1_3_20241112_093623420223_84900', 'tf_1_4_20241112_093623966281_84900', 'tf_1_5_20241112_093626160355_84900', ...)
  
  [ 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
* checking for unstated dependencies in vignettes ... OK
* checking package vignettes in 'inst/doc' ... OK
* checking re-building of vignette outputs ... [59s] OK
* checking PDF version of manual ... [22s] OK
* checking HTML version of manual ... [16s] OK
* DONE
Status: 1 ERROR