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

Version 8.0.1

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.

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.