diff options
| author | Michael P | 2011-07-28 04:05:27 +0000 |
|---|---|---|
| committer | Michael P | 2011-07-28 04:05:27 +0000 |
| commit | 85d499e14b8e69823e4409627c893bb19aed91d9 (patch) | |
| tree | 519194a8f1868034502faa32ed0c84df6212a98f /src | |
| parent | 1e04470efe097fdaa61ebdff858d7394537d6f9e (diff) | |
Correction of regression test update
A part of the test was failing due to a forgotten ORDER BY.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/update_1.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/update.sql | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/update_1.out b/src/test/regress/expected/update_1.out index 6758ac259f..b51a0e4b76 100644 --- a/src/test/regress/expected/update_1.out +++ b/src/test/regress/expected/update_1.out @@ -93,11 +93,11 @@ LINE 1: UPDATE update_test AS t SET b = update_test.b + 10 WHERE t.a... HINT: Perhaps you meant to reference the table alias "t". -- Make sure that we can update to a TOASTed value. UPDATE update_test SET c = repeat('x', 10000) WHERE c = 'car'; -SELECT a, b, char_length(c) FROM update_test; +SELECT a, b, char_length(c) FROM update_test ORDER BY a; a | b | char_length ----+----+------------- - 10 | 20 | 5 | 10 | 3 + 10 | 20 | (2 rows) DROP TABLE update_test; diff --git a/src/test/regress/sql/update.sql b/src/test/regress/sql/update.sql index e53aa58b60..91926f15f5 100644 --- a/src/test/regress/sql/update.sql +++ b/src/test/regress/sql/update.sql @@ -56,6 +56,6 @@ UPDATE update_test AS t SET b = update_test.b + 10 WHERE t.a = 10; -- Make sure that we can update to a TOASTed value. UPDATE update_test SET c = repeat('x', 10000) WHERE c = 'car'; -SELECT a, b, char_length(c) FROM update_test; +SELECT a, b, char_length(c) FROM update_test ORDER BY a; DROP TABLE update_test; |