[Groonga-commit] groonga/groonga at eb6c646 [master] test logical_range_filter: add tests for month and day mixed shard types

Back to archive index

Kouhei Sutou null+****@clear*****
Tue Jun 23 22:38:30 JST 2015


Kouhei Sutou	2015-06-23 22:38:30 +0900 (Tue, 23 Jun 2015)

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

  Message:
    test logical_range_filter: add tests for month and day mixed shard types

  Added files:
    test/command/fixture/sharding/logical_range_filter/shard_type/month_day.grn
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/all.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/all.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/all.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/all.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_exclude.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_exclude.test
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_include.expected
    test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_include.test

  Added: test/command/fixture/sharding/logical_range_filter/shard_type/month_day.grn (+142 -0) 100644
===================================================================
--- /dev/null
+++ test/command/fixture/sharding/logical_range_filter/shard_type/month_day.grn    2015-06-23 22:38:30 +0900 (49338b2)
@@ -0,0 +1,142 @@
+#@disable-logging
+
+#@on-error omit
+register sharding
+#@on-error default
+
+table_create Logs_201501 TABLE_NO_KEY
+column_create Logs_201501 timestamp COLUMN_SCALAR Time
+column_create Logs_201501 memo COLUMN_SCALAR ShortText
+column_create Logs_201501 message COLUMN_SCALAR Text
+
+table_create Timestamps_201501 TABLE_PAT_KEY Time
+column_create Timestamps_201501 index COLUMN_INDEX Logs_201501 timestamp
+
+
+table_create Logs_201502 TABLE_NO_KEY
+column_create Logs_201502 timestamp COLUMN_SCALAR Time
+column_create Logs_201502 memo COLUMN_SCALAR ShortText
+column_create Logs_201502 message COLUMN_SCALAR Text
+
+table_create Timestamps_201502 TABLE_PAT_KEY Time
+column_create Timestamps_201502 index COLUMN_INDEX Logs_201502 timestamp
+
+
+table_create Logs_20150203 TABLE_NO_KEY
+column_create Logs_20150203 timestamp COLUMN_SCALAR Time
+column_create Logs_20150203 memo COLUMN_SCALAR ShortText
+column_create Logs_20150203 message COLUMN_SCALAR Text
+
+table_create Timestamps_20150203 TABLE_PAT_KEY Time
+column_create Timestamps_20150203 index COLUMN_INDEX Logs_20150203 timestamp
+
+
+table_create Logs_20150228 TABLE_NO_KEY
+column_create Logs_20150228 timestamp COLUMN_SCALAR Time
+column_create Logs_20150228 memo COLUMN_SCALAR ShortText
+column_create Logs_20150228 message COLUMN_SCALAR Text
+
+table_create Timestamps_20150228 TABLE_PAT_KEY Time
+column_create Timestamps_20150228 index COLUMN_INDEX Logs_20150228 timestamp
+
+
+table_create Logs_201503 TABLE_NO_KEY
+column_create Logs_201503 timestamp COLUMN_SCALAR Time
+column_create Logs_201503 memo COLUMN_SCALAR ShortText
+column_create Logs_201503 message COLUMN_SCALAR Text
+
+table_create Timestamps_201503 TABLE_PAT_KEY Time
+column_create Timestamps_201503 index COLUMN_INDEX Logs_201503 timestamp
+
+
+load --table Logs_201501
+[
+{
+  "timestamp": "2015-01-31 23:59:58",
+  "memo":      "2015-01-31 23:59:58",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-01-31 23:59:59",
+  "memo":      "2015-01-31 23:59:59",
+  "message":   "Shutdown"
+}
+]
+
+load --table Logs_201502
+[
+{
+  "timestamp": "2015-02-01 00:00:00",
+  "memo":      "2015-02-01 00:00:00",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-02-01 00:00:01",
+  "memo":      "2015-02-01 00:00:01",
+  "message":   "Shutdown"
+},
+{
+  "timestamp": "2015-02-02 00:00:00",
+  "memo":      "2015-02-02 00:00:00",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-02-02 00:00:01",
+  "memo":      "2015-02-02 00:00:01",
+  "message":   "Shutdown"
+}
+]
+
+load --table Logs_20150203
+[
+{
+  "timestamp": "2015-02-03 00:00:00",
+  "memo":      "2015-02-03 00:00:00",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-02-03 00:00:01",
+  "memo":      "2015-02-03 00:00:01",
+  "message":   "Shutdown"
+},
+{
+  "timestamp": "2015-02-03 23:59:58",
+  "memo":      "2015-02-03 23:59:58",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-02-03 23:59:59",
+  "memo":      "2015-02-03 23:59:59",
+  "message":   "Shutdown"
+}
+]
+
+load --table Logs_20150228
+[
+{
+  "timestamp": "2015-02-28 23:59:58",
+  "memo":      "2015-02-28 23:59:58",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-02-28 23:59:59",
+  "memo":      "2015-02-28 23:59:59",
+  "message":   "Shutdown"
+}
+]
+
+load --table Logs_201503
+[
+{
+  "timestamp": "2015-03-01 00:00:00",
+  "memo":      "2015-03-01 00:00:00",
+  "message":   "Start"
+},
+{
+  "timestamp": "2015-03-01 00:00:01",
+  "memo":      "2015-03-01 00:00:01",
+  "message":   "Shutdown"
+}
+]
+
+#@enable-logging

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/all.expected (+94 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/all.expected    2015-06-23 22:38:30 +0900 (4fdcddd)
@@ -0,0 +1,94 @@
+logical_range_filter Logs timestamp   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-01-31 23:59:58",
+      "Start",
+      1422716398.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-03-01 00:00:01",
+      "Shutdown",
+      1425135601.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/all.test (+4 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/all.test    2015-06-23 22:38:30 +0900 (ca758d0)
@@ -0,0 +1,4 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_exclude.expected (+84 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_exclude.expected    2015-06-23 22:38:30 +0900 (f4f19ea)
@@ -0,0 +1,84 @@
+logical_range_filter Logs timestamp   --max "2015-03-01 00:00:00"   --max_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-01-31 23:59:58",
+      "Start",
+      1422716398.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_exclude.test (+6 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_exclude.test    2015-06-23 22:38:30 +0900 (6cfe53b)
@@ -0,0 +1,6 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --max "2015-03-01 00:00:00" \
+  --max_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_include.expected (+89 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_include.expected    2015-06-23 22:38:30 +0900 (8b29a0b)
@@ -0,0 +1,89 @@
+logical_range_filter Logs timestamp   --max "2015-03-01 00:00:00"   --max_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-01-31 23:59:58",
+      "Start",
+      1422716398.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_include.test (+6 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/max_include.test    2015-06-23 22:38:30 +0900 (05029c0)
@@ -0,0 +1,6 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --max "2015-03-01 00:00:00" \
+  --max_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude.expected (+84 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude.expected    2015-06-23 22:38:30 +0900 (3a67fef)
@@ -0,0 +1,84 @@
+logical_range_filter Logs timestamp   --min "2015-01-31 23:59:59"   --min_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-03-01 00:00:01",
+      "Shutdown",
+      1425135601.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude.test (+6 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude.test    2015-06-23 22:38:30 +0900 (bc52ee9)
@@ -0,0 +1,6 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --min "2015-01-31 23:59:59" \
+  --min_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_exclude.expected (+74 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_exclude.expected    2015-06-23 22:38:30 +0900 (f313901)
@@ -0,0 +1,74 @@
+logical_range_filter Logs timestamp   --min "2015-01-31 23:59:59"   --min_border "exclude"   --max "2015-03-01 00:00:00"   --max_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_exclude.test (+8 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_exclude.test    2015-06-23 22:38:30 +0900 (9e284eb)
@@ -0,0 +1,8 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --min "2015-01-31 23:59:59" \
+  --min_border "exclude" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_include.expected (+79 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_include.expected    2015-06-23 22:38:30 +0900 (6c693a2)
@@ -0,0 +1,79 @@
+logical_range_filter Logs timestamp   --min "2015-01-31 23:59:59"   --min_border "exclude"   --max "2015-03-01 00:00:00"   --max_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_include.test (+8 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_exclude_max_include.test    2015-06-23 22:38:30 +0900 (b470609)
@@ -0,0 +1,8 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --min "2015-01-31 23:59:59" \
+  --min_border "exclude" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include.expected (+89 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include.expected    2015-06-23 22:38:30 +0900 (b8b23e8)
@@ -0,0 +1,89 @@
+logical_range_filter Logs timestamp   --min "2015-01-31 23:59:59"   --min_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-03-01 00:00:01",
+      "Shutdown",
+      1425135601.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include.test (+6 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include.test    2015-06-23 22:38:30 +0900 (02f0309)
@@ -0,0 +1,6 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --min "2015-01-31 23:59:59" \
+  --min_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_exclude.expected (+79 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_exclude.expected    2015-06-23 22:38:30 +0900 (5333ca7)
@@ -0,0 +1,79 @@
+logical_range_filter Logs timestamp   --min "2015-01-31 23:59:59"   --min_border "include"   --max "2015-03-01 00:00:00"   --max_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_exclude.test (+8 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_exclude.test    2015-06-23 22:38:30 +0900 (e405c56)
@@ -0,0 +1,8 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --min "2015-01-31 23:59:59" \
+  --min_border "include" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_include.expected (+84 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_include.expected    2015-06-23 22:38:30 +0900 (40f92d5)
@@ -0,0 +1,84 @@
+logical_range_filter Logs timestamp   --min "2015-01-31 23:59:59"   --min_border "include"   --max "2015-03-01 00:00:00"   --max_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_include.test (+8 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/ascending/min_include_max_include.test    2015-06-23 22:38:30 +0900 (667ec5d)
@@ -0,0 +1,8 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --min "2015-01-31 23:59:59" \
+  --min_border "include" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/all.expected (+94 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/all.expected    2015-06-23 22:38:30 +0900 (47bdd52)
@@ -0,0 +1,94 @@
+logical_range_filter Logs timestamp   --order descending   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-03-01 00:00:01",
+      "Shutdown",
+      1425135601.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-01-31 23:59:58",
+      "Start",
+      1422716398.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/all.test (+5 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/all.test    2015-06-23 22:38:30 +0900 (349dcf1)
@@ -0,0 +1,5 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_exclude.expected (+84 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_exclude.expected    2015-06-23 22:38:30 +0900 (6b7a5b9)
@@ -0,0 +1,84 @@
+logical_range_filter Logs timestamp   --order descending   --max "2015-03-01 00:00:00"   --max_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-01-31 23:59:58",
+      "Start",
+      1422716398.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_exclude.test (+7 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_exclude.test    2015-06-23 22:38:30 +0900 (0eca4c4)
@@ -0,0 +1,7 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --max "2015-03-01 00:00:00" \
+  --max_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_include.expected (+89 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_include.expected    2015-06-23 22:38:30 +0900 (c760164)
@@ -0,0 +1,89 @@
+logical_range_filter Logs timestamp   --order descending   --max "2015-03-01 00:00:00"   --max_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ],
+    [
+      "2015-01-31 23:59:58",
+      "Start",
+      1422716398.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_include.test (+7 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/max_include.test    2015-06-23 22:38:30 +0900 (91b63b2)
@@ -0,0 +1,7 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --max "2015-03-01 00:00:00" \
+  --max_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude.expected (+84 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude.expected    2015-06-23 22:38:30 +0900 (64fb2d5)
@@ -0,0 +1,84 @@
+logical_range_filter Logs timestamp   --order descending   --min "2015-01-31 23:59:59"   --min_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-03-01 00:00:01",
+      "Shutdown",
+      1425135601.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude.test (+7 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude.test    2015-06-23 22:38:30 +0900 (7edbf80)
@@ -0,0 +1,7 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --min "2015-01-31 23:59:59" \
+  --min_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_exclude.expected (+74 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_exclude.expected    2015-06-23 22:38:30 +0900 (ca14317)
@@ -0,0 +1,74 @@
+logical_range_filter Logs timestamp   --order descending   --min "2015-01-31 23:59:59"   --min_border "exclude"   --max "2015-03-01 00:00:00"   --max_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_exclude.test (+9 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_exclude.test    2015-06-23 22:38:30 +0900 (26b2010)
@@ -0,0 +1,9 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --min "2015-01-31 23:59:59" \
+  --min_border "exclude" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_include.expected (+79 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_include.expected    2015-06-23 22:38:30 +0900 (414a7d9)
@@ -0,0 +1,79 @@
+logical_range_filter Logs timestamp   --order descending   --min "2015-01-31 23:59:59"   --min_border "exclude"   --max "2015-03-01 00:00:00"   --max_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_include.test (+9 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_exclude_max_include.test    2015-06-23 22:38:30 +0900 (e71ae4e)
@@ -0,0 +1,9 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --min "2015-01-31 23:59:59" \
+  --min_border "exclude" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include.expected (+89 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include.expected    2015-06-23 22:38:30 +0900 (db39a5f)
@@ -0,0 +1,89 @@
+logical_range_filter Logs timestamp   --order descending   --min "2015-01-31 23:59:59"   --min_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-03-01 00:00:01",
+      "Shutdown",
+      1425135601.0
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include.test (+7 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include.test    2015-06-23 22:38:30 +0900 (211540f)
@@ -0,0 +1,7 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --min "2015-01-31 23:59:59" \
+  --min_border "include" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_exclude.expected (+79 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_exclude.expected    2015-06-23 22:38:30 +0900 (12cc19d)
@@ -0,0 +1,79 @@
+logical_range_filter Logs timestamp   --order descending   --min "2015-01-31 23:59:59"   --min_border "include"   --max "2015-03-01 00:00:00"   --max_border "exclude"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_exclude.test (+9 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_exclude.test    2015-06-23 22:38:30 +0900 (255e7e5)
@@ -0,0 +1,9 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --min "2015-01-31 23:59:59" \
+  --min_border "include" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "exclude" \
+  --limit -1

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_include.expected (+84 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_include.expected    2015-06-23 22:38:30 +0900 (5de2b68)
@@ -0,0 +1,84 @@
+logical_range_filter Logs timestamp   --order descending   --min "2015-01-31 23:59:59"   --min_border "include"   --max "2015-03-01 00:00:00"   --max_border "include"   --limit -1
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        "memo",
+        "ShortText"
+      ],
+      [
+        "message",
+        "Text"
+      ],
+      [
+        "timestamp",
+        "Time"
+      ]
+    ],
+    [
+      "2015-03-01 00:00:00",
+      "Start",
+      1425135600.0
+    ],
+    [
+      "2015-02-28 23:59:59",
+      "Shutdown",
+      1425135599.0
+    ],
+    [
+      "2015-02-28 23:59:58",
+      "Start",
+      1425135598.0
+    ],
+    [
+      "2015-02-03 23:59:59",
+      "Shutdown",
+      1422975599.0
+    ],
+    [
+      "2015-02-03 23:59:58",
+      "Start",
+      1422975598.0
+    ],
+    [
+      "2015-02-03 00:00:01",
+      "Shutdown",
+      1422889201.0
+    ],
+    [
+      "2015-02-03 00:00:00",
+      "Start",
+      1422889200.0
+    ],
+    [
+      "2015-02-02 00:00:01",
+      "Shutdown",
+      1422802801.0
+    ],
+    [
+      "2015-02-02 00:00:00",
+      "Start",
+      1422802800.0
+    ],
+    [
+      "2015-02-01 00:00:01",
+      "Shutdown",
+      1422716401.0
+    ],
+    [
+      "2015-02-01 00:00:00",
+      "Start",
+      1422716400.0
+    ],
+    [
+      "2015-01-31 23:59:59",
+      "Shutdown",
+      1422716399.0
+    ]
+  ]
+]

  Added: test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_include.test (+9 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/sharding/logical_range_filter/shard_type/month_day/descending/min_include_max_include.test    2015-06-23 22:38:30 +0900 (2f07296)
@@ -0,0 +1,9 @@
+#@include fixture/sharding/logical_range_filter/shard_type/month_day.grn
+
+logical_range_filter Logs timestamp \
+  --order descending \
+  --min "2015-01-31 23:59:59" \
+  --min_border "include" \
+  --max "2015-03-01 00:00:00" \
+  --max_border "include" \
+  --limit -1




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