| |
| Date | Build
Number | Change
Type | Description |
| 08/23/2024 | 9001 | Amazon S3 | Added
- Added the GeneratePresignedURL stored procedure.
|
| 08/20/2024 | 8998 | Amazon S3 | Added
- Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
|
| 07/29/2024 | 8976 | Amazon S3 | Added
- Added the Buckets connection property. When the Buckets property is active, the Buckets table displays null for every column except the primary key Bucket.
|
| 07/01/2024 | 8948 | Amazon S3 | Added
- Added "STSEndpointOverride" connection property, which specifies an endpoint to use for the AWS STS service.
|
| 06/28/2024 | 8945 | Amazon S3 | Removed
- AwsMFA has been removed as an AuthScheme value. Use MFA properties with AwsRootKeys, AwsIAMRoles, and TemporaryCredentials schemes where necessary.
|
| 06/18/2024 | 8935 | General | Added
- Added support for the "TELAVIV" region (Israel) in the AWSRegion connection property.
|
| 05/22/2024 | 8908 | Amazon S3 | Added
- The "Object" output was added for the DownloadObjects stored procedure. This output contains the name of the object that was downloaded.
|
| 05/15/2024 | 8901 | Amazon S3 | Changed
- Three columns in the Buckets table have been changed to read-only: OwnerDisplayName, OwnerId, and CreationDate.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 05/08/2024 | 8894 | Amazon S3 | Removed
- Removed support for Wasabi endpoints.
|
| 04/06/2024 | 8862 | Amazon S3 | Added
- Added support for the AwsWebIdentity authentication scheme.
|
| 03/15/2024 | 8840 | General | Added
- Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
|
| 03/04/2024 | 8829 | Amazon S3 | Added
- Added support for AWS KMS server-side encryption, which can be configured through ServerSideEncryption connection property.
- Added support for specifying a server-side encryption key, context and enabling S3 bucket keys when using AWS KMS through SSEKey, SSEContext, SSEEnableS3BucketKeys connection properties respectively.
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/28/2023 | 8732 | General | Added
- Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 10/30/2023 | 8703 | Amazon S3 | Added
- Added two new stored procedures PutBucketAcl and PutObjectAcl.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 12/19/2022 | 8388 | Amazon S3 | Added
- Added support for DeleteObject and MoveObject StoredProcedure
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 11/11/2022 | 8350 | ODBC | Changed
- Updated embedded JRE to jre8u345-b01 (Linux x64 / MacOS x64) and jre-17.0.5+8 (MacOS aarch64).
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 09/06/2022 | 8284 | Amazon S3 | Added
- Added support for in-memory download using the DownloadObjects stored procedure.
|
| 09/01/2022 | 8279 | Amazon S3 | Removed
- Removed the DownloadObjectTorrent store procedure.
|
| 08/30/2022 | 8277 | Amazon S3 | Added
- Added support for uploading server-side encrypted objects via the ServerSideEncryption connection property.
|
| 05/17/2022 | 8172 | ODBC | Changed
- Updated VC++ redistributable Libraries to Microsoft Visual C++ 2015-2022 Redistributable 14.32
|
| 05/05/2022 | 8160 | Amazon S3 | Added
- Added the BucketsCompliance and ObjectsCompliance tables.
|
| 04/27/2022 | 8152 | ODBC | Changed
- The installer now installs .NET 4.0 instead of .NET 2.0 during default installation when both are present.
|
| 03/16/2022 | 8110 | Amazon S3 | Added
- Added support for Instance Metadata Service Version 2 (IMDSv2) when authenticating from an Amazon EC2 instance.
|
| 03/01/2022 | 8095 | Amazon S3 | Added
- Added support for the AwsCognitoBasic and AwsCognitoSrp authentication methods.
|
| 12/22/2021 | 8026 | ODBC | Added
- Added support for transactions.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/29/2021 | 7880 | ODBC | Added
- Added support for the Array data type for the input parameters in stored procedures.
|
| 07/23/2021 | 7874 | General | Changed
- Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 07/23/2021 | 7874 | Amazon S3 | Added
- Added multi-thread multi-part upload support for the UploadObject procedure. Set the value of the ChunkSize to -1 if you want to disable the multi part logic.
Removed
- Removed the SimpleUploadLimit connection property. We will perform multi-part upload by default in the UploadObject procedure. The number of parallel calls can be controlled by the MaxThreads connection property.
|
| 05/29/2021 | 7819 | ODBC | Added
- Exposed the InitiateOAuth connection property.
|
| 05/26/2021 | 7816 | ODBC | Added
- Added support for the JAVA_HOME setting in the configuration file.
|
| 05/17/2021 | 7807 | Amazon S3 | Added
- Added support for Single Sign On (SSO) connection with PingFederate as the Identity Provider (IdP).
|
| 04/29/2021 | 7789 | ODBC | Added
- Added the SqlMaxColumnNameLen connection property.
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|
| 04/16/2021 | 7776 | General | Changed
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|
| 04/16/2021 | 7776 | ODBC | Changed
- ODBC Drivers on Linux and Mac now depend on the JRE, which brings improved stability and performance.
|