Groonga - fulltext search engine.

[Groonga-commit] groonga/groonga at 93c4ead [master] test: add tests for compare operations with index

Kouhei Sutou null+****@clear*****
Fri Feb 5 16:18:26 JST 2016

• Previous message: [Groonga-commit] groonga/grntest at e0d2c54 [master] Revert "Invert expected and actual order"
• Next message: [Groonga-commit] groonga/groonga at b3cb399 [master] test: add tests for compare operations for vector element
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Kouhei Sutou	2016-02-05 16:18:26 +0900 (Fri, 05 Feb 2016)

  New Revision: 93c4ead88b7a64fa966495182e2d956cd705fbf5
  https://github.com/groonga/groonga/commit/93c4ead88b7a64fa966495182e2d956cd705fbf5

  Message:
    test: add tests for compare operations with index

  Added files:
    test/command/suite/select/filter/index/compare_operation/equal/int32.expected
    test/command/suite/select/filter/index/compare_operation/equal/int32.test
    test/command/suite/select/filter/index/compare_operation/greater/int32.expected
    test/command/suite/select/filter/index/compare_operation/greater/int32.test
    test/command/suite/select/filter/index/compare_operation/greater/vector_int32.expected
    test/command/suite/select/filter/index/compare_operation/greater/vector_int32.test
    test/command/suite/select/filter/index/compare_operation/greater_equal/int32.expected
    test/command/suite/select/filter/index/compare_operation/greater_equal/int32.test
    test/command/suite/select/filter/index/compare_operation/greater_equal/vector_int32.expected
    test/command/suite/select/filter/index/compare_operation/greater_equal/vector_int32.test
    test/command/suite/select/filter/index/compare_operation/less/int32.expected
    test/command/suite/select/filter/index/compare_operation/less/int32.test
    test/command/suite/select/filter/index/compare_operation/less/vector_int32.expected
    test/command/suite/select/filter/index/compare_operation/less/vector_int32.test
    test/command/suite/select/filter/index/compare_operation/less_equal/int32.expected
    test/command/suite/select/filter/index/compare_operation/less_equal/int32.test
    test/command/suite/select/filter/index/compare_operation/less_equal/vector_int32.expected
    test/command/suite/select/filter/index/compare_operation/less_equal/vector_int32.test

  Added: test/command/suite/select/filter/index/compare_operation/equal/int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/equal/int32.expected    2016-02-05 16:18:26 +0900 (31fdba6)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+[[0,0.0,0.0],true]
