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