Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitfecc04f

Browse files
committed
This patch fixes in intermittent failure in the regression tests:
there was a race condition between the "alter_table" and "rules"regression tests. Depending on scheduling, sometimes an ALTERTABLE command would operate on a relation created by the "rules"tests, leading to unexpected results.Neil Conway
1 parentce3d087 commitfecc04f

File tree

2 files changed

+6
-6
lines changed

2 files changed

+6
-6
lines changed

‎src/test/regress/expected/alter_table.out

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -615,10 +615,10 @@ ERROR: ALTER TABLE: relation "pg_class" is a system catalog
615615
alter table pg_class alter relname set not null;
616616
ERROR: ALTER TABLE: relation "pg_class" is a system catalog
617617
-- try altering non-existent table, should fail
618-
alter tablefoo alter column bar set not null;
619-
ERROR: Relation "foo" does not exist
620-
alter tablefoo alter column bar drop not null;
621-
ERROR: Relation "foo" does not exist
618+
alter tablenon_existent alter column bar set not null;
619+
ERROR: Relation "non_existent" does not exist
620+
alter tablenon_existent alter column bar drop not null;
621+
ERROR: Relation "non_existent" does not exist
622622
-- test setting columns to null and not null and vice versa
623623
-- test checking for null values and primary key
624624
create table atacc1 (test int not null);

‎src/test/regress/sql/alter_table.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -478,8 +478,8 @@ alter table pg_class alter column relname drop not null;
478478
altertable pg_class alter relnamesetnot null;
479479

480480
-- try altering non-existent table, should fail
481-
altertablefoo alter column barsetnot null;
482-
altertablefoo alter column bar dropnot null;
481+
altertablenon_existent alter column barsetnot null;
482+
altertablenon_existent alter column bar dropnot null;
483483

484484
-- test setting columns to null and not null and vice versa
485485
-- test checking for null values and primary key

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp