blob: 7c155ce28fc423578c3a50678cc575f609c749fc [file] [log] [blame]
/*
* Description : BTree Index verification test
* : This test is intended to verify that the secondary BTree index is NOT used in the optimized query plan.
* Expected Result : Success
* Date : 13th Aug 2012
*/
// THE BTREE INDEX IN THIS CASE SHOULD NOT BE PICKED UP!!!!
// Verify that the optimized query plan does not have the BTree search
drop dataverse test if exists;
create dataverse test;
use dataverse test;
write output to nc1:"rttest/btree-index_btree-secondary-37.adm";
create type TestType as open {
id : int32,
fname : string,
lname : string
}
create dataset testdst(TestType) primary key id;
create index sec_Idx on testdst(fname,lname);
for $emp in dataset('testdst')
where $emp.lname = "Kim"
return $emp