Path to this page:
Subject: CVS commit: pkgsrc/databases/R-dbplyr
From: Makoto Fujiwara
Date: 2023-06-17 15:08:06
Message id: 20230617130806.4CFC4FA89@cvs.NetBSD.org
Log Message:
(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)
Files: