Change History

Released On

Description

2024-10-11

This issue is the fourth official release, adapts to DWS 8.2.1.220.

2024-04-03

This issue is the third official release, adapts to DWS 8.1.3.325.

2023-04-28

This issue is the second official release, adapts to DWS 8.1.3.200.

  • Partition addition and partition table management are supported.PERIOD (interval type) and TTL (interval type) are now available in partition management.

  • JSON foreign tables are supported.

    1. READ ONLY HDFS foreign tables in JSON format are supported.

    2. READ ONLY OBS foreign tables in JSON file format are supported.

  • Column-store VACUUM

    1. Added the GUC parameter colvacuum_threshold_scale_factor to control the minimum ratio of dead tuples in a rewritten file of column-store tables.

    2. The VACUUM operation on the primary table is disabled by default. You need to set the colvacuum_threshold_scale_factor parameter to enable this function.

  • The row-store ring buffer is controlled by a switch.

    The ring buffer is controlled by a switch and its threshold is adjustable. Batch update of large tables no longer uses the ring buffer.

  • Default storage mode of a table.It is controlled by the parameter default_orientation. If the storage mode is not specified during table creation, this parameter specifies the default storage mode.

  • The GBK character set supports the euro sign.

  • OBS foreign tables are adapted to XSKY and the parameter eol is added.

  • SQL supports Roaring Bitmaps.

  • Case-insensitive is supported to improve Teradata compatibility.

  • List partitioned tables are supported.

  • Enhanced MySQL compatibility

    ALTER TABLE can modify multiple columns at a time.

    ALTER TABLE supports COMMENT.

    ALTER TABLE supports CHANGE, DROP KEY, DROP PARTITION, and FIRST/AFTER.

  • DWS customers have a large number of MERGE INTO operations on replication tables. Like row-store replication tables, column-store replication tables now support UPDATE, DELETE, and MERGE INTO operations.

  • Fine-grained permission management

    Added the ALTER, DROP and VACUUM permissions at table level.

    Added the ALTER and DROP permissions at schema level.

    Add the preset roles role_signal_backend and role_read_all_stats.

  • Added the distributed view pg_session_wlmstat.

  • Added the GUC parameter log_clean_strategy for CM cluster log compression and clearance.

  • Modified partition table features

    Changed the limit on the number of boundary values: The number of partitions in a partition table cannot exceed 32767, and the number of boundary values of all partitions cannot exceed 32767.

    The default partition creation policy is modified. When a partition table is created, two default partitions are created. The partition time range of the two default partitions is PERIOD.

  • Added the function of returning NULL when the divisor is 0.

    Specifies whether to report an error when the divisor is 0 in MySQL compatibility mode. The compatibility configuration item enable_division_by_zero_mysql is added to the behavior_compat_options parameter.

  • Added the GUC parameter ddl_lock_timeout, which specifies the DDL lock timeout interval.

  • Enhanced the view PG_LOCKS.

    Added the views PGXC_WAIT_DETAIL and PGXC_LOCKWAIT_DETAIL.

    Add columns such as wait_on_pid and query_id.

2022-11-17

This issue is the first official release, adapts to DWS 8.1.1.202.

last updated: 2024-11-13 15:46 UTC - commit: bdcb01d62e4f1de672b662d88ef6cb8eb3a27a29