Support and Constraints

The differences between operations supported by GaussDB(DWS) 3.0 lie in the management console and database operations.

For details about the operation differences supported on the management console, see Table 1. For details about the supported database capabilities, see Table 2.

**Table 1** Console Operation
Module	Function	DWS 2.0	DWS 3.0
Navigation menu	Dashboard	Yes	Yes
	Cluster Management	Yes	Yes
	DR management	Yes	No
	Snapshot management	Yes	Yes
	Parameters	Yes	Yes
	Incident management	Yes	Yes
	Alarm management	Yes	Yes
	Client connections	Yes	Yes
Dashboard	Resources	Yes	Yes
	Alarms	Yes	Yes
	Recent events	Yes	Yes
	Cluster monitoring metrics (DMS)	Yes	Yes
Cluster management	Monitoring panel (DMS)	Yes	Yes
	Monitoring metrics (Cloud Eye)	Yes	Yes
	Restart	Yes	Yes
	Scaling	Yes	Yes
	Redistributing data	Yes	Yes
	Viewing redistribution details	Yes	Yes
	Resetting passwords	Yes	Yes
	Creating snapshots	Yes	Yes
	Canceling read-only status	Yes	Yes
	Deletion	Yes	Yes
	Managing CNs	Yes	Yes
	Storage space scaling	Yes	Yes
Basic Information	Basic information	Yes	Yes
	ELB	Yes	Yes
	Resource pool	Yes	Yes
	Logical cluster	Yes	Yes
	Snapshot	Yes	Yes
	Parameter modifications	Yes	Yes
	Security settings	Yes	Yes
	MRS data sources	Yes	Yes
	Monitoring Panel	Yes	Yes
	Tags	Yes	Yes
	Node management	Yes	Yes
DR management	DR management	Yes	No
Snapshot management	Restoration	Yes	Yes
	Deletion	Yes	Yes
	Copy	Yes	Yes
Incident management	Event management (general)	Yes	Yes
Alarm management	Alarm management	Yes	Yes
Client connections	Client connections	Yes	Yes
Others	Inspection	Yes	Yes
	Intelligent O&M	Yes	Yes
	Node restoration	Yes	Yes
	Warm backup on the tenant side	Yes	Yes
	OpenApi	Yes	No

**Table 2** Database operations
Type	Syntax	Supported
Basic functions	CREATE TABLE	Yes
	CREATE TABLE LIKE	Yes
	DROP TABLE	Yes
	INSERT	Yes
	COPY	Yes
	SELECT	Yes
	TRUNCATE	Yes
	EXPLAIN	Yes
	ANALYZE	Yes
	VACUUM	Yes
	ALTER TABLE DROP PARTITION	Yes
	ALTER TABLE ADD PARTITION	Yes
	ALTER TABLE SET WITH OPTION	Yes
	ALTER TABLE DROP COLUMN	Yes
	ALTER TABLE ADD COLUMN	Yes
	ALTER TABLE ADD NODELIST	Yes
	ALTER TABLE CHANGE OWNER	Yes
	ALTER TABLE RENAME COLUMN	Yes
	ALTER TABLE TRUNCATE PARTITION	Yes
	Other ALTER TABLE syntax	Yes
	CREATE INDEX	Yes
	DROP INDEX	Yes
	DELETE	Yes
	ALTER INDEX	Yes
	MERGE	Yes
	SELECT INTO	Yes
	UPDATE	Yes
	CREATE TABLE AS	Yes
	Webhook	No
	PRIMARY KEY	Yes
	UNIQUE CONSTRAINT	Yes
	UNLOG tables	Yes
	Custom types	No
	Explicit cursors	Yes
Transaction capability	Sub-transactions	Yes
Transaction capability	Transaction Isolation Levels	Yes
Advanced functions	Materialized views	No
	Stored procedures	No
	AUTO VACUUM	Yes
	AUTO ANALYZE	Yes
	GIS	No

**Table 3** Data types supported by column-store tables
Category	Data Type	Description	Length
Numeric Type	smallint	Small integer, also called INT2	2
	integer	Typical choice for integer, also called INT4	4
	bigint	Big integer, also called INT8	8
	decimal	Arbitrary precision type	Variable length
	numeric	Arbitrary precision type	Variable length
	real	Single-precision floating point	4
	double precision	Double-precision floating point	8
	smallserial	Two-byte auto-incrementing integer	2
	serial	Four-byte auto-incrementing integer	4
	bigserial	Eight-byte auto-incrementing integer	8
Monetary Type	money	Currency amount	8
Character Type	character varying(n), varchar(n)	Variable-length string	Variable length
	character(n), char(n)	Fixed-length string	n
	character, char	Single-byte internal type	1
	text	Variable-length string	Variable length
	nvarchar2	Variable-length string	Variable length
	clob	A big text object	Variable length
Date/Time Type	timestamp with time zone	Date and time (with time zone)	8
	timestamp without time zone	Date and time	8
	date	Date and time (Oracle compatibility mode); date (other compatibility modes)	When using Oracle compatibility mode, the storage space is 8 bytes, whereas in other compatibility modes, it is 4 bytes.
	time without time zone	Time within one day.	8
	time with time zone	Time within one day (with time zone)	12
	interval	Time interval	16