Release Notes 4.0

SQream is introducing a new version release system that follows the more commonly used Major.Minor versioning schema. The newly released 4.0 version is a minor version upgrade and does not require considerable preparation.

The 4.0 release notes were released on 01/25/2023 and describe the following:

New Features 

Re-enabling an enhanced version of the License Storage Capacity feature

Lightweight Directory Access Protocol(LDAP) may be used to authenticate SQream roles

Physical deletion performance enhancement by supporting file systems with parallelism capabilities

Storage Version 

The storage version presently in effect is version 45.

SQream Studio Updates and Improvements 

When creating a New Role, you may now create a group role by selecting Set as a group role.

When editing an Existing Role, you are no longer obligated to update the role’s password.

Known Issues 

Percentile is not supported for Window functions.

Version 4.0 resolved Issues 

SQ No.	Description
SQ-10544	SQream Studio dashboard periodic update enhancement
SQ-11296	Slow catalog queries
SQ-11772	Slow query performance when using `JOIN` clause
SQ-12318	JDBC `insertBuffer` parameter issue
SQ-12364	`GET DDL` foreign table output issue
SQ-12446	SQream Studio group role modification issue
SQ-12468	Internal compiler error
SQ-12580	Server Picker GPU dependency
SQ-12598	Executing `SELECT` on a foreign table with no valid path produces no error message
SQ-12652	SQream Studio result panel adjustment
SQ-13055	NULL issue when executing query with pysqream

Configuration Changes 

No configuration changes were made.

Naming Changes 

No relevant naming changes were made.

Deprecated Features 

SQream is declaring end of support of VARCHAR data type, the decision resulted by SQream’s effort to enhance its core functionalities and with respect to ever changing echo system requirements.

VARCHAR is no longer supported for new customers - effective from Version 2022.1.3 (September 2022).

TEXT data type is replacing VARCHAR and NVARCHAR - SQream will maintain VARCHAR data type support until 09/30/2023.

End of Support 

No End of Support changes were made.

Upgrading to version 4.0 

Generate a back-up of the metadata by running the following command:
```
$ select backup_metadata('out_path');
```
Tip

SQream recommends storing the generated back-up locally in case needed.

SQream runs the Garbage Collector and creates a clean backup tarball package.
Shut down all SQream services.
Extract the recently created back-up file.
Replace your current metadata with the metadata you stored in the back-up file.
Navigate to the new SQream package bin folder.
Run the following command:
```
$ ./upgrade_storage <levelDB path>
```

Note

Upgrading from a major version to another major version requires you to follow the Upgrade Storage step. This is described in Step 7 of the Upgrading SQream Version procedure.