ZUNIONSTORE merges multiple sorted sets into one, and stores the result under the key specified. Since the number of keys can vary and there are more parameters after the keys, it require the numkeys parameter to be specified before the keys.
If using the default aggregate function (SUM) this is fine, as you can simply store the sorted set names to be merged in a table, use the size of the table as numkeys, and unpack() the table to pass all of the keys names to redis.
The problem occurs when you want to change the aggregate function, adding more parameters after unpack(), which changes its behaviour:
‘Lua always adjusts the number of results from a function to the circumstances of the call. When we call a function as a statement, Lua discards all of its results. When we use a call as an expression, Lua keeps only the first result. We get all results only when the call is the last (or the only) expression in a list of expressions.’
So unpack will only pass the first sorted set key name.
The workaround is to add the aggregate command to the list of sorted set key names, and deduct the number of keys passed:
local ok, err = red:zunionstore(‘destinationKey’,#setNames-2,unpack(setNames))