blob: dea4276ee36e97e03da398c23eea3656bfb022cf [file] [log] [blame]
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +00001/*
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -08002 * Description : BTree Index verification test
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +00003 * : This test is intended to verify that the secondary BTree index is used
khfaraaz82@gmail.comc9db98e2012-08-21 00:08:58 +00004 * : in the optimized query plan.
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +00005 * Expected Result : Success
6 * Date : 13th Aug 2012
7 */
8
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -08009// Please note this is a Positive test and the BTree index should be used in the plan.
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000010
11drop dataverse test if exists;
12create dataverse test;
13use dataverse test;
14
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -080015write output to nc1:"rttest/btree-index_btree-primary-33.adm";
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000016
17create type TestType as open {
18 id : int32,
19 fname : string,
20 lname : string
21}
22
ramangrover29669d8f62013-02-11 06:03:32 +000023create dataset testdst(TestType) primary key id;
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000024
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000025create index sec_Idx on testdst(fname,lname);
26
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000027for $emp in dataset('testdst')
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -080028where $emp.fname > "Roger"
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000029return $emp