Running ‘testthat.R’ [39s/107s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > if (requireNamespace("testthat", quietly = TRUE)) {
  +   library(testthat)
  +   library(mlr3db)
  +   test_check("mlr3db")
  + }
  Loading required package: mlr3
  Loading required namespace: future
  Loading required package: RSQLite
  Loading required package: RSQLite
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Error (test_as_duckdb_backend.R:6:3): data ──────────────────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_hvraruvnma
  Error: Catalog Error: Table with name _duckdb_append_view_hvraruvnma does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_hvraruvnma
                                                    ^
  Backtrace:
       █
    1. └─global::expect_backend(b) test_as_duckdb_backend.R:6:2
    2.   └─b$data(rows = rn, cols = pk, data_format = "data.table")
    3.     └─mlr3db:::.__DataBackendDuckDB__data(...)
    4.       └─mlr3db:::write_temp_table(private$.data, rows)
    5.         ├─DBI::dbWriteTable(...)
    6.         └─DBI::dbWriteTable(...)
    7.           └─duckdb:::.local(conn, name, value, ...)
    8.             ├─DBI::dbExecute(...)
    9.             └─DBI::dbExecute(...)
   10.               ├─DBI::dbSendStatement(conn, statement, ...)
   11.               └─DBI::dbSendStatement(conn, statement, ...)
   12.                 ├─DBI::dbSendQuery(conn, statement, ...)
   13.                 └─duckdb::dbSendQuery(conn, statement, ...)
   14.                   └─duckdb:::.local(conn, statement, ...)
  ── Error (test_as_duckdb_backend.R:14:3): DataBackend ──────────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_qnoogvctpm
  Error: Catalog Error: Table with name _duckdb_append_view_qnoogvctpm does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_qnoogvctpm
                                                    ^
  Backtrace:
       █
    1. └─global::expect_iris_backend(b) test_as_duckdb_backend.R:14:2
    2.   └─b$distinct(b$rownames, "Species")
    3.     └─mlr3db:::.__DataBackendDuckDB__distinct(...)
    4.       └─mlr3db:::write_temp_table(private$.data, rows)
    5.         ├─DBI::dbWriteTable(...)
    6.         └─DBI::dbWriteTable(...)
    7.           └─duckdb:::.local(conn, name, value, ...)
    8.             ├─DBI::dbExecute(...)
    9.             └─DBI::dbExecute(...)
   10.               ├─DBI::dbSendStatement(conn, statement, ...)
   11.               └─DBI::dbSendStatement(conn, statement, ...)
   12.                 ├─DBI::dbSendQuery(conn, statement, ...)
   13.                 └─duckdb::dbSendQuery(conn, statement, ...)
   14.                   └─duckdb:::.local(conn, statement, ...)
  ── Error (test_as_duckdb_backend.R:23:3): Task ─────────────────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_urfecbcbkr
  Error: Catalog Error: Table with name _duckdb_append_view_urfecbcbkr does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_urfecbcbkr
                                                    ^
  Backtrace:
       █
    1. └─global::expect_backend(task$backend) test_as_duckdb_backend.R:23:2
    2.   └─b$data(rows = rn, cols = pk, data_format = "data.table")
    3.     └─mlr3db:::.__DataBackendDuckDB__data(...)
    4.       └─mlr3db:::write_temp_table(private$.data, rows)
    5.         ├─DBI::dbWriteTable(...)
    6.         └─DBI::dbWriteTable(...)
    7.           └─duckdb:::.local(conn, name, value, ...)
    8.             ├─DBI::dbExecute(...)
    9.             └─DBI::dbExecute(...)
   10.               ├─DBI::dbSendStatement(conn, statement, ...)
   11.               └─DBI::dbSendStatement(conn, statement, ...)
   12.                 ├─DBI::dbSendQuery(conn, statement, ...)
   13.                 └─duckdb::dbSendQuery(conn, statement, ...)
   14.                   └─duckdb:::.local(conn, statement, ...)
  ── Error (test_duckdb.R:7:3): Valid DataBackend ────────────────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_ovfqqzyymc
  Error: Catalog Error: Table with name _duckdb_append_view_ovfqqzyymc does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_ovfqqzyymc
                                                    ^
  Backtrace:
       █
    1. └─global::expect_backend(b) test_duckdb.R:7:2
    2.   └─b$data(rows = rn, cols = pk, data_format = "data.table")
    3.     └─mlr3db:::.__DataBackendDuckDB__data(...)
    4.       └─mlr3db:::write_temp_table(private$.data, rows)
    5.         ├─DBI::dbWriteTable(...)
    6.         └─DBI::dbWriteTable(...)
    7.           └─duckdb:::.local(conn, name, value, ...)
    8.             ├─DBI::dbExecute(...)
    9.             └─DBI::dbExecute(...)
   10.               ├─DBI::dbSendStatement(conn, statement, ...)
   11.               └─DBI::dbSendStatement(conn, statement, ...)
   12.                 ├─DBI::dbSendQuery(conn, statement, ...)
   13.                 └─duckdb::dbSendQuery(conn, statement, ...)
   14.                   └─duckdb:::.local(conn, statement, ...)
  ── Error (test_duckdb.R:17:3): strings_as_factors ──────────────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_ngmezwimbt
  Error: Catalog Error: Table with name _duckdb_append_view_ngmezwimbt does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_ngmezwimbt
                                                    ^
  Backtrace:
       █
    1. ├─checkmate::expect_character(...) test_duckdb.R:17:2
    2. │ └─checkmate::checkCharacter(...)
    3. │   └─`%and%`(...)
    4. │     └─base::isTRUE(lhs)
    5. └─b$data(b$rownames[1], "Species")
    6.   └─mlr3db:::.__DataBackendDuckDB__data(...)
    7.     └─mlr3db:::write_temp_table(private$.data, rows)
    8.       ├─DBI::dbWriteTable(...)
    9.       └─DBI::dbWriteTable(...)
   10.         └─duckdb:::.local(conn, name, value, ...)
   11.           ├─DBI::dbExecute(...)
   12.           └─DBI::dbExecute(...)
   13.             ├─DBI::dbSendStatement(conn, statement, ...)
   14.             └─DBI::dbSendStatement(conn, statement, ...)
   15.               ├─DBI::dbSendQuery(conn, statement, ...)
   16.               └─duckdb::dbSendQuery(conn, statement, ...)
   17.                 └─duckdb:::.local(conn, statement, ...)
  ── Error (test_duckdb.R:35:3): distinct with NULL rows ─────────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_ltsxnfgfau
  Error: Catalog Error: Table with name _duckdb_append_view_ltsxnfgfau does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_ltsxnfgfau
                                                    ^
  Backtrace:
       █
    1. ├─testthat::expect_equal(...) test_duckdb.R:35:2
    2. │ └─testthat::quasi_label(enquo(expected), expected.label, arg = "expected")
    3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
    4. └─b$distinct(b$rownames, b$colnames)
    5.   └─mlr3db:::.__DataBackendDuckDB__distinct(...)
    6.     └─mlr3db:::write_temp_table(private$.data, rows)
    7.       ├─DBI::dbWriteTable(...)
    8.       └─DBI::dbWriteTable(...)
    9.         └─duckdb:::.local(conn, name, value, ...)
   10.           ├─DBI::dbExecute(...)
   11.           └─DBI::dbExecute(...)
   12.             ├─DBI::dbSendStatement(conn, statement, ...)
   13.             └─DBI::dbSendStatement(conn, statement, ...)
   14.               ├─DBI::dbSendQuery(conn, statement, ...)
   15.               └─duckdb::dbSendQuery(conn, statement, ...)
   16.                 └─duckdb:::.local(conn, statement, ...)
  ── Error (test_reconnect.R:29:3): expectations + duckdb ────────────────────────
  Error: object 'b' not found
  Backtrace:
      █
   1. └─mlr3db:::roundtrip(b) test_reconnect.R:29:2
   2.   └─base::saveRDS(x, path) test_reconnect.R:4:2
  ── Error (test_train_predict_duckdb.R:8:3): single step train + predict ────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_wfvvfgwodf
  Error: Catalog Error: Table with name _duckdb_append_view_wfvvfgwodf does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2764950" SELECT * FROM _duckdb_append_view_wfvvfgwodf
                                                    ^
  Backtrace:
       █
    1. ├─global::expect_learner(learner$train(task, 1:120)) test_train_predict_duckdb.R:8:2
    2. │ └─checkmate::expect_r6(lrn, "Learner", cloneable = TRUE)
    3. │   └─checkmate::checkR6(...)
    4. └─learner$train(task, 1:120)
    5.   └─mlr3:::.__Learner__train(...)
    6.     └─mlr3:::learner_train(self, task, row_ids)
    7.       └─mlr3misc::encapsulate(...)
    8.         ├─mlr3misc::invoke(...)
    9.         │ └─base::eval.parent(expr, n = 1L)
   10.         │   └─base::eval(expr, p)
   11.         │     └─base::eval(expr, p)
   12.         └─mlr3:::.f(learner = <environment>, task = <environment>)
   13.           └─get_private(learner)$.train(task)
   14.             └─mlr3:::.__LearnerClassifFeatureless__.train(...)
   15.               ├─mlr3misc::set_class(...)
   16.               ├─base::table(task$data(cols = tn)[[1L]])
   17.               └─task$data(cols = tn)
   18.                 └─mlr3:::.__TaskClassif__data(...)
   19.                   └─super$data(rows, cols, data_format, ordered)
   20.                     └─mlr3:::.__Task__data(...)
   21.                       └─self$backend$data(rows = rows, cols = query_cols, data_format = data_format)
   22.                         └─mlr3db:::.__DataBackendDuckDB__data(...)
   23.                           └─mlr3db:::write_temp_table(private$.data, rows)
   24.                             ├─DBI::dbWriteTable(...)
   25.                             └─DBI::dbWriteTable(...)
   26.                               └─duckdb:::.local(conn, name, value, ...)
   27.                                 ├─DBI::dbExecute(...)
   28.                                 └─DBI::dbExecute(...)
   29.                                   ├─DBI::dbSendStatement(conn, statement, ...)
   30.                                   └─DBI::dbSendStatement(conn, statement, ...)
   31.                                     ├─DBI::dbSendQuery(conn, statement, ...)
   32.                                     └─duckdb::dbSendQuery(conn, statement, ...)
   33.                                       └─duckdb:::.local(conn, statement, ...)
  ── Error (test_train_predict_duckdb.R:17:3): resample works ────────────────────
  Error: duckdb_prepare_R: Failed to prepare query INSERT INTO "rows_2773063" SELECT * FROM _duckdb_append_view_yyomcqtlyn
  Error: Catalog Error: Table with name _duckdb_append_view_yyomcqtlyn does not exist!
  Did you mean "data"?
  LINE 1: ...SERT INTO "rows_2773063" SELECT * FROM _duckdb_append_view_yyomcqtlyn
                                                    ^
  Backtrace:
       █
    1. ├─global::with_future(...) test_train_predict_duckdb.R:17:2
    2. │ └─base::force(expr)
    3. └─mlr3::resample(task, learner, mlr3::rsmp("cv", folds = 3)) test_train_predict_duckdb.R:18:4
    4.   └─future.apply::future_lapply(...)
    5.     └─future.apply:::future_xapply(...)
    6.       ├─future::value(fs)
    7.       └─future:::value.list(fs)
    8.         ├─future::resolve(...)
    9.         └─future:::resolve.list(...)
   10.           └─future:::signalConditionsASAP(obj, resignal = FALSE, pos = ii)
   11.             └─future:::signalConditions(...)
  
  [ FAIL 9 | WARN 1 | SKIP 0 | PASS 667 ]
  Error: Test failures
  Execution halted