blob: 079f30cba59a414021de9ba3456e2bfa57c2d12b [file] [log] [blame]
/*
* Description : This test is intended to verify that the primary BTree index is used
* : in the optimized query plan.
* Expected Result : Success
* Date : 13th Aug 2012
*/
// Positive test - prefix search, BTree index should be used in query plan
drop dataverse test if exists;
create dataverse test;
use dataverse test;
write output to nc1:"rttest/btree-index_btree-primary-04.adm";
create type TestType as open {
fname : string,
lname : string
}
// create internal dataset with primary index defined on fname,lname fields
create dataset testdst(TestType) primary key fname,lname;
for $emp in dataset('testdst')
where $emp.fname <= "Vanpatten"
return $emp