asterix-app/src/test/resources/runtimets/queries/dml/drop-empty-secondary-indexes.aql

/*
 * Description     : Drop empty secondary index.
 * Expected Result : Success
 * Date            : 8th Feb 2013
 *
 */

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

create type TestType as open {
id : int32,
name : string,
locn : point,
zip : string
}

create dataset t1(TestType) partitioned by key id;

create index rtree_index_point on t1(locn) type rtree;

create index keyWD_indx on t1(name) type keyword;

create index secndIndx on t1(zip);

drop index t1.rtree_index_point;

drop index t1.keyWD_indx;

drop index t1.secndIndx;

for $l in dataset('Metadata.Index')
where $l.IsPrimary=false
return $l;