Kouhei Sutou
null+****@clear*****
Tue Dec 10 23:46:58 JST 2013
Kouhei Sutou 2013-12-10 23:46:58 +0900 (Tue, 10 Dec 2013) New Revision: 367886709ae8844173a4b66d3606f7fd674773dd https://github.com/groonga/groonga/commit/367886709ae8844173a4b66d3606f7fd674773dd Message: test geo_in_rectangle: add tests for all areas around 180 point with index use Now, geo_in_rectangle() supports the world! Added files: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/all_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/all_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_west_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_east_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_east_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_south_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_south_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_west_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/same_as_mesh.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/same_as_mesh.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_east_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_east_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_west_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/west_out.test Modified files: lib/geo.c Modified: lib/geo.c (+4 -2) =================================================================== --- lib/geo.c 2013-12-10 23:40:04 +0900 (a2b38b2) +++ lib/geo.c 2013-12-10 23:46:58 +0900 (d9f9524) @@ -1309,8 +1309,10 @@ extract_rectangle_in_area(grn_ctx *ctx, grn_bool out_of_area = GRN_FALSE; grn_bool cover_all_areas = GRN_FALSE; - if (GRN_GEO_POINT_IN_NORTH_WEST(top_left) && - GRN_GEO_POINT_IN_SOUTH_EAST(bottom_right)) { + if ((GRN_GEO_POINT_IN_NORTH_WEST(top_left) && + GRN_GEO_POINT_IN_SOUTH_EAST(bottom_right)) || + (GRN_GEO_POINT_IN_NORTH_EAST(top_left) && + GRN_GEO_POINT_IN_SOUTH_WEST(bottom_right))) { cover_all_areas = GRN_TRUE; } Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/all_out.expected (+129 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/all_out.expected 2013-12-10 23:46:58 +0900 (f8cda24) @@ -0,0 +1,129 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x647999997", "-3x-647999997")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 36 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-647999999" + ], + [ + "-3x-647999998" + ], + [ + "-3x-647999997" + ], + [ + "-3x647999997" + ], + [ + "-3x647999998" + ], + [ + "-3x647999999" + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x-647999997" + ], + [ + "-2x647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x-647999997" + ], + [ + "-1x647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x-647999997" + ], + [ + "0x647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x-647999997" + ], + [ + "1x647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ], + [ + "2x-647999999" + ], + [ + "2x-647999998" + ], + [ + "2x-647999997" + ], + [ + "2x647999997" + ], + [ + "2x647999998" + ], + [ + "2x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/all_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/all_out.test 2013-12-10 23:46:58 +0900 (be390dc) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x647999997", "-3x-647999997")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_out.expected 2013-12-10 23:46:58 +0900 (b05a314) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999997", "-2x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_out.test 2013-12-10 23:46:58 +0900 (a0f3892) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999997", "-2x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_west_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_west_out.expected 2013-12-10 23:46:58 +0900 (f27fda6) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999997", "-2x-647999997")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x-647999997" + ], + [ + "-2x647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x-647999997" + ], + [ + "-1x647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x-647999997" + ], + [ + "0x647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x-647999997" + ], + [ + "1x647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/east_west_out.test 2013-12-10 23:46:58 +0900 (8b0bb2e) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999997", "-2x-647999997")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_east_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_east_out.expected 2013-12-10 23:46:58 +0900 (cb2b1ea) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x647999997", "-2x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ], + [ + "2x-647999999" + ], + [ + "2x-647999998" + ], + [ + "2x647999997" + ], + [ + "2x647999998" + ], + [ + "2x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_east_out.test 2013-12-10 23:46:58 +0900 (53a10c7) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x647999997", "-2x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_out.expected 2013-12-10 23:46:58 +0900 (59faacc) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x647999998", "-2x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ], + [ + "2x-647999999" + ], + [ + "2x-647999998" + ], + [ + "2x647999998" + ], + [ + "2x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_out.test 2013-12-10 23:46:58 +0900 (cbcdfc5) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x647999998", "-2x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_south_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_south_out.expected 2013-12-10 23:46:58 +0900 (caa590f) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x647999998", "-3x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-647999999" + ], + [ + "-3x-647999998" + ], + [ + "-3x647999998" + ], + [ + "-3x647999999" + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ], + [ + "2x-647999999" + ], + [ + "2x-647999998" + ], + [ + "2x647999998" + ], + [ + "2x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_south_out.test 2013-12-10 23:46:58 +0900 (2f1186f) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x647999998", "-3x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_west_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_west_out.expected 2013-12-10 23:46:58 +0900 (da8e0d4) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x647999998", "-2x-647999997")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x-647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x-647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x-647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x-647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ], + [ + "2x-647999999" + ], + [ + "2x-647999998" + ], + [ + "2x-647999997" + ], + [ + "2x647999998" + ], + [ + "2x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/north_west_out.test 2013-12-10 23:46:58 +0900 (2c40460) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x647999998", "-2x-647999997")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/same_as_mesh.expected (+69 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/same_as_mesh.expected 2013-12-10 23:46:58 +0900 (08b30fe) @@ -0,0 +1,69 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999998", "-2x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 16 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/same_as_mesh.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/same_as_mesh.test 2013-12-10 23:46:58 +0900 (8b7fb79) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999998", "-2x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_east_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_east_out.expected 2013-12-10 23:46:58 +0900 (84385ea) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999997", "-3x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-647999999" + ], + [ + "-3x-647999998" + ], + [ + "-3x647999997" + ], + [ + "-3x647999998" + ], + [ + "-3x647999999" + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_east_out.test 2013-12-10 23:46:58 +0900 (856b3a5) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999997", "-3x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_out.expected 2013-12-10 23:46:58 +0900 (86fbcd2) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999998", "-3x-647999998")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-647999999" + ], + [ + "-3x-647999998" + ], + [ + "-3x647999998" + ], + [ + "-3x647999999" + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_out.test 2013-12-10 23:46:58 +0900 (4fd7182) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999998", "-3x-647999998")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_west_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_west_out.expected 2013-12-10 23:46:58 +0900 (15cf763) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999998", "-3x-647999997")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-647999999" + ], + [ + "-3x-647999998" + ], + [ + "-3x-647999997" + ], + [ + "-3x647999998" + ], + [ + "-3x647999999" + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x-647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x-647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x-647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x-647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/south_west_out.test 2013-12-10 23:46:58 +0900 (c06baf9) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999998", "-3x-647999997")' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/west_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/west_out.expected 2013-12-10 23:46:58 +0900 (5c9637e) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x647999998", "-2x-647999997")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-647999999" + ], + [ + "-2x-647999998" + ], + [ + "-2x-647999997" + ], + [ + "-2x647999998" + ], + [ + "-2x647999999" + ], + [ + "-1x-647999999" + ], + [ + "-1x-647999998" + ], + [ + "-1x-647999997" + ], + [ + "-1x647999998" + ], + [ + "-1x647999999" + ], + [ + "0x-647999999" + ], + [ + "0x-647999998" + ], + [ + "0x-647999997" + ], + [ + "0x647999998" + ], + [ + "0x647999999" + ], + [ + "1x-647999999" + ], + [ + "1x-647999998" + ], + [ + "1x-647999997" + ], + [ + "1x647999998" + ], + [ + "1x647999999" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_180/use_index/west_out.test 2013-12-10 23:46:58 +0900 (182e991) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_180.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x647999998", "-2x-647999997")' -------------- next part -------------- HTML����������������������������... 下载