dbConnect() gains a timeout parameter, to control how long a connection should be attempted before timing out. (#139)
Full schema support using Id objects available in DBI 8.0 (#91, #120)
dbQuoteIdentifier() when given a length 0 input (#146 @edgararuiz).Fix multiple transactions with rollback (#136).
Add custom sqlCreateTable and dbListTables method for Taradata connections (@edgararuiz) ## Features
Add custom sqlCreateTable and dbListTables method for Teradata connections (@edgararuiz)
Add dbms.name parameter to dbConnect() to allow the user to set the database management system name in cases it cannot be queried from the Driver (#115, @hoxo-m).
Fix multiple transactions with rollback (#136).
Fix translation of missing values for integer types (#119).
Update PIC flags to avoid portability concerns.
Add bigint parameter to dbConnect() to allow the user to set the behavior when converting 64 bit integers into R types.
Fixes for compatibility with the RStudio Connections pane and viewer. (@jmcphers).
Define BUILD_REAL_64_BIT_MODE for compatibility with older systems sql.h, to ensure we always use 8 byte pointers.
Added temporary-table support for Oracle database using a custom sqlCreateTable (#99, @edgararuiz)
Fix regression when binding due to the num_columns variable not being updated by odbc_result::bind_list().
Support table creation for Vertica and Redshift (#93, @khotilov).
Changed parameter fieldTypes to field.types in functions dbWriteTable() and sqlCreateTable() to be compliant with DBI (#106, @jschelbert).
dbSendStatement no longer executes the statement, this is instead done when dbBind() or dbGetRowsAffected() is called. This change brings ODBC into compliance with the DBI specification for dbSendStatement(). (#84, @ruiyiz).
Workaround for drivers which do not implement SQLGetInfo, such as the Access driver. (#78)
Fix for installation error for systems without GNU Make as the default make, such as Solaris.
Provide a fall backs for drivers which do not support SQLDescribeParam and those which do not support transactions.
sqlCreateTable() gains a fieldTypes argument, which allows one to override a column type for a given table, if the default type is not appropriate.
Support for databases with non UTF-8 encodings. Use the encoding parameter to dbConnect() to specify the database encoding.
Support for the SQL Connection Pane in the RStudio IDE.
Unknown fields no longer throw a warning, instead they signal a custom condition, which can be caught if desired with
withCallingHandlers(expr, odbc_unknown_field_type = function(e) {…} )
Conversion to and from timezones is handled by the cctz library. If the database is in a non-UTC timezone it can be specified with the timezone parameter to dbConnect().
Time objects are converted to and from hms objects.
64 bit integers are converted to and from bit64 objects.
Support table creation for Impala and Hive Databases (# 38, @edgararuiz).
NEWS.md file to track changes to the package.