Sun Feb 19 12:15:54 2023 UTC ()
(databases/R-dbplyr) Updated 2.2.1 to 2.3.0
# dbplyr 2.3.0
* Compatibility with purrr 1.0.0 (@mgirlich, #1085).
## New features
* `stringr::str_like()` (new in 1.5.0) is translated to the closest `LIKE`
equivalent (@rjpat, #509)
* In preparation for dplyr 1.1.0:
* The `.by` argument is supported (@mgirlich, #1051).
* Passing `...` to `across()` is deprecated because the evaluation timing
of `...` is ambiguous. Now instead of (e.g.)
`across(a:b, mean, na.rm = TRUE)` use
* `pick()` is translated (@mgirlich, #1044).
* `case_match()` is translated (@mgirlich, #1020).
* `case_when()` now supports the `.default` argument (@mgirlich, #1017).
* Variables that aren't found in either the data or in the environment now
produce an error (@mgirlich, #907).
## SQL optimisation
* dbplyr now produces fewer subqueries resulting in shorter, more readable, and,
in some cases, faster SQL. The following combination of verbs now avoids a
subquery if possible:
* `*_join()` + `select()` (@mgirlich, #876).
* `select()` + `*_join()` (@mgirlich, #875).
* `mutate()` + `filter()` and `filter()` + `filter()` (@mgirlich, #792).
* `distinct()` (@mgirlich, #880).
* `summarise()` + `filter()` now translates to `HAVING` (@mgirlich, #877).
* `left/inner_join()` + `left/inner_join()` (@mgirlich, #865).
* dbplyr now uses `SELECT *` after a join instead of explicitly selecting every
column, where possible (@mgirlich, #898).
* Joins only use the table aliases ("LHS" and "RHS") if necessary (@mgirlich).
* When using common table expressions, the results of joins and set operations
are now reused (@mgirlich, #978).
## Improved error messages
* Many errors have been improved and now show the function where the error
happened instead of a helper function (@mgirlich, #907).
* Errors produced by the database, e.g. in `collect()` or `rows_*()`, now show
the verb where the error happened (@mgirlich).
* `window_order()` now produces a better error message when applied to a data
frame (@mgirlich, #947).
* Using a named `across()` now gives a clear error message (@mgirlich, #761).
## Minor improvements and bug fixes
* Keyword highlighting can now be customised via the option `dbplyr_highlight`.
Turn it off via `options(dbplyr_highlight = FALSE)` or pass a custom ansi
style, e.g. `options(dbplyr_highlight = cli::combine_ansi_styles("bold", "cyan"))`
(@mgirlich, #974).
* The rank functions (`row_number()`, `min_rank()`, `rank()`, `dense_rank()`,
`percent_rank()`, and `cume_dist()`) now give missing values the rank NA to
match the behaviour of dplyr (@mgirlich, #991).
* `NA`s in `blob()`s are correctly translated to `NULL` (#983).
* `copy_inline()` gains a `types` argument to specify the SQL column types
(@mgirlich, #963).
* `cur_column()` is now supported (@mgirlich, #951).
* `distinct()` returns columns ordered the way you request, not the same
as the input data (@mgirlich).
* `fill()` can now fill "downup" and "updown" (@mgirlich, #1057), and
now order by non-numeric columns also in the up direction (@mgirlich, #1057).
* `filter()` now works when using a window function and an external vector
(#1048).
* `group_by()` + renamed columns works once again (@mgirlich, #928).
* `last()` is correctly translated when no window frame is specified
(@mgirlich, #1063).
* `setOldClass()` uses a namespace, fixing an installation issue (@mgirlich, #927).
* `sql()` is now translated differently. The `...` are now evaluated locally
instead of being translated with `translate_sql()` (@mgirlich, #952).
## Backend specific improvements
* HANA:
* Correctly translates `as.character()` (#1027).
* `copy_inline()` now works for Hana (#950)
* MySQL:
* `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)
* Oracle:
* `slice_sample()` now works for Oracle (@mgirlich, #986).
* `copy_inline()` now works for Oracle (#972)
* PostgreSQL:
* Generates correct literals for Dates (#727).
* `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)
* `rows_*()` use the column types of `x` when auto copying (@mgirlich, #909).
* Redshift:
* `round()` now respects the `digits` argument (@owenjonesuob, #1033).
* No longer tries to use named windows anymore (@owenjonesuob, #1035).
* `copy_inline()` now works for Redshift (#949, thanks to @ejneer for an
initial implementation).
* `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)
* Snowflake:
* numeric functions: `all()`, `any()`, `log10()`, `round()`, `cor()`, `cov()`
and `sd()`.
* date functions: `day()`, `mday()`, `wday()`, `yday()`, `week()`,
`isoweek()`, `month()`, `quarter()`, `isoyear()`, `seconds()`, `minutes()`,
`hours()`, `days()`, `weeks()`, `months()`, `years()` and `floor_date()`.
* string functions: `grepl()`, `paste()`, `paste0()`, `str_c()`, `str_locate()`,
`str_detect()`, `str_replace()`, `str_replace_all()`, `str_remove()`,
`str_remove_all()`, `str_trim()`, `str_squish()` and `str_flatten()`
(@fh-afrachioni, #860).
* `str_flatten()` uses `collapse = ""` by default (@fh-afrachioni, #993)
* SQLite:
* `quantile()` gives a better error saying that it is not supported
(@mgirlich, #1000).
* SQL server:
* `as.POSIXct()` now translated correctly (@krlmlr, #1011).
* `median()` now translated correctly (#1008).
* `pivot_wider()` works again for MS SQL (@mgirlich, #929).
* Always use 1 and 0 as literals for logicals (@krlmlr, #934).
* Teradata:
* Querying works again. Unfortunately, the fix requires every column to
once again by explicitly selected (@mgirlich, #966).
* New translations for `as.Date()`, `week()`, `quarter()`, `paste()`,
`startsWith()`, `row_number()`, `weighted.mean()`, `lead()`, `lag()`, and
`cumsum()` (@overmar, #913).
(mef)
diff -r1.2 -r1.3 pkgsrc/databases/R-dbplyr/Makefile
diff -r1.2 -r1.3 pkgsrc/databases/R-dbplyr/distinfo
--- pkgsrc/databases/R-dbplyr/Makefile 2023/01/01 04:41:11 1.2
+++ pkgsrc/databases/R-dbplyr/Makefile 2023/02/19 12:15:54 1.3
| @@ -1,17 +1,17 @@ | | | @@ -1,17 +1,17 @@ |
1 | # $NetBSD: Makefile,v 1.2 2023/01/01 04:41:11 mef Exp $ | | 1 | # $NetBSD: Makefile,v 1.3 2023/02/19 12:15:54 mef Exp $ |
2 | | | 2 | |
3 | R_PKGNAME= dbplyr | | 3 | R_PKGNAME= dbplyr |
4 | R_PKGVER= 2.2.1 | | 4 | R_PKGVER= 2.3.0 |
5 | | | 5 | |
6 | MAINTAINER= pkgsrc-users@NetBSD.org | | 6 | MAINTAINER= pkgsrc-users@NetBSD.org |
7 | COMMENT= Database backend for dplyr | | 7 | COMMENT= Database backend for dplyr |
8 | LICENSE= mit | | 8 | LICENSE= mit |
9 | | | 9 | |
10 | DEPENDS+= R-assertthat-[0-9]*:../../devel/R-assertthat | | 10 | DEPENDS+= R-assertthat-[0-9]*:../../devel/R-assertthat |
11 | DEPENDS+= R-blob-[0-9]*:../../devel/R-blob | | 11 | DEPENDS+= R-blob-[0-9]*:../../devel/R-blob |
12 | DEPENDS+= R-DBI-[0-9]*:../../math/R-DBI | | 12 | DEPENDS+= R-DBI-[0-9]*:../../math/R-DBI |
13 | DEPENDS+= R-dplyr-[0-9]*:../../math/R-dplyr | | 13 | DEPENDS+= R-dplyr-[0-9]*:../../math/R-dplyr |
14 | DEPENDS+= R-ellipsis-[0-9]*:../../math/R-ellipsis | | 14 | DEPENDS+= R-ellipsis-[0-9]*:../../math/R-ellipsis |
15 | DEPENDS+= R-glue-[0-9]*:../../devel/R-glue | | 15 | DEPENDS+= R-glue-[0-9]*:../../devel/R-glue |
16 | DEPENDS+= R-lifecycle-[0-9]*:../../devel/R-lifecycle | | 16 | DEPENDS+= R-lifecycle-[0-9]*:../../devel/R-lifecycle |
17 | DEPENDS+= R-magrittr-[0-9]*:../../devel/R-magrittr | | 17 | DEPENDS+= R-magrittr-[0-9]*:../../devel/R-magrittr |
--- pkgsrc/databases/R-dbplyr/distinfo 2023/01/01 04:41:11 1.2
+++ pkgsrc/databases/R-dbplyr/distinfo 2023/02/19 12:15:54 1.3
| @@ -1,5 +1,5 @@ | | | @@ -1,5 +1,5 @@ |
1 | $NetBSD: distinfo,v 1.2 2023/01/01 04:41:11 mef Exp $ | | 1 | $NetBSD: distinfo,v 1.3 2023/02/19 12:15:54 mef Exp $ |
2 | | | 2 | |
3 | BLAKE2s (R/dbplyr_2.2.1.tar.gz) = 67b5a2d65cafa0f895e322821d6be9b6ad6390827f52b407ee01cf18f5cb5fb7 | | 3 | BLAKE2s (R/dbplyr_2.3.0.tar.gz) = 930f6f826f4c98bd5c07d23df140cbcae3a50c42ce50e129ee18b6956b18f12d |
4 | SHA512 (R/dbplyr_2.2.1.tar.gz) = 68953a399aca4d23dc58071293095e42efff0eb921dbdf5c67debc692bbc9d960df681ac7b8429780ee047e2330f8337a7e49d49722b2d3bdbad30ad38a753b9 | | 4 | SHA512 (R/dbplyr_2.3.0.tar.gz) = 54f703148a461327c632c21056e02eb97b3d53a551426533c000a2e918815879b5f0d2bfde51f586bbe4132e399bbf0091d92afc630622f37b26c08977899a4c |
5 | Size (R/dbplyr_2.2.1.tar.gz) = 670569 bytes | | 5 | Size (R/dbplyr_2.3.0.tar.gz) = 704259 bytes |