diff options
| -rw-r--r-- | src/test/regress/expected/combocid.out | 62 |
1 files changed, 31 insertions, 31 deletions
diff --git a/src/test/regress/expected/combocid.out b/src/test/regress/expected/combocid.out index cea80f3672..b63894c283 100644 --- a/src/test/regress/expected/combocid.out +++ b/src/test/regress/expected/combocid.out @@ -19,8 +19,8 @@ INSERT INTO combocidtest VALUES (2); SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 10 | 1 - (1,2) | 11 | 2 + (0,1) | 10 | 1 + (0,2) | 11 | 2 (2 rows) SAVEPOINT s1; @@ -29,8 +29,8 @@ UPDATE combocidtest SET foobar = foobar + 10; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,3) | 12 | 11 - (1,4) | 12 | 12 + (0,3) | 12 | 11 + (0,4) | 12 | 12 (2 rows) ROLLBACK TO s1; @@ -38,8 +38,8 @@ ROLLBACK TO s1; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 0 | 1 - (1,2) | 1 | 2 + (0,1) | 0 | 1 + (0,2) | 1 | 2 (2 rows) COMMIT; @@ -47,8 +47,8 @@ COMMIT; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 0 | 1 - (1,2) | 1 | 2 + (0,1) | 0 | 1 + (0,2) | 1 | 2 (2 rows) -- Test combo cids with portals @@ -59,17 +59,17 @@ DELETE FROM combocidtest; FETCH ALL FROM c; ctid | cmin | foobar -------+------+-------- - (1,1) | 1 | 1 - (1,2) | 1 | 2 - (1,5) | 0 | 333 + (0,1) | 1 | 1 + (0,2) | 1 | 2 + (0,5) | 0 | 333 (3 rows) ROLLBACK; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 1 | 1 - (1,2) | 1 | 2 + (0,1) | 1 | 1 + (0,2) | 1 | 2 (2 rows) -- check behavior with locked tuples @@ -89,9 +89,9 @@ INSERT INTO combocidtest VALUES (444); SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 1 | 1 - (1,2) | 1 | 2 - (1,6) | 10 | 444 + (0,1) | 1 | 1 + (0,2) | 1 | 2 + (0,6) | 10 | 444 (3 rows) SAVEPOINT s1; @@ -99,17 +99,17 @@ SAVEPOINT s1; SELECT ctid,cmin,* FROM combocidtest FOR UPDATE; ctid | cmin | foobar -------+------+-------- - (1,1) | 1 | 1 - (1,2) | 1 | 2 - (1,6) | 10 | 444 + (0,1) | 1 | 1 + (0,2) | 1 | 2 + (0,6) | 10 | 444 (3 rows) SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 1 | 1 - (1,2) | 1 | 2 - (1,6) | 10 | 444 + (0,1) | 1 | 1 + (0,2) | 1 | 2 + (0,6) | 10 | 444 (3 rows) -- but this does @@ -117,26 +117,26 @@ UPDATE combocidtest SET foobar = foobar + 10; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,7) | 12 | 11 - (1,8) | 12 | 12 - (1,9) | 12 | 454 + (0,7) | 12 | 11 + (0,8) | 12 | 12 + (0,9) | 12 | 454 (3 rows) ROLLBACK TO s1; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 12 | 1 - (1,2) | 12 | 2 - (1,6) | 0 | 444 + (0,1) | 12 | 1 + (0,2) | 12 | 2 + (0,6) | 0 | 444 (3 rows) COMMIT; SELECT ctid,cmin,* FROM combocidtest; ctid | cmin | foobar -------+------+-------- - (1,1) | 12 | 1 - (1,2) | 12 | 2 - (1,6) | 0 | 444 + (0,1) | 12 | 1 + (0,2) | 12 | 2 + (0,6) | 0 | 444 (3 rows) |