Kouhei Sutou
null+****@clear*****
Fri Dec 13 23:14:39 JST 2013
Kouhei Sutou 2013-12-13 23:14:39 +0900 (Fri, 13 Dec 2013) New Revision: 2d291747e5eb8747f45d8555ad84123d7ebc2c9c https://github.com/groonga/groonga/commit/2d291747e5eb8747f45d8555ad84123d7ebc2c9c Message: test geo_in_circle: add a test for north/east area without index use Added files: test/command/fixture/geo/in_circle/ddl.grn test/command/fixture/geo/in_circle/north_east.grn test/command/suite/select/filter/geo_in_circle/no_index/north_east.expected test/command/suite/select/filter/geo_in_circle/no_index/north_east.test Added: test/command/fixture/geo/in_circle/ddl.grn (+7 -0) 100644 =================================================================== --- /dev/null +++ test/command/fixture/geo/in_circle/ddl.grn 2013-12-13 23:14:39 +0900 (7b248e9) @@ -0,0 +1,7 @@ +#@disable-logging +table_create LandMarks TABLE_NO_KEY +column_create LandMarks point COLUMN_SCALAR WGS84GeoPoint + +table_create Points TABLE_PAT_KEY WGS84GeoPoint +column_create Points land_mark_index COLUMN_INDEX LandMarks point +#@enable-logging Added: test/command/fixture/geo/in_circle/north_east.grn (+633 -0) 100644 =================================================================== --- /dev/null +++ test/command/fixture/geo/in_circle/north_east.grn 2013-12-13 23:14:39 +0900 (92ca4cf) @@ -0,0 +1,633 @@ +#@include fixture/geo/in_circle/ddl.grn + +#@disable-logging +load --table LandMarks +[ +["point"], +["0x0"], +["0x1"], +["0x2"], +["0x3"], +["0x4"], +["0x5"], +["0x6"], +["0x7"], +["0x8"], +["0x9"], +["0x10"], +["0x11"], +["0x12"], +["0x13"], +["0x14"], +["0x15"], +["0x16"], +["0x17"], +["0x18"], +["0x19"], +["0x20"], +["0x21"], +["0x22"], +["0x23"], +["0x24"], +["1x0"], +["1x1"], +["1x2"], +["1x3"], +["1x4"], +["1x5"], +["1x6"], +["1x7"], +["1x8"], +["1x9"], +["1x10"], +["1x11"], +["1x12"], +["1x13"], +["1x14"], +["1x15"], +["1x16"], +["1x17"], +["1x18"], +["1x19"], +["1x20"], +["1x21"], +["1x22"], +["1x23"], +["1x24"], +["2x0"], +["2x1"], +["2x2"], +["2x3"], +["2x4"], +["2x5"], +["2x6"], +["2x7"], +["2x8"], +["2x9"], +["2x10"], +["2x11"], +["2x12"], +["2x13"], +["2x14"], +["2x15"], +["2x16"], +["2x17"], +["2x18"], +["2x19"], +["2x20"], +["2x21"], +["2x22"], +["2x23"], +["2x24"], +["3x0"], +["3x1"], +["3x2"], +["3x3"], +["3x4"], +["3x5"], +["3x6"], +["3x7"], +["3x8"], +["3x9"], +["3x10"], +["3x11"], +["3x12"], +["3x13"], +["3x14"], +["3x15"], +["3x16"], +["3x17"], +["3x18"], +["3x19"], +["3x20"], +["3x21"], +["3x22"], +["3x23"], +["3x24"], +["4x0"], +["4x1"], +["4x2"], +["4x3"], +["4x4"], +["4x5"], +["4x6"], +["4x7"], +["4x8"], +["4x9"], +["4x10"], +["4x11"], +["4x12"], +["4x13"], +["4x14"], +["4x15"], +["4x16"], +["4x17"], +["4x18"], +["4x19"], +["4x20"], +["4x21"], +["4x22"], +["4x23"], +["4x24"], +["5x0"], +["5x1"], +["5x2"], +["5x3"], +["5x4"], +["5x5"], +["5x6"], +["5x7"], +["5x8"], +["5x9"], +["5x10"], +["5x11"], +["5x12"], +["5x13"], +["5x14"], +["5x15"], +["5x16"], +["5x17"], +["5x18"], +["5x19"], +["5x20"], +["5x21"], +["5x22"], +["5x23"], +["5x24"], +["6x0"], +["6x1"], +["6x2"], +["6x3"], +["6x4"], +["6x5"], +["6x6"], +["6x7"], +["6x8"], +["6x9"], +["6x10"], +["6x11"], +["6x12"], +["6x13"], +["6x14"], +["6x15"], +["6x16"], +["6x17"], +["6x18"], +["6x19"], +["6x20"], +["6x21"], +["6x22"], +["6x23"], +["6x24"], +["7x0"], +["7x1"], +["7x2"], +["7x3"], +["7x4"], +["7x5"], +["7x6"], +["7x7"], +["7x8"], +["7x9"], +["7x10"], +["7x11"], +["7x12"], +["7x13"], +["7x14"], +["7x15"], +["7x16"], +["7x17"], +["7x18"], +["7x19"], +["7x20"], +["7x21"], +["7x22"], +["7x23"], +["7x24"], +["8x0"], +["8x1"], +["8x2"], +["8x3"], +["8x4"], +["8x5"], +["8x6"], +["8x7"], +["8x8"], +["8x9"], +["8x10"], +["8x11"], +["8x12"], +["8x13"], +["8x14"], +["8x15"], +["8x16"], +["8x17"], +["8x18"], +["8x19"], +["8x20"], +["8x21"], +["8x22"], +["8x23"], +["8x24"], +["9x0"], +["9x1"], +["9x2"], +["9x3"], +["9x4"], +["9x5"], +["9x6"], +["9x7"], +["9x8"], +["9x9"], +["9x10"], +["9x11"], +["9x12"], +["9x13"], +["9x14"], +["9x15"], +["9x16"], +["9x17"], +["9x18"], +["9x19"], +["9x20"], +["9x21"], +["9x22"], +["9x23"], +["9x24"], +["10x0"], +["10x1"], +["10x2"], +["10x3"], +["10x4"], +["10x5"], +["10x6"], +["10x7"], +["10x8"], +["10x9"], +["10x10"], +["10x11"], +["10x12"], +["10x13"], +["10x14"], +["10x15"], +["10x16"], +["10x17"], +["10x18"], +["10x19"], +["10x20"], +["10x21"], +["10x22"], +["10x23"], +["10x24"], +["11x0"], +["11x1"], +["11x2"], +["11x3"], +["11x4"], +["11x5"], +["11x6"], +["11x7"], +["11x8"], +["11x9"], +["11x10"], +["11x11"], +["11x12"], +["11x13"], +["11x14"], +["11x15"], +["11x16"], +["11x17"], +["11x18"], +["11x19"], +["11x20"], +["11x21"], +["11x22"], +["11x23"], +["11x24"], +["12x0"], +["12x1"], +["12x2"], +["12x3"], +["12x4"], +["12x5"], +["12x6"], +["12x7"], +["12x8"], +["12x9"], +["12x10"], +["12x11"], +["12x12"], +["12x13"], +["12x14"], +["12x15"], +["12x16"], +["12x17"], +["12x18"], +["12x19"], +["12x20"], +["12x21"], +["12x22"], +["12x23"], +["12x24"], +["13x0"], +["13x1"], +["13x2"], +["13x3"], +["13x4"], +["13x5"], +["13x6"], +["13x7"], +["13x8"], +["13x9"], +["13x10"], +["13x11"], +["13x12"], +["13x13"], +["13x14"], +["13x15"], +["13x16"], +["13x17"], +["13x18"], +["13x19"], +["13x20"], +["13x21"], +["13x22"], +["13x23"], +["13x24"], +["14x0"], +["14x1"], +["14x2"], +["14x3"], +["14x4"], +["14x5"], +["14x6"], +["14x7"], +["14x8"], +["14x9"], +["14x10"], +["14x11"], +["14x12"], +["14x13"], +["14x14"], +["14x15"], +["14x16"], +["14x17"], +["14x18"], +["14x19"], +["14x20"], +["14x21"], +["14x22"], +["14x23"], +["14x24"], +["15x0"], +["15x1"], +["15x2"], +["15x3"], +["15x4"], +["15x5"], +["15x6"], +["15x7"], +["15x8"], +["15x9"], +["15x10"], +["15x11"], +["15x12"], +["15x13"], +["15x14"], +["15x15"], +["15x16"], +["15x17"], +["15x18"], +["15x19"], +["15x20"], +["15x21"], +["15x22"], +["15x23"], +["15x24"], +["16x0"], +["16x1"], +["16x2"], +["16x3"], +["16x4"], +["16x5"], +["16x6"], +["16x7"], +["16x8"], +["16x9"], +["16x10"], +["16x11"], +["16x12"], +["16x13"], +["16x14"], +["16x15"], +["16x16"], +["16x17"], +["16x18"], +["16x19"], +["16x20"], +["16x21"], +["16x22"], +["16x23"], +["16x24"], +["17x0"], +["17x1"], +["17x2"], +["17x3"], +["17x4"], +["17x5"], +["17x6"], +["17x7"], +["17x8"], +["17x9"], +["17x10"], +["17x11"], +["17x12"], +["17x13"], +["17x14"], +["17x15"], +["17x16"], +["17x17"], +["17x18"], +["17x19"], +["17x20"], +["17x21"], +["17x22"], +["17x23"], +["17x24"], +["18x0"], +["18x1"], +["18x2"], +["18x3"], +["18x4"], +["18x5"], +["18x6"], +["18x7"], +["18x8"], +["18x9"], +["18x10"], +["18x11"], +["18x12"], +["18x13"], +["18x14"], +["18x15"], +["18x16"], +["18x17"], +["18x18"], +["18x19"], +["18x20"], +["18x21"], +["18x22"], +["18x23"], +["18x24"], +["19x0"], +["19x1"], +["19x2"], +["19x3"], +["19x4"], +["19x5"], +["19x6"], +["19x7"], +["19x8"], +["19x9"], +["19x10"], +["19x11"], +["19x12"], +["19x13"], +["19x14"], +["19x15"], +["19x16"], +["19x17"], +["19x18"], +["19x19"], +["19x20"], +["19x21"], +["19x22"], +["19x23"], +["19x24"], +["20x0"], +["20x1"], +["20x2"], +["20x3"], +["20x4"], +["20x5"], +["20x6"], +["20x7"], +["20x8"], +["20x9"], +["20x10"], +["20x11"], +["20x12"], +["20x13"], +["20x14"], +["20x15"], +["20x16"], +["20x17"], +["20x18"], +["20x19"], +["20x20"], +["20x21"], +["20x22"], +["20x23"], +["20x24"], +["21x0"], +["21x1"], +["21x2"], +["21x3"], +["21x4"], +["21x5"], +["21x6"], +["21x7"], +["21x8"], +["21x9"], +["21x10"], +["21x11"], +["21x12"], +["21x13"], +["21x14"], +["21x15"], +["21x16"], +["21x17"], +["21x18"], +["21x19"], +["21x20"], +["21x21"], +["21x22"], +["21x23"], +["21x24"], +["22x0"], +["22x1"], +["22x2"], +["22x3"], +["22x4"], +["22x5"], +["22x6"], +["22x7"], +["22x8"], +["22x9"], +["22x10"], +["22x11"], +["22x12"], +["22x13"], +["22x14"], +["22x15"], +["22x16"], +["22x17"], +["22x18"], +["22x19"], +["22x20"], +["22x21"], +["22x22"], +["22x23"], +["22x24"], +["23x0"], +["23x1"], +["23x2"], +["23x3"], +["23x4"], +["23x5"], +["23x6"], +["23x7"], +["23x8"], +["23x9"], +["23x10"], +["23x11"], +["23x12"], +["23x13"], +["23x14"], +["23x15"], +["23x16"], +["23x17"], +["23x18"], +["23x19"], +["23x20"], +["23x21"], +["23x22"], +["23x23"], +["23x24"], +["24x0"], +["24x1"], +["24x2"], +["24x3"], +["24x4"], +["24x5"], +["24x6"], +["24x7"], +["24x8"], +["24x9"], +["24x10"], +["24x11"], +["24x12"], +["24x13"], +["24x14"], +["24x15"], +["24x16"], +["24x17"], +["24x18"], +["24x19"], +["24x20"], +["24x21"], +["24x22"], +["24x23"], +["24x24"] +] +#@enable-logging Added: test/command/suite/select/filter/geo_in_circle/no_index/north_east.expected (+948 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_circle/no_index/north_east.expected 2013-12-13 23:14:39 +0900 (88d1578) @@ -0,0 +1,948 @@ +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 --filter 'geo_in_circle(point, "11x11", "11x1") > 0' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 309 + ], + [ + [ + "point", + "WGS84GeoPoint" + ] + ], + [ + "2x7" + ], + [ + "2x8" + ], + [ + "2x9" + ], + [ + "2x10" + ], + [ + "2x11" + ], + [ + "2x12" + ], + [ + "2x13" + ], + [ + "2x14" + ], + [ + "2x15" + ], + [ + "3x6" + ], + [ + "3x7" + ], + [ + "3x8" + ], + [ + "3x9" + ], + [ + "3x10" + ], + [ + "3x11" + ], + [ + "3x12" + ], + [ + "3x13" + ], + [ + "3x14" + ], + [ + "3x15" + ], + [ + "3x16" + ], + [ + "4x4" + ], + [ + "4x5" + ], + [ + "4x6" + ], + [ + "4x7" + ], + [ + "4x8" + ], + [ + "4x9" + ], + [ + "4x10" + ], + [ + "4x11" + ], + [ + "4x12" + ], + [ + "4x13" + ], + [ + "4x14" + ], + [ + "4x15" + ], + [ + "4x16" + ], + [ + "4x17" + ], + [ + "4x18" + ], + [ + "5x4" + ], + [ + "5x5" + ], + [ + "5x6" + ], + [ + "5x7" + ], + [ + "5x8" + ], + [ + "5x9" + ], + [ + "5x10" + ], + [ + "5x11" + ], + [ + "5x12" + ], + [ + "5x13" + ], + [ + "5x14" + ], + [ + "5x15" + ], + [ + "5x16" + ], + [ + "5x17" + ], + [ + "5x18" + ], + [ + "6x3" + ], + [ + "6x4" + ], + [ + "6x5" + ], + [ + "6x6" + ], + [ + "6x7" + ], + [ + "6x8" + ], + [ + "6x9" + ], + [ + "6x10" + ], + [ + "6x11" + ], + [ + "6x12" + ], + [ + "6x13" + ], + [ + "6x14" + ], + [ + "6x15" + ], + [ + "6x16" + ], + [ + "6x17" + ], + [ + "6x18" + ], + [ + "6x19" + ], + [ + "7x2" + ], + [ + "7x3" + ], + [ + "7x4" + ], + [ + "7x5" + ], + [ + "7x6" + ], + [ + "7x7" + ], + [ + "7x8" + ], + [ + "7x9" + ], + [ + "7x10" + ], + [ + "7x11" + ], + [ + "7x12" + ], + [ + "7x13" + ], + [ + "7x14" + ], + [ + "7x15" + ], + [ + "7x16" + ], + [ + "7x17" + ], + [ + "7x18" + ], + [ + "7x19" + ], + [ + "7x20" + ], + [ + "8x2" + ], + [ + "8x3" + ], + [ + "8x4" + ], + [ + "8x5" + ], + [ + "8x6" + ], + [ + "8x7" + ], + [ + "8x8" + ], + [ + "8x9" + ], + [ + "8x10" + ], + [ + "8x11" + ], + [ + "8x12" + ], + [ + "8x13" + ], + [ + "8x14" + ], + [ + "8x15" + ], + [ + "8x16" + ], + [ + "8x17" + ], + [ + "8x18" + ], + [ + "8x19" + ], + [ + "8x20" + ], + [ + "9x2" + ], + [ + "9x3" + ], + [ + "9x4" + ], + [ + "9x5" + ], + [ + "9x6" + ], + [ + "9x7" + ], + [ + "9x8" + ], + [ + "9x9" + ], + [ + "9x10" + ], + [ + "9x11" + ], + [ + "9x12" + ], + [ + "9x13" + ], + [ + "9x14" + ], + [ + "9x15" + ], + [ + "9x16" + ], + [ + "9x17" + ], + [ + "9x18" + ], + [ + "9x19" + ], + [ + "9x20" + ], + [ + "10x2" + ], + [ + "10x3" + ], + [ + "10x4" + ], + [ + "10x5" + ], + [ + "10x6" + ], + [ + "10x7" + ], + [ + "10x8" + ], + [ + "10x9" + ], + [ + "10x10" + ], + [ + "10x11" + ], + [ + "10x12" + ], + [ + "10x13" + ], + [ + "10x14" + ], + [ + "10x15" + ], + [ + "10x16" + ], + [ + "10x17" + ], + [ + "10x18" + ], + [ + "10x19" + ], + [ + "10x20" + ], + [ + "11x1" + ], + [ + "11x2" + ], + [ + "11x3" + ], + [ + "11x4" + ], + [ + "11x5" + ], + [ + "11x6" + ], + [ + "11x7" + ], + [ + "11x8" + ], + [ + "11x9" + ], + [ + "11x10" + ], + [ + "11x11" + ], + [ + "11x12" + ], + [ + "11x13" + ], + [ + "11x14" + ], + [ + "11x15" + ], + [ + "11x16" + ], + [ + "11x17" + ], + [ + "11x18" + ], + [ + "11x19" + ], + [ + "11x20" + ], + [ + "11x21" + ], + [ + "12x2" + ], + [ + "12x3" + ], + [ + "12x4" + ], + [ + "12x5" + ], + [ + "12x6" + ], + [ + "12x7" + ], + [ + "12x8" + ], + [ + "12x9" + ], + [ + "12x10" + ], + [ + "12x11" + ], + [ + "12x12" + ], + [ + "12x13" + ], + [ + "12x14" + ], + [ + "12x15" + ], + [ + "12x16" + ], + [ + "12x17" + ], + [ + "12x18" + ], + [ + "12x19" + ], + [ + "12x20" + ], + [ + "13x2" + ], + [ + "13x3" + ], + [ + "13x4" + ], + [ + "13x5" + ], + [ + "13x6" + ], + [ + "13x7" + ], + [ + "13x8" + ], + [ + "13x9" + ], + [ + "13x10" + ], + [ + "13x11" + ], + [ + "13x12" + ], + [ + "13x13" + ], + [ + "13x14" + ], + [ + "13x15" + ], + [ + "13x16" + ], + [ + "13x17" + ], + [ + "13x18" + ], + [ + "13x19" + ], + [ + "13x20" + ], + [ + "14x2" + ], + [ + "14x3" + ], + [ + "14x4" + ], + [ + "14x5" + ], + [ + "14x6" + ], + [ + "14x7" + ], + [ + "14x8" + ], + [ + "14x9" + ], + [ + "14x10" + ], + [ + "14x11" + ], + [ + "14x12" + ], + [ + "14x13" + ], + [ + "14x14" + ], + [ + "14x15" + ], + [ + "14x16" + ], + [ + "14x17" + ], + [ + "14x18" + ], + [ + "14x19" + ], + [ + "14x20" + ], + [ + "15x2" + ], + [ + "15x3" + ], + [ + "15x4" + ], + [ + "15x5" + ], + [ + "15x6" + ], + [ + "15x7" + ], + [ + "15x8" + ], + [ + "15x9" + ], + [ + "15x10" + ], + [ + "15x11" + ], + [ + "15x12" + ], + [ + "15x13" + ], + [ + "15x14" + ], + [ + "15x15" + ], + [ + "15x16" + ], + [ + "15x17" + ], + [ + "15x18" + ], + [ + "15x19" + ], + [ + "15x20" + ], + [ + "16x3" + ], + [ + "16x4" + ], + [ + "16x5" + ], + [ + "16x6" + ], + [ + "16x7" + ], + [ + "16x8" + ], + [ + "16x9" + ], + [ + "16x10" + ], + [ + "16x11" + ], + [ + "16x12" + ], + [ + "16x13" + ], + [ + "16x14" + ], + [ + "16x15" + ], + [ + "16x16" + ], + [ + "16x17" + ], + [ + "16x18" + ], + [ + "16x19" + ], + [ + "17x3" + ], + [ + "17x4" + ], + [ + "17x5" + ], + [ + "17x6" + ], + [ + "17x7" + ], + [ + "17x8" + ], + [ + "17x9" + ], + [ + "17x10" + ], + [ + "17x11" + ], + [ + "17x12" + ], + [ + "17x13" + ], + [ + "17x14" + ], + [ + "17x15" + ], + [ + "17x16" + ], + [ + "17x17" + ], + [ + "17x18" + ], + [ + "17x19" + ], + [ + "18x4" + ], + [ + "18x5" + ], + [ + "18x6" + ], + [ + "18x7" + ], + [ + "18x8" + ], + [ + "18x9" + ], + [ + "18x10" + ], + [ + "18x11" + ], + [ + "18x12" + ], + [ + "18x13" + ], + [ + "18x14" + ], + [ + "18x15" + ], + [ + "18x16" + ], + [ + "18x17" + ], + [ + "18x18" + ], + [ + "19x6" + ], + [ + "19x7" + ], + [ + "19x8" + ], + [ + "19x9" + ], + [ + "19x10" + ], + [ + "19x11" + ], + [ + "19x12" + ], + [ + "19x13" + ], + [ + "19x14" + ], + [ + "19x15" + ], + [ + "19x16" + ], + [ + "20x7" + ], + [ + "20x8" + ], + [ + "20x9" + ], + [ + "20x10" + ], + [ + "20x11" + ], + [ + "20x12" + ], + [ + "20x13" + ], + [ + "20x14" + ], + [ + "20x15" + ] + ] + ] +] Added: test/command/suite/select/filter/geo_in_circle/no_index/north_east.test (+4 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/geo_in_circle/no_index/north_east.test 2013-12-13 23:14:39 +0900 (a271b27) @@ -0,0 +1,4 @@ +#@include fixture/geo/in_circle/north_east.grn + +select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \ + --filter 'geo_in_circle(point, "11x11", "11x1") > 0' -------------- next part -------------- HTML����������������������������...Download
