UTに必要なオブジェクトを追加し、UT以外の登録内容をUTに影響しないように削除した。

diff --git a/expected/pg_hint_plan-9.1.out b/expected/pg_hint_plan-9.1.out
index 125aecf..02efe8f 100644 (file)
--- a/expected/pg_hint_plan-9.1.out
+++ b/expected/pg_hint_plan-9.1.out
@@ -7929,3 +7929,4 @@ error hint:
 
 CONTEXT:  SQL statement "SELECT /*+SeqScan(t1)*/ t1.id         FROM t1 WHERE t1.id = 1"
 PL/pgSQL function "inline_code_block" line 5 at SQL statement
+DROP EXTENSION pg_hint_plan;

diff --git a/expected/pg_hint_plan-9.2.out b/expected/pg_hint_plan-9.2.out
index 148ba46..f2a1b43 100644 (file)
--- a/expected/pg_hint_plan-9.2.out
+++ b/expected/pg_hint_plan-9.2.out
@@ -8017,3 +8017,4 @@ error hint:
 
 CONTEXT:  SQL statement "SELECT /*+SeqScan(t1)*/ t1.id         FROM t1 WHERE t1.id = 1"
 PL/pgSQL function inline_code_block line 5 at SQL statement
+DROP EXTENSION pg_hint_plan;

diff --git a/expected/ut-init.out b/expected/ut-init.out
index a19ef0c..450aea9 100644 (file)
--- a/expected/ut-init.out
+++ b/expected/ut-init.out
@@ -32,6 +32,7 @@ CREATE TABLE s2.t1 (LIKE s1.t1 INCLUDING ALL);
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for table "t1"
 CREATE TABLE s1.p1 (LIKE s1.t1 INCLUDING ALL);
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "p1_pkey" for table "p1"
+CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "ja_JP" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;
 CREATE TABLE s1.p2 (LIKE s1.t1 INCLUDING ALL);
 NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "p2_pkey" for table "p2"
 CREATE TABLE s1.p1c1 (LIKE s1.p1 INCLUDING ALL, CHECK (c1 <= 100)) INHERITS(s1.p1);
@@ -145,6 +146,7 @@ CREATE INDEX t3_i1 ON s1.t3 (c1);
 CREATE INDEX t4_i1 ON s1.t4 (c1);
 CREATE INDEX p1_i ON s1.p1 (c1);
 CREATE INDEX p2_i ON s1.p2 (c1);
+CREATE INDEX p1_i2 ON s1.p1 (c2);
 CREATE INDEX p1c1_i ON s1.p1c1 (c1);
 CREATE INDEX p1c2_i ON s1.p1c2 (c1);
 CREATE INDEX p1c3_i ON s1.p1c3 (c1);