/* | |
* Description : BTree Index verification test | |
* : This test is intended to verify that the primary BTree index is used | |
* : in the optimized query plan. | |
* Expected Result : Success | |
* Date : 11th Nov 2014 | |
*/ | |
// Positive test - prefix search | |
drop dataverse test if exists; | |
create dataverse test; | |
use dataverse test; | |
write output to nc1:"rttest/btree-index_btree-primary-32.adm"; | |
create type TestType as open { | |
fname : string, | |
lname : string | |
} | |
create dataset testdst(TestType) primary key fname,lname; | |
for $emp in dataset('testdst') | |
where $emp.fname < "Julio" and $emp.lname = "Xu" | |
return $emp |