Advertisement
Guest User

Untitled

a guest
Nov 20th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. create database pllua_bug;
  2. \c pllua_bug
  3.  
  4. create extension if not exists pllua;
  5.  
  6. drop table test;
  7. create table test as select s, md5(random()::text) from generate_Series(1,500) s;
  8.  
  9. create or replace function f1()
  10. returns void as $$
  11. for t in _U.get_test:rows() do
  12. print(t.md5)
  13. end
  14. end
  15. do
  16. _U = {
  17. get_test = server.prepare([[
  18. SELECT *
  19. FROM test
  20. ]]):save()
  21. }
  22. $$ language plluau;
  23.  
  24. create or replace function f2()
  25. returns void as $$
  26. for t in _U.get_test:rows() do
  27. print(t.md5)
  28. end
  29. end
  30. do
  31. _U = {
  32. get_test = server.prepare([[
  33. SELECT *
  34. FROM test
  35. ]]):save()
  36. }
  37. $$ language plluau;
  38.  
  39. select * from f1();
  40. select * from f2();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement