GAUSS-00901 -- GAUSS-00910
GAUSS-00901: “tables in ALTER TABLE EXCHANGE PARTITION must have the same column/row storage”
SQLSTATE: 0A000
Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement use both row and 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.
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.
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.
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.
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.
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 column constraint.
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 same column order.
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.
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.