blob: a771083113c2bf759ce61db0d24357ff945b655c [file] [log] [blame]
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +00001/*
khfaraaz82@gmail.comc9db98e2012-08-21 00:08:58 +00002 * Description : BTree Index verification test
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -08003 * : This test is intended to verify that the secondary BTree index is NOT used
4 * : 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// Negative test - BTree index should NOT be used in query plan
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000010
11drop dataverse test if exists;
12create dataverse test;
13use dataverse test;
14
15write output to nc1:"rttest/btree-index_btree-secondary-37.adm";
16
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 != "Max"
khfaraaz82@gmail.com552e4c82012-08-19 07:37:50 +000029return $emp