[Groonga-commit] groonga/groonga at 34b47c7 [master] test geo_in_rectangle: add tests for south/west area without index use

Back to archive index

Kouhei Sutou null+****@clear*****
Sat Dec 7 23:02:58 JST 2013


Kouhei Sutou	2013-12-07 23:02:58 +0900 (Sat, 07 Dec 2013)

  New Revision: 34b47c76f62a00272b9c79664d8079d26ae4df18
  https://github.com/groonga/groonga/commit/34b47c76f62a00272b9c79664d8079d26ae4df18

  Message:
    test geo_in_rectangle: add tests for south/west area without index use

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

  Added: test/command/fixture/geo/in_rectangle/south_west.grn (+264 -0) 100644
===================================================================
--- /dev/null
+++ test/command/fixture/geo/in_rectangle/south_west.grn    2013-12-07 23:02:58 +0900 (b860d51)
@@ -0,0 +1,264 @@
+#@include fixture/geo/in_rectangle/ddl.grn
+
+#@disable-logging
+load --table LandMarks
+[
+["point"],
+["-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"],
+["-9x-1"],
+["-9x-2"],
+["-9x-3"],
+["-9x-4"],
+["-9x-5"],
+["-9x-6"],
+["-9x-7"],
+["-9x-8"],
+["-9x-9"],
+["-9x-10"],
+["-9x-11"],
+["-9x-12"],
+["-9x-13"],
+["-9x-14"],
+["-9x-15"],
+["-9x-16"],
+["-10x-1"],
+["-10x-2"],
+["-10x-3"],
+["-10x-4"],
+["-10x-5"],
+["-10x-6"],
+["-10x-7"],
+["-10x-8"],
+["-10x-9"],
+["-10x-10"],
+["-10x-11"],
+["-10x-12"],
+["-10x-13"],
+["-10x-14"],
+["-10x-15"],
+["-10x-16"],
+["-11x-1"],
+["-11x-2"],
+["-11x-3"],
+["-11x-4"],
+["-11x-5"],
+["-11x-6"],
+["-11x-7"],
+["-11x-8"],
+["-11x-9"],
+["-11x-10"],
+["-11x-11"],
+["-11x-12"],
+["-11x-13"],
+["-11x-14"],
+["-11x-15"],
+["-11x-16"],
+["-12x-1"],
+["-12x-2"],
+["-12x-3"],
+["-12x-4"],
+["-12x-5"],
+["-12x-6"],
+["-12x-7"],
+["-12x-8"],
+["-12x-9"],
+["-12x-10"],
+["-12x-11"],
+["-12x-12"],
+["-12x-13"],
+["-12x-14"],
+["-12x-15"],
+["-12x-16"],
+["-13x-1"],
+["-13x-2"],
+["-13x-3"],
+["-13x-4"],
+["-13x-5"],
+["-13x-6"],
+["-13x-7"],
+["-13x-8"],
+["-13x-9"],
+["-13x-10"],
+["-13x-11"],
+["-13x-12"],
+["-13x-13"],
+["-13x-14"],
+["-13x-15"],
+["-13x-16"],
+["-14x-1"],
+["-14x-2"],
+["-14x-3"],
+["-14x-4"],
+["-14x-5"],
+["-14x-6"],
+["-14x-7"],
+["-14x-8"],
+["-14x-9"],
+["-14x-10"],
+["-14x-11"],
+["-14x-12"],
+["-14x-13"],
+["-14x-14"],
+["-14x-15"],
+["-14x-16"],
+["-15x-1"],
+["-15x-2"],
+["-15x-3"],
+["-15x-4"],
+["-15x-5"],
+["-15x-6"],
+["-15x-7"],
+["-15x-8"],
+["-15x-9"],
+["-15x-10"],
+["-15x-11"],
+["-15x-12"],
+["-15x-13"],
+["-15x-14"],
+["-15x-15"],
+["-15x-16"],
+["-16x-1"],
+["-16x-2"],
+["-16x-3"],
+["-16x-4"],
+["-16x-5"],
+["-16x-6"],
+["-16x-7"],
+["-16x-8"],
+["-16x-9"],
+["-16x-10"],
+["-16x-11"],
+["-16x-12"],
+["-16x-13"],
+["-16x-14"],
+["-16x-15"],
+["-16x-16"]
+]
+#@enable-logging

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_out.expected    2013-12-07 23:02:58 +0900 (a9136b9)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-4", "-4x-2") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-2"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-2"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_out.test    2013-12-07 23:02:58 +0900 (9123f8c)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-4", "-4x-2") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_west_out.expected (+45 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_west_out.expected    2013-12-07 23:02:58 +0900 (4a6c847)
@@ -0,0 +1,45 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-5", "-4x-2") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        8
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-2"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-3x-5"
+      ],
+      [
+        "-4x-2"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-4x-5"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/east_west_out.test    2013-12-07 23:02:58 +0900 (1e8bff4)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-5", "-4x-2") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_east_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_east_out.expected    2013-12-07 23:02:58 +0900 (98f5076)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x-4", "-4x-2") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-2"
+      ],
+      [
+        "-2x-3"
+      ],
+      [
+        "-2x-4"
+      ],
+      [
+        "-3x-2"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-2"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_east_out.test    2013-12-07 23:02:58 +0900 (b910716)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x-4", "-4x-2") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_out.expected    2013-12-07 23:02:58 +0900 (006b2a0)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x-4", "-4x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-3"
+      ],
+      [
+        "-2x-4"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_out.test    2013-12-07 23:02:58 +0900 (8d6b8f0)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x-4", "-4x-3") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_south_out.expected (+45 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_south_out.expected    2013-12-07 23:02:58 +0900 (64ba8e1)
@@ -0,0 +1,45 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x-4", "-5x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        8
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-3"
+      ],
+      [
+        "-2x-4"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-5x-3"
+      ],
+      [
+        "-5x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_south_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_south_out.test    2013-12-07 23:02:58 +0900 (3061bf6)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x-4", "-5x-3") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_west_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_west_out.expected    2013-12-07 23:02:58 +0900 (c3f0080)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-2x-5", "-4x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-2x-3"
+      ],
+      [
+        "-2x-4"
+      ],
+      [
+        "-2x-5"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-3x-5"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-4x-5"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/north_west_out.test    2013-12-07 23:02:58 +0900 (2a77f26)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-2x-5", "-4x-3") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/same_as_mesh.expected (+33 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/same_as_mesh.expected    2013-12-07 23:02:58 +0900 (9984f51)
@@ -0,0 +1,33 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-4", "-4x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        4
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/same_as_mesh.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/same_as_mesh.test    2013-12-07 23:02:58 +0900 (f93ef37)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-4", "-4x-3") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_east_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_east_out.expected    2013-12-07 23:02:58 +0900 (fd7f26e)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-4", "-5x-2") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-2"
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-2"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-5x-2"
+      ],
+      [
+        "-5x-3"
+      ],
+      [
+        "-5x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_east_out.test    2013-12-07 23:02:58 +0900 (af6a1e6)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-4", "-5x-2") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_out.expected    2013-12-07 23:02:58 +0900 (7d2139e)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-4", "-5x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-5x-3"
+      ],
+      [
+        "-5x-4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_out.test    2013-12-07 23:02:58 +0900 (61e745a)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-4", "-5x-3") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_west_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_west_out.expected    2013-12-07 23:02:58 +0900 (acbcf6d)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-5", "-5x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-3x-5"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-4x-5"
+      ],
+      [
+        "-5x-3"
+      ],
+      [
+        "-5x-4"
+      ],
+      [
+        "-5x-5"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/south_west_out.test    2013-12-07 23:02:58 +0900 (bf02929)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-5", "-5x-3") > 0'

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/west_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/west_out.expected    2013-12-07 23:02:58 +0900 (3501650)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "-3x-5", "-4x-3") > 0'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "-3x-3"
+      ],
+      [
+        "-3x-4"
+      ],
+      [
+        "-3x-5"
+      ],
+      [
+        "-4x-3"
+      ],
+      [
+        "-4x-4"
+      ],
+      [
+        "-4x-5"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/south_west/no_index/west_out.test    2013-12-07 23:02:58 +0900 (4982314)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/south_west.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "-3x-5", "-4x-3") > 0'
-------------- next part --------------
HTML����������������������������...
Download 



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