• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revisionb7ad30c63b36abc1bf3fc453ad92edea454debae (tree)
Time2013-08-09 15:45:30
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
@@ -44,7 +44,7 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
4444 (2 rows)
4545
4646 -- No. A-5-1-3
47---+SeqScan(t1)
47+/*SeqScan(t1)*/
4848 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
4949 QUERY PLAN
5050 ------------------------------
@@ -62,46 +62,7 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
6262 (2 rows)
6363
6464 -- No. A-5-1-5
65--- +SeqScan(t1)
66-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
67- QUERY PLAN
68-------------------------------
69- Index Scan using t1_i1 on t1
70- Index Cond: (c1 = 1)
71-(2 rows)
72-
73--- No. A-5-1-6
74---SeqScan(t1)
75-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
76- QUERY PLAN
77-------------------------------
78- Index Scan using t1_i1 on t1
79- Index Cond: (c1 = 1)
80-(2 rows)
81-
82--- No. A-5-1-7
83-/*+SeqScan(t1) /* nest comment */ */
84-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
85-INFO: hint syntax error at or near "/* nest comment */ */
86-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;"
87-DETAIL: Nested block comments are not supported.
88- QUERY PLAN
89-------------------------------
90- Index Scan using t1_i1 on t1
91- Index Cond: (c1 = 1)
92-(2 rows)
93-
94--- No. A-5-1-8
95-/* +SeqScan(t1) /* nest comment */ */
96-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
97- QUERY PLAN
98-------------------------------
99- Index Scan using t1_i1 on t1
100- Index Cond: (c1 = 1)
101-(2 rows)
102-
103--- No. A-5-1-9
104-/*SeqScan(t1) /* nest comment */ */
65+/* /*+SeqScan(t1)*/ */
10566 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
10667 QUERY PLAN
10768 ------------------------------
--- a/expected/ut-A-9.2.out
+++ b/expected/ut-A-9.2.out
@@ -44,7 +44,7 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
4444 (2 rows)
4545
4646 -- No. A-5-1-3
47---+SeqScan(t1)
47+/*SeqScan(t1)*/
4848 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
4949 QUERY PLAN
5050 ------------------------------
@@ -62,46 +62,7 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
6262 (2 rows)
6363
6464 -- No. A-5-1-5
65--- +SeqScan(t1)
66-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
67- QUERY PLAN
68-------------------------------
69- Index Scan using t1_i1 on t1
70- Index Cond: (c1 = 1)
71-(2 rows)
72-
73--- No. A-5-1-6
74---SeqScan(t1)
75-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
76- QUERY PLAN
77-------------------------------
78- Index Scan using t1_i1 on t1
79- Index Cond: (c1 = 1)
80-(2 rows)
81-
82--- No. A-5-1-7
83-/*+SeqScan(t1) /* nest comment */ */
84-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
85-INFO: hint syntax error at or near "/* nest comment */ */
86-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;"
87-DETAIL: Nested block comments are not supported.
88- QUERY PLAN
89-------------------------------
90- Index Scan using t1_i1 on t1
91- Index Cond: (c1 = 1)
92-(2 rows)
93-
94--- No. A-5-1-8
95-/* +SeqScan(t1) /* nest comment */ */
96-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
97- QUERY PLAN
98-------------------------------
99- Index Scan using t1_i1 on t1
100- Index Cond: (c1 = 1)
101-(2 rows)
102-
103--- No. A-5-1-9
104-/*SeqScan(t1) /* nest comment */ */
65+/* /*+SeqScan(t1)*/ */
10566 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
10667 QUERY PLAN
10768 ------------------------------
--- a/sql/ut-A.sql
+++ b/sql/ut-A.sql
@@ -33,7 +33,7 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3333 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3434
3535 -- No. A-5-1-3
36---+SeqScan(t1)
36+/*SeqScan(t1)*/
3737 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
3838
3939 -- No. A-5-1-4
@@ -41,23 +41,7 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
4141 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
4242
4343 -- No. A-5-1-5
44--- +SeqScan(t1)
45-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
46-
47--- No. A-5-1-6
48---SeqScan(t1)
49-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
50-
51--- No. A-5-1-7
52-/*+SeqScan(t1) /* nest comment */ */
53-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
54-
55--- No. A-5-1-8
56-/* +SeqScan(t1) /* nest comment */ */
57-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
58-
59--- No. A-5-1-9
60-/*SeqScan(t1) /* nest comment */ */
44+/* /*+SeqScan(t1)*/ */
6145 EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
6246
6347 ----
Show on old repository browser