[Groonga-commit] groonga/groonga at 461d623 [master] test: add geo_in_rectangle() tests for north/east area

Back to archive index

Kouhei Sutou null+****@clear*****
Sat Dec 7 18:19:04 JST 2013


Kouhei Sutou	2013-12-07 18:19:04 +0900 (Sat, 07 Dec 2013)

  New Revision: 461d6234cae6dc3f90363dcc0883d3460453609f
  https://github.com/groonga/groonga/commit/461d6234cae6dc3f90363dcc0883d3460453609f

  Message:
    test: add geo_in_rectangle() tests for north/east area

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

  Added: test/command/fixture/geo/in_rectangle/ddl.grn (+6 -0) 100644
===================================================================
--- /dev/null
+++ test/command/fixture/geo/in_rectangle/ddl.grn    2013-12-07 18:19:04 +0900 (a7044dd)
@@ -0,0 +1,6 @@
+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
+

  Added: test/command/fixture/geo/in_rectangle/north_east.grn (+265 -0) 100644
===================================================================
--- /dev/null
+++ test/command/fixture/geo/in_rectangle/north_east.grn    2013-12-07 18:19:04 +0900 (6a4a831)
@@ -0,0 +1,265 @@
+#@disable-logging
+#@include fixture/geo/in_rectangle/ddl.grn
+
+load --table LandMarks
+[
+["point"],
+["0x0"],
+["0x1"],
+["0x2"],
+["0x3"],
+["0x4"],
+["0x5"],
+["0x6"],
+["0x7"],
+["0x8"],
+["0x9"],
+["0x10"],
+["0x11"],
+["0x12"],
+["0x13"],
+["0x14"],
+["0x15"],
+["1x0"],
+["1x1"],
+["1x2"],
+["1x3"],
+["1x4"],
+["1x5"],
+["1x6"],
+["1x7"],
+["1x8"],
+["1x9"],
+["1x10"],
+["1x11"],
+["1x12"],
+["1x13"],
+["1x14"],
+["1x15"],
+["2x0"],
+["2x1"],
+["2x2"],
+["2x3"],
+["2x4"],
+["2x5"],
+["2x6"],
+["2x7"],
+["2x8"],
+["2x9"],
+["2x10"],
+["2x11"],
+["2x12"],
+["2x13"],
+["2x14"],
+["2x15"],
+["3x0"],
+["3x1"],
+["3x2"],
+["3x3"],
+["3x4"],
+["3x5"],
+["3x6"],
+["3x7"],
+["3x8"],
+["3x9"],
+["3x10"],
+["3x11"],
+["3x12"],
+["3x13"],
+["3x14"],
+["3x15"],
+["4x0"],
+["4x1"],
+["4x2"],
+["4x3"],
+["4x4"],
+["4x5"],
+["4x6"],
+["4x7"],
+["4x8"],
+["4x9"],
+["4x10"],
+["4x11"],
+["4x12"],
+["4x13"],
+["4x14"],
+["4x15"],
+["5x0"],
+["5x1"],
+["5x2"],
+["5x3"],
+["5x4"],
+["5x5"],
+["5x6"],
+["5x7"],
+["5x8"],
+["5x9"],
+["5x10"],
+["5x11"],
+["5x12"],
+["5x13"],
+["5x14"],
+["5x15"],
+["6x0"],
+["6x1"],
+["6x2"],
+["6x3"],
+["6x4"],
+["6x5"],
+["6x6"],
+["6x7"],
+["6x8"],
+["6x9"],
+["6x10"],
+["6x11"],
+["6x12"],
+["6x13"],
+["6x14"],
+["6x15"],
+["7x0"],
+["7x1"],
+["7x2"],
+["7x3"],
+["7x4"],
+["7x5"],
+["7x6"],
+["7x7"],
+["7x8"],
+["7x9"],
+["7x10"],
+["7x11"],
+["7x12"],
+["7x13"],
+["7x14"],
+["7x15"],
+["8x0"],
+["8x1"],
+["8x2"],
+["8x3"],
+["8x4"],
+["8x5"],
+["8x6"],
+["8x7"],
+["8x8"],
+["8x9"],
+["8x10"],
+["8x11"],
+["8x12"],
+["8x13"],
+["8x14"],
+["8x15"],
+["9x0"],
+["9x1"],
+["9x2"],
+["9x3"],
+["9x4"],
+["9x5"],
+["9x6"],
+["9x7"],
+["9x8"],
+["9x9"],
+["9x10"],
+["9x11"],
+["9x12"],
+["9x13"],
+["9x14"],
+["9x15"],
+["10x0"],
+["10x1"],
+["10x2"],
+["10x3"],
+["10x4"],
+["10x5"],
+["10x6"],
+["10x7"],
+["10x8"],
+["10x9"],
+["10x10"],
+["10x11"],
+["10x12"],
+["10x13"],
+["10x14"],
+["10x15"],
+["11x0"],
+["11x1"],
+["11x2"],
+["11x3"],
+["11x4"],
+["11x5"],
+["11x6"],
+["11x7"],
+["11x8"],
+["11x9"],
+["11x10"],
+["11x11"],
+["11x12"],
+["11x13"],
+["11x14"],
+["11x15"],
+["12x0"],
+["12x1"],
+["12x2"],
+["12x3"],
+["12x4"],
+["12x5"],
+["12x6"],
+["12x7"],
+["12x8"],
+["12x9"],
+["12x10"],
+["12x11"],
+["12x12"],
+["12x13"],
+["12x14"],
+["12x15"],
+["13x0"],
+["13x1"],
+["13x2"],
+["13x3"],
+["13x4"],
+["13x5"],
+["13x6"],
+["13x7"],
+["13x8"],
+["13x9"],
+["13x10"],
+["13x11"],
+["13x12"],
+["13x13"],
+["13x14"],
+["13x15"],
+["14x0"],
+["14x1"],
+["14x2"],
+["14x3"],
+["14x4"],
+["14x5"],
+["14x6"],
+["14x7"],
+["14x8"],
+["14x9"],
+["14x10"],
+["14x11"],
+["14x12"],
+["14x13"],
+["14x14"],
+["14x15"],
+["15x0"],
+["15x1"],
+["15x2"],
+["15x3"],
+["15x4"],
+["15x5"],
+["15x6"],
+["15x7"],
+["15x8"],
+["15x9"],
+["15x10"],
+["15x11"],
+["15x12"],
+["15x13"],
+["15x14"],
+["15x15"]
+]
+
+#@enable-logging

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/all_out.expected (+69 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/all_out.expected    2013-12-07 18:19:04 +0900 (29756c5)
@@ -0,0 +1,69 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "4x1", "1x4")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        16
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "1x1"
+      ],
+      [
+        "1x2"
+      ],
+      [
+        "1x3"
+      ],
+      [
+        "1x4"
+      ],
+      [
+        "2x1"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "2x4"
+      ],
+      [
+        "3x1"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "3x4"
+      ],
+      [
+        "4x1"
+      ],
+      [
+        "4x2"
+      ],
+      [
+        "4x3"
+      ],
+      [
+        "4x4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/all_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/all_out.test    2013-12-07 18:19:04 +0900 (476331b)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "4x1", "1x4")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/east_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/east_out.expected    2013-12-07 18:19:04 +0900 (6fb57fb)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x2", "2x4")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "2x4"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "3x4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/east_out.test    2013-12-07 18:19:04 +0900 (97ce456)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x2", "2x4")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/east_west_out.expected (+45 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/east_west_out.expected    2013-12-07 18:19:04 +0900 (1bcfc7d)
@@ -0,0 +1,45 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x1", "2x4")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        8
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x1"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "2x4"
+      ],
+      [
+        "3x1"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "3x4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/east_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/east_west_out.test    2013-12-07 18:19:04 +0900 (6601269)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x1", "2x4")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_east_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_east_out.expected    2013-12-07 18:19:04 +0900 (5dcf99a)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "4x2", "2x4")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "2x4"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "3x4"
+      ],
+      [
+        "4x2"
+      ],
+      [
+        "4x3"
+      ],
+      [
+        "4x4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_east_out.test    2013-12-07 18:19:04 +0900 (1c61c0d)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "4x2", "2x4")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_out.expected    2013-12-07 18:19:04 +0900 (5820bec)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "4x2", "2x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "4x2"
+      ],
+      [
+        "4x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_out.test    2013-12-07 18:19:04 +0900 (140c8d6)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "4x2", "2x3")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_south_out.expected (+45 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_south_out.expected    2013-12-07 18:19:04 +0900 (cc968e6)
@@ -0,0 +1,45 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "4x2", "1x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        8
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "1x2"
+      ],
+      [
+        "1x3"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "4x2"
+      ],
+      [
+        "4x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_south_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_south_out.test    2013-12-07 18:19:04 +0900 (3b777db)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "4x2", "1x3")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_west_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_west_out.expected    2013-12-07 18:19:04 +0900 (29d265b)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "4x1", "2x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x1"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x1"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "4x1"
+      ],
+      [
+        "4x2"
+      ],
+      [
+        "4x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/north_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/north_west_out.test    2013-12-07 18:19:04 +0900 (f6265a8)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "4x1", "2x3")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/same_as_mesh.expected (+33 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/same_as_mesh.expected    2013-12-07 18:19:04 +0900 (a4dbbfc)
@@ -0,0 +1,33 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x2", "2x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        4
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/same_as_mesh.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/same_as_mesh.test    2013-12-07 18:19:04 +0900 (4179e6a)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x2", "2x3")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/south_east_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/south_east_out.expected    2013-12-07 18:19:04 +0900 (8d7c2ca)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x2", "1x4")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "1x2"
+      ],
+      [
+        "1x3"
+      ],
+      [
+        "1x4"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "2x4"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ],
+      [
+        "3x4"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/south_east_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/south_east_out.test    2013-12-07 18:19:04 +0900 (84ae9d5)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x2", "1x4")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/south_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/south_out.expected    2013-12-07 18:19:04 +0900 (04fcd34)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x2", "1x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "1x2"
+      ],
+      [
+        "1x3"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/south_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/south_out.test    2013-12-07 18:19:04 +0900 (c36dcae)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x2", "1x3")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/south_west_out.expected (+48 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/south_west_out.expected    2013-12-07 18:19:04 +0900 (5b8c836)
@@ -0,0 +1,48 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x1", "1x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        9
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "1x1"
+      ],
+      [
+        "1x2"
+      ],
+      [
+        "1x3"
+      ],
+      [
+        "2x1"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x1"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/south_west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/south_west_out.test    2013-12-07 18:19:04 +0900 (7186a20)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x1", "1x3")'

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/west_out.expected (+39 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/west_out.expected    2013-12-07 18:19:04 +0900 (b3191de)
@@ -0,0 +1,39 @@
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1   --filter 'geo_in_rectangle(point, "3x1", "2x3")'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        6
+      ],
+      [
+        [
+          "point",
+          "WGS84GeoPoint"
+        ]
+      ],
+      [
+        "2x1"
+      ],
+      [
+        "2x2"
+      ],
+      [
+        "2x3"
+      ],
+      [
+        "3x1"
+      ],
+      [
+        "3x2"
+      ],
+      [
+        "3x3"
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/geo_in_rectangle/north_east/west_out.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/geo_in_rectangle/north_east/west_out.test    2013-12-07 18:19:04 +0900 (3cd71bd)
@@ -0,0 +1,4 @@
+#@include fixture/geo/in_rectangle/north_east.grn
+
+select LandMarks --sortby '_id' --output_columns 'point' --limit -1 \
+  --filter 'geo_in_rectangle(point, "3x1", "2x3")'
-------------- next part --------------
HTML����������������������������...
다운로드 



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