Running ‘testthat.R’ [15s/27s]
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 
    `/data/gannet/ripley/R/packages/tests-devel/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 
    `/data/gannet/ripley/R/packages/tests-devel/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 
    `/data/gannet/ripley/R/packages/tests-devel/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 <rt_write_line> 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 <countries_from_file_compat> 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) `<fn>`("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) `<fn>`(`<dckdb_rr>`)
   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 <rt_write_line> 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) `<fn>`("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) `<fn>`(`<dckdb_rr>`)
   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 <countries_from_file_compat> 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