• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revision7392b374d10a0526e6d4209685cdc1d6ada36ab7 (tree)
Time2020-10-29 20:31:47
AuthorKyotaro Horiguchi <horikyoga.ntt@gmai...>
CommiterKyotaro Horiguchi

Log Message

Stabilize regression test.

I was annoyed by frequent nonsubstantial change of title line length
of explain output. This commit makes maskout.sh replace the title
lines with fixed content.

Change Summary

Incremental Difference

--- a/expected/pg_hint_plan.out
+++ b/expected/pg_hint_plan.out
@@ -8808,8 +8808,8 @@ Rows()
88088808 EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id);
88098809 \o
88108810 \! sql/maskout.sh results/pg_hint_plan.tmpout
8811- QUERY PLAN
8812-------------------------------------------------------------------------------
8811+ QUERY PLAN
8812+----------------
88138813 Merge Join (cost=xxx..xxx rows=1000 width=xxx)
88148814 Merge Cond: (t1.id = t2.id)
88158815 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8827,8 +8827,8 @@ error hint:
88278827
88288828 \o
88298829 \! sql/maskout.sh results/pg_hint_plan.tmpout
8830- QUERY PLAN
8831-------------------------------------------------------------------------------
8830+ QUERY PLAN
8831+----------------
88328832 Merge Join (cost=xxx..xxx rows=99 width=xxx)
88338833 Merge Cond: (t1.id = t2.id)
88348834 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8846,8 +8846,8 @@ error hint:
88468846
88478847 \o
88488848 \! sql/maskout.sh results/pg_hint_plan.tmpout
8849- QUERY PLAN
8850-------------------------------------------------------------------------------
8849+ QUERY PLAN
8850+----------------
88518851 Merge Join (cost=xxx..xxx rows=1099 width=xxx)
88528852 Merge Cond: (t1.id = t2.id)
88538853 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8865,8 +8865,8 @@ error hint:
88658865
88668866 \o
88678867 \! sql/maskout.sh results/pg_hint_plan.tmpout
8868- QUERY PLAN
8869-------------------------------------------------------------------------------
8868+ QUERY PLAN
8869+----------------
88708870 Merge Join (cost=xxx..xxx rows=901 width=xxx)
88718871 Merge Cond: (t1.id = t2.id)
88728872 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8884,8 +8884,8 @@ error hint:
88848884
88858885 \o
88868886 \! sql/maskout.sh results/pg_hint_plan.tmpout
8887- QUERY PLAN
8888-------------------------------------------------------------------------------
8887+ QUERY PLAN
8888+----------------
88898889 Merge Join (cost=xxx..xxx rows=99000 width=xxx)
88908890 Merge Cond: (t1.id = t2.id)
88918891 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8903,8 +8903,8 @@ error hint:
89038903
89048904 \o
89058905 \! sql/maskout.sh results/pg_hint_plan.tmpout
8906- QUERY PLAN
8907-------------------------------------------------------------------------------
8906+ QUERY PLAN
8907+----------------
89088908 Merge Join (cost=xxx..xxx rows=10 width=xxx)
89098909 Merge Cond: (t1.id = t2.id)
89108910 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8924,8 +8924,8 @@ Rows(t1 t2 #aa)
89248924
89258925 \o
89268926 \! sql/maskout.sh results/pg_hint_plan.tmpout
8927- QUERY PLAN
8928-------------------------------------------------------------------------------
8927+ QUERY PLAN
8928+----------------
89298929 Merge Join (cost=xxx..xxx rows=1000 width=xxx)
89308930 Merge Cond: (t1.id = t2.id)
89318931 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8945,8 +8945,8 @@ Rows(t1 t2 /99)
89458945
89468946 \o
89478947 \! sql/maskout.sh results/pg_hint_plan.tmpout
8948- QUERY PLAN
8949-------------------------------------------------------------------------------
8948+ QUERY PLAN
8949+----------------
89508950 Merge Join (cost=xxx..xxx rows=1000 width=xxx)
89518951 Merge Cond: (t1.id = t2.id)
89528952 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8966,8 +8966,8 @@ error hint:
89668966
89678967 \o
89688968 \! sql/maskout.sh results/pg_hint_plan.tmpout
8969- QUERY PLAN
8970-------------------------------------------------------------------------------
8969+ QUERY PLAN
8970+----------------
89718971 Merge Join (cost=xxx..xxx rows=1 width=xxx)
89728972 Merge Cond: (t1.id = t2.id)
89738973 -> Index Scan using t1_pkey on t1 (cost=xxx..xxx rows=10000 width=xxx)
@@ -8978,8 +8978,8 @@ error hint:
89788978 EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id) JOIN t3 ON (t3.id = t2.id);
89798979 \o
89808980 \! sql/maskout.sh results/pg_hint_plan.tmpout
8981- QUERY PLAN
8982-------------------------------------------------------------------------------------
8981+ QUERY PLAN
8982+----------------
89838983 Merge Join (cost=xxx..xxx rows=10 width=xxx)
89848984 Merge Cond: (t1.id = t3.id)
89858985 -> Merge Join (cost=xxx..xxx rows=1000 width=xxx)
@@ -9002,8 +9002,8 @@ error hint:
90029002
90039003 \o
90049004 \! sql/maskout.sh results/pg_hint_plan.tmpout
9005- QUERY PLAN
9006-------------------------------------------------------------------------------------
9005+ QUERY PLAN
9006+----------------
90079007 Merge Join (cost=xxx..xxx rows=1 width=xxx)
90089008 Merge Cond: (t1.id = t3.id)
90099009 -> Merge Join (cost=xxx..xxx rows=22 width=xxx)
@@ -9027,8 +9027,8 @@ error hint:
90279027 \o
90289028 set max_parallel_workers_per_gather to DEFAULT;
90299029 \! sql/maskout.sh results/pg_hint_plan.tmpout
9030- QUERY PLAN
9031-------------------------------------------------------------------------------------
9030+ QUERY PLAN
9031+----------------
90329032 Merge Join (cost=xxx..xxx rows=100 width=xxx)
90339033 Merge Cond: (t1.id = t3.id)
90349034 -> Merge Join (cost=xxx..xxx rows=1000 width=xxx)
--- a/expected/ut-J.out
+++ b/expected/ut-J.out
@@ -791,8 +791,8 @@ error hint:
791791
792792 \o
793793 \! sql/maskout.sh results/ut-J.tmpout
794- QUERY PLAN
795----------------------------------------------------------------------------------------------
794+ QUERY PLAN
795+----------------
796796 Nested Loop (cost={inf}..{inf} rows=1 width=xxx)
797797 InitPlan 1 (returns $1)
798798 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -4708,8 +4708,8 @@ error hint:
47084708
47094709 \o
47104710 \! sql/maskout.sh results/ut-J.tmpout
4711- QUERY PLAN
4712--------------------------------------------------------------------------------
4711+ QUERY PLAN
4712+----------------
47134713 Hash Full Join (cost={inf}..{inf} rows=1000 width=xxx)
47144714 Hash Cond: (t1.c1 = t2.c1)
47154715 -> Seq Scan on t1 (cost=xxx..xxx rows=1000 width=xxx)
--- a/expected/ut-R.out
+++ b/expected/ut-R.out
@@ -7,8 +7,8 @@ SET search_path TO public;
77 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
88 \o
99 \! sql/maskout.sh results/ut-R.tmpout
10- QUERY PLAN
11----------------------------------------------------------------------------
10+ QUERY PLAN
11+----------------
1212 Merge Join (cost=xxx..xxx rows=100 width=xxx)
1313 Merge Cond: (t1.c1 = t2.c1)
1414 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -32,8 +32,8 @@ error hint:
3232
3333 \o
3434 \! sql/maskout.sh results/ut-R.tmpout
35- QUERY PLAN
36----------------------------------------------------------------------------
35+ QUERY PLAN
36+----------------
3737 Merge Join (cost=xxx..xxx rows=1 width=xxx)
3838 Merge Cond: (t1.c1 = t2.c1)
3939 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -54,8 +54,8 @@ error hint:
5454
5555 \o
5656 \! sql/maskout.sh results/ut-R.tmpout
57- QUERY PLAN
58--------------------------------------------------------------------------------
57+ QUERY PLAN
58+----------------
5959 Merge Join (cost=xxx..xxx rows=100 width=xxx)
6060 Merge Cond: (t_1.c1 = t_2.c1)
6161 -> Index Scan using t1_i1 on t1 t_1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -76,8 +76,8 @@ error hint:
7676
7777 \o
7878 \! sql/maskout.sh results/ut-R.tmpout
79- QUERY PLAN
80--------------------------------------------------------------------------------
79+ QUERY PLAN
80+----------------
8181 Merge Join (cost=xxx..xxx rows=1 width=xxx)
8282 Merge Cond: (t_1.c1 = t_2.c1)
8383 -> Index Scan using t1_i1 on t1 t_1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -101,8 +101,8 @@ error hint:
101101
102102 \o
103103 \! sql/maskout.sh results/ut-R.tmpout
104- QUERY PLAN
105----------------------------------------------------------------------------
104+ QUERY PLAN
105+----------------
106106 Merge Join (cost=xxx..xxx rows=1 width=xxx)
107107 Merge Cond: (t1.c1 = t2.c1)
108108 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -123,8 +123,8 @@ error hint:
123123
124124 \o
125125 \! sql/maskout.sh results/ut-R.tmpout
126- QUERY PLAN
127----------------------------------------------------------------------------
126+ QUERY PLAN
127+----------------
128128 Merge Join (cost=xxx..xxx rows=100 width=xxx)
129129 Merge Cond: (t1.c1 = t2.c1)
130130 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -148,8 +148,8 @@ error hint:
148148
149149 \o
150150 \! sql/maskout.sh results/ut-R.tmpout
151- QUERY PLAN
152----------------------------------------------------------------------------
151+ QUERY PLAN
152+----------------
153153 Merge Join (cost=xxx..xxx rows=1 width=xxx)
154154 Merge Cond: (t1.c1 = t2.c1)
155155 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -170,8 +170,8 @@ error hint:
170170
171171 \o
172172 \! sql/maskout.sh results/ut-R.tmpout
173- QUERY PLAN
174----------------------------------------------------------------------------
173+ QUERY PLAN
174+----------------
175175 Merge Join (cost=xxx..xxx rows=100 width=xxx)
176176 Merge Cond: (t1.c1 = t2.c1)
177177 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -195,8 +195,8 @@ error hint:
195195
196196 \o
197197 \! sql/maskout.sh results/ut-R.tmpout
198- QUERY PLAN
199----------------------------------------------------------------------------
198+ QUERY PLAN
199+----------------
200200 Merge Join (cost=xxx..xxx rows=1 width=xxx)
201201 Merge Cond: (t1.c1 = t2.c1)
202202 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -209,8 +209,8 @@ error hint:
209209 EXPLAIN SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = s2.t1.c1;
210210 \o
211211 \! sql/maskout.sh results/ut-R.tmpout
212- QUERY PLAN
213----------------------------------------------------------------------------
212+ QUERY PLAN
213+----------------
214214 Merge Join (cost=xxx..xxx rows=100 width=xxx)
215215 Merge Cond: (t1.c1 = t1_1.c1)
216216 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -232,8 +232,8 @@ Rows(t1 t1 #1)
232232
233233 \o
234234 \! sql/maskout.sh results/ut-R.tmpout
235- QUERY PLAN
236----------------------------------------------------------------------------
235+ QUERY PLAN
236+----------------
237237 Merge Join (cost=xxx..xxx rows=100 width=xxx)
238238 Merge Cond: (t1.c1 = t1_1.c1)
239239 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -253,8 +253,8 @@ error hint:
253253
254254 \o
255255 \! sql/maskout.sh results/ut-R.tmpout
256- QUERY PLAN
257----------------------------------------------------------------------------
256+ QUERY PLAN
257+----------------
258258 Merge Join (cost=xxx..xxx rows=100 width=xxx)
259259 Merge Cond: (t1.c1 = t1_1.c1)
260260 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -266,8 +266,8 @@ error hint:
266266 EXPLAIN SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = s2t1.c1;
267267 \o
268268 \! sql/maskout.sh results/ut-R.tmpout
269- QUERY PLAN
270----------------------------------------------------------------------------
269+ QUERY PLAN
270+----------------
271271 Merge Join (cost=xxx..xxx rows=100 width=xxx)
272272 Merge Cond: (t1.c1 = s2t1.c1)
273273 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -287,8 +287,8 @@ error hint:
287287
288288 \o
289289 \! sql/maskout.sh results/ut-R.tmpout
290- QUERY PLAN
291----------------------------------------------------------------------------
290+ QUERY PLAN
291+----------------
292292 Merge Join (cost=xxx..xxx rows=1 width=xxx)
293293 Merge Cond: (t1.c1 = s2t1.c1)
294294 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -301,8 +301,8 @@ error hint:
301301 EXPLAIN SELECT *, (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
302302 \o
303303 \! sql/maskout.sh results/ut-R.tmpout
304- QUERY PLAN
305---------------------------------------------------------------------------------------------------
304+ QUERY PLAN
305+----------------
306306 Merge Join (cost=xxx..xxx rows=100 width=xxx)
307307 Merge Cond: (t1.c1 = t2.c1)
308308 InitPlan 1 (returns $0)
@@ -330,8 +330,8 @@ error hint:
330330
331331 \o
332332 \! sql/maskout.sh results/ut-R.tmpout
333- QUERY PLAN
334---------------------------------------------------------------------------------------------------
333+ QUERY PLAN
334+----------------
335335 Merge Join (cost=xxx..xxx rows=100 width=xxx)
336336 Merge Cond: (t1.c1 = t2.c1)
337337 InitPlan 1 (returns $0)
@@ -360,8 +360,8 @@ error hint:
360360
361361 \o
362362 \! sql/maskout.sh results/ut-R.tmpout
363- QUERY PLAN
364--------------------------------------------------------------------------------------------------
363+ QUERY PLAN
364+----------------
365365 Merge Join (cost=xxx..xxx rows=1 width=xxx)
366366 Merge Cond: (t1.c1 = t2.c1)
367367 InitPlan 1 (returns $0)
@@ -393,8 +393,8 @@ error hint:
393393
394394 \o
395395 \! sql/maskout.sh results/ut-R.tmpout
396- QUERY PLAN
397----------------------------------------------------------------------------
396+ QUERY PLAN
397+----------------
398398 Merge Join (cost=xxx..xxx rows=1 width=xxx)
399399 Merge Cond: (t1.c1 = t2.c1)
400400 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -417,8 +417,8 @@ Rows(t1 t1 #1)
417417
418418 \o
419419 \! sql/maskout.sh results/ut-R.tmpout
420- QUERY PLAN
421----------------------------------------------------------------------------
420+ QUERY PLAN
421+----------------
422422 Merge Join (cost=xxx..xxx rows=100 width=xxx)
423423 Merge Cond: (t1.c1 = t2.c1)
424424 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -434,8 +434,8 @@ INFO: pg_hint_plan: hint syntax error at or near "(t1 t1)(t2 t2)"
434434 DETAIL: Unrecognized hint keyword "".
435435 \o
436436 \! sql/maskout.sh results/ut-R.tmpout
437- QUERY PLAN
438----------------------------------------------------------------------------
437+ QUERY PLAN
438+----------------
439439 Merge Join (cost=xxx..xxx rows=100 width=xxx)
440440 Merge Cond: (t1.c1 = t2.c1)
441441 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -447,8 +447,8 @@ DETAIL: Unrecognized hint keyword "".
447447 EXPLAIN SELECT * FROM s1.t1, s1.t2, s1.t3 WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
448448 \o
449449 \! sql/maskout.sh results/ut-R.tmpout
450- QUERY PLAN
451----------------------------------------------------------------------------------
450+ QUERY PLAN
451+----------------
452452 Merge Join (cost=xxx..xxx rows=100 width=xxx)
453453 Merge Cond: (t1.c1 = t2.c1)
454454 -> Merge Join (cost=xxx..xxx rows=1000 width=xxx)
@@ -466,8 +466,8 @@ INFO: pg_hint_plan: hint syntax error at or near "(t1 t2 t1 t2)"
466466 DETAIL: Unrecognized hint keyword "".
467467 \o
468468 \! sql/maskout.sh results/ut-R.tmpout
469- QUERY PLAN
470----------------------------------------------------------------------------------------
469+ QUERY PLAN
470+----------------
471471 Nested Loop (cost=xxx..xxx rows=100 width=xxx)
472472 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
473473 Merge Cond: (t1.c1 = t2.c1)
@@ -497,8 +497,8 @@ error hint:
497497
498498 \o
499499 \! sql/maskout.sh results/ut-R.tmpout
500- QUERY PLAN
501----------------------------------------------------------------------------
500+ QUERY PLAN
501+----------------
502502 Merge Join (cost=xxx..xxx rows=1 width=xxx)
503503 Merge Cond: (t1.c1 = t2.c1)
504504 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -511,8 +511,8 @@ error hint:
511511 EXPLAIN SELECT * FROM s1.p1 t1, s1.p1 t2 WHERE t1.c1 = t2.c1;
512512 \o
513513 \! sql/maskout.sh results/ut-R.tmpout
514- QUERY PLAN
515-------------------------------------------------------------------------------
514+ QUERY PLAN
515+----------------
516516 Hash Join (cost=xxx..xxx rows=301 width=xxx)
517517 Hash Cond: (t1.c1 = t2.c1)
518518 -> Append (cost=xxx..xxx rows=301 width=xxx)
@@ -539,8 +539,8 @@ error hint:
539539
540540 \o
541541 \! sql/maskout.sh results/ut-R.tmpout
542- QUERY PLAN
543-------------------------------------------------------------------------------
542+ QUERY PLAN
543+----------------
544544 Hash Join (cost=xxx..xxx rows=1 width=xxx)
545545 Hash Cond: (t1.c1 = t2.c1)
546546 -> Append (cost=xxx..xxx rows=301 width=xxx)
@@ -560,8 +560,8 @@ error hint:
560560 EXPLAIN SELECT * FROM s1.ul1 t1, s1.ul1 t2 WHERE t1.c1 = t2.c1;
561561 \o
562562 \! sql/maskout.sh results/ut-R.tmpout
563- QUERY PLAN
564------------------------------------------------------------------------
563+ QUERY PLAN
564+----------------
565565 Hash Join (cost=xxx..xxx rows=1130 width=xxx)
566566 Hash Cond: (t1.c1 = t2.c1)
567567 -> Seq Scan on ul1 t1 (cost=xxx..xxx rows=1130 width=xxx)
@@ -580,8 +580,8 @@ error hint:
580580
581581 \o
582582 \! sql/maskout.sh results/ut-R.tmpout
583- QUERY PLAN
584------------------------------------------------------------------------
583+ QUERY PLAN
584+----------------
585585 Hash Join (cost=xxx..xxx rows=1 width=xxx)
586586 Hash Cond: (t1.c1 = t2.c1)
587587 -> Seq Scan on ul1 t1 (cost=xxx..xxx rows=1130 width=xxx)
@@ -594,8 +594,8 @@ CREATE TEMP TABLE tm1 (LIKE s1.t1 INCLUDING ALL);
594594 EXPLAIN SELECT * FROM tm1 t1, tm1 t2 WHERE t1.c1 = t2.c1;
595595 \o
596596 \! sql/maskout.sh results/ut-R.tmpout
597- QUERY PLAN
598------------------------------------------------------------------------
597+ QUERY PLAN
598+----------------
599599 Hash Join (cost=xxx..xxx rows=1130 width=xxx)
600600 Hash Cond: (t1.c1 = t2.c1)
601601 -> Seq Scan on tm1 t1 (cost=xxx..xxx rows=1130 width=xxx)
@@ -614,8 +614,8 @@ error hint:
614614
615615 \o
616616 \! sql/maskout.sh results/ut-R.tmpout
617- QUERY PLAN
618------------------------------------------------------------------------
617+ QUERY PLAN
618+----------------
619619 Hash Join (cost=xxx..xxx rows=1 width=xxx)
620620 Hash Cond: (t1.c1 = t2.c1)
621621 -> Seq Scan on tm1 t1 (cost=xxx..xxx rows=1130 width=xxx)
@@ -628,8 +628,8 @@ CREATE TEMP TABLE t_pg_class AS SELECT * from pg_class LIMIT 100;
628628 EXPLAIN SELECT * FROM t_pg_class t1, t_pg_class t2 WHERE t1.oid = t2.oid;
629629 \o
630630 \! sql/maskout.sh results/ut-R.tmpout
631- QUERY PLAN
632-------------------------------------------------------------------------------
631+ QUERY PLAN
632+----------------
633633 Hash Join (cost=xxx..xxx rows=450 width=xxx)
634634 Hash Cond: (t1.oid = t2.oid)
635635 -> Seq Scan on t_pg_class t1 (cost=xxx..xxx rows=300 width=xxx)
@@ -648,8 +648,8 @@ error hint:
648648
649649 \o
650650 \! sql/maskout.sh results/ut-R.tmpout
651- QUERY PLAN
652-------------------------------------------------------------------------------
651+ QUERY PLAN
652+----------------
653653 Hash Join (cost=xxx..xxx rows=1 width=xxx)
654654 Hash Cond: (t1.oid = t2.oid)
655655 -> Seq Scan on t_pg_class t1 (cost=xxx..xxx rows=300 width=xxx)
@@ -663,8 +663,8 @@ error hint:
663663 EXPLAIN SELECT * FROM s1.f1() t1, s1.f1() t2 WHERE t1.c1 = t2.c1;
664664 \o
665665 \! sql/maskout.sh results/ut-R.tmpout
666- QUERY PLAN
667------------------------------------------------------------------
666+ QUERY PLAN
667+----------------
668668 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
669669 Join Filter: (t1.c1 = t2.c1)
670670 -> Function Scan on f1 t1 (cost=xxx..xxx rows=1 width=xxx)
@@ -682,8 +682,8 @@ error hint:
682682
683683 \o
684684 \! sql/maskout.sh results/ut-R.tmpout
685- QUERY PLAN
686------------------------------------------------------------------
685+ QUERY PLAN
686+----------------
687687 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
688688 Join Filter: (t1.c1 = t2.c1)
689689 -> Function Scan on f1 t1 (cost=xxx..xxx rows=1 width=xxx)
@@ -694,8 +694,8 @@ error hint:
694694 EXPLAIN SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS t1 (c1, c2, c3, c4), s1.t2 WHERE t1.c1 = t2.c1;
695695 \o
696696 \! sql/maskout.sh results/ut-R.tmpout
697- QUERY PLAN
698---------------------------------------------------------------------------
697+ QUERY PLAN
698+----------------
699699 Hash Join (cost=xxx..xxx rows=3 width=xxx)
700700 Hash Cond: (t2.c1 = "*VALUES*".column1)
701701 -> Seq Scan on t2 (cost=xxx..xxx rows=100 width=xxx)
@@ -714,8 +714,8 @@ error hint:
714714
715715 \o
716716 \! sql/maskout.sh results/ut-R.tmpout
717- QUERY PLAN
718---------------------------------------------------------------------------
717+ QUERY PLAN
718+----------------
719719 Hash Join (cost=xxx..xxx rows=3 width=xxx)
720720 Hash Cond: (t2.c1 = "*VALUES*".column1)
721721 -> Seq Scan on t2 (cost=xxx..xxx rows=100 width=xxx)
@@ -734,8 +734,8 @@ error hint:
734734
735735 \o
736736 \! sql/maskout.sh results/ut-R.tmpout
737- QUERY PLAN
738---------------------------------------------------------------------------
737+ QUERY PLAN
738+----------------
739739 Hash Join (cost=xxx..xxx rows=1 width=xxx)
740740 Hash Cond: (t2.c1 = "*VALUES*".column1)
741741 -> Seq Scan on t2 (cost=xxx..xxx rows=100 width=xxx)
@@ -747,8 +747,8 @@ error hint:
747747 EXPLAIN WITH c1(c1) AS (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) SELECT * FROM s1.t1, c1 WHERE t1.c1 = c1.c1;
748748 \o
749749 \! sql/maskout.sh results/ut-R.tmpout
750- QUERY PLAN
751-------------------------------------------------------------------------------------------------
750+ QUERY PLAN
751+----------------
752752 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
753753 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
754754 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
@@ -773,8 +773,8 @@ error hint:
773773
774774 \o
775775 \! sql/maskout.sh results/ut-R.tmpout
776- QUERY PLAN
777-------------------------------------------------------------------------------------------------
776+ QUERY PLAN
777+----------------
778778 Nested Loop (cost=xxx..xxx rows=2 width=xxx)
779779 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
780780 -> Merge Join (cost=xxx..xxx rows=1 width=xxx)
@@ -791,8 +791,8 @@ error hint:
791791 EXPLAIN SELECT * FROM s1.v1 t1, s1.v1 t2 WHERE t1.c1 = t2.c1;
792792 \o
793793 \! sql/maskout.sh results/ut-R.tmpout
794- QUERY PLAN
795---------------------------------------------------------------------------
794+ QUERY PLAN
795+----------------
796796 Hash Join (cost=xxx..xxx rows=1000 width=xxx)
797797 Hash Cond: (v1t1.c1 = v1t1_1.c1)
798798 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -811,8 +811,8 @@ error hint:
811811
812812 \o
813813 \! sql/maskout.sh results/ut-R.tmpout
814- QUERY PLAN
815---------------------------------------------------------------------------
814+ QUERY PLAN
815+----------------
816816 Hash Join (cost=xxx..xxx rows=1000 width=xxx)
817817 Hash Cond: (v1t1.c1 = v1t1_1.c1)
818818 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -831,8 +831,8 @@ error hint:
831831
832832 \o
833833 \! sql/maskout.sh results/ut-R.tmpout
834- QUERY PLAN
835--------------------------------------------------------------------------
834+ QUERY PLAN
835+----------------
836836 Hash Join (cost=xxx..xxx rows=1 width=xxx)
837837 Hash Cond: (v1t1.c1 = v1t1_.c1)
838838 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -844,8 +844,8 @@ error hint:
844844 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.c1 = (SELECT max(st1.c1) FROM s1.t1 st1, s1.t2 st2 WHERE st1.c1 = st2.c1);
845845 \o
846846 \! sql/maskout.sh results/ut-R.tmpout
847- QUERY PLAN
848--------------------------------------------------------------------------------------------------
847+ QUERY PLAN
848+----------------
849849 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
850850 InitPlan 1 (returns $0)
851851 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -873,8 +873,8 @@ error hint:
873873
874874 \o
875875 \! sql/maskout.sh results/ut-R.tmpout
876- QUERY PLAN
877--------------------------------------------------------------------------------------------------
876+ QUERY PLAN
877+----------------
878878 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
879879 InitPlan 1 (returns $0)
880880 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -897,8 +897,8 @@ error hint:
897897 EXPLAIN SELECT * FROM s1.t1, (SELECT t2.c1 FROM s1.t2) st2 WHERE t1.c1 = st2.c1;
898898 \o
899899 \! sql/maskout.sh results/ut-R.tmpout
900- QUERY PLAN
901----------------------------------------------------------------------------
900+ QUERY PLAN
901+----------------
902902 Merge Join (cost=xxx..xxx rows=100 width=xxx)
903903 Merge Cond: (t1.c1 = t2.c1)
904904 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -918,8 +918,8 @@ error hint:
918918
919919 \o
920920 \! sql/maskout.sh results/ut-R.tmpout
921- QUERY PLAN
922----------------------------------------------------------------------------
921+ QUERY PLAN
922+----------------
923923 Merge Join (cost=xxx..xxx rows=100 width=xxx)
924924 Merge Cond: (t1.c1 = t2.c1)
925925 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -939,8 +939,8 @@ error hint:
939939
940940 \o
941941 \! sql/maskout.sh results/ut-R.tmpout
942- QUERY PLAN
943----------------------------------------------------------------------------
942+ QUERY PLAN
943+----------------
944944 Merge Join (cost=xxx..xxx rows=1 width=xxx)
945945 Merge Cond: (t1.c1 = t2.c1)
946946 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -966,8 +966,8 @@ Rows(t1 #1)
966966
967967 \o
968968 \! sql/maskout.sh results/ut-R.tmpout
969- QUERY PLAN
970----------------------------------------------------------------------------
969+ QUERY PLAN
970+----------------
971971 Merge Join (cost=xxx..xxx rows=100 width=xxx)
972972 Merge Cond: (t1.c1 = t2.c1)
973973 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -990,8 +990,8 @@ Rows(t1 t2 1)
990990
991991 \o
992992 \! sql/maskout.sh results/ut-R.tmpout
993- QUERY PLAN
994----------------------------------------------------------------------------
993+ QUERY PLAN
994+----------------
995995 Merge Join (cost=xxx..xxx rows=100 width=xxx)
996996 Merge Cond: (t1.c1 = t2.c1)
997997 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -1014,8 +1014,8 @@ Rows(t1 t2 #notrows)
10141014
10151015 \o
10161016 \! sql/maskout.sh results/ut-R.tmpout
1017- QUERY PLAN
1018----------------------------------------------------------------------------
1017+ QUERY PLAN
1018+----------------
10191019 Merge Join (cost=xxx..xxx rows=100 width=xxx)
10201020 Merge Cond: (t1.c1 = t2.c1)
10211021 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -1064,8 +1064,8 @@ error hint:
10641064
10651065 \o
10661066 \! sql/maskout.sh results/ut-R.tmpout
1067- QUERY PLAN
1068---------------------------------------------------------------------------------------------------------------------
1067+ QUERY PLAN
1068+----------------
10691069 Aggregate (cost=xxx..xxx rows=1 width=xxx)
10701070 InitPlan 1 (returns $1)
10711071 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1158,8 +1158,8 @@ error hint:
11581158
11591159 \o
11601160 \! sql/maskout.sh results/ut-R.tmpout
1161- QUERY PLAN
1162---------------------------------------------------------------------------------------------------------------------
1161+ QUERY PLAN
1162+----------------
11631163 Aggregate (cost=xxx..xxx rows=1 width=xxx)
11641164 InitPlan 1 (returns $1)
11651165 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1250,8 +1250,8 @@ error hint:
12501250
12511251 \o
12521252 \! sql/maskout.sh results/ut-R.tmpout
1253- QUERY PLAN
1254---------------------------------------------------------------------------------------------------------------------
1253+ QUERY PLAN
1254+----------------
12551255 Aggregate (cost=xxx..xxx rows=1 width=xxx)
12561256 InitPlan 1 (returns $1)
12571257 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1370,8 +1370,8 @@ error hint:
13701370
13711371 \o
13721372 \! sql/maskout.sh results/ut-R.tmpout
1373- QUERY PLAN
1374---------------------------------------------------------------------------------------------------------------------
1373+ QUERY PLAN
1374+----------------
13751375 Aggregate (cost=xxx..xxx rows=1 width=xxx)
13761376 InitPlan 1 (returns $1)
13771377 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1444,8 +1444,8 @@ error hint:
14441444
14451445 \o
14461446 \! sql/maskout.sh results/ut-R.tmpout
1447- QUERY PLAN
1448------------------------------------------------------------------------------------------------
1447+ QUERY PLAN
1448+----------------
14491449 Aggregate (cost=xxx..xxx rows=1 width=xxx)
14501450 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
14511451 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -1480,8 +1480,8 @@ error hint:
14801480
14811481 \o
14821482 \! sql/maskout.sh results/ut-R.tmpout
1483- QUERY PLAN
1484---------------------------------------------------------------------------------------------
1483+ QUERY PLAN
1484+----------------
14851485 Aggregate (cost=xxx..xxx rows=1 width=xxx)
14861486 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
14871487 Join Filter: (bmt2.c1 = bmt1.c1)
@@ -1511,8 +1511,8 @@ error hint:
15111511
15121512 \o
15131513 \! sql/maskout.sh results/ut-R.tmpout
1514- QUERY PLAN
1515------------------------------------------------------------------------------------------------
1514+ QUERY PLAN
1515+----------------
15161516 Aggregate (cost=xxx..xxx rows=1 width=xxx)
15171517 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
15181518 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -1547,8 +1547,8 @@ error hint:
15471547
15481548 \o
15491549 \! sql/maskout.sh results/ut-R.tmpout
1550- QUERY PLAN
1551---------------------------------------------------------------------------------------------
1550+ QUERY PLAN
1551+----------------
15521552 Aggregate (cost=xxx..xxx rows=1 width=xxx)
15531553 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
15541554 Join Filter: (bmt2.c1 = bmt1.c1)
@@ -1600,8 +1600,8 @@ error hint:
16001600
16011601 \o
16021602 \! sql/maskout.sh results/ut-R.tmpout
1603- QUERY PLAN
1604---------------------------------------------------------------------------------------------------------------------
1603+ QUERY PLAN
1604+----------------
16051605 Aggregate (cost=xxx..xxx rows=1 width=xxx)
16061606 InitPlan 1 (returns $1)
16071607 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1696,8 +1696,8 @@ error hint:
16961696
16971697 \o
16981698 \! sql/maskout.sh results/ut-R.tmpout
1699- QUERY PLAN
1700---------------------------------------------------------------------------------------------------------------------
1699+ QUERY PLAN
1700+----------------
17011701 Aggregate (cost=xxx..xxx rows=1 width=xxx)
17021702 InitPlan 1 (returns $1)
17031703 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1789,8 +1789,8 @@ error hint:
17891789
17901790 \o
17911791 \! sql/maskout.sh results/ut-R.tmpout
1792- QUERY PLAN
1793---------------------------------------------------------------------------------------------------------------------
1792+ QUERY PLAN
1793+----------------
17941794 Aggregate (cost=xxx..xxx rows=1 width=xxx)
17951795 InitPlan 1 (returns $1)
17961796 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -1910,8 +1910,8 @@ error hint:
19101910
19111911 \o
19121912 \! sql/maskout.sh results/ut-R.tmpout
1913- QUERY PLAN
1914---------------------------------------------------------------------------------------------------------------------
1913+ QUERY PLAN
1914+----------------
19151915 Aggregate (cost=xxx..xxx rows=1 width=xxx)
19161916 InitPlan 1 (returns $1)
19171917 -> Aggregate (cost=xxx..xxx rows=1 width=xxx)
@@ -2015,8 +2015,8 @@ error hint:
20152015
20162016 \o
20172017 \! sql/maskout.sh results/ut-R.tmpout
2018- QUERY PLAN
2019-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2018+ QUERY PLAN
2019+----------------
20202020 Aggregate (cost=xxx..xxx rows=1 width=xxx)
20212021 -> Hash Join (cost=xxx..xxx rows=1 width=xxx)
20222022 Hash Cond: (bmt4.c1 = bmt1.c1)
@@ -2125,8 +2125,8 @@ error hint:
21252125
21262126 \o
21272127 \! sql/maskout.sh results/ut-R.tmpout
2128- QUERY PLAN
2129-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2128+ QUERY PLAN
2129+----------------
21302130 Aggregate (cost=xxx..xxx rows=1 width=xxx)
21312131 -> Hash Join (cost=xxx..xxx rows=1 width=xxx)
21322132 Hash Cond: (bmt4.c1 = bmt1.c1)
@@ -2233,8 +2233,8 @@ error hint:
22332233
22342234 \o
22352235 \! sql/maskout.sh results/ut-R.tmpout
2236- QUERY PLAN
2237-------------------------------------------------------------------------------------------------------------------------------------------------------------------
2236+ QUERY PLAN
2237+----------------
22382238 Aggregate (cost=xxx..xxx rows=1 width=xxx)
22392239 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
22402240 -> Hash Join (cost=xxx..xxx rows=1 width=xxx)
@@ -2376,8 +2376,8 @@ error hint:
23762376
23772377 \o
23782378 \! sql/maskout.sh results/ut-R.tmpout
2379- QUERY PLAN
2380-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2379+ QUERY PLAN
2380+----------------
23812381 Aggregate (cost=xxx..xxx rows=1 width=xxx)
23822382 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
23832383 -> Hash Join (cost=xxx..xxx rows=1 width=xxx)
@@ -2475,8 +2475,8 @@ error hint:
24752475
24762476 \o
24772477 \! sql/maskout.sh results/ut-R.tmpout
2478- QUERY PLAN
2479-----------------------------------------------------------------------------------
2478+ QUERY PLAN
2479+----------------
24802480 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
24812481 InitPlan 1 (returns $0)
24822482 -> Index Only Scan using t1_i1 on t1 b2t1 (cost=xxx..xxx rows=1 width=xxx)
@@ -2523,8 +2523,8 @@ error hint:
25232523
25242524 \o
25252525 \! sql/maskout.sh results/ut-R.tmpout
2526- QUERY PLAN
2527-----------------------------------------------------------------------------------
2526+ QUERY PLAN
2527+----------------
25282528 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
25292529 InitPlan 1 (returns $0)
25302530 -> Index Only Scan using t1_i1 on t1 b2t1 (cost=xxx..xxx rows=1 width=xxx)
@@ -2580,8 +2580,8 @@ error hint:
25802580
25812581 \o
25822582 \! sql/maskout.sh results/ut-R.tmpout
2583- QUERY PLAN
2584-------------------------------------------------------------------------------------------------
2583+ QUERY PLAN
2584+----------------
25852585 Nested Loop (cost=xxx..xxx rows=10 width=xxx)
25862586 Join Filter: (bmt1.c1 = bmt2.c1)
25872587 InitPlan 1 (returns $0)
@@ -2663,8 +2663,8 @@ error hint:
26632663
26642664 \o
26652665 \! sql/maskout.sh results/ut-R.tmpout
2666- QUERY PLAN
2667-------------------------------------------------------------------------------------------------
2666+ QUERY PLAN
2667+----------------
26682668 Nested Loop (cost=xxx..xxx rows=10 width=xxx)
26692669 Join Filter: (bmt1.c1 = bmt2.c1)
26702670 InitPlan 1 (returns $0)
@@ -2751,8 +2751,8 @@ error hint:
27512751
27522752 \o
27532753 \! sql/maskout.sh results/ut-R.tmpout
2754- QUERY PLAN
2755---------------------------------------------------------------------------------------------------------------------
2754+ QUERY PLAN
2755+----------------
27562756 Nested Loop (cost=xxx..xxx rows=10 width=xxx)
27572757 Join Filter: (bmt1.c1 = bmt4.c1)
27582758 InitPlan 1 (returns $1)
@@ -2894,8 +2894,8 @@ error hint:
28942894
28952895 \o
28962896 \! sql/maskout.sh results/ut-R.tmpout
2897- QUERY PLAN
2898---------------------------------------------------------------------------------------------------------------------
2897+ QUERY PLAN
2898+----------------
28992899 Nested Loop (cost=xxx..xxx rows=10 width=xxx)
29002900 Join Filter: (bmt1.c1 = bmt4.c1)
29012901 InitPlan 1 (returns $1)
@@ -2996,8 +2996,8 @@ error hint:
29962996
29972997 \o
29982998 \! sql/maskout.sh results/ut-R.tmpout
2999- QUERY PLAN
3000-------------------------------------------------------------------------------------------------------------------------------
2999+ QUERY PLAN
3000+----------------
30013001 Nested Loop (cost=xxx..xxx rows=10 width=xxx)
30023002 Join Filter: (bmt1.c1 = bmt4.c1)
30033003 InitPlan 1 (returns $0)
@@ -3087,8 +3087,8 @@ error hint:
30873087
30883088 \o
30893089 \! sql/maskout.sh results/ut-R.tmpout
3090- QUERY PLAN
3091-------------------------------------------------------------------------------------------------------------------------------
3090+ QUERY PLAN
3091+----------------
30923092 Nested Loop (cost=xxx..xxx rows=10 width=xxx)
30933093 Join Filter: (bmt1.c1 = bmt4.c1)
30943094 InitPlan 1 (returns $0)
@@ -3142,8 +3142,8 @@ error hint:
31423142
31433143 \o
31443144 \! sql/maskout.sh results/ut-R.tmpout
3145- QUERY PLAN
3146------------------------------------------------------------------------------------------------
3145+ QUERY PLAN
3146+----------------
31473147 Aggregate (cost=xxx..xxx rows=1 width=xxx)
31483148 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
31493149 Join Filter: (t1.c1 = t4.c1)
@@ -3187,8 +3187,8 @@ error hint:
31873187
31883188 \o
31893189 \! sql/maskout.sh results/ut-R.tmpout
3190- QUERY PLAN
3191----------------------------------------------------------------------------------
3190+ QUERY PLAN
3191+----------------
31923192 Aggregate (cost=xxx..xxx rows=1 width=xxx)
31933193 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
31943194 Join Filter: (t1.c1 = t4.c1)
@@ -3222,8 +3222,8 @@ error hint:
32223222
32233223 \o
32243224 \! sql/maskout.sh results/ut-R.tmpout
3225- QUERY PLAN
3226-----------------------------------------------------------------------------------------------------
3225+ QUERY PLAN
3226+----------------
32273227 Aggregate (cost=xxx..xxx rows=1 width=xxx)
32283228 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
32293229 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3267,8 +3267,8 @@ error hint:
32673267
32683268 \o
32693269 \! sql/maskout.sh results/ut-R.tmpout
3270- QUERY PLAN
3271--------------------------------------------------------------------------------------
3270+ QUERY PLAN
3271+----------------
32723272 Aggregate (cost=xxx..xxx rows=1 width=xxx)
32733273 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
32743274 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3310,8 +3310,8 @@ error hint:
33103310
33113311 \o
33123312 \! sql/maskout.sh results/ut-R.tmpout
3313- QUERY PLAN
3314------------------------------------------------------------------------------------------------
3313+ QUERY PLAN
3314+----------------
33153315 Aggregate (cost=xxx..xxx rows=1 width=xxx)
33163316 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
33173317 Join Filter: (t1.c1 = t4.c1)
@@ -3387,8 +3387,8 @@ error hint:
33873387
33883388 \o
33893389 \! sql/maskout.sh results/ut-R.tmpout
3390- QUERY PLAN
3391----------------------------------------------------------------------------------
3390+ QUERY PLAN
3391+----------------
33923392 Aggregate (cost=xxx..xxx rows=1 width=xxx)
33933393 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
33943394 Join Filter: (t1.c1 = t4.c1)
@@ -3451,8 +3451,8 @@ error hint:
34513451
34523452 \o
34533453 \! sql/maskout.sh results/ut-R.tmpout
3454- QUERY PLAN
3455-----------------------------------------------------------------------------------------------------
3454+ QUERY PLAN
3455+----------------
34563456 Aggregate (cost=xxx..xxx rows=1 width=xxx)
34573457 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
34583458 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3543,8 +3543,8 @@ error hint:
35433543
35443544 \o
35453545 \! sql/maskout.sh results/ut-R.tmpout
3546- QUERY PLAN
3547--------------------------------------------------------------------------------------
3546+ QUERY PLAN
3547+----------------
35483548 Aggregate (cost=xxx..xxx rows=1 width=xxx)
35493549 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
35503550 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3612,8 +3612,8 @@ error hint:
36123612
36133613 \o
36143614 \! sql/maskout.sh results/ut-R.tmpout
3615- QUERY PLAN
3616------------------------------------------------------------------------------------------------
3615+ QUERY PLAN
3616+----------------
36173617 Aggregate (cost=xxx..xxx rows=1 width=xxx)
36183618 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
36193619 Join Filter: (t1.c1 = t4.c1)
@@ -3721,8 +3721,8 @@ error hint:
37213721
37223722 \o
37233723 \! sql/maskout.sh results/ut-R.tmpout
3724- QUERY PLAN
3725----------------------------------------------------------------------------------
3724+ QUERY PLAN
3725+----------------
37263726 Aggregate (cost=xxx..xxx rows=1 width=xxx)
37273727 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
37283728 Join Filter: (t1.c1 = t4.c1)
@@ -3816,8 +3816,8 @@ error hint:
38163816
38173817 \o
38183818 \! sql/maskout.sh results/ut-R.tmpout
3819- QUERY PLAN
3820-----------------------------------------------------------------------------------------------------
3819+ QUERY PLAN
3820+----------------
38213821 Aggregate (cost=xxx..xxx rows=1 width=xxx)
38223822 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
38233823 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3965,8 +3965,8 @@ error hint:
39653965
39663966 \o
39673967 \! sql/maskout.sh results/ut-R.tmpout
3968- QUERY PLAN
3969--------------------------------------------------------------------------------------
3968+ QUERY PLAN
3969+----------------
39703970 Aggregate (cost=xxx..xxx rows=1 width=xxx)
39713971 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
39723972 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -4039,8 +4039,8 @@ HashJoin(v1t1 v1t1)
40394039
40404040 \o
40414041 \! sql/maskout.sh results/ut-R.tmpout
4042- QUERY PLAN
4043---------------------------------------------------------------------------
4042+ QUERY PLAN
4043+----------------
40444044 Hash Join (cost=xxx..xxx rows=1000 width=xxx)
40454045 Hash Cond: (v1t1.c1 = v1t1_1.c1)
40464046 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4064,8 +4064,8 @@ Rows(v1t1 v1t1 #1)
40644064
40654065 \o
40664066 \! sql/maskout.sh results/ut-R.tmpout
4067- QUERY PLAN
4068---------------------------------------------------------------------------
4067+ QUERY PLAN
4068+----------------
40694069 Hash Join (cost=xxx..xxx rows=1000 width=xxx)
40704070 Hash Cond: (v1t1.c1 = v1t1_1.c1)
40714071 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4085,8 +4085,8 @@ error hint:
40854085
40864086 \o
40874087 \! sql/maskout.sh results/ut-R.tmpout
4088- QUERY PLAN
4089------------------------------------------------------------------------------
4088+ QUERY PLAN
4089+----------------
40904090 Nested Loop (cost=xxx..xxx rows=1000 width=xxx)
40914091 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
40924092 -> Index Scan using t1_i1 on t1 v1t1_ (cost=xxx..xxx rows=1 width=xxx)
@@ -4105,8 +4105,8 @@ error hint:
41054105
41064106 \o
41074107 \! sql/maskout.sh results/ut-R.tmpout
4108- QUERY PLAN
4109------------------------------------------------------------------------------
4108+ QUERY PLAN
4109+----------------
41104110 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
41114111 -> Seq Scan on t1 v1t1 (cost=xxx..xxx rows=1000 width=xxx)
41124112 -> Index Scan using t1_i1 on t1 v1t1_ (cost=xxx..xxx rows=1 width=xxx)
@@ -4120,8 +4120,8 @@ INFO: pg_hint_plan: hint syntax error at or near "RowsHashJoin(r4t1 r4t1)"
41204120 DETAIL: Unrecognized hint keyword "RowsHashJoin".
41214121 \o
41224122 \! sql/maskout.sh results/ut-R.tmpout
4123- QUERY PLAN
4124---------------------------------------------------------------------------
4123+ QUERY PLAN
4124+----------------
41254125 Hash Join (cost=xxx..xxx rows=1000 width=xxx)
41264126 Hash Cond: (r4t1.c1 = r4t1_1.c1)
41274127 -> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4135,8 +4135,8 @@ INFO: pg_hint_plan: hint syntax error at or near "RowsHashJoin(r4t1 r4t1)Rows(r
41354135 DETAIL: Unrecognized hint keyword "RowsHashJoin".
41364136 \o
41374137 \! sql/maskout.sh results/ut-R.tmpout
4138- QUERY PLAN
4139---------------------------------------------------------------------------
4138+ QUERY PLAN
4139+----------------
41404140 Hash Join (cost=xxx..xxx rows=1000 width=xxx)
41414141 Hash Cond: (r4t1.c1 = r4t1_1.c1)
41424142 -> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4156,8 +4156,8 @@ error hint:
41564156
41574157 \o
41584158 \! sql/maskout.sh results/ut-R.tmpout
4159- QUERY PLAN
4160-----------------------------------------------------------------------------
4159+ QUERY PLAN
4160+----------------
41614161 Nested Loop (cost=xxx..xxx rows=1000 width=xxx)
41624162 -> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
41634163 -> Index Scan using t1_i1 on t1 r5t1 (cost=xxx..xxx rows=1 width=xxx)
@@ -4176,8 +4176,8 @@ error hint:
41764176
41774177 \o
41784178 \! sql/maskout.sh results/ut-R.tmpout
4179- QUERY PLAN
4180-----------------------------------------------------------------------------
4179+ QUERY PLAN
4180+----------------
41814181 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
41824182 -> Seq Scan on t1 r4t1 (cost=xxx..xxx rows=1000 width=xxx)
41834183 -> Index Scan using t1_i1 on t1 r5t1 (cost=xxx..xxx rows=1 width=xxx)
@@ -4191,8 +4191,8 @@ error hint:
41914191 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
41924192 \o
41934193 \! sql/maskout.sh results/ut-R.tmpout
4194- QUERY PLAN
4195---------------------------------------------------------------------------------
4194+ QUERY PLAN
4195+----------------
41964196 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
41974197 -> Hash Join (cost=xxx..xxx rows=2 width=xxx)
41984198 Hash Cond: (t2.c1 = "*VALUES*".column1)
@@ -4216,8 +4216,8 @@ error hint:
42164216
42174217 \o
42184218 \! sql/maskout.sh results/ut-R.tmpout
4219- QUERY PLAN
4220---------------------------------------------------------------------------------
4219+ QUERY PLAN
4220+----------------
42214221 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
42224222 -> Hash Join (cost=xxx..xxx rows=2 width=xxx)
42234223 Hash Cond: (t2.c1 = "*VALUES*".column1)
@@ -4241,8 +4241,8 @@ error hint:
42414241
42424242 \o
42434243 \! sql/maskout.sh results/ut-R.tmpout
4244- QUERY PLAN
4245------------------------------------------------------------------------------
4244+ QUERY PLAN
4245+----------------
42464246 Nested Loop (cost=xxx..xxx rows=20 width=xxx)
42474247 -> Nested Loop (cost=xxx..xxx rows=2 width=xxx)
42484248 -> Values Scan on "*VALUES*" (cost=xxx..xxx rows=2 width=xxx)
@@ -4256,8 +4256,8 @@ error hint:
42564256 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t4 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1 AND t1.c1 = t4.c1;
42574257 \o
42584258 \! sql/maskout.sh results/ut-R.tmpout
4259- QUERY PLAN
4260---------------------------------------------------------------------------------------
4259+ QUERY PLAN
4260+----------------
42614261 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
42624262 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
42634263 Join Filter: (t2.c1 = "*VALUES*_1".column1)
@@ -4286,8 +4286,8 @@ error hint:
42864286
42874287 \o
42884288 \! sql/maskout.sh results/ut-R.tmpout
4289- QUERY PLAN
4290---------------------------------------------------------------------------------------
4289+ QUERY PLAN
4290+----------------
42914291 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
42924292 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
42934293 Join Filter: (t2.c1 = "*VALUES*_1".column1)
@@ -4322,8 +4322,8 @@ Rows(*VALUES* t1 t2 t3 #2)
43224322
43234323 \o
43244324 \! sql/maskout.sh results/ut-R.tmpout
4325- QUERY PLAN
4326---------------------------------------------------------------------------------------
4325+ QUERY PLAN
4326+----------------
43274327 Nested Loop (cost=xxx..xxx rows=1 width=xxx)
43284328 -> Nested Loop (cost=xxx..xxx rows=1 width=xxx)
43294329 Join Filter: (t2.c1 = "*VALUES*_1".column1)
@@ -4345,8 +4345,8 @@ Rows(*VALUES* t1 t2 t3 #2)
43454345 EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
43464346 \o
43474347 \! sql/maskout.sh results/ut-R.tmpout
4348- QUERY PLAN
4349-------------------------------------------------------------------------------------------------------
4348+ QUERY PLAN
4349+----------------
43504350 Aggregate (cost=xxx..xxx rows=1 width=xxx)
43514351 -> Nested Loop (cost=xxx..xxx rows=100 width=xxx)
43524352 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
@@ -4377,8 +4377,8 @@ error hint:
43774377
43784378 \o
43794379 \! sql/maskout.sh results/ut-R.tmpout
4380- QUERY PLAN
4381------------------------------------------------------------------------------------------
4380+ QUERY PLAN
4381+----------------
43824382 Merge Join (cost=xxx..xxx rows=70 width=xxx)
43834383 Merge Cond: (bmt1.c1 = bmt2.c1)
43844384 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4399,8 +4399,8 @@ error hint:
43994399 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
44004400 \o
44014401 \! sql/maskout.sh results/ut-R.tmpout
4402- QUERY PLAN
4403-------------------------------------------------------------------------------------------------
4402+ QUERY PLAN
4403+----------------
44044404 Nested Loop (cost=xxx..xxx rows=100 width=xxx)
44054405 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
44064406 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -4430,8 +4430,8 @@ error hint:
44304430
44314431 \o
44324432 \! sql/maskout.sh results/ut-R.tmpout
4433- QUERY PLAN
4434------------------------------------------------------------------------------------------
4433+ QUERY PLAN
4434+----------------
44354435 Merge Join (cost=xxx..xxx rows=60 width=xxx)
44364436 Merge Cond: (bmt1.c1 = bmt2.c1)
44374437 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4452,8 +4452,8 @@ error hint:
44524452 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
44534453 \o
44544454 \! sql/maskout.sh results/ut-R.tmpout
4455- QUERY PLAN
4456-------------------------------------------------------------------------------------------------
4455+ QUERY PLAN
4456+----------------
44574457 Nested Loop (cost=xxx..xxx rows=100 width=xxx)
44584458 -> Merge Join (cost=xxx..xxx rows=100 width=xxx)
44594459 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -4483,8 +4483,8 @@ error hint:
44834483
44844484 \o
44854485 \! sql/maskout.sh results/ut-R.tmpout
4486- QUERY PLAN
4487------------------------------------------------------------------------------------------
4486+ QUERY PLAN
4487+----------------
44884488 Merge Join (cost=xxx..xxx rows=50 width=xxx)
44894489 Merge Cond: (bmt1.c1 = bmt2.c1)
44904490 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4517,8 +4517,8 @@ error hint:
45174517
45184518 \o
45194519 \! sql/maskout.sh results/ut-R.tmpout
4520- QUERY PLAN
4521----------------------------------------------------------------------------
4520+ QUERY PLAN
4521+----------------
45224522 Merge Join (cost=xxx..xxx rows=1 width=xxx)
45234523 Merge Cond: (t1.c1 = t2.c1)
45244524 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4539,8 +4539,8 @@ error hint:
45394539
45404540 \o
45414541 \! sql/maskout.sh results/ut-R.tmpout
4542- QUERY PLAN
4543----------------------------------------------------------------------------
4542+ QUERY PLAN
4543+----------------
45444544 Merge Join (cost=xxx..xxx rows=5 width=xxx)
45454545 Merge Cond: (t1.c1 = t2.c1)
45464546 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4564,8 +4564,8 @@ error hint:
45644564
45654565 \o
45664566 \! sql/maskout.sh results/ut-R.tmpout
4567- QUERY PLAN
4568----------------------------------------------------------------------------
4567+ QUERY PLAN
4568+----------------
45694569 Merge Join (cost=xxx..xxx rows=101 width=xxx)
45704570 Merge Cond: (t1.c1 = t2.c1)
45714571 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4586,8 +4586,8 @@ error hint:
45864586
45874587 \o
45884588 \! sql/maskout.sh results/ut-R.tmpout
4589- QUERY PLAN
4590----------------------------------------------------------------------------
4589+ QUERY PLAN
4590+----------------
45914591 Merge Join (cost=xxx..xxx rows=99 width=xxx)
45924592 Merge Cond: (t1.c1 = t2.c1)
45934593 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4609,8 +4609,8 @@ error hint:
46094609
46104610 \o
46114611 \! sql/maskout.sh results/ut-R.tmpout
4612- QUERY PLAN
4613----------------------------------------------------------------------------
4612+ QUERY PLAN
4613+----------------
46144614 Merge Join (cost=xxx..xxx rows=1 width=xxx)
46154615 Merge Cond: (t1.c1 = t2.c1)
46164616 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4635,8 +4635,8 @@ error hint:
46354635
46364636 \o
46374637 \! sql/maskout.sh results/ut-R.tmpout
4638- QUERY PLAN
4639----------------------------------------------------------------------------
4638+ QUERY PLAN
4639+----------------
46404640 Merge Join (cost=xxx..xxx rows=1 width=xxx)
46414641 Merge Cond: (t1.c1 = t2.c1)
46424642 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4657,8 +4657,8 @@ error hint:
46574657
46584658 \o
46594659 \! sql/maskout.sh results/ut-R.tmpout
4660- QUERY PLAN
4661----------------------------------------------------------------------------
4660+ QUERY PLAN
4661+----------------
46624662 Merge Join (cost=xxx..xxx rows=200 width=xxx)
46634663 Merge Cond: (t1.c1 = t2.c1)
46644664 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4679,8 +4679,8 @@ error hint:
46794679
46804680 \o
46814681 \! sql/maskout.sh results/ut-R.tmpout
4682- QUERY PLAN
4683----------------------------------------------------------------------------
4682+ QUERY PLAN
4683+----------------
46844684 Merge Join (cost=xxx..xxx rows=10 width=xxx)
46854685 Merge Cond: (t1.c1 = t2.c1)
46864686 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4696,8 +4696,8 @@ error hint:
46964696 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
46974697 \o
46984698 \! sql/maskout.sh results/ut-R.tmpout
4699- QUERY PLAN
4700-------------------------------------------------------------------------------
4699+ QUERY PLAN
4700+----------------
47014701 Hash Join (cost=xxx..xxx rows=301 width=xxx)
47024702 Hash Cond: (p2.c1 = p1.c1)
47034703 -> Append (cost=xxx..xxx rows=304 width=xxx)
@@ -4730,8 +4730,8 @@ error hint:
47304730
47314731 \o
47324732 \! sql/maskout.sh results/ut-R.tmpout
4733- QUERY PLAN
4734-------------------------------------------------------------------------------
4733+ QUERY PLAN
4734+----------------
47354735 Hash Join (cost=xxx..xxx rows=1 width=xxx)
47364736 Hash Cond: (p2.c1 = p1.c1)
47374737 -> Append (cost=xxx..xxx rows=304 width=xxx)
@@ -4757,8 +4757,8 @@ error hint:
47574757 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
47584758 \o
47594759 \! sql/maskout.sh results/ut-R.tmpout
4760- QUERY PLAN
4761-------------------------------------------------------------------------------
4760+ QUERY PLAN
4761+----------------
47624762 Hash Join (cost=xxx..xxx rows=301 width=xxx)
47634763 Hash Cond: (p2.c1 = p1.c1)
47644764 -> Append (cost=xxx..xxx rows=304 width=xxx)
@@ -4791,8 +4791,8 @@ error hint:
47914791
47924792 \o
47934793 \! sql/maskout.sh results/ut-R.tmpout
4794- QUERY PLAN
4795-------------------------------------------------------------------------------
4794+ QUERY PLAN
4795+----------------
47964796 Hash Join (cost=xxx..xxx rows=301 width=xxx)
47974797 Hash Cond: (p2.c1 = p1.c1)
47984798 -> Append (cost=xxx..xxx rows=304 width=xxx)
@@ -4821,8 +4821,8 @@ error hint:
48214821 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
48224822 \o
48234823 \! sql/maskout.sh results/ut-R.tmpout
4824- QUERY PLAN
4825----------------------------------------------------------------------------
4824+ QUERY PLAN
4825+----------------
48264826 Merge Join (cost=xxx..xxx rows=100 width=xxx)
48274827 Merge Cond: (t1.c1 = t2.c1)
48284828 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4845,8 +4845,8 @@ error hint:
48454845
48464846 \o
48474847 \! sql/maskout.sh results/ut-R.tmpout
4848- QUERY PLAN
4849----------------------------------------------------------------------------
4848+ QUERY PLAN
4849+----------------
48504850 Merge Join (cost=xxx..xxx rows=1 width=xxx)
48514851 Merge Cond: (t1.c1 = t2.c1)
48524852 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4859,8 +4859,8 @@ error hint:
48594859 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
48604860 \o
48614861 \! sql/maskout.sh results/ut-R.tmpout
4862- QUERY PLAN
4863----------------------------------------------------------------------------
4862+ QUERY PLAN
4863+----------------
48644864 Merge Join (cost=xxx..xxx rows=100 width=xxx)
48654865 Merge Cond: (t1.c1 = t2.c1)
48664866 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4886,8 +4886,8 @@ error hint:
48864886
48874887 \o
48884888 \! sql/maskout.sh results/ut-R.tmpout
4889- QUERY PLAN
4890----------------------------------------------------------------------------
4889+ QUERY PLAN
4890+----------------
48914891 Merge Join (cost=xxx..xxx rows=1 width=xxx)
48924892 Merge Cond: (t1.c1 = t2.c1)
48934893 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4900,8 +4900,8 @@ error hint:
49004900 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
49014901 \o
49024902 \! sql/maskout.sh results/ut-R.tmpout
4903- QUERY PLAN
4904----------------------------------------------------------------------------
4903+ QUERY PLAN
4904+----------------
49054905 Merge Join (cost=xxx..xxx rows=100 width=xxx)
49064906 Merge Cond: (t1.c1 = t2.c1)
49074907 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4924,8 +4924,8 @@ error hint:
49244924
49254925 \o
49264926 \! sql/maskout.sh results/ut-R.tmpout
4927- QUERY PLAN
4928----------------------------------------------------------------------------
4927+ QUERY PLAN
4928+----------------
49294929 Merge Join (cost=xxx..xxx rows=1 width=xxx)
49304930 Merge Cond: (t1.c1 = t2.c1)
49314931 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4938,8 +4938,8 @@ error hint:
49384938 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
49394939 \o
49404940 \! sql/maskout.sh results/ut-R.tmpout
4941- QUERY PLAN
4942----------------------------------------------------------------------------
4941+ QUERY PLAN
4942+----------------
49434943 Merge Join (cost=xxx..xxx rows=100 width=xxx)
49444944 Merge Cond: (t1.c1 = t2.c1)
49454945 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4965,8 +4965,8 @@ error hint:
49654965
49664966 \o
49674967 \! sql/maskout.sh results/ut-R.tmpout
4968- QUERY PLAN
4969----------------------------------------------------------------------------
4968+ QUERY PLAN
4969+----------------
49704970 Merge Join (cost=xxx..xxx rows=1 width=xxx)
49714971 Merge Cond: (t1.c1 = t2.c1)
49724972 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -4983,8 +4983,8 @@ SET client_min_messages TO DEBUG1;
49834983 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
49844984 \o
49854985 \! sql/maskout.sh results/ut-R.tmpout
4986- QUERY PLAN
4987----------------------------------------------------------------------------
4986+ QUERY PLAN
4987+----------------
49884988 Merge Join (cost=xxx..xxx rows=100 width=xxx)
49894989 Merge Cond: (t1.c1 = t2.c1)
49904990 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
@@ -5005,8 +5005,8 @@ error hint:
50055005
50065006 \o
50075007 \! sql/maskout.sh results/ut-R.tmpout
5008- QUERY PLAN
5009----------------------------------------------------------------------------
5008+ QUERY PLAN
5009+----------------
50105010 Merge Join (cost=xxx..xxx rows=101 width=xxx)
50115011 Merge Cond: (t1.c1 = t2.c1)
50125012 -> Index Scan using t1_i1 on t1 (cost=xxx..xxx rows=1000 width=xxx)
--- a/expected/ut-S.out
+++ b/expected/ut-S.out
@@ -4487,8 +4487,8 @@ error hint:
44874487
44884488 \o
44894489 \! sql/maskout.sh results/ut-S.tmpout
4490- QUERY PLAN
4491--------------------------------------------------------------------------------
4490+ QUERY PLAN
4491+----------------
44924492 Seq Scan on ti1 (cost={inf}..{inf} rows=1 width=xxx)
44934493 Filter: (c1 = 100)
44944494
@@ -4505,8 +4505,8 @@ error hint:
45054505
45064506 \o
45074507 \! sql/maskout.sh results/ut-S.tmpout
4508- QUERY PLAN
4509--------------------------------------------------------------------------------
4508+ QUERY PLAN
4509+----------------
45104510 Seq Scan on ti1 (cost={inf}..{inf} rows=1 width=xxx)
45114511 Filter: (c1 = 100)
45124512
@@ -4523,8 +4523,8 @@ error hint:
45234523
45244524 \o
45254525 \! sql/maskout.sh results/ut-S.tmpout
4526- QUERY PLAN
4527--------------------------------------------------------------------------------
4526+ QUERY PLAN
4527+----------------
45284528 Seq Scan on ti1 (cost={inf}..{inf} rows=1 width=xxx)
45294529 Filter: (c1 = 100)
45304530
@@ -4541,8 +4541,8 @@ error hint:
45414541
45424542 \o
45434543 \! sql/maskout.sh results/ut-S.tmpout
4544- QUERY PLAN
4545--------------------------------------------------------------------------------
4544+ QUERY PLAN
4545+----------------
45464546 Seq Scan on ti1 (cost={inf}..{inf} rows=1 width=xxx)
45474547 Filter: (c1 = 100)
45484548
@@ -4559,8 +4559,8 @@ error hint:
45594559
45604560 \o
45614561 \! sql/maskout.sh results/ut-S.tmpout
4562- QUERY PLAN
4563--------------------------------------------------------------------------------
4562+ QUERY PLAN
4563+----------------
45644564 Seq Scan on ti1 (cost={inf}..{inf} rows=1 width=xxx)
45654565 Filter: (c1 = 100)
45664566
@@ -4577,8 +4577,8 @@ error hint:
45774577
45784578 \o
45794579 \! sql/maskout.sh results/ut-S.tmpout
4580- QUERY PLAN
4581--------------------------------------------------------------------------------
4580+ QUERY PLAN
4581+----------------
45824582 Seq Scan on ti1 (cost={inf}..{inf} rows=1 width=xxx)
45834583 Filter: (c1 = 100)
45844584
@@ -4601,8 +4601,8 @@ error hint:
46014601
46024602 \o
46034603 \! sql/maskout.sh results/ut-S.tmpout
4604- QUERY PLAN
4605--------------------------------------------------------------------------------
4604+ QUERY PLAN
4605+----------------
46064606 Seq Scan on t1 (cost={inf}..{inf} rows=1 width=xxx)
46074607 Filter: (c1 = 1)
46084608
@@ -5232,8 +5232,8 @@ error hint:
52325232 EXPLAIN SELECT c4 FROM s1.p1 WHERE c2 * 2 < 100 AND c1 < 10;
52335233 \o
52345234 \! sql/maskout.sh results/ut-S.tmpout
5235- QUERY PLAN
5236----------------------------------------------------------------
5235+ QUERY PLAN
5236+----------------
52375237 Append (cost=xxx..xxx rows=4 width=xxx)
52385238 -> Seq Scan on p1 p1_1 (cost=xxx..xxx rows=1 width=xxx)
52395239 Filter: ((c1 < 10) AND ((c2 * 2) < 100))
@@ -5253,8 +5253,8 @@ error hint:
52535253
52545254 \o
52555255 \! sql/maskout.sh results/ut-S.tmpout
5256- QUERY PLAN
5257------------------------------------------------------------------------------------------
5256+ QUERY PLAN
5257+----------------
52585258 Append (cost=xxx..xxx rows=4 width=xxx)
52595259 -> Index Scan using p1_parent on p1 p1_1 (cost=xxx..xxx rows=1 width=xxx)
52605260 Filter: ((c2 * 2) < 100)
@@ -5277,8 +5277,8 @@ error hint:
52775277
52785278 \o
52795279 \! sql/maskout.sh results/ut-S.tmpout
5280- QUERY PLAN
5281------------------------------------------------------------------------------------
5280+ QUERY PLAN
5281+----------------
52825282 Append (cost=xxx..xxx rows=4 width=xxx)
52835283 -> Index Scan using p1_i2 on p1 p1_1 (cost=xxx..xxx rows=1 width=xxx)
52845284 Index Cond: (c2 = 1)
@@ -5304,8 +5304,8 @@ error hint:
53045304
53055305 \o
53065306 \! sql/maskout.sh results/ut-S.tmpout
5307- QUERY PLAN
5308---------------------------------------------------------------------------------------
5307+ QUERY PLAN
5308+----------------
53095309 Append (cost={inf}..{inf} rows=3 width=xxx)
53105310 -> Seq Scan on p2 p2_1 (cost={inf}..{inf} rows=1 width=xxx)
53115311 Filter: (c1 = 1)
--- a/sql/maskout.sh
+++ b/sql/maskout.sh
@@ -1,4 +1,5 @@
11 #! /bin/sh
22 cat $1 | \
33 sed 's/cost=10\{7\}[\.0-9]\+ /cost={inf}..{inf} /;s/cost=[\.0-9]\+ /cost=xxx..xxx /;s/width=[0-9]\+\([^0-9]\)/width=xxx\1/' |\
4-egrep -v "^ *((Planning time|JIT|Functions|Options):|\([0-9]* rows\))"
4+egrep -v "^ *((Planning time|JIT|Functions|Options):|\([0-9]* rows\))" |\
5+sed -e 's/^ *QUERY PLAN *$/ QUERY PLAN/' -e 's/^--*$/----------------/'
Show on old repository browser