[Groonga-commit] groonga/groonga at f634f53 [master] geo_in_rectangle: support east longitude to west longitude in south area without index

Back to archive index

Kouhei Sutou null+****@clear*****
Sun Dec 8 23:42:46 JST 2013


Kouhei Sutou	2013-12-08 23:42:46 +0900 (Sun, 08 Dec 2013)

  New Revision: f634f5368f16693d86425306b51e597731a9a92c
  https://github.com/groonga/groonga/commit/f634f5368f16693d86425306b51e597731a9a92c

  Message:
    geo_in_rectangle: support east longitude to west longitude in south area without index
    
    TODO: Document it.
    
    geo_in_rectangle(column, "-100x-100", "-200x100") means
    
           -100  |   100
         ---+----+----+---
                 |
            +- -100 --+
            |    |    |
            +- -200 --+
                 |
    
    geo_in_rectangle(column, "-100x100", "-200x-100") means
    
           -100  |   100
         ---+----+----+---
                 |
         ---+  -100   +---
            |    |    |
         ---+  -200   +---
                 |

  Added files:
    test/command/fixture/geo/in_rectangle/south/around_180.grn
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/all_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/all_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_west_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_west_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_east_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_east_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_south_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_south_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_west_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_west_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/same_as_mesh.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/same_as_mesh.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_east_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_east_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_west_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_west_out.test
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/west_out.expected
    test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/west_out.test

  Added: test/command/fixture/geo/in_rectangle/south/around_180.grn (+264 -0) 100644
