citusdata / citusdata/citus

Intermediate result has invalid oidvector data

Open
#8,160 2 comments 0 reactions 0 assignees View on GitHub
backlog sqlsmith
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

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.