blob: d98636ca0083061649ae13ea9288ef24fea27a5b [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
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -08003 * : This test is intended to verify that the primary BTree index is 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
Ildar Absalyamovc70c06a2014-11-11 16:37:04 -08009// Positive test - prefix search
khfaraaz82@gmail.com71e71482012-08-18 00:25:07 +000010
11drop dataverse test if exists;
12create dataverse test;
13use dataverse test;
14
15write output to nc1:"rttest/btree-index_btree-primary-13.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" and $emp.lname < "Xu"
26return $emp