Skip to main content

Search

Welcome to Tibero GTS!

Tibero 7.2 Release Notes [2022.08]

New Features

DBMS Engine

The following features have been added.

JSON Type

  • Support for JSON_MERGEPATCH, JSON_OBJECTAGG functions

  • Support for JSON_VALUE Function Based Index (matching up to JSON_VALUE options required)

  • Support for JSON Type variables and IN/OUT parameters within PSM

SQL PROFILE Feature

  • SQL tuning can be performed using SQL Profile when direct modification of application SQL is not possible.

Note: Refer to Chapter 42 DBMS_SQLTUNE in the "Tibero tbPSM Reference Guide"

SQL PLAN BASELINE Feature

  • Store created plans and use stored plans even if the optimizer does not choose them.

TAS Metafile Patch/Rollback

  • Patch tasks / rollback tasks can be processed without TAS reconfiguration when adding/removing TAS META FILE is required.

Tibero Recovery Catalog

  • Provides Recovery Catalog feature for managing metadata of multiple databases

Utility

The following features have been added.

tbSQL SET MARKUP Feature

  • tbsql output results can be displayed in HTML format.

Client Driver

JDBC 4.1 Support

  • Support for BigInteger / BIGINT type

  • connection.abort

  • connection.setSchema

  • connection.setNetworkTimeout

  • statement.closeOnCompletion

  • Support for Resultset.getObject(Class)

JDBC 4.2 Support

  • Support for LocalDate, LocalTime, LocalDateTime, OffsetTime, OffsetDateTime

  • Support for setObject, registerOutParameter based on SQLType

  • Statement.executeLargeUpdate returns row count as long type

Note: Refer to Chapter 2 JDBC Standard Support in the "Tibero JDBC Developer Guide"

Changed Features

DBMS Engine

The following features have been improved.

DBMS_VERIFY

  • Support for DBMS_VERIFY feature on Local partitioned index

SYSTEM VIEW

TYPE column added to the following views

  • [DBA | ALL | USER]_TAB_PRIVS

  • [DBA | ALL | USER]_TBL_PRIVS

  • [ALL | USER]_TAB_PRIVS_MADE

DBMS_UTILITY

  • Added MAXNAME_ARRAY type

DBMS_XMLGEN

  • Added SETBINDVALUE procedure

Client Driver

Default Character Set

  • The default character set for the client environment has changed from MSWIN949 to UTF8 (TB_NLS_LANG)