1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
env = require('test_run')
test_run = env.new()
inspector = env.new()
engine = inspector:get_cfg('engine')
space = box.schema.space.create('tweedledum', { engine = engine })
index = space:create_index('primary', { type = 'tree' })
test_run:cmd("setopt delimiter ';'")
function crossjoin(space0, space1, limit)
local result = {}
for _,v0 in space0:pairs() do
for _,v1 in space1:pairs() do
if limit <= 0 then
return result
end
local newtuple = v0:totable()
for _, v in v1:pairs() do table.insert(newtuple, v) end
table.insert(result, newtuple)
limit = limit - 1
end
end
return result
end;
test_run:cmd("setopt delimiter ''");
crossjoin(space, space, 0)
crossjoin(space, space, 10000)
space:insert{1}
crossjoin(space, space, 10000)
space:insert{2}
crossjoin(space, space, 10000)
space:insert{3, 'hello'}
crossjoin(space, space, 10000)
space:insert{4, 'world'}
space[0]:insert{5, 'hello world'}
crossjoin(space, space, 10000)
space:drop()
crossjoin = nil
|