[Groonga-commit] groonga/groonga at 09d9da0 [master] test: add without index case

Back to archive index

Kouhei Sutou null+****@clear*****
Mon Sep 29 22:55:48 JST 2014


Kouhei Sutou	2014-09-29 22:55:48 +0900 (Mon, 29 Sep 2014)

  New Revision: 09d9da09ced453ae0659a50194ef8158ad5ceab1
  https://github.com/groonga/groonga/commit/09d9da09ced453ae0659a50194ef8158ad5ceab1

  Message:
    test: add without index case

  Added files:
    test/command/suite/select/filter/range/without_index/less_than_and_greater_than.expected
    test/command/suite/select/filter/range/without_index/less_than_and_greater_than.test
    test/command/suite/select/filter/range/without_index/less_than_and_greater_than_or_equal.expected
    test/command/suite/select/filter/range/without_index/less_than_and_greater_than_or_equal.test
    test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than.expected
    test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than.test
    test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than_or_equal.expected
    test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than_or_equal.test

  Added: test/command/suite/select/filter/range/without_index/less_than_and_greater_than.expected (+47 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_and_greater_than.expected    2014-09-29 22:55:48 +0900 (c5f3488)
@@ -0,0 +1,47 @@
+table_create Users TABLE_HASH_KEY ShortText
+[[0,0.0,0.0],true]
+column_create Users age COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+[[0,0.0,0.0],5]
+select Users --filter 'age > 18 && age < 20'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        1
+      ],
+      [
+        [
+          "_id",
+          "UInt32"
+        ],
+        [
+          "_key",
+          "ShortText"
+        ],
+        [
+          "age",
+          "Int32"
+        ]
+      ],
+      [
+        3,
+        "calros",
+        19
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/range/without_index/less_than_and_greater_than.test (+13 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_and_greater_than.test    2014-09-29 22:55:48 +0900 (22010b2)
@@ -0,0 +1,13 @@
+table_create Users TABLE_HASH_KEY ShortText
+column_create Users age COLUMN_SCALAR Int32
+
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+
+select Users --filter 'age > 18 && age < 20'

  Added: test/command/suite/select/filter/range/without_index/less_than_and_greater_than_or_equal.expected (+52 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_and_greater_than_or_equal.expected    2014-09-29 22:55:48 +0900 (35e74bf)
@@ -0,0 +1,52 @@
+table_create Users TABLE_HASH_KEY ShortText
+[[0,0.0,0.0],true]
+column_create Users age COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+[[0,0.0,0.0],5]
+select Users --filter 'age > 18 && age <= 20'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        2
+      ],
+      [
+        [
+          "_id",
+          "UInt32"
+        ],
+        [
+          "_key",
+          "ShortText"
+        ],
+        [
+          "age",
+          "Int32"
+        ]
+      ],
+      [
+        3,
+        "calros",
+        19
+      ],
+      [
+        4,
+        "dave",
+        20
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/range/without_index/less_than_and_greater_than_or_equal.test (+13 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_and_greater_than_or_equal.test    2014-09-29 22:55:48 +0900 (b597cb2)
@@ -0,0 +1,13 @@
+table_create Users TABLE_HASH_KEY ShortText
+column_create Users age COLUMN_SCALAR Int32
+
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+
+select Users --filter 'age > 18 && age <= 20'

  Added: test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than.expected (+52 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than.expected    2014-09-29 22:55:48 +0900 (d25fb0c)
@@ -0,0 +1,52 @@
+table_create Users TABLE_HASH_KEY ShortText
+[[0,0.0,0.0],true]
+column_create Users age COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+[[0,0.0,0.0],5]
+select Users --filter 'age >= 18 && age < 20'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        2
+      ],
+      [
+        [
+          "_id",
+          "UInt32"
+        ],
+        [
+          "_key",
+          "ShortText"
+        ],
+        [
+          "age",
+          "Int32"
+        ]
+      ],
+      [
+        2,
+        "bob",
+        18
+      ],
+      [
+        3,
+        "calros",
+        19
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than.test (+13 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than.test    2014-09-29 22:55:48 +0900 (8b8a424)
@@ -0,0 +1,13 @@
+table_create Users TABLE_HASH_KEY ShortText
+column_create Users age COLUMN_SCALAR Int32
+
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+
+select Users --filter 'age >= 18 && age < 20'

  Added: test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than_or_equal.expected (+57 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than_or_equal.expected    2014-09-29 22:55:48 +0900 (b0db6b0)
@@ -0,0 +1,57 @@
+table_create Users TABLE_HASH_KEY ShortText
+[[0,0.0,0.0],true]
+column_create Users age COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+[[0,0.0,0.0],5]
+select Users --filter 'age >= 18 && age <= 20'
+[
+  [
+    0,
+    0.0,
+    0.0
+  ],
+  [
+    [
+      [
+        3
+      ],
+      [
+        [
+          "_id",
+          "UInt32"
+        ],
+        [
+          "_key",
+          "ShortText"
+        ],
+        [
+          "age",
+          "Int32"
+        ]
+      ],
+      [
+        2,
+        "bob",
+        18
+      ],
+      [
+        3,
+        "calros",
+        19
+      ],
+      [
+        4,
+        "dave",
+        20
+      ]
+    ]
+  ]
+]

  Added: test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than_or_equal.test (+13 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/range/without_index/less_than_or_equal_and_greater_than_or_equal.test    2014-09-29 22:55:48 +0900 (3a0b4dd)
@@ -0,0 +1,13 @@
+table_create Users TABLE_HASH_KEY ShortText
+column_create Users age COLUMN_SCALAR Int32
+
+load --table Users
+[
+{"_key": "alice",  "age": 17},
+{"_key": "bob",    "age": 18},
+{"_key": "calros", "age": 19},
+{"_key": "dave",   "age": 20},
+{"_key": "eric",   "age": 21}
+]
+
+select Users --filter 'age >= 18 && age <= 20'
-------------- next part --------------
HTML����������������������������...
Download 



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