R Under development (unstable) (2026-01-19 r89308 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.

> # This file is part of the standard setup for testthat.
> # It is recommended that you do not modify it.
> #
> # Where should you do additional test configuration?
> # Learn more about the roles of various files in:
> # * https://r-pkgs.org/tests.html
> # * https://testthat.r-lib.org/reference/test_package.html#special-files
> 
> library(testthat)
> library(PatientProfiles)
> 
> test_check("PatientProfiles")
Starting 2 test processes.
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-addConceptIntersect.R: ! The following columns will be overwritten:
> test-addConceptIntersect.R: * intersect
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * s: count, percentage
> test-summariseResult.R: * v_1: min, q25, median, q75, max
> test-summariseResult.R: * v_2: count, percentage
> test-summariseResult.R: * v_3: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * v_4: min, q25, median, q75, max
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:03:53.051253
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:03:53.207817
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * s: count, percentage
> test-summariseResult.R: * v_1: min, q25, median, q75, max
> test-summariseResult.R: * v_2: count, percentage
> test-summariseResult.R: * v_3: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * v_4: min, q25, median, q75, max
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:03:54.388962
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:03:54.994807
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * s: count, percentage
> test-summariseResult.R: * v_1: min, q25, median, q75, max
> test-summariseResult.R: * v_2: count, percentage
> test-summariseResult.R: * v_3: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * v_4: min, q25, median, q75, max
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:03:55.957061
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:03:56.524027
> test-summariseResult.R: ! names of strata will be ignored
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * s: count, percentage
> test-summariseResult.R: * v_1: min, q25, median, q75, max
> test-summariseResult.R: * v_2: count, percentage
> test-summariseResult.R: * v_3: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * v_4: min, q25, median, q75, max
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:03:57.567385
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:03:58.662219
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * acetaminophen_m365_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * cohort_end_date: min, q25, median, q75, max
> test-summariseResult.R: * cohort_start_date: min, q25, median, q75, max
> test-summariseResult.R: * covid_minf_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * headache_minf_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * ibuprophen_m365_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * naloxone_m365_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:00.450838
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:00.622873
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * acetaminophen_m365_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * cohort_end_date: min, q25, median, q75, max
> test-summariseResult.R: * cohort_start_date: min, q25, median, q75, max
> test-summariseResult.R: * covid_minf_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * headache_minf_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * ibuprophen_m365_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: * naloxone_m365_to_0: min, q25, median, q75, max, count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:03.727525
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:03.91504
> test-summariseResult.R: No analyses were selected.
> test-summariseResult.R: No analyses were selected.
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: mean, sd, median, q25, q75, count_missing, percentage_missing, density
> test-summariseResult.R: * number_visits: mean, sd, median, q25, q75, count_missing, percentage_missing, count, percentage, density
> test-summariseResult.R: * prior_history: mean, sd, median, q25, q75, count_missing, percentage_missing, density
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:05.407629
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:05.712397
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: mean, sd, median, q25, q75, count_missing, percentage_missing, density
> test-summariseResult.R: * number_visits: mean, sd, median, q25, q75, count_missing, percentage_missing, count, percentage, density
> test-summariseResult.R: * prior_history: mean, sd, median, q25, q75, count_missing, percentage_missing, density
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:06.887444
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:07.547573
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: min, q25, median, q75, max
> test-summariseResult.R: * age_group: count, percentage
> test-summariseResult.R: * condition_end_date: min, q25, median, q75, max
> test-summariseResult.R: * condition_start_date: min, q25, median, q75, max
> test-summariseResult.R: * future_observation: min, q25, median, q75, max
> test-summariseResult.R: * prior_observation: min, q25, median, q75, max
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:18.851388
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:19.182928
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: min, q25, median, q75, max
> test-summariseResult.R: * age_group: count, percentage
> test-summariseResult.R: * condition_end_date: min, q25, median, q75, max
> test-summariseResult.R: * condition_start_date: min, q25, median, q75, max
> test-summariseResult.R: * future_observation: min, q25, median, q75, max
> test-summariseResult.R: * prior_observation: min, q25, median, q75, max
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:20.86195
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:21.25076
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: min, q25, median, q75, max
> test-summariseResult.R: * age_group: count, percentage
> test-summariseResult.R: * condition_end_date: min, q25, median, q75, max
> test-summariseResult.R: * condition_start_date: min, q25, median, q75, max
> test-summariseResult.R: * future_observation: min, q25, median, q75, max
> test-summariseResult.R: * prior_observation: min, q25, median, q75, max
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:23.064904
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:23.226259
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * condition_end_date: min, q25, median, q75, max
> test-summariseResult.R: * condition_start_date: min, q25, median, q75, max
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:23.86756
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:24.006574
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: min, q25, median, q75, max
> test-summariseResult.R: * age_group: count, percentage
> test-summariseResult.R: * condition_end_date: min, q25, median, q75, max
> test-summariseResult.R: * condition_start_date: min, q25, median, q75, max
> test-summariseResult.R: * future_observation: min, q25, median, q75, max
> test-summariseResult.R: * prior_observation: min, q25, median, q75, max
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:36.580819
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:36.938885
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age: min, q25, median, q75, max
> test-summariseResult.R: * age_group: count, percentage
> test-summariseResult.R: * condition_end_date: min, q25, median, q75, max
> test-summariseResult.R: * condition_start_date: min, q25, median, q75, max
> test-summariseResult.R: * future_observation: min, q25, median, q75, max
> test-summariseResult.R: * prior_observation: min, q25, median, q75, max
> test-summariseResult.R: * sex: count, percentage
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:38.704235
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:39.175236
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:40.04049
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:40.120364
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * group: count
> test-summariseResult.R: * age1: density, mean
> test-summariseResult.R: * age2: density, mean
> test-summariseResult.R: * asthma: density, mean, count
> test-summariseResult.R: * birth: density, mean
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:47.404878
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:47.681008
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * group: count
> test-summariseResult.R: * age1: density, mean
> test-summariseResult.R: * age2: density, mean
> test-summariseResult.R: * asthma: density, mean, count
> test-summariseResult.R: * birth: density, mean
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:48.685542
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:49.348918
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age1: density
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:50.441794
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:50.555016
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age1: density
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:51.43152
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:51.525402
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * age1: density
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:52.632546
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:52.86365
> test-summariseResult.R: i The following estimates will be calculated:
> test-summariseResult.R: * birth: mean, sd
> test-summariseResult.R: ! Table is collected to memory as not all requested estimates are supported on the database side
> test-summariseResult.R: > Start summary of data, at 2026-01-20 20:04:53.75369
> test-summariseResult.R: v Summary finished, at 2026-01-20 20:04:53.853832
[ FAIL 0 | WARN 61 | SKIP 109 | PASS 196 ]

══ Skipped tests (109) ═════════════════════════════════════════════════════════
• On CRAN (108): 'test-addAttributes.R:2:3', 'test-addCategories.R:2:3',
  'test-addCategories.R:70:3', 'test-addCategories.R:109:3',
  'test-addCategories.R:157:3', 'test-addConceptIntersect.R:2:3',
  'test-addConceptIntersect.R:100:3', 'test-addConceptIntersect.R:152:3',
  'test-addConceptIntersect.R:195:3', 'test-addConceptIntersect.R:228:3',
  'test-addConceptIntersect.R:261:3', 'test-addCohortIntersect.R:272:3',
  'test-addCohortIntersect.R:347:3', 'test-addCohortIntersect.R:393:3',
  'test-addCohortIntersect.R:502:3', 'test-addCohortIntersect.R:592:3',
  'test-addCohortIntersect.R:650:3', 'test-addCohortIntersect.R:722:3',
  'test-addCohortIntersect.R:744:3', 'test-addCohortIntersect.R:830:3',
  'test-addCohortIntersect.R:884:3', 'test-addCohortIntersect.R:942:3',
  'test-addDeath.R:101:3', 'test-addDeath.R:143:3', 'test-addDeath.R:241:3',
  'test-addDeath.R:281:3', 'test-addFutureObservation.R:2:3',
  'test-addFutureObservation.R:14:3', 'test-addFutureObservation.R:30:3',
  'test-addFutureObservation.R:90:3', 'test-addFutureObservation.R:150:3',
  'test-addFutureObservation.R:212:3', 'test-addFutureObservation.R:256:3',
  'test-addInObservation.R:2:3', 'test-addInObservation.R:18:3',
  'test-addInObservation.R:49:3', 'test-addInObservation.R:173:3',
  'test-addIntersect.R:2:3', 'test-addIntersect.R:37:3',
  'test-addIntersect.R:226:3', 'test-addIntersect.R:277:3',
  'test-addIntersect.R:398:3', 'test-addIntersect.R:502:3',
  'test-addIntersect.R:558:3', 'test-addIntersect.R:626:3',
  'test-addIntersect.R:775:3', 'test-addIntersect.R:855:3',
  'test-addIntersect.R:872:3', 'test-addIntersect.R:942:3',
  'test-addIntersect.R:1028:3', 'test-addIntersect.R:1209:3',
  'test-addIntersect.R:1225:3', 'test-addObservationPeriodId.R:2:3',
  'test-addPriorObservation.R:2:3', 'test-addPriorObservation.R:14:3',
  'test-addPriorObservation.R:30:3', 'test-addPriorObservation.R:76:3',
  'test-addPriorObservation.R:121:3', 'test-addPriorObservation.R:184:3',
  'test-addSex.R:2:3', 'test-addSex.R:16:3', 'test-addSex.R:33:3',
  'test-addSex.R:76:3', 'test-addTableIntersect.R:31:3',
  'test-addTableIntersect.R:216:3', 'test-addTableIntersect.R:324:3',
  'test-addTableIntersect.R:460:3', 'test-addTableIntersect.R:591:3',
  'test-benchmarkPatientProfiles.R:2:3', 'test-checks.R:2:3',
  'test-checks.R:102:3', 'test-checks.R:155:3', 'test-checks.R:172:3',
  'test-checks.R:222:3', 'test-checks.R:249:3', 'test-filterCohortId.R:2:3',
  'test-addDemographics.R:2:3', 'test-addDemographics.R:26:3',
  'test-addDemographics.R:353:3', 'test-addDemographics.R:422:3',
  'test-addDemographics.R:697:3', 'test-addDemographics.R:849:3',
  'test-addDemographics.R:870:3', 'test-addDemographics.R:982:3',
  'test-addDemographics.R:1058:3', 'test-addDemographics.R:1172:3',
  'test-addDemographics.R:1238:3', 'test-addDemographics.R:1267:3',
  'test-addDemographics.R:1297:3', 'test-addDemographics.R:1316:3',
  'test-addDemographics.R:1330:3', 'test-addDemographics.R:1351:3',
  'test-addDemographics.R:1381:3', 'test-format.R:2:3', 'test-format.R:89:3',
  'test-format.R:100:3', 'test-format.R:110:3',
  'test-mockPatientProfiles.R:2:3', 'test-name.R:2:3', 'test-utilities.R:2:3',
  'test-summariseResult.R:255:3', 'test-summariseResult.R:300:3',
  'test-summariseResult.R:365:3', 'test-summariseResult.R:409:3',
  'test-summariseResult.R:431:3', 'test-summariseResult.R:502:3',
  'test-summariseResult.R:590:3', 'test-summariseResult.R:850:3'
• dbToTest == "duckdb" is TRUE (1): 'test-summariseResult.R:1116:3'

[ FAIL 0 | WARN 61 | SKIP 109 | PASS 196 ]
> 
> proc.time()
   user  system elapsed 
  17.98    0.81  182.57