Release Notes 2022.1.3

The 2022.1.3 release notes were released on 9/20/2022 and describe the following:

Version Content

The 2022.1.3 Release Notes describes the following:

  • Optimize the delete operation by removing redundant calls.

  • Support LIKE condition for filtering metadata.

  • Migration tool for converting VARCHAR columns into TEXT columns.

  • Support sub-queries in the UPDATE condition.

Storage Version

The storage version presently in effect is version 42.

Known Issues

The following table lists the issues that are known limitations in Version 2022.1.3:

SQ No.

Description

SQ-11677

UPADTE or DELETE using a sub-query that includes ‘%’ (modulo) is crashing SQreamDB worker

Resolved Issues

The following table lists the issues that were resolved in Version 2022.1.3:

SQ No.

Description

SQ-11487

COPY FROM with offset = 0 (which is an unsupported option) is stuck up to the query timeout.

SQ-11373

SQL statement fails after changing the foreign table the statement tries to query.

SQ-11320

Locked users are not being released on system reset.

SQ-11310

Using “create table like” on foreign tables results in flat compression of the created table.

SQ-11287

SQL User Defined Function fails when function definition contain parenthesis

SQ-11187

FLAT compression is wrongly chosen when dealing with data sets starting with all-nulls

SQ-10892

Update - enhanced error message when trying to run update on foreign table.

Operations and 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 immediately.

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

As part of this release 2022.1.3, SQream provides an automated and secured migration tool to help customers with the conversion phase from VARCHAR to TEXT data type, please address delivery for further information.

End of Support

No End of Support changes were made.

Upgrading to v2022.1.3

  1. 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.

  2. Shut down all SQream services.

  3. Extract the recently created back-up file.

  4. Replace your current metadata with the metadata you stored in the back-up file.

  5. Navigate to the new SQream package bin folder.

  6. 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.