[Bug] UNIQUE index must contain all columns in the table's distribution key

[congxuebin]

Cloudberry Database version

No response

What happened

gpadmin=# CREATE TABLE sto_uao_neg_index (id int, date date, amt decimal(10,2))

with (appendonly=true, orientation=column)

DISTRIBUTED BY (id);

CREATE TABLE

gpadmin=# drop index if exists uni_index;

NOTICE:  index "uni_index" does not exist, skipping

DROP INDEX

gpadmin=# CREATE UNIQUE INDEX uni_index ON sto_uao_neg_index (date);

ERROR:  UNIQUE index must contain all columns in the table's distribution key

What you think should happen instead

ERROR:  append-only tables do not support unique indexes

How to reproduce

Please see info as above

Operating System

centos7

Anything else

UAOCSDDLTestCase.test_neg_uao_index in cbdbtestrepo failed

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct.

[congxuebin]

According to Yifan's note, this is incompatible change. Closing it.