citusdata / citusdata/citus

Unexpected "cannot switch local execution status" error when querying two different dist tables

Open
#5,388 1 comment 1 reaction 0 assignees View on GitHub
bug dev_reported mx single node
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

```sql
-- single node, fwiw

create table d1(a int);
create table d2(a int);
SELECT create_distributed_table('d1','a');
SELECT create_distributed_table('d2','a');

begin;
select * from d1;
explain select * from d1;
select * from d2;
ERROR: cannot switch local execution status from local execution required to local execution disabled since it can cause visibility problems in the current transaction
```

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.