Kouhei Sutou
null+****@clear*****
Tue Dec 10 23:02:59 JST 2013
Kouhei Sutou 2013-12-10 23:02:59 +0900 (Tue, 10 Dec 2013) New Revision: fe279d25e60253350cfe24ea2eb4e35a2fcdc3c4 https://github.com/groonga/groonga/commit/fe279d25e60253350cfe24ea2eb4e35a2fcdc3c4 Message: test geo_in_rectangle: add tests for all areas around 0 point without index use Added files: test/command/fixture/geo/in_rectangle/all/around_0.grn test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/all_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/all_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_west_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_east_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_east_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_south_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_south_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_west_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/same_as_mesh.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/same_as_mesh.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_east_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_east_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_west_out.test test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/west_out.expected test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/west_out.test Added: test/command/fixture/geo/in_rectangle/all/around_0.grn (+264 -0) 100644 =================================================================== --- /dev/null +++ test/command/fixture/geo/in_rectangle/all/around_0.grn 2013-12-10 23:02:59 +0900 (0e55327) @@ -0,0 +1,264 @@ +#@include fixture/geo/in_rectangle/ddl.grn + +#@disable-logging +load --table LandMarks +[ +["point"], +["-8x-8"], +["-8x-7"], +["-8x-6"], +["-8x-5"], +["-8x-4"], +["-8x-3"], +["-8x-2"], +["-8x-1"], +["-8x0"], +["-8x1"], +["-8x2"], +["-8x3"], +["-8x4"], +["-8x5"], +["-8x6"], +["-8x7"], +["-7x-8"], +["-7x-7"], +["-7x-6"], +["-7x-5"], +["-7x-4"], +["-7x-3"], +["-7x-2"], +["-7x-1"], +["-7x0"], +["-7x1"], +["-7x2"], +["-7x3"], +["-7x4"], +["-7x5"], +["-7x6"], +["-7x7"], +["-6x-8"], +["-6x-7"], +["-6x-6"], +["-6x-5"], +["-6x-4"], +["-6x-3"], +["-6x-2"], +["-6x-1"], +["-6x0"], +["-6x1"], +["-6x2"], +["-6x3"], +["-6x4"], +["-6x5"], +["-6x6"], +["-6x7"], +["-5x-8"], +["-5x-7"], +["-5x-6"], +["-5x-5"], +["-5x-4"], +["-5x-3"], +["-5x-2"], +["-5x-1"], +["-5x0"], +["-5x1"], +["-5x2"], +["-5x3"], +["-5x4"], +["-5x5"], +["-5x6"], +["-5x7"], +["-4x-8"], +["-4x-7"], +["-4x-6"], +["-4x-5"], +["-4x-4"], +["-4x-3"], +["-4x-2"], +["-4x-1"], +["-4x0"], +["-4x1"], +["-4x2"], +["-4x3"], +["-4x4"], +["-4x5"], +["-4x6"], +["-4x7"], +["-3x-8"], +["-3x-7"], +["-3x-6"], +["-3x-5"], +["-3x-4"], +["-3x-3"], +["-3x-2"], +["-3x-1"], +["-3x0"], +["-3x1"], +["-3x2"], +["-3x3"], +["-3x4"], +["-3x5"], +["-3x6"], +["-3x7"], +["-2x-8"], +["-2x-7"], +["-2x-6"], +["-2x-5"], +["-2x-4"], +["-2x-3"], +["-2x-2"], +["-2x-1"], +["-2x0"], +["-2x1"], +["-2x2"], +["-2x3"], +["-2x4"], +["-2x5"], +["-2x6"], +["-2x7"], +["-1x-8"], +["-1x-7"], +["-1x-6"], +["-1x-5"], +["-1x-4"], +["-1x-3"], +["-1x-2"], +["-1x-1"], +["-1x0"], +["-1x1"], +["-1x2"], +["-1x3"], +["-1x4"], +["-1x5"], +["-1x6"], +["-1x7"], +["0x-8"], +["0x-7"], +["0x-6"], +["0x-5"], +["0x-4"], +["0x-3"], +["0x-2"], +["0x-1"], +["0x0"], +["0x1"], +["0x2"], +["0x3"], +["0x4"], +["0x5"], +["0x6"], +["0x7"], +["1x-8"], +["1x-7"], +["1x-6"], +["1x-5"], +["1x-4"], +["1x-3"], +["1x-2"], +["1x-1"], +["1x0"], +["1x1"], +["1x2"], +["1x3"], +["1x4"], +["1x5"], +["1x6"], +["1x7"], +["2x-8"], +["2x-7"], +["2x-6"], +["2x-5"], +["2x-4"], +["2x-3"], +["2x-2"], +["2x-1"], +["2x0"], +["2x1"], +["2x2"], +["2x3"], +["2x4"], +["2x5"], +["2x6"], +["2x7"], +["3x-8"], +["3x-7"], +["3x-6"], +["3x-5"], +["3x-4"], +["3x-3"], +["3x-2"], +["3x-1"], +["3x0"], +["3x1"], +["3x2"], +["3x3"], +["3x4"], +["3x5"], +["3x6"], +["3x7"], +["4x-8"], +["4x-7"], +["4x-6"], +["4x-5"], +["4x-4"], +["4x-3"], +["4x-2"], +["4x-1"], +["4x0"], +["4x1"], +["4x2"], +["4x3"], +["4x4"], +["4x5"], +["4x6"], +["4x7"], +["5x-8"], +["5x-7"], +["5x-6"], +["5x-5"], +["5x-4"], +["5x-3"], +["5x-2"], +["5x-1"], +["5x0"], +["5x1"], +["5x2"], +["5x3"], +["5x4"], +["5x5"], +["5x6"], +["5x7"], +["6x-8"], +["6x-7"], +["6x-6"], +["6x-5"], +["6x-4"], +["6x-3"], +["6x-2"], +["6x-1"], +["6x0"], +["6x1"], +["6x2"], +["6x3"], +["6x4"], +["6x5"], +["6x6"], +["6x7"], +["7x-8"], +["7x-7"], +["7x-6"], +["7x-5"], +["7x-4"], +["7x-3"], +["7x-2"], +["7x-1"], +["7x0"], +["7x1"], +["7x2"], +["7x3"], +["7x4"], +["7x5"], +["7x6"], +["7x7"] +] +#@enable-logging Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/all_out.expected (+129 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/all_out.expected 2013-12-10 23:02:59 +0900 (f7db956) @@ -0,0 +1,129 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-3", "-3x2") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 36 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-1x-3" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "0x-3" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "1x-3" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "2x-3" + ], + [ + "2x-2" + ], + [ + "2x-1" + ], + [ + "2x0" + ], + [ + "2x1" + ], + [ + "2x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/all_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/all_out.test 2013-12-10 23:02:59 +0900 (c4cf1be) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-3", "-3x2") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_out.expected 2013-12-10 23:02:59 +0900 (da3ed04) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-2", "-2x2") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "1x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_out.test 2013-12-10 23:02:59 +0900 (04e733b) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-2", "-2x2") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_west_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_west_out.expected 2013-12-10 23:02:59 +0900 (a50894f) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-3", "-2x2") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-1x-3" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "0x-3" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "1x-3" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "1x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/east_west_out.test 2013-12-10 23:02:59 +0900 (ac142a8) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-3", "-2x2") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_east_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_east_out.expected 2013-12-10 23:02:59 +0900 (dd4f5e5) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-2", "-2x2") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "1x2" + ], + [ + "2x-2" + ], + [ + "2x-1" + ], + [ + "2x0" + ], + [ + "2x1" + ], + [ + "2x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_east_out.test 2013-12-10 23:02:59 +0900 (bf2f549) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-2", "-2x2") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_out.expected 2013-12-10 23:02:59 +0900 (46f417a) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-2", "-2x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "2x-2" + ], + [ + "2x-1" + ], + [ + "2x0" + ], + [ + "2x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_out.test 2013-12-10 23:02:59 +0900 (8c2a521) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-2", "-2x1") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_south_out.expected (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_south_out.expected 2013-12-10 23:02:59 +0900 (a4eec99) @@ -0,0 +1,93 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-2", "-3x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 24 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "2x-2" + ], + [ + "2x-1" + ], + [ + "2x0" + ], + [ + "2x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_south_out.test 2013-12-10 23:02:59 +0900 (597ce4e) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-2", "-3x1") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_west_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_west_out.expected 2013-12-10 23:02:59 +0900 (2082b89) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "2x-3", "-2x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-3" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-3" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-3" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "2x-3" + ], + [ + "2x-2" + ], + [ + "2x-1" + ], + [ + "2x0" + ], + [ + "2x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/north_west_out.test 2013-12-10 23:02:59 +0900 (f9e1ba6) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "2x-3", "-2x1") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/same_as_mesh.expected (+69 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/same_as_mesh.expected 2013-12-10 23:02:59 +0900 (fb8d5bf) @@ -0,0 +1,69 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-2", "-2x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 16 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/same_as_mesh.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/same_as_mesh.test 2013-12-10 23:02:59 +0900 (e7eb685) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-2", "-2x1") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_east_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_east_out.expected 2013-12-10 23:02:59 +0900 (ec329c4) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-2", "-3x2") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-3x2" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-2x2" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "-1x2" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "0x2" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ], + [ + "1x2" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_east_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_east_out.test 2013-12-10 23:02:59 +0900 (ccefce2) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-2", "-3x2") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_out.expected 2013-12-10 23:02:59 +0900 (804b84e) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-2", "-3x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_out.test 2013-12-10 23:02:59 +0900 (bfe4053) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-2", "-3x1") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_west_out.expected (+96 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_west_out.expected 2013-12-10 23:02:59 +0900 (c073d60) @@ -0,0 +1,96 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-3", "-3x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 25 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-3x-3" + ], + [ + "-3x-2" + ], + [ + "-3x-1" + ], + [ + "-3x0" + ], + [ + "-3x1" + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-3" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-3" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-3" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/south_west_out.test 2013-12-10 23:02:59 +0900 (e1fe687) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-3", "-3x1") > 0' Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/west_out.expected (+81 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/west_out.expected 2013-12-10 23:02:59 +0900 (6ac16ec) @@ -0,0 +1,81 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_rectangle(point, "1x-3", "-2x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 20 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "-2x-3" + ], + [ + "-2x-2" + ], + [ + "-2x-1" + ], + [ + "-2x0" + ], + [ + "-2x1" + ], + [ + "-1x-3" + ], + [ + "-1x-2" + ], + [ + "-1x-1" + ], + [ + "-1x0" + ], + [ + "-1x1" + ], + [ + "0x-3" + ], + [ + "0x-2" + ], + [ + "0x-1" + ], + [ + "0x0" + ], + [ + "0x1" + ], + [ + "1x-3" + ], + [ + "1x-2" + ], + [ + "1x-1" + ], + [ + "1x0" + ], + [ + "1x1" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/west_out.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_rectangle/all/around_0/no_index/west_out.test 2013-12-10 23:02:59 +0900 (7c1fe4d) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_rectangle/all/around_0.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_rectangle(point, "1x-3", "-2x1") > 0' -------------- next part -------------- HTML����������������������������...下載
