Kouhei Sutou
null+****@clear*****
Tue Dec 10 22:51:28 JST 2013
Kouhei Sutou 2013-12-10 22:51:28 +0900 (Tue, 10 Dec 2013) New Revision: 52d7db5dba2109d6e5d3593322e8b7c6516a9f5e https://github.com/groonga/groonga/commit/52d7db5dba2109d6e5d3593322e8b7c6516a9f5e Message: test geo_in_rectangle: add tests for west area with index use It also works well without code change! Added files: test/command/suite/select/filter/geo_in_rectangle/west/use_index/all_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/all_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_west_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_east_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_east_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_south_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_south_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_west_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/same_as_mesh.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/same_as_mesh.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_east_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_east_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_west_out.test test/command/suite/select/filter/geo_in_rectangle/west/use_index/west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/use_index/west_out.test Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/all_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/all_out.expected 2013-12-10 22:51:28 +0900 (31e83cd) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-5", "-3x-2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x-2" + ], + [ + "2x-3" + ], + [ + "2x-4" + ], + [ + "2x-5" + ], + [ + "1x-2" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "1x-5" + ], + [ + "0x-2" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "0x-5" + ], + [ + "-1x-2" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-1x-5" + ], + [ + "-2x-2" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-2x-5" + ], + [ + "-3x-2" + ], + [ + "-3x-3" + ], + [ + "-3x-4" + ], + [ + "-3x-5" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/all_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/all_out.test 2013-12-10 22:51:28 +0900 (fc718ee) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-5", "-3x-2")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_out.expected 2013-12-10 22:51:28 +0900 (c972d96) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-4", "-2x-2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-2" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-2" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-2" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-2" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_out.test 2013-12-10 22:51:28 +0900 (f22f2f0) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-4", "-2x-2")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_west_out.expected (+69 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_west_out.expected 2013-12-10 22:51:28 +0900 (cf21bff) @@ -0,0 +1,69 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-5", "-2x-2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 16 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-2" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "1x-5" + ], + [ + "0x-2" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "0x-5" + ], + [ + "-1x-2" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-1x-5" + ], + [ + "-2x-2" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-2x-5" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/east_west_out.test 2013-12-10 22:51:28 +0900 (59e41a3) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-5", "-2x-2")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_east_out.expected 2013-12-10 22:51:28 +0900 (6ec906c) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-4", "-2x-2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x-2" + ], + [ + "2x-3" + ], + [ + "2x-4" + ], + [ + "1x-2" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-2" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-2" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-2" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_east_out.test 2013-12-10 22:51:28 +0900 (cda2a0f) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-4", "-2x-2")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_out.expected 2013-12-10 22:51:28 +0900 (ff25d76) @@ -0,0 +1,51 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-4", "-2x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 10 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x-3" + ], + [ + "2x-4" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_out.test 2013-12-10 22:51:28 +0900 (d1d6d11) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-4", "-2x-3")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_south_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_south_out.expected 2013-12-10 22:51:28 +0900 (5ab617c) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-4", "-3x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x-3" + ], + [ + "2x-4" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-3x-3" + ], + [ + "-3x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_south_out.test 2013-12-10 22:51:28 +0900 (ec8974c) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-4", "-3x-3")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_west_out.expected 2013-12-10 22:51:28 +0900 (a490f2b) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-5", "-2x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x-3" + ], + [ + "2x-4" + ], + [ + "2x-5" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "1x-5" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "0x-5" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-1x-5" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-2x-5" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/north_west_out.test 2013-12-10 22:51:28 +0900 (8ed71b4) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-5", "-2x-3")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/same_as_mesh.expected (+45 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/same_as_mesh.expected 2013-12-10 22:51:28 +0900 (f84af57) @@ -0,0 +1,45 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-4", "-2x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 8 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/same_as_mesh.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/same_as_mesh.test 2013-12-10 22:51:28 +0900 (47172a6) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-4", "-2x-3")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_east_out.expected 2013-12-10 22:51:28 +0900 (9bd286c) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-4", "-3x-2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-2" + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-2" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-2" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-2" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-3x-2" + ], + [ + "-3x-3" + ], + [ + "-3x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_east_out.test 2013-12-10 22:51:28 +0900 (796e208) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-4", "-3x-2")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_out.expected 2013-12-10 22:51:28 +0900 (0acf174) @@ -0,0 +1,51 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-4", "-3x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 10 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-3x-3" + ], + [ + "-3x-4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_out.test 2013-12-10 22:51:28 +0900 (9596143) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-4", "-3x-3")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_west_out.expected 2013-12-10 22:51:28 +0900 (cd92d33) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-5", "-3x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "1x-5" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "0x-5" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-1x-5" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-2x-5" + ], + [ + "-3x-3" + ], + [ + "-3x-4" + ], + [ + "-3x-5" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/south_west_out.test 2013-12-10 22:51:28 +0900 (9afbce9) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-5", "-3x-3")' Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/west_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/west_out.expected 2013-12-10 22:51:28 +0900 (c36860a) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-5", "-2x-3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x-3" + ], + [ + "1x-4" + ], + [ + "1x-5" + ], + [ + "0x-3" + ], + [ + "0x-4" + ], + [ + "0x-5" + ], + [ + "-1x-3" + ], + [ + "-1x-4" + ], + [ + "-1x-5" + ], + [ + "-2x-3" + ], + [ + "-2x-4" + ], + [ + "-2x-5" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/west/use_index/west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/use_index/west_out.test 2013-12-10 22:51:28 +0900 (f38b7bf) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/west.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-5", "-2x-3")' -------------- next part -------------- HTML����������������������������... Télécharger