asterix-app/src/test/resources/optimizerts/queries/skip-index/skip-secondary-btree-index-search-in-delete.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;

create type AddressType as closed {
  number: int32, 
  street: string,
  city: string
}

create type CustomerType as closed {
  cid: int32, 
  name: string,
  age: int32,
  address: AddressType?,
  interests: {{string}},
  children: [ { name: string, age: int32? } ]
}

create dataset Customers(CustomerType) primary key cid;

create index age_index on Customers(age);

delete $c from dataset Customers where $c.age /*+ skip-index */ < 20;