Error when caching table having composite index
Main Memory Database Cache
Brought to you by:
prabatuty
Scenario :
create table t1(f1 int , f2 int,f3 int,f4 char(10),primary key(f1,f2));
create index ix2 on t1(f3,f4); in target database
Cache the table.
It fails saying
22006:3086808784:CatalogTables.cxx:240:Index with name 't1_ix2' already exists on the table 't1'.
22006:3086808784:DatabaseManagerImpl.cxx:905:Catalog table updation failed in INDEX table
22006:3086808784:CacheTableLoader.cxx:403:Index creation failed in csql for t1
It should cache without any error
Test Script test/cache/Recovery/test006.ksh