[YSQL] Unexpected error " unexpected varattno 5 in expression to be mapped" after columns are dropped in table and a new partition is added

[ajcaldera1]

Jira Link: DB-11292

Description

Given the following schema:

create table part_column_drop (
  useless_1 int,
  id int,
  useless_2 int,
  d int,
  b int,
  useless_3 int
) partition by range (id);

If I apply the following script to it that drops the 'useless_x' columns and adds a secondary partial index, and then add partition to the table, I get a "unexpected varattno 5 in expression to be mapped" error.

Script:

alter table part_column_drop drop column useless_1;
alter table part_column_drop drop column useless_2;
alter table part_column_drop drop column useless_3;
create index part_column_drop_b_pred on part_column_drop(b) where b = 1;
create table part_column_drop_1_10 partition of part_column_drop for values from (1) to (10);

Output:

create table part_column_drop (
  useless_1 int,
  id int,
  useless_2 int,
  d int,
  b int,
  useless_3 int
) partition by range (id);
CREATE TABLE
alter table part_column_drop drop column useless_1;
ALTER TABLE
alter table part_column_drop drop column useless_2;
ALTER TABLE
alter table part_column_drop drop column useless_3;
ALTER TABLE
create index part_column_drop_b_pred on part_column_drop(b) where b = 1;
CREATE INDEX
create table part_column_drop_1_10 partition of part_column_drop for values from (1) to (10);
ysqlsh:z.sql:20: ERROR:  unexpected varattno 5 in expression to be mapped

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.