Intermediate result has invalid oidvector data
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
In the very peculiar case of including an oidvector type in a subquery that involves a distributed table:
```SQL
-- dist_table is any distributed table
SELECT * FROM(
SELECT
(SELECT count(*) FROM dist_table),
proargtypes
FROM
pg_catalog.pg_proc) as subq_0;
ERROR: invalid oidvector data
DETAIL: on server postgres@localhost:9701
```
Error coming from worker node:
```
NOTICE: executing the command locally: SELECT count, proargtypes FROM
(SELECT intermediate_result.count, intermediate_result.proargtypes
FROM read_intermediate_result('111_2'::text, 'binary'::citus_copy_format)
intermediate_result(count bigint, proargtypes oidvector)) subq_0
ERROR: invalid oidvector data
```
Contributor guide
Assessment
This issue has not been assessed yet.