blob: cc52d2a83343fe46c092873c7e89a6b661e137b9 [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 NOT 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
9// Negative test
10
11drop dataverse test if exists;
12create dataverse test;
13use dataverse test;
14
15write output to nc1:"rttest/btree-index_btree-primary-09.adm";
16
17create type TestType as open {
18 fname : string,
19 lname : string
20}
21
ramangrover29669d8f62013-02-11 06:03:32 +000022create dataset testdst(TestType) primary key fname,lname;
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +000023
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +000024for $emp in dataset('testdst')
25where $emp.fname = "Julio" or $emp.lname = "Malaika"
26return $emp