• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revision2889ddb02a55230431a29bfce52140c41322a75a (tree)
Time2013-09-13 15:46:41
AuthorTakashi Suzuki <suzuki.takashi@metr...>
CommiterTakashi Suzuki

Log Message

PL/pgSQL文に関する仕様変更にそってリグレッションテストの内容を変更した。

Change Summary

Incremental Difference

--- a/expected/ut-A-9.1.out
+++ b/expected/ut-A-9.1.out
@@ -4016,11 +4016,10 @@ BEGIN
40164016 RETURN 0;
40174017 END IF;
40184018
4019- EXECUTE '/*+ IndexScan(t_1) */'
4020- ' SELECT nested_planner($1) FROM s1.t1 t_1'
4021- ' JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)'
4022- ' ORDER BY t_1.c1 LIMIT 1'
4023- INTO new_cnt USING cnt - 1;
4019+ SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) INTO new_cnt
4020+ FROM s1.t1 t_1
4021+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4022+ ORDER BY t_1.c1 LIMIT 1;
40244023
40254024 RETURN new_cnt;
40264025 END;
@@ -4082,9 +4081,22 @@ error hint:
40824081 --No.13-3-2
40834082 EXPLAIN (COSTS false) SELECT nested_planner(2) FROM s1.t1 t_1 ORDER BY t_1.c1;
40844083 NOTICE: nested_planner(2)
4084+LOG: pg_hint_plan:
4085+used hint:
4086+IndexScan(t_1)
4087+not used hint:
4088+duplication hint:
4089+error hint:
4090+
4091+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4092+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4093+ ORDER BY t_1.c1 LIMIT 1"
4094+PL/pgSQL function "nested_planner" line 12 at SQL statement
40854095 NOTICE: nested_planner(1)
4086-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4087-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4096+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4097+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4098+ ORDER BY t_1.c1 LIMIT 1"
4099+PL/pgSQL function "nested_planner" line 12 at SQL statement
40884100 QUERY PLAN
40894101 ----------------------------------
40904102 Index Scan using t1_i1 on t1 t_1
@@ -4094,17 +4106,10 @@ PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
40944106 EXPLAIN (COSTS false) SELECT nested_planner(2) FROM s1.t1 t_1 ORDER BY t_1.c1;
40954107 NOTICE: nested_planner(2)
40964108 NOTICE: nested_planner(1)
4097-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4098-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4099-LOG: pg_hint_plan:
4100-used hint:
4101-SeqScan(t_2)
4102-not used hint:
4103-duplication hint:
4104-error hint:
4105-
4106-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4107-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4109+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4110+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4111+ ORDER BY t_1.c1 LIMIT 1"
4112+PL/pgSQL function "nested_planner" line 12 at SQL statement
41084113 LOG: pg_hint_plan:
41094114 used hint:
41104115 not used hint:
@@ -4121,29 +4126,49 @@ error hint:
41214126 EXPLAIN (COSTS false) SELECT nested_planner(5) FROM s1.t1 t_1 ORDER BY t_1.c1;
41224127 NOTICE: nested_planner(5)
41234128 NOTICE: nested_planner(4)
4124-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4125-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4129+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4130+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4131+ ORDER BY t_1.c1 LIMIT 1"
4132+PL/pgSQL function "nested_planner" line 12 at SQL statement
41264133 NOTICE: nested_planner(3)
4127-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4128-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4129-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4130-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4134+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4135+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4136+ ORDER BY t_1.c1 LIMIT 1"
4137+PL/pgSQL function "nested_planner" line 12 at SQL statement
4138+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4139+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4140+ ORDER BY t_1.c1 LIMIT 1"
4141+PL/pgSQL function "nested_planner" line 12 at SQL statement
41314142 NOTICE: nested_planner(2)
4132-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4133-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4134-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4135-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4136-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4137-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4143+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4144+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4145+ ORDER BY t_1.c1 LIMIT 1"
4146+PL/pgSQL function "nested_planner" line 12 at SQL statement
4147+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4148+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4149+ ORDER BY t_1.c1 LIMIT 1"
4150+PL/pgSQL function "nested_planner" line 12 at SQL statement
4151+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4152+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4153+ ORDER BY t_1.c1 LIMIT 1"
4154+PL/pgSQL function "nested_planner" line 12 at SQL statement
41384155 NOTICE: nested_planner(1)
4139-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4140-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4141-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4142-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4143-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4144-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4145-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4146-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4156+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4157+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4158+ ORDER BY t_1.c1 LIMIT 1"
4159+PL/pgSQL function "nested_planner" line 12 at SQL statement
4160+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4161+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4162+ ORDER BY t_1.c1 LIMIT 1"
4163+PL/pgSQL function "nested_planner" line 12 at SQL statement
4164+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4165+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4166+ ORDER BY t_1.c1 LIMIT 1"
4167+PL/pgSQL function "nested_planner" line 12 at SQL statement
4168+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4169+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4170+ ORDER BY t_1.c1 LIMIT 1"
4171+PL/pgSQL function "nested_planner" line 12 at SQL statement
41474172 QUERY PLAN
41484173 ----------------------------------
41494174 Index Scan using t1_i1 on t1 t_1
@@ -4153,77 +4178,49 @@ PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
41534178 EXPLAIN (COSTS false) SELECT nested_planner(5) FROM s1.t1 t_1 ORDER BY t_1.c1;
41544179 NOTICE: nested_planner(5)
41554180 NOTICE: nested_planner(4)
4156-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4157-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4181+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4182+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4183+ ORDER BY t_1.c1 LIMIT 1"
4184+PL/pgSQL function "nested_planner" line 12 at SQL statement
41584185 NOTICE: nested_planner(3)
4159-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4160-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4161-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4162-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4186+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4187+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4188+ ORDER BY t_1.c1 LIMIT 1"
4189+PL/pgSQL function "nested_planner" line 12 at SQL statement
4190+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4191+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4192+ ORDER BY t_1.c1 LIMIT 1"
4193+PL/pgSQL function "nested_planner" line 12 at SQL statement
41634194 NOTICE: nested_planner(2)
4164-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4165-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4166-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4167-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4168-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4169-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4195+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4196+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4197+ ORDER BY t_1.c1 LIMIT 1"
4198+PL/pgSQL function "nested_planner" line 12 at SQL statement
4199+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4200+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4201+ ORDER BY t_1.c1 LIMIT 1"
4202+PL/pgSQL function "nested_planner" line 12 at SQL statement
4203+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4204+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4205+ ORDER BY t_1.c1 LIMIT 1"
4206+PL/pgSQL function "nested_planner" line 12 at SQL statement
41704207 NOTICE: nested_planner(1)
4171-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4172-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4173-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4174-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4175-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4176-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4177-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4178-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4179-LOG: pg_hint_plan:
4180-used hint:
4181-SeqScan(t_2)
4182-not used hint:
4183-duplication hint:
4184-error hint:
4185-
4186-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4187-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4188-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4189-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4190-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4191-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4192-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4193-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4194-LOG: pg_hint_plan:
4195-used hint:
4196-SeqScan(t_2)
4197-not used hint:
4198-duplication hint:
4199-error hint:
4200-
4201-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4202-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4203-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4204-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4205-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4206-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4207-LOG: pg_hint_plan:
4208-used hint:
4209-SeqScan(t_2)
4210-not used hint:
4211-duplication hint:
4212-error hint:
4213-
4214-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4215-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4216-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4217-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4218-LOG: pg_hint_plan:
4219-used hint:
4220-SeqScan(t_2)
4221-not used hint:
4222-duplication hint:
4223-error hint:
4224-
4225-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4226-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4208+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4209+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4210+ ORDER BY t_1.c1 LIMIT 1"
4211+PL/pgSQL function "nested_planner" line 12 at SQL statement
4212+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4213+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4214+ ORDER BY t_1.c1 LIMIT 1"
4215+PL/pgSQL function "nested_planner" line 12 at SQL statement
4216+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4217+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4218+ ORDER BY t_1.c1 LIMIT 1"
4219+PL/pgSQL function "nested_planner" line 12 at SQL statement
4220+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4221+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4222+ ORDER BY t_1.c1 LIMIT 1"
4223+PL/pgSQL function "nested_planner" line 12 at SQL statement
42274224 LOG: pg_hint_plan:
42284225 used hint:
42294226 not used hint:
@@ -4247,17 +4244,10 @@ EXPLAIN (COSTS false)
42474244 ORDER BY t_1.c1;
42484245 NOTICE: nested_planner(2)
42494246 NOTICE: nested_planner(1)
4250-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4251-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4252-LOG: pg_hint_plan:
4253-used hint:
4254-HashJoin(t_1 t_2)
4255-not used hint:
4256-duplication hint:
4257-error hint:
4258-
4259-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4260-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4247+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4248+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4249+ ORDER BY t_1.c1 LIMIT 1"
4250+PL/pgSQL function "nested_planner" line 12 at SQL statement
42614251 LOG: pg_hint_plan:
42624252 used hint:
42634253 HashJoin(t_1 t_2)
@@ -4284,17 +4274,10 @@ EXPLAIN (COSTS false)
42844274 ORDER BY st_1.c1;
42854275 NOTICE: nested_planner(2)
42864276 NOTICE: nested_planner(1)
4287-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4288-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4289-LOG: pg_hint_plan:
4290-used hint:
4291-not used hint:
4292-HashJoin(st_1 st_2)
4293-duplication hint:
4294-error hint:
4295-
4296-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4297-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4277+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4278+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4279+ ORDER BY t_1.c1 LIMIT 1"
4280+PL/pgSQL function "nested_planner" line 12 at SQL statement
42984281 LOG: pg_hint_plan:
42994282 used hint:
43004283 HashJoin(st_1 st_2)
@@ -4321,17 +4304,10 @@ EXPLAIN (COSTS false)
43214304 ORDER BY st_1.c1;
43224305 NOTICE: nested_planner(2)
43234306 NOTICE: nested_planner(1)
4324-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4325-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4326-LOG: pg_hint_plan:
4327-used hint:
4328-HashJoin(t_1 t_2)
4329-not used hint:
4330-duplication hint:
4331-error hint:
4332-
4333-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4334-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4307+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4308+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4309+ ORDER BY t_1.c1 LIMIT 1"
4310+PL/pgSQL function "nested_planner" line 12 at SQL statement
43354311 LOG: pg_hint_plan:
43364312 used hint:
43374313 not used hint:
@@ -4357,17 +4333,10 @@ EXPLAIN (COSTS false)
43574333 ORDER BY t_1.c1;
43584334 NOTICE: nested_planner(2)
43594335 NOTICE: nested_planner(1)
4360-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4361-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4362-LOG: pg_hint_plan:
4363-used hint:
4364-not used hint:
4365-HashJoin(st_1 st_2)
4366-duplication hint:
4367-error hint:
4368-
4369-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4370-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4336+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4337+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4338+ ORDER BY t_1.c1 LIMIT 1"
4339+PL/pgSQL function "nested_planner" line 12 at SQL statement
43714340 LOG: pg_hint_plan:
43724341 used hint:
43734342 not used hint:
@@ -4392,21 +4361,10 @@ EXPLAIN (COSTS false)
43924361 ORDER BY t_1.c1;
43934362 NOTICE: nested_planner(2)
43944363 NOTICE: nested_planner(1)
4395-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4396-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4397-INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
4398-DETAIL: Relation name "t_1" is duplicated.
4399-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4400-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4401-LOG: pg_hint_plan:
4402-used hint:
4403-not used hint:
4404-duplication hint:
4405-error hint:
4406-HashJoin(t_1 t_1)
4407-
4408-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4409-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4364+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4365+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4366+ ORDER BY t_1.c1 LIMIT 1"
4367+PL/pgSQL function "nested_planner" line 12 at SQL statement
44104368 LOG: pg_hint_plan:
44114369 used hint:
44124370 not used hint:
@@ -4430,10 +4388,9 @@ BEGIN
44304388 RETURN 0;
44314389 END IF;
44324390
4433- EXECUTE '/*+ IndexScan(t_1) */'
4434- ' SELECT nested_planner_one_t($1) FROM s1.t1 t_1'
4435- ' ORDER BY t_1.c1 LIMIT 1'
4436- INTO new_cnt USING cnt - 1;
4391+ SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) INTO new_cnt
4392+ FROM s1.t1 t_1
4393+ ORDER BY t_1.c1 LIMIT 1;
44374394
44384395 RETURN new_cnt;
44394396 END;
@@ -4443,9 +4400,32 @@ EXPLAIN (COSTS false)
44434400 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
44444401 ORDER BY t_1.c1;
44454402 NOTICE: nested_planner_one_t(2)
4403+LOG: pg_hint_plan:
4404+used hint:
4405+IndexScan(t_1)
4406+not used hint:
4407+duplication hint:
4408+error hint:
4409+
4410+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4411+ ORDER BY t_1.c1 LIMIT 1"
4412+PL/pgSQL function "nested_planner_one_t" line 11 at SQL statement
44464413 NOTICE: nested_planner_one_t(1)
4447-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner_one_t($1) FROM s1.t1 t_1 ORDER BY t_1.c1 LIMIT 1"
4448-PL/pgSQL function "nested_planner_one_t" line 11 at EXECUTE statement
4414+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4415+ ORDER BY t_1.c1 LIMIT 1"
4416+PL/pgSQL function "nested_planner_one_t" line 11 at SQL statement
4417+LOG: pg_hint_plan:
4418+used hint:
4419+not used hint:
4420+IndexScan(t_1)
4421+duplication hint:
4422+error hint:
4423+
4424+CONTEXT: SQL statement "SELECT 0"
4425+PL/pgSQL function "nested_planner_one_t" line 8 at RETURN
4426+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4427+ ORDER BY t_1.c1 LIMIT 1"
4428+PL/pgSQL function "nested_planner_one_t" line 11 at SQL statement
44494429 QUERY PLAN
44504430 ----------------------------------------
44514431 Merge Join
@@ -4463,17 +4443,9 @@ EXPLAIN (COSTS false)
44634443 ORDER BY t_1.c1;
44644444 NOTICE: nested_planner_one_t(2)
44654445 NOTICE: nested_planner_one_t(1)
4466-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner_one_t($1) FROM s1.t1 t_1 ORDER BY t_1.c1 LIMIT 1"
4467-PL/pgSQL function "nested_planner_one_t" line 11 at EXECUTE statement
4468-LOG: pg_hint_plan:
4469-used hint:
4470-not used hint:
4471-HashJoin(t_1 t_1)
4472-duplication hint:
4473-error hint:
4474-
4475-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner_one_t($1) FROM s1.t1 t_1 ORDER BY t_1.c1 LIMIT 1"
4476-PL/pgSQL function "nested_planner_one_t" line 11 at EXECUTE statement
4446+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4447+ ORDER BY t_1.c1 LIMIT 1"
4448+PL/pgSQL function "nested_planner_one_t" line 11 at SQL statement
44774449 INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
44784450 DETAIL: Relation name "t_1" is duplicated.
44794451 LOG: pg_hint_plan:
@@ -4502,21 +4474,10 @@ EXPLAIN (COSTS false)
45024474 ORDER BY t_1.c1;
45034475 NOTICE: nested_planner(2)
45044476 NOTICE: nested_planner(1)
4505-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4506-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4507-INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
4508-DETAIL: Relation name "t_1" is duplicated.
4509-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4510-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4511-LOG: pg_hint_plan:
4512-used hint:
4513-not used hint:
4514-duplication hint:
4515-error hint:
4516-HashJoin(t_1 t_1)
4517-
4518-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4519-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4477+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4478+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4479+ ORDER BY t_1.c1 LIMIT 1"
4480+PL/pgSQL function "nested_planner" line 12 at SQL statement
45204481 INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
45214482 DETAIL: Relation name "t_1" is duplicated.
45224483 LOG: pg_hint_plan:
@@ -4545,23 +4506,11 @@ EXPLAIN (COSTS false)
45454506 INFO: hint syntax error at or near "MergeJoin(t_1 t_2)HashJoin(t_1 t_2)"
45464507 DETAIL: Conflict join method hint.
45474508 NOTICE: nested_planner(2)
4548-INFO: hint syntax error at or near "MergeJoin(t_1 t_2)HashJoin(t_1 t_2)"
4549-DETAIL: Conflict join method hint.
4550-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4551-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
45524509 NOTICE: nested_planner(1)
4553-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4554-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4555-LOG: pg_hint_plan:
4556-used hint:
4557-HashJoin(t_1 t_2)
4558-not used hint:
4559-duplication hint:
4560-MergeJoin(t_1 t_2)
4561-error hint:
4562-
4563-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4564-PL/pgSQL function "nested_planner" line 12 at EXECUTE statement
4510+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4511+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4512+ ORDER BY t_1.c1 LIMIT 1"
4513+PL/pgSQL function "nested_planner" line 12 at SQL statement
45654514 LOG: pg_hint_plan:
45664515 used hint:
45674516 HashJoin(t_1 t_2)
--- a/expected/ut-A-9.2.out
+++ b/expected/ut-A-9.2.out
@@ -4166,11 +4166,10 @@ BEGIN
41664166 RETURN 0;
41674167 END IF;
41684168
4169- EXECUTE '/*+ IndexScan(t_1) */'
4170- ' SELECT nested_planner($1) FROM s1.t1 t_1'
4171- ' JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)'
4172- ' ORDER BY t_1.c1 LIMIT 1'
4173- INTO new_cnt USING cnt - 1;
4169+ SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) INTO new_cnt
4170+ FROM s1.t1 t_1
4171+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4172+ ORDER BY t_1.c1 LIMIT 1;
41744173
41754174 RETURN new_cnt;
41764175 END;
@@ -4233,8 +4232,21 @@ error hint:
42334232 EXPLAIN (COSTS false) SELECT nested_planner(2) FROM s1.t1 t_1 ORDER BY t_1.c1;
42344233 NOTICE: nested_planner(2)
42354234 NOTICE: nested_planner(1)
4236-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4237-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4235+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4236+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4237+ ORDER BY t_1.c1 LIMIT 1"
4238+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4239+LOG: pg_hint_plan:
4240+used hint:
4241+IndexScan(t_1)
4242+not used hint:
4243+duplication hint:
4244+error hint:
4245+
4246+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4247+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4248+ ORDER BY t_1.c1 LIMIT 1"
4249+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42384250 QUERY PLAN
42394251 ---------------------------------------
42404252 Index Only Scan using t1_i1 on t1 t_1
@@ -4244,17 +4256,21 @@ PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
42444256 EXPLAIN (COSTS false) SELECT nested_planner(2) FROM s1.t1 t_1 ORDER BY t_1.c1;
42454257 NOTICE: nested_planner(2)
42464258 NOTICE: nested_planner(1)
4247-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4248-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4259+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4260+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4261+ ORDER BY t_1.c1 LIMIT 1"
4262+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42494263 LOG: pg_hint_plan:
42504264 used hint:
4251-SeqScan(t_2)
4265+IndexScan(t_1)
42524266 not used hint:
42534267 duplication hint:
42544268 error hint:
42554269
4256-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4257-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4270+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4271+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4272+ ORDER BY t_1.c1 LIMIT 1"
4273+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42584274 LOG: pg_hint_plan:
42594275 used hint:
42604276 not used hint:
@@ -4271,29 +4287,117 @@ error hint:
42714287 EXPLAIN (COSTS false) SELECT nested_planner(5) FROM s1.t1 t_1 ORDER BY t_1.c1;
42724288 NOTICE: nested_planner(5)
42734289 NOTICE: nested_planner(4)
4274-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4275-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4290+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4291+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4292+ ORDER BY t_1.c1 LIMIT 1"
4293+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42764294 NOTICE: nested_planner(3)
4277-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4278-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4279-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4280-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4295+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4296+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4297+ ORDER BY t_1.c1 LIMIT 1"
4298+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4299+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4300+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4301+ ORDER BY t_1.c1 LIMIT 1"
4302+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42814303 NOTICE: nested_planner(2)
4282-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4283-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4284-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4285-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4286-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4287-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4304+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4305+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4306+ ORDER BY t_1.c1 LIMIT 1"
4307+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4308+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4309+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4310+ ORDER BY t_1.c1 LIMIT 1"
4311+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4312+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4313+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4314+ ORDER BY t_1.c1 LIMIT 1"
4315+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42884316 NOTICE: nested_planner(1)
4289-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4290-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4291-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4292-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4293-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4294-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4295-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4296-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4317+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4318+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4319+ ORDER BY t_1.c1 LIMIT 1"
4320+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4321+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4322+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4323+ ORDER BY t_1.c1 LIMIT 1"
4324+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4325+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4326+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4327+ ORDER BY t_1.c1 LIMIT 1"
4328+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4329+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4330+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4331+ ORDER BY t_1.c1 LIMIT 1"
4332+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4333+LOG: pg_hint_plan:
4334+used hint:
4335+IndexScan(t_1)
4336+not used hint:
4337+duplication hint:
4338+error hint:
4339+
4340+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4341+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4342+ ORDER BY t_1.c1 LIMIT 1"
4343+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4344+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4345+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4346+ ORDER BY t_1.c1 LIMIT 1"
4347+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4348+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4349+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4350+ ORDER BY t_1.c1 LIMIT 1"
4351+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4352+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4353+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4354+ ORDER BY t_1.c1 LIMIT 1"
4355+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4356+LOG: pg_hint_plan:
4357+used hint:
4358+IndexScan(t_1)
4359+not used hint:
4360+duplication hint:
4361+error hint:
4362+
4363+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4364+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4365+ ORDER BY t_1.c1 LIMIT 1"
4366+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4367+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4368+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4369+ ORDER BY t_1.c1 LIMIT 1"
4370+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4371+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4372+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4373+ ORDER BY t_1.c1 LIMIT 1"
4374+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4375+LOG: pg_hint_plan:
4376+used hint:
4377+IndexScan(t_1)
4378+not used hint:
4379+duplication hint:
4380+error hint:
4381+
4382+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4383+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4384+ ORDER BY t_1.c1 LIMIT 1"
4385+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4386+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4387+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4388+ ORDER BY t_1.c1 LIMIT 1"
4389+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4390+LOG: pg_hint_plan:
4391+used hint:
4392+IndexScan(t_1)
4393+not used hint:
4394+duplication hint:
4395+error hint:
4396+
4397+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4398+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4399+ ORDER BY t_1.c1 LIMIT 1"
4400+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
42974401 QUERY PLAN
42984402 ---------------------------------------
42994403 Index Only Scan using t1_i1 on t1 t_1
@@ -4302,78 +4406,129 @@ PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
43024406 /*+SeqScan(t_2)*/
43034407 EXPLAIN (COSTS false) SELECT nested_planner(5) FROM s1.t1 t_1 ORDER BY t_1.c1;
43044408 NOTICE: nested_planner(5)
4409+LOG: pg_hint_plan:
4410+used hint:
4411+IndexScan(t_1)
4412+not used hint:
4413+duplication hint:
4414+error hint:
4415+
4416+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4417+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4418+ ORDER BY t_1.c1 LIMIT 1"
4419+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43054420 NOTICE: nested_planner(4)
4306-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4307-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4421+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4422+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4423+ ORDER BY t_1.c1 LIMIT 1"
4424+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43084425 NOTICE: nested_planner(3)
4309-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4310-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4311-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4312-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4426+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4427+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4428+ ORDER BY t_1.c1 LIMIT 1"
4429+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4430+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4431+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4432+ ORDER BY t_1.c1 LIMIT 1"
4433+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43134434 NOTICE: nested_planner(2)
4314-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4315-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4316-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4317-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4318-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4319-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4435+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4436+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4437+ ORDER BY t_1.c1 LIMIT 1"
4438+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4439+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4440+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4441+ ORDER BY t_1.c1 LIMIT 1"
4442+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4443+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4444+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4445+ ORDER BY t_1.c1 LIMIT 1"
4446+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43204447 NOTICE: nested_planner(1)
4321-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4322-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4323-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4324-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4325-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4326-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4327-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4328-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4448+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4449+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4450+ ORDER BY t_1.c1 LIMIT 1"
4451+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4452+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4453+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4454+ ORDER BY t_1.c1 LIMIT 1"
4455+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4456+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4457+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4458+ ORDER BY t_1.c1 LIMIT 1"
4459+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4460+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4461+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4462+ ORDER BY t_1.c1 LIMIT 1"
4463+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43294464 LOG: pg_hint_plan:
43304465 used hint:
4331-SeqScan(t_2)
4466+IndexScan(t_1)
43324467 not used hint:
43334468 duplication hint:
43344469 error hint:
43354470
4336-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4337-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4338-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4339-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4340-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4341-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4342-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4343-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4471+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4472+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4473+ ORDER BY t_1.c1 LIMIT 1"
4474+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4475+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4476+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4477+ ORDER BY t_1.c1 LIMIT 1"
4478+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4479+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4480+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4481+ ORDER BY t_1.c1 LIMIT 1"
4482+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4483+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4484+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4485+ ORDER BY t_1.c1 LIMIT 1"
4486+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43444487 LOG: pg_hint_plan:
43454488 used hint:
4346-SeqScan(t_2)
4489+IndexScan(t_1)
43474490 not used hint:
43484491 duplication hint:
43494492 error hint:
43504493
4351-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4352-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4353-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4354-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4355-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4356-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4494+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4495+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4496+ ORDER BY t_1.c1 LIMIT 1"
4497+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4498+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4499+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4500+ ORDER BY t_1.c1 LIMIT 1"
4501+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4502+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4503+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4504+ ORDER BY t_1.c1 LIMIT 1"
4505+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43574506 LOG: pg_hint_plan:
43584507 used hint:
4359-SeqScan(t_2)
4508+IndexScan(t_1)
43604509 not used hint:
43614510 duplication hint:
43624511 error hint:
43634512
4364-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4365-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4366-SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4367-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4513+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4514+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4515+ ORDER BY t_1.c1 LIMIT 1"
4516+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
4517+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4518+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4519+ ORDER BY t_1.c1 LIMIT 1"
4520+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43684521 LOG: pg_hint_plan:
43694522 used hint:
4370-SeqScan(t_2)
4523+IndexScan(t_1)
43714524 not used hint:
43724525 duplication hint:
43734526 error hint:
43744527
4375-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4376-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4528+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4529+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4530+ ORDER BY t_1.c1 LIMIT 1"
4531+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
43774532 LOG: pg_hint_plan:
43784533 used hint:
43794534 not used hint:
@@ -4397,17 +4552,21 @@ EXPLAIN (COSTS false)
43974552 ORDER BY t_1.c1;
43984553 NOTICE: nested_planner(2)
43994554 NOTICE: nested_planner(1)
4400-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4401-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4555+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4556+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4557+ ORDER BY t_1.c1 LIMIT 1"
4558+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
44024559 LOG: pg_hint_plan:
44034560 used hint:
4404-HashJoin(t_1 t_2)
4561+IndexScan(t_1)
44054562 not used hint:
44064563 duplication hint:
44074564 error hint:
44084565
4409-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4410-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4566+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4567+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4568+ ORDER BY t_1.c1 LIMIT 1"
4569+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
44114570 LOG: pg_hint_plan:
44124571 used hint:
44134572 HashJoin(t_1 t_2)
@@ -4434,17 +4593,21 @@ EXPLAIN (COSTS false)
44344593 ORDER BY st_1.c1;
44354594 NOTICE: nested_planner(2)
44364595 NOTICE: nested_planner(1)
4437-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4438-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4596+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4597+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4598+ ORDER BY t_1.c1 LIMIT 1"
4599+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
44394600 LOG: pg_hint_plan:
44404601 used hint:
4602+IndexScan(t_1)
44414603 not used hint:
4442-HashJoin(st_1 st_2)
44434604 duplication hint:
44444605 error hint:
44454606
4446-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4447-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4607+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4608+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4609+ ORDER BY t_1.c1 LIMIT 1"
4610+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
44484611 LOG: pg_hint_plan:
44494612 used hint:
44504613 HashJoin(st_1 st_2)
@@ -4471,17 +4634,21 @@ EXPLAIN (COSTS false)
44714634 ORDER BY st_1.c1;
44724635 NOTICE: nested_planner(2)
44734636 NOTICE: nested_planner(1)
4474-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4475-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4637+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4638+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4639+ ORDER BY t_1.c1 LIMIT 1"
4640+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
44764641 LOG: pg_hint_plan:
44774642 used hint:
4478-HashJoin(t_1 t_2)
4643+IndexScan(t_1)
44794644 not used hint:
44804645 duplication hint:
44814646 error hint:
44824647
4483-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4484-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4648+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4649+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4650+ ORDER BY t_1.c1 LIMIT 1"
4651+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
44854652 LOG: pg_hint_plan:
44864653 used hint:
44874654 not used hint:
@@ -4507,17 +4674,21 @@ EXPLAIN (COSTS false)
45074674 ORDER BY t_1.c1;
45084675 NOTICE: nested_planner(2)
45094676 NOTICE: nested_planner(1)
4510-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4511-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4677+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4678+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4679+ ORDER BY t_1.c1 LIMIT 1"
4680+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
45124681 LOG: pg_hint_plan:
45134682 used hint:
4683+IndexScan(t_1)
45144684 not used hint:
4515-HashJoin(st_1 st_2)
45164685 duplication hint:
45174686 error hint:
45184687
4519-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4520-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4688+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4689+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4690+ ORDER BY t_1.c1 LIMIT 1"
4691+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
45214692 LOG: pg_hint_plan:
45224693 used hint:
45234694 not used hint:
@@ -4542,21 +4713,21 @@ EXPLAIN (COSTS false)
45424713 ORDER BY t_1.c1;
45434714 NOTICE: nested_planner(2)
45444715 NOTICE: nested_planner(1)
4545-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4546-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4547-INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
4548-DETAIL: Relation name "t_1" is duplicated.
4549-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4550-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4716+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4717+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4718+ ORDER BY t_1.c1 LIMIT 1"
4719+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
45514720 LOG: pg_hint_plan:
45524721 used hint:
4722+IndexScan(t_1)
45534723 not used hint:
45544724 duplication hint:
45554725 error hint:
4556-HashJoin(t_1 t_1)
45574726
4558-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4559-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4727+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4728+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4729+ ORDER BY t_1.c1 LIMIT 1"
4730+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
45604731 LOG: pg_hint_plan:
45614732 used hint:
45624733 not used hint:
@@ -4580,10 +4751,9 @@ BEGIN
45804751 RETURN 0;
45814752 END IF;
45824753
4583- EXECUTE '/*+ IndexScan(t_1) */'
4584- ' SELECT nested_planner_one_t($1) FROM s1.t1 t_1'
4585- ' ORDER BY t_1.c1 LIMIT 1'
4586- INTO new_cnt USING cnt - 1;
4754+ SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) INTO new_cnt
4755+ FROM s1.t1 t_1
4756+ ORDER BY t_1.c1 LIMIT 1;
45874757
45884758 RETURN new_cnt;
45894759 END;
@@ -4594,8 +4764,30 @@ EXPLAIN (COSTS false)
45944764 ORDER BY t_1.c1;
45954765 NOTICE: nested_planner_one_t(2)
45964766 NOTICE: nested_planner_one_t(1)
4597-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner_one_t($1) FROM s1.t1 t_1 ORDER BY t_1.c1 LIMIT 1"
4598-PL/pgSQL function nested_planner_one_t(integer) line 11 at EXECUTE statement
4767+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4768+ ORDER BY t_1.c1 LIMIT 1"
4769+PL/pgSQL function nested_planner_one_t(integer) line 11 at SQL statement
4770+LOG: pg_hint_plan:
4771+used hint:
4772+not used hint:
4773+IndexScan(t_1)
4774+duplication hint:
4775+error hint:
4776+
4777+CONTEXT: PL/pgSQL function nested_planner_one_t(integer) line 8 at RETURN
4778+SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4779+ ORDER BY t_1.c1 LIMIT 1"
4780+PL/pgSQL function nested_planner_one_t(integer) line 11 at SQL statement
4781+LOG: pg_hint_plan:
4782+used hint:
4783+IndexScan(t_1)
4784+not used hint:
4785+duplication hint:
4786+error hint:
4787+
4788+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4789+ ORDER BY t_1.c1 LIMIT 1"
4790+PL/pgSQL function nested_planner_one_t(integer) line 11 at SQL statement
45994791 QUERY PLAN
46004792 ---------------------------------------------
46014793 Merge Join
@@ -4613,17 +4805,19 @@ EXPLAIN (COSTS false)
46134805 ORDER BY t_1.c1;
46144806 NOTICE: nested_planner_one_t(2)
46154807 NOTICE: nested_planner_one_t(1)
4616-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner_one_t($1) FROM s1.t1 t_1 ORDER BY t_1.c1 LIMIT 1"
4617-PL/pgSQL function nested_planner_one_t(integer) line 11 at EXECUTE statement
4808+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4809+ ORDER BY t_1.c1 LIMIT 1"
4810+PL/pgSQL function nested_planner_one_t(integer) line 11 at SQL statement
46184811 LOG: pg_hint_plan:
46194812 used hint:
4813+IndexScan(t_1)
46204814 not used hint:
4621-HashJoin(t_1 t_1)
46224815 duplication hint:
46234816 error hint:
46244817
4625-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner_one_t($1) FROM s1.t1 t_1 ORDER BY t_1.c1 LIMIT 1"
4626-PL/pgSQL function nested_planner_one_t(integer) line 11 at EXECUTE statement
4818+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) FROM s1.t1 t_1
4819+ ORDER BY t_1.c1 LIMIT 1"
4820+PL/pgSQL function nested_planner_one_t(integer) line 11 at SQL statement
46274821 INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
46284822 DETAIL: Relation name "t_1" is duplicated.
46294823 LOG: pg_hint_plan:
@@ -4652,21 +4846,21 @@ EXPLAIN (COSTS false)
46524846 ORDER BY t_1.c1;
46534847 NOTICE: nested_planner(2)
46544848 NOTICE: nested_planner(1)
4655-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4656-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4657-INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
4658-DETAIL: Relation name "t_1" is duplicated.
4659-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4660-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4849+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4850+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4851+ ORDER BY t_1.c1 LIMIT 1"
4852+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
46614853 LOG: pg_hint_plan:
46624854 used hint:
4855+IndexScan(t_1)
46634856 not used hint:
46644857 duplication hint:
46654858 error hint:
4666-HashJoin(t_1 t_1)
46674859
4668-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4669-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4860+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4861+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4862+ ORDER BY t_1.c1 LIMIT 1"
4863+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
46704864 INFO: hint syntax error at or near "HashJoin(t_1 t_1)"
46714865 DETAIL: Relation name "t_1" is duplicated.
46724866 LOG: pg_hint_plan:
@@ -4695,23 +4889,22 @@ EXPLAIN (COSTS false)
46954889 INFO: hint syntax error at or near "MergeJoin(t_1 t_2)HashJoin(t_1 t_2)"
46964890 DETAIL: Conflict join method hint.
46974891 NOTICE: nested_planner(2)
4698-INFO: hint syntax error at or near "MergeJoin(t_1 t_2)HashJoin(t_1 t_2)"
4699-DETAIL: Conflict join method hint.
4700-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4701-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
47024892 NOTICE: nested_planner(1)
4703-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4704-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4893+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4894+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4895+ ORDER BY t_1.c1 LIMIT 1"
4896+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
47054897 LOG: pg_hint_plan:
47064898 used hint:
4707-HashJoin(t_1 t_2)
4899+IndexScan(t_1)
47084900 not used hint:
47094901 duplication hint:
4710-MergeJoin(t_1 t_2)
47114902 error hint:
47124903
4713-CONTEXT: SQL statement "/*+ IndexScan(t_1) */ SELECT nested_planner($1) FROM s1.t1 t_1 JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1) ORDER BY t_1.c1 LIMIT 1"
4714-PL/pgSQL function nested_planner(integer) line 12 at EXECUTE statement
4904+CONTEXT: SQL statement "SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) FROM s1.t1 t_1
4905+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
4906+ ORDER BY t_1.c1 LIMIT 1"
4907+PL/pgSQL function nested_planner(integer) line 12 at SQL statement
47154908 LOG: pg_hint_plan:
47164909 used hint:
47174910 HashJoin(t_1 t_2)
--- a/sql/ut-A.sql
+++ b/sql/ut-A.sql
@@ -1074,11 +1074,10 @@ BEGIN
10741074 RETURN 0;
10751075 END IF;
10761076
1077- EXECUTE '/*+ IndexScan(t_1) */'
1078- ' SELECT nested_planner($1) FROM s1.t1 t_1'
1079- ' JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)'
1080- ' ORDER BY t_1.c1 LIMIT 1'
1081- INTO new_cnt USING cnt - 1;
1077+ SELECT /*+ IndexScan(t_1) */ nested_planner(cnt - 1) INTO new_cnt
1078+ FROM s1.t1 t_1
1079+ JOIN s1.t2 t_2 ON (t_1.c1 = t_2.c1)
1080+ ORDER BY t_1.c1 LIMIT 1;
10821081
10831082 RETURN new_cnt;
10841083 END;
@@ -1161,10 +1160,9 @@ BEGIN
11611160 RETURN 0;
11621161 END IF;
11631162
1164- EXECUTE '/*+ IndexScan(t_1) */'
1165- ' SELECT nested_planner_one_t($1) FROM s1.t1 t_1'
1166- ' ORDER BY t_1.c1 LIMIT 1'
1167- INTO new_cnt USING cnt - 1;
1163+ SELECT /*+ IndexScan(t_1) */ nested_planner_one_t(cnt - 1) INTO new_cnt
1164+ FROM s1.t1 t_1
1165+ ORDER BY t_1.c1 LIMIT 1;
11681166
11691167 RETURN new_cnt;
11701168 END;
Show on old repository browser