CVS commit: pkgsrc/databases/R-dbplyr

["Makoto Fujiwara" <mef%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   mef
Date:           Sat Jun 17 13:08:06 UTC 2023

Modified Files:
        pkgsrc/databases/R-dbplyr: Makefile distinfo

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)


To generate a diff of this commit:
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/R-dbplyr/Makefile \
    pkgsrc/databases/R-dbplyr/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/R-dbplyr/Makefile
diff -u pkgsrc/databases/R-dbplyr/Makefile:1.3 pkgsrc/databases/R-dbplyr/Makefile:1.4
--- pkgsrc/databases/R-dbplyr/Makefile:1.3      Sun Feb 19 12:15:54 2023
+++ pkgsrc/databases/R-dbplyr/Makefile  Sat Jun 17 13:08:06 2023
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.3 2023/02/19 12:15:54 mef Exp $
+# $NetBSD: Makefile,v 1.4 2023/06/17 13:08:06 mef Exp $
 
 R_PKGNAME=     dbplyr
-R_PKGVER=      2.3.0
+R_PKGVER=      2.3.2
 
 MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
 COMMENT=       Database backend for dplyr
Index: pkgsrc/databases/R-dbplyr/distinfo
diff -u pkgsrc/databases/R-dbplyr/distinfo:1.3 pkgsrc/databases/R-dbplyr/distinfo:1.4
--- pkgsrc/databases/R-dbplyr/distinfo:1.3      Sun Feb 19 12:15:54 2023
+++ pkgsrc/databases/R-dbplyr/distinfo  Sat Jun 17 13:08:06 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.3 2023/02/19 12:15:54 mef Exp $
+$NetBSD: distinfo,v 1.4 2023/06/17 13:08:06 mef Exp $
 
-BLAKE2s (R/dbplyr_2.3.0.tar.gz) = 930f6f826f4c98bd5c07d23df140cbcae3a50c42ce50e129ee18b6956b18f12d
-SHA512 (R/dbplyr_2.3.0.tar.gz) = 54f703148a461327c632c21056e02eb97b3d53a551426533c000a2e918815879b5f0d2bfde51f586bbe4132e399bbf0091d92afc630622f37b26c08977899a4c
-Size (R/dbplyr_2.3.0.tar.gz) = 704259 bytes
+BLAKE2s (R/dbplyr_2.3.2.tar.gz) = b7f0a3eab029016d0168452833c0336d529a816845cbc69930bc23ef01759136
+SHA512 (R/dbplyr_2.3.2.tar.gz) = cf003d23d433c4c107baa3e293060ba4dc63e47d72dd4cc9f95165d52d9a43f5cd4b1ae9db6ac5fcf6d248dd8779572b861951f7631d59f00ea74417e26fc231
+Size (R/dbplyr_2.3.2.tar.gz) = 723687 bytes