Kouhei Sutou
null+****@clear*****
Fri Feb 5 16:37:19 JST 2016
Kouhei Sutou 2016-02-05 16:37:19 +0900 (Fri, 05 Feb 2016) New Revision: b3cb399b24a88254b16925725be03c844b3b312d https://github.com/groonga/groonga/commit/b3cb399b24a88254b16925725be03c844b3b312d Message: test: add tests for compare operations for vector element Added files: test/command/suite/select/filter/compare_operation/equal/vector_element_int32.expected test/command/suite/select/filter/compare_operation/equal/vector_element_int32.test test/command/suite/select/filter/compare_operation/greater/vector_element_int32.expected test/command/suite/select/filter/compare_operation/greater/vector_element_int32.test test/command/suite/select/filter/compare_operation/greater_equal/vector_element_int32.expected test/command/suite/select/filter/compare_operation/greater_equal/vector_element_int32.test test/command/suite/select/filter/compare_operation/less/vector_element_int32.expected test/command/suite/select/filter/compare_operation/less/vector_element_int32.test test/command/suite/select/filter/compare_operation/less_equal/vector_element_int32.expected test/command/suite/select/filter/compare_operation/less_equal/vector_element_int32.test Added: test/command/suite/select/filter/compare_operation/equal/vector_element_int32.expected (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/equal/vector_element_int32.expected 2016-02-05 16:37:19 +0900 (d1aa780) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values numbers COLUMN_VECTOR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"numbers": [2, 1, 3]}, +{"numbers": [2, 3, 4]}, +{"numbers": [3, 9, -1]} +] +[[0,0.0,0.0],3] +select Values --filter 'numbers[1] == 3' --output_columns 'numbers' +[[0,0.0,0.0],[[[1],[["numbers","Int32"]],[[2,3,4]]]]] Added: test/command/suite/select/filter/compare_operation/equal/vector_element_int32.test (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/equal/vector_element_int32.test 2016-02-05 16:37:19 +0900 (ce7067b) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +column_create Values numbers COLUMN_VECTOR Int32 + +load --table Values +[ +{"numbers": [2, 1, 3]}, +{"numbers": [2, 3, 4]}, +{"numbers": [3, 9, -1]} +] + +select Values \ + --filter 'numbers[1] == 3' \ + --output_columns 'numbers' Added: test/command/suite/select/filter/compare_operation/greater/vector_element_int32.expected (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/greater/vector_element_int32.expected 2016-02-05 16:37:19 +0900 (4b24d3f) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values numbers COLUMN_VECTOR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"numbers": [2, 3, 9]}, +{"numbers": [2, 4, 3]}, +{"numbers": [8, 5, -1]} +] +[[0,0.0,0.0],3] +select Values --filter 'numbers[1] > 3' --output_columns 'numbers' +[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,4,3]],[[8,5,-1]]]]] Added: test/command/suite/select/filter/compare_operation/greater/vector_element_int32.test (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/greater/vector_element_int32.test 2016-02-05 16:37:19 +0900 (0a33295) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +column_create Values numbers COLUMN_VECTOR Int32 + +load --table Values +[ +{"numbers": [2, 3, 9]}, +{"numbers": [2, 4, 3]}, +{"numbers": [8, 5, -1]} +] + +select Values \ + --filter 'numbers[1] > 3' \ + --output_columns 'numbers' Added: test/command/suite/select/filter/compare_operation/greater_equal/vector_element_int32.expected (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/greater_equal/vector_element_int32.expected 2016-02-05 16:37:19 +0900 (5a2f544) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values numbers COLUMN_VECTOR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"numbers": [2, 3, 9]}, +{"numbers": [2, 4, 3]}, +{"numbers": [8, 5, -1]} +] +[[0,0.0,0.0],3] +select Values --filter 'numbers[1] >= 4' --output_columns 'numbers' +[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,4,3]],[[8,5,-1]]]]] Added: test/command/suite/select/filter/compare_operation/greater_equal/vector_element_int32.test (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/greater_equal/vector_element_int32.test 2016-02-05 16:37:19 +0900 (f8b75eb) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +column_create Values numbers COLUMN_VECTOR Int32 + +load --table Values +[ +{"numbers": [2, 3, 9]}, +{"numbers": [2, 4, 3]}, +{"numbers": [8, 5, -1]} +] + +select Values \ + --filter 'numbers[1] >= 4' \ + --output_columns 'numbers' Added: test/command/suite/select/filter/compare_operation/less/vector_element_int32.expected (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/less/vector_element_int32.expected 2016-02-05 16:37:19 +0900 (63585c2) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values numbers COLUMN_VECTOR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"numbers": [2, 1, 3]}, +{"numbers": [3, 2, 0]}, +{"numbers": [8, -1, 9]} +] +[[0,0.0,0.0],3] +select Values --filter 'numbers[1] < 2' --output_columns 'numbers' +[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,1,3]],[[8,-1,9]]]]] Added: test/command/suite/select/filter/compare_operation/less/vector_element_int32.test (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/less/vector_element_int32.test 2016-02-05 16:37:19 +0900 (3060ec3) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +column_create Values numbers COLUMN_VECTOR Int32 + +load --table Values +[ +{"numbers": [2, 1, 3]}, +{"numbers": [3, 2, 0]}, +{"numbers": [8, -1, 9]} +] + +select Values \ + --filter 'numbers[1] < 2' \ + --output_columns 'numbers' Added: test/command/suite/select/filter/compare_operation/less_equal/vector_element_int32.expected (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/less_equal/vector_element_int32.expected 2016-02-05 16:37:19 +0900 (285393d) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Values numbers COLUMN_VECTOR Int32 +[[0,0.0,0.0],true] +load --table Values +[ +{"numbers": [2, 1, 3]}, +{"numbers": [3, 2, 0]}, +{"numbers": [8, -1, 9]} +] +[[0,0.0,0.0],3] +select Values --filter 'numbers[1] <= 1' --output_columns 'numbers' +[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,1,3]],[[8,-1,9]]]]] Added: test/command/suite/select/filter/compare_operation/less_equal/vector_element_int32.test (+13 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/filter/compare_operation/less_equal/vector_element_int32.test 2016-02-05 16:37:19 +0900 (a409ea4) @@ -0,0 +1,13 @@ +table_create Values TABLE_NO_KEY +column_create Values numbers COLUMN_VECTOR Int32 + +load --table Values +[ +{"numbers": [2, 1, 3]}, +{"numbers": [3, 2, 0]}, +{"numbers": [8, -1, 9]} +] + +select Values \ + --filter 'numbers[1] <= 1' \ + --output_columns 'numbers' -------------- next part -------------- HTML����������������������������... Télécharger