Skip to content
This repository has been archived by the owner on Jun 18, 2024. It is now read-only.

Possible incorrect computation of scanCols in UPDATE #12

Open
soumyadeep2007 opened this issue Jun 24, 2020 · 0 comments
Open

Possible incorrect computation of scanCols in UPDATE #12

soumyadeep2007 opened this issue Jun 24, 2020 · 0 comments
Labels

Comments

@soumyadeep2007
Copy link

This is a thread for collecting cases where scanCols is wrongly computed for UPDATE.

Case 1:

drop table if exists t1;
create table t1(a int, b int);
insert into t1 values(2,1);
analyze t1;
drop table if exists t2;
create table t2(a int, b int, c int);
insert into t2 select i, i%2, i from generate_series(1,5)i;
insert into t2 select i, i, i from generate_series(1,5)i;
analyze t2;
UPDATE t2 SET b = 2 WHERE a = (SELECT a FROM t1);
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

1 participant