Release Notes 2022.1.6

The 2022.1.6 release notes were released on 12/11/2022 and describe the following:

New Features 

.Net Driver now supports .NET version 6 or newer.

Storage Version 

The storage version presently in effect is version 42.

Known Issues 

Percentile is not supported for Window functions.

Version 2022.1.6 resolved Issues 

SQ No.	Description
SQ-10160	Spotfire casting issues when reading SQream data
SQ-11295	`max_file_size` when executing `COPY_TO` is imprecise
SQ-11940, SQ-11926, SQ-11874	Known encryption issues
SQ-11975	Internal runtime error
SQ-12019	Using `PERCENTILE_DISC` function with `PARTITION BY` function causes internal error
SQ-12089	`COUNT (*)` execution fails when using foreign table
SQ-12117	Running TCPH-21 results in out of memory
SQ-12204	Possible issue when trying to INSERT Unicode data using .Net client

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 v2022.1.6 

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.