| Date | Build
Number | Change
Type | Description
|
| 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/09/2023 | 8713 | cis | Changed
- Salesforce with SSO Adapter reports the Double type as Doule type instead of Decimial type
- Salesforce with SSO Adapter supports create a table with Clob type column. The Clob type is mapped to Salesforce LongTextArea field.
|
| 10/24/2023 | 8697 | Microsoft Project | Changed
- The default value for the hidden connection property IncludeReferenceColumn has changed to false and the ParentReference columns will no longer be list by default.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 05/04/2023 | 8524 | Microsoft Project | Removed
- Removed the Search stored procedure.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 12/15/2022 | 8384 | Microsoft Project | Added
- Added support for AzureAD authentication. Users can authenticate with any app registered on the Azure Portal by specifying the OAuthClientId and OAuthClientSecret in the connection properties. The authentication process can be customized by specifying properties like Scope, CallbackURL and AzureTenant.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 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.
|
| 04/30/2021 | 7790 | Microsoft Project | Changed
- Changed the sensitivity of the State property to no longer be sensitive. It was mistakenly marked with password sensitivity.
|
| 04/25/2021 | 7785 | General | Added
- Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 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 | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 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/13/2021 | 7773 | Microsoft Project | Changed
- The OneLogin method we used previously has been deprecated by OneLogin. We have updated our design to use the latest version of the OneLogin API, which now requires a seperate OAuthClientId and OAuthClientSecret associated with your OneLogin app to be passed in through SSOProperties. The APIKey that was formerly passed in through SSOProperties for OneLogin is removed.
|
| 03/26/2021 | 7755 | Microsoft Project | Deprecated
- The UseSSO connection property is deprecated. You should select the preferred SSO scheme directly from the AuthScheme connection property instead.
|