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

Commitd998fac

Browse files
committed
Add a regression test to catch future silliness in the index-building
area...
1 parentf3707d0 commitd998fac

File tree

2 files changed

+15
-0
lines changed

2 files changed

+15
-0
lines changed

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

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -95,3 +95,10 @@ INSERT INTO func_index_heap VALUES('ABCD', 'EF');
9595
ERROR: Cannot insert a duplicate key into unique index func_index_index
9696
-- but this shouldn't:
9797
INSERT INTO func_index_heap VALUES('QWERTY');
98+
--
99+
-- Also try building functional, expressional, and partial indexes on
100+
-- tables that already contain data.
101+
--
102+
create unique index hash_f8_index_1 on hash_f8_heap(abs(random));
103+
create unique index hash_f8_index_2 on hash_f8_heap((seqno + 1), random);
104+
create unique index hash_f8_index_3 on hash_f8_heap(random) where seqno > 1000;

‎src/test/regress/sql/create_index.sql

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -120,3 +120,11 @@ INSERT INTO func_index_heap VALUES('QWE','RTY');
120120
INSERT INTO func_index_heapVALUES('ABCD','EF');
121121
-- but this shouldn't:
122122
INSERT INTO func_index_heapVALUES('QWERTY');
123+
124+
--
125+
-- Also try building functional, expressional, and partial indexes on
126+
-- tables that already contain data.
127+
--
128+
createunique indexhash_f8_index_1on hash_f8_heap(abs(random));
129+
createunique indexhash_f8_index_2on hash_f8_heap((seqno+1), random);
130+
createunique indexhash_f8_index_3on hash_f8_heap(random)where seqno>1000;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp