The Entity Provider for Teradata supports 3 new Teradata Database String fastpath functions: Right, Left and Reverse introduced in Teradata Database 15.10. The Right and Left functions were supported using the Substring Teradata String function prior to Teradata Database 15.10. The current Database release supports the Right and Left canonical functions directly. The Canonical Reverse function is supported beginning with the Teradata Database 15.10. These new functions are found in Canonical String Functions.
Primary Amp Indexes are supported in column-partitioned tables. The new index type may be found in Schema Indexes Collection.
TdDataReader.GetSchemaTable method returns additional metadata. The ColumnInfo DataColumn has been enhanced and two new DataColumns (ServerCharacterSet and UDTType) have been added to the DataTable.
The TdConnection.InfoMessage event is now raised when a command execution returns a warning message from the Teradata Database.
The Teradata Database Direct Pass-through allows any text found between the @BEGIN_PASS_THRU and @END_PASS_THRU tokens, found in a FOREIGN TABLE query, to be directly passed through to a foreign database server. The .NET Data Provider does not validate the query as a FOREIGN TABLE query, and will pass all text unparsed found between these two tokens.
A command executed in ANSI session mode with a simple comment (-- simple comment) at the end of the command would skip the COMMIT WORK normally appended in ANSI Session mode. This has been fixed.
TdConnection.Close would block when called from an application that is listening for the TdConnection.StateChange event, and attempted to close the connection while the original state was Connecting
and the current state was Broken
. This has been fixed.
The Teradata Database allows 16383 parameter rows to be included in a parameter array when using the TdDataAdapter to batch commands. In previous releases the Data Provider would fill the message buffer with parameter rows, and did not check for the maximum number of rows that can be handled by the Teradata Database. When more than 16383 rows weresent, the Teradata Database returned a 5966 error. This has been fixed.
There was a problem when Connection Pooling is enabled and Query Bands are specified in the connection string. If TdConnection.Open and then TdConnection.Close are called multiple times using the same connection string (the Query Band attribute values can change) a NullReferenceException will get thrown. This has been fixed.
Statement Independence will always be enabled when TdDataAdapter.Update TdDataAdapter.Update is called. This will change the behavior of the Data Provider when a batch is processed. Refer to Behavior of TdDataAdapter.Update With Different Settings for more information.