ORDER BY t_1.c1 LIMIT 1;
$$ LANGUAGE SQL IMMUTABLE;
--No.13-4-1
+-- recall_planner() is reduced to constant while planning using the
+-- hint defined in the function. Then the outer query is planned based
+-- on the following hint. pg_hint_plan shows the log for the function
+-- but the resulting explain output doesn't contain the corresponding
+-- plan.
/*+HashJoin(t_1 t_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 t_1
(7 rows)
--No.13-4-2
--- recall_planner() is reduced to constant while planning using the
--- hint defined in the function. Then the outer query is planned based
--- on the following hint. pg_hint_plan shows the log for the function
--- but the resulting explain output doesn't contain the corresponding
--- plan.
+--See description for No.13-4-1
/*+HashJoin(st_1 st_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 st_1
(7 rows)
--No.13-4-3
---See description for No.13-4-2
+--See description for No.13-4-1
/*+HashJoin(t_1 t_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 st_1
(6 rows)
--No.13-4-4
---See description for No.13-4-2
+--See description for No.13-4-1
/*+HashJoin(st_1 st_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 t_1
(6 rows)
--No.13-4-5
--- See description for No.13-4-2. No joins in ths plan, so
+-- See description for No.13-4-1. No joins in ths plan, so
-- pg_hint_plan doesn't complain on the wrongly written error hint.
/*+HashJoin(t_1 t_1)*/
EXPLAIN (COSTS false)
DROP FUNCTION recall_planner_one_t(int);
ERROR: function recall_planner_one_t(integer) does not exist
--No.13-4-7
--- See description for No.13-4-2. Complains on the wrongly wrtten hit.
+-- See description for No.13-4-1. Complains on the wrongly written hint.
/*+HashJoin(t_1 t_1)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 t_1
$$ LANGUAGE SQL IMMUTABLE;
--No.13-4-1
+-- recall_planner() is reduced to constant while planning using the
+-- hint defined in the function. Then the outer query is planned based
+-- on the following hint. pg_hint_plan shows the log for the function
+-- but the resulting explain output doesn't contain the corresponding
+-- plan.
/*+HashJoin(t_1 t_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 t_1
ORDER BY t_1.c1;
--No.13-4-2
--- recall_planner() is reduced to constant while planning using the
--- hint defined in the function. Then the outer query is planned based
--- on the following hint. pg_hint_plan shows the log for the function
--- but the resulting explain output doesn't contain the corresponding
--- plan.
+--See description for No.13-4-1
/*+HashJoin(st_1 st_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 st_1
ORDER BY st_1.c1;
--No.13-4-3
---See description for No.13-4-2
+--See description for No.13-4-1
/*+HashJoin(t_1 t_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 st_1
ORDER BY st_1.c1;
--No.13-4-4
---See description for No.13-4-2
+--See description for No.13-4-1
/*+HashJoin(st_1 st_2)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 t_1
ORDER BY t_1.c1;
--No.13-4-5
--- See description for No.13-4-2. No joins in ths plan, so
+-- See description for No.13-4-1. No joins in ths plan, so
-- pg_hint_plan doesn't complain on the wrongly written error hint.
/*+HashJoin(t_1 t_1)*/
EXPLAIN (COSTS false)
DROP FUNCTION recall_planner_one_t(int);
--No.13-4-7
--- See description for No.13-4-2. Complains on the wrongly wrtten hit.
+-- See description for No.13-4-1. Complains on the wrongly written hint.
/*+HashJoin(t_1 t_1)*/
EXPLAIN (COSTS false)
SELECT recall_planner() FROM s1.t1 t_1