blob: 1c6b312b553c10b4425533269f0592c8073f6666 [file] [log] [blame]
salsubaieebb167912013-12-21 12:55:52 -08001/*
2 * Description : Notice the query hint to avoid using any secondary index to evaluate the predicate in the where clause
3 * Expected Res : Success
4 * Date : 21th December 2013
5 */
6
7drop dataverse test if exists;
8create dataverse test;
9
10use dataverse test;
11
12create type MyRecord as closed {
13 id: int32,
14 point: point,
15 kwds: string,
16 line1: line,
17 line2: line,
18 poly1: polygon,
19 poly2: polygon,
20 rec: rectangle,
21 circle: circle
22}
23
24create dataset MyData(MyRecord)
25 primary key id;
26
27create index rtree_index_point on MyData(point) type rtree;
28
29delete $m from dataset MyData /*+ skip-index */ where spatial-intersect($m.point, create-polygon([0.0,1.0,0.0,4.0,12.0,4.0,12.0,1.0]));