citusdata / citusdata/citus

single row insert fails silently on append tables when distributed on a composite type

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

Description

- create a composite type on master and workers
- create an append distributed table, distribute on a composite typed column
- create an empty shard
- try to insert a single row
- no error message, but no rows inserted either.

Tested this scenario with
1 - local table with the same definition --> works
2 - distributed table with regular partition column --> works

```sql
create table ptt(a ct, b int);
select run_command_on_workers('create type ct as (a int, b int)');
select create_distributed_table('ptt', 'a', 'append');
select master_create_empty_shard('ptt');
insert into ptt values ( (1,1)::ct, 2);
-- Result
-- INSERT 0 0
```

It is most likely related to missing min/max functions for the type

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.