postgres.git / summary / log / commit / refs
commit 6aab24d7bc82bb6ca022358e05182fa537db293e
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed Jun 22 23:21:29 2011 +0000
First released in: 9.2.0
Revert "Don't select log_cnt in sequence regression tests."
This reverts commit addf11f9a264417aa467d4e135b9a8afc59f172a.
The right fix for the problem is to update the alternative expected
file, not to lobotomize the test case.
src/test/regress/expected/sequence.out | 18 ++++++++----------
src/test/regress/sql/sequence.sql | 6 ++----
2 files changed, 10 insertions(+), 14 deletions(-)
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out
index db88cc4186b..968fcce8ac9 100644
--- a/src/test/regress/expected/sequence.out
+++ b/src/test/regress/expected/sequence.out
@@ -172,11 +172,10 @@ DROP SEQUENCE sequence_test;
-- renaming sequences
CREATE SEQUENCE foo_seq;
ALTER TABLE foo_seq RENAME TO foo_seq_new;
-SELECT sequence_name, last_value, start_value, increment_by, max_value,
- min_value, cache_value, is_cycled, is_called FROM foo_seq_new;
- sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | is_cycled | is_called
----------------+------------+-------------+--------------+---------------------+-----------+-------------+-----------+-----------
- foo_seq | 1 | 1 | 1 | 9223372036854775807 | 1 | 1 | f | f
+SELECT * FROM foo_seq_new;
+ sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
+---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
+ foo_seq | 1 | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f
(1 row)
SELECT nextval('foo_seq_new');
@@ -191,11 +190,10 @@ SELECT nextval('foo_seq_new');
2
(1 row)
-SELECT sequence_name, last_value, start_value, increment_by, max_value,
- min_value, cache_value, is_cycled, is_called FROM foo_seq_new;
- sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | is_cycled | is_called
----------------+------------+-------------+--------------+---------------------+-----------+-------------+-----------+-----------
- foo_seq | 2 | 1 | 1 | 9223372036854775807 | 1 | 1 | f | t
+SELECT * FROM foo_seq_new;
+ sequence_name | last_value | start_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
+---------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
+ foo_seq | 2 | 1 | 1 | 9223372036854775807 | 1 | 1 | 32 | f | t
(1 row)
DROP SEQUENCE foo_seq_new;
diff --git a/src/test/regress/sql/sequence.sql b/src/test/regress/sql/sequence.sql
index cc97f32e92e..97ffb60385c 100644
--- a/src/test/regress/sql/sequence.sql
+++ b/src/test/regress/sql/sequence.sql
@@ -78,12 +78,10 @@ DROP SEQUENCE sequence_test;
-- renaming sequences
CREATE SEQUENCE foo_seq;
ALTER TABLE foo_seq RENAME TO foo_seq_new;
-SELECT sequence_name, last_value, start_value, increment_by, max_value,
- min_value, cache_value, is_cycled, is_called FROM foo_seq_new;
+SELECT * FROM foo_seq_new;
SELECT nextval('foo_seq_new');
SELECT nextval('foo_seq_new');
-SELECT sequence_name, last_value, start_value, increment_by, max_value,
- min_value, cache_value, is_cycled, is_called FROM foo_seq_new;
+SELECT * FROM foo_seq_new;
DROP SEQUENCE foo_seq_new;
-- renaming serial sequences
[parent: effbe6ecb484]