Join with Condition on Money Column Fails
Open
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
Assessment
This issue has not been assessed yet.