asterix-app/src/test/resources/optimizerts/queries/skip-index/skip-rtree-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 MyRecord as closed {
  id: int32,
  point: point,
  kwds: string,
  line1: line,
  line2: line,
  poly1: polygon,
  poly2: polygon,
  rec: rectangle,
  circle: circle
}

create dataset MyData(MyRecord)
  primary key id;

create index rtree_index_point on MyData(point) type rtree;

delete $m from dataset MyData where /*+ skip-index */ spatial-intersect($m.point, create-polygon([0.0,1.0,0.0,4.0,12.0,4.0,12.0,1.0]));