Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Disable failing DuckDB-related test-cases on Big-endian platforms (indices and sorting are broken in DuckDB upstream) #2211

Open
barracuda156 opened this issue Apr 17, 2024 · 0 comments

Comments

@barracuda156
Copy link

Maybe disable select duckdb-related tests on BE platforms due to needed functionality in DuckDB being broken? duckdb/duckdb#9714
Until it is fixed, hopefully.


R version 4.3.3 (2024-02-29) -- "Angel Food Cake"
Copyright (C) 2024 The R Foundation for Statistical Computing
Platform: powerpc-apple-darwin10.0.0d2 (32-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library(testthat)
> 
> # Need to use qualified call, this is checked in helper-print.R
> testthat::test_check("dm")
Loading required package: dm

Attaching package: 'dm'

The following object is masked from 'package:stats':

    filter

Starting 2 test processes
Superclass process has cloneable=FALSE, but subclass r_session has cloneable=TRUE. A subclass cannot be cloneable when its superclass is not cloneable, so cloning will be disabled for r_session.
Superclass process has cloneable=FALSE, but subclass r_session has cloneable=TRUE. A subclass cannot be cloneable when its superclass is not cloneable, so cloning will be disabled for r_session.
[ FAIL 13 | WARN 8 | SKIP 239 | PASS 1341 ]

══ Skipped tests (239) ═════════════════════════════════════════════════════════
• COMPOUND (1): 'test-rows-dm.R:203:3'
• Dependent on database version, find better way to record this info (1):
  'test-meta.R:19:3'
• DiagrammeRsvg cannot be loaded (3): 'test-draw-dm.R:117:3',
  'test-draw-dm.R:153:3', 'test-draw-dm.R:182:3'
• FIXME (2): 'test-learn.R:155:3', 'test-nest.R:2:3'
• FIXME: Unstable on GHA? (1): 'test-dm.R:495:3'
• Need to think about it (1): 'test-key-helpers.R:45:3'
• On CRAN (183): 'test-zzx-deprecated.R:2:3', 'test-zzx-deprecated.R:15:3',
  'test-zzx-deprecated.R:25:3', 'test-zzx-deprecated.R:35:3',
  'test-zzx-deprecated.R:45:3', 'test-zzx-deprecated.R:58:3',
  'test-zzx-deprecated.R:81:3', 'test-zzx-deprecated.R:91:3',
  'test-zzx-deprecated.R:106:3', 'test-zzx-deprecated.R:121:3',
  'test-zzx-deprecated.R:141:3', 'test-zzx-deprecated.R:151:3',
  'test-zzx-deprecated.R:166:3', 'test-zzx-deprecated.R:185:3',
  'test-zzx-deprecated.R:221:3', 'test-zzx-deprecated.R:255:3',
  'test-zzx-deprecated.R:275:3', 'test-zzx-deprecated.R:291:3',
  'test-zzx-deprecated.R:326:3', 'test-zzx-deprecated.R:341:3',
  'test-zzx-deprecated.R:356:3', 'test-flatten.R:18:3', 'test-flatten.R:99:3',
  'test-dplyr.R:347:3', 'test-dplyr.R:506:3', 'test-dplyr.R:545:3',
  'test-dplyr.R:558:3', 'test-dplyr.R:569:3', 'test-dplyr.R:598:3',
  'test-dplyr.R:614:3', 'test-dplyr.R:806:3', 'test-draw-dm.R:17:3',
  'test-draw-dm.R:104:3', 'test-filter-dm.R:62:3', 'test-filter-dm.R:173:3',
  'test-filter-dm.R:182:3', 'test-filter-dm.R:191:3', 'test-filter-dm.R:241:3',
  'test-bind.R:42:3', 'test-bind.R:97:3', 'test-bind.R:107:3',
  'test-bind.R:125:3', 'test-learn.R:445:3', 'test-add-tbl.R:92:3',
  'test-add-tbl.R:137:3', 'test-autoincrement.R:17:3',
  'test-autoincrement.R:26:3', 'test-build_copy_queries.R:33:3',
  'test-build_copy_queries.R:76:3', 'test-rows-dm.R:2:3',
  'test-rows-dm.R:28:3', 'test-rows-dm.R:390:3', 'test-code-generation.R:7:3',
  'test-datamodelr-code.R:4:3', 'test-datamodelr-code.R:17:3',
  'test-datamodelr-code.R:37:3', 'test-datamodelr-code.R:57:3',
  'test-datamodelr-code.R:78:3', 'test-datamodelr-code.R:99:3',
  'test-datamodelr-code.R:120:3', 'test-datamodelr-code.R:133:3',
  'test-check-cardinalities.R:30:3', 'test-check-cardinalities.R:289:3',
  'test-check-cardinalities.R:337:3', 'test-check-cardinalities.R:422:3',
  'test-db-interface.R:35:3', 'test-disambiguate.R:2:3',
  'test-disentangle.R:2:3', 'test-dm.R:2:3', 'test-dm.R:70:3',
  'test-dm.R:108:3', 'test-dm.R:148:3', 'test-dm.R:194:3', 'test-dm.R:202:3',
  'test-dm.R:211:3', 'test-dm.R:217:3', 'test-dm.R:223:3', 'test-dm.R:311:3',
  'test-dm.R:508:3', 'test-dm.R:534:3', 'test-dm.R:564:3', 'test-dm.R:598:3',
  'test-dm_deconstruct.R:2:3', 'test-dm_deconstruct.R:9:3',
  'test-dm_nest_tbl.R:17:3', 'test-deconstruct.R:6:3',
  'test-deconstruct.R:16:3', 'test-deconstruct.R:26:3',
  'test-deconstruct.R:55:3', 'test-deconstruct.R:72:3',
  'test-deconstruct.R:120:3', 'test-deconstruct.R:144:3',
  'test-deconstruct.R:160:3', 'test-deconstruct.R:181:3',
  'test-deconstruct.R:198:3', 'test-deconstruct.R:222:3',
  'test-deconstruct.R:246:3', 'test-deconstruct.R:270:3',
  'test-deconstruct.R:294:3', 'test-deconstruct.R:320:3',
  'test-deconstruct.R:346:3', 'test-deconstruct.R:372:3',
  'test-deconstruct.R:398:3', 'test-deconstruct.R:420:3',
  'test-deconstruct.R:479:3', 'test-deconstruct.R:492:3',
  'test-deconstruct.R:507:3', 'test-deconstruct.R:525:3',
  'test-deconstruct.R:572:3', 'test-deconstruct.R:586:3',
  'test-deconstruct.R:599:3', 'test-dm_sql.R:4:3', 'test-duckdb.R:2:3',
  'test-enum-ops.R:11:3', 'test-enum-ops.R:30:3', 'test-enum-ops.R:103:3',
  'test-enum-ops.R:176:3', 'test-enumerate_all_paths.R:2:3',
  'test-dm_wrap.R:12:3', 'test-dm_wrap.R:79:3', 'test-error-helpers.R:2:3',
  'test-examine-cardinalities.R:2:3', 'test-examine-cardinalities.R:16:3',
  'test-examine-cardinalities.R:23:3', 'test-examine-constraints.R:68:3',
  'test-examine-constraints.R:77:3', 'test-examine-constraints.R:87:3',
  'test-examine-constraints.R:94:3', 'test-format.R:2:3', 'test-graph.R:29:3',
  'test-graph.R:38:3', 'test-json.R:5:3', 'test-json_nest.R:2:3',
  'test-json_pack.R:2:3', 'test-foreign-keys.R:16:3',
  'test-foreign-keys.R:145:3', 'test-foreign-keys.R:252:3',
  'test-foreign-keys.R:260:3', 'test-foreign-keys.R:287:3', 'test-maria.R:2:3',
  'test-meta.R:3:3', 'test-mssql.R:2:3', 'test-pack_join.R:5:3',
  'test-key-helpers.R:4:3', 'test-key-helpers.R:327:3',
  'test-key-helpers.R:333:3', 'test-key-helpers.R:342:3',
  'test-key-helpers.R:350:3', 'test-postgres.R:2:3', 'test-paste.R:10:3',
  'test-paste.R:93:3', 'test-select-tbl.R:30:3', 'test-primary-keys.R:25:3',
  'test-primary-keys.R:94:3', 'test-primary-keys.R:178:3',
  'test-primary-keys.R:198:3', 'test-primary-keys.R:229:3',
  'test-primary-keys.R:246:3', 'test-primary-keys.R:253:3',
  'test-select.R:2:3', 'test-select.R:10:3', 'test-select.R:18:3',
  'test-select.R:47:3', 'test-select.R:88:3', 'test-sqlite.R:2:3',
  'test-standalone-check_suggested.R:3:3',
  'test-standalone-check_suggested.R:17:3', 'test-tidyr.R:54:3',
  'test-tidyr.R:92:3', 'test-unique-keys.R:2:3', 'test-unique-keys.R:175:3',
  'test-upgrade.R:3:3', 'test-upgrade.R:15:3', 'test-upgrade.R:26:3',
  'test-upgrade.R:42:3', 'test-upgrade.R:53:3', 'test-upgrade.R:72:3',
  'test-upgrade.R:86:3', 'test-upgrade.R:102:3', 'test-upgrade.R:116:3',
  'test-waldo.R:8:3', 'test-zoom.R:30:3', 'test-zoom.R:133:3'
• Slow test. To run, set CI=true (6): 'test-db-interface.R:7:3',
  'test-dplyr-src.R:49:3', 'test-examine-constraints.R:34:3',
  'test-examine-constraints.R:52:3', 'test-foreign-keys.R:180:3',
  'test-primary-keys.R:158:3'
• `dm_pixarfilms()` needs the "pixarfilms" package. (2):
  'test-build_copy_queries.R:5:3', 'test-dm_pixarfilms.R:2:3'
• `foo()` needs the "iurtnkjvmomweicopbt" package. (1):
  'test-standalone-check_suggested.R:30:3'
• dm argument (1): 'test-select-tbl.R:71:3'
• does not work on `df` (1): 'test-validate.R:201:3'
• keyed = TRUE (1): 'test-deconstruct.R:91:3'
• not testing deprecated cdm_nycflights13(): test too slow (1):
  'test-zzx-deprecated.R:266:3'
• not testing deprecated learning from DB: test too slow (1):
  'test-zzx-deprecated.R:236:3'
• only works on `db` (1): 'test-filter-dm.R:47:3'
• only works on `duckdb` (2): 'test-duckdb.R:9:3', 'test-duckdb.R:32:3'
• only works on `maria` (2): 'test-maria.R:9:3', 'test-maria.R:32:3'
• only works on `mssql` (6): 'test-learn.R:207:3', 'test-learn.R:283:3',
  'test-db-helpers.R:2:3', 'test-mssql.R:9:3', 'test-mssql.R:32:3',
  'test-schema.R:129:3'
• only works on `mssql`, `postgres` (4): 'test-db-interface.R:81:3',
  'test-db-interface.R:94:3', 'test-db-interface.R:125:3', 'test-schema.R:2:3'
• only works on `mssql`, `postgres`, `maria` (4): 'test-learn.R:2:3',
  'test-learn.R:70:3', 'test-learn.R:365:3', 'test-meta.R:9:3'
• only works on `postgres` (4): 'test-db-helpers.R:108:3',
  'test-postgres.R:9:3', 'test-postgres.R:32:3', 'test-schema.R:99:3'
• only works on `postgres`, `mssql` (2): 'test-json_nest.R:14:3',
  'test-json_pack.R:13:3'
• only works on `postgres`, `mssql`, `sqlite` (1): 'test-rows-dm.R:221:3'
• only works on `postgres`, `sqlite`, `mssql`, `maria` (1):
  'test-db-interface.R:183:3'
• only works on `sqlite` (3): 'test-schema.R:201:3', 'test-sqlite.R:9:3',
  'test-sqlite.R:32:3'
• packageVersion("tidyselect") > "1.2.0" is TRUE (3):
  'test-foreign-keys.R:304:3', 'test-primary-keys.R:215:3',
  'test-tidyselect.R:23:3'

══ Failed tests ════════════════════════════════════════════════════════════════
── Error ('test-bind.R:51:3'): errors: src mismatches ──────────────────────────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─dm:::expect_dm_error(...) at test-bind.R:51:3
  2. │ └─testthat::expect_error(expr, class = dm_error(class)) at tests/testthat/helper-expectations.R:48:3
  3. │   └─testthat:::expect_condition_matching(...)
  4. │     └─testthat:::quasi_capture(...)
  5. │       ├─testthat (local) .capture(...)
  6. │       │ └─base::withCallingHandlers(...)
  7. │       └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
  8. ├─dm::dm_bind(dm_for_flatten(), dm_for_filter_duckdb())
  9. │ └─rlang::list2(...)
 10. ├─dm:::dm_for_filter_duckdb()
 11. ├─dm::copy_dm_to(duckdb_test_src(), dm_for_filter()) at tests/testthat/helper-src.R:26:7
 12. │ └─purrr::walk(...)
 13. │   └─purrr::map(.x, .f, ..., .progress = .progress)
 14. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
 15. │       ├─purrr:::with_indexed_errors(...)
 16. │       │ └─base::withCallingHandlers(...)
 17. │       ├─purrr:::call_with_cleanup(...)
 18. │       └─dm (local) .f(.x[[i]], ...)
 19. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 20. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 21. │           ├─DBI::dbSendStatement(conn, statement, ...)
 22. │           └─DBI::dbSendStatement(conn, statement, ...)
 23. │             ├─DBI::dbSendQuery(conn, statement, ...)
 24. │             └─duckdb::dbSendQuery(conn, statement, ...)
 25. │               └─duckdb (local) .local(conn, statement, ...)
 26. │                 └─duckdb:::duckdb_result(...)
 27. │                   └─duckdb:::duckdb_execute(res)
 28. │                     └─duckdb:::rapi_execute(...)
 29. └─base::.handleSimpleError(...)
 30.   └─purrr (local) h(simpleError(msg, call))
 31.     └─cli::cli_abort(...)
 32.       └─rlang::abort(...)
── Error ('test-rows-dm.R:98:3'): dm_rows_update() ─────────────────────────────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─base::suppressMessages(copy_dm_to(my_db_test_src(), dm_filter_rearranged)) at test-rows-dm.R:98:3
  2. │ └─base::withCallingHandlers(...)
  3. ├─dm::copy_dm_to(my_db_test_src(), dm_filter_rearranged)
  4. │ └─purrr::walk(...)
  5. │   └─purrr::map(.x, .f, ..., .progress = .progress)
  6. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
  7. │       ├─purrr:::with_indexed_errors(...)
  8. │       │ └─base::withCallingHandlers(...)
  9. │       ├─purrr:::call_with_cleanup(...)
 10. │       └─dm (local) .f(.x[[i]], ...)
 11. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 12. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 13. │           ├─DBI::dbSendStatement(conn, statement, ...)
 14. │           └─DBI::dbSendStatement(conn, statement, ...)
 15. │             ├─DBI::dbSendQuery(conn, statement, ...)
 16. │             └─duckdb::dbSendQuery(conn, statement, ...)
 17. │               └─duckdb (local) .local(conn, statement, ...)
 18. │                 └─duckdb:::duckdb_result(...)
 19. │                   └─duckdb:::duckdb_execute(res)
 20. │                     └─duckdb:::rapi_execute(...)
 21. └─base::.handleSimpleError(...)
 22.   └─purrr (local) h(simpleError(msg, call))
 23.     └─cli::cli_abort(...)
 24.       └─rlang::abort(...)
── Error ('test-rows-dm.R:152:3'): dm_rows_truncate() ──────────────────────────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─base::suppressMessages(...) at test-rows-dm.R:152:3
  2. │ └─base::withCallingHandlers(...)
  3. ├─dm::copy_dm_to(my_db_test_src(), dm_for_filter())
  4. │ └─purrr::walk(...)
  5. │   └─purrr::map(.x, .f, ..., .progress = .progress)
  6. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
  7. │       ├─purrr:::with_indexed_errors(...)
  8. │       │ └─base::withCallingHandlers(...)
  9. │       ├─purrr:::call_with_cleanup(...)
 10. │       └─dm (local) .f(.x[[i]], ...)
 11. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 12. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 13. │           ├─DBI::dbSendStatement(conn, statement, ...)
 14. │           └─DBI::dbSendStatement(conn, statement, ...)
 15. │             ├─DBI::dbSendQuery(conn, statement, ...)
 16. │             └─duckdb::dbSendQuery(conn, statement, ...)
 17. │               └─duckdb (local) .local(conn, statement, ...)
 18. │                 └─duckdb:::duckdb_result(...)
 19. │                   └─duckdb:::duckdb_execute(res)
 20. │                     └─duckdb:::rapi_execute(...)
 21. └─base::.handleSimpleError(...)
 22.   └─purrr (local) h(simpleError(msg, call))
 23.     └─cli::cli_abort(...)
 24.       └─rlang::abort(...)
── Error ('test-db-helpers.R:199:3'): DB helpers work for other DBMS than MSSQL or Postgres ──
Error: rapi_execute: Failed to run query
Error: Not implemented Error: Sorting is not supported on big endian architectures
Backtrace:
     ▆
  1. ├─dm:::expect_dm_warning(...) at test-db-helpers.R:199:3
  2. │ └─testthat::expect_warning(out <- expr, class = dm_warning(class)) at tests/testthat/helper-expectations.R:52:3
  3. │   └─testthat:::expect_condition_matching(...)
  4. │     └─testthat:::quasi_capture(...)
  5. │       ├─testthat (local) .capture(...)
  6. │       │ └─base::withCallingHandlers(...)
  7. │       └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
  8. ├─dm:::expect_dm_warning(...)
  9. │ └─testthat::expect_warning(out <- expr, class = dm_warning(class)) at tests/testthat/helper-expectations.R:52:3
 10. │   └─testthat:::expect_condition_matching(...)
 11. │     └─testthat:::quasi_capture(...)
 12. │       ├─testthat (local) .capture(...)
 13. │       │ └─base::withCallingHandlers(...)
 14. │       └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
 15. ├─testthat::expect_true(...)
 16. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
 17. │   └─rlang::eval_bare(expr, quo_get_env(quo))
 18. ├─"test_db_helpers" %in% ...
 19. └─dm:::get_src_tbl_names(my_db_test_src(), schema = "schema", dbname = "dbname")
 20.   ├─dplyr::src_tbls(src)
 21.   └─dbplyr:::src_tbls.src_sql(src)
 22.     ├─DBI::dbListTables(x$con)
 23.     └─duckdb::dbListTables(x$con)
 24.       ├─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 25.       └─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 26.         └─DBI (local) .local(conn, statement, ...)
 27.           ├─DBI::dbSendQuery(conn, statement, ...)
 28.           └─duckdb::dbSendQuery(conn, statement, ...)
 29.             └─duckdb (local) .local(conn, statement, ...)
 30.               └─duckdb:::duckdb_result(...)
 31.                 └─duckdb:::duckdb_execute(res)
 32.                   └─duckdb:::rapi_execute(...)
── Error ('test-dm.R:273:3'): 'compute.dm()' computes tables on DB ─────────────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─... %>% dm_get_def() at test-dm.R:273:3
  2. ├─dm:::dm_get_def(.)
  3. │ └─dm:::check_dm(x)
  4. │   └─dm::is_dm(x)
  5. ├─dm::dm_filter(., tf_1 = a > 3)
  6. │ └─dm:::dm_filter_api0(...)
  7. │   └─dm:::dm_filter_api1(...)
  8. │     └─purrr::reduce2(...)
  9. │       └─purrr:::reduce2_impl(.x, .y, .f, ..., .init = .init, .left = TRUE)
 10. │         └─purrr:::reduce_init(.x, .init, left = .left, error_call = .purrr_error_call)
 11. ├─dm:::dm_for_filter_duckdb()
 12. ├─dm::copy_dm_to(duckdb_test_src(), dm_for_filter()) at tests/testthat/helper-src.R:26:7
 13. │ └─purrr::walk(...)
 14. │   └─purrr::map(.x, .f, ..., .progress = .progress)
 15. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
 16. │       ├─purrr:::with_indexed_errors(...)
 17. │       │ └─base::withCallingHandlers(...)
 18. │       ├─purrr:::call_with_cleanup(...)
 19. │       └─dm (local) .f(.x[[i]], ...)
 20. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 21. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 22. │           ├─DBI::dbSendStatement(conn, statement, ...)
 23. │           └─DBI::dbSendStatement(conn, statement, ...)
 24. │             ├─DBI::dbSendQuery(conn, statement, ...)
 25. │             └─duckdb::dbSendQuery(conn, statement, ...)
 26. │               └─duckdb (local) .local(conn, statement, ...)
 27. │                 └─duckdb:::duckdb_result(...)
 28. │                   └─duckdb:::duckdb_execute(res)
 29. │                     └─duckdb:::rapi_execute(...)
 30. └─base::.handleSimpleError(...)
 31.   └─purrr (local) h(simpleError(msg, call))
 32.     └─cli::cli_abort(...)
 33.       └─rlang::abort(...)
── Error ('test-dm.R:286:3'): 'compute.dm_zoomed()' computes tables on DB ──────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─dm_for_filter_duckdb() %>% dm_zoom_to(tf_1) %>% ... at test-dm.R:286:3
  2. ├─dplyr::mutate(., c = a + 1)
  3. ├─dm::dm_zoom_to(., tf_1)
  4. │ └─dm:::check_not_zoomed(dm)
  5. │   └─dm:::check_dm(dm)
  6. │     └─dm::is_dm(x)
  7. ├─dm:::dm_for_filter_duckdb()
  8. ├─dm::copy_dm_to(duckdb_test_src(), dm_for_filter()) at tests/testthat/helper-src.R:26:7
  9. │ └─purrr::walk(...)
 10. │   └─purrr::map(.x, .f, ..., .progress = .progress)
 11. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
 12. │       ├─purrr:::with_indexed_errors(...)
 13. │       │ └─base::withCallingHandlers(...)
 14. │       ├─purrr:::call_with_cleanup(...)
 15. │       └─dm (local) .f(.x[[i]], ...)
 16. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 17. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 18. │           ├─DBI::dbSendStatement(conn, statement, ...)
 19. │           └─DBI::dbSendStatement(conn, statement, ...)
 20. │             ├─DBI::dbSendQuery(conn, statement, ...)
 21. │             └─duckdb::dbSendQuery(conn, statement, ...)
 22. │               └─duckdb (local) .local(conn, statement, ...)
 23. │                 └─duckdb:::duckdb_result(...)
 24. │                   └─duckdb:::duckdb_execute(res)
 25. │                     └─duckdb:::rapi_execute(...)
 26. └─base::.handleSimpleError(...)
 27.   └─purrr (local) h(simpleError(msg, call))
 28.     └─cli::cli_abort(...)
 29.       └─rlang::abort(...)
── Error ('test-dm.R:487:3'): dm_get_con() works ───────────────────────────────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─testthat::expect_identical(dm_get_con(dm_for_filter_db()), con_from_src_or_con(my_db_test_src())) at test-dm.R:487:3
  2. │ └─testthat::quasi_label(enquo(object), label, arg = "object")
  3. │   └─rlang::eval_bare(expr, quo_get_env(quo))
  4. ├─dm::dm_get_con(dm_for_filter_db())
  5. │ └─dm:::check_not_zoomed(dm)
  6. │   └─dm:::check_dm(dm)
  7. │     └─dm::is_dm(x)
  8. ├─dm:::dm_for_filter_db()
  9. ├─dm::copy_dm_to(my_db_test_src(), dm_for_filter()) at tests/testthat/helper-src.R:337:3
 10. │ └─purrr::walk(...)
 11. │   └─purrr::map(.x, .f, ..., .progress = .progress)
 12. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
 13. │       ├─purrr:::with_indexed_errors(...)
 14. │       │ └─base::withCallingHandlers(...)
 15. │       ├─purrr:::call_with_cleanup(...)
 16. │       └─dm (local) .f(.x[[i]], ...)
 17. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 18. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 19. │           ├─DBI::dbSendStatement(conn, statement, ...)
 20. │           └─DBI::dbSendStatement(conn, statement, ...)
 21. │             ├─DBI::dbSendQuery(conn, statement, ...)
 22. │             └─duckdb::dbSendQuery(conn, statement, ...)
 23. │               └─duckdb (local) .local(conn, statement, ...)
 24. │                 └─duckdb:::duckdb_result(...)
 25. │                   └─duckdb:::duckdb_execute(res)
 26. │                     └─duckdb:::rapi_execute(...)
 27. └─base::.handleSimpleError(...)
 28.   └─purrr (local) h(simpleError(msg, call))
 29.     └─cli::cli_abort(...)
 30.       └─rlang::abort(...)
── Error ('test-nest.R:41:3'): 'nest_join_dm_zoomed()' fails for DB-'dm' ───────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─dm:::expect_dm_error(...) at test-nest.R:41:3
  2. │ └─testthat::expect_error(expr, class = dm_error(class)) at tests/testthat/helper-expectations.R:48:3
  3. │   └─testthat:::expect_condition_matching(...)
  4. │     └─testthat:::quasi_capture(...)
  5. │       ├─testthat (local) .capture(...)
  6. │       │ └─base::withCallingHandlers(...)
  7. │       └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
  8. ├─dm_zoom_to(dm_for_filter_duckdb(), tf_3) %>% ...
  9. ├─dm:::nest_join_dm_zoomed(.)
 10. ├─dm::dm_zoom_to(dm_for_filter_duckdb(), tf_3)
 11. │ └─dm:::check_not_zoomed(dm)
 12. │   └─dm:::check_dm(dm)
 13. │     └─dm::is_dm(x)
 14. ├─dm:::dm_for_filter_duckdb()
 15. ├─dm::copy_dm_to(duckdb_test_src(), dm_for_filter()) at tests/testthat/helper-src.R:26:7
 16. │ └─purrr::walk(...)
 17. │   └─purrr::map(.x, .f, ..., .progress = .progress)
 18. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
 19. │       ├─purrr:::with_indexed_errors(...)
 20. │       │ └─base::withCallingHandlers(...)
 21. │       ├─purrr:::call_with_cleanup(...)
 22. │       └─dm (local) .f(.x[[i]], ...)
 23. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 24. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 25. │           ├─DBI::dbSendStatement(conn, statement, ...)
 26. │           └─DBI::dbSendStatement(conn, statement, ...)
 27. │             ├─DBI::dbSendQuery(conn, statement, ...)
 28. │             └─duckdb::dbSendQuery(conn, statement, ...)
 29. │               └─duckdb (local) .local(conn, statement, ...)
 30. │                 └─duckdb:::duckdb_result(...)
 31. │                   └─duckdb:::duckdb_execute(res)
 32. │                     └─duckdb:::rapi_execute(...)
 33. └─base::.handleSimpleError(...)
 34.   └─purrr (local) h(simpleError(msg, call))
 35.     └─cli::cli_abort(...)
 36.       └─rlang::abort(...)
── Error ('test-pack_join.R:15:3'): `pack_join()` works with remote table ──────
<purrr_error_indexed/rlang_error/error/condition>
Error in `map(.x, .f, ..., .progress = .progress)`: i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
Backtrace:
     ▆
  1. ├─dm:::dm_for_filter_duckdb() at test-pack_join.R:15:3
  2. ├─dm::copy_dm_to(duckdb_test_src(), dm_for_filter()) at tests/testthat/helper-src.R:26:7
  3. │ └─purrr::walk(...)
  4. │   └─purrr::map(.x, .f, ..., .progress = .progress)
  5. │     └─purrr:::map_("list", .x, .f, ..., .progress = .progress)
  6. │       ├─purrr:::with_indexed_errors(...)
  7. │       │ └─base::withCallingHandlers(...)
  8. │       ├─purrr:::call_with_cleanup(...)
  9. │       └─dm (local) .f(.x[[i]], ...)
 10. │         ├─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 11. │         └─DBI::dbExecute(dest_con, .x, immediate = TRUE)
 12. │           ├─DBI::dbSendStatement(conn, statement, ...)
 13. │           └─DBI::dbSendStatement(conn, statement, ...)
 14. │             ├─DBI::dbSendQuery(conn, statement, ...)
 15. │             └─duckdb::dbSendQuery(conn, statement, ...)
 16. │               └─duckdb (local) .local(conn, statement, ...)
 17. │                 └─duckdb:::duckdb_result(...)
 18. │                   └─duckdb:::duckdb_execute(res)
 19. │                     └─duckdb:::rapi_execute(...)
 20. └─base::.handleSimpleError(...)
 21.   └─purrr (local) h(simpleError(msg, call))
 22.     └─cli::cli_abort(...)
 23.       └─rlang::abort(...)
── Error ('test-validate.R:190:3'): validator speaks up (sqlite()) ─────────────
<dplyr:::mutate_error/rlang_error/error/condition>
Error in `mutate(., data = if_else(table == "tf_1", list(dm_for_filter_duckdb()$tf_1), 
    data))`: i In argument: `data = if_else(table == "tf_1", list(dm_for_filter_duckdb()$tf_1), data)`.
Caused by error in `map()`:
i In index: 1.
Caused by error:
! rapi_execute: Failed to run query
Error: Not implemented Error: indexes are not supported on big endian architectures
── Error ('test_dm_from_con.R:23:3'): table identifiers are quoted ─────────────
Error: rapi_execute: Failed to run query
Error: Not implemented Error: Sorting is not supported on big endian architectures
Backtrace:
     ▆
  1. ├─... %>% ... at test_dm_from_con.R:23:3
  2. ├─dm::dm_select_tbl(...)
  3. │ └─dm:::check_not_zoomed(dm)
  4. │   └─dm:::check_dm(dm)
  5. │     └─dm::is_dm(x)
  6. ├─dm:::suppress_mssql_warning(dm_from_con(con_db, learn_keys = FALSE))
  7. └─dm::dm_from_con(con_db, learn_keys = FALSE) at tests/testthat/helper-skip.R:60:5
  8.   └─dm:::get_src_tbl_names(src, ..., names = .names)
  9.     ├─dplyr::src_tbls(src)
 10.     └─dbplyr:::src_tbls.src_sql(src)
 11.       ├─DBI::dbListTables(x$con)
 12.       └─duckdb::dbListTables(x$con)
 13.         ├─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 14.         └─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 15.           └─DBI (local) .local(conn, statement, ...)
 16.             ├─DBI::dbSendQuery(conn, statement, ...)
 17.             └─duckdb::dbSendQuery(conn, statement, ...)
 18.               └─duckdb (local) .local(conn, statement, ...)
 19.                 └─duckdb:::duckdb_result(...)
 20.                   └─duckdb:::duckdb_execute(res)
 21.                     └─duckdb:::rapi_execute(...)
── Error ('test_dm_from_con.R:63:3'): table identifiers are quoted with learn_keys = FALSE ──
Error: rapi_execute: Failed to run query
Error: Not implemented Error: Sorting is not supported on big endian architectures
Backtrace:
     ▆
  1. ├─dm:::suppress_mssql_warning(...) at test_dm_from_con.R:63:3
  2. └─dm::dm_from_con(con_from_src_or_con(con_db), learn_keys = FALSE) at tests/testthat/helper-skip.R:60:5
  3.   └─dm:::get_src_tbl_names(src, ..., names = .names)
  4.     ├─dplyr::src_tbls(src)
  5.     └─dbplyr:::src_tbls.src_sql(src)
  6.       ├─DBI::dbListTables(x$con)
  7.       └─duckdb::dbListTables(x$con)
  8.         ├─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
  9.         └─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 10.           └─DBI (local) .local(conn, statement, ...)
 11.             ├─DBI::dbSendQuery(conn, statement, ...)
 12.             └─duckdb::dbSendQuery(conn, statement, ...)
 13.               └─duckdb (local) .local(conn, statement, ...)
 14.                 └─duckdb:::duckdb_result(...)
 15.                   └─duckdb:::duckdb_execute(res)
 16.                     └─duckdb:::rapi_execute(...)
── Error ('test_dm_from_con.R:77:3'): dm_from_src() deprecated ─────────────────
Error: rapi_execute: Failed to run query
Error: Not implemented Error: Sorting is not supported on big endian architectures
Backtrace:
     ▆
  1. ├─lifecycle::expect_deprecated(...) at test_dm_from_con.R:77:3
  2. │ └─testthat::expect_warning(...)
  3. │   └─testthat:::expect_condition_matching(...)
  4. │     └─testthat:::quasi_capture(...)
  5. │       ├─testthat (local) .capture(...)
  6. │       │ └─base::withCallingHandlers(...)
  7. │       └─rlang::eval_bare(quo_get_expr(.quo), quo_get_env(.quo))
  8. └─dm::dm_from_src(src_from_src_or_con(con_db), learn_keys = FALSE)
  9.   └─dm::dm_from_con(...)
 10.     └─dm:::get_src_tbl_names(src, ..., names = .names)
 11.       ├─dplyr::src_tbls(src)
 12.       └─dbplyr:::src_tbls.src_sql(src)
 13.         ├─DBI::dbListTables(x$con)
 14.         └─duckdb::dbListTables(x$con)
 15.           ├─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 16.           └─DBI::dbGetQuery(conn, SQL("SELECT name FROM sqlite_master WHERE type='table' OR type='view' ORDER BY name"))
 17.             └─DBI (local) .local(conn, statement, ...)
 18.               ├─DBI::dbSendQuery(conn, statement, ...)
 19.               └─duckdb::dbSendQuery(conn, statement, ...)
 20.                 └─duckdb (local) .local(conn, statement, ...)
 21.                   └─duckdb:::duckdb_result(...)
 22.                     └─duckdb:::duckdb_execute(res)
 23.                       └─duckdb:::rapi_execute(...)

[ FAIL 13 | WARN 8 | SKIP 239 | PASS 1341 ]
Deleting unused snapshots:
• datamodelr-code/nycflights13.dot
• datamodelr-code/nycflights13_draw_uk_1.dot
• datamodelr-code/nycflights13_draw_uk_2.dot
• datamodelr-code/nycflights13_draw_uk_3.dot
• datamodelr-code/nycflights13_table_desc_1.dot
• datamodelr-code/nycflights13_table_desc_2.dot
• datamodelr-code/weird.dot
• draw-dm/empty-table-in-dm.svg
• draw-dm/nycflight-dm-types.svg
• draw-dm/nycflight-dm.svg
• draw-dm/single-empty-table-dm.svg
• draw-dm/table-desc-1-dm.svg
• draw-dm/table-desc-2-dm.svg
• draw-dm/table-desc-3-dm.svg
• draw-dm/table-desc-4-dm.svg
• draw-dm/table-uk-1-dm.svg
• draw-dm/table-uk-2-dm.svg
Error: Test failures
Execution halted
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant