Misleading cartesian products error on repartition queries
Open
usability
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
On a repartition query, if data types of the equality don't match, we error out with an unrelated error message.
```sql
CREATE TABLE testA (id int, valueInt int, valueBigint bigint);
CREATE TABLE testB (id int, valueInt int, valueBigint bigint);
SELECT create_distributed_table('testA', 'id');
SELECT create_distributed_table('testB', 'id');
SELECT count(*) FROM testA, testB WHERE testA.id = testB.valueBigint;
```
```sql
ERROR: cannot perform distributed planning on this query
DETAIL: Cartesian products are currently unsupported
```
Contributor guide
Assessment
This issue has not been assessed yet.