R Under development (unstable) (2024-12-12 r87438 ucrt) -- "Unsuffered Consequences" Copyright (C) 2024 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) > library(joyn) Attaching package: 'joyn' The following object is masked from 'package:base': merge > > test_check("joyn") x Error: Input table x has no columns. x Error: Input table x has no columns. x Error: Input table y has no columns. x Error: Neither x or y table has columns. x Error: Table x has the following column duplicated: x. Please rename or remove and try again. x Error: table x is not uniquely identified by id Duplicate counts in x: id copies percent 1: 1 2 40% 2: total 5 100% x Error: table y is not uniquely identified by id Duplicate counts in y: id copies percent 1: 2 2 40% 2: total 5 100% x Error: table x is not uniquely identified by id1 x Error: table y is not uniquely identified by id1 Duplicate counts in x: id1 copies percent 1: 1 2 50% 2: total 4 100% Duplicate counts in y: id1 copies percent 1: 3 2 50% 2: total 4 100% x Error: table y is not uniquely identified by id Duplicate counts in y: id copies percent 1: 2 2 40% 2: total 5 100% x Error: table y is not uniquely identified by id Duplicate counts in y: id copies percent 1: 2 2 40% 2: total 5 100% ! Warning: argument copy = TRUE is not active in this version of joyn ! Warning: joyn does not currently allow inequality joins, so keep = NULL will retain only keys in x inner join: df1[id1, id2] 3/4 (75%) <1:1st> df3[id1, id2] 3/4 (75%) i Note: Joyn's report available in variable .joyn v This is an info message o Timing:The full joyn is executed in 0.000344 seconds. o Timing: The entire joyn function, including checks, is executed in 0.016865 seconds. ! Warning: Currently, joyn allows only na_matches = 'na' x This is a warning message ! Warning: Currently, joyn allows only na_matches = 'na' x This is a warning message v first try v first try info v second try warn v first try info v third try note v second try warn x Error: table y is not uniquely identified by id x Error: table x is not uniquely identified by id x Error: table y is not uniquely identified by id -- JOYn Report -- .joyn n percent 1 x 2 100% 2 y 1 50% 3 total 2 100% ---------------------------------------------------------- End of JOYn report -- i Note: Joyn's report available in variable .joyn ! Warning: cannot use arguments update_values = TRUE and/or update_NAs = TRUE for anti join x Error: table x is not uniquely identified by id ℹ Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `id`, `datetime_1`, and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, character_5, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `datetime_1` and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, numeric_double_5, …, datetime_1, and datetime_2 ! Max number of possible IDs (100) reached. You may modify it in argument `max_numb_possible_ids` ℹ Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `id`, `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, numeric_double_5, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, character_5, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `datetime_1` and `datetime_2` i Variables to test: id, t, and x i Found unique identifiers: `x` i Variables to test: id, t, and x i Found unique identifiers: `x` i Variables to test: id1, id2, t, and x i Variables to test: id1, id2, t, and x i Variables to test: numeric_int_1, numeric_int_2, numeric_int_3, and numeric_int_4 i Variables to test: numeric_int_1, numeric_int_2, numeric_int_3, and numeric_int_4 i Variables to test: id, numeric_int_1, and character_1 i Found unique identifiers: `id` i Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, ..., datetime_1, and datetime_2 i Found unique identifiers: `id`, `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, and `datetime_2` i Variables to test: id, numeric_double_1, and numeric_double_2 i Found unique identifiers: `id`, `numeric_double_1`, and `numeric_double_2` i Variables to test: id, unique_id2, and unique_id3 i Variables to test: id1, id2, and t i Variables to test: id, unique_id2, factor_1, and factor_2 i Found unique identifiers: `id` i Variables to test: id1, id2, t, and x i Variables to test: t and x i Variables to test: id1, id2, and t i Variables to test: logical_1, logical_2, factor_1, factor_2, and unique_id1 ! No unique identifier found. i Variables to test: t and x i Variables to test: id1 and x i Variables to test: character_1, character_2, character_3, character_4, character_5, character_6, character_7, character_8, character_9, and character_10 i Variables to test: id and foo i Found unique identifiers: `id` and `foo` i Variables to test: id, unique_id1, unique_id3, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, and numeric_int_10 i Found unique identifiers: `id` i Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, ..., numeric_double_1, and numeric_double_2 i Found unique identifiers: `id`, `datetime_1`, `datetime_2`, `numeric_double_1`, and `numeric_double_2` i Variables to test: t and x i Variables to test: v, foo, and id i Found unique identifiers: `v`, `foo`, and `id` x No variables available after applying include/exclude filters. i Found unique identifiers: `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, `datetime_2`, and `id` i Variables to test: unique_id2, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, numeric_double_5, numeric_double_6, numeric_double_7, numeric_double_8, numeric_double_9, numeric_double_10, character_1, character_2, character_3, character_4, character_5, character_6, character_7, ..., datetime_2, and numeric_int_1 i Found unique identifiers: `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, and `datetime_2` i Variables to test: t ! Can't make combinations of t if the min number of combinations is 2 and the max is 1 i Variables to test: id1, id2, t, and x i Variables to test: id1 and t i Variables to test: id1, id2, t, and x i Variables to test: id, v, and foo i Found unique identifiers: `id`, `v`, and `foo` i Variables to test: unique_id1, unique_id2, unique_id3, character_1, character_2, character_3, and character_4 i Variables to test: id, t, and x i Found unique identifiers: `x` i Variables to test: id1, id2, t, and x i Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, ..., datetime_1, and datetime_2 i Variables to test: id1, id2, t, and x ! Can't make combinations of id1, t, id2, and x if the min number of combinations is 2 and the max is 1 i Variables to test: id1, id2, t, and x ! Can't make combinations of id1, t, id2, and x if the min number of combinations is 3 and the max is 2 i Variables to test: id, t, and x i Found unique identifiers: `x` ! var `rer` not found in dataframe i Variables to test: id, t, and x i Found unique identifiers: `x` i Variables to test: id1 and t i Variables to test: id1 and t i Variables to test: var1, var2, and var3 i Variables to test: id1, id2, and id3 i Variables to test: id1, id2, and id3 ℹ Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `id`, `datetime_1`, and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, character_5, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `datetime_1` and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, numeric_double_5, …, datetime_1, and datetime_2 ! Max number of possible IDs (100) reached. You may modify it in argument `max_numb_possible_ids` ℹ Variables to test: id, unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `id`, `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, numeric_double_1, numeric_double_2, numeric_double_3, numeric_double_4, numeric_double_5, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `numeric_double_1`, `numeric_double_2`, `numeric_double_3`, `numeric_double_4`, `numeric_double_5`, `numeric_double_6`, `numeric_double_7`, `numeric_double_8`, `numeric_double_9`, `numeric_double_10`, `datetime_1`, and `datetime_2` ℹ Variables to test: unique_id1, unique_id2, unique_id3, numeric_int_1, numeric_int_2, numeric_int_3, numeric_int_4, numeric_int_5, numeric_int_6, numeric_int_7, numeric_int_8, numeric_int_9, numeric_int_10, character_1, character_2, character_3, character_4, character_5, …, datetime_1, and datetime_2 ℹ Found unique identifiers: `datetime_1` and `datetime_2` ── JOYn Report ── .joyn n percent 1 x 2 25% 2 y 1 12.5% 3 x & y 5 62.5% 4 total 8 100% ────────────────────────────────────────────────────────── End of JOYn report ── ℹ Note: Joyn's report available in variable .joyn ℹ Note: Removing key variables id from id, x, category, and t i name x- is an invalid variable name. It will be changed to x. i name is an invalid variable name. It will be changed to X [ FAIL 0 | WARN 0 | SKIP 6 | PASS 474 ] ══ Skipped tests (6) ═══════════════════════════════════════════════════════════ • This test is not needed anymore because the match is always m:m in collapse::join (1): 'test-joyn_workhorse.R:76:3' • empty test (3): 'test-dplyr-joins.R:1202:1', 'test-joyn.R:70:1', 'test-update_na_vals.R:215:1' • joyn_workhorse does not check match type (1): 'test-joyn_workhorse.R:202:3' • warning of cartesian is not working well yet - (1): 'test-merge-data.table.R:69:3' [ FAIL 0 | WARN 0 | SKIP 6 | PASS 474 ] > > proc.time() user system elapsed 20.31 1.01 20.95