summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPavan Deolasee2017-08-29 11:26:28 +0000
committerPavan Deolasee2017-08-29 11:26:28 +0000
commit968106ef5bfbee49bbd4f931d9903636e600c302 (patch)
treec6a2daf8ff042671d971195929d379aceee8dfa9
parent5c03f66df4a31344eaea5bdbf041ae3472056202 (diff)
Accept regression diffs in update test case
The first diff was in fact a mistake and the actual output matched with the upstream output. It must have been missed during the merge process. The other diff was simply an error because XL doesn't allow updating distribution key column.
-rw-r--r--src/test/regress/expected/update.out6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/update.out b/src/test/regress/expected/update.out
index a9796445b3..f761e47e80 100644
--- a/src/test/regress/expected/update.out
+++ b/src/test/regress/expected/update.out
@@ -161,7 +161,7 @@ UPDATE update_test SET c = repeat('x', 10000) WHERE c = 'car';
SELECT a, b, char_length(c) FROM update_test ORDER BY a;
a | b | char_length
----+-----+-------------
- 21 | 101 |
+ 21 | 100 |
41 | 12 | 10000
42 | 12 | 10000
| |
@@ -211,8 +211,8 @@ insert into part_a_1_a_10 values ('a', 1);
insert into part_b_10_b_20 values ('b', 10);
-- fail
update part_a_1_a_10 set a = 'b' where a = 'a';
-ERROR: new row for relation "part_a_1_a_10" violates partition constraint
-DETAIL: Failing row contains (b, 1).
+ERROR: could not plan this distributed update
+DETAIL: correlated UPDATE or updating distribution column currently not supported in Postgres-XL.
update range_parted set b = b - 1 where b = 10;
ERROR: new row for relation "part_b_10_b_20" violates partition constraint
DETAIL: Failing row contains (b, 9).