Kentaro Hayashi
null+****@clear*****
Mon Apr 17 13:20:33 JST 2017
Kentaro Hayashi 2017-04-17 13:20:33 +0900 (Mon, 17 Apr 2017) New Revision: b9516d30f26073b6680eb42b917bf3afabd8bd85 https://github.com/groonga/groonga/commit/b9516d30f26073b6680eb42b917bf3afabd8bd85 Merged 83425ce: Merge pull request #656 from kenhys/test-cache-columns-value Message: test: add columns[NAME].value test case without cache When the value of --columns[NAME].value parameter is changed, Groonga returns result without using cache. Added files: test/command/suite/sharding/logical_select/cache/columns/value.expected test/command/suite/sharding/logical_select/cache/columns/value.test Added: test/command/suite/sharding/logical_select/cache/columns/value.expected (+119 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/cache/columns/value.expected 2017-04-17 13:20:33 +0900 (1f46434) @@ -0,0 +1,119 @@ +plugin_register sharding +[[0,0.0,0.0],true] +plugin_register functions/number +[[0,0.0,0.0],true] +table_create Logs_20170415 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170415 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170416 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170416 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "price": 100}, +{"timestamp": "2017/04/15 01:00:00", "price": 200} +] +[[0,0.0,0.0],2] +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "price": 300}, +{"timestamp": "2017/04/16 11:00:00", "price": 400}, +{"timestamp": "2017/04/16 11:00:00", "price": 500} +] +[[0,0.0,0.0],3] +logical_select Logs --shard_key timestamp --columns[price_with_tax].stage initial --columns[price_with_tax].type UInt32 --columns[price_with_tax].flags COLUMN_SCALAR --columns[price_with_tax].value 'price * 1.05' --output_columns price,price_with_tax +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 5 + ], + [ + [ + "price", + "UInt32" + ], + [ + "price_with_tax", + "UInt32" + ] + ], + [ + 100, + 105 + ], + [ + 200, + 210 + ], + [ + 300, + 315 + ], + [ + 400, + 420 + ], + [ + 500, + 525 + ] + ] + ] +] +logical_select Logs --shard_key timestamp --columns[price_with_tax].stage initial --columns[price_with_tax].type UInt32 --columns[price_with_tax].flags COLUMN_SCALAR --columns[price_with_tax].value 'price * 1.08' --output_columns price,price_with_tax +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 5 + ], + [ + [ + "price", + "UInt32" + ], + [ + "price_with_tax", + "UInt32" + ] + ], + [ + 100, + 108 + ], + [ + 200, + 216 + ], + [ + 300, + 324 + ], + [ + 400, + 432 + ], + [ + 500, + 540 + ] + ] + ] +] Added: test/command/suite/sharding/logical_select/cache/columns/value.test (+42 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/cache/columns/value.test 2017-04-17 13:20:33 +0900 (e1dc044) @@ -0,0 +1,42 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +plugin_register functions/number + +table_create Logs_20170415 TABLE_NO_KEY +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +column_create Logs_20170415 price COLUMN_SCALAR UInt32 + +table_create Logs_20170416 TABLE_NO_KEY +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +column_create Logs_20170416 price COLUMN_SCALAR UInt32 + +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "price": 100}, +{"timestamp": "2017/04/15 01:00:00", "price": 200} +] + +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "price": 300}, +{"timestamp": "2017/04/16 11:00:00", "price": 400}, +{"timestamp": "2017/04/16 11:00:00", "price": 500} +] + +logical_select Logs \ + --shard_key timestamp \ + --columns[price_with_tax].stage initial \ + --columns[price_with_tax].type UInt32 \ + --columns[price_with_tax].flags COLUMN_SCALAR \ + --columns[price_with_tax].value 'price * 1.05' \ + --output_columns price,price_with_tax + +logical_select Logs \ + --shard_key timestamp \ + --columns[price_with_tax].stage initial \ + --columns[price_with_tax].type UInt32 \ + --columns[price_with_tax].flags COLUMN_SCALAR \ + --columns[price_with_tax].value 'price * 1.08' \ + --output_columns price,price_with_tax -------------- next part -------------- HTML����������������������������...Télécharger
