single row insert fails silently on append tables when distributed on a composite type
- 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
Assessment
This issue has not been assessed yet.