Nothing
test_that("factors can be round tripped", {
skip_if_not(TEST_RE2)
con <- local_con()
df0 <- data.frame(
a = c(1, 2, 3),
f = as.factor(c("a", "b", NA)),
x = c("Hello", "World", "Etc"),
stringsAsFactors = FALSE
)
duckdb_register(con, "df0", df0)
df1 <- dbReadTable(con, "df0")
expect_equal(df0, df1)
dbWriteTable(con, "df1", df0)
df2 <- dbReadTable(con, "df1")
expect_equal(df0, df2)
})
test_that("iris can be round-tripped", {
skip_if_not(TEST_RE2)
con <- local_con()
duckdb_register(con, "iris", iris)
df1 <- dbReadTable(con, "iris")
expect_identical(iris, df1)
dbWriteTable(con, "iris2", iris)
df2 <- dbReadTable(con, "iris2")
expect_identical(iris, df2)
})
test_that("non-utf things can be read", {
skip_if_not(TEST_RE2)
con <- local_con()
horrid_string <- iconv("Mühleisen", "utf8", "latin1")
Encoding(horrid_string) <- "latin1"
# both column name and factor level and plain string are latin1
df <- data.frame(
a = factor(horrid_string),
b = horrid_string,
stringsAsFactors = FALSE
)
names(df) <- c(horrid_string, "less_horrid")
duckdb_register(con, "df", df)
df1 <- dbReadTable(con, "df")
dbWriteTable(con, "df2", df)
df2 <- dbReadTable(con, "df2")
# fix the encoding again
levels(df[[1]]) <- iconv(levels(df[[1]]), "latin1", "UTF8")
names(df) <- iconv(names(df), "latin1", "UTF8")
df$less_horrid <- iconv(df$less_horrid, "latin1", "UTF8")
expect_identical(df, df1)
expect_identical(df, df2)
})
test_that("single value factors round trip correctly, issue 2627", {
skip_if_not(TEST_RE2)
con <- local_con()
df1 <- data.frame(year = as.factor(rep("1998", 5)))
dbWriteTable(con, "df", df1, field.types = c(year = "VARCHAR"))
df2 <- dbReadTable(con, "df")
df1$year <- as.character(df1$year)
expect_identical(df1, df2)
})
test_that("huge-cardinality factors do not cause strange crashes, issue 3639", {
con <- local_con()
set.seed(123)
df <- data.frame(col1 = factor(sample(5000, 10^6, replace = TRUE)))
duckdb_register(con, "df", df)
})
test_that("levels that differ only in case are different levels", {
con <- local_con()
df <- data.frame(f = factor(c("a", "A", "a")))
dbWriteTable(con, "df", df)
expect_equal(dbReadTable(con, "df"), df)
# Two factor cells whose levels differ in case differ in type, like two
# cells with different levels, and a list column of them has no single type.
# The error can arrive as a second one reading "std::exception"
# (see test-struct.R), so catch whichever arrives.
cells <- data.frame(id = 1:2)
cells$f <- list(factor("a"), factor("A"))
err <- tryCatch(duckdb_register(con, "cells_reg", cells), error = identity)
expect_s3_class(err, "duckdb_error")
err <- tryCatch(dbWriteTable(con, "cells", cells), error = identity)
expect_s3_class(err, "duckdb_error")
expect_false(dbExistsTable(con, "cells"))
})
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.