GAUSS-00901 -- GAUSS-00910

Updated on 2023-12-22 GMT+08:00

View PDF

GAUSS-00901: "tables in ALTER TABLE EXCHANGE PARTITION must have the same column/row storage"

SQLSTATE: 0A000

Description: One of the tables specified in the ALTER TABLE EXCHANGE PARTITION statement uses row storage and the other uses column storage.

Solution: Ensure that tables specified in the ALTER TABLE EXCHANGE PARTITION statement use the same storage mode.

GAUSS-00902: "tables in ALTER TABLE EXCHANGE PARTITION must have the same type of compress"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement use different compression types.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same compression type. Otherwise, the statement cannot be performed.

GAUSS-00903: "tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different numbers of columns.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same number of columns. Otherwise, the statement cannot be performed.

GAUSS-00904: "column name mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION have different column names.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column name. Otherwise, the statement cannot be performed.

GAUSS-00905: "column type or size mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column types or sizes.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column type and size. Otherwise, the statement cannot be performed.

GAUSS-00906: "column not null constraint mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different NOT NULL column attributes.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same NOT NULL column attribute. Otherwise, the statement cannot be performed.

GAUSS-00907: "column default constraint mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different default column constraints.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same default constraint of columns. Otherwise, the statement cannot be performed.

GAUSS-00908: "column collation mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column orders.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the column order. Otherwise, the statement cannot be performed.

Example:

postgres=# create table t3 (a int,b text collate "C")
postgres-# with (orientation = column,compression=middle)
postgres-# distribute by hash (a);
CREATE TABLE
postgres=# create table t4 (a int,b text)
postgres-# with (orientation = column,compression=middle)
postgres-# distribute by hash (a)
postgres-# partition by range(b)(
postgres(# partition p1 values less than('a'),
postgres(# partition p2 values less than('h'),
postgres(# partition p3 values less than(maxvalue));
CREATE TABLE
postgres=# alter table t4 exchange partition (p3) with table t3;
ERROR:  column collation mismatch in ALTER TABLE EXCHANGE PARTITION

GAUSS-00909: "column storage mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column storage settings.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column storage setting. Otherwise, the statement cannot be performed.

GAUSS-00910: "the type of column compress mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column compression types.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same compression type. Otherwise, the statement cannot be performed.

Parent topic: GAUSS-00901 -- GAUSS-01000

Previous topic: GAUSS-00901 -- GAUSS-01000

Next topic: GAUSS-00911 -- GAUSS-00920