blob: fdddf92968b1f206d55a59657adda12d62fbdd43 [file] [log] [blame]
-- Given a create table specifying a constraint
create table exclusion_constraints_t1(a int, b int, EXCLUDE (a WITH =));
ERROR: GPDB does not support exclusion constraints.
-- Then we errored out
-- Given a create partition table table specifying a constraint
create table exclusion_constraints_pt1(a int, b int, EXCLUDE (b WITH =)) partition by range(a) (start(1) end(4) every(1));
ERROR: GPDB does not support exclusion constraints.
-- Then we errored out
-- Given a table without constraints
create table exclusion_constraints_t2(a int, b int);
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Apache Cloudberry data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
-- And we alter table to add constraints
ALTER TABLE exclusion_constraints_t2 ADD CONSTRAINT constraint_on_t2 EXCLUDE USING btree (b WITH =);
ERROR: GPDB does not support exclusion constraints.
-- Then we errored out