Kouhei Sutou
null+****@clear*****
Thu Jun 22 16:09:03 JST 2017
Kouhei Sutou 2017-06-22 16:09:03 +0900 (Thu, 22 Jun 2017) New Revision: a67348c3bf81cff2d27acce50b47a33cf1e702b4 https://github.com/groonga/groonga/commit/a67348c3bf81cff2d27acce50b47a33cf1e702b4 Message: in_values test: add Added files: test/command/suite/select/function/in_values/with_index/value/vector.expected test/command/suite/select/function/in_values/with_index/value/vector.test Added: test/command/suite/select/function/in_values/with_index/value/vector.expected (+70 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/function/in_values/with_index/value/vector.expected 2017-06-22 16:09:03 +0900 (a416d15) @@ -0,0 +1,70 @@ +table_create Tags TABLE_PAT_KEY ShortText +[[0,0.0,0.0],true] +table_create Memos TABLE_HASH_KEY ShortText +[[0,0.0,0.0],true] +column_create Memos tags COLUMN_VECTOR ShortText +[[0,0.0,0.0],true] +column_create Tags memos_tags COLUMN_INDEX Memos tags +[[0,0.0,0.0],true] +load --table Memos +[ +{"_key": "Groonga is fast", "tags": ["groonga", "full text search"]}, +{"_key": "Mroonga is fast", "tags": ["mroonga", "mysql"]}, +{"_key": "Rroonga is fast", "tags": ["rroonga", "ruby"]}, +{"_key": "Droonga is fast", "tags": ["droonga", "ruby"]}, +{"_key": "Groonga is a HTTP server", "tags": ["groonga", "http"]} +] +[[0,0.0,0.0],5] +select Memos --output_columns _key,tags --filter 'in_values(tags, "groonga", "mroonga", "droonga")' --sortby _id +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 4 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "tags", + "ShortText" + ] + ], + [ + "Groonga is fast", + [ + "groonga", + "full text search" + ] + ], + [ + "Mroonga is fast", + [ + "mroonga", + "mysql" + ] + ], + [ + "Droonga is fast", + [ + "droonga", + "ruby" + ] + ], + [ + "Groonga is a HTTP server", + [ + "groonga", + "http" + ] + ] + ] + ] +] Added: test/command/suite/select/function/in_values/with_index/value/vector.test (+20 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/function/in_values/with_index/value/vector.test 2017-06-22 16:09:03 +0900 (36164c5) @@ -0,0 +1,20 @@ +table_create Tags TABLE_PAT_KEY ShortText + +table_create Memos TABLE_HASH_KEY ShortText +column_create Memos tags COLUMN_VECTOR ShortText + +column_create Tags memos_tags COLUMN_INDEX Memos tags + +load --table Memos +[ +{"_key": "Groonga is fast", "tags": ["groonga", "full text search"]}, +{"_key": "Mroonga is fast", "tags": ["mroonga", "mysql"]}, +{"_key": "Rroonga is fast", "tags": ["rroonga", "ruby"]}, +{"_key": "Droonga is fast", "tags": ["droonga", "ruby"]}, +{"_key": "Groonga is a HTTP server", "tags": ["groonga", "http"]} +] + +select Memos \ + --output_columns _key,tags \ + --filter 'in_values(tags, "groonga", "mroonga", "droonga")' \ + --sortby _id -------------- next part -------------- HTML����������������������������...Download