t

(1 row)

/* RuntimeAppend (check that dropped columns don't break tlists) */

create table test.dropped_cols(val int4 not null);

select pathman.create_hash_partitions('test.dropped_cols', 'val', 4);

create_hash_partitions

------------------------

4

(1 row)

insert into test.dropped_cols select generate_series(1, 100);

alter table test.dropped_cols add column new_col text;/* add column */

alter table test.dropped_cols drop column new_col;/* drop column! */

explain (costs off) select * from generate_series(1, 10) f(id), lateral (select count(1) FILTER (WHERE true) from test.dropped_cols where val = f.id) c;

QUERY PLAN

-----------------------------------------------------------

Nested Loop

-> Function Scan on generate_series f

-> Aggregate

-> Custom Scan (RuntimeAppend)

Prune by: (dropped_cols.val = f.id)

-> Seq Scan on dropped_cols_0 dropped_cols

Filter: (val = f.id)

-> Seq Scan on dropped_cols_1 dropped_cols

Filter: (val = f.id)

-> Seq Scan on dropped_cols_2 dropped_cols

Filter: (val = f.id)

-> Seq Scan on dropped_cols_3 dropped_cols

Filter: (val = f.id)

(13 rows)

drop table test.dropped_cols cascade;

NOTICE: drop cascades to 4 other objects

set enable_hashjoin = off;

set enable_mergejoin = off;

select from test.runtime_test_4

selectcount(*)=0frompathman.pathman_partition_list

where parent='test.runtime_test_4'::regclassand coalesce(range_min::int,1)<0;

createtabletest.dropped_cols(val int4not null);

selectpathman.create_hash_partitions('test.dropped_cols','val',4);

insert intotest.dropped_colsselect generate_series(1,100);

altertabletest.dropped_cols add column new_coltext;/* add column*/

altertabletest.dropped_cols drop column new_col;/* drop column!*/

explain (costs off)select*from generate_series(1,10) f(id), lateral (selectcount(1) FILTER (WHERE true)fromtest.dropped_colswhere val=f.id) c;

droptabletest.dropped_cols cascade;

set enable_hashjoin= off;

set enable_mergejoin= off;

foreach (lc1,pulled_vars)

{

Var*tlist_var= (Var*)lfirst(lc1);

Var*tlist_var= (Var*)lfirst(lc1);

boolfound_column= false;

AttrNumberattnum;

AttrNumberattnum=0;

if (tlist_var->varattno<InvalidAttrNumber)

continue;

attnum=0;

foreach (lc2,appinfo->translated_vars)

{

Var*translated_var= (Var*)lfirst(lc2);

attnum++;

if (!translated_var)

continue;

if (translated_var->varattno==tlist_var->varattno)

{

tlist_var->varattno=attnum;

found_column= true;/* successful mapping */

}

}

if (!found_column)

elog(ERROR,

"table \"%s\" has no attribute %d of partition \"%s\"",

get_rel_name_or_relid(appinfo->parent_relid),

tlist_var->varoattno,

get_rel_name_or_relid(appinfo->child_relid));

}

ChangeVarNodes((Node*)temp_tlist,