citusdata / citusdata/citus

Join with Condition on Money Column Fails

Open
#4,281 4 comments 0 reactions 0 assignees View on GitHub
bug sqlancer
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

```
SET citus.enable_repartition_joins to ON;

CREATE TABLE dist1(a INT, b money);
SELECT create_distributed_table('dist1', 'a');

CREATE TABLE dist2(a INT, b money);
SELECT create_distributed_table('dist2', 'a');

SELECT * FROM dist1, dist2 WHERE (dist1.b = dist2.b);

ERROR: cache lookup failed for opclass 0
CONTEXT: while executing command on localhost:9701
```
This query does not fail when the `b` columns are of type `INT`.

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.