Running ‘testthat.R’ [99s/135s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(dbplyr)
  > 
  > test_check("dbplyr")
  Registering testing src: sqlite OK
  [ FAIL 1 | WARN 0 | SKIP 320 | PASS 1394 ]
  
  ══ Skipped tests (320) ═════════════════════════════════════════════════════════
  • Need at least two srcs to compare (6): 'test-verb-compute.R:34:3',
    'test-verb-copy-to.R:20:3', 'test-verb-copy-to.R:29:3',
    'test-verb-set-ops.R:49:3', 'test-verb-set-ops.R:65:3',
    'test-verb-set-ops.R:89:3'
  • No MariaDB (4): 'test-backend-mysql.R:77:3', 'test-backend-mysql.R:82:3',
    'test-backend-mysql.R:87:3', 'test-backend-mysql.R:98:3'
  • No mssql (13): 'test-backend-mssql.R:291:3', 'test-backend-mssql.R:308:3',
    'test-backend-mssql.R:327:3', 'test-backend-mssql.R:343:3',
    'test-backend-mssql.R:371:3', 'test-backend-mssql.R:400:3',
    'test-backend-mssql.R:426:3', 'test-backend-mssql.R:453:3',
    'test-backend-mssql.R:481:3', 'test-backend-mssql.R:510:3',
    'test-backend-mssql.R:537:3', 'test-backend-mssql.R:566:3',
    'test-backend-mssql.R:593:3'
  • No postgres (8): 'test-backend-postgres.R:152:3',
    'test-backend-postgres.R:160:3', 'test-backend-postgres.R:166:3',
    'test-backend-postgres.R:180:3', 'test-backend-postgres.R:243:3',
    'test-backend-postgres.R:295:3', 'test-backend-postgres.R:357:3',
    'test-verb-joins.R:91:3'
  • On CRAN (283): 'test-backend-.R:70:3', 'test-backend-.R:128:3',
    'test-backend-.R:140:3', 'test-backend-access.R:69:3',
    'test-backend-hana.R:4:3', 'test-backend-hana.R:17:3',
    'test-backend-hive.R:13:3', 'test-backend-impala.R:22:3',
    'test-backend-mssql.R:64:3', 'test-backend-mssql.R:102:3',
    'test-backend-mssql.R:119:3', 'test-backend-mssql.R:134:3',
    'test-backend-mssql.R:140:3', 'test-backend-mssql.R:152:3',
    'test-backend-mssql.R:162:3', 'test-backend-mssql.R:174:3',
    'test-backend-mssql.R:196:3', 'test-backend-mssql.R:216:3',
    'test-backend-mssql.R:234:3', 'test-backend-mssql.R:257:3',
    'test-backend-mssql.R:276:3', 'test-backend-mysql.R:39:3',
    'test-backend-mysql.R:59:3', 'test-backend-oracle.R:20:3',
    'test-backend-oracle.R:39:3', 'test-backend-oracle.R:55:3',
    'test-backend-oracle.R:72:3', 'test-backend-postgres.R:81:3',
    'test-backend-postgres.R:89:3', 'test-backend-postgres.R:104:3',
    'test-backend-postgres.R:135:3', 'test-backend-redshift.R:51:3',
    'test-backend-sqlite.R:41:3', 'test-backend-sqlite.R:49:3',
    'test-backend-sqlite.R:53:3', 'test-backend-sqlite.R:101:3',
    'test-backend-teradata.R:53:3', 'test-backend-teradata.R:60:3',
    'test-backend-teradata.R:66:3', 'test-backend-teradata.R:76:3',
    'test-backend-teradata.R:83:3', 'test-build-sql.R:3:3', 'test-db-io.R:7:3',
    'test-db-sql.R:7:3', 'test-db-sql.R:27:3', 'test-escape.R:107:3',
    'test-escape.R:112:3', 'test-escape.R:117:3', 'test-ident.R:14:3',
    'test-lazy-join-query.R:20:3', 'test-lazy-select-query.R:2:3',
    'test-pillar.R:2:3', 'test-query-join.R:6:3', 'test-query-join.R:16:3',
    'test-query-join.R:25:3', 'test-query-join.R:32:3', 'test-query-join.R:39:3',
    'test-query-select.R:9:3', 'test-query-select.R:18:3',
    'test-query-select.R:22:3', 'test-query-semi-join.R:4:3',
    'test-query-semi-join.R:9:3', 'test-query-set-op.R:4:3',
    'test-query-set-op.R:9:3', 'test-rows.R:7:3', 'test-rows.R:53:3',
    'test-rows.R:66:3', 'test-rows.R:121:3', 'test-rows.R:163:3',
    'test-rows.R:193:3', 'test-rows.R:220:3', 'test-rows.R:228:3',
    'test-rows.R:275:3', 'test-rows.R:314:3', 'test-rows.R:329:3',
    'test-rows.R:413:3', 'test-rows.R:454:3', 'test-rows.R:500:3',
    'test-rows.R:518:3', 'test-rows.R:566:3', 'test-rows.R:607:3',
    'test-rows.R:649:3', 'test-rows.R:693:3', 'test-rows.R:731:3',
    'test-rows.R:784:3', 'test-rows.R:824:3', 'test-rows.R:865:3',
    'test-rows.R:911:3', 'test-rows.R:927:3', 'test-schema.R:2:3',
    'test-sql-build.R:3:3', 'test-sql.R:8:3', 'test-tbl-lazy.R:7:3',
    'test-tbl-lazy.R:11:3', 'test-tbl-lazy.R:22:3', 'test-tbl-sql.R:34:3',
    'test-test-backend-snowflake.R:6:3', 'test-tidyeval-across.R:48:3',
    'test-tidyeval-across.R:92:3', 'test-tidyeval-across.R:213:3',
    'test-tidyeval-across.R:220:3', 'test-tidyeval-across.R:228:3',
    'test-tidyeval-across.R:362:3', 'test-tidyeval-across.R:371:3',
    'test-tidyeval-across.R:378:3', 'test-tidyeval-across.R:421:3',
    'test-tidyeval-across.R:438:3', 'test-tidyeval-across.R:445:3',
    'test-tidyeval-across.R:452:3', 'test-tidyeval-across.R:459:3',
    'test-tidyeval-across.R:494:3', 'test-tidyeval-across.R:523:3',
    'test-tidyeval-across.R:531:3', 'test-tidyeval-across.R:611:3',
    'test-tidyeval-across.R:617:3', 'test-tidyeval-across.R:623:3',
    'test-tidyeval-across.R:633:3', 'test-translate-sql-conditional.R:2:3',
    'test-translate-sql-conditional.R:9:3',
    'test-translate-sql-conditional.R:13:3',
    'test-translate-sql-conditional.R:24:3',
    'test-translate-sql-conditional.R:58:3',
    'test-translate-sql-conditional.R:65:3',
    'test-translate-sql-conditional.R:152:3',
    'test-translate-sql-conditional.R:217:3',
    'test-translate-sql-conditional.R:232:3',
    'test-translate-sql-conditional.R:261:3',
    'test-translate-sql-conditional.R:267:3', 'test-translate-sql-cut.R:97:3',
    'test-translate-sql-cut.R:138:3', 'test-translate-sql-helpers.R:2:3',
    'test-translate-sql-helpers.R:37:3', 'test-translate-sql-helpers.R:41:3',
    'test-translate-sql-helpers.R:72:3', 'test-translate-sql-quantile.R:2:3',
    'test-translate-sql-string.R:15:3', 'test-translate-sql-window.R:83:3',
    'test-translate-sql-window.R:131:3', 'test-translate-sql-window.R:181:3',
    'test-translate-sql-window.R:202:3', 'test-translate-sql.R:5:3',
    'test-translate-sql.R:15:3', 'test-translate-sql.R:72:3',
    'test-verb-arrange.R:16:3', 'test-verb-arrange.R:21:3',
    'test-verb-arrange.R:45:3', 'test-verb-arrange.R:64:3',
    'test-verb-compute.R:58:3', 'test-verb-compute.R:107:3',
    'test-verb-compute.R:115:3', 'test-verb-copy-to.R:60:3',
    'test-verb-copy-to.R:77:3', 'test-verb-copy-to.R:101:3',
    'test-verb-copy-to.R:110:3', 'test-verb-copy-to.R:137:3',
    'test-verb-count.R:4:3', 'test-verb-count.R:64:3',
    'test-verb-distinct.R:151:3', 'test-verb-distinct.R:193:3',
    'test-verb-do.R:33:3', 'test-verb-do.R:71:3', 'test-verb-expand.R:7:3',
    'test-verb-expand.R:19:3', 'test-verb-expand.R:24:3',
    'test-verb-expand.R:30:3', 'test-verb-expand.R:50:3',
    'test-verb-expand.R:54:3', 'test-verb-expand.R:58:3',
    'test-verb-expand.R:63:3', 'test-verb-expand.R:104:3',
    'test-verb-expand.R:110:3', 'test-verb-expand.R:132:3',
    'test-verb-fill.R:45:3', 'test-verb-fill.R:58:3', 'test-verb-fill.R:71:3',
    'test-verb-fill.R:84:3', 'test-verb-fill.R:98:3', 'test-verb-fill.R:104:3',
    'test-verb-filter.R:19:3', 'test-verb-filter.R:56:3',
    'test-verb-filter.R:62:3', 'test-verb-filter.R:168:3',
    'test-verb-filter.R:184:3', 'test-verb-filter.R:219:3',
    'test-verb-filter.R:293:3', 'test-verb-filter.R:329:3',
    'test-verb-filter.R:339:3', 'test-verb-group_by.R:20:3',
    'test-verb-group_by.R:27:3', 'test-verb-group_by.R:35:3',
    'test-verb-group_by.R:156:3', 'test-verb-joins.R:31:3',
    'test-verb-joins.R:54:3', 'test-verb-joins.R:71:3',
    'test-verb-joins.R:161:3', 'test-verb-joins.R:273:3',
    'test-verb-joins.R:355:3', 'test-verb-joins.R:487:3',
    'test-verb-joins.R:544:3', 'test-verb-joins.R:571:3',
    'test-verb-joins.R:586:3', 'test-verb-joins.R:746:3',
    'test-verb-joins.R:793:3', 'test-verb-joins.R:863:3',
    'test-verb-joins.R:873:3', 'test-verb-joins.R:895:3',
    'test-verb-joins.R:904:3', 'test-verb-joins.R:944:3',
    'test-verb-joins.R:989:3', 'test-verb-joins.R:1173:3',
    'test-verb-mutate.R:30:3', 'test-verb-mutate.R:43:3',
    'test-verb-mutate.R:57:3', 'test-verb-mutate.R:64:3',
    'test-verb-mutate.R:105:3', 'test-verb-mutate.R:129:3',
    'test-verb-mutate.R:156:3', 'test-verb-mutate.R:176:3',
    'test-verb-mutate.R:188:3', 'test-verb-mutate.R:415:3',
    'test-verb-mutate.R:422:3', 'test-verb-mutate.R:467:3',
    'test-verb-mutate.R:474:3', 'test-verb-mutate.R:481:3',
    'test-verb-pivot-longer.R:13:3', 'test-verb-pivot-longer.R:31:3',
    'test-verb-pivot-longer.R:40:3', 'test-verb-pivot-longer.R:44:3',
    'test-verb-pivot-longer.R:77:3', 'test-verb-pivot-longer.R:81:3',
    'test-verb-pivot-longer.R:88:3', 'test-verb-pivot-longer.R:142:3',
    'test-verb-pivot-longer.R:158:3', 'test-verb-pivot-longer.R:191:3',
    'test-verb-pivot-longer.R:235:3', 'test-verb-pivot-longer.R:251:3',
    'test-verb-pivot-longer.R:259:3', 'test-verb-pivot-wider.R:23:3',
    'test-verb-pivot-wider.R:48:3', 'test-verb-pivot-wider.R:60:3',
    'test-verb-pivot-wider.R:223:3', 'test-verb-pivot-wider.R:231:3',
    'test-verb-pivot-wider.R:253:3', 'test-verb-pivot-wider.R:265:3',
    'test-verb-pivot-wider.R:314:3', 'test-verb-pivot-wider.R:333:3',
    'test-verb-pivot-wider.R:364:3', 'test-verb-pivot-wider.R:403:3',
    'test-verb-pivot-wider.R:462:3', 'test-verb-pivot-wider.R:467:3',
    'test-verb-pivot-wider.R:472:3', 'test-verb-pivot-wider.R:479:3',
    'test-verb-pivot-wider.R:486:3', 'test-verb-pull.R:45:3',
    'test-verb-select.R:28:3', 'test-verb-select.R:40:3',
    'test-verb-select.R:97:3', 'test-verb-select.R:158:3',
    'test-verb-select.R:181:3', 'test-verb-select.R:217:3',
    'test-verb-select.R:256:3', 'test-verb-select.R:282:3',
    'test-verb-select.R:292:3', 'test-verb-select.R:300:3',
    'test-verb-select.R:315:3', 'test-verb-slice.R:3:3',
    'test-verb-slice.R:17:3', 'test-verb-slice.R:26:3', 'test-verb-slice.R:36:3',
    'test-verb-slice.R:51:3', 'test-verb-slice.R:62:3',
    'test-verb-summarise.R:21:3', 'test-verb-summarise.R:44:3',
    'test-verb-summarise.R:66:3', 'test-verb-summarise.R:76:3',
    'test-verb-summarise.R:107:3', 'test-verb-summarise.R:116:3',
    'test-verb-summarise.R:127:3', 'test-verb-uncount.R:5:3',
    'test-verb-window.R:2:3', 'test-verb-window.R:13:3',
    'test-verb-window.R:19:3', 'test-verb-window.R:33:3'
  • `grouped_df()` needs a `name_repair` argument (1):
    'test-verb-pivot-wider.R:81:3'
  • identical(Sys.getenv("GITHUB_POSTGRES"), "true") is not TRUE (1):
    'test-backend-postgres-old.R:2:3'
  • not clear whether test makes sense (2): 'test-verb-arrange.R:2:3',
    'test-verb-arrange.R:131:3'
  • not yet correctly supported (1): 'test-tidyeval-across.R:263:3'
  • tidyselect issue #221 (1): 'test-tidyeval-across.R:500:3'
  
  ══ Failed tests ════════════════════════════════════════════════════════════════
  ── Failure ('test-escape.R:80:3'): date and date-times are converted to ISO 8601 ──
  escape(x1, con = con) (`actual`) not equal to sql("'2000-01-02T09:04:05Z'") (`expected`).
  
  `actual`:   "<SQL> '2000-01-02T03:04:05Z'"
  `expected`: "<SQL> '2000-01-02T09:04:05Z'"
  
  [ FAIL 1 | WARN 0 | SKIP 320 | PASS 1394 ]
  Error: Test failures
  Execution halted