blob: 5b09c492d77a92dfe1cc5ee9ad88a2b373868738 [file] [log] [blame]
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +00001/*
2 * Description : BTree Index verification (usage) test
3 * : This test is intended to verify that the primary BTree index is NOT used
4 * : in the optimized query plan for predicates like the one used in this test.
5 * 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-11.adm";
14
15create type TestType as open {
16 fname : string,
17 lname : string
18}
19
20// create internal dataset with primary index defined on fname,lname fields
21create dataset testdst(TestType) partitioned by key fname,lname;
22
23// load valid data with fname and lname entries
24
25load dataset testdst
26using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
27(("path"="nc1://data/fn-ln.adm"),("format"="delimited-text"),("delimiter"="|"));
28
29// Query the data that was loaded above.
30
31for $emp in dataset('testdst')
32where $emp.fname > "Allan" and $emp.lname < "Zubi"
33return $emp