asterix-app/src/test/resources/optimizerts/queries/skip-index/skip-secondary-btree-index-2.aql

/*
 * Description  : Notice the query hint to avoid using any secondary index to evaluate the predicate in the where clause
 * Expected Res : Success
 * Date         : 21th December 2013
 */

drop dataverse test if exists;
create dataverse test;
use dataverse test;

write output to nc1:"rttest/btree-index_btree-secondary-57.adm";

create type TestType as open {
    id : int32,
    fname : string,
    lname : string
}

create dataset testdst(TestType) primary key id;

create index sec_Idx on testdst(fname);

for $emp in dataset('testdst') 
where $emp.fname /*+ skip-index */ >= "Max" and $emp.fname <= "Roger" 
return $emp