Kouhei Sutou
null+****@clear*****
Mon Jul 6 22:18:11 JST 2015
Kouhei Sutou 2015-07-06 22:18:11 +0900 (Mon, 06 Jul 2015) New Revision: 5b14e2efc6367cf4457cda407e92bdd8e0fb6437 https://github.com/groonga/groonga/commit/5b14e2efc6367cf4457cda407e92bdd8e0fb6437 Message: logical_select: add a test for multiple keys "_value.COLUMN" style isn't supported for multiple keys. Because drilldown result may consist with multiple tables. It means that "_value" (= one of drilled-down records) and table mismatch may be occurred. Added files: test/command/suite/sharding/logical_select/drilldown/labeled/keys/multiple.expected test/command/suite/sharding/logical_select/drilldown/labeled/keys/multiple.test Added: test/command/suite/sharding/logical_select/drilldown/labeled/keys/multiple.expected (+177 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/drilldown/labeled/keys/multiple.expected 2015-07-06 22:18:11 +0900 (2f5c39a) @@ -0,0 +1,177 @@ +register sharding +[[0,0.0,0.0],true] +table_create Logs_20150203 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150203 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20150203 memo COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +column_create Logs_20150203 date COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +column_create Logs_20150203 action COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Logs_20150204 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150204 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20150204 memo COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +column_create Logs_20150204 date COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +column_create Logs_20150204 action COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Logs_20150205 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150205 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20150205 memo COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +column_create Logs_20150205 date COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +column_create Logs_20150205 action COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +load --table Logs_20150203 +[ +{ + "timestamp": "2015-02-03 12:49:00", + "memo": "2015-02-03 12:49:00", + "date": "2015-02-03", + "action": "Start" +}, +{ + "timestamp": "2015-02-03 23:59:59", + "memo": "2015-02-03 23:59:59", + "date": "2015-02-03", + "action": "Shutdown" +} +] +[[0,0.0,0.0],2] +load --table Logs_20150204 +[ +{ + "timestamp": "2015-02-04 00:00:00", + "memo": "2015-02-04 00:00:00", + "date": "2015-02-04", + "action": "Start" +}, +{ + "timestamp": "2015-02-04 13:49:00", + "memo": "2015-02-04 13:49:00", + "date": "2015-02-04", + "action": "Restart" +}, +{ + "timestamp": "2015-02-04 13:50:00", + "memo": "2015-02-04 13:50:00", + "date": "2015-02-04", + "action": "Restart" +} +] +[[0,0.0,0.0],3] +load --table Logs_20150205 +[ +{ + "timestamp": "2015-02-05 13:49:00", + "memo": "2015-02-05 13:49:00", + "date": "2015-02-05", + "action": "Restart" +}, +{ + "timestamp": "2015-02-05 13:50:00", + "memo": "2015-02-05 13:50:00", + "date": "2015-02-05", + "action": "Restart" +}, +{ + "timestamp": "2015-02-05 13:51:00", + "memo": "2015-02-05 13:51:00", + "date": "2015-02-05", + "action": "Restart" +}, +{ + "timestamp": "2015-02-05 13:52:00", + "memo": "2015-02-05 13:52:00", + "date": "2015-02-05", + "action": "Restart" +} +] +[[0,0.0,0.0],4] +logical_select Logs timestamp --command_version 2 --limit 0 --drilldown[action_date].keys action,date --drilldown[action_date].output_columns _key[0],_key[1],_nsubrecs +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 9 + ], + [ + [ + "action", + "ShortText" + ], + [ + null, + null + ], + [ + "date", + "ShortText" + ], + [ + "memo", + "ShortText" + ] + ] + ], + { + "action_date": [ + [ + 5 + ], + [ + [ + "_key[0]", + null + ], + [ + "_key[1]", + null + ], + [ + "_nsubrecs", + "Int32" + ] + ], + [ + "Start", + "2015-02-03", + 1 + ], + [ + "Shutdown", + "2015-02-03", + 1 + ], + [ + "Start", + "2015-02-04", + 1 + ], + [ + "Restart", + "2015-02-04", + 2 + ], + [ + "Restart", + "2015-02-05", + 4 + ] + ] + } + ] +] Added: test/command/suite/sharding/logical_select/drilldown/labeled/keys/multiple.test (+93 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/drilldown/labeled/keys/multiple.test 2015-07-06 22:18:11 +0900 (fa3f6a9) @@ -0,0 +1,93 @@ +#@on-error omit +register sharding +#@on-error default + +table_create Logs_20150203 TABLE_NO_KEY +column_create Logs_20150203 timestamp COLUMN_SCALAR Time +column_create Logs_20150203 memo COLUMN_SCALAR ShortText +column_create Logs_20150203 date COLUMN_SCALAR ShortText +column_create Logs_20150203 action COLUMN_SCALAR ShortText + +table_create Logs_20150204 TABLE_NO_KEY +column_create Logs_20150204 timestamp COLUMN_SCALAR Time +column_create Logs_20150204 memo COLUMN_SCALAR ShortText +column_create Logs_20150204 date COLUMN_SCALAR ShortText +column_create Logs_20150204 action COLUMN_SCALAR ShortText + +table_create Logs_20150205 TABLE_NO_KEY +column_create Logs_20150205 timestamp COLUMN_SCALAR Time +column_create Logs_20150205 memo COLUMN_SCALAR ShortText +column_create Logs_20150205 date COLUMN_SCALAR ShortText +column_create Logs_20150205 action COLUMN_SCALAR ShortText + +load --table Logs_20150203 +[ +{ + "timestamp": "2015-02-03 12:49:00", + "memo": "2015-02-03 12:49:00", + "date": "2015-02-03", + "action": "Start" +}, +{ + "timestamp": "2015-02-03 23:59:59", + "memo": "2015-02-03 23:59:59", + "date": "2015-02-03", + "action": "Shutdown" +} +] + +load --table Logs_20150204 +[ +{ + "timestamp": "2015-02-04 00:00:00", + "memo": "2015-02-04 00:00:00", + "date": "2015-02-04", + "action": "Start" +}, +{ + "timestamp": "2015-02-04 13:49:00", + "memo": "2015-02-04 13:49:00", + "date": "2015-02-04", + "action": "Restart" +}, +{ + "timestamp": "2015-02-04 13:50:00", + "memo": "2015-02-04 13:50:00", + "date": "2015-02-04", + "action": "Restart" +} +] + +load --table Logs_20150205 +[ +{ + "timestamp": "2015-02-05 13:49:00", + "memo": "2015-02-05 13:49:00", + "date": "2015-02-05", + "action": "Restart" +}, +{ + "timestamp": "2015-02-05 13:50:00", + "memo": "2015-02-05 13:50:00", + "date": "2015-02-05", + "action": "Restart" +}, +{ + "timestamp": "2015-02-05 13:51:00", + "memo": "2015-02-05 13:51:00", + "date": "2015-02-05", + "action": "Restart" +}, +{ + "timestamp": "2015-02-05 13:52:00", + "memo": "2015-02-05 13:52:00", + "date": "2015-02-05", + "action": "Restart" +} +] + +logical_select Logs timestamp \ + --command_version 2 \ + --limit 0 \ + --drilldown[action_date].keys action,date \ + --drilldown[action_date].output_columns _key[0],_key[1],_nsubrecs -------------- next part -------------- HTML����������������������������...Download