On this page

SQL Syntax
Keywords
System Catalogs
System Functions
System Views
Behavior Changes
GUC Parameters

Show all

Help Center/ GaussDB(DWS)/ Product Bulletin/ Product Notice/ Version 8.0.1

Version 8.0.1

Updated on 2024-09-03 GMT+08:00

View PDF

V8.0.1.500 release date: February 8, 2021

V8.0.1.100 release date: July 31, 2020

SQL Syntax

**Table 1** SQL syntax
Change Type	No.	Name	Change Description
Add	1	Setting the temporary tablespace quota	The CREATE USER/ROLE user1... TEMP SPACE '5GB' syntax is added to set the temporary space quota.
	2	Changing the temporary tablespace quota	The ALTER USER user1 TEMP SPACE '5GB'; syntax is added to modify the temporary space quota.
	3	Setting the space limit for the intermediate calculation result set to be flushed to disks	The CREATE USER/ROLE user1... SPILL SPACE'unlimited; syntax is added to set the temporary space quota of the intermediate result set.
	4	Modifying the upper limit of the space for storing intermediate calculation results	The ALTER USER user1 SPILL SPACE '5GB'; syntax is added to set the temporary space quota for the intermediate result set.
	5	ALTER TABLE	The alter table modify not null [enable] / alter table modify null syntax is added.
	6	CREATE INDEX	The index name can contain schema when an index is created.
	7	ALTER SEQUENCE	The ALTER SEQUENCE syntax is added.
	8	CREATE SYNONYM	The CREATE [OR REPLACE] SYNONYM syn_name FOR obj_name syntax is added.
	9	DROP SYNONYM	The DROP SYNONYM IF EXISTS syn_name syntax is added.
	10	ALTER SYNONYM	The ALTER SYNONYM syn_name OWNER TO newowner syntax is added.
	11	CREATE USER/ROLE with ldap password disable	AD authentication is supported. When creating a user, set the user authentication type to LDAP.
	12	ALTER USER/ROLEwith ldap password disable	AD authentication is supported, and the user authentication type is changed to LDAP.
	13	Adding parameter options to the copy fault tolerance table	The log errors data option is added to support user-defined selection. Fill in the rawrecord field.
Modify	14	GIN index	The GIN index is disabled in the 300 scenario.
Delete	15	ALTER TABLEPartitioned tableexchange with unloggTable	Do not exchange partitioned tables with unlogged tables.

Keywords

**Table 2** Keywords
Change Type	No.	Name	Change Description
Add	1	SYNONYM	The non-reserved keyword SYNONYM is added.
	2	VERIFY	The reserved keyword VERIFY is added.
	3	FAST	The non-reserved keyword FAST is added.
	4	COMPLETE	The non-reserved keyword COMPLETE was added.
Modify	5	FUNCTION	The keyword FUNCTION is changed to a non-reserved keyword U.
	6	OVER	The keyword OVER is changed to a non-reserved keyword U.
	7	SPLIT	The SPLIT keyword is changed to a non-reserved keyword U.
	8	RETURN	The type of keyword RETURN is changed to a non-reserved keyword U.
	9	ISNULL	The ISNULL type is changed to a non-reserved keyword U.

System Catalogs

**Table 3** System catalogs
Change Type	No.	Name	Change Description
Add	1	PG_SYNONYM	Added the pg_synonym system catalog for storing the mapping between synonym objects and associated object names.
	2	PG_REDACTION_POLICY PG_REDACTION_COLUMN	pg_redaction_policy stores object masking policies and status expressions. pg_redaction_column stores object column information, including which columns need to be anonymized and the anonymization mode.
	3	PG_OBJECT	Stores the creation time, creation user, and last modification time of a table/foreign table/view/index/sequence/function.
Modify	4	PG_AUTHID	The authinfo column is added to identify the authentication type of a user. The default value is empty. If the user is an AD user, the value is ldap.

System Functions

**Table 4** System functions
Change Type	No.	Name	Change Description
Add	1	dbms_redact.add_policy dbms_redact.alter_policy dbms_redact.enable_policy dbms_redact.disable_policy dbms_redact.drop_policy	Add a data masking policy. Modify the masking policy information, including adding a masking column to a table object and modifying the masking mode of the column. Enable or disable a data masking policy. Deleting a data masking policy
	2	pgxc_get_workload_sql_count	Provides statistics on the number of SELECT/UPDATE/INSERT/DELETE statements executed in all workload Cgroup on all CNs of the current cluster and the number of DDL, DML, and DCL statements.
	3	pgxc_get_workload_sql_elapse_time	Provides statistics on response time of SELECT/UPDATE/INSERT/DELETE statements executed in all workload Cgroup on all CNs of the current cluster.
	4	get_instr_unique_sql	Provides unique SQL information collected on the current node.
	5	reset_instr_unique_sql(cstring, cstring, INT8)	Deletes the collected Unique SQL information.
	6	pgxc_get_instr_unique_sql	Provides complete Unique SQL information collected on all CNs in a cluster.
	7	pg_check_authid	Checks whether the user exists based on the user OID.
Modify	8	pg_stat_get_sql_count	Provides statistics on the results of SELECT/UPDATE/INSERT/DELETE/MERGE INTO statements executed by all users on all the nodes, their response time, and the number of DDL, DML, and DCL statements.
Modify	9	pgxc_get_sql_count	Provides statistics on the results of SELECT/UPDATE/INSERT/DELETE/MERGE INTO statements executed by all users on the current node, their response time, and the number of DDL, DML, and DCL statements.

