| |
| Date | Version | Source | Category | Type | Description |
| 2026-05-27 | 26.0.9643 | General | Connection | Removed | - Removed the deprecated ReplaceInvalidTypesWithNull connection property. Use the ReplaceInvalidValuesWithNull property instead.
|
| 2026-05-07 | 26.0.9623 | General | Data Model | Added | - Added the ColumnCapabilities column to the sys_tablecolumns system table. This column is a bit mask denoting the column's write capabilities.
|
| 2026-04-29 | 26.0.9615 | Adobe Target | Data Model | Changed | - Renamed the Scopes input parameter to Scope in the GetOAuthAccessToken stored procedure.
|
| 2026-04-28 | 26.0.9614 | ADO.NET | Connection | Added | - Added the following functions to the driver class. If you pass these functions an exception with no error records, an InvalidArgumentException is thrown.
- containsErrorSource: Returns true if the exception contains an error record for the provided source name, or false otherwise.
- getErrorCodeFromSource: Returns the numeric error code from the error record with the given source, or -1 if there is no error record from that source.
- containsErrorCode: Returns true if the exception contains an error record with the provided error code, or false otherwise.
- findErrorProperty: Returns the value of the property with the given name, or null if no property with that name is defined.
- formatErrorRecords: Returns a string containing all the exception's error records, including messages, codes, properties, and error locations.
|
| 2026-04-15 | 26.0.9601 | General | Query Exec | Changed | - String comparisons using GREATER, LESS, and CONTAINS operators are now case-insensitive by default.
|
| 2026-04-01 | 26.0.9587 | ADO.NET | | Added | - Added support for EFCore 10.
|
| 2026-01-13 | 25.0.9509 | General | | Added | - Added support for the REGEXP_REPLACE() string function.
|
| 2025-12-05 | 25.0.9470 | General | | Added | - Added support for the INSERT INTO SELECT statement, with driver-side execution for providers that do not support the operation natively.
|
| 2025-10-06 | 25.0.9410 | General | | Added | - Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
|
| 2025-09-12 | 25.0.9386 | General | | Added | - Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
|
| 2025-09-10 | 25.0.9384 | General | | Changed | - All columns in statically defined Views are now reported as read-only.
|
| 2025-09-03 | 25.0.9377 | General | | Changed | - Corrected the behavior when IN criteria with NULL values are used in the projection part. It now returns NULL instead of 0. For example, "NULL IN (1,2)" returns "NULL".
|
| 2025-09-01 | 25.0.9375 | General | | Added | - Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
|
| 2025-08-21 | 25.0.9364 | General | | Changed | - Report behavior change:
- Fixed inconsistent string value comparisons in non-table queries.
- For example, "SELECT 'A' = 'a'" previously returned false, but it now returns true.
|
| 2025-08-13 | 25.0.9356 | General | | Changed | - Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
|
| 2025-06-25 | 25.0.9307 | General | | Removed | - Removed the "ADLS Gen 1" value from the ConnectionType property.
|
| 2025-06-20 | 25.0.9302 | General | | Added | - Created the following functions:
- TEXT_ENCODE: encodes a string into a different charset (UTF8 → UTF7 and returns a binary array as the result).
- TEXT_DECODE: takes a binary array and decodes it back into a string when provided the charset.
- BASE64_ENCODE: takes a binary array and encodes it as a base64 string (varchar).
- BASE64_DECODE: takes a base 64-encoded string and decodes it into a binary array.
|
| 2025-06-18 | 25.0.9300 | General | | Changed | - The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
|
| 2025-05-29 | 25.0.9280 | ADO.NET | | Changed | - We have improved our implementation of the ADO.NET DbDataReader.GetDataTypeName so that it now returns database data type names, such as varchar, tinyint, and datetime. Previously we returned the fully-qualified name of the column’s .NET type, in a format like "System.String, System.Private.CoreLib, Version=6.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e".
|
| 2025-05-27 | 25.0.9278 | ADO.NET | | Removed | - Removed support for the C# implementation of SQLite. Features that previously used this implementation by default, such as AutoCache and EF6 schema caching, now require the native SQLite driver.
|
| 2025-05-27 | 25.0.9278 | General | | Removed | - Removed the "Proprietary" enum option from ProxyAuthscheme.
|