Addressed comments & added more tests
git-svn-id: https://asterixdb.googlecode.com/svn/branches/asterix_stabilization@671 eaa15691-b419-025a-1212-ee371bd00084
diff --git a/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-secondary-45.aql b/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-secondary-45.aql
index 02723cb..9d1024f 100644
--- a/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-secondary-45.aql
+++ b/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-secondary-45.aql
@@ -1,7 +1,7 @@
/*
- * Description : BTree Index verification (usage) test
+ * Description : BTree Index verification 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).
+ * : in the optimized query plan.
* Expected Result : Success
* Date : 13th Aug 2012
*/
@@ -18,20 +18,14 @@
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