1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
t = db.geo_box1;
t.drop();
num = 0;
for ( x=0; x<=20; x++ ){
for ( y=0; y<=20; y++ ){
o = { _id : num++ , loc : [ x , y ] };
t.save( o );
}
}
t.ensureIndex( { loc : "2d" } );
searches = [
[ [ 1 , 2 ] , [ 4 , 5 ] ] ,
[ [ 1 , 1 ] , [ 2 , 2 ] ] ,
[ [ 0 , 2 ] , [ 4 , 5 ] ] ,
[ [ 1 , 1 ] , [ 2 , 8 ] ] ,
];
for ( i=0; i<searches.length; i++ ){
b = searches[i];
//printjson( b );
q = { loc : { $within : { $box : b } } };
numWanetd = ( 1 + b[1][0] - b[0][0] ) * ( 1 + b[1][1] - b[0][1] );
assert.eq( numWanetd , t.find(q).itcount() , "itcount: " + tojson( q ) );
printjson( t.find(q).explain() );
}
assert.eq( 0 , t.find( { loc : { $within : { $box : [ [100 , 100 ] , [ 110 , 110 ] ] } } } ).itcount() , "E1" );
assert.eq( 0 , t.find( { loc : { $within : { $box : [ [100 , 100 ] , [ 110 , 110 ] ] } } } ).count() , "E2" );
assert.eq( num , t.find( { loc : { $within : { $box : [ [ 0 , 0 ] , [ 110 , 110 ] ] } } } ).count() , "E3" );
assert.eq( num , t.find( { loc : { $within : { $box : [ [ 0 , 0 ] , [ 110 , 110 ] ] } } } ).itcount() , "E4" );
assert.eq( 57 , t.find( { loc : { $within : { $box : [ [ 0 , 0 ] , [ 110 , 110 ] ] } } } ).limit(57).itcount() , "E5" );
// SERVER-13621
// Eetect and invert the $box coordinates when they're specified incorrectly.
assert.eq( num , t.find( { loc : { $within : { $box : [ [ 110 , 110 ], [ 0 , 0 ] ] } } } ).count() , "E5" );
assert.eq( num , t.find( { loc : { $within : { $box : [ [ 110 , 0 ], [ 0 , 110 ] ] } } } ).count() , "E6" );
assert.eq( num , t.find( { loc : { $within : { $box : [ [ 0 , 110 ], [ 110 , 0 ] ] } } } ).count() , "E7" );
|
