odbc 1.4.2
-
dbAppendTable()Improve performance by checking existence once (#691). -
dbConnect()no longer automatically escapes suspicious characters
(since there doesn't seem to be a consistent way to do this across drivers)
but instead points you toquote_value()which applies a heuristic
that should work for most drivers (#718). -
New wrapper for
dbExecute()that setsimmediate = TRUEif you are
not supplyingparams. That should yield a small speed boost in
many cases (#706). -
dbSendQuery()once again defaults toimmediate = FALSE(since if you're
using it instead ofdbGetQuery()you're likely to be using it with
dbBind()). (#726). -
Deprecated
odbcConnectionColumns()(in favor ofdbListFields()),
odbcConnectionActions(), andodbcConnectionIcon()(@simonpcouch, #699). -
Backend specific changes:
-
databricks: Fix schema enumeration in connections pane
(@detule, #715). -
Oracle: use more reliable technique to determine user/schema name (#738),
and fixdbExistsTable()when identifier components contain_
(@detule, #712). -
SQL Server: improvements to
dbExists()(@meztez, #724) and
dbListTables()(@simonpcouch, #509) for temporary tables.
It now uses column type"BIGINT"integer64 objects. -
SQL Server with freetds driver: no longer crashes when executing multiple
queries (@detule, #731). -
Teradata: Fix usage of
exactargument in internal methods (@detule, 717).
-
-
On MacOS and Linux, the package will now automatically set the
ODBCSYSINI
environmental variable when using the unixODBC driver manager.ODBCSYSINI
will not be changed if it exists already (@simonpcouch, #709).