[YSQL] Table with identifier not found: OBJECT_NOT_FOUND when done ALTER INDEX OWNER TO role

[dhruva4869]

Jira Link: DB-18750

Description

Version: 2.29.0.0-b59
Steps-

yugabyte=# create table foo(id int, primary key(id));
CREATE TABLE
yugabyte=# \d foo
                Table "public.foo"
 Column |  Type   | Collation | Nullable | Default 
--------+---------+-----------+----------+---------
 id     | integer |           | not null | 
Indexes:
    "foo_pkey" PRIMARY KEY, lsm (id HASH)

yugabyte=# alter index foo_pkey OWNER TO test_role_4;
ERROR:  Table with identifier 000033cf000030008000000000004003 not found: OBJECT_NOT_FOUND

This also fails in 2024.2.

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.