diff options
| author | Tom Lane | 2011-06-22 23:21:29 +0000 |
|---|---|---|
| committer | Tom Lane | 2011-06-22 23:21:29 +0000 |
| commit | 6aab24d7bc82bb6ca022358e05182fa537db293e (patch) | |
| tree | 3d218df887e990aaea1468f203250f13d19b334a | |
| parent | effbe6ecb4848aee867ebd867d0978c5e81fa598 (diff) | |
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.
| -rw-r--r-- | src/test/regress/expected/sequence.out | 18 | ||||
| -rw-r--r-- | 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 |
