Running 'spelling.R' [0s]
  Running 'testthat.R' [64s]
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(SCDB)
  
  Attaching package: 'SCDB'
  
  The following object is masked from 'package:base':
  
      nrow
  
  > 
  > # Run the test using the default system connection
  > test_check("SCDB")
  [conflicted] Will prefer SCDB::id over any other package.
  No useful drivers (other than SQLite) were found!
  #####
  Following drivers will be tested:
    RSQLite::SQLite (SQLite)
  
  Following drivers were not found and will NOT be tested:
    RPostgres::Postgres (PostgreSQL)
    odbc::odbc (MSSQL)
  #####
  [ FAIL 1 | WARN 1 | SKIP 0 | PASS 336 ]
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error ('test-db_joins.R:99:3'): *_join() works ──────────────────────────────
  Error in `dplyr::collect(dplyr::select(dplyr::left_join(xx, xx, na_by = "name"), 
      !"name"))`: Failed to collect lazy table.
  Caused by error:
  ! Invalid result set
  Backtrace:
       ▆
    1. ├─testthat::expect_equal(...) at test-db_joins.R:99:3
    2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. ├─dplyr::collect(...)
    5. └─dbplyr:::collect.tbl_sql(dplyr::select(dplyr::left_join(xx, xx, na_by = "name"), !"name"))
    6.   └─base::tryCatch(...)
    7.     └─base (local) tryCatchList(expr, classes, parentenv, handlers)
    8.       └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]])
    9.         └─value[[3L]](cond)
   10.           └─cli::cli_abort("Failed to collect lazy table.", parent = cnd)
   11.             └─rlang::abort(...)
  
  [ FAIL 1 | WARN 1 | SKIP 0 | PASS 336 ]
  Error: Test failures
  In addition: Warning message:
  Closing open result set, pending rows 
  Execution halted