Kouhei Sutou
null+****@clear*****
Wed Nov 19 00:05:04 JST 2014
Kouhei Sutou 2014-11-19 00:05:04 +0900 (Wed, 19 Nov 2014) New Revision: c98d3f38792b4ce49a690240f0bd5d32bfb4ec29 https://github.com/groonga/groonga/commit/c98d3f38792b4ce49a690240f0bd5d32bfb4ec29 Message: test select/drilldown: group by plain/ directory Added files: test/command/suite/select/drilldown/plain/output_columns/reference.test Copied files: test/command/suite/select/drilldown/plain/filtered/short_text.expected (from test/command/suite/select/drilldown/filtered/short_text.expected) test/command/suite/select/drilldown/plain/filtered/short_text.test (from test/command/suite/select/drilldown/filtered/short_text.test) test/command/suite/select/drilldown/plain/multiple.expected (from test/command/suite/select/drilldown/multiple.expected) Renamed files: test/command/suite/select/drilldown/plain/multiple.test (from test/command/suite/select/drilldown/multiple.test) test/command/suite/select/drilldown/plain/output_columns/reference.expected (from test/command/suite/select/drilldown/multiple.expected) test/command/suite/select/drilldown/plain/output_columns/short_text.expected (from test/command/suite/select/drilldown/filtered/short_text.expected) test/command/suite/select/drilldown/plain/output_columns/short_text.test (from test/command/suite/select/drilldown/filtered/short_text.test) test/command/suite/select/drilldown/plain/single.expected (from test/command/suite/select/drilldown/single.expected) test/command/suite/select/drilldown/plain/single.test (from test/command/suite/select/drilldown/single.test) Copied: test/command/suite/select/drilldown/plain/filtered/short_text.expected (+0 -0) 100% =================================================================== Copied: test/command/suite/select/drilldown/plain/filtered/short_text.test (+0 -0) 100% =================================================================== Copied: test/command/suite/select/drilldown/plain/multiple.expected (+0 -0) 100% =================================================================== Renamed: test/command/suite/select/drilldown/plain/multiple.test (+0 -0) 100% =================================================================== Renamed: test/command/suite/select/drilldown/plain/output_columns/reference.expected (+34 -49) 53% =================================================================== --- test/command/suite/select/drilldown/multiple.expected 2014-11-18 23:59:37 +0900 (830e489) +++ test/command/suite/select/drilldown/plain/output_columns/reference.expected 2014-11-19 00:05:04 +0900 (04cc8d5) @@ -1,20 +1,28 @@ table_create Tags TABLE_PAT_KEY ShortText [[0,0.0,0.0],true] +column_create Tags label COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] table_create Memos TABLE_HASH_KEY ShortText [[0,0.0,0.0],true] column_create Memos tag COLUMN_SCALAR Tags [[0,0.0,0.0],true] -column_create Memos date COLUMN_SCALAR ShortText -[[0,0.0,0.0],true] +load --table Tags +[ +{"_key": "groonga", "label": "Groonga"}, +{"_key": "mroonga", "label": "Mroonga"}, +{"_key": "rroonga", "label": "Rroonga"} +] +[[0,0.0,0.0],3] load --table Memos [ -{"_key": "groonga is fast!", "tag": "groonga", "date": "2013-06-21"}, -{"_key": "mroonga is fast!", "tag": "mroonga", "date": "2013-06-21"}, -{"_key": "groonga sticker!", "tag": "groonga", "date": "2013-06-22"}, -{"_key": "rroonga is fast!", "tag": "rroonga", "date": "2013-06-23"} +{"_key": "Groonga is fast!", "tag": "groonga"}, +{"_key": "Mroonga is fast!", "tag": "mroonga"}, +{"_key": "Groonga sticker!", "tag": "groonga"}, +{"_key": "Rroonga is fast!", "tag": "rroonga"}, +{"_key": "Groonga is good!", "tag": "groonga"} ] -[[0,0.0,0.0],4] -select Memos --drilldown tag,date +[[0,0.0,0.0],5] +select Memos --filter true --drilldown tag --drilldown_output_columns _key,label,_nsubrecs [ [ 0, @@ -24,7 +32,7 @@ select Memos --drilldown tag,date [ [ [ - 4 + 5 ], [ [ @@ -36,37 +44,34 @@ select Memos --drilldown tag,date "ShortText" ], [ - "date", - "ShortText" - ], - [ "tag", "Tags" ] ], [ 1, - "groonga is fast!", - "2013-06-21", + "Groonga is fast!", "groonga" ], [ 2, - "mroonga is fast!", - "2013-06-21", + "Mroonga is fast!", "mroonga" ], [ 3, - "groonga sticker!", - "2013-06-22", + "Groonga sticker!", "groonga" ], [ 4, - "rroonga is fast!", - "2013-06-23", + "Rroonga is fast!", "rroonga" + ], + [ + 5, + "Groonga is good!", + "groonga" ] ], [ @@ -79,30 +84,7 @@ select Memos --drilldown tag,date "ShortText" ], [ - "_nsubrecs", - "Int32" - ] - ], - [ - "groonga", - 2 - ], - [ - "mroonga", - 1 - ], - [ - "rroonga", - 1 - ] - ], - [ - [ - 3 - ], - [ - [ - "_key", + "label", "ShortText" ], [ @@ -111,15 +93,18 @@ select Memos --drilldown tag,date ] ], [ - "2013-06-21", - 2 + "groonga", + "Groonga", + 3 ], [ - "2013-06-22", + "mroonga", + "Mroonga", 1 ], [ - "2013-06-23", + "rroonga", + "Rroonga", 1 ] ] Added: test/command/suite/select/drilldown/plain/output_columns/reference.test (+26 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/select/drilldown/plain/output_columns/reference.test 2014-11-19 00:05:04 +0900 (5d53e4b) @@ -0,0 +1,26 @@ +table_create Tags TABLE_PAT_KEY ShortText +column_create Tags label COLUMN_SCALAR ShortText + +table_create Memos TABLE_HASH_KEY ShortText +column_create Memos tag COLUMN_SCALAR Tags + +load --table Tags +[ +{"_key": "groonga", "label": "Groonga"}, +{"_key": "mroonga", "label": "Mroonga"}, +{"_key": "rroonga", "label": "Rroonga"} +] + +load --table Memos +[ +{"_key": "Groonga is fast!", "tag": "groonga"}, +{"_key": "Mroonga is fast!", "tag": "mroonga"}, +{"_key": "Groonga sticker!", "tag": "groonga"}, +{"_key": "Rroonga is fast!", "tag": "rroonga"}, +{"_key": "Groonga is good!", "tag": "groonga"} +] + +select Memos \ + --filter true \ + --drilldown tag \ + --drilldown_output_columns _key,label,_nsubrecs Renamed: test/command/suite/select/drilldown/plain/output_columns/short_text.expected (+11 -5) 79% =================================================================== --- test/command/suite/select/drilldown/filtered/short_text.expected 2014-11-18 23:59:37 +0900 (cd0be9d) +++ test/command/suite/select/drilldown/plain/output_columns/short_text.expected 2014-11-19 00:05:04 +0900 (f22dbae) @@ -7,10 +7,11 @@ load --table Memos {"_key": "Groonga is fast!", "tag": "Groonga"}, {"_key": "Mroonga is fast!", "tag": "Mroonga"}, {"_key": "Groonga sticker!", "tag": "Groonga"}, -{"_key": "Rroonga is fast!", "tag": "Rroonga"} +{"_key": "Rroonga is fast!", "tag": "Rroonga"}, +{"_key": "Groonga is good!", "tag": "Groonga"} ] -[[0,0.0,0.0],4] -select Memos --filter true --drilldown tag +[[0,0.0,0.0],5] +select Memos --filter true --drilldown tag --drilldown_output_columns _key,_nsubrecs [ [ 0, @@ -20,7 +21,7 @@ select Memos --filter true --drilldown tag [ [ [ - 4 + 5 ], [ [ @@ -55,6 +56,11 @@ select Memos --filter true --drilldown tag 4, "Rroonga is fast!", "Rroonga" + ], + [ + 5, + "Groonga is good!", + "Groonga" ] ], [ @@ -73,7 +79,7 @@ select Memos --filter true --drilldown tag ], [ "Groonga", - 2 + 3 ], [ "Mroonga", Renamed: test/command/suite/select/drilldown/plain/output_columns/short_text.test (+6 -2) 57% =================================================================== --- test/command/suite/select/drilldown/filtered/short_text.test 2014-11-18 23:59:37 +0900 (27edbe7) +++ test/command/suite/select/drilldown/plain/output_columns/short_text.test 2014-11-19 00:05:04 +0900 (4e7bab0) @@ -6,7 +6,11 @@ load --table Memos {"_key": "Groonga is fast!", "tag": "Groonga"}, {"_key": "Mroonga is fast!", "tag": "Mroonga"}, {"_key": "Groonga sticker!", "tag": "Groonga"}, -{"_key": "Rroonga is fast!", "tag": "Rroonga"} +{"_key": "Rroonga is fast!", "tag": "Rroonga"}, +{"_key": "Groonga is good!", "tag": "Groonga"} ] -select Memos --filter true --drilldown tag +select Memos \ + --filter true \ + --drilldown tag \ + --drilldown_output_columns _key,_nsubrecs Renamed: test/command/suite/select/drilldown/plain/single.expected (+0 -0) 100% =================================================================== Renamed: test/command/suite/select/drilldown/plain/single.test (+0 -0) 100% =================================================================== -------------- next part -------------- HTML����������������������������...Download