• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revisionaa37d096bd88c899f374fbdab98c86bcac3cb4cf (tree)
Time2013-08-20 16:21:12
AuthorTakashi Suzuki <suzuki.takashi@metr...>
CommiterTakashi Suzuki

Log Message

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

Change Summary

Incremental Difference

--- a/expected/ut-A-9.1.out
+++ b/expected/ut-A-9.1.out
@@ -1459,6 +1459,23 @@ error hint:
14591459 Filter: (c1 = 1)
14601460 (3 rows)
14611461
1462+-- No. A-7-3-13
1463+-- No. A-9-2-13
1464+/*+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)*/
1465+EXPLAIN (COSTS false) SELECT * FROM s1.t1 "123456789012345678901234567890123456789012345678901234" WHERE "123456789012345678901234567890123456789012345678901234".c1 = 1;
1466+LOG: pg_hint_plan:
1467+used hint:
1468+not used hint:
1469+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)
1470+duplication hint:
1471+error hint:
1472+
1473+ QUERY PLAN
1474+---------------------------------------------------------------------------------------
1475+ Index Scan using t1_i1 on t1 "123456789012345678901234567890123456789012345678901234"
1476+ Index Cond: (c1 = 1)
1477+(2 rows)
1478+
14621479 ----
14631480 ---- No. A-7-4 hint parse error
14641481 ----
--- a/expected/ut-A-9.2.out
+++ b/expected/ut-A-9.2.out
@@ -1457,6 +1457,23 @@ error hint:
14571457 Filter: (c1 = 1)
14581458 (3 rows)
14591459
1460+-- No. A-7-3-13
1461+-- No. A-9-2-13
1462+/*+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)*/
1463+EXPLAIN (COSTS false) SELECT * FROM s1.t1 "123456789012345678901234567890123456789012345678901234" WHERE "123456789012345678901234567890123456789012345678901234".c1 = 1;
1464+LOG: pg_hint_plan:
1465+used hint:
1466+not used hint:
1467+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)
1468+duplication hint:
1469+error hint:
1470+
1471+ QUERY PLAN
1472+---------------------------------------------------------------------------------------
1473+ Index Scan using t1_i1 on t1 "123456789012345678901234567890123456789012345678901234"
1474+ Index Cond: (c1 = 1)
1475+(2 rows)
1476+
14601477 ----
14611478 ---- No. A-7-4 hint parse error
14621479 ----
--- a/expected/ut-G-9.1.out
+++ b/expected/ut-G-9.1.out
@@ -677,6 +677,29 @@ error hint:
677677
678678 RESET client_min_messages;
679679 ----
680+---- No. G-2-1 GUC parameter
681+----
682+-- No. G-2-1-3
683+/*+Set(1234567890123456789012345678901234567890123456789012345678901234 1)*/
684+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
685+NOTICE: identifier "1234567890123456789012345678901234567890123456789012345678901234" will be truncated to "123456789012345678901234567890123456789012345678901234567890123"
686+INFO: unrecognized configuration parameter "123456789012345678901234567890123456789012345678901234567890123"
687+ c1 | c2 | c3 | c4
688+----+----+----+----
689+ 1 | 1 | 1 | 1
690+(1 row)
691+
692+-- No. G-2-1-4
693+/*+Set(constraint_exclusion 1234567890123456789012345678901234567890123456789012345678901234)*/
694+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
695+INFO: invalid value for parameter "constraint_exclusion": "1234567890123456789012345678901234567890123456789012345678901234"
696+HINT: Available values: partition, on, off.
697+ c1 | c2 | c3 | c4
698+----+----+----+----
699+ 1 | 1 | 1 | 1
700+(1 row)
701+
702+----
680703 ---- No. G-2-2 category of GUC parameter and role
681704 ----
682705 -- No. G-2-2-1
--- a/expected/ut-G-9.2.out
+++ b/expected/ut-G-9.2.out
@@ -677,6 +677,29 @@ error hint:
677677
678678 RESET client_min_messages;
679679 ----
680+---- No. G-2-1 GUC parameter
681+----
682+-- No. G-2-1-3
683+/*+Set(1234567890123456789012345678901234567890123456789012345678901234 1)*/
684+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
685+NOTICE: identifier "1234567890123456789012345678901234567890123456789012345678901234" will be truncated to "123456789012345678901234567890123456789012345678901234567890123"
686+INFO: unrecognized configuration parameter "123456789012345678901234567890123456789012345678901234567890123"
687+ c1 | c2 | c3 | c4
688+----+----+----+----
689+ 1 | 1 | 1 | 1
690+(1 row)
691+
692+-- No. G-2-1-4
693+/*+Set(constraint_exclusion 1234567890123456789012345678901234567890123456789012345678901234)*/
694+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
695+INFO: invalid value for parameter "constraint_exclusion": "1234567890123456789012345678901234567890123456789012345678901234"
696+HINT: Available values: partition, on, off.
697+ c1 | c2 | c3 | c4
698+----+----+----+----
699+ 1 | 1 | 1 | 1
700+(1 row)
701+
702+----
680703 ---- No. G-2-2 category of GUC parameter and role
681704 ----
682705 -- No. G-2-2-1
--- a/sql/ut-A.sql
+++ b/sql/ut-A.sql
@@ -471,6 +471,11 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 "tT()""
471471 Setあ" WHERE "tT()""
472472 Setあ".c1 = 1;
473473
474+-- No. A-7-3-13
475+-- No. A-9-2-13
476+/*+SeqScan(a123456789b123456789c123456789d123456789e123456789f123)*/
477+EXPLAIN (COSTS false) SELECT * FROM s1.t1 "123456789012345678901234567890123456789012345678901234" WHERE "123456789012345678901234567890123456789012345678901234".c1 = 1;
478+
474479 ----
475480 ---- No. A-7-4 hint parse error
476481 ----
--- 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)';
4747 RESET client_min_messages;
4848
4949 ----
50+---- No. G-2-1 GUC parameter
51+----
52+
53+-- No. G-2-1-3
54+/*+Set(1234567890123456789012345678901234567890123456789012345678901234 1)*/
55+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
56+
57+-- No. G-2-1-4
58+/*+Set(constraint_exclusion 1234567890123456789012345678901234567890123456789012345678901234)*/
59+SELECT * FROM s1.t1 WHERE t1.c1 = 1;
60+
61+----
5062 ---- No. G-2-2 category of GUC parameter and role
5163 ----
5264
Show on old repository browser