Table of Contents
This chapter briefly describes newly added and updated features in Tibero 7.2.
This section lists and briefly describes newly added features.
The following features have been added.
JSON Type
Supports the JSON_MERGEPATCH and JSON_OBJECTAGG functions.
Supports Function-based indexes for JSON_VALUE. (Options for JSON_VALUE must match.)
Supports declaration of JSON type variables and an IN/OUT parameter in PSM.
SQL Profiles
Allows SQL tuning when the user cannot modify an SQL query within an application.
For more information about how to use SQL profiles, refer to "Chapter 42. DBMS_SQLTUNE" in Tibero tbPSM Reference Guide.
SQL Plan Baselines
Stores SQL plans to be used by the user without choosing the Optimizer for optimized plans.
Patch and rollback tasks when TAS meta files are added or removed
Added DDLs to support a patch implementation that requires adding or removing TAS meta files, without reconfiguring TAS.
Tibero Recovery Catalog
Supports metadata management for multiple databases.
Stores metadata of different databases to physically separated locations. The database storing metadata is referred to as Catalog database (Catalog).
When a database is registered in the catalog, tbrmgr scans the database's control file and extracts metadata, which is sent and stored to the catalog.
Keeps data up-to-date.
Updates metadata when backups are created or deleted using the rmgr client, or when the administrator requests resynchronization.
For more information, refer to "Chapter 18. Tibero Recovery Catalog" in Tibero Administrator's Guide.
Copying files based on the redundancy number with ASCMD commands
Added an option for the cp and cptolocal commands to specify a mirror of a target file through ascmd.
The -redun option (set to a value between 0 and 2) copies a file according to the redundancy number.
MVIEW
Added new MVIEW features.
[DBA|ALL|USER]_MVIEW_DETAIL_RELATIONS: displays MVIEW-related objects information.
[DBA|ALL|USER]_MVIEW_REFRESH_TIMES: displays refresh time of MVIEW.
CONTEXT INDEX
Added views for CONTEXT INDEX.
CTX_PREFERENCES
CTX_PREFERENCE_VALUES
CTX_STOPLISTS
The following features have been added.
SET MARKUP for tbSQL
Displays output of tbsql in html.
The following features have been added.
JDBC 4.1 Standards
Supports java.math.BigInteger and JDBC type BIGINT.
Supports disconnection using the connection.abort function.
Supports specifying schema using the connection.setSchema function.
Supports specifying a timeout using the connection.setNetworkTimeout function.
Supports closing statements upon the end of result sets using the statement.closeOnCompletion function.
Supports specifying return types using a class as the argument of the Resultset.getObject function.
JDBC 4.2 Standards
Supports java.time.LocalDate, LocalTime, LocalDateTime, OffsetTime, and OffsetDateTime types.
Supports specifying types using SQLType as the argument of the setObject and registerOutParameter functions.
Supports returning the affected row count value in the long data type using the Statement.executeLargeUpdate function.
For more information, refer to "Chapter 2. JDBC Standars" in Tibero JDBC Developer's Guide.
This section lists and briefly describes modified and improved key features.
The following features have been improved.
DBMS_VERIFY
Supports DBMS_VERIFY for local partitioned indexes.
SYSTEM VIEW
Added the TYPE column for the following views.
[DBA|ALL|USER]_TAB_PRIVS
[DBA|ALL|USER]_TBL_PRIVS
[ALL|USER]_TAB_PRIVS_MADE
DBMS_UTILITY
Added the MAXNAME_ARRAY type in the DBMS_UTILITY package.
DBMS_XMLGEN
Added the SETBINDVALUE procedure in the DBMS_XMLGEN package.