Released: Dec 9, 2021

Updates in 9.1.1

Funktionen

• Added PoolId connection option.

PostgreSQL data provider

• Added support for PostgreSQL 14.
• Added stored procedure OUT parameters in PostgreSQL 14.

InterBase data provider

• Added CutOffParams global variable.
• Added WireCompression option to the Connection component.
• Fields of type dtFloat are now created for system types INT128, DECFLOAT, and large NUMERIC by default.

NexusDB data provider

• Block fetch is now supported.
• Improved fetch performance.

DBF data provider

• FSIZE SQL function is now supported.
• Autoinc data type for dfVisualFoxPro tables is now supported.

Fehlerkorrekturen

• Fixed bug with freezing multiply connection pools in threads.
• Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable.
• Fixed bug with using the AsDate property when working with fields of the ftDate type.
• Fixed bug with updating the state of records at applying cached updates.
• Fixed bug with resetting the specific params.

Oracle data provider

• Fixed bug with LONG parameters in Oracle 11 and earlier.
• Fixed bug with UnicodeEnvironment in pooling.

SQLServer data provider

• Fixed bug with setting the port number to the Server property in Direct mode.
• Fixed bug with Varchar(max) and Text OUT parameters in Direct mode.
• Fixed bug with describing string params in the Direct mode.

MySQL data provider

• Fixed bug with an "Unknown column" error when adding record when RefreshOption = roAfterInsert.

PostgreSQL data provider

• Fixed bug with Access Violation on RefreshRecord after connection switching.
• Fixed bug with application name when connection pooling is used.
• Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations.
• Fixed bug with processing large OID values.

InterBase data provider

• Fixed bug with insertion of a string and binary values when UseUnicode set to True.
• Fixed bug with an incorrect encoding of table alias names.
• Fixed bug with using the AutoDDL property for TUniScript.
• Fixed bug with value exceeds the range for valid timestamps when using AsDateTime property.
• Fixed bug with Access Violation when DescribeParams is True and using the AsBytes property.
• Fixed bug with setting the value of type UInt64 using the Value parameter property.
• Fixed bug with inserting a Byte value using the Value parameter property.
• Fixed bug with setting the numeric value of the parameter via AsString for TUniStoredProc.
• Fixed bug with setting the Connection String.

SQLite data provider

• Fixed bug with memory leak when using the julianday() SQL-function in Direct mode.

DBF data provider

• Fixed bug with reading logical fields which contains "Y"/"N" values.
• Fixed bug with "Invalid field data" when setting a value that exceeds the character field size.

ODBC data provider

• Fixed bug with "Range check error" when the field size is greater than MaxInt.
• Fixed bug with "Invalid precision value" for dtMemo fields.
• Fixed bug with processing UUID fields.