Kentaro Hayashi
null+****@clear*****
Thu Apr 20 15:08:23 JST 2017
Kentaro Hayashi 2017-04-20 15:08:23 +0900 (Thu, 20 Apr 2017) New Revision: 84df8d73ca4ca4f9aff5e826793f03bc7edc374e https://github.com/groonga/groonga/commit/84df8d73ca4ca4f9aff5e826793f03bc7edc374e Merged dd51979: Merge pull request #672 from kenhys/test-no-hit-dynamic-columns-with-drilldown Message: test: add no hit dynamic columns with drilldown without error This test case checks whether drilldown with empty records of dynamic columns (price_with_tax) in initial stage doesn't cause an error. Added files: test/command/suite/sharding/logical_select/columns/stage/initial/no_hit/drilldown.expected test/command/suite/sharding/logical_select/columns/stage/initial/no_hit/drilldown.test Added: test/command/suite/sharding/logical_select/columns/stage/initial/no_hit/drilldown.expected (+77 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/columns/stage/initial/no_hit/drilldown.expected 2017-04-20 15:08:23 +0900 (9e469b0) @@ -0,0 +1,77 @@ +plugin_register sharding +[[0,0.0,0.0],true] +plugin_register functions/number +[[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 price COLUMN_SCALAR UInt32 +[[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 price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 100}, +{"timestamp": "2017/03/15 01:00:00", "price": 200} +] +[[0,0.0,0.0],2] +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 100}, +{"timestamp": "2017/03/16 11:00:00", "price": 200}, +{"timestamp": "2017/03/16 11:00:00", "price": 300} +] +[[0,0.0,0.0],3] +logical_select Logs --shard_key timestamp --limit 0 --min "2017/04/01 00:00:00" --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' --drilldown price_with_tax +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 0 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "price_with_tax", + "UInt32" + ], + [ + "price", + "UInt32" + ], + [ + "timestamp", + "Time" + ] + ] + ], + [ + [ + 0 + ], + [ + [ + "_key", + "UInt32" + ], + [ + "_nsubrecs", + "Int32" + ] + ] + ] + ] +] Added: test/command/suite/sharding/logical_select/columns/stage/initial/no_hit/drilldown.test (+37 -0) 100644 =================================================================== --- /dev/null +++ test/command/suite/sharding/logical_select/columns/stage/initial/no_hit/drilldown.test 2017-04-20 15:08:23 +0900 (dac1c54) @@ -0,0 +1,37 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +plugin_register functions/number + +table_create Logs_20170315 TABLE_NO_KEY +column_create Logs_20170315 timestamp COLUMN_SCALAR Time +column_create Logs_20170315 price COLUMN_SCALAR UInt32 + +table_create Logs_20170316 TABLE_NO_KEY +column_create Logs_20170316 timestamp COLUMN_SCALAR Time +column_create Logs_20170316 price COLUMN_SCALAR UInt32 + +load --table Logs_20170315 +[ +{"timestamp": "2017/03/15 00:00:00", "price": 100}, +{"timestamp": "2017/03/15 01:00:00", "price": 200} +] + +load --table Logs_20170316 +[ +{"timestamp": "2017/03/16 10:00:00", "price": 100}, +{"timestamp": "2017/03/16 11:00:00", "price": 200}, +{"timestamp": "2017/03/16 11:00:00", "price": 300} +] + +logical_select Logs \ + --shard_key timestamp \ + --limit 0 \ + --min "2017/04/01 00:00:00" \ + --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' \ + --drilldown price_with_tax + -------------- next part -------------- HTML����������������������������...Download