Release Notes 2021.1.2

The 2021.1.2 release notes were released on 8/9/2021 and describe the following:

New Features

The 2021.1.2 Release Notes include the following new features:

Aliases Added to SUBSTRING Function and Length Argument

The following aliases have been added:

  • length - len

  • substring - substr

Data Type Aliases Added

The following data type aliases have been added:

  • INTEGER - int

  • DECIMAL - numeric

  • DOUBLE PRECISION - double

  • CHARACTER/CHAR - text

  • NATIONAL CHARACTER/NATIONAL CHAR/NCHAR - text

  • CHARACTER VARYING/CHAR VARYING - text

  • NATIONAL CHARACTER VARYING/NATIONAL CHAR VARYING/NCHAR VARYING - text

String Literals Containing ASCII Characters Interepreted as TEXT

SQream now interprets all string literals, including those containing ASCII characters, as text.

For more information, see String Types.

Decimal Literals Interpreted as Numeric Columns

SQream now interprets literals containing decimal points as numeric instead of as double.

For more information, see Data Types.

Roles Area Added to Studio Version 5.4.3

The Roles area has been added to Studio version 5.4.3. From the Roles area users can create and assign roles and manage user permissions.

Resolved Issues

The following list describes the resolved issues:

  • In Parquet files, float columns could not be mapped to SQream double columns. This was fixed.

  • The REPLACE function only supported constant values as arguments. This was fixed.

  • The LIKE function did not check for incorrect patterns or handle escape characters. This was fixed.