citusdata / citusdata/citus

mark_tables_colocated returns unintelligible error message when run against range/append tables

Open
#1,776 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

- created to range distributed tables (r1 and r2) with the same schema (a int, b int)
- distributed on the same column (a)
- created an empty shard for each table
- set min/max ranges for each shard to be same (1, 10)
- moved shards to a same node
- run mark_tables_colocated function

got
```
select mark_tables_colocated('r1', ARRAY['r2'::regclass]);
ERROR: cannot colocate tables r1 and r2
DETAIL: Shard intervals don't match for r1 and r2.
```

Related to #1329

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.