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

Commit5395aed

Browse files
committed
Add regression tests for ALTER INDEX.
Gavin Sherry
1 parentf78ecbf commit5395aed

File tree

2 files changed

+4
-4
lines changed

2 files changed

+4
-4
lines changed

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -126,8 +126,8 @@ DROP TABLE tmp_new;
126126
DROP TABLE tmp_new2;
127127
-- ALTER TABLE ... RENAME on non-table relations
128128
-- renaming indexes (FIXME: this should probably test the index's functionality)
129-
ALTERTABLE onek_unique1 RENAME TO tmp_onek_unique1;
130-
ALTERTABLE tmp_onek_unique1 RENAME TO onek_unique1;
129+
ALTERINDEX onek_unique1 RENAME TO tmp_onek_unique1;
130+
ALTERINDEX tmp_onek_unique1 RENAME TO onek_unique1;
131131
-- renaming views
132132
CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1;
133133
ALTER TABLE tmp_view RENAME TO tmp_view_new;

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -166,8 +166,8 @@ DROP TABLE tmp_new2;
166166

167167
-- ALTER TABLE ... RENAME on non-table relations
168168
-- renaming indexes (FIXME: this should probably test the index's functionality)
169-
ALTERTABLE onek_unique1 RENAME TO tmp_onek_unique1;
170-
ALTERTABLE tmp_onek_unique1 RENAME TO onek_unique1;
169+
ALTERINDEX onek_unique1 RENAME TO tmp_onek_unique1;
170+
ALTERINDEX tmp_onek_unique1 RENAME TO onek_unique1;
171171
-- renaming views
172172
CREATEVIEWtmp_view (unique1)ASSELECT unique1FROM tenk1;
173173
ALTERTABLE tmp_view RENAME TO tmp_view_new;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp