Package: CohortCharacteristics Check: tests New result: ERROR Running ‘spelling.R’ [0s/0s] Running ‘testthat.R’ [472s/296s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > # 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(CohortCharacteristics) > > test_check("CohortCharacteristics") Starting 2 test processes. > test-plotCohortTiming.R: i The following estimates will be calculated: > test-plotCohortTiming.R: * days_between_cohort_entries: min, q25, median, q75, max, density > test-plotCohortTiming.R: ! Table is collected to memory as not all requested estimates are supported on the database side > test-plotCohortTiming.R: > Start summary of data, at 2026-03-13 14:56:44.210797 > test-plotCohortTiming.R: v Summary finished, at 2026-03-13 14:56:44.477484 > test-plotCohortTiming.R: `result_id` is not present in result. > test-plotCohortTiming.R: `result_id` is not present in result. > test-plotCohortTiming.R: `result_id` is not present in result. > test-plotCohortTiming.R: `result_id` is not present in result. Saving _problems/test-plotCohortTiming-245.R > test-plotLargeScaleCharacteristics.R: i Summarising large scale characteristics > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) > test-plotCohortAttrition.R: i The following estimates will be calculated: > test-plotCohortAttrition.R: * cohort_end_date: min, q25, median, q75, max > test-plotCohortAttrition.R: * cohort_start_date: min, q25, median, q75, max > test-plotCohortAttrition.R: ! Table is collected to memory as not all requested estimates are supported on the database side > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotCohortAttrition.R: > Start summary of data, at 2026-03-13 14:56:56.90179 > test-plotCohortAttrition.R: v Summary finished, at 2026-03-13 14:56:57.057841 > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotLargeScaleCharacteristics.R: - getting characteristics from table condition_occurrence (1 of 1) for time ... > test-plotLargeScaleCharacteristics.R: Formatting result > test-plotLargeScaleCharacteristics.R: v Summarising large scale characteristics > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` > test-summariseCharacteristics.R: i adding cohortIntersectFlag 2/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to 0` -> `inf_to_0` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/3 > test-summariseCharacteristics.R: i adding cohortIntersectFlag 2/3 > test-summariseCharacteristics.R: i adding cohortIntersectFlag 3/3 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to 0` -> `inf_to_0` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` > test-summariseCohortOverlap.R: Cohort table is empty: returning empty summarised result. > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` > test-summariseCharacteristics.R: i adding cohortIntersectFlag 2/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to 0` -> `inf_to_0` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCohortOverlap.R: `result_id` is not present in result. > test-summariseCharacteristics.R: i summarising cohort cohort_2 > test-summariseCharacteristics.R: i summarising cohort cohort_3 > test-summariseCohortOverlap.R: `result_id` is not present in result. > test-summariseCohortOverlap.R: `result_id` is not present in result. > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCohortOverlap.R: `result_id` is not present in result. > test-summariseCharacteristics.R: i adding tableIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` > test-summariseCohortOverlap.R: `result_id` is not present in result. > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: i summarising cohort cohort_2 > test-summariseCharacteristics.R: i summarising cohort cohort_3 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCohortTiming.R: Cohort table is empty: returning empty summarised timing result. > test-summariseCohortTiming.R: i The following estimates will be calculated: > test-summariseCohortTiming.R: * days_between_cohort_entries: min, q25, median, q75, max, density > test-summariseCohortTiming.R: ! Table is collected to memory as not all requested estimates are supported on the database side > test-summariseCohortTiming.R: > Start summary of data, at 2026-03-13 14:59:12.818407 > test-summariseCohortTiming.R: v Summary finished, at 2026-03-13 14:59:13.296557 > test-summariseCohortTiming.R: i The following estimates will be calculated: > test-summariseCohortTiming.R: * days_between_cohort_entries: min, q25, median, q75, max > test-summariseCohortTiming.R: ! Table is collected to memory as not all requested estimates are supported on the database side > test-summariseCohortTiming.R: > Start summary of data, at 2026-03-13 14:59:23.039288 > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCohortTiming.R: v Summary finished, at 2026-03-13 14:59:24.089482 > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` Saving _problems/test-summariseCohortTiming-63.R > test-utilities.R: `group` is not present in settings. > test-utilities.R: `group` is not present in settings. > test-utilities.R: `group` is not present in settings. > test-summariseCharacteristics.R: i adding cohortIntersectFlag 2/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to 0` -> `inf_to_0` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to 0` -> `365_to_0` > test-summariseCharacteristics.R: i adding cohortIntersectFlag 2/2 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to 0` -> `inf_to_0` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding tableIntersectCount 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to -1` -> `inf_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding tableIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to -1` -> `inf_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding tableIntersectDate 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to -1` -> `inf_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding tableIntersectDays 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `1 to Inf` -> `1_to_inf` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort exposed > test-summariseCharacteristics.R: i summarising cohort unexposed > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectCount 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to -1` -> `inf_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to -1` -> `inf_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectDate 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-Inf to -1` -> `inf_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectDays 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `1 to Inf` -> `1_to_inf` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to -1` -> `365_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: i summarising cohort cohort_2 > test-summariseCharacteristics.R: v summariseCharacteristics finished! > test-summariseCharacteristics.R: i adding demographics columns > test-summariseCharacteristics.R: i adding cohortIntersectFlag 1/1 > test-summariseCharacteristics.R: window names casted to snake_case: > test-summariseCharacteristics.R: * `-365 to -1` -> `365_to_1` > test-summariseCharacteristics.R: i summarising data > test-summariseCharacteristics.R: i summarising cohort cohort_1 > test-summariseCharacteristics.R: i summarising cohort cohort_2 > test-summariseCharacteristics.R: v summariseCharacteristics finished! [ FAIL 2 | WARN 17 | SKIP 24 | PASS 218 ] ══ Skipped tests (24) ══════════════════════════════════════════════════════════ • On CRAN (22): 'test-benchmarkCohortCharacteristics.R:2:3', 'test-plotCharacteristics.R:2:3', 'test-plotCharacteristics.R:176:3', 'test-plotCohortCount.R:2:3', 'test-plotCohortOverlap.R:2:3', 'test-plotCohortTiming.R:2:3', 'test-plotCohortTiming.R:100:3', 'test-plotLargeScaleCharacteristics.R:3:3', 'test-summariseCohortCount.R:2:3', 'test-summariseLargeScaleCharacteristics.R:2:3', 'test-table.R:2:3', 'test-tableCharacteristics.R:2:3', 'test-tableCharacteristics.R:124:3', 'test-tableCohortAttrition.R:2:3', 'test-tableCohortCount.R:2:3', 'test-tableCohortOverlap.R:2:3', 'test-tableCohortTiming.R:2:3', 'test-tableLargeScaleCharacteristics.R:2:3', 'test-tableLargeScaleCharacteristics.R:80:3', 'test-summariseCharacteristics.R:1180:3', 'test-summariseCharacteristics.R:1425:3', 'test-summariseCharacteristics.R:1552:3' • empty test (2): 'test-plotLargeScaleCharacteristics.R:140:1', 'test-summariseCohortTiming.R:114:1' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-plotCohortTiming.R:245:3'): plotCohortTiming, density x axis ─── Error in `dplyr::collect(x)`: Failed to collect lazy table. Caused by error in `dbSendQuery()`: ! INTERNAL Error: Failed to bind column reference "cohort_start_date_comparator" [24.0]: inequal types (DATE != INTEGER) Stack Trace: /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb9Exception6ToJSONENS_13ExceptionTypeERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE+0x54) [0x7f839306f0b4] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb9ExceptionC1ENS_13ExceptionTypeERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE+0x11) [0x7f839306f0e1] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb17InternalExceptionC2ERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE+0x11) [0x7f83930720b1] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb17InternalExceptionC1IJRKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERmSA_S7_S7_EEES9_DpOT_+0x199) [0x7f8393377d99] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(+0x90720a) [0x7f839250720a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor15VisitExpressionEPNS_10unique_ptrINS_10ExpressionESt14default_deleteIS2_ELb1EEE+0x118) [0x7f8393c2c128] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor20EnumerateExpressionsERNS_15LogicalOperatorERKSt8functionIFvPNS_10unique_ptrINS_10ExpressionESt14default_deleteIS5_ELb1EEEEE+0x7d) [0x7f8393c2dd8d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor24VisitOperatorExpressionsERNS_15LogicalOperatorE+0x3f) [0x7f8393c2e32f] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x7e) [0x7f83933659ae] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x2d2) [0x7f8393365c02] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor21VisitOperatorChildrenERNS_15LogicalOperatorE+0x4d) [0x7f8393c3e92d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x73) [0x7f83933659a3] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor21VisitOperatorChildrenERNS_15LogicalOperatorE+0x4d) [0x7f8393c3e92d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x73) [0x7f83933659a3] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor21VisitOperatorChildrenERNS_15LogicalOperatorE+0x4d) [0x7f8393c3e92d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x73) [0x7f83933659a3] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21PhysicalPlanGenerator14ResolveAndPlanENS_10unique_ptrINS_15LogicalOperatorESt14default_deleteIS2_ELb1EEE+0x8a) [0x7f839336633a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21PhysicalPlanGenerator4PlanENS_10unique_ptrINS_15LogicalOperatorESt14default_deleteIS2_ELb1EEE+0x2a) [0x7f839336652a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext31CreatePreparedStatementInternalERNS_17ClientContextLockERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS_10unique_ptrINS_12SQLStatementESt14default_deleteISC_ELb1EEENS_22PendingQueryParametersE+0x685) [0x7f8393a31cc5] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext23CreatePreparedStatementERNS_17ClientContextLockERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS_10unique_ptrINS_12SQLStatementESt14default_deleteISC_ELb1EEENS_22PendingQueryParametersENS_21PreparedStatementModeE+0x4da) [0x7f8393a3246a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(+0x1e32a97) [0x7f8393a32a97] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext32RunFunctionInTransactionInternalERNS_17ClientContextLockERKSt8functionIFvvEEb+0x74) [0x7f8393a0e614] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext15PrepareInternalERNS_17ClientContextLockENS_10unique_ptrINS_12SQLStatementESt14default_deleteIS4_ELb1EEE+0x1b5) [0x7f8393a12cf5] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext7PrepareENS_10unique_ptrINS_12SQLStatementESt14default_deleteIS2_ELb1EEE+0xa5) [0x7f8393a34b05] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb10Connection7PrepareENS_10unique_ptrINS_12SQLStatementESt14default_deleteIS2_ELb1EEE+0x30) [0x7f8393a34bb0] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_Z12rapi_prepareN5cpp1116external_pointerIN6duckdb11ConnWrapperEXadL_ZNS1_11ConnDeleterEPS2_EEEENSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS_11environmentE+0x43f) [0x7f839277281f] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_duckdb_rapi_prepare+0x19a) [0x7f83927ebf0a] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1051ae) [0x7f83ac7051ae] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x141ae1) [0x7f83ac741ae1] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1527d7) [0x7f83ac7527d7] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x35a) [0x7f83ac7520ca] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1527d7) [0x7f83ac7527d7] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x152ae5) [0x7f83ac752ae5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14a8a0) [0x7f83ac74a8a0] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1527d7) [0x7f83ac7527d7] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x152ae5) [0x7f83ac752ae5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14a8a0) [0x7f83ac74a8a0] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/lib/R/Library/4.6/x86_64-linux-gnu/rlang/libs/rlang.so(+0x1d1a0) [0x7f83969e31a0] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x10355a) [0x7f83ac70355a] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1464a5) [0x7f83ac7464a5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x15704d) [0x7f83ac75704d] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155984) [0x7f83ac755984] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14659c) [0x7f83ac74659c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(R_execMethod+0x229) [0x7f83ac754f29] /home/hornik/tmp/R-d-gcc-15/library/methods/libs/methods.so(+0x5b7d) [0x7f83a967bb7d] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a1fe4) [0x7f83ac7a1fe4] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14b7b9) [0x7f83ac74b7b9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155609) [0x7f83ac755609] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x19faf3) [0x7f83ac79faf3] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a0067) [0x7f83ac7a0067] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a041b) [0x7f83ac7a041b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14627c) [0x7f83ac74627c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155609) [0x7f83ac755609] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x19faf3) [0x7f83ac79faf3] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a0067) [0x7f83ac7a0067] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a041b) [0x7f83ac7a041b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14627c) [0x7f83ac74627c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155609) [0x7f83ac755609] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x19faf3) [0x7f83ac79faf3] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a01e1) [0x7f83ac7a01e1] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a041b) [0x7f83ac7a041b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14627c) [0x7f83ac74627c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x15704d) [0x7f83ac75704d] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155984) [0x7f83ac755984] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x15849f) [0x7f83ac75849f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1464a5) [0x7f83ac7464a5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x158964) [0x7f83ac758964] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1464a5) [0x7f83ac7464a5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic. For more information, see https://duckdb.org/docs/stable/dev/internal_errors i Context: rapi_prepare i Error type: INTERNAL ── Error ('test-summariseCohortTiming.R:60:3'): summariseCohortTiming ────────── Error in `dplyr::collect(x)`: Failed to collect lazy table. Caused by error in `dbSendQuery()`: ! INTERNAL Error: Failed to bind column reference "cohort_start_date_comparator" [24.0]: inequal types (DATE != INTEGER) Stack Trace: /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb9Exception6ToJSONENS_13ExceptionTypeERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE+0x54) [0x7f839306f0b4] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb9ExceptionC1ENS_13ExceptionTypeERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE+0x11) [0x7f839306f0e1] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb17InternalExceptionC2ERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEE+0x11) [0x7f83930720b1] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb17InternalExceptionC1IJRKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERmSA_S7_S7_EEES9_DpOT_+0x199) [0x7f8393377d99] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(+0x90720a) [0x7f839250720a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor15VisitExpressionEPNS_10unique_ptrINS_10ExpressionESt14default_deleteIS2_ELb1EEE+0x118) [0x7f8393c2c128] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor20EnumerateExpressionsERNS_15LogicalOperatorERKSt8functionIFvPNS_10unique_ptrINS_10ExpressionESt14default_deleteIS5_ELb1EEEEE+0x7d) [0x7f8393c2dd8d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor24VisitOperatorExpressionsERNS_15LogicalOperatorE+0x3f) [0x7f8393c2e32f] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x7e) [0x7f83933659ae] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x2d2) [0x7f8393365c02] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor21VisitOperatorChildrenERNS_15LogicalOperatorE+0x4d) [0x7f8393c3e92d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x73) [0x7f83933659a3] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor21VisitOperatorChildrenERNS_15LogicalOperatorE+0x4d) [0x7f8393c3e92d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x73) [0x7f83933659a3] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb22LogicalOperatorVisitor21VisitOperatorChildrenERNS_15LogicalOperatorE+0x4d) [0x7f8393c3e92d] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21ColumnBindingResolver13VisitOperatorERNS_15LogicalOperatorE+0x73) [0x7f83933659a3] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21PhysicalPlanGenerator14ResolveAndPlanENS_10unique_ptrINS_15LogicalOperatorESt14default_deleteIS2_ELb1EEE+0x8a) [0x7f839336633a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb21PhysicalPlanGenerator4PlanENS_10unique_ptrINS_15LogicalOperatorESt14default_deleteIS2_ELb1EEE+0x2a) [0x7f839336652a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext31CreatePreparedStatementInternalERNS_17ClientContextLockERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS_10unique_ptrINS_12SQLStatementESt14default_deleteISC_ELb1EEENS_22PendingQueryParametersE+0x685) [0x7f8393a31cc5] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext23CreatePreparedStatementERNS_17ClientContextLockERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS_10unique_ptrINS_12SQLStatementESt14default_deleteISC_ELb1EEENS_22PendingQueryParametersENS_21PreparedStatementModeE+0x4da) [0x7f8393a3246a] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(+0x1e32a97) [0x7f8393a32a97] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext32RunFunctionInTransactionInternalERNS_17ClientContextLockERKSt8functionIFvvEEb+0x74) [0x7f8393a0e614] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext15PrepareInternalERNS_17ClientContextLockENS_10unique_ptrINS_12SQLStatementESt14default_deleteIS4_ELb1EEE+0x1b5) [0x7f8393a12cf5] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb13ClientContext7PrepareENS_10unique_ptrINS_12SQLStatementESt14default_deleteIS2_ELb1EEE+0xa5) [0x7f8393a34b05] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_ZN6duckdb10Connection7PrepareENS_10unique_ptrINS_12SQLStatementESt14default_deleteIS2_ELb1EEE+0x30) [0x7f8393a34bb0] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_Z12rapi_prepareN5cpp1116external_pointerIN6duckdb11ConnWrapperEXadL_ZNS1_11ConnDeleterEPS2_EEEENSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEENS_11environmentE+0x43f) [0x7f839277281f] /home/hornik/tmp/CRAN_recheck/Library/duckdb/libs/duckdb.so(_duckdb_rapi_prepare+0x19a) [0x7f83927ebf0a] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1051ae) [0x7f83ac7051ae] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x141ae1) [0x7f83ac741ae1] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1527d7) [0x7f83ac7527d7] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x35a) [0x7f83ac7520ca] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1527d7) [0x7f83ac7527d7] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x152ae5) [0x7f83ac752ae5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14a8a0) [0x7f83ac74a8a0] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1527d7) [0x7f83ac7527d7] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x152ae5) [0x7f83ac752ae5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14a8a0) [0x7f83ac74a8a0] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/lib/R/Library/4.6/x86_64-linux-gnu/rlang/libs/rlang.so(+0x1d1a0) [0x7f83969e31a0] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x10355a) [0x7f83ac70355a] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1464a5) [0x7f83ac7464a5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x15704d) [0x7f83ac75704d] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155984) [0x7f83ac755984] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14659c) [0x7f83ac74659c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(R_execMethod+0x229) [0x7f83ac754f29] /home/hornik/tmp/R-d-gcc-15/library/methods/libs/methods.so(+0x5b7d) [0x7f83a967bb7d] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a1fe4) [0x7f83ac7a1fe4] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14b7b9) [0x7f83ac74b7b9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155609) [0x7f83ac755609] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x19faf3) [0x7f83ac79faf3] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a0067) [0x7f83ac7a0067] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a041b) [0x7f83ac7a041b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14627c) [0x7f83ac74627c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155609) [0x7f83ac755609] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x19faf3) [0x7f83ac79faf3] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a0067) [0x7f83ac7a0067] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a041b) [0x7f83ac7a041b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14627c) [0x7f83ac74627c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155609) [0x7f83ac755609] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x19faf3) [0x7f83ac79faf3] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a01e1) [0x7f83ac7a01e1] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1a041b) [0x7f83ac7a041b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x14627c) [0x7f83ac74627c] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x15704d) [0x7f83ac75704d] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x155984) [0x7f83ac755984] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x52f) [0x7f83ac75229f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x15849f) [0x7f83ac75849f] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1464a5) [0x7f83ac7464a5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x153e1e) [0x7f83ac753e1e] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x154bd9) [0x7f83ac754bd9] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x28a) [0x7f83ac751ffa] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x158964) [0x7f83ac758964] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x1464a5) [0x7f83ac7464a5] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(+0x151b0b) [0x7f83ac751b0b] /home/hornik/tmp/R-d-gcc-15/lib/libR.so(Rf_eval+0x14b) [0x7f83ac751ebb] This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic. For more information, see https://duckdb.org/docs/stable/dev/internal_errors i Context: rapi_prepare i Error type: INTERNAL [ FAIL 2 | WARN 17 | SKIP 24 | PASS 218 ] Error: ! Test failures. Execution halted Package: duckspatial Check: re-building of vignette outputs New result: ERROR Error(s) in re-building vignettes: ... --- re-building ‘aw_interpolation.Rmd’ using rmarkdown Quitting from aw_interpolation.Rmd:67-78 [unnamed-chunk-2] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error in `get_geom_name()`: ! The table does not exist. --- Backtrace: ▆ 1. └─duckspatial::ddbs_interpolate_aw(...) 2. └─duckspatial:::get_geom_name(conn, t_list$query_name) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: processing vignette 'aw_interpolation.Rmd' failed with diagnostics: The table does not exist. --- failed re-building ‘aw_interpolation.Rmd’ --- re-building ‘benchmark.Rmd’ using rmarkdown --- finished re-building ‘benchmark.Rmd’ --- re-building ‘duckspatial.Rmd’ using rmarkdown [WARNING] Deprecated: --highlight-style. Use --syntax-highlighting instead. --- finished re-building ‘duckspatial.Rmd’ --- re-building ‘spatial_joins.Rmd’ using rmarkdown [WARNING] Deprecated: --highlight-style. Use --syntax-highlighting instead. --- finished re-building ‘spatial_joins.Rmd’ SUMMARY: processing the following file failed: ‘aw_interpolation.Rmd’ Error: Vignette re-building failed. Execution halted Package: duckspatial Check: tests New result: ERROR Running ‘testthat.R’ [8s/7s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > # 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/testing-design.html#sec-tests-files-overview > # * https://testthat.r-lib.org/articles/special-files.html > > library(testthat) > library(duckspatial) Important: 'crs_column' and 'crs' arguments are deprecated and will be removed in the next version. If possible, use the default values of these arguments to avoid future issues. > library(duckdb) Loading required package: DBI > > test_check("duckspatial") Reading layer `countries' from data source `/home/hornik/tmp/CRAN_recheck/duckspatial.Rcheck/duckspatial/spatial/countries.geojson' using driver `GeoJSON' Simple feature collection with 257 features and 6 fields Geometry type: POLYGON Dimension: XY Bounding box: xmin: -178.9125 ymin: -89.9 xmax: 180 ymax: 83.65187 Geodetic CRS: WGS 84 Reading layer `argentina' from data source `/home/hornik/tmp/CRAN_recheck/duckspatial.Rcheck/duckspatial/spatial/argentina.geojson' using driver `GeoJSON' Simple feature collection with 1 feature and 6 fields Geometry type: POLYGON Dimension: XY Bounding box: xmin: -73.52455 ymin: -52.39755 xmax: -53.62409 ymax: -21.81793 Geodetic CRS: WGS 84 Reading layer `rivers' from data source `/home/hornik/tmp/CRAN_recheck/duckspatial.Rcheck/duckspatial/spatial/rivers.geojson' using driver `GeoJSON' Simple feature collection with 100 features and 1 field Geometry type: LINESTRING Dimension: XY Bounding box: xmin: 2766878 ymin: 2222357 xmax: 3578648 ymax: 2459939 Projected CRS: ETRS89-extended / LAEA Europe v Temporary view view_test registered Saving _problems/test-compatibility-28.R i Table dropped v Table rt_write_line successfully imported Saving _problems/test-compatibility-63.R v Temporary view rt_register_line registered Saving _problems/test-compatibility-92.R i Table dropped v Table countries_from_file_compat successfully imported Saving _problems/test-compatibility-112.R [ FAIL 4 | WARN 1 | SKIP 17 | PASS 3 ] ══ Skipped tests (17) ══════════════════════════════════════════════════════════ • On CRAN (17): 'test-db_read.R:2:1', 'test-db_register.R:3:1', 'test-db_write.R:3:1', 'test-ddbs_area.R:3:1', 'test-ddbs_bbox.R:3:1', 'test-ddbs_combine.R:3:1', 'test-ddbs_concave_hull.R:3:1', 'test-ddbs_convex_hull.R:3:1', 'test-ddbs_distance.R:3:1', 'test-ddbs_envelope.R:3:1', 'test-ddbs_generate_points.R:5:1', 'test-ddbs_interpolate_aw.R:2:1', 'test-ddbs_join.R:3:1', 'test-ddbs_length.R:3:1', 'test-ddbs_transform.R:5:1', 'test-ddbs_union.R:3:1', 'test-utils.R:2:1' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-compatibility.R:28:5'): Compatibility: Arrow Views behave like Persistent Tables ── Error in `dbSendQuery(conn, statement, ...)`: Unknown column type for prepare: GEOMETRY i Context: rapi_prepare Backtrace: ▆ 1. ├─duckspatial::ddbs_read_vector(conn, "view_test", crs = 4326) at test-compatibility.R:28:5 2. │ ├─DBI::dbListFields(conn, name_list$query_name) 3. │ └─DBI::dbListFields(conn, name_list$query_name) 4. │ ├─DBI::dbGetQuery(...) 5. │ └─DBI::dbGetQuery(...) 6. │ └─DBI (local) .local(conn, statement, ...) 7. │ ├─DBI::dbSendQuery(conn, statement, ...) 8. │ └─duckdb::dbSendQuery(conn, statement, ...) 9. │ └─duckdb (local) .local(conn, statement, ...) 10. │ └─duckdb:::rethrow_rapi_prepare(conn@conn_ref, statement, env) 11. │ ├─rlang::try_fetch(...) 12. │ │ ├─base::tryCatch(...) 13. │ │ │ └─base (local) tryCatchList(expr, classes, parentenv, handlers) 14. │ │ │ └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 15. │ │ │ └─base (local) doTryCatch(return(expr), name, parentenv, handler) 16. │ │ └─base::withCallingHandlers(...) 17. │ └─duckdb:::rapi_prepare(conn, query, env) 18. ├─duckdb (local) ``("rapi_prepare", "Unknown column type for prepare: GEOMETRY") 19. │ └─rlang::abort(error_parts, class = "duckdb_error", !!!fields) 20. │ └─rlang:::signal_abort(cnd, .file) 21. │ └─base::signalCondition(cnd) 22. └─rlang (local) ``(``) 23. └─handlers[[1L]](cnd) 24. └─duckdb:::rethrow_error_from_rapi(e, call) 25. └─rlang::abort(msg, call = call) ── Error ('test-compatibility.R:63:9'): Round trip: write -> read for various geometry types ── Error in `get_geom_name(conn, name_list$query_name)`: The table does not exist. Backtrace: ▆ 1. └─duckspatial::ddbs_read_vector(conn, table_name) at test-compatibility.R:63:9 2. └─duckspatial:::get_geom_name(conn, name_list$query_name) 3. └─cli::cli_abort("The table <{x}> does not exist.") 4. └─rlang::abort(...) ── Error ('test-compatibility.R:92:9'): Round trip: register -> read for various geometry types ── Error in `dbSendQuery(conn, statement, ...)`: Unknown column type for prepare: GEOMETRY i Context: rapi_prepare Backtrace: ▆ 1. ├─duckspatial::ddbs_read_vector(conn, view_name) at test-compatibility.R:92:9 2. │ ├─DBI::dbListFields(conn, name_list$query_name) 3. │ └─DBI::dbListFields(conn, name_list$query_name) 4. │ ├─DBI::dbGetQuery(...) 5. │ └─DBI::dbGetQuery(...) 6. │ └─DBI (local) .local(conn, statement, ...) 7. │ ├─DBI::dbSendQuery(conn, statement, ...) 8. │ └─duckdb::dbSendQuery(conn, statement, ...) 9. │ └─duckdb (local) .local(conn, statement, ...) 10. │ └─duckdb:::rethrow_rapi_prepare(conn@conn_ref, statement, env) 11. │ ├─rlang::try_fetch(...) 12. │ │ ├─base::tryCatch(...) 13. │ │ │ └─base (local) tryCatchList(expr, classes, parentenv, handlers) 14. │ │ │ └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 15. │ │ │ └─base (local) doTryCatch(return(expr), name, parentenv, handler) 16. │ │ └─base::withCallingHandlers(...) 17. │ └─duckdb:::rapi_prepare(conn, query, env) 18. ├─duckdb (local) ``("rapi_prepare", "Unknown column type for prepare: GEOMETRY") 19. │ └─rlang::abort(error_parts, class = "duckdb_error", !!!fields) 20. │ └─rlang:::signal_abort(cnd, .file) 21. │ └─base::signalCondition(cnd) 22. └─rlang (local) ``(``) 23. └─handlers[[1L]](cnd) 24. └─duckdb:::rethrow_error_from_rapi(e, call) 25. └─rlang::abort(msg, call = call) ── Error ('test-compatibility.R:112:5'): Compatibility: Writing from file path and reading back ── Error in `get_geom_name(conn, name_list$query_name)`: The table does not exist. Backtrace: ▆ 1. └─duckspatial::ddbs_read_vector(conn, table_name) at test-compatibility.R:112:5 2. └─duckspatial:::get_geom_name(conn, name_list$query_name) 3. └─cli::cli_abort("The table <{x}> does not exist.") 4. └─rlang::abort(...) [ FAIL 4 | WARN 1 | SKIP 17 | PASS 3 ] Error: ! Test failures. Execution halted