blob: 0d81301dadd17cda6b29b53a941d6ba16f20f895 [file] [log] [blame]
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +00001/*
khfaraaz82@gmail.comc9db98e2012-08-21 00:08:58 +00002 * Description : BTree Index verification test
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +00003 * : This test is intended to verify that the primary BTree index is used
khfaraaz82@gmail.comc9db98e2012-08-21 00:08:58 +00004 * : in the optimized query plan.
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +00005 * Expected Result : Success
6 * Date : 13th Aug 2012
7 */
8
9drop dataverse test if exists;
10create dataverse test;
11use dataverse test;
12
13write output to nc1:"rttest/btree-index_btree-primary-15.adm";
14
15create type TestType as open {
16 fname : string,
17 lname : string
18}
19
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +000020create dataset testdst(TestType) partitioned by key fname,lname;
21
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +000022load dataset testdst
23using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
24(("path"="nc1://data/fn-ln.adm"),("format"="delimited-text"),("delimiter"="|"));
25
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +000026for $emp in dataset('testdst')
27where $emp.fname > "Craig" and $emp.lname > "Kevin" and $emp.fname < "Mary" and $emp.lname < "Tomes"
28return $emp