Last updated on 2021-03-30 05:48:00 CEST.
Flavor | Version | Tinstall | Tcheck | Ttotal | Status | Flags |
---|---|---|---|---|---|---|
r-devel-linux-x86_64-debian-clang | 0.4.0 | 5.25 | 75.37 | 80.62 | ERROR | |
r-devel-linux-x86_64-debian-gcc | 0.4.0 | 3.70 | 56.75 | 60.45 | ERROR | |
r-devel-linux-x86_64-fedora-clang | 0.4.0 | 99.31 | ERROR | |||
r-devel-linux-x86_64-fedora-gcc | 0.4.0 | 89.67 | ERROR | |||
r-devel-windows-ix86+x86_64 | 0.4.0 | 10.00 | 82.00 | 92.00 | ERROR | |
r-devel-windows-x86_64-gcc10-UCRT | 0.4.0 | ERROR | ||||
r-patched-linux-x86_64 | 0.4.0 | 4.13 | 71.96 | 76.09 | ERROR | |
r-patched-solaris-x86 | 0.4.0 | 147.00 | ERROR | |||
r-release-linux-x86_64 | 0.4.0 | 5.09 | 72.43 | 77.52 | ERROR | |
r-release-macos-x86_64 | 0.4.0 | OK | ||||
r-release-windows-ix86+x86_64 | 0.4.0 | 8.00 | 76.00 | 84.00 | ERROR | |
r-oldrel-macos-x86_64 | 0.4.0 | OK | ||||
r-oldrel-windows-ix86+x86_64 | 0.4.0 | 6.00 | 100.00 | 106.00 | ERROR |
Version: 0.4.0
Check: tests
Result: ERROR
Running 'testthat.R' [33s/54s]
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_4302" SELECT * FROM _duckdb_append_view_tkcvfgzyfy
Error: Catalog Error: Table with name _duckdb_append_view_tkcvfgzyfy does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_tkcvfgzyfy
^
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_4302" SELECT * FROM _duckdb_append_view_pbiotbfdjj
Error: Catalog Error: Table with name _duckdb_append_view_pbiotbfdjj does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_pbiotbfdjj
^
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_4302" SELECT * FROM _duckdb_append_view_tbxcsogbbe
Error: Catalog Error: Table with name _duckdb_append_view_tbxcsogbbe does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_tbxcsogbbe
^
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_4302" SELECT * FROM _duckdb_append_view_lmftiiopwn
Error: Catalog Error: Table with name _duckdb_append_view_lmftiiopwn does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_lmftiiopwn
^
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_4302" SELECT * FROM _duckdb_append_view_frggvrwqnb
Error: Catalog Error: Table with name _duckdb_append_view_frggvrwqnb does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_frggvrwqnb
^
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_4302" SELECT * FROM _duckdb_append_view_wdwsvpqkrz
Error: Catalog Error: Table with name _duckdb_append_view_wdwsvpqkrz does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_wdwsvpqkrz
^
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_4302" SELECT * FROM _duckdb_append_view_jblcwwcawm
Error: Catalog Error: Table with name _duckdb_append_view_jblcwwcawm does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_4302" SELECT * FROM _duckdb_append_view_jblcwwcawm
^
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_16008" SELECT * FROM _duckdb_append_view_xixasgbuiq
Error: Catalog Error: Table with name _duckdb_append_view_xixasgbuiq does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_16008" SELECT * FROM _duckdb_append_view_xixasgbuiq
^
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
Flavor: r-devel-linux-x86_64-debian-clang
Version: 0.4.0
Check: tests
Result: ERROR
Running ‘testthat.R’ [25s/54s]
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_1012" SELECT * FROM _duckdb_append_view_uwujjydojn
Error: Catalog Error: Table with name _duckdb_append_view_uwujjydojn does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_uwujjydojn
^
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_1012" SELECT * FROM _duckdb_append_view_yrawlgpkuq
Error: Catalog Error: Table with name _duckdb_append_view_yrawlgpkuq does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_yrawlgpkuq
^
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_1012" SELECT * FROM _duckdb_append_view_jemshdtmqb
Error: Catalog Error: Table with name _duckdb_append_view_jemshdtmqb does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_jemshdtmqb
^
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_1012" SELECT * FROM _duckdb_append_view_tmkyvxejev
Error: Catalog Error: Table with name _duckdb_append_view_tmkyvxejev does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_tmkyvxejev
^
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_1012" SELECT * FROM _duckdb_append_view_zmfnswnqfo
Error: Catalog Error: Table with name _duckdb_append_view_zmfnswnqfo does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_zmfnswnqfo
^
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_1012" SELECT * FROM _duckdb_append_view_pfrodocjqs
Error: Catalog Error: Table with name _duckdb_append_view_pfrodocjqs does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_pfrodocjqs
^
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_1012" SELECT * FROM _duckdb_append_view_pglmerngef
Error: Catalog Error: Table with name _duckdb_append_view_pglmerngef does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_1012" SELECT * FROM _duckdb_append_view_pglmerngef
^
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_18271" SELECT * FROM _duckdb_append_view_gehqwkdmbm
Error: Catalog Error: Table with name _duckdb_append_view_gehqwkdmbm does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18271" SELECT * FROM _duckdb_append_view_gehqwkdmbm
^
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
Flavor: r-devel-linux-x86_64-debian-gcc
Version: 0.4.0
Check: tests
Result: ERROR
Running ‘testthat.R’ [37s/63s]
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_19354" SELECT * FROM _duckdb_append_view_wsvsbtyiqr
Error: Catalog Error: Table with name _duckdb_append_view_wsvsbtyiqr does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_wsvsbtyiqr
^
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_19354" SELECT * FROM _duckdb_append_view_kjdubdeiav
Error: Catalog Error: Table with name _duckdb_append_view_kjdubdeiav does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_kjdubdeiav
^
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_19354" SELECT * FROM _duckdb_append_view_dvcrukvaur
Error: Catalog Error: Table with name _duckdb_append_view_dvcrukvaur does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_dvcrukvaur
^
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_19354" SELECT * FROM _duckdb_append_view_ialcbtcutb
Error: Catalog Error: Table with name _duckdb_append_view_ialcbtcutb does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_ialcbtcutb
^
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_19354" SELECT * FROM _duckdb_append_view_glvekixqjm
Error: Catalog Error: Table with name _duckdb_append_view_glvekixqjm does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_glvekixqjm
^
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_19354" SELECT * FROM _duckdb_append_view_ejpkkitxdi
Error: Catalog Error: Table with name _duckdb_append_view_ejpkkitxdi does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_ejpkkitxdi
^
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_19354" SELECT * FROM _duckdb_append_view_vcmtzfdrzv
Error: Catalog Error: Table with name _duckdb_append_view_vcmtzfdrzv does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_19354" SELECT * FROM _duckdb_append_view_vcmtzfdrzv
^
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_21366" SELECT * FROM _duckdb_append_view_gkjgklmlds
Error: Catalog Error: Table with name _duckdb_append_view_gkjgklmlds does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_21366" SELECT * FROM _duckdb_append_view_gkjgklmlds
^
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
Flavor: r-devel-linux-x86_64-fedora-clang
Version: 0.4.0
Check: tests
Result: ERROR
Running ‘testthat.R’ [38s/99s]
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_2159915" SELECT * FROM _duckdb_append_view_dplnhifylz
Error: Catalog Error: Table with name _duckdb_append_view_dplnhifylz does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_dplnhifylz
^
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_2159915" SELECT * FROM _duckdb_append_view_xdhraxturp
Error: Catalog Error: Table with name _duckdb_append_view_xdhraxturp does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_xdhraxturp
^
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_2159915" SELECT * FROM _duckdb_append_view_zteibinzdh
Error: Catalog Error: Table with name _duckdb_append_view_zteibinzdh does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_zteibinzdh
^
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_2159915" SELECT * FROM _duckdb_append_view_zjqlrlahnd
Error: Catalog Error: Table with name _duckdb_append_view_zjqlrlahnd does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_zjqlrlahnd
^
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_2159915" SELECT * FROM _duckdb_append_view_vimpmasvsr
Error: Catalog Error: Table with name _duckdb_append_view_vimpmasvsr does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_vimpmasvsr
^
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_2159915" SELECT * FROM _duckdb_append_view_wcfihycgcq
Error: Catalog Error: Table with name _duckdb_append_view_wcfihycgcq does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_wcfihycgcq
^
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_2159915" SELECT * FROM _duckdb_append_view_losyrcseyy
Error: Catalog Error: Table with name _duckdb_append_view_losyrcseyy does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2159915" SELECT * FROM _duckdb_append_view_losyrcseyy
^
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_2169528" SELECT * FROM _duckdb_append_view_wjwlrnogti
Error: Catalog Error: Table with name _duckdb_append_view_wjwlrnogti does not exist!
Did you mean "data"?
LINE 1: ...SERT INTO "rows_2169528" SELECT * FROM _duckdb_append_view_wjwlrnogti
^
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
Flavor: r-devel-linux-x86_64-fedora-gcc
Version: 0.4.0
Check: tests
Result: ERROR
Running 'testthat.R' [37s]
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_65484" SELECT * FROM _duckdb_append_view_fnzpowoblt
Error: Catalog Error: Table with name _duckdb_append_view_fnzpowoblt does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_fnzpowoblt
^
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_65484" SELECT * FROM _duckdb_append_view_yrcdmxiimp
Error: Catalog Error: Table with name _duckdb_append_view_yrcdmxiimp does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_yrcdmxiimp
^
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_65484" SELECT * FROM _duckdb_append_view_rqhxpenity
Error: Catalog Error: Table with name _duckdb_append_view_rqhxpenity does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_rqhxpenity
^
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_65484" SELECT * FROM _duckdb_append_view_nnwtexlpao
Error: Catalog Error: Table with name _duckdb_append_view_nnwtexlpao does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_nnwtexlpao
^
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_65484" SELECT * FROM _duckdb_append_view_nrdluufjgp
Error: Catalog Error: Table with name _duckdb_append_view_nrdluufjgp does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_nrdluufjgp
^
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_65484" SELECT * FROM _duckdb_append_view_yzuahbmull
Error: Catalog Error: Table with name _duckdb_append_view_yzuahbmull does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_yzuahbmull
^
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_65484" SELECT * FROM _duckdb_append_view_nuvlnrkaqz
Error: Catalog Error: Table with name _duckdb_append_view_nuvlnrkaqz does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_65484" SELECT * FROM _duckdb_append_view_nuvlnrkaqz
^
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_49820" SELECT * FROM _duckdb_append_view_nzvxpbwlra
Error: Catalog Error: Table with name _duckdb_append_view_nzvxpbwlra does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_49820" SELECT * FROM _duckdb_append_view_nzvxpbwlra
^
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
In addition: Warning message:
In duckdb_shutdown(conn@driver) : invalid driver object, already closed?
Execution halted
Flavor: r-devel-windows-ix86+x86_64
Version: 0.4.0
Check: tests
Result: ERROR
Running 'testthat.R'
Running the tests in 'tests/testthat.R' failed.
Last 13 lines of output:
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
In addition: Warning message:
In duckdb_shutdown(conn@driver) : invalid driver object, already closed?
Execution halted
Flavor: r-devel-windows-x86_64-gcc10-UCRT
Version: 0.4.0
Check: tests
Result: ERROR
Running ‘testthat.R’ [33s/50s]
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_29753" SELECT * FROM _duckdb_append_view_otmjhlzwkl
Error: Catalog Error: Table with name _duckdb_append_view_otmjhlzwkl does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_otmjhlzwkl
^
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_29753" SELECT * FROM _duckdb_append_view_rcokgcbchn
Error: Catalog Error: Table with name _duckdb_append_view_rcokgcbchn does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_rcokgcbchn
^
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_29753" SELECT * FROM _duckdb_append_view_vfvgqebidh
Error: Catalog Error: Table with name _duckdb_append_view_vfvgqebidh does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_vfvgqebidh
^
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_29753" SELECT * FROM _duckdb_append_view_gxogwmwuvj
Error: Catalog Error: Table with name _duckdb_append_view_gxogwmwuvj does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_gxogwmwuvj
^
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_29753" SELECT * FROM _duckdb_append_view_koeujfzred
Error: Catalog Error: Table with name _duckdb_append_view_koeujfzred does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_koeujfzred
^
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_29753" SELECT * FROM _duckdb_append_view_axlpuckosg
Error: Catalog Error: Table with name _duckdb_append_view_axlpuckosg does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_axlpuckosg
^
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_29753" SELECT * FROM _duckdb_append_view_qdijlhchqr
Error: Catalog Error: Table with name _duckdb_append_view_qdijlhchqr does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29753" SELECT * FROM _duckdb_append_view_qdijlhchqr
^
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_9332" SELECT * FROM _duckdb_append_view_heldrsbehr
Error: Catalog Error: Table with name _duckdb_append_view_heldrsbehr does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_9332" SELECT * FROM _duckdb_append_view_heldrsbehr
^
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
Flavor: r-patched-linux-x86_64
Version: 0.4.0
Check: tests
Result: ERROR
Running ‘testthat.R’ [65s/83s]
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_3320" SELECT * FROM _duckdb_append_view_umqdujbmcc
Error: Catalog Error: Table with name _duckdb_append_view_umqdujbmcc does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_umqdujbmcc
^
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_3320" SELECT * FROM _duckdb_append_view_hbechauoko
Error: Catalog Error: Table with name _duckdb_append_view_hbechauoko does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_hbechauoko
^
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_3320" SELECT * FROM _duckdb_append_view_kvcoktxjtq
Error: Catalog Error: Table with name _duckdb_append_view_kvcoktxjtq does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_kvcoktxjtq
^
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_3320" SELECT * FROM _duckdb_append_view_urbdcdbvyo
Error: Catalog Error: Table with name _duckdb_append_view_urbdcdbvyo does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_urbdcdbvyo
^
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_3320" SELECT * FROM _duckdb_append_view_lyvymxjjnh
Error: Catalog Error: Table with name _duckdb_append_view_lyvymxjjnh does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_lyvymxjjnh
^
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_3320" SELECT * FROM _duckdb_append_view_uibqmdlpiw
Error: Catalog Error: Table with name _duckdb_append_view_uibqmdlpiw does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_uibqmdlpiw
^
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_3320" SELECT * FROM _duckdb_append_view_eujshgcupa
Error: Catalog Error: Table with name _duckdb_append_view_eujshgcupa does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_3320" SELECT * FROM _duckdb_append_view_eujshgcupa
^
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_6898" SELECT * FROM _duckdb_append_view_iqhdgacord
Error: Catalog Error: Table with name _duckdb_append_view_iqhdgacord does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_6898" SELECT * FROM _duckdb_append_view_iqhdgacord
^
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
Flavor: r-patched-solaris-x86
Version: 0.4.0
Check: tests
Result: ERROR
Running ‘testthat.R’ [33s/50s]
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_18094" SELECT * FROM _duckdb_append_view_kkwporgbqo
Error: Catalog Error: Table with name _duckdb_append_view_kkwporgbqo does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_kkwporgbqo
^
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_18094" SELECT * FROM _duckdb_append_view_btsftrjayl
Error: Catalog Error: Table with name _duckdb_append_view_btsftrjayl does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_btsftrjayl
^
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_18094" SELECT * FROM _duckdb_append_view_ywnrvjlcfd
Error: Catalog Error: Table with name _duckdb_append_view_ywnrvjlcfd does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_ywnrvjlcfd
^
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_18094" SELECT * FROM _duckdb_append_view_rqtbgmmmiz
Error: Catalog Error: Table with name _duckdb_append_view_rqtbgmmmiz does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_rqtbgmmmiz
^
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_18094" SELECT * FROM _duckdb_append_view_rzlyhfvfdj
Error: Catalog Error: Table with name _duckdb_append_view_rzlyhfvfdj does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_rzlyhfvfdj
^
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_18094" SELECT * FROM _duckdb_append_view_rnmwidczob
Error: Catalog Error: Table with name _duckdb_append_view_rnmwidczob does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_rnmwidczob
^
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_18094" SELECT * FROM _duckdb_append_view_kzhyrxnsos
Error: Catalog Error: Table with name _duckdb_append_view_kzhyrxnsos does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_18094" SELECT * FROM _duckdb_append_view_kzhyrxnsos
^
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_29787" SELECT * FROM _duckdb_append_view_brsecwtekm
Error: Catalog Error: Table with name _duckdb_append_view_brsecwtekm does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_29787" SELECT * FROM _duckdb_append_view_brsecwtekm
^
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
Flavor: r-release-linux-x86_64
Version: 0.4.0
Check: tests
Result: ERROR
Running 'testthat.R' [33s]
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_38496" SELECT * FROM _duckdb_append_view_voebvptcjy
Error: Catalog Error: Table with name _duckdb_append_view_voebvptcjy does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_voebvptcjy
^
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_38496" SELECT * FROM _duckdb_append_view_ckgzjgobuy
Error: Catalog Error: Table with name _duckdb_append_view_ckgzjgobuy does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_ckgzjgobuy
^
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_38496" SELECT * FROM _duckdb_append_view_rwwrjwfkjk
Error: Catalog Error: Table with name _duckdb_append_view_rwwrjwfkjk does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_rwwrjwfkjk
^
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_38496" SELECT * FROM _duckdb_append_view_jwomwfrtcy
Error: Catalog Error: Table with name _duckdb_append_view_jwomwfrtcy does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_jwomwfrtcy
^
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_38496" SELECT * FROM _duckdb_append_view_ipzhquapgr
Error: Catalog Error: Table with name _duckdb_append_view_ipzhquapgr does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_ipzhquapgr
^
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_38496" SELECT * FROM _duckdb_append_view_xptzandmmz
Error: Catalog Error: Table with name _duckdb_append_view_xptzandmmz does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_xptzandmmz
^
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_38496" SELECT * FROM _duckdb_append_view_atfpwktlah
Error: Catalog Error: Table with name _duckdb_append_view_atfpwktlah does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_38496" SELECT * FROM _duckdb_append_view_atfpwktlah
^
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_87320" SELECT * FROM _duckdb_append_view_xwtoaqizqp
Error: Catalog Error: Table with name _duckdb_append_view_xwtoaqizqp does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_87320" SELECT * FROM _duckdb_append_view_xwtoaqizqp
^
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
In addition: Warning message:
In duckdb_shutdown(conn@driver) : invalid driver object, already closed?
Execution halted
Flavor: r-release-windows-ix86+x86_64
Version: 0.4.0
Check: tests
Result: ERROR
Running 'testthat.R' [45s]
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_69424" SELECT * FROM _duckdb_append_view_izfxdbtixd
Error: Catalog Error: Table with name _duckdb_append_view_izfxdbtixd does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_izfxdbtixd
^
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_69424" SELECT * FROM _duckdb_append_view_xqrvgtgoxv
Error: Catalog Error: Table with name _duckdb_append_view_xqrvgtgoxv does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_xqrvgtgoxv
^
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_69424" SELECT * FROM _duckdb_append_view_zftxnwhife
Error: Catalog Error: Table with name _duckdb_append_view_zftxnwhife does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_zftxnwhife
^
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_69424" SELECT * FROM _duckdb_append_view_ordbqfomwd
Error: Catalog Error: Table with name _duckdb_append_view_ordbqfomwd does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_ordbqfomwd
^
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_69424" SELECT * FROM _duckdb_append_view_mxhsmntcfr
Error: Catalog Error: Table with name _duckdb_append_view_mxhsmntcfr does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_mxhsmntcfr
^
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_69424" SELECT * FROM _duckdb_append_view_mvmtvlhvqv
Error: Catalog Error: Table with name _duckdb_append_view_mvmtvlhvqv does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_mvmtvlhvqv
^
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_69424" SELECT * FROM _duckdb_append_view_yijonzksvl
Error: Catalog Error: Table with name _duckdb_append_view_yijonzksvl does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_69424" SELECT * FROM _duckdb_append_view_yijonzksvl
^
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_95564" SELECT * FROM _duckdb_append_view_nrsljichvz
Error: Catalog Error: Table with name _duckdb_append_view_nrsljichvz does not exist!
Did you mean "data"?
LINE 1: INSERT INTO "rows_95564" SELECT * FROM _duckdb_append_view_nrsljichvz
^
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
Flavor: r-oldrel-windows-ix86+x86_64