Kouhei Sutou
null+****@clear*****
Tue Dec 10 22:47:23 JST 2013
Kouhei Sutou 2013-12-10 22:47:23 +0900 (Tue, 10 Dec 2013) New Revision: 1511de2527ca0c72e2bb9a2861f81ed000646121 https://github.com/groonga/groonga/commit/1511de2527ca0c72e2bb9a2861f81ed000646121 Message: test geo_in_rectangle: add tests for west area without index use Added files: test/command/fixture/geo/in_rectangle/west.grn test/command/suite/select/filter/geo_in_rectangle/west/no_index/all_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/all_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_west_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_east_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_east_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_south_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_south_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_west_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/same_as_mesh.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/same_as_mesh.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_east_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_east_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_west_out.test test/command/suite/select/filter/geo_in_rectangle/west/no_index/west_out.expected test/command/suite/select/filter/geo_in_rectangle/west/no_index/west_out.test Added: test/command/fixture/geo/in_rectangle/west.grn (+264 -0) 100644 =================================================================== --- /dev/null +++ test/command/fixture/geo/in_rectangle/west.grn 2013-12-10 22:47:23 +0900 (d2ac383) @@ -0,0 +1,264 @@ +#@include fixture/geo/in_rectangle/ddl.grn + +#@disable-logging +load --table LandMarks +[ +["point"], +["7x-1"], +["7x-2"], +["7x-3"], +["7x-4"], +["7x-5"], +["7x-6"], +["7x-7"], +["7x-8"], +["7x-9"], +["7x-10"], +["7x-11"], +["7x-12"], +["7x-13"], +["7x-14"], +["7x-15"], +["7x-16"], +["6x-1"], +["6x-2"], +["6x-3"], +["6x-4"], +["6x-5"], +["6x-6"], +["6x-7"], +["6x-8"], +["6x-9"], +["6x-10"], +["6x-11"], +["6x-12"], +["6x-13"], +["6x-14"], +["6x-15"], +["6x-16"], +["5x-1"], +["5x-2"], +["5x-3"], +["5x-4"], +["5x-5"], +["5x-6"], +["5x-7"], +["5x-8"], +["5x-9"], +["5x-10"], +["5x-11"], +["5x-12"], +["5x-13"], +["5x-14"], +["5x-15"], +["5x-16"], +["4x-1"], +["4x-2"], +["4x-3"], +["4x-4"], +["4x-5"], +["4x-6"], +["4x-7"], +["4x-8"], +["4x-9"], +["4x-10"], +["4x-11"], +["4x-12"], +["4x-13"], +["4x-14"], +["4x-15"], +["4x-16"], +["3x-1"], +["3x-2"], +["3x-3"], +["3x-4"], +["3x-5"], +["3x-6"], +["3x-7"], +["3x-8"], +["3x-9"], +["3x-10"], +["3x-11"], +["3x-12"], +["3x-13"], +["3x-14"], +["3x-15"], +["3x-16"], +["2x-1"], +["2x-2"], +["2x-3"], +["2x-4"], +["2x-5"], +["2x-6"], +["2x-7"], +["2x-8"], +["2x-9"], +["2x-10"], +["2x-11"], +["2x-12"], +["2x-13"], +["2x-14"], +["2x-15"], +["2x-16"], +["1x-1"], +["1x-2"], +["1x-3"], +["1x-4"], +["1x-5"], +["1x-6"], +["1x-7"], +["1x-8"], +["1x-9"], +["1x-10"], +["1x-11"], +["1x-12"], +["1x-13"], +["1x-14"], +["1x-15"], +["1x-16"], +["0x-1"], +["0x-2"], +["0x-3"], +["0x-4"], +["0x-5"], +["0x-6"], +["0x-7"], +["0x-8"], +["0x-9"], +["0x-10"], +["0x-11"], +["0x-12"], +["0x-13"], +["0x-14"], +["0x-15"], +["0x-16"], +["-1x-1"], +["-1x-2"], +["-1x-3"], +["-1x-4"], +["-1x-5"], +["-1x-6"], +["-1x-7"], +["-1x-8"], +["-1x-9"], +["-1x-10"], +["-1x-11"], +["-1x-12"], +["-1x-13"], +["-1x-14"], +["-1x-15"], +["-1x-16"], +["-2x-1"], +["-2x-2"], +["-2x-3"], +["-2x-4"], +["-2x-5"], +["-2x-6"], +["-2x-7"], +["-2x-8"], +["-2x-9"], +["-2x-10"], +["-2x-11"], +["-2x-12"], +["-2x-13"], +["-2x-14"], +["-2x-15"], +["-2x-16"], +["-3x-1"], +["-3x-2"], +["-3x-3"], +["-3x-4"], +["-3x-5"], +["-3x-6"], +["-3x-7"], +["-3x-8"], +["-3x-9"], +["-3x-10"], +["-3x-11"], +["-3x-12"], +["-3x-13"], +["-3x-14"], +["-3x-15"], +["-3x-16"], +["-4x-1"], +["-4x-2"], +["-4x-3"], +["-4x-4"], +["-4x-5"], +["-4x-6"], +["-4x-7"], +["-4x-8"], +["-4x-9"], +["-4x-10"], +["-4x-11"], +["-4x-12"], +["-4x-13"], +["-4x-14"], +["-4x-15"], +["-4x-16"], +["-5x-1"], +["-5x-2"], +["-5x-3"], +["-5x-4"], +["-5x-5"], +["-5x-6"], +["-5x-7"], +["-5x-8"], +["-5x-9"], +["-5x-10"], +["-5x-11"], +["-5x-12"], +["-5x-13"], +["-5x-14"], +["-5x-15"], +["-5x-16"], +["-6x-1"], +["-6x-2"], +["-6x-3"], +["-6x-4"], +["-6x-5"], +["-6x-6"], +["-6x-7"], +["-6x-8"], +["-6x-9"], +["-6x-10"], +["-6x-11"], +["-6x-12"], +["-6x-13"], +["-6x-14"], +["-6x-15"], +["-6x-16"], +["-7x-1"], +["-7x-2"], +["-7x-3"], +["-7x-4"], +["-7x-5"], +["-7x-6"], +["-7x-7"], +["-7x-8"], +["-7x-9"], +["-7x-10"], +["-7x-11"], +["-7x-12"], +["-7x-13"], +["-7x-14"], +["-7x-15"], +["-7x-16"], +["-8x-1"], +["-8x-2"], +["-8x-3"], +["-8x-4"], +["-8x-5"], +["-8x-6"], +["-8x-7"], +["-8x-8"], +["-8x-9"], +["-8x-10"], +["-8x-11"], +["-8x-12"], +["-8x-13"], +["-8x-14"], +["-8x-15"], +["-8x-16"] +] +#@enable-logging Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/all_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/all_out.expected 2013-12-10 22:47:23 +0900 (ff69e4a) @@ -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.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/no_index/all_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/all_out.test 2013-12-10 22:47:23 +0900 (8c60efe) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_out.expected 2013-12-10 22:47:23 +0900 (9c970e0) @@ -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.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/no_index/east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_out.test 2013-12-10 22:47:23 +0900 (91a42f5) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_west_out.expected (+69 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_west_out.expected 2013-12-10 22:47:23 +0900 (e4fbfdb) @@ -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.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/no_index/east_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/east_west_out.test 2013-12-10 22:47:23 +0900 (61ab3a9) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_east_out.expected 2013-12-10 22:47:23 +0900 (becd45e) @@ -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.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/no_index/north_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_east_out.test 2013-12-10 22:47:23 +0900 (41ecb82) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_out.expected 2013-12-10 22:47:23 +0900 (bffd57b) @@ -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.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/no_index/north_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_out.test 2013-12-10 22:47:23 +0900 (05d60d9) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_south_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_south_out.expected 2013-12-10 22:47:23 +0900 (93da1f4) @@ -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.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/no_index/north_south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_south_out.test 2013-12-10 22:47:23 +0900 (35402a0) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_west_out.expected 2013-12-10 22:47:23 +0900 (15515ab) @@ -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.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/no_index/north_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/north_west_out.test 2013-12-10 22:47:23 +0900 (1c2a619) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/same_as_mesh.expected (+45 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/same_as_mesh.expected 2013-12-10 22:47:23 +0900 (7e9f747) @@ -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.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/no_index/same_as_mesh.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/same_as_mesh.test 2013-12-10 22:47:23 +0900 (1af504f) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_east_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_east_out.expected 2013-12-10 22:47:23 +0900 (75563f3) @@ -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.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/no_index/south_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_east_out.test 2013-12-10 22:47:23 +0900 (800642c) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_out.expected (+51 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_out.expected 2013-12-10 22:47:23 +0900 (3861516) @@ -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.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/no_index/south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_out.test 2013-12-10 22:47:23 +0900 (f52bb8f) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_west_out.expected (+66 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_west_out.expected 2013-12-10 22:47:23 +0900 (38c219f) @@ -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.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/no_index/south_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/south_west_out.test 2013-12-10 22:47:23 +0900 (6ebcd1c) @@ -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") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/west/no_index/west_out.expected (+57 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/west_out.expected 2013-12-10 22:47:23 +0900 (773e12d) @@ -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.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/no_index/west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/west/no_index/west_out.test 2013-12-10 22:47:23 +0900 (c5c7781) @@ -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") > 0' -------------- next part -------------- HTML����������������������������...下载
