aboutsummaryrefslogtreecommitdiff
path: root/src/test/isolation/expected/plpgsql-toast.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/isolation/expected/plpgsql-toast.out')
-rw-r--r--src/test/isolation/expected/plpgsql-toast.out104
1 files changed, 78 insertions, 26 deletions
diff --git a/src/test/isolation/expected/plpgsql-toast.out b/src/test/isolation/expected/plpgsql-toast.out
index 213bddad4fd..0fee7953acc 100644
--- a/src/test/isolation/expected/plpgsql-toast.out
+++ b/src/test/isolation/expected/plpgsql-toast.out
@@ -2,17 +2,23 @@ Parsed test spec with 2 sessions
starting permutation: lock assign1 vacuum unlock
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
step lock:
SELECT pg_advisory_lock(1);
pg_advisory_lock
+----------------
+
+(1 row)
-
step assign1:
do $$
declare
@@ -33,24 +39,32 @@ step unlock:
SELECT pg_advisory_unlock(1);
pg_advisory_unlock
+------------------
+t
+(1 row)
-t
s1: NOTICE: length(x) = 6000
step assign1: <... completed>
starting permutation: lock assign2 vacuum unlock
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
step lock:
SELECT pg_advisory_lock(1);
pg_advisory_lock
+----------------
+
+(1 row)
-
step assign2:
do $$
declare
@@ -71,24 +85,32 @@ step unlock:
SELECT pg_advisory_unlock(1);
pg_advisory_unlock
+------------------
+t
+(1 row)
-t
s1: NOTICE: length(x) = 6000
step assign2: <... completed>
starting permutation: lock assign3 vacuum unlock
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
step lock:
SELECT pg_advisory_lock(1);
pg_advisory_lock
+----------------
+
+(1 row)
-
step assign3:
do $$
declare
@@ -110,24 +132,32 @@ step unlock:
SELECT pg_advisory_unlock(1);
pg_advisory_unlock
+------------------
+t
+(1 row)
-t
s1: NOTICE: length(r) = 6004
step assign3: <... completed>
starting permutation: lock assign4 vacuum unlock
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
step lock:
SELECT pg_advisory_lock(1);
pg_advisory_lock
+----------------
+
+(1 row)
-
step assign4:
do $$
declare
@@ -148,24 +178,32 @@ step unlock:
SELECT pg_advisory_unlock(1);
pg_advisory_unlock
+------------------
+t
+(1 row)
-t
s1: NOTICE: length(r) = 6004
step assign4: <... completed>
starting permutation: lock assign5 vacuum unlock
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
step lock:
SELECT pg_advisory_lock(1);
pg_advisory_lock
+----------------
+
+(1 row)
-
step assign5:
do $$
declare
@@ -188,24 +226,32 @@ step unlock:
SELECT pg_advisory_unlock(1);
pg_advisory_unlock
+------------------
+t
+(1 row)
-t
s1: NOTICE: length(r) = 6002
step assign5: <... completed>
starting permutation: lock assign6 vacuum unlock
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
step lock:
SELECT pg_advisory_lock(1);
pg_advisory_lock
+----------------
+
+(1 row)
-
step assign6:
do $$
declare
@@ -229,8 +275,10 @@ step unlock:
SELECT pg_advisory_unlock(1);
pg_advisory_unlock
+------------------
+t
+(1 row)
-t
s1: NOTICE: length(r) = 6002
s1: NOTICE: length(r) = 9002
s1: NOTICE: length(r) = 12002
@@ -238,11 +286,15 @@ step assign6: <... completed>
starting permutation: fetch-after-commit
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
pg_advisory_unlock_all
+----------------------
+
+(1 row)
-
s1: NOTICE: length(t) = 6000
s1: NOTICE: length(t) = 9000
s1: NOTICE: length(t) = 12000