Kouhei Sutou
null+****@clear*****
Tue Dec 10 22:30:28 JST 2013
Kouhei Sutou 2013-12-10 22:30:28 +0900 (Tue, 10 Dec 2013) New Revision: 02073e1cb8a97f745488f0107399cc526ebc6524 https://github.com/groonga/groonga/commit/02073e1cb8a97f745488f0107399cc526ebc6524 Message: test geo_in_rectangle: add tests for east area with index use It works well without code change! Yay! Added files: test/command/suite/select/filter/geo_in_rectangle/east/use_index/all_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/all_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_west_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_west_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_east_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_east_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_south_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_south_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_west_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_west_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/same_as_mesh.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/same_as_mesh.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_east_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_east_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_west_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_west_out.test test/command/suite/select/filter/geo_in_rectangle/east/use_index/west_out.expected test/command/suite/select/filter/geo_in_rectangle/east/use_index/west_out.test Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/all_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/all_out.expected 2013-12-10 22:30:28 +0900 (b6ab33d) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x1", "-3x4")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x1" + ], + [ + "2x2" + ], + [ + "2x3" + ], + [ + "2x4" + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "1x4" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "0x4" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-1x4" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-2x4" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-3x3" + ], + [ + "-3x4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/all_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/all_out.test 2013-12-10 22:30:28 +0900 (c7efba1) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x1", "-3x4")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_out.expected 2013-12-10 22:30:28 +0900 (8bd3737) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x2", "-2x4")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "1x4" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "0x4" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-1x4" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-2x4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_out.test 2013-12-10 22:30:28 +0900 (0504dc2) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x2", "-2x4")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_west_out.expected (+69 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_west_out.expected 2013-12-10 22:30:28 +0900 (04609c7) @@ -0,0 +1,69 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x1", "-2x4")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 16 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "1x4" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "0x4" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-1x4" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-2x4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/east_west_out.test 2013-12-10 22:30:28 +0900 (2b15e62) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x1", "-2x4")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_east_out.expected 2013-12-10 22:30:28 +0900 (e7ee76b) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x2", "-2x4")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x2" + ], + [ + "2x3" + ], + [ + "2x4" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "1x4" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "0x4" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-1x4" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-2x4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_east_out.test 2013-12-10 22:30:28 +0900 (7f895a7) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x2", "-2x4")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_out.expected 2013-12-10 22:30:28 +0900 (a3b6994) @@ -0,0 +1,51 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x2", "-2x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 10 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x2" + ], + [ + "2x3" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x2" + ], + [ + "-2x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_out.test 2013-12-10 22:30:28 +0900 (1b2f5ec) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x2", "-2x3")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_south_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_south_out.expected 2013-12-10 22:30:28 +0900 (006c17a) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x2", "-3x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x2" + ], + [ + "2x3" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-3x2" + ], + [ + "-3x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_south_out.test 2013-12-10 22:30:28 +0900 (1ff8575) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x2", "-3x3")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_west_out.expected 2013-12-10 22:30:28 +0900 (a3bd91b) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x1", "-2x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x1" + ], + [ + "2x2" + ], + [ + "2x3" + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-2x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/north_west_out.test 2013-12-10 22:30:28 +0900 (ed96f4f) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x1", "-2x3")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/same_as_mesh.expected (+45 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/same_as_mesh.expected 2013-12-10 22:30:28 +0900 (07b561d) @@ -0,0 +1,45 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x2", "-2x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 8 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x2" + ], + [ + "-2x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/same_as_mesh.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/same_as_mesh.test 2013-12-10 22:30:28 +0900 (726257f) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x2", "-2x3")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_east_out.expected 2013-12-10 22:30:28 +0900 (a50edc8) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x2", "-3x4")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "1x4" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "0x4" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-1x4" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-2x4" + ], + [ + "-3x2" + ], + [ + "-3x3" + ], + [ + "-3x4" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_east_out.test 2013-12-10 22:30:28 +0900 (a43c4de) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x2", "-3x4")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_out.expected 2013-12-10 22:30:28 +0900 (9112d0d) @@ -0,0 +1,51 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x2", "-3x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 10 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-3x2" + ], + [ + "-3x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_out.test 2013-12-10 22:30:28 +0900 (5c8c601) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x2", "-3x3")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_west_out.expected 2013-12-10 22:30:28 +0900 (421a304) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x1", "-3x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-2x3" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-3x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/south_west_out.test 2013-12-10 22:30:28 +0900 (e630cce) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x1", "-3x3")' Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/west_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/west_out.expected 2013-12-10 22:30:28 +0900 (3cc2045) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x1", "-2x3")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "1x3" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "0x3" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "-1x3" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-2x3" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/east/use_index/west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/east/use_index/west_out.test 2013-12-10 22:30:28 +0900 (7d3cd48) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x1", "-2x3")' -------------- next part -------------- HTML����������������������������...Download