Kentaro Hayashi
null+****@clear*****
Mon Apr 17 19:10:47 JST 2017
Kentaro Hayashi 2017-04-17 19:10:47 +0900 (Mon, 17 Apr 2017) New Revision: 365542e99586f6f65a79a45ace2fe5657669ec2b https://github.com/groonga/groonga/commit/365542e99586f6f65a79a45ace2fe5657669ec2b Merged ad69098: Merge pull request #661 from kenhys/test-cache-drilldowns-columns-value Message: test: add drilldowns[LABEL].columns[NAME].value test case without cache When the value of drilldowns[LABEL].columns[NAME].value parameter is changed, Groonga returns result without using cache. Added files: test/command/suite/sharding/logical_select/cache/drilldowns/columns/value.expected test/command/suite/sharding/logical_select/cache/drilldowns/columns/value.test Added: test/command/suite/sharding/logical_select/cache/drilldowns/columns/value.expected (+216 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/cache/drilldowns/columns/value.expected 2017-04-17 19:10:47 +0900 (973e403) @@ -0,0 +1,216 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Items TABLE_HASH_KEY ShortText +[[0,0.0,0.0],true] +column_create Items price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170315 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170315 items COLUMN_VECTOR Items +[[0,0.0,0.0],true] +table_create Logs_20170316 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170316 items COLUMN_VECTOR Items +[[0,0.0,0.0],true] +table_create Logs_20170317 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170317 items COLUMN_VECTOR Items +[[0,0.0,0.0],true] +load --table Items +[ +{"_key": "Book", "price": 1000}, +{"_key": "Note", "price": 1000}, +{"_key": "Box", "price": 500}, +{"_key": "Pen", "price": 500}, +{"_key": "Food", "price": 500}, +{"_key": "Drink", "price": 300} +] +[[0,0.0,0.0],6] +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "items": ["Book", "Note", "Box", "Pen"]}, +{"timestamp": "2017/03/15 01:00:00", "items": ["Food", "Drink", "Pen"]} +] +[[0,0.0,0.0],2] +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "items": ["Pen", "Note", "Food", "Drink"]}, +{"timestamp": "2017/03/16 11:00:00", "items": ["Note", "Box"]} +] +[[0,0.0,0.0],2] +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "items": ["Food", "Book"]}, +{"timestamp": "2017/03/17 20:00:00", "items": ["Drink", "Note"]} +] +[[0,0.0,0.0],2] +logical_select Logs --shard_key timestamp --output_columns _id --limit 0 --drilldowns[item].keys items --drilldowns[item].sort_keys price --drilldowns[item].output_columns _key,_nsubrecs,price,price_with_tax --drilldowns[item].columns[price_with_tax].stage initial --drilldowns[item].columns[price_with_tax].type UInt32 --drilldowns[item].columns[price_with_tax].flags COLUMN_SCALAR --drilldowns[item].columns[price_with_tax].value 'price * 1.05' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "item": [ + [ + 6 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "price", + "UInt32" + ], + [ + "price_with_tax", + "UInt32" + ] + ], + [ + "Drink", + 3, + 300, + 315 + ], + [ + "Food", + 3, + 500, + 525 + ], + [ + "Pen", + 3, + 500, + 525 + ], + [ + "Box", + 2, + 500, + 525 + ], + [ + "Book", + 2, + 1000, + 1050 + ], + [ + "Note", + 4, + 1000, + 1050 + ] + ] + } + ] +] +logical_select Logs --shard_key timestamp --output_columns _id --limit 0 --drilldowns[item].keys items --drilldowns[item].sort_keys price --drilldowns[item].output_columns _key,_nsubrecs,price,price_with_tax --drilldowns[item].columns[price_with_tax].stage initial --drilldowns[item].columns[price_with_tax].type UInt32 --drilldowns[item].columns[price_with_tax].flags COLUMN_SCALAR --drilldowns[item].columns[price_with_tax].value 'price * 1.08' +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "item": [ + [ + 6 + ], + [ + [ + "_key", + "ShortText" + ], + [ + "_nsubrecs", + "Int32" + ], + [ + "price", + "UInt32" + ], + [ + "price_with_tax", + "UInt32" + ] + ], + [ + "Drink", + 3, + 300, + 324 + ], + [ + "Food", + 3, + 500, + 540 + ], + [ + "Pen", + 3, + 500, + 540 + ], + [ + "Box", + 2, + 500, + 540 + ], + [ + "Book", + 2, + 1000, + 1080 + ], + [ + "Note", + 4, + 1000, + 1080 + ] + ] + } + ] +] Added: test/command/suite/sharding/logical_select/cache/drilldowns/columns/value.test (+70 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/cache/drilldowns/columns/value.test 2017-04-17 19:10:47 +0900 (ad2f418) @@ -0,0 +1,70 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Items TABLE_HASH_KEY ShortText +column_create Items price COLUMN_SCALAR UInt32 + +table_create Logs_20170315 TABLE_NO_KEY +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +column_create Logs_20170315 items COLUMN_VECTOR Items + +table_create Logs_20170316 TABLE_NO_KEY +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +column_create Logs_20170316 items COLUMN_VECTOR Items + +table_create Logs_20170317 TABLE_NO_KEY +column_create Logs_20170317 timestamp COLUMN_SCALAR Time +column_create Logs_20170317 items COLUMN_VECTOR Items + +load --table Items +[ +{"_key": "Book", "price": 1000}, +{"_key": "Note", "price": 1000}, +{"_key": "Box", "price": 500}, +{"_key": "Pen", "price": 500}, +{"_key": "Food", "price": 500}, +{"_key": "Drink", "price": 300} +] + +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "items": ["Book", "Note", "Box", "Pen"]}, +{"timestamp": "2017/03/15 01:00:00", "items": ["Food", "Drink", "Pen"]} +] + +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "items": ["Pen", "Note", "Food", "Drink"]}, +{"timestamp": "2017/03/16 11:00:00", "items": ["Note", "Box"]} +] + +load --table Logs_20170317 +[ +{"timestamp": "2017/03/17 20:00:00", "items": ["Food", "Book"]}, +{"timestamp": "2017/03/17 20:00:00", "items": ["Drink", "Note"]} +] + +logical_select Logs \ + --shard_key timestamp \ + --output_columns _id \ + --limit 0 \ + --drilldowns[item].keys items \ + --drilldowns[item].sort_keys price \ + --drilldowns[item].output_columns _key,_nsubrecs,price,price_with_tax \ + --drilldowns[item].columns[price_with_tax].stage initial \ + --drilldowns[item].columns[price_with_tax].type UInt32 \ + --drilldowns[item].columns[price_with_tax].flags COLUMN_SCALAR \ + --drilldowns[item].columns[price_with_tax].value 'price * 1.05' + +logical_select Logs \ + --shard_key timestamp \ + --output_columns _id \ + --limit 0 \ + --drilldowns[item].keys items \ + --drilldowns[item].sort_keys price \ + --drilldowns[item].output_columns _key,_nsubrecs,price,price_with_tax \ + --drilldowns[item].columns[price_with_tax].stage initial \ + --drilldowns[item].columns[price_with_tax].type UInt32 \ + --drilldowns[item].columns[price_with_tax].flags COLUMN_SCALAR \ + --drilldowns[item].columns[price_with_tax].value 'price * 1.08' -------------- next part -------------- HTML����������������������������...ダウンロード
