運用試験にあった機能試験レベルの項目をリグレッションテストに追加した。

diff --git a/expected/ut-A-9.1.out b/expected/ut-A-9.1.out
index 2e0f44b..dbc6991 100644 (file)
--- a/expected/ut-A-9.1.out
+++ b/expected/ut-A-9.1.out
@@ -1459,6 +1459,23 @@ error hint:
    Filter: (c1 = 1)
 (3 rows)
 
+-- No. A-7-3-13
+-- No. A-9-2-13
+/*+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)*/
+EXPLAIN (COSTS false) SELECT * FROM s1.t1 "123456789012345678901234567890123456789012345678901234" WHERE "123456789012345678901234567890123456789012345678901234".c1 = 1;
+LOG:  pg_hint_plan:
+used hint:
+not used hint:
+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)
+duplication hint:
+error hint:
+
+                                      QUERY PLAN                                       
+---------------------------------------------------------------------------------------
+ Index Scan using t1_i1 on t1 "123456789012345678901234567890123456789012345678901234"
+   Index Cond: (c1 = 1)
+(2 rows)
+
 ----
 ---- No. A-7-4 hint parse error
 ----

diff --git a/expected/ut-A-9.2.out b/expected/ut-A-9.2.out
index e81a6ef..24c0b2e 100644 (file)
--- a/expected/ut-A-9.2.out
+++ b/expected/ut-A-9.2.out
@@ -1457,6 +1457,23 @@ error hint:
    Filter: (c1 = 1)
 (3 rows)
 
+-- No. A-7-3-13
+-- No. A-9-2-13
+/*+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)*/
+EXPLAIN (COSTS false) SELECT * FROM s1.t1 "123456789012345678901234567890123456789012345678901234" WHERE "123456789012345678901234567890123456789012345678901234".c1 = 1;
+LOG:  pg_hint_plan:
+used hint:
+not used hint:
+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)
+duplication hint:
+error hint:
+
+                                      QUERY PLAN                                       
+---------------------------------------------------------------------------------------
+ Index Scan using t1_i1 on t1 "123456789012345678901234567890123456789012345678901234"
+   Index Cond: (c1 = 1)
+(2 rows)
+
 ----
 ---- No. A-7-4 hint parse error
 ----

diff --git a/expected/ut-G-9.1.out b/expected/ut-G-9.1.out
index 2f7663f..9419314 100644 (file)
--- a/expected/ut-G-9.1.out
+++ b/expected/ut-G-9.1.out
@@ -677,6 +677,29 @@ error hint:
 
 RESET client_min_messages;
 ----
+---- No. G-2-1 GUC parameter
+----
+-- No. G-2-1-3
+/*+Set(1234567890123456789012345678901234567890123456789012345678901234 1)*/
+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+NOTICE:  identifier "1234567890123456789012345678901234567890123456789012345678901234" will be truncated to "123456789012345678901234567890123456789012345678901234567890123"
+INFO:  unrecognized configuration parameter "123456789012345678901234567890123456789012345678901234567890123"
+ c1 | c2 | c3 | c4 
+----+----+----+----
+  1 |  1 |  1 | 1
+(1 row)
+
+-- No. G-2-1-4
+/*+Set(constraint_exclusion 1234567890123456789012345678901234567890123456789012345678901234)*/
+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+INFO:  invalid value for parameter "constraint_exclusion": "1234567890123456789012345678901234567890123456789012345678901234"
+HINT:  Available values: partition, on, off.
+ c1 | c2 | c3 | c4 
+----+----+----+----
+  1 |  1 |  1 | 1
+(1 row)
+
+----
 ---- No. G-2-2 category of GUC parameter and role
 ----
 -- No. G-2-2-1

diff --git a/expected/ut-G-9.2.out b/expected/ut-G-9.2.out
index c13b654..16c0a5a 100644 (file)
--- a/expected/ut-G-9.2.out
+++ b/expected/ut-G-9.2.out
@@ -677,6 +677,29 @@ error hint:
 
 RESET client_min_messages;
 ----
+---- No. G-2-1 GUC parameter
+----
+-- No. G-2-1-3
+/*+Set(1234567890123456789012345678901234567890123456789012345678901234 1)*/
+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+NOTICE:  identifier "1234567890123456789012345678901234567890123456789012345678901234" will be truncated to "123456789012345678901234567890123456789012345678901234567890123"
+INFO:  unrecognized configuration parameter "123456789012345678901234567890123456789012345678901234567890123"
+ c1 | c2 | c3 | c4 
+----+----+----+----
+  1 |  1 |  1 | 1
+(1 row)
+
+-- No. G-2-1-4
+/*+Set(constraint_exclusion 1234567890123456789012345678901234567890123456789012345678901234)*/
+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+INFO:  invalid value for parameter "constraint_exclusion": "1234567890123456789012345678901234567890123456789012345678901234"
+HINT:  Available values: partition, on, off.
+ c1 | c2 | c3 | c4 
+----+----+----+----
+  1 |  1 |  1 | 1
+(1 row)
+
+----
 ---- No. G-2-2 category of GUC parameter and role
 ----
 -- No. G-2-2-1

diff --git a/sql/ut-A.sql b/sql/ut-A.sql
index b8cb3dd..b4dfd8b 100644 (file)
--- a/sql/ut-A.sql
+++ b/sql/ut-A.sql
@@ -471,6 +471,11 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 "tT()""
 Setあ" WHERE "tT()""  
 Setあ".c1 = 1;
 
+-- No. A-7-3-13
+-- No. A-9-2-13
+/*+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)*/
+EXPLAIN (COSTS false) SELECT * FROM s1.t1 "123456789012345678901234567890123456789012345678901234" WHERE "123456789012345678901234567890123456789012345678901234".c1 = 1;
+
 ----
 ---- No. A-7-4 hint parse error
 ----

diff --git a/sql/ut-G.sql b/sql/ut-G.sql
index c9740ef..02d28c1 100644 (file)
--- a/sql/ut-G.sql
+++ b/sql/ut-G.sql
@@ -47,6 +47,18 @@ EXPLAIN (COSTS false) UPDATE s1.r3_ SET c1 = c1 WHERE c1 = 1 AND ctid = '(1,1)';
 RESET client_min_messages;
 
 ----
+---- No. G-2-1 GUC parameter
+----
+
+-- No. G-2-1-3
+/*+Set(1234567890123456789012345678901234567890123456789012345678901234 1)*/
+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+
+-- No. G-2-1-4
+/*+Set(constraint_exclusion 1234567890123456789012345678901234567890123456789012345678901234)*/
+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
+
+----
 ---- No. G-2-2 category of GUC parameter and role
 ----