blob: 86c4f843f742ccbdd63eb6cd2478c0d6c3f24655 [file] [log] [blame]
/*
* Description : BTree Index verification (usage) test
* : This test is intended to verify that the secondary BTree index is used
* : in the optimized query plan for predicates like (predicate1 and predicate2 and predicate3 and predicate4).
* Expected Result : Success
* Date : 13th Aug 2012
*/
drop dataverse test if exists;
create dataverse test;
use dataverse test;
write output to nc1:"rttest/btree-index_btree-secondary-46.adm";
create type TestType as open {
id : int32,
fname : string,
lname : string
}
// create internal dataset
create dataset testdst(TestType) partitioned by key id;
// create secondary index
create index sec_Idx on testdst(fname,lname);
// load valid data with fname and lname entries
load dataset testdst
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1://data/id-fn-ln.adm"),("format"="delimited-text"),("delimiter"="|"));
// Query the data that was loaded above.
for $emp in dataset('testdst')
where $emp.fname >= "Craig" and $emp.lname >= "Kevin" and $emp.fname <= "Mary" and $emp.lname <= "Tomes"
return $emp