• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revisionce19272adf7f1c0a3aed0b7825bd4fd07cced965 (tree)
Time2014-01-30 15:42:06
AuthorTakashi Suzuki <suzuki.takashi@metr...>
CommiterTakashi Suzuki

Log Message

出力メッセージ変更後の状態にリグレッションテストの予測結果を変更した。

Change Summary

Incremental Difference

--- a/expected/pg_hint_plan.out
+++ b/expected/pg_hint_plan.out
@@ -8148,7 +8148,7 @@ Rows(t1 t2 #aa)
81488148 /*+ Rows(t1 t2 /99) */
81498149 EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id); -- ERROR
81508150 INFO: hint syntax error at or near "/99"
8151-DETAIL: unrecognized rows value type notation.
8151+DETAIL: Unrecognized rows value type notation.
81528152 LOG: pg_hint_plan:
81538153 used hint:
81548154 not used hint:
@@ -8167,7 +8167,7 @@ Rows(t1 t2 /99)
81678167 -- round up to 1
81688168 /*+ Rows(t1 t2 -99999) */
81698169 EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id);
8170-WARNING: make rows estimation 1 since below 1 : Rows(t1 t2 -99999)
8170+WARNING: Force estimate to be at least one row, to avoid possible divide-by-zero when interpolating costs : Rows(t1 t2 -99999)
81718171 LOG: pg_hint_plan:
81728172 used hint:
81738173 Rows(t1 t2 -99999)
--- a/expected/ut-R.out
+++ b/expected/ut-R.out
@@ -497,7 +497,7 @@ Rows(t1 #1)
497497 /*+Rows(t1 t2 1)*/
498498 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
499499 INFO: hint syntax error at or near "1"
500-DETAIL: unrecognized rows value type notation.
500+DETAIL: Unrecognized rows value type notation.
501501 LOG: pg_hint_plan:
502502 used hint:
503503 not used hint:
@@ -2183,7 +2183,7 @@ error hint:
21832183 \o results/R_3-1-1.out.log
21842184 /*+Rows(t1 t2 #0)*/
21852185 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
2186-WARNING: make rows estimation 1 since below 1 : Rows(t1 t2 #0)
2186+WARNING: Force estimate to be at least one row, to avoid possible divide-by-zero when interpolating costs : Rows(t1 t2 #0)
21872187 LOG: pg_hint_plan:
21882188 used hint:
21892189 Rows(t1 t2 #0)
@@ -2243,7 +2243,7 @@ error hint:
22432243 \o results/R_3-2-3.out.log
22442244 /*+Rows(t1 t2 -1000)*/
22452245 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
2246-WARNING: make rows estimation 1 since below 1 : Rows(t1 t2 -1000)
2246+WARNING: Force estimate to be at least one row, to avoid possible divide-by-zero when interpolating costs : Rows(t1 t2 -1000)
22472247 LOG: pg_hint_plan:
22482248 used hint:
22492249 Rows(t1 t2 -1000)
@@ -2261,7 +2261,7 @@ error hint:
22612261 \o results/R_3-3-1.out.log
22622262 /*+Rows(t1 t2 *0)*/
22632263 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
2264-WARNING: make rows estimation 1 since below 1 : Rows(t1 t2 *0)
2264+WARNING: Force estimate to be at least one row, to avoid possible divide-by-zero when interpolating costs : Rows(t1 t2 *0)
22652265 LOG: pg_hint_plan:
22662266 used hint:
22672267 Rows(t1 t2 *0)
Show on old repository browser