PITR : Catalog not getting updated when we create index and restore to previous snapshot.

[sonalsagarwal]

Jira Link: DB-2388

ycqlsh> create index testidx on yb_pitr_test.employees(salary);
ycqlsh> describe yb_pitr_test.employees

CREATE TABLE yb_pitr_test.employees (
    employee_no int PRIMARY KEY,
    name text,
    department text,
    salary int
) WITH default_time_to_live = 0
    AND transactions = {'enabled': 'true'};
CREATE INDEX testidx ON yb_pitr_test.employees (name, employee_no)
    WITH transactions = {'enabled': 'true'};
ycqlsh> explain select * from yb_pitr_test.employees where name='John Zimmerman' ;

 QUERY PLAN
-----------------------------------------------------------------
 Index Scan using yb_pitr_test.testidx on yb_pitr_test.employees
   Key Conditions: (name = 'John Zimmerman')                    

Restore to previous version :

bin/yb-admin -master_addresses=172.151.20.139,172.151.23.237,172.151.31.9 restore_snapshot_schedule e0239f77-2281-4a37-8ea5-4a7278fe98d8 minus 1m

The describe on keyspace still shows the index, but query on table doesnot show usage of index. When we create an index with same name, it gets created successfully, and describe keyspace also shows the information for new index.
The restore is working properly, just that the describe information is not updated after restore.

ycqlsh> describe yb_pitr_test.employees

CREATE TABLE yb_pitr_test.employees (
    employee_no int PRIMARY KEY,
    name text,
    department text,
    salary int
) WITH default_time_to_live = 0
    AND transactions = {'enabled': 'true'};
CREATE INDEX testidx ON yb_pitr_test.employees (name, employee_no)
    WITH transactions = {'enabled': 'true'};
ycqlsh> explain select * from yb_pitr_test.employees where name='John Zimmerman' ;

 QUERY PLAN
-------------------------------------
 Seq Scan on yb_pitr_test.employees 
   Filter: (name = 'John Zimmerman')


ycqlsh> create index testidx on yb_pitr_test.employees(salary);
ycqlsh> describe yb_pitr_test.employees

CREATE TABLE yb_pitr_test.employees (
    employee_no int PRIMARY KEY,
    name text,
    department text,
    salary int
) WITH default_time_to_live = 0
    AND transactions = {'enabled': 'true'};
CREATE INDEX testidx ON yb_pitr_test.employees (salary, employee_no)
    WITH transactions = {'enabled': 'true'};