1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
# db_copy_to() wraps DBI errors
Code
(expect_error(db_copy_to(con = con, table = "tmp2", values = data.frame(x = c(1,
1)), unique_indexes = list("x"))))
Output
<error/rlang_error>
Error in `db_copy_to()`:
! Can't copy data to table `tmp2`.
Caused by error in `db_create_index.DBIConnection()`:
! Can't create index on table `tmp2`.
i Using SQL: CREATE UNIQUE INDEX `tmp2_x` ON `tmp2` (`x`)
Caused by error:
! dummy DBI error
# db_copy_to() can overwrite a table
Code
(expect_error(db_copy_to(con = con, table = "tmp", values = data.frame(x = c(1,
1)))))
Output
<error/rlang_error>
Error in `db_copy_to()`:
! Can't copy data to table `tmp`.
Caused by error in `dplyr::db_write_table()`:
! Can't write table table `tmp`.
Caused by error:
! dummy DBI error
# db_save_query() can overwrite a table
Code
(expect_error(db_save_query(con = con, sql = "SELECT 2 FROM tmp", name = "tmp"))
)
Output
<error/rlang_error>
Error in `db_save_query()`:
! Can't save query to table `tmp`.
i Using SQL: CREATE TEMPORARY TABLE `tmp` AS `SELECT 2 FROM tmp`
Caused by error:
! dummy DBI error
|
