(2 rows)
----
----- No. A-10-1 duplicate hint
-----
--- No. A-10-1-1
-EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2, s1.t3, s1.t4 WHERE t1.ctid = '(1,1)' AND t1.c1 = t2.c1 AND t2.ctid = '(1,1)' AND t1.c1 = t3.c1 AND t3.ctid = '(1,1)' AND t1.c1 = t4.c1 AND t4.ctid = '(1,1)';
- QUERY PLAN
------------------------------------------------------
- Nested Loop
- Join Filter: (t1.c1 = t4.c1)
- -> Nested Loop
- Join Filter: (t1.c1 = t3.c1)
- -> Nested Loop
- Join Filter: (t1.c1 = t2.c1)
- -> Tid Scan on t1
- TID Cond: (ctid = '(1,1)'::tid)
- -> Seq Scan on t2
- Filter: (ctid = '(1,1)'::tid)
- -> Tid Scan on t3
- TID Cond: (ctid = '(1,1)'::tid)
- -> Tid Scan on t4
- TID Cond: (ctid = '(1,1)'::tid)
-(14 rows)
-
-/*+
-Set(enable_tidscan aaa)
-Set(enable_tidscan on)
-Set(enable_tidscan off)
-SeqScan(t4)
-IndexScan(t4)
-BitmapScan(t4)
-TidScan(t4)
-NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-*/
-EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2, s1.t3, s1.t4 WHERE t1.ctid = '(1,1)' AND t1.c1 = t2.c1 AND t2.ctid = '(1,1)' AND t1.c1 = t3.c1 AND t3.ctid = '(1,1)' AND t1.c1 = t4.c1 AND t4.ctid = '(1,1)';
-INFO: hint syntax error at or near "SeqScan(t4)
-IndexScan(t4)
-BitmapScan(t4)
-TidScan(t4)
-NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict scan method hint.
-INFO: hint syntax error at or near "IndexScan(t4)
-BitmapScan(t4)
-TidScan(t4)
-NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict scan method hint.
-INFO: hint syntax error at or near "BitmapScan(t4)
-TidScan(t4)
-NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict scan method hint.
-INFO: hint syntax error at or near "NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict join method hint.
-INFO: hint syntax error at or near "MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict join method hint.
-INFO: hint syntax error at or near "Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict leading hint.
-INFO: hint syntax error at or near "Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict leading hint.
-INFO: hint syntax error at or near "Set(enable_tidscan aaa)
-Set(enable_tidscan on)
-Set(enable_tidscan off)
-SeqScan(t4)
-IndexScan(t4)
-BitmapScan(t4)
-TidScan(t4)
-NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict set hint.
-INFO: hint syntax error at or near "Set(enable_tidscan on)
-Set(enable_tidscan off)
-SeqScan(t4)
-IndexScan(t4)
-BitmapScan(t4)
-TidScan(t4)
-NestLoop(t4 t3)
-MergeJoin(t4 t3)
-HashJoin(t4 t3)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict set hint.
-LOG: pg_hint_plan:
-used hint:
-TidScan(t4)
-HashJoin(t3 t4)
-Leading(t4 t3 t2 t1)
-Set(enable_tidscan off)
-not used hint:
-duplication hint:
-SeqScan(t4)
-IndexScan(t4)
-BitmapScan(t4)
-NestLoop(t3 t4)
-MergeJoin(t3 t4)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan aaa)
-Set(enable_tidscan on)
-error hint:
-
- QUERY PLAN
------------------------------------------------------------
- Nested Loop
- -> Nested Loop
- Join Filter: (t3.c1 = t2.c1)
- -> Hash Join
- Hash Cond: (t3.c1 = t4.c1)
- -> Seq Scan on t3
- Filter: (ctid = '(1,1)'::tid)
- -> Hash
- -> Tid Scan on t4
- TID Cond: (ctid = '(1,1)'::tid)
- -> Seq Scan on t2
- Filter: (ctid = '(1,1)'::tid)
- -> Index Scan using t1_i1 on t1
- Index Cond: (c1 = t2.c1)
- Filter: (ctid = '(1,1)'::tid)
-(15 rows)
-
--- No. A-10-1-2
-EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2, s1.t3, s1.t4 WHERE t1.ctid = '(1,1)' AND t1.c1 = t2.c1 AND t2.ctid = '(1,1)' AND t1.c1 = t3.c1 AND t3.ctid = '(1,1)' AND t1.c1 = t4.c1 AND t4.ctid = '(1,1)';
- QUERY PLAN
------------------------------------------------------
- Nested Loop
- Join Filter: (t1.c1 = t4.c1)
- -> Nested Loop
- Join Filter: (t1.c1 = t3.c1)
- -> Nested Loop
- Join Filter: (t1.c1 = t2.c1)
- -> Tid Scan on t1
- TID Cond: (ctid = '(1,1)'::tid)
- -> Seq Scan on t2
- Filter: (ctid = '(1,1)'::tid)
- -> Tid Scan on t3
- TID Cond: (ctid = '(1,1)'::tid)
- -> Tid Scan on t4
- TID Cond: (ctid = '(1,1)'::tid)
-(14 rows)
-
-/*+
-SeqScan(t4)
-Set(enable_tidscan aaa)
-IndexScan(t4)
-NestLoop(t4 t3)
-Leading(t2 t1 t4 t3)
-Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-*/
-EXPLAIN (COSTS false) SELECT * FROM s1.t1, s1.t2, s1.t3, s1.t4 WHERE t1.ctid = '(1,1)' AND t1.c1 = t2.c1 AND t2.ctid = '(1,1)' AND t1.c1 = t3.c1 AND t3.ctid = '(1,1)' AND t1.c1 = t4.c1 AND t4.ctid = '(1,1)';
-INFO: hint syntax error at or near "SeqScan(t4)
-Set(enable_tidscan aaa)
-IndexScan(t4)
-NestLoop(t4 t3)
-Leading(t2 t1 t4 t3)
-Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict scan method hint.
-INFO: hint syntax error at or near "IndexScan(t4)
-NestLoop(t4 t3)
-Leading(t2 t1 t4 t3)
-Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict scan method hint.
-INFO: hint syntax error at or near "BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict scan method hint.
-INFO: hint syntax error at or near "NestLoop(t4 t3)
-Leading(t2 t1 t4 t3)
-Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict join method hint.
-INFO: hint syntax error at or near "MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict join method hint.
-INFO: hint syntax error at or near "Leading(t2 t1 t4 t3)
-Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict leading hint.
-INFO: hint syntax error at or near "Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict leading hint.
-INFO: hint syntax error at or near "Set(enable_tidscan aaa)
-IndexScan(t4)
-NestLoop(t4 t3)
-Leading(t2 t1 t4 t3)
-Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict set hint.
-INFO: hint syntax error at or near "Set(enable_tidscan on)
-BitmapScan(t4)
-MergeJoin(t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan off)
-TidScan(t4)
-HashJoin(t4 t3)
-Leading(t4 t3 t2 t1)
-"
-DETAIL: Conflict set hint.
-LOG: pg_hint_plan:
-used hint:
-TidScan(t4)
-HashJoin(t3 t4)
-Leading(t4 t3 t2 t1)
-Set(enable_tidscan off)
-not used hint:
-duplication hint:
-SeqScan(t4)
-IndexScan(t4)
-BitmapScan(t4)
-NestLoop(t3 t4)
-MergeJoin(t3 t4)
-Leading(t2 t1 t4 t3)
-Leading(t1 t4 t3 t2)
-Set(enable_tidscan aaa)
-Set(enable_tidscan on)
-error hint:
-
- QUERY PLAN
------------------------------------------------------------
- Nested Loop
- -> Nested Loop
- Join Filter: (t3.c1 = t2.c1)
- -> Hash Join
- Hash Cond: (t3.c1 = t4.c1)
- -> Seq Scan on t3
- Filter: (ctid = '(1,1)'::tid)
- -> Hash
- -> Tid Scan on t4
- TID Cond: (ctid = '(1,1)'::tid)
- -> Seq Scan on t2
- Filter: (ctid = '(1,1)'::tid)
- -> Index Scan using t1_i1 on t1
- Index Cond: (c1 = t2.c1)
- Filter: (ctid = '(1,1)'::tid)
-(15 rows)
-
-----
----- No. A-10-2 restrict query type
-----
--- No. A-10-2-1
-EXPLAIN (COSTS false) SELECT * FROM s1.t1 FULL OUTER JOIN s1.t2 ON (t1.c1 = t2.c1);
- QUERY PLAN
-------------------------------
- Hash Full Join
- Hash Cond: (t1.c1 = t2.c1)
- -> Seq Scan on t1
- -> Hash
- -> Seq Scan on t2
-(5 rows)
-
-/*+NestLoop(t1 t2)*/
-EXPLAIN (COSTS true) SELECT * FROM s1.t1 FULL OUTER JOIN s1.t2 ON (t1.c1 = t2.c1);
-LOG: pg_hint_plan:
-used hint:
-NestLoop(t1 t2)
-not used hint:
-duplication hint:
-error hint:
-
- QUERY PLAN
---------------------------------------------------------------------------
- Hash Full Join (cost=10000000003.25..10000000024.00 rows=1000 width=29)
- Hash Cond: (t1.c1 = t2.c1)
- -> Seq Scan on t1 (cost=0.00..16.00 rows=1000 width=15)
- -> Hash (cost=2.00..2.00 rows=100 width=14)
- -> Seq Scan on t2 (cost=0.00..2.00 rows=100 width=14)
-(5 rows)
-
--- No. A-10-2-2
-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c3 = 1;
- QUERY PLAN
----------------------------------
- Bitmap Heap Scan on t1
- Recheck Cond: (c3 = 1)
- -> Bitmap Index Scan on t1_i
- Index Cond: (c3 = 1)
-(4 rows)
-
-/*+IndexScan(t1 t1_i1)*/
-EXPLAIN (COSTS true) SELECT * FROM s1.t1 WHERE t1.c3 = 1;
-LOG: available indexes for IndexScan(t1): t1_i1
-LOG: pg_hint_plan:
-used hint:
-IndexScan(t1 t1_i1)
-not used hint:
-duplication hint:
-error hint:
-
- QUERY PLAN
-------------------------------------------------------------------------
- Seq Scan on t1 (cost=10000000000.00..10000000018.50 rows=10 width=15)
- Filter: (c3 = 1)
-(2 rows)
-
--- No. A-10-2-3
-EXPLAIN (COSTS false) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
- QUERY PLAN
-------------------------------
- Index Scan using t1_i1 on t1
- Index Cond: (c1 = 1)
-(2 rows)
-
-/*+TidScan(t1)*/
-EXPLAIN (COSTS true) SELECT * FROM s1.t1 WHERE t1.c1 = 1;
-LOG: pg_hint_plan:
-used hint:
-TidScan(t1)
-not used hint:
-duplication hint:
-error hint:
-
- QUERY PLAN
------------------------------------------------------------------------
- Seq Scan on t1 (cost=10000000000.00..10000000018.50 rows=1 width=15)
- Filter: (c1 = 1)
-(2 rows)
-
-----
----- No. A-10-3 VIEW, RULE multi specified
-----
--- No. A-10-3-1
-EXPLAIN (COSTS false) SELECT * FROM s1.v1 v1, s1.v1 v2 WHERE v1.c1 = v2.c1;
- QUERY PLAN
-----------------------------------
- Hash Join
- Hash Cond: (v1t1.c1 = v1t1.c1)
- -> Seq Scan on t1 v1t1
- -> Hash
- -> Seq Scan on t1 v1t1
-(5 rows)
-
-/*+Leading(v1t1 v1t1)HashJoin(v1t1 v1t1)BitmapScan(v1t1)*/
-EXPLAIN (COSTS false) SELECT * FROM s1.v1 v1, s1.v1 v2 WHERE v1.c1 = v2.c1;
-INFO: hint syntax error at or near "HashJoin(v1t1 v1t1)BitmapScan(v1t1)"
-DETAIL: Relation name "v1t1" is ambiguous.
-INFO: hint syntax error at or near "Leading(v1t1 v1t1)HashJoin(v1t1 v1t1)BitmapScan(v1t1)"
-DETAIL: Relation name "v1t1" is ambiguous.
-LOG: pg_hint_plan:
-used hint:
-BitmapScan(v1t1)
-not used hint:
-Leading(v1t1 v1t1)
-duplication hint:
-error hint:
-HashJoin(v1t1 v1t1)
-
- QUERY PLAN
-------------------------------------------
- Nested Loop
- -> Index Scan using t1_i1 on t1 v1t1
- -> Bitmap Heap Scan on t1 v1t1
- Recheck Cond: (c1 = v1t1.c1)
- -> Bitmap Index Scan on t1_i1
- Index Cond: (c1 = v1t1.c1)
-(6 rows)
-
--- No. A-10-3-2
-EXPLAIN (COSTS false) SELECT * FROM s1.v1 v1, s1.v1_ v2 WHERE v1.c1 = v2.c1;
- QUERY PLAN
------------------------------------
- Hash Join
- Hash Cond: (v1t1.c1 = v1t1_.c1)
- -> Seq Scan on t1 v1t1
- -> Hash
- -> Seq Scan on t1 v1t1_
-(5 rows)
-
-/*+Leading(v1t1 v1t1_)NestLoop(v1t1 v1t1_)SeqScan(v1t1)BitmapScan(v1t1_)*/
-EXPLAIN (COSTS false) SELECT * FROM s1.v1 v1, s1.v1_ v2 WHERE v1.c1 = v2.c1;
-LOG: pg_hint_plan:
-used hint:
-SeqScan(v1t1)
-BitmapScan(v1t1_)
-NestLoop(v1t1 v1t1_)
-Leading(v1t1 v1t1_)
-not used hint:
-duplication hint:
-error hint:
-
- QUERY PLAN
-------------------------------------------
- Nested Loop
- -> Seq Scan on t1 v1t1
- -> Bitmap Heap Scan on t1 v1t1_
- Recheck Cond: (c1 = v1t1.c1)
- -> Bitmap Index Scan on t1_i1
- Index Cond: (c1 = v1t1.c1)
-(6 rows)
-
--- No. A-10-3-3
-EXPLAIN (COSTS false) SELECT * FROM s1.r4 t1, s1.r4 t2 WHERE t1.c1 = t2.c1;
- QUERY PLAN
-----------------------------------
- Hash Join
- Hash Cond: (r4t1.c1 = r4t1.c1)
- -> Seq Scan on t1 r4t1
- -> Hash
- -> Seq Scan on t1 r4t1
-(5 rows)
-
-/*+Leading(r4t1 r4t1)HashJoin(r4t1 r4t1)BitmapScan(r4t1)*/
-EXPLAIN (COSTS false) SELECT * FROM s1.r4 t1, s1.r4 t2 WHERE t1.c1 = t2.c1;
-INFO: hint syntax error at or near "HashJoin(r4t1 r4t1)BitmapScan(r4t1)"
-DETAIL: Relation name "r4t1" is ambiguous.
-INFO: hint syntax error at or near "Leading(r4t1 r4t1)HashJoin(r4t1 r4t1)BitmapScan(r4t1)"
-DETAIL: Relation name "r4t1" is ambiguous.
-LOG: pg_hint_plan:
-used hint:
-BitmapScan(r4t1)
-not used hint:
-Leading(r4t1 r4t1)
-duplication hint:
-error hint:
-HashJoin(r4t1 r4t1)
-
- QUERY PLAN
-------------------------------------------
- Nested Loop
- -> Index Scan using t1_i1 on t1 r4t1
- -> Bitmap Heap Scan on t1 r4t1
- Recheck Cond: (c1 = r4t1.c1)
- -> Bitmap Index Scan on t1_i1
- Index Cond: (c1 = r4t1.c1)
-(6 rows)
-
--- No. A-10-3-4
-EXPLAIN (COSTS false) SELECT * FROM s1.r4 t1, s1.r5 t2 WHERE t1.c1 = t2.c1;
- QUERY PLAN
-----------------------------------
- Hash Join
- Hash Cond: (r4t1.c1 = r5t1.c1)
- -> Seq Scan on t1 r4t1
- -> Hash
- -> Seq Scan on t1 r5t1
-(5 rows)
-
-/*+Leading(r4t1 r5t1)NestLoop(r4t1 r5t1)SeqScan(r4t1)BitmapScan(r5t1)*/
-EXPLAIN (COSTS false) SELECT * FROM s1.r4 t1, s1.r5 t2 WHERE t1.c1 = t2.c1;
-LOG: pg_hint_plan:
-used hint:
-SeqScan(r4t1)
-BitmapScan(r5t1)
-NestLoop(r4t1 r5t1)
-Leading(r4t1 r5t1)
-not used hint:
-duplication hint:
-error hint:
-
- QUERY PLAN
-------------------------------------------
- Nested Loop
- -> Seq Scan on t1 r4t1
- -> Bitmap Heap Scan on t1 r5t1
- Recheck Cond: (c1 = r4t1.c1)
- -> Bitmap Index Scan on t1_i1
- Index Cond: (c1 = r4t1.c1)
-(6 rows)
-
-----
----- No. A-11-1 psql command
-----
-SELECT count(*) FROM s1.t1 WHERE t1.c1 = 1;
- count
--------
- 1
-(1 row)
-
-/*+SeqScan(t1)*/
-SELECT count(*) FROM s1.t1 WHERE t1.c1 = 1;
-LOG: pg_hint_plan:
-used hint:
-SeqScan(t1)
-not used hint:
-duplication hint:
-error hint:
-
- count
--------
- 1
-(1 row)
-
--- No. A-11-1-4
-\set FETCH_COUNT 0
-/*+SeqScan(t1)*/
-SELECT count(*) FROM s1.t1 WHERE t1.c1 = 1;
-LOG: pg_hint_plan:
-used hint:
-SeqScan(t1)
-not used hint:
-duplication hint:
-error hint:
-
- count
--------
- 1
-(1 row)
-
--- No. A-11-1-5
-\set FETCH_COUNT 1
-/*+SeqScan(t1)*/
-SELECT count(*) FROM s1.t1 WHERE t1.c1 = 1;
- count
--------
- 1
-(1 row)
-
-\unset FETCH_COUNT
-----
----- No. A-11-4 PL/pgSQL function
-----
--- No. A-11-4-1
-CREATE OR REPLACE FUNCTION f1() RETURNS SETOF text LANGUAGE plpgsql AS $$
-DECLARE
- r text;
-BEGIN
- FOR r IN EXPLAIN SELECT c4 FROM s1.t1 WHERE t1.c1 = 1
- LOOP
- RETURN NEXT r; -- return current row of SELECT
- END LOOP;
- RETURN;
-END
-$$;
-SELECT f1();
- f1
-----------------------------------------------------------------
- Index Scan using t1_i1 on t1 (cost=0.00..8.27 rows=1 width=3)
- Index Cond: (c1 = 1)
-(2 rows)
-
-/*+SeqScan(t1)*/
-SELECT f1();
-LOG: pg_hint_plan:
-used hint:
-not used hint:
-SeqScan(t1)
-duplication hint:
-error hint:
-
-LOG: pg_hint_plan:
-used hint:
-SeqScan(t1)
-not used hint:
-duplication hint:
-error hint:
-
-CONTEXT: PL/pgSQL function f1() line 5 at FOR over SELECT rows
- f1
----------------------------------------------------
- Seq Scan on t1 (cost=0.00..18.50 rows=1 width=3)
- Filter: (c1 = 1)
-(2 rows)
-
--- No. A-11-4-2
-/*+SeqScan(t1)*/CREATE OR REPLACE FUNCTION f1() RETURNS SETOF text LANGUAGE plpgsql AS $$
-DECLARE
- r text;
-BEGIN
- /*+SeqScan(t1)*/FOR r IN EXPLAIN /*+SeqScan(t1)*/SELECT c4 FROM s1.t1 WHERE t1.c1 = 1
- LOOP
- /*+SeqScan(t1)*/RETURN NEXT r; -- return current row of SELECT
- END LOOP;
- /*+SeqScan(t1)*/RETURN;
-END
-$$;
-SELECT f1();
- f1
-----------------------------------------------------------------
- Index Scan using t1_i1 on t1 (cost=0.00..8.27 rows=1 width=3)
- Index Cond: (c1 = 1)
-(2 rows)
-
-----
---- No. A-12-1 reset of global variable of core at the error
---- No. A-12-2 reset of global variable of original at the error
----