· 8 years ago · Nov 20, 2017, 10:46 PM
1create database pllua_bug;
2\c pllua_bug
3
4create extension if not exists pllua;
5
6drop table test;
7create table test as select s, md5(random()::text) from generate_Series(1,500) s;
8
9create or replace function f1()
10 returns void as $$
11 for t in _U.get_test:rows() do
12 print(t.md5)
13 end
14end
15do
16 _U = {
17 get_test = server.prepare([[
18 SELECT *
19 FROM test
20 ]]):save()
21 }
22$$ language plluau;
23
24create or replace function f2()
25 returns void as $$
26 for t in _U.get_test:rows() do
27 print(t.md5)
28 end
29end
30do
31 _U = {
32 get_test = server.prepare([[
33 SELECT *
34 FROM test
35 ]]):save()
36 }
37$$ language plluau;
38
39select * from f1();
40select * from f2();