R version 4.6.0 alpha (2026-03-28 r89738 ucrt) 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/testing-design.html#sec-tests-files-overview > # * https://testthat.r-lib.org/articles/special-files.html > > library(testthat) > library(duckspatial) duckspatial 1.0.0 attached * Compatible with DuckDB v1.5.1 * This release introduces breaking changes * See full release notes for migration guidance Default output has changed: duckspatial now returns lazy `duckspatial_df` (dbplyr) objects instead of `sf` objects. To restore the previous behaviour: ddbs_options(duckspatial.mode = 'sf') > library(duckdb) Loading required package: DBI > > test_check("duckspatial") Reading layer `countries' from data source `D:\RCompile\CRANincoming\R-devel\lib\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 `D:\RCompile\CRANincoming\R-devel\lib\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 `D:\RCompile\CRANincoming\R-devel\lib\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 Table nc_test_opts successfully imported v Temporary view view_test registered v Arrow view view_test successfully imported. i Table dropped v Table table_test successfully imported v table table_test successfully imported. i Table dropped v Table rt_write_line successfully imported v table rt_write_line successfully imported. i Table dropped v Table rt_write_polygon successfully imported v table rt_write_polygon successfully imported. i Table dropped v Table rt_write_multipoint successfully imported v table rt_write_multipoint successfully imported. v Temporary view rt_register_line registered v Arrow view rt_register_line successfully imported. v Temporary view rt_register_polygon registered v Arrow view rt_register_polygon successfully imported. v Temporary view rt_register_multipoint registered v Arrow view rt_register_multipoint successfully imported. i Table dropped v Table countries_from_file_compat successfully imported v table countries_from_file_compat successfully imported. Imported view using SQL recreation (zero overhead) v Temporary view imported_07e4b0cc_c004_46ff_861d_dd16daaef2f1 registered v Table nc_data successfully imported v Table nc_as_sf successfully imported v Table nc_data successfully imported ! Column 'FID' renamed to 'FID_original' to avoid conflict with GeoPackage primary key. -- duckspatial Status Report --------------------------------------------------- -- Global Options -- * Output Type: "duckspatial_df" * Mode: "duckspatial" -- Default Connection -- v Active DuckDB connection found. v spatial extension loaded v table source_countries successfully imported. v table imported_countries successfully imported. v table source_countries successfully imported. v table original successfully imported. ! No CRS found in the input data. The table will be created without CRS information. v Table test_table successfully imported Imported view using SQL recreation (zero overhead) Detected column "geom", converting to first. writing: substituting ENGCRS["Undefined Cartesian SRS with unknown unit"] for missing CRS Imported view using SQL recreation (zero overhead) Imported view using SQL query (zero overhead) Imported view using ATTACH (zero-copy, READ_ONLY) Imported view using ATTACH (zero-copy, READ_ONLY) v Temporary view sf_imported registered v Table points_lazy successfully imported v Table countries_lazy successfully imported v Table points_c1 successfully imported v Table countries_c2 successfully imported v Temporary view imported_78df9625_63dc_4e02_8191_766023edf391 registered v Temporary view imported_c1f938d4_a131_4b80_a696_67d6f37cf7ef registered ! No CRS found in the input data. The table will be created without CRS information. v Table test_table successfully imported v table test_table successfully imported. ! No CRS found in the input data. The table will be created without CRS information. v Table test_table successfully imported ! No CRS found in the input data. The table will be created without CRS information. v Table test_table_2 successfully imported v Table t1 successfully imported v Table t1 successfully imported v Table t2 successfully imported v Temporary view imported_328bb5e4_bff9_4b0a_a0b9_6eea69316057 registered v Arrow view imported_328bb5e4_bff9_4b0a_a0b9_6eea69316057 successfully imported. v Table t1 successfully imported v Temporary view imported_9a6a6a73_bdab_456b_bd60_7c3a12d9af65 registered v Table t1 successfully imported v Table t1 successfully imported v Table t2 successfully imported v Temporary view imported_b19cc500_ff6d_4095_8a63_2293929815df registered [ FAIL 0 | WARN 4 | SKIP 21 | PASS 440 ] ══ Skipped tests (21) ══════════════════════════════════════════════════════════ • On CRAN (20): 'test-db_read.R:2:1', 'test-db_register.R:3:1', 'test-db_write.R:3:1', 'test-ddbs_affine.R:7:1', 'test-ddbs_as_spatial.R:6:1', 'test-ddbs_extent_funs.R:6:1', 'test-ddbs_filter.R:3:1', 'test-ddbs_generate_points.R:6:1', 'test-ddbs_geom_conversion.R:6:1', 'test-ddbs_geom_validation.R:6:1', 'test-ddbs_interpolate_aw.R:2:1', 'test-ddbs_join.R:3:1', 'test-ddbs_measure.R:6:1', 'test-ddbs_ops_binary.R:6:1', 'test-ddbs_ops_unary.R:6:1', 'test-ddbs_predicates.R:6:1', 'test-ddbs_quadkey.R:6:1', 'test-ddbs_transform.R:5:1', 'test-ddbs_union.R:6:1', 'test-utils.R:2:1' • Skipping (1): 'test-duckspatial_df_dplyr_methods.R:195:3' [ FAIL 0 | WARN 4 | SKIP 21 | PASS 440 ] > > proc.time() user system elapsed 187.78 51.98 103.67