+column_create Values number COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_number COLUMN_INDEX Values number
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"number": 1},
+{"number": 3},
+{"number": -1}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'number == -1'   --output_columns 'number'
+[[0,0.0,0.0],[[[1],[["number","Int32"]],[-1]]]]

  Added: test/command/suite/select/filter/index/compare_operation/equal/int32.test (+16 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/equal/int32.test    2016-02-05 16:18:26 +0900 (7bb3e19)
@@ -0,0 +1,16 @@
+table_create Values TABLE_NO_KEY
+column_create Values number COLUMN_SCALAR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_number COLUMN_INDEX Values number
+
+load --table Values
+[
+{"number": 1},
+{"number": 3},
+{"number": -1}
+]
+
+select Values \
+  --filter 'number == -1' \
+  --output_columns 'number'

  Added: test/command/suite/select/filter/index/compare_operation/greater/int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater/int32.expected    2016-02-05 16:18:26 +0900 (8facb26)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+[[0,0.0,0.0],true]
+column_create Values number COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_number COLUMN_INDEX Values number
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'number > 3'   --output_columns 'number'
+[[0,0.0,0.0],[[[1],[["number","Int32"]],[4]]]]

  Added: test/command/suite/select/filter/index/compare_operation/greater/int32.test (+16 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater/int32.test    2016-02-05 16:18:26 +0900 (bdc1c89)
@@ -0,0 +1,16 @@
+table_create Values TABLE_NO_KEY
+column_create Values number COLUMN_SCALAR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_number COLUMN_INDEX Values number
+
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+
+select Values \
+  --filter 'number > 3' \
+  --output_columns 'number'

  Added: test/command/suite/select/filter/index/compare_operation/greater/vector_int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater/vector_int32.expected    2016-02-05 16:18:26 +0900 (d57ff4c)
@@ -0,0 +1,17 @@
+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]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'numbers > 3'   --output_columns 'numbers'   --sortby _id
+[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,3,4]],[[8,9,-1]]]]]

  Added: test/command/suite/select/filter/index/compare_operation/greater/vector_int32.test (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater/vector_int32.test    2016-02-05 16:18:26 +0900 (0770bac)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+column_create Values numbers COLUMN_VECTOR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+
+select Values \
+  --filter 'numbers > 3' \
+  --output_columns 'numbers' \
+  --sortby _id

  Added: test/command/suite/select/filter/index/compare_operation/greater_equal/int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater_equal/int32.expected    2016-02-05 16:18:26 +0900 (6508caf)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+[[0,0.0,0.0],true]
+column_create Values number COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_number COLUMN_INDEX Values number
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'number >= 3'   --output_columns 'number'
+[[0,0.0,0.0],[[[2],[["number","Int32"]],[3],[4]]]]

  Added: test/command/suite/select/filter/index/compare_operation/greater_equal/int32.test (+16 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater_equal/int32.test    2016-02-05 16:18:26 +0900 (6bfba4c)
@@ -0,0 +1,16 @@
+table_create Values TABLE_NO_KEY
+column_create Values number COLUMN_SCALAR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_number COLUMN_INDEX Values number
+
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+
+select Values \
+  --filter 'number >= 3' \
+  --output_columns 'number'

  Added: test/command/suite/select/filter/index/compare_operation/greater_equal/vector_int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater_equal/vector_int32.expected    2016-02-05 16:18:26 +0900 (f6f9b09)
@@ -0,0 +1,17 @@
+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]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'numbers >= 4'   --output_columns 'numbers'   --sortby _id
+[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,3,4]],[[8,9,-1]]]]]

  Added: test/command/suite/select/filter/index/compare_operation/greater_equal/vector_int32.test (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/greater_equal/vector_int32.test    2016-02-05 16:18:26 +0900 (e1fe6a6)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+column_create Values numbers COLUMN_VECTOR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+
+select Values \
+  --filter 'numbers >= 4' \
+  --output_columns 'numbers' \
+  --sortby _id

  Added: test/command/suite/select/filter/index/compare_operation/less/int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less/int32.expected    2016-02-05 16:18:26 +0900 (10b40b5)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+[[0,0.0,0.0],true]
+column_create Values number COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_number COLUMN_INDEX Values number
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'number < 3'   --output_columns 'number'
+[[0,0.0,0.0],[[[1],[["number","Int32"]],[-1]]]]

  Added: test/command/suite/select/filter/index/compare_operation/less/int32.test (+16 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less/int32.test    2016-02-05 16:18:26 +0900 (a9188fe)
@@ -0,0 +1,16 @@
+table_create Values TABLE_NO_KEY
+column_create Values number COLUMN_SCALAR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_number COLUMN_INDEX Values number
+
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+
+select Values \
+  --filter 'number < 3' \
+  --output_columns 'number'

  Added: test/command/suite/select/filter/index/compare_operation/less/vector_int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less/vector_int32.expected    2016-02-05 16:18:26 +0900 (f146e96)
@@ -0,0 +1,17 @@
+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]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'numbers < 2'   --output_columns 'numbers'   --sortby _id
+[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,1,3]],[[8,9,-1]]]]]

  Added: test/command/suite/select/filter/index/compare_operation/less/vector_int32.test (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less/vector_int32.test    2016-02-05 16:18:26 +0900 (c02b980)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+column_create Values numbers COLUMN_VECTOR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+
+select Values \
+  --filter 'numbers < 2' \
+  --output_columns 'numbers' \
+  --sortby _id

  Added: test/command/suite/select/filter/index/compare_operation/less_equal/int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less_equal/int32.expected    2016-02-05 16:18:26 +0900 (41052a6)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+[[0,0.0,0.0],true]
+column_create Values number COLUMN_SCALAR Int32
+[[0,0.0,0.0],true]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_number COLUMN_INDEX Values number
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'number <= 3'   --output_columns 'number'   --sortby number
+[[0,0.0,0.0],[[[2],[["number","Int32"]],[-1],[3]]]]

  Added: test/command/suite/select/filter/index/compare_operation/less_equal/int32.test (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less_equal/int32.test    2016-02-05 16:18:26 +0900 (3e4b088)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+column_create Values number COLUMN_SCALAR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_number COLUMN_INDEX Values number
+
+load --table Values
+[
+{"number": 3},
+{"number": 4},
+{"number": -1}
+]
+
+select Values \
+  --filter 'number <= 3' \
+  --output_columns 'number' \
+  --sortby number

  Added: test/command/suite/select/filter/index/compare_operation/less_equal/vector_int32.expected (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less_equal/vector_int32.expected    2016-02-05 16:18:26 +0900 (a9541b2)
@@ -0,0 +1,17 @@
+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]
+table_create Numbers TABLE_PAT_KEY Int32
+[[0,0.0,0.0],true]
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+[[0,0.0,0.0],true]
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+[[0,0.0,0.0],3]
+select Values   --filter 'numbers <= 1'   --output_columns 'numbers'   --sortby _id
+[[0,0.0,0.0],[[[2],[["numbers","Int32"]],[[2,1,3]],[[8,9,-1]]]]]

  Added: test/command/suite/select/filter/index/compare_operation/less_equal/vector_int32.test (+17 -0) 100644
===================================================================
--- /dev/null
+++ test/command/suite/select/filter/index/compare_operation/less_equal/vector_int32.test    2016-02-05 16:18:26 +0900 (0bfad2d)
@@ -0,0 +1,17 @@
+table_create Values TABLE_NO_KEY
+column_create Values numbers COLUMN_VECTOR Int32
+
+table_create Numbers TABLE_PAT_KEY Int32
+column_create Numbers values_numbers COLUMN_INDEX|WITH_POSITION Values numbers
+
+load --table Values
+[
+{"numbers": [2, 1, 3]},
+{"numbers": [2, 3, 4]},
+{"numbers": [8, 9, -1]}
+]
+
+select Values \
+  --filter 'numbers <= 1' \
+  --output_columns 'numbers' \
+  --sortby _id
-------------- next part --------------
HTML����������������������������...
Download 

• Previous message: [Groonga-commit] groonga/grntest at e0d2c54 [master] Revert "Invert expected and actual order"
• Next message: [Groonga-commit] groonga/groonga at b3cb399 [master] test: add tests for compare operations for vector element
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]