Kouhei Sutou
null+****@clear*****
Sun Dec 8 22:24:17 JST 2013
Kouhei Sutou 2013-12-08 22:24:17 +0900 (Sun, 08 Dec 2013) New Revision: f3fcddb8c3e6cf212c95db14f59d7c5fc1d2dbe4 https://github.com/groonga/groonga/commit/f3fcddb8c3e6cf212c95db14f59d7c5fc1d2dbe4 Message: test geo_in_rectangle: add tests for north area with index use Added files: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/all_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/all_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_west_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_west_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_east_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_east_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_south_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_south_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_west_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_west_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/same_as_mesh.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/same_as_mesh.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_east_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_east_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_west_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_west_out.test test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/west_out.expected test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/west_out.test Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/all_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/all_out.expected 2013-12-08 22:24:17 +0900 (72d8171) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-2x-3", "-5x2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-4x-3" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-4x2" + ], + [ + "-5x-3" + ], + [ + "-5x-2" + ], + [ + "-5x-1" + ], + [ + "-5x0" + ], + [ + "-5x1" + ], + [ + "-5x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/all_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/all_out.test 2013-12-08 22:24:17 +0900 (0cfbba8) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-2x-3", "-5x2")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_out.expected 2013-12-08 22:24:17 +0900 (d38323c) @@ -0,0 +1,51 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-2", "-4x2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 10 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-4x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_out.test 2013-12-08 22:24:17 +0900 (f939938) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-2", "-4x2")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_west_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_west_out.expected 2013-12-08 22:24:17 +0900 (c2bdbd9) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-3", "-4x2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-4x-3" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-4x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/east_west_out.test 2013-12-08 22:24:17 +0900 (835c913) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-3", "-4x2")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_east_out.expected 2013-12-08 22:24:17 +0900 (37b636c) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-2x-2", "-4x2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-4x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_east_out.test 2013-12-08 22:24:17 +0900 (abc783d) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-2x-2", "-4x2")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_out.expected 2013-12-08 22:24:17 +0900 (c6ee7c4) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-2x-2", "-4x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_out.test 2013-12-08 22:24:17 +0900 (a3cc77d) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-2x-2", "-4x1")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_south_out.expected (+69 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_south_out.expected 2013-12-08 22:24:17 +0900 (347c825) @@ -0,0 +1,69 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-2x-2", "-5x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 16 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-5x-2" + ], + [ + "-5x-1" + ], + [ + "-5x0" + ], + [ + "-5x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_south_out.test 2013-12-08 22:24:17 +0900 (19217eb) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-2x-2", "-5x1")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_west_out.expected 2013-12-08 22:24:17 +0900 (38692f5) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-2x-3", "-4x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-3" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/north_west_out.test 2013-12-08 22:24:17 +0900 (1ffde10) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-2x-3", "-4x1")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/same_as_mesh.expected (+45 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/same_as_mesh.expected 2013-12-08 22:24:17 +0900 (1f8bd8c) @@ -0,0 +1,45 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-2", "-4x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 8 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/same_as_mesh.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/same_as_mesh.test 2013-12-08 22:24:17 +0900 (d67c9a1) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-2", "-4x1")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_east_out.expected 2013-12-08 22:24:17 +0900 (3a1acd9) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-2", "-5x2")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-4x2" + ], + [ + "-5x-2" + ], + [ + "-5x-1" + ], + [ + "-5x0" + ], + [ + "-5x1" + ], + [ + "-5x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_east_out.test 2013-12-08 22:24:17 +0900 (b008d79) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-2", "-5x2")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_out.expected 2013-12-08 22:24:17 +0900 (d46b375) @@ -0,0 +1,57 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-2", "-5x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 12 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-5x-2" + ], + [ + "-5x-1" + ], + [ + "-5x0" + ], + [ + "-5x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_out.test 2013-12-08 22:24:17 +0900 (6a6caed) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-2", "-5x1")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_west_out.expected 2013-12-08 22:24:17 +0900 (0b58e14) @@ -0,0 +1,66 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-3", "-5x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 15 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-3" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ], + [ + "-5x-3" + ], + [ + "-5x-2" + ], + [ + "-5x-1" + ], + [ + "-5x0" + ], + [ + "-5x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/south_west_out.test 2013-12-08 22:24:17 +0900 (0d60d24) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-3", "-5x1")' Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/west_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/west_out.expected 2013-12-08 22:24:17 +0900 (2d5805d) @@ -0,0 +1,51 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "-3x-3", "-4x1")' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 10 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-4x-3" + ], + [ + "-4x-2" + ], + [ + "-4x-1" + ], + [ + "-4x0" + ], + [ + "-4x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/south/around_0/use_index/west_out.test 2013-12-08 22:24:17 +0900 (28570d4) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/south/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "-3x-3", "-4x1")' -------------- next part -------------- HTML����������������������������...Download