From d31e3e4059934f0a6001d4cb3f0bf014fedfee38 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 24 Nov 2009 16:54:40 +0200 Subject: [PATCH] sql/pgq: update regtest for get_batch_cursor() change --- sql/pgq/expected/pgq_core.out | 1 + sql/pgq/sql/pgq_core.sql | 1 + 2 files changed, 2 insertions(+) diff --git a/sql/pgq/expected/pgq_core.out b/sql/pgq/expected/pgq_core.out index 15da99a3..a2cb6b2b 100644 --- a/sql/pgq/expected/pgq_core.out +++ b/sql/pgq/expected/pgq_core.out @@ -202,6 +202,7 @@ select ev_id,ev_retry,ev_type,ev_data,ev_extra1,ev_extra2,ev_extra3,ev_extra4 3 | | r3 | data | | | | (3 rows) +close acurs; select ev_id,ev_retry,ev_type,ev_data,ev_extra1,ev_extra2,ev_extra3,ev_extra4 from pgq.get_batch_cursor(3, 'acurs', 2); ev_id | ev_retry | ev_type | ev_data | ev_extra1 | ev_extra2 | ev_extra3 | ev_extra4 diff --git a/sql/pgq/sql/pgq_core.sql b/sql/pgq/sql/pgq_core.sql index bf3f690e..dfc4bd9e 100644 --- a/sql/pgq/sql/pgq_core.sql +++ b/sql/pgq/sql/pgq_core.sql @@ -49,6 +49,7 @@ select ev_id,ev_retry,ev_type,ev_data,ev_extra1,ev_extra2,ev_extra3,ev_extra4 fr begin; select ev_id,ev_retry,ev_type,ev_data,ev_extra1,ev_extra2,ev_extra3,ev_extra4 from pgq.get_batch_cursor(3, 'acurs', 10); +close acurs; select ev_id,ev_retry,ev_type,ev_data,ev_extra1,ev_extra2,ev_extra3,ev_extra4 from pgq.get_batch_cursor(3, 'acurs', 2); close acurs; -- 2.39.5