J-3-1-1の試験を追加した。

[pghintplan/pg_hint_plan.git] / sql / init.sql

diff --git a/sql/init.sql b/sql/init.sql
index f08340e..771a57c 100644 (file)
--- a/sql/init.sql
+++ b/sql/init.sql
@@ -1,3 +1,7 @@
+SET search_path TO public;
+
+CREATE SCHEMA s0;
+
 CREATE TABLE t1 (id int PRIMARY KEY, val int);
 CREATE TABLE t2 (id int PRIMARY KEY, val int);
 CREATE TABLE t3 (id int PRIMARY KEY, val int);
@@ -11,6 +15,7 @@ CREATE TABLE p1_c1_c1 (LIKE p1 INCLUDING ALL, CHECK (id <= 50)) INHERITS(p1_c1);
 CREATE TABLE p1_c1_c2 (LIKE p1 INCLUDING ALL, CHECK (id > 50 AND id <= 100)) INHERITS(p1_c1);
 CREATE TABLE p1_c3_c1 (LIKE p1 INCLUDING ALL, CHECK (id > 200 AND id <= 250)) INHERITS(p1_c3);
 CREATE TABLE p1_c3_c2 (LIKE p1 INCLUDING ALL, CHECK (id > 250 AND id <= 300)) INHERITS(p1_c3);
+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;
@@ -39,13 +44,14 @@ CREATE VIEW v2 AS SELECT t1.id t1_id, t1.val t1_val, t2.id t2_id, t2.val t2_val
 CREATE VIEW v3 AS SELECT t_1.id t1_id, t_1.val t1_val, t_2.id t2_id, t_2.val t2_val FROM t1 t_1, t2 t_2 WHERE t_1.id = t_2.id;
 CREATE VIEW v4 AS SELECT v_2.t1_id, t_3.id FROM v2 v_2, t3 t_3 WHERE v_2.t1_id = t_3.id;
 
-SET enable_bitmapscan TO on;
-SET enable_hashagg TO on;
-SET enable_tidscan TO on;
-SET enable_sort TO on;
-SET enable_indexscan TO on;
-SET enable_seqscan TO on;
-SET enable_material TO on;
-SET enable_hashjoin TO on;
-SET enable_mergejoin TO on;
-SET enable_nestloop TO on;
+/*
+ * The following GUC parameters need the setting of the default value to
+ * succeed in regression test.
+ */
+CREATE VIEW settings AS
+SELECT name, setting, category
+  FROM pg_settings
+ WHERE category LIKE 'Query Tuning%'
+    OR name = 'client_min_messages'
+ ORDER BY category, name;
+SELECT * FROM settings;