Running 'testthat.R' [36s]
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_99588" SELECT * FROM _duckdb_append_view_pnwykcjwvg
  Error: Catalog Error: Table with name _duckdb_append_view_pnwykcjwvg does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_pnwykcjwvg
                                                 ^
  Backtrace:
       x
    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_99588" SELECT * FROM _duckdb_append_view_xfprtiwvia
  Error: Catalog Error: Table with name _duckdb_append_view_xfprtiwvia does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_xfprtiwvia
                                                 ^
  Backtrace:
       x
    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_99588" SELECT * FROM _duckdb_append_view_emnggsvivm
  Error: Catalog Error: Table with name _duckdb_append_view_emnggsvivm does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_emnggsvivm
                                                 ^
  Backtrace:
       x
    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_99588" SELECT * FROM _duckdb_append_view_qmtkfvdthu
  Error: Catalog Error: Table with name _duckdb_append_view_qmtkfvdthu does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_qmtkfvdthu
                                                 ^
  Backtrace:
       x
    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_99588" SELECT * FROM _duckdb_append_view_xcjmyqddwb
  Error: Catalog Error: Table with name _duckdb_append_view_xcjmyqddwb does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_xcjmyqddwb
                                                 ^
  Backtrace:
       x
    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_99588" SELECT * FROM _duckdb_append_view_rtbaywkaxc
  Error: Catalog Error: Table with name _duckdb_append_view_rtbaywkaxc does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_rtbaywkaxc
                                                 ^
  Backtrace:
       x
    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:
      x
   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_99588" SELECT * FROM _duckdb_append_view_uipylwtkci
  Error: Catalog Error: Table with name _duckdb_append_view_uipylwtkci does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_99588" SELECT * FROM _duckdb_append_view_uipylwtkci
                                                 ^
  Backtrace:
       x
    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_46408" SELECT * FROM _duckdb_append_view_apveuhbhiw
  Error: Catalog Error: Table with name _duckdb_append_view_apveuhbhiw does not exist!
  Did you mean "data"?
  LINE 1: INSERT INTO "rows_46408" SELECT * FROM _duckdb_append_view_apveuhbhiw
                                                 ^
  Backtrace:
       x
    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