Sat Jun 17 13:08:06 2023 UTC ()
(databases/R-dbplyr) 2.3.0 to 2.3.2
# dbplyr 2.3.2
* Hot patch release to resolve R CMD check failures.
# dbplyr 2.3.1
## Breaking changes
* `window_order()` now only accepts bare symbols or symbols wrapped in `desc()`.
This breaking change is necessary to allow `select()` to drop and rename
variables used in `window_order()` (@mgirlich, #1103).
## Improved error messages
* `quantile()` and `median()` now error for SQL Server when used in `summarise()`
and for PostgreSQL when used in `mutate()` as they can't be properly
translated (@mgirlich, #1110).
* Added an informative error for unsupported join arguments `unmatched` and
`multiple` (@mgirlich).
* Using predicates, e.g. `where(is.integer)`, in `across()` now produces an
error as they never worked anyway (@mgirlich, #1169).
* Catch unsupported argument `pivot_wider(id_expand = TRUE)` and
`pivot_longer(cols_vary)` (@mgirlich, #1109).
## Bug fixes in SQL generation
* Fixed an issue when using a window function after a `summarise()` and
`select()` (@mgirlich, #1104).
* Fixed an issue when there where at least 3 joins and renamed variables
(@mgirlich, #1101).
* `mutate()` and `select()` after `distinct()` now again produce a subquery to
generate the correct translation (@mgirlich, #1119, #1141).
* Fixed an issue when using `filter()` on a summarised variable (@mgirlich, #1128).
* `mutate()` + `filter()` now again produces a new query if the `mutate()`
uses a window function or SQL (@mgirlich, #1135).
* `across()` and `pick()` can be used (again) in `distinct()` (@mgirlich, #1125).
* The `rows_*()` function work again for tables in a schema in PostgreSQL
(@mgirlich, #1133).
## Minor improvements and bug fixes
* `sql()` now evaluates its arguments locally also when used in `across()` (@mgirlich, #1039).
* The rank functions (`row_number()`, `min_rank()`, `rank()`, `dense_rank()`,
`percent_rank()`, and `cume_dist()`) now support multiple variables by
wrapping them in `tibble()`, e.g. `rank(tibble(x, y))` (@mgirlich, #1118).
* `pull()` now supports the argument `name` (@mgirlich, #1136).
* Added support for `join_by()` added in dplyr 1.1.0 (@mgirlich, #1074).
* Using `by = character()` to perform a cross join is now soft-deprecated in
favor of `cross_join()`.
* `full_join()` and `right_join()` are now translated directly to `FULL JOIN`
and `RIGHT JOIN` for SQLite as native support was finally added (@mgirlich, #1150).
* `case_match()` now works with strings on the left hand side (@mgirlich, #1143).
* The rank functions (`row_number()`, `min_rank()`, `rank()`, `dense_rank()`,
`percent_rank()`, and `cume_dist()`) now work again for variables wrapped in
`desc()`, e.g. `row_number(desc(x))` (@mgirlich, #1118).
* Moved argument `auto_index` after `...` in `*_join()` (@mgirlich, #1115).
* Removed dependency on assertthat (@mgirlich, #1112).
* `across()` now uses the original value when a column is overriden to match
the behaviour of dplyr. For example `mutate(df, across(c(x, y), ~ .x / x))`
now produces
```
SELECT `x` / `x` AS `x`, `y` / `x` AS `y`
FROM `df`
```
instead of
```
SELECT `x`, `y` / `x` AS `y`
FROM (
SELECT `x` / `x` AS `x`, `y`
FROM `df`
)
```
(@mgirlich, #1015).
* Restricted length of table aliases to avoid truncation on certain backends (e.g., Postgres) (@fh-mthomson, #1096)
(mef)
diff -r1.3 -r1.4 pkgsrc/databases/R-dbplyr/Makefile
diff -r1.3 -r1.4 pkgsrc/databases/R-dbplyr/distinfo
--- pkgsrc/databases/R-dbplyr/Makefile 2023/02/19 12:15:54 1.3
+++ pkgsrc/databases/R-dbplyr/Makefile 2023/06/17 13:08:06 1.4
| @@ -1,17 +1,17 @@ | | | @@ -1,17 +1,17 @@ |
1 | # $NetBSD: Makefile,v 1.3 2023/02/19 12:15:54 mef Exp $ | | 1 | # $NetBSD: Makefile,v 1.4 2023/06/17 13:08:06 mef Exp $ |
2 | | | 2 | |
3 | R_PKGNAME= dbplyr | | 3 | R_PKGNAME= dbplyr |
4 | R_PKGVER= 2.3.0 | | 4 | R_PKGVER= 2.3.2 |
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/02/19 12:15:54 1.3
+++ pkgsrc/databases/R-dbplyr/distinfo 2023/06/17 13:08:06 1.4
| @@ -1,5 +1,5 @@ | | | @@ -1,5 +1,5 @@ |
1 | $NetBSD: distinfo,v 1.3 2023/02/19 12:15:54 mef Exp $ | | 1 | $NetBSD: distinfo,v 1.4 2023/06/17 13:08:06 mef Exp $ |
2 | | | 2 | |
3 | BLAKE2s (R/dbplyr_2.3.0.tar.gz) = 930f6f826f4c98bd5c07d23df140cbcae3a50c42ce50e129ee18b6956b18f12d | | 3 | BLAKE2s (R/dbplyr_2.3.2.tar.gz) = b7f0a3eab029016d0168452833c0336d529a816845cbc69930bc23ef01759136 |
4 | SHA512 (R/dbplyr_2.3.0.tar.gz) = 54f703148a461327c632c21056e02eb97b3d53a551426533c000a2e918815879b5f0d2bfde51f586bbe4132e399bbf0091d92afc630622f37b26c08977899a4c | | 4 | SHA512 (R/dbplyr_2.3.2.tar.gz) = cf003d23d433c4c107baa3e293060ba4dc63e47d72dd4cc9f95165d52d9a43f5cd4b1ae9db6ac5fcf6d248dd8779572b861951f7631d59f00ea74417e26fc231 |
5 | Size (R/dbplyr_2.3.0.tar.gz) = 704259 bytes | | 5 | Size (R/dbplyr_2.3.2.tar.gz) = 723687 bytes |