System Views

**Table 5** System views
Change Type	No.	Name	Change Description
Add	1	ALL_SYNONYMS DBA_SYNONYMS USER_SYNONYMS	ALL_SYNONYMS displays all synonyms accessible to the current user. DBA_SYNONYMS displays all synonyms in the database. Only users with system administrator permissions can access this view. USER_SYNONYMS displays synonyms accessible to the current user.
	2	REDACTION_POLICIES REDACTION_COLUMNS	The two tables correspond to two system catalogs. The OID is converted to the name to display the policy information.
	3	GS_WORKLOAD_SQL_COUNT	Displays statistics on the number of SQL statements executed in workload Cgroups on the current node, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
	4	PGXC_WORKLOAD_SQL_COUNT	Displays statistics on the number of SQL statements executed in workload Cgroups on all CNs in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
	5	GLOBAL_WORKLOAD_SQL_COUNT	Displays statistics on the number of SQL statements executed in all workload Cgroups in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
	6	GS_WORKLOAD_SQL_ELAPSE_TIME	Displays statistics on the response time of SQL statements in workload Cgroups on the current node, including the maximum, minimum, average, and total response time of SELECT, UPDATE, INSERT, and DELETE statements. The unit is microsecond.
	7	PGXC_WORKLOAD_SQL_ELAPSE_TIME	Displays statistics on the response time of SQL statements in workload Cgroups on all CNs in a cluster, including the maximum, minimum, average, and total response time of SELECT, UPDATE, INSERT, and DELETE statements. The unit is microsecond.
	8	GLOBAL_WORKLOAD_SQL_ELAPSE_TIME	Displays statistics on the response time of SQL statements in all workload Cgroups in a cluster, including the maximum, minimum, average, and total response time of SELECT, UPDATE, INSERT, and DELETE statements. The unit is microsecond.
	9	PGXC_INSTR_UNIQUE_SQL	Displays the complete Unique SQL statistics of all CN nodes in the cluster.
	10	GS_INSTR_UNIQUE_SQL	You can query the Unique SQL execution information collected by the current node.
Modify	11	ALL_OBJECTS DBA_OBJECTS USER_OBJECTS	Modify the view definition and extend the SYNONYM object.
	12	PGXC_THREAD_WAIT_STATUS	Modify the view definition.
	13	GS_SQL_COUNT	Provides statistics on the number of SELECT/UPDATE/INSERT/DELETE/MERGE INTO statements executed by all users on the current node, response time, and the number of DDL, DML, and DCL statements.
	14	PGXC_SQL_COUNT	Provides statistics on the number of SELECT/UPDATE/INSERT/DELETE/MERGE INTO statements executed by all users in the cluster, response time, and the number of DDL, DML, and DCL statements.
	15	ALL_OBJECTS DBA_OBJECTS USER_OBJECTS	Modify the view definition and add the creation time and last modification time of the object.
	16	PG_TABLES	Modify the view definition and add the creation user, creation time, and last modification time of the table.

Behavior Changes

**Table 6** Behavior changes
Change Type	No.	Name	Change Description
Add	1	CN Retry Disables Some Copy FROM Scenarios	The COPY FROM STDIN statement is not supported. The gsql \copy from meta-command is not supported. JDBC CopyManager copyIn cannot be used to import data.

GUC Parameters

**Table 7** GUC Parameters
Change Type	No.	Name	Change Description
Add	1	sql_use_spacelimit	Specifies the maximum storage space for a single SQL statement on a single DN.
	2	remote_read_mode	Sets the remote read mode.
	3	enable_incremental_catchup	Sets whether to enable incremental catchup.
	4	wait_dummy_time	Maximum time for waiting for the secondary server to start or send back the scan list during incremental catchup.
	5	enable_xlog_group_insert	It specifies whether the xlog enables the group insertion mode on the ARM platform.
	6	topsql_retention_time	Number of days for storing data in the gs_wlm_session_info and gs_wlm_operator_info tables.
	7	user_metric_retention_time	Indicates the number of days for storing historical resource monitoring data.
	8	instance_metric_retention_time	Indicates the number of days for storing historical resource monitoring data of an instance.
	9	enable_user_metric_persistent	Indicates whether to enable the function of monitoring and dumping historical user resources.
	10	enable_instance_metric_persistent	Indicates whether to enable the function of dumping historical instance resource monitoring data.
	11	COMM_IPC	Switch for locating communication performance problems. This parameter specifies whether to print the information about the packets sent and received by each communication node.
	12	COMM_PARAM	Communication performance problem locating switch. This parameter specifies whether to print the session parameter settings during node communication.
	13	plan_cache_mode	Controls the behavior of the cached plan. The custom plan, generic plan, or auto mode can be forcibly used (the default value is auto).
Modify	14	audit_system_object	The 18th digit is added to indicate whether to audit SYNONYM objects. The maximum value is changed to 524287.
	15	comm_max_stream	In the FusionCube environment, the default value of this parameter is changed to 10000 after the cluster is installed.
	16	enable_dynamic_workload	The default value is changed from off to on.
	17	behavior_compat_options	The convert_interval_to_text member is added to control whether the implicit type conversion from interval to text is supported. By default, the implicit type conversion is not supported.

Parent topic: Product Notice

Previous topic: Version 8.1.0

Next topic: Deleted Database Interfaces

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback

Log In and Submit Submit Cancel