Skip to content

dbplyr 1.4.4

Choose a tag to compare

@hadley hadley released this 27 May 12:10
  • Internally DBI::dbExecute() now uses immediate = TRUE; this improves
    support for session-scoped temporary tables in MS SQL (@krlmlr, #438).

  • Subqueries with ORDER BY use TOP 9223372036854775807 instead of
    TOP 100 PERCENT on SQL Server for compatibility with Azure Data Warehouse
    (#337, @alexkyllo).

  • escape() now supports blob vectors using new sql_escape_raw()
    generic. It enables using blob variables in
    dplyr verbs, for example to filter nvarchar values by UTF-16 blobs
    (see r-dbi/DBI#215 (comment)).
    (@okhoma, #433)

  • Added setOldClass() calls for "ident" and "ident_q" classes for
    compatibility with dplyr 1.0.0 (#448, @krlmlr).

  • Postgres str_detect() translation uses same argument names as stringr,
    and gains a negate argument (#444).

  • semi_join() and anti_join() now correctly support the sql_on argument
    (#443, @krlmlr).