summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTomas Vondra2017-07-16 14:09:17 +0000
committerTomas Vondra2017-07-16 14:09:17 +0000
commite0ebb632a977982f23edbef56ca5a503e1d7f0bc (patch)
tree7a46121b2d7996df6726ad4234f0ec60d9749dd6
parentee92c90e6bf9935a2a642819e1cb2c408a817b45 (diff)
Accept minor changes in sequence regression tests
Mostly just renames of the objects, received from upstream.
-rw-r--r--src/test/regress/expected/sequence.out18
1 files changed, 9 insertions, 9 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out
index 82c3acb27e..94c3867301 100644
--- a/src/test/regress/expected/sequence.out
+++ b/src/test/regress/expected/sequence.out
@@ -65,14 +65,14 @@ ALTER SEQUENCE sequence_test14 AS int; -- min and max will be adjusted
--- test creation of SERIAL column
---
SET sequence_range = 1;
-CREATE TABLE serialTest (f1 text, f2 serial);
-INSERT INTO serialTest VALUES ('foo');
-INSERT INTO serialTest VALUES ('bar');
-INSERT INTO serialTest VALUES ('force', 100);
-INSERT INTO serialTest VALUES ('wrong', NULL);
+CREATE TABLE serialTest1 (f1 text, f2 serial);
+INSERT INTO serialTest1 VALUES ('foo');
+INSERT INTO serialTest1 VALUES ('bar');
+INSERT INTO serialTest1 VALUES ('force', 100);
+INSERT INTO serialTest1 VALUES ('wrong', NULL);
ERROR: null value in column "f2" violates not-null constraint
DETAIL: Failing row contains (wrong, null).
-SELECT * FROM serialTest ORDER BY f1, f2;
+SELECT * FROM serialTest1 ORDER BY f1, f2;
f1 | f2
-------+-----
bar | 2
@@ -264,9 +264,9 @@ SELECT last_value, log_cnt IN (31, 32) AS log_cnt_ok, is_called FROM foo_seq_new
DROP SEQUENCE foo_seq_new;
-- renaming serial sequences
-ALTER TABLE serialtest_f2_seq RENAME TO serialtest_f2_foo;
-INSERT INTO serialTest VALUES ('more');
-SELECT * FROM serialTest ORDER BY f1, f2;
+ALTER TABLE serialtest1_f2_seq RENAME TO serialtest1_f2_foo;
+INSERT INTO serialTest1 VALUES ('more');
+SELECT * FROM serialTest1 ORDER BY f1, f2;
f1 | f2
-------+-----
bar | 2