===================================================================
--- /dev/null
+++ test/command/fixture/geo/in_rectangle/south/around_180.grn    2013-12-08 23:42:46 +0900 (a0791c6)
@@ -0,0 +1,264 @@
+#@include fixture/geo/in_rectangle/ddl.grn
+
+#@disable-logging
+load --table LandMarks
+[
+["point"],
+["-1x-647999999"],
+["-1x-647999998"],
+["-1x-647999997"],
+["-1x-647999996"],
+["-1x-647999995"],
+["-1x-647999994"],
+["-1x-647999993"],
+["-1x-647999992"],
+["-1x647999992"],
+["-1x647999993"],
+["-1x647999994"],
+["-1x647999995"],
+["-1x647999996"],
+["-1x647999997"],
+["-1x647999998"],
+["-1x647999999"],
+["-2x-647999999"],
+["-2x-647999998"],
+["-2x-647999997"],
+["-2x-647999996"],
+["-2x-647999995"],
+["-2x-647999994"],
+["-2x-647999993"],
+["-2x-647999992"],
+["-2x647999992"],
+["-2x647999993"],
+["-2x647999994"],
+["-2x647999995"],
+["-2x647999996"],
+["-2x647999997"],
+["-2x647999998"],
+["-2x647999999"],
+["-3x-647999999"],
+["-3x-647999998"],
+["-3x-647999997"],
+["-3x-647999996"],
+["-3x-647999995"],
+["-3x-647999994"],
+["-3x-647999993"],
+["-3x-647999992"],
+["-3x647999992"],
+["-3x647999993"],
+["-3x647999994"],
+["-3x647999995"],
+["-3x647999996"],
+["-3x647999997"],
+["-3x647999998"],
+["-3x647999999"],
+["-4x-647999999"],
+["-4x-647999998"],
+["-4x-647999997"],
+["-4x-647999996"],
+["-4x-647999995"],
+["-4x-647999994"],
+["-4x-647999993"],
+["-4x-647999992"],
+["-4x647999992"],
+["-4x647999993"],
+["-4x647999994"],
+["-4x647999995"],
+["-4x647999996"],
+["-4x647999997"],
+["-4x647999998"],
+["-4x647999999"],
+["-5x-647999999"],
+["-5x-647999998"],
+["-5x-647999997"],
+["-5x-647999996"],
+["-5x-647999995"],
+["-5x-647999994"],
+["-5x-647999993"],
+["-5x-647999992"],
+["-5x647999992"],
+["-5x647999993"],
+["-5x647999994"],
+["-5x647999995"],
+["-5x647999996"],
+["-5x647999997"],
+["-5x647999998"],
+["-5x647999999"],
+["-6x-647999999"],
+["-6x-647999998"],
+["-6x-647999997"],
+["-6x-647999996"],
+["-6x-647999995"],
+["-6x-647999994"],
+["-6x-647999993"],
+["-6x-647999992"],
+["-6x647999992"],
+["-6x647999993"],
+["-6x647999994"],
+["-6x647999995"],
+["-6x647999996"],
+["-6x647999997"],
+["-6x647999998"],
+["-6x647999999"],
+["-7x-647999999"],
+["-7x-647999998"],
+["-7x-647999997"],
+["-7x-647999996"],
+["-7x-647999995"],
+["-7x-647999994"],
+["-7x-647999993"],
+["-7x-647999992"],
+["-7x647999992"],
+["-7x647999993"],
+["-7x647999994"],
+["-7x647999995"],
+["-7x647999996"],
+["-7x647999997"],
+["-7x647999998"],
+["-7x647999999"],
+["-8x-647999999"],
+["-8x-647999998"],
+["-8x-647999997"],
+["-8x-647999996"],
+["-8x-647999995"],
+["-8x-647999994"],
+["-8x-647999993"],
+["-8x-647999992"],
+["-8x647999992"],
+["-8x647999993"],
+["-8x647999994"],
+["-8x647999995"],
+["-8x647999996"],
+["-8x647999997"],
+["-8x647999998"],
+["-8x647999999"],
+["-9x-647999999"],
+["-9x-647999998"],
+["-9x-647999997"],
+["-9x-647999996"],
+["-9x-647999995"],
+["-9x-647999994"],
+["-9x-647999993"],
+["-9x-647999992"],
+["-9x647999992"],
+["-9x647999993"],
+["-9x647999994"],
+["-9x647999995"],
+["-9x647999996"],
+["-9x647999997"],
+["-9x647999998"],
+["-9x647999999"],
+["-10x-647999999"],
+["-10x-647999998"],
+["-10x-647999997"],
+["-10x-647999996"],
+["-10x-647999995"],
+["-10x-647999994"],
+["-10x-647999993"],
+["-10x-647999992"],
+["-10x647999992"],
+["-10x647999993"],
+["-10x647999994"],
+["-10x647999995"],
+["-10x647999996"],
+["-10x647999997"],
+["-10x647999998"],
+["-10x647999999"],
+["-11x-647999999"],
+["-11x-647999998"],
+["-11x-647999997"],
+["-11x-647999996"],
+["-11x-647999995"],
+["-11x-647999994"],
+["-11x-647999993"],
+["-11x-647999992"],
+["-11x647999992"],
+["-11x647999993"],
+["-11x647999994"],
+["-11x647999995"],
+["-11x647999996"],
+["-11x647999997"],
+["-11x647999998"],
+["-11x647999999"],
+["-12x-647999999"],
+["-12x-647999998"],
+["-12x-647999997"],
+["-12x-647999996"],
+["-12x-647999995"],
+["-12x-647999994"],
+["-12x-647999993"],
+["-12x-647999992"],
+["-12x647999992"],
+["-12x647999993"],
+["-12x647999994"],
+["-12x647999995"],
+["-12x647999996"],
+["-12x647999997"],
+["-12x647999998"],
+["-12x647999999"],
+["-13x-647999999"],
+["-13x-647999998"],
+["-13x-647999997"],
+["-13x-647999996"],
+["-13x-647999995"],
+["-13x-647999994"],
+["-13x-647999993"],
+["-13x-647999992"],
+["-13x647999992"],
+["-13x647999993"],
+["-13x647999994"],
+["-13x647999995"],
+["-13x647999996"],
+["-13x647999997"],
+["-13x647999998"],
+["-13x647999999"],
+["-14x-647999999"],
+["-14x-647999998"],
+["-14x-647999997"],
+["-14x-647999996"],
+["-14x-647999995"],
+["-14x-647999994"],
+["-14x-647999993"],
+["-14x-647999992"],
+["-14x647999992"],
+["-14x647999993"],
+["-14x647999994"],
+["-14x647999995"],
+["-14x647999996"],
+["-14x647999997"],
+["-14x647999998"],
+["-14x647999999"],
+["-15x-647999999"],
+["-15x-647999998"],
+["-15x-647999997"],
+["-15x-647999996"],
+["-15x-647999995"],
+["-15x-647999994"],
+["-15x-647999993"],
+["-15x-647999992"],
+["-15x647999992"],
+["-15x647999993"],
+["-15x647999994"],
+["-15x647999995"],
+["-15x647999996"],
+["-15x647999997"],
+["-15x647999998"],
+["-15x647999999"],
+["-16x-647999999"],
+["-16x-647999998"],
+["-16x-647999997"],
+["-16x-647999996"],
+["-16x-647999995"],
+["-16x-647999994"],
+["-16x-647999993"],
+["-16x-647999992"],
+["-16x647999992"],
+["-16x647999993"],
+["-16x647999994"],
+["-16x647999995"],
+["-16x647999996"],
+["-16x647999997"],
+["-16x647999998"],
+["-16x647999999"]
+]
+#@enable-logging

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/all_out.expected (+93 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/all_out.expected    2013-12-08 23:42:46 +0900 (560acf6)
@@ -0,0 +1,93 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x647999997", "-5x-647999997") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        24
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-647999999"
+      ],
+      [
+        "-2x-647999998"
+      ],
+      [
+        "-2x-647999997"
+      ],
+      [
+        "-2x647999997"
+      ],
+      [
+        "-2x647999998"
+      ],
+      [
+        "-2x647999999"
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x-647999997"
+      ],
+      [
+        "-3x647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x-647999997"
+      ],
+      [
+        "-4x647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ],
+      [
+        "-5x-647999999"
+      ],
+      [
+        "-5x-647999998"
+      ],
+      [
+        "-5x-647999997"
+      ],
+      [
+        "-5x647999997"
+      ],
+      [
+        "-5x647999998"
+      ],
+      [
+        "-5x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/all_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/all_out.test    2013-12-08 23:42:46 +0900 (05eb229)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x647999997", "-5x-647999997") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_out.expected (+51 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_out.expected    2013-12-08 23:42:46 +0900 (361d66b)
@@ -0,0 +1,51 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999997", "-4x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        10
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_out.test    2013-12-08 23:42:46 +0900 (8946a50)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999997", "-4x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_west_out.expected (+57 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_west_out.expected    2013-12-08 23:42:46 +0900 (e86111d)
@@ -0,0 +1,57 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999997", "-4x-647999997") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        12
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x-647999997"
+      ],
+      [
+        "-3x647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x-647999997"
+      ],
+      [
+        "-4x647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/east_west_out.test    2013-12-08 23:42:46 +0900 (64fde73)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999997", "-4x-647999997") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_east_out.expected (+66 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_east_out.expected    2013-12-08 23:42:46 +0900 (76e2b3e)
@@ -0,0 +1,66 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x647999997", "-4x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        15
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-647999999"
+      ],
+      [
+        "-2x-647999998"
+      ],
+      [
+        "-2x647999997"
+      ],
+      [
+        "-2x647999998"
+      ],
+      [
+        "-2x647999999"
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_east_out.test    2013-12-08 23:42:46 +0900 (f717db9)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x647999997", "-4x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_out.expected (+57 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_out.expected    2013-12-08 23:42:46 +0900 (1e577bf)
@@ -0,0 +1,57 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x647999998", "-4x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        12
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-647999999"
+      ],
+      [
+        "-2x-647999998"
+      ],
+      [
+        "-2x647999998"
+      ],
+      [
+        "-2x647999999"
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_out.test    2013-12-08 23:42:46 +0900 (857c88f)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x647999998", "-4x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_south_out.expected (+69 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_south_out.expected    2013-12-08 23:42:46 +0900 (4c61b16)
@@ -0,0 +1,69 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x647999998", "-5x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        16
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-647999999"
+      ],
+      [
+        "-2x-647999998"
+      ],
+      [
+        "-2x647999998"
+      ],
+      [
+        "-2x647999999"
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ],
+      [
+        "-5x-647999999"
+      ],
+      [
+        "-5x-647999998"
+      ],
+      [
+        "-5x647999998"
+      ],
+      [
+        "-5x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_south_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_south_out.test    2013-12-08 23:42:46 +0900 (121d8db)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x647999998", "-5x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_west_out.expected (+66 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_west_out.expected    2013-12-08 23:42:46 +0900 (1ee0a28)
@@ -0,0 +1,66 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x647999998", "-4x-647999997") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        15
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-647999999"
+      ],
+      [
+        "-2x-647999998"
+      ],
+      [
+        "-2x-647999997"
+      ],
+      [
+        "-2x647999998"
+      ],
+      [
+        "-2x647999999"
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x-647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x-647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/north_west_out.test    2013-12-08 23:42:46 +0900 (eaba273)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x647999998", "-4x-647999997") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/same_as_mesh.expected (+45 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/same_as_mesh.expected    2013-12-08 23:42:46 +0900 (18bb603)
@@ -0,0 +1,45 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999998", "-4x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        8
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/same_as_mesh.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/same_as_mesh.test    2013-12-08 23:42:46 +0900 (807bc6b)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999998", "-4x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_east_out.expected (+66 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_east_out.expected    2013-12-08 23:42:46 +0900 (dfbc69e)
@@ -0,0 +1,66 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999997", "-5x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        15
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ],
+      [
+        "-5x-647999999"
+      ],
+      [
+        "-5x-647999998"
+      ],
+      [
+        "-5x647999997"
+      ],
+      [
+        "-5x647999998"
+      ],
+      [
+        "-5x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_east_out.test    2013-12-08 23:42:46 +0900 (8937640)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999997", "-5x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_out.expected (+57 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_out.expected    2013-12-08 23:42:46 +0900 (bab0c0a)
@@ -0,0 +1,57 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999998", "-5x-647999998") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        12
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ],
+      [
+        "-5x-647999999"
+      ],
+      [
+        "-5x-647999998"
+      ],
+      [
+        "-5x647999998"
+      ],
+      [
+        "-5x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_out.test    2013-12-08 23:42:46 +0900 (a6641fb)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999998", "-5x-647999998") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_west_out.expected (+66 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_west_out.expected    2013-12-08 23:42:46 +0900 (cb884e8)
@@ -0,0 +1,66 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999998", "-5x-647999997") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        15
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x-647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x-647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ],
+      [
+        "-5x-647999999"
+      ],
+      [
+        "-5x-647999998"
+      ],
+      [
+        "-5x-647999997"
+      ],
+      [
+        "-5x647999998"
+      ],
+      [
+        "-5x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/south_west_out.test    2013-12-08 23:42:46 +0900 (8361f11)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999998", "-5x-647999997") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/west_out.expected (+51 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/west_out.expected    2013-12-08 23:42:46 +0900 (2f3006b)
@@ -0,0 +1,51 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x647999998", "-4x-647999997") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        10
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-647999999"
+      ],
+      [
+        "-3x-647999998"
+      ],
+      [
+        "-3x-647999997"
+      ],
+      [
+        "-3x647999998"
+      ],
+      [
+        "-3x647999999"
+      ],
+      [
+        "-4x-647999999"
+      ],
+      [
+        "-4x-647999998"
+      ],
+      [
+        "-4x-647999997"
+      ],
+      [
+        "-4x647999998"
+      ],
+      [
+        "-4x647999999"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south/around_180/no_index/west_out.test    2013-12-08 23:42:46 +0900 (d68426d)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south/around_180.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x647999998", "-4x-647999997") > 0'
-------------- next part --------------
HTML����������������������������...
下载 



More information about the Groonga-commit mailing list
Back to archive index