citusdata / citusdata/citus

Collation Mismatch Between Explicit Collations

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

Description

``` SQL
CREATE TABLE tbl(a INT);
SELECT create_distributed_table('tbl', 'a');

SELECT * FROM tbl WHERE ('A' COLLATE "en_US.utf8") != 1::MONEY::VARCHAR(1);

ERROR: collation mismatch between explicit collations "en_US.utf8" and "default"
CONTEXT: while executing command on localhost:9701
```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the SQL example against a distributed table and compare the behavior with the equivalent non-distributed query. Investigate how the explicit en_US.utf8 and default collations are handled when comparing the VARCHAR expression with the converted MONEY value; done means the intended comparison behavior is established without the reported collation mismatch.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, sql
Domain
databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.