提交: 9806c9462f9bd59c7f604ddf174103f54eba941b - pg_hint_plan (git)

firtst release

Commit MetaInfo

• 修訂: 9806c9462f9bd59c7f604ddf174103f54eba941b (tree)
• 時間: 2014-12-19 16:15:56
• 作者: Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
• Commiter: Kyotaro Horiguchi

Log Message

Fix regression test according to the changes of PostgreSQL.

PostgreSQL became to give WARNING for usage of hash indexes. This
change is to follow it.

Change Summary

• modified: expected/init.out
• modified: expected/ut-init.out

差異

--- a/expected/init.out
+++ b/expected/init.out
@@ -36,6 +36,7 @@ CREATE INDEX p2_id_val_idx ON p2 (id, val);
 CREATE UNIQUE INDEX p2_val_idx ON p2 (val);
 CREATE INDEX p2_ununi_id_val_idx ON p2 (val);
 CREATE INDEX p2_val_idx_1 ON p2 USING hash (val);
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE INDEX p2_val_id_idx ON p2 (val, id);
 CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "ja_JP");
 CREATE INDEX p2_val_idx3 ON p2 (val varchar_ops);
@@ -48,27 +49,35 @@ CREATE INDEX p2_val_idx7 ON p2 (val) WHERE id < 120;
 CREATE TABLE p2_c1 (LIKE p2 INCLUDING ALL, CHECK (id <= 100)) INHERITS(p2);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c2 (LIKE p2 INCLUDING ALL, CHECK (id > 100 AND id <= 200)) INHERITS(p2);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c3 (LIKE p2 INCLUDING ALL, CHECK (id > 200 AND id <= 300)) INHERITS(p2);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c4 (LIKE p2 INCLUDING ALL, CHECK (id > 300)) INHERITS(p2);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c1_c1 (LIKE p2 INCLUDING ALL, CHECK (id <= 50)) INHERITS(p2_c1);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c1_c2 (LIKE p2 INCLUDING ALL, CHECK (id > 50 AND id <= 100)) INHERITS(p2_c1);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c3_c1 (LIKE p2 INCLUDING ALL, CHECK (id > 200 AND id <= 250)) INHERITS(p2_c3);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE p2_c3_c2 (LIKE p2 INCLUDING ALL, CHECK (id > 250 AND id <= 300)) INHERITS(p2_c3);
 NOTICE:  merging column "id" with inherited definition
 NOTICE:  merging column "val" with inherited definition
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE TABLE s0.t1 (id int PRIMARY KEY, val int);
 INSERT INTO t1 SELECT i, i % 100 FROM (SELECT generate_series(1, 10000) i) t;
 INSERT INTO t2 SELECT i, i % 10 FROM (SELECT generate_series(1, 1000) i) t;

--- a/expected/ut-init.out
+++ b/expected/ut-init.out
@@ -143,6 +143,7 @@ CREATE INDEX ti1_i3    ON s1.ti1 (c2, c4, c4);
 CREATE INDEX ti1_i4    ON s1.ti1 (c2, c4, c4, c4);
 CREATE INDEX ti1_btree ON s1.ti1 USING btree (c1);
 CREATE INDEX ti1_hash  ON s1.ti1 USING hash (c1);
+WARNING:  hash indexes are not WAL-logged and their use is discouraged
 CREATE INDEX ti1_gist  ON s1.ti1 USING gist (c1);
 CREATE INDEX ti1_gin   ON s1.ti1 USING gin (c1);
 CREATE INDEX ti1_expr  ON s1.ti1 ((c1 < 100));