Updating a local table with a subquery errors out
Open
bug
dev_reported
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Updating a local table with a subquery errors out. This is what we do under the hood so technically we should support this as well.
```sql
UPDATE local set a =5 FROM (SELECT * FROM dist_table) dist WHERE local.a
= dist.b;
ERROR: relation local is not distributed
Time: 0.991 ms
```
Contributor guide
Assessment
This issue has not been assessed yet.