• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revision7a9a406e758419f5a43ec750a2efb7b8134e839d (tree)
Time2020-10-29 20:29:28
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
@@ -8846,8 +8846,8 @@ Rows()
88468846 EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id);
88478847 \o
88488848 \! sql/maskout.sh results/pg_hint_plan.tmpout
8849- QUERY PLAN
8850-------------------------------------------------------------------------------
8849+ QUERY PLAN
8850+----------------
88518851 Merge Join (cost=xxx rows=1000 width=xxx)
88528852 Merge Cond: (t1.id = t2.id)
88538853 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8866,8 +8866,8 @@ error hint:
88668866
88678867 \o
88688868 \! sql/maskout.sh results/pg_hint_plan.tmpout
8869- QUERY PLAN
8870-------------------------------------------------------------------------------
8869+ QUERY PLAN
8870+----------------
88718871 Merge Join (cost=xxx rows=99 width=xxx)
88728872 Merge Cond: (t1.id = t2.id)
88738873 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8886,8 +8886,8 @@ error hint:
88868886
88878887 \o
88888888 \! sql/maskout.sh results/pg_hint_plan.tmpout
8889- QUERY PLAN
8890-------------------------------------------------------------------------------
8889+ QUERY PLAN
8890+----------------
88918891 Merge Join (cost=xxx rows=1099 width=xxx)
88928892 Merge Cond: (t1.id = t2.id)
88938893 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8906,8 +8906,8 @@ error hint:
89068906
89078907 \o
89088908 \! sql/maskout.sh results/pg_hint_plan.tmpout
8909- QUERY PLAN
8910-------------------------------------------------------------------------------
8909+ QUERY PLAN
8910+----------------
89118911 Merge Join (cost=xxx rows=901 width=xxx)
89128912 Merge Cond: (t1.id = t2.id)
89138913 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8926,8 +8926,8 @@ error hint:
89268926
89278927 \o
89288928 \! sql/maskout.sh results/pg_hint_plan.tmpout
8929- QUERY PLAN
8930-------------------------------------------------------------------------------
8929+ QUERY PLAN
8930+----------------
89318931 Merge Join (cost=xxx rows=99000 width=xxx)
89328932 Merge Cond: (t1.id = t2.id)
89338933 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8946,8 +8946,8 @@ error hint:
89468946
89478947 \o
89488948 \! sql/maskout.sh results/pg_hint_plan.tmpout
8949- QUERY PLAN
8950-------------------------------------------------------------------------------
8949+ QUERY PLAN
8950+----------------
89518951 Merge Join (cost=xxx rows=10 width=xxx)
89528952 Merge Cond: (t1.id = t2.id)
89538953 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8968,8 +8968,8 @@ Rows(t1 t2 #aa)
89688968
89698969 \o
89708970 \! sql/maskout.sh results/pg_hint_plan.tmpout
8971- QUERY PLAN
8972-------------------------------------------------------------------------------
8971+ QUERY PLAN
8972+----------------
89738973 Merge Join (cost=xxx rows=1000 width=xxx)
89748974 Merge Cond: (t1.id = t2.id)
89758975 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -8990,8 +8990,8 @@ Rows(t1 t2 /99)
89908990
89918991 \o
89928992 \! sql/maskout.sh results/pg_hint_plan.tmpout
8993- QUERY PLAN
8994-------------------------------------------------------------------------------
8993+ QUERY PLAN
8994+----------------
89958995 Merge Join (cost=xxx rows=1000 width=xxx)
89968996 Merge Cond: (t1.id = t2.id)
89978997 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -9012,8 +9012,8 @@ error hint:
90129012
90139013 \o
90149014 \! sql/maskout.sh results/pg_hint_plan.tmpout
9015- QUERY PLAN
9016-------------------------------------------------------------------------------
9015+ QUERY PLAN
9016+----------------
90179017 Merge Join (cost=xxx rows=1 width=xxx)
90189018 Merge Cond: (t1.id = t2.id)
90199019 -> Index Scan using t1_pkey on t1 (cost=xxx rows=10000 width=xxx)
@@ -9025,8 +9025,8 @@ error hint:
90259025 EXPLAIN SELECT * FROM t1 JOIN t2 ON (t1.id = t2.id) JOIN t3 ON (t3.id = t2.id);
90269026 \o
90279027 \! sql/maskout.sh results/pg_hint_plan.tmpout
9028- QUERY PLAN
9029-------------------------------------------------------------------------------------
9028+ QUERY PLAN
9029+----------------
90309030 Merge Join (cost=xxx rows=10 width=xxx)
90319031 Merge Cond: (t1.id = t3.id)
90329032 -> Merge Join (cost=xxx rows=1000 width=xxx)
@@ -9050,8 +9050,8 @@ error hint:
90509050
90519051 \o
90529052 \! sql/maskout.sh results/pg_hint_plan.tmpout
9053- QUERY PLAN
9054-------------------------------------------------------------------------------------
9053+ QUERY PLAN
9054+----------------
90559055 Merge Join (cost=xxx rows=1 width=xxx)
90569056 Merge Cond: (t1.id = t3.id)
90579057 -> Merge Join (cost=xxx rows=22 width=xxx)
@@ -9076,8 +9076,8 @@ error hint:
90769076 \o
90779077 set max_parallel_workers_per_gather to DEFAULT;
90789078 \! sql/maskout.sh results/pg_hint_plan.tmpout
9079- QUERY PLAN
9080-------------------------------------------------------------------------------------
9079+ QUERY PLAN
9080+----------------
90819081 Merge Join (cost=xxx rows=100 width=xxx)
90829082 Merge Cond: (t1.id = t3.id)
90839083 -> Merge Join (cost=xxx rows=1000 width=xxx)
--- a/expected/ut-J.out
+++ b/expected/ut-J.out
@@ -795,8 +795,8 @@ error hint:
795795
796796 \o
797797 \! sql/maskout.sh results/ut-J.tmpout
798- QUERY PLAN
799----------------------------------------------------------------------------------------------
798+ QUERY PLAN
799+----------------
800800 Nested Loop (cost=xxx rows=1 width=xxx)
801801 InitPlan 1 (returns $1)
802802 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -4745,8 +4745,8 @@ error hint:
47454745
47464746 \o
47474747 \! sql/maskout.sh results/ut-J.tmpout
4748- QUERY PLAN
4749---------------------------------------------------------------------------
4748+ QUERY PLAN
4749+----------------
47504750 Hash Full Join (cost=xxx rows=1000 width=xxx)
47514751 Hash Cond: (t1.c1 = t2.c1)
47524752 -> Seq Scan on t1 (cost=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 rows=100 width=xxx)
1313 Merge Cond: (t1.c1 = t2.c1)
1414 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -33,8 +33,8 @@ error hint:
3333
3434 \o
3535 \! sql/maskout.sh results/ut-R.tmpout
36- QUERY PLAN
37----------------------------------------------------------------------------
36+ QUERY PLAN
37+----------------
3838 Merge Join (cost=xxx rows=1 width=xxx)
3939 Merge Cond: (t1.c1 = t2.c1)
4040 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -56,8 +56,8 @@ error hint:
5656
5757 \o
5858 \! sql/maskout.sh results/ut-R.tmpout
59- QUERY PLAN
60--------------------------------------------------------------------------------
59+ QUERY PLAN
60+----------------
6161 Merge Join (cost=xxx rows=100 width=xxx)
6262 Merge Cond: (t_1.c1 = t_2.c1)
6363 -> Index Scan using t1_i1 on t1 t_1 (cost=xxx rows=1000 width=xxx)
@@ -79,8 +79,8 @@ error hint:
7979
8080 \o
8181 \! sql/maskout.sh results/ut-R.tmpout
82- QUERY PLAN
83--------------------------------------------------------------------------------
82+ QUERY PLAN
83+----------------
8484 Merge Join (cost=xxx rows=1 width=xxx)
8585 Merge Cond: (t_1.c1 = t_2.c1)
8686 -> Index Scan using t1_i1 on t1 t_1 (cost=xxx rows=1000 width=xxx)
@@ -105,8 +105,8 @@ error hint:
105105
106106 \o
107107 \! sql/maskout.sh results/ut-R.tmpout
108- QUERY PLAN
109----------------------------------------------------------------------------
108+ QUERY PLAN
109+----------------
110110 Merge Join (cost=xxx rows=1 width=xxx)
111111 Merge Cond: (t1.c1 = t2.c1)
112112 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -128,8 +128,8 @@ error hint:
128128
129129 \o
130130 \! sql/maskout.sh results/ut-R.tmpout
131- QUERY PLAN
132----------------------------------------------------------------------------
131+ QUERY PLAN
132+----------------
133133 Merge Join (cost=xxx rows=100 width=xxx)
134134 Merge Cond: (t1.c1 = t2.c1)
135135 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -154,8 +154,8 @@ error hint:
154154
155155 \o
156156 \! sql/maskout.sh results/ut-R.tmpout
157- QUERY PLAN
158----------------------------------------------------------------------------
157+ QUERY PLAN
158+----------------
159159 Merge Join (cost=xxx rows=1 width=xxx)
160160 Merge Cond: (t1.c1 = t2.c1)
161161 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -177,8 +177,8 @@ error hint:
177177
178178 \o
179179 \! sql/maskout.sh results/ut-R.tmpout
180- QUERY PLAN
181----------------------------------------------------------------------------
180+ QUERY PLAN
181+----------------
182182 Merge Join (cost=xxx rows=100 width=xxx)
183183 Merge Cond: (t1.c1 = t2.c1)
184184 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -203,8 +203,8 @@ error hint:
203203
204204 \o
205205 \! sql/maskout.sh results/ut-R.tmpout
206- QUERY PLAN
207----------------------------------------------------------------------------
206+ QUERY PLAN
207+----------------
208208 Merge Join (cost=xxx rows=1 width=xxx)
209209 Merge Cond: (t1.c1 = t2.c1)
210210 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -218,8 +218,8 @@ error hint:
218218 EXPLAIN SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = s2.t1.c1;
219219 \o
220220 \! sql/maskout.sh results/ut-R.tmpout
221- QUERY PLAN
222----------------------------------------------------------------------------
221+ QUERY PLAN
222+----------------
223223 Merge Join (cost=xxx rows=100 width=xxx)
224224 Merge Cond: (t1.c1 = t1_1.c1)
225225 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -242,8 +242,8 @@ Rows(t1 t1 #1)
242242
243243 \o
244244 \! sql/maskout.sh results/ut-R.tmpout
245- QUERY PLAN
246----------------------------------------------------------------------------
245+ QUERY PLAN
246+----------------
247247 Merge Join (cost=xxx rows=100 width=xxx)
248248 Merge Cond: (t1.c1 = t1_1.c1)
249249 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -264,8 +264,8 @@ error hint:
264264
265265 \o
266266 \! sql/maskout.sh results/ut-R.tmpout
267- QUERY PLAN
268----------------------------------------------------------------------------
267+ QUERY PLAN
268+----------------
269269 Merge Join (cost=xxx rows=100 width=xxx)
270270 Merge Cond: (t1.c1 = t1_1.c1)
271271 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -278,8 +278,8 @@ error hint:
278278 EXPLAIN SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = s2t1.c1;
279279 \o
280280 \! sql/maskout.sh results/ut-R.tmpout
281- QUERY PLAN
282----------------------------------------------------------------------------
281+ QUERY PLAN
282+----------------
283283 Merge Join (cost=xxx rows=100 width=xxx)
284284 Merge Cond: (t1.c1 = s2t1.c1)
285285 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -300,8 +300,8 @@ error hint:
300300
301301 \o
302302 \! sql/maskout.sh results/ut-R.tmpout
303- QUERY PLAN
304----------------------------------------------------------------------------
303+ QUERY PLAN
304+----------------
305305 Merge Join (cost=xxx rows=1 width=xxx)
306306 Merge Cond: (t1.c1 = s2t1.c1)
307307 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -315,8 +315,8 @@ error hint:
315315 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;
316316 \o
317317 \! sql/maskout.sh results/ut-R.tmpout
318- QUERY PLAN
319---------------------------------------------------------------------------------------------------
318+ QUERY PLAN
319+----------------
320320 Merge Join (cost=xxx rows=100 width=xxx)
321321 Merge Cond: (t1.c1 = t2.c1)
322322 InitPlan 1 (returns $0)
@@ -345,8 +345,8 @@ error hint:
345345
346346 \o
347347 \! sql/maskout.sh results/ut-R.tmpout
348- QUERY PLAN
349---------------------------------------------------------------------------------------------------
348+ QUERY PLAN
349+----------------
350350 Merge Join (cost=xxx rows=100 width=xxx)
351351 Merge Cond: (t1.c1 = t2.c1)
352352 InitPlan 1 (returns $0)
@@ -376,8 +376,8 @@ error hint:
376376
377377 \o
378378 \! sql/maskout.sh results/ut-R.tmpout
379- QUERY PLAN
380--------------------------------------------------------------------------------------------------
379+ QUERY PLAN
380+----------------
381381 Merge Join (cost=xxx rows=1 width=xxx)
382382 Merge Cond: (t1.c1 = t2.c1)
383383 InitPlan 1 (returns $0)
@@ -410,8 +410,8 @@ error hint:
410410
411411 \o
412412 \! sql/maskout.sh results/ut-R.tmpout
413- QUERY PLAN
414----------------------------------------------------------------------------
413+ QUERY PLAN
414+----------------
415415 Merge Join (cost=xxx rows=1 width=xxx)
416416 Merge Cond: (t1.c1 = t2.c1)
417417 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -435,8 +435,8 @@ Rows(t1 t1 #1)
435435
436436 \o
437437 \! sql/maskout.sh results/ut-R.tmpout
438- QUERY PLAN
439----------------------------------------------------------------------------
438+ QUERY PLAN
439+----------------
440440 Merge Join (cost=xxx rows=100 width=xxx)
441441 Merge Cond: (t1.c1 = t2.c1)
442442 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -453,8 +453,8 @@ INFO: pg_hint_plan: hint syntax error at or near "(t1 t1)(t2 t2)"
453453 DETAIL: Unrecognized hint keyword "".
454454 \o
455455 \! sql/maskout.sh results/ut-R.tmpout
456- QUERY PLAN
457----------------------------------------------------------------------------
456+ QUERY PLAN
457+----------------
458458 Merge Join (cost=xxx rows=100 width=xxx)
459459 Merge Cond: (t1.c1 = t2.c1)
460460 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -467,8 +467,8 @@ DETAIL: Unrecognized hint keyword "".
467467 EXPLAIN SELECT * FROM s1.t1, s1.t2, s1.t3 WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
468468 \o
469469 \! sql/maskout.sh results/ut-R.tmpout
470- QUERY PLAN
471----------------------------------------------------------------------------------
470+ QUERY PLAN
471+----------------
472472 Merge Join (cost=xxx rows=100 width=xxx)
473473 Merge Cond: (t1.c1 = t2.c1)
474474 -> Merge Join (cost=xxx rows=1000 width=xxx)
@@ -487,8 +487,8 @@ INFO: pg_hint_plan: hint syntax error at or near "(t1 t2 t1 t2)"
487487 DETAIL: Unrecognized hint keyword "".
488488 \o
489489 \! sql/maskout.sh results/ut-R.tmpout
490- QUERY PLAN
491----------------------------------------------------------------------------------------
490+ QUERY PLAN
491+----------------
492492 Nested Loop (cost=xxx rows=100 width=xxx)
493493 -> Merge Join (cost=xxx rows=100 width=xxx)
494494 Merge Cond: (t1.c1 = t2.c1)
@@ -519,8 +519,8 @@ error hint:
519519
520520 \o
521521 \! sql/maskout.sh results/ut-R.tmpout
522- QUERY PLAN
523----------------------------------------------------------------------------
522+ QUERY PLAN
523+----------------
524524 Merge Join (cost=xxx rows=1 width=xxx)
525525 Merge Cond: (t1.c1 = t2.c1)
526526 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -534,8 +534,8 @@ error hint:
534534 EXPLAIN SELECT * FROM s1.p1 t1, s1.p1 t2 WHERE t1.c1 = t2.c1;
535535 \o
536536 \! sql/maskout.sh results/ut-R.tmpout
537- QUERY PLAN
538-------------------------------------------------------------------------------
537+ QUERY PLAN
538+----------------
539539 Hash Join (cost=xxx rows=301 width=xxx)
540540 Hash Cond: (t1.c1 = t2.c1)
541541 -> Append (cost=xxx rows=301 width=xxx)
@@ -563,8 +563,8 @@ error hint:
563563
564564 \o
565565 \! sql/maskout.sh results/ut-R.tmpout
566- QUERY PLAN
567-------------------------------------------------------------------------------
566+ QUERY PLAN
567+----------------
568568 Hash Join (cost=xxx rows=1 width=xxx)
569569 Hash Cond: (t1.c1 = t2.c1)
570570 -> Append (cost=xxx rows=301 width=xxx)
@@ -585,8 +585,8 @@ error hint:
585585 EXPLAIN SELECT * FROM s1.ul1 t1, s1.ul1 t2 WHERE t1.c1 = t2.c1;
586586 \o
587587 \! sql/maskout.sh results/ut-R.tmpout
588- QUERY PLAN
589------------------------------------------------------------------------
588+ QUERY PLAN
589+----------------
590590 Hash Join (cost=xxx rows=1130 width=xxx)
591591 Hash Cond: (t1.c1 = t2.c1)
592592 -> Seq Scan on ul1 t1 (cost=xxx rows=1130 width=xxx)
@@ -606,8 +606,8 @@ error hint:
606606
607607 \o
608608 \! sql/maskout.sh results/ut-R.tmpout
609- QUERY PLAN
610------------------------------------------------------------------------
609+ QUERY PLAN
610+----------------
611611 Hash Join (cost=xxx rows=1 width=xxx)
612612 Hash Cond: (t1.c1 = t2.c1)
613613 -> Seq Scan on ul1 t1 (cost=xxx rows=1130 width=xxx)
@@ -621,8 +621,8 @@ CREATE TEMP TABLE tm1 (LIKE s1.t1 INCLUDING ALL);
621621 EXPLAIN SELECT * FROM tm1 t1, tm1 t2 WHERE t1.c1 = t2.c1;
622622 \o
623623 \! sql/maskout.sh results/ut-R.tmpout
624- QUERY PLAN
625------------------------------------------------------------------------
624+ QUERY PLAN
625+----------------
626626 Hash Join (cost=xxx rows=1130 width=xxx)
627627 Hash Cond: (t1.c1 = t2.c1)
628628 -> Seq Scan on tm1 t1 (cost=xxx rows=1130 width=xxx)
@@ -642,8 +642,8 @@ error hint:
642642
643643 \o
644644 \! sql/maskout.sh results/ut-R.tmpout
645- QUERY PLAN
646------------------------------------------------------------------------
645+ QUERY PLAN
646+----------------
647647 Hash Join (cost=xxx rows=1 width=xxx)
648648 Hash Cond: (t1.c1 = t2.c1)
649649 -> Seq Scan on tm1 t1 (cost=xxx rows=1130 width=xxx)
@@ -657,8 +657,8 @@ CREATE TEMP TABLE t_pg_class WITH OIDS AS SELECT * from pg_class LIMIT 100;
657657 EXPLAIN SELECT * FROM t_pg_class t1, t_pg_class t2 WHERE t1.oid = t2.oid;
658658 \o
659659 \! sql/maskout.sh results/ut-R.tmpout
660- QUERY PLAN
661-------------------------------------------------------------------------------
660+ QUERY PLAN
661+----------------
662662 Hash Join (cost=xxx rows=310 width=xxx)
663663 Hash Cond: (t1.oid = t2.oid)
664664 -> Seq Scan on t_pg_class t1 (cost=xxx rows=310 width=xxx)
@@ -678,8 +678,8 @@ error hint:
678678
679679 \o
680680 \! sql/maskout.sh results/ut-R.tmpout
681- QUERY PLAN
682-------------------------------------------------------------------------------
681+ QUERY PLAN
682+----------------
683683 Hash Join (cost=xxx rows=1 width=xxx)
684684 Hash Cond: (t1.oid = t2.oid)
685685 -> Seq Scan on t_pg_class t1 (cost=xxx rows=310 width=xxx)
@@ -694,8 +694,8 @@ error hint:
694694 EXPLAIN SELECT * FROM s1.f1() t1, s1.f1() 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 Nested Loop (cost=xxx rows=1 width=xxx)
700700 Join Filter: (t1.c1 = t2.c1)
701701 -> Function Scan on f1 t1 (cost=xxx rows=1 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 Nested Loop (cost=xxx rows=1 width=xxx)
720720 Join Filter: (t1.c1 = t2.c1)
721721 -> Function Scan on f1 t1 (cost=xxx rows=1 width=xxx)
@@ -727,8 +727,8 @@ error hint:
727727 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;
728728 \o
729729 \! sql/maskout.sh results/ut-R.tmpout
730- QUERY PLAN
731---------------------------------------------------------------------------
730+ QUERY PLAN
731+----------------
732732 Hash Join (cost=xxx rows=3 width=xxx)
733733 Hash Cond: (t2.c1 = "*VALUES*".column1)
734734 -> Seq Scan on t2 (cost=xxx rows=100 width=xxx)
@@ -748,8 +748,8 @@ error hint:
748748
749749 \o
750750 \! sql/maskout.sh results/ut-R.tmpout
751- QUERY PLAN
752---------------------------------------------------------------------------
751+ QUERY PLAN
752+----------------
753753 Hash Join (cost=xxx rows=3 width=xxx)
754754 Hash Cond: (t2.c1 = "*VALUES*".column1)
755755 -> Seq Scan on t2 (cost=xxx rows=100 width=xxx)
@@ -769,8 +769,8 @@ error hint:
769769
770770 \o
771771 \! sql/maskout.sh results/ut-R.tmpout
772- QUERY PLAN
773---------------------------------------------------------------------------
772+ QUERY PLAN
773+----------------
774774 Hash Join (cost=xxx rows=1 width=xxx)
775775 Hash Cond: (t2.c1 = "*VALUES*".column1)
776776 -> Seq Scan on t2 (cost=xxx rows=100 width=xxx)
@@ -783,8 +783,8 @@ error hint:
783783 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;
784784 \o
785785 \! sql/maskout.sh results/ut-R.tmpout
786- QUERY PLAN
787---------------------------------------------------------------------------------------------------
786+ QUERY PLAN
787+----------------
788788 Nested Loop (cost=xxx rows=1 width=xxx)
789789 CTE c1
790790 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -812,8 +812,8 @@ error hint:
812812
813813 \o
814814 \! sql/maskout.sh results/ut-R.tmpout
815- QUERY PLAN
816---------------------------------------------------------------------------------------------------
815+ QUERY PLAN
816+----------------
817817 Nested Loop (cost=xxx rows=2 width=xxx)
818818 CTE c1
819819 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -833,8 +833,8 @@ error hint:
833833 EXPLAIN SELECT * FROM s1.v1 t1, s1.v1 t2 WHERE t1.c1 = t2.c1;
834834 \o
835835 \! sql/maskout.sh results/ut-R.tmpout
836- QUERY PLAN
837---------------------------------------------------------------------------
836+ QUERY PLAN
837+----------------
838838 Hash Join (cost=xxx rows=1000 width=xxx)
839839 Hash Cond: (v1t1.c1 = v1t1_1.c1)
840840 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
@@ -854,8 +854,8 @@ error hint:
854854
855855 \o
856856 \! sql/maskout.sh results/ut-R.tmpout
857- QUERY PLAN
858---------------------------------------------------------------------------
857+ QUERY PLAN
858+----------------
859859 Hash Join (cost=xxx rows=1000 width=xxx)
860860 Hash Cond: (v1t1.c1 = v1t1_1.c1)
861861 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
@@ -875,8 +875,8 @@ error hint:
875875
876876 \o
877877 \! sql/maskout.sh results/ut-R.tmpout
878- QUERY PLAN
879--------------------------------------------------------------------------
878+ QUERY PLAN
879+----------------
880880 Hash Join (cost=xxx rows=1 width=xxx)
881881 Hash Cond: (v1t1.c1 = v1t1_.c1)
882882 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
@@ -889,8 +889,8 @@ error hint:
889889 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);
890890 \o
891891 \! sql/maskout.sh results/ut-R.tmpout
892- QUERY PLAN
893--------------------------------------------------------------------------------------------------
892+ QUERY PLAN
893+----------------
894894 Nested Loop (cost=xxx rows=1 width=xxx)
895895 InitPlan 1 (returns $0)
896896 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -919,8 +919,8 @@ error hint:
919919
920920 \o
921921 \! sql/maskout.sh results/ut-R.tmpout
922- QUERY PLAN
923--------------------------------------------------------------------------------------------------
922+ QUERY PLAN
923+----------------
924924 Nested Loop (cost=xxx rows=1 width=xxx)
925925 InitPlan 1 (returns $0)
926926 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -944,8 +944,8 @@ error hint:
944944 EXPLAIN SELECT * FROM s1.t1, (SELECT t2.c1 FROM s1.t2) st2 WHERE t1.c1 = st2.c1;
945945 \o
946946 \! sql/maskout.sh results/ut-R.tmpout
947- QUERY PLAN
948----------------------------------------------------------------------------
947+ QUERY PLAN
948+----------------
949949 Merge Join (cost=xxx rows=100 width=xxx)
950950 Merge Cond: (t1.c1 = t2.c1)
951951 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -966,8 +966,8 @@ error hint:
966966
967967 \o
968968 \! sql/maskout.sh results/ut-R.tmpout
969- QUERY PLAN
970----------------------------------------------------------------------------
969+ QUERY PLAN
970+----------------
971971 Merge Join (cost=xxx rows=100 width=xxx)
972972 Merge Cond: (t1.c1 = t2.c1)
973973 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -988,8 +988,8 @@ error hint:
988988
989989 \o
990990 \! sql/maskout.sh results/ut-R.tmpout
991- QUERY PLAN
992----------------------------------------------------------------------------
991+ QUERY PLAN
992+----------------
993993 Merge Join (cost=xxx rows=1 width=xxx)
994994 Merge Cond: (t1.c1 = t2.c1)
995995 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -1016,8 +1016,8 @@ Rows(t1 #1)
10161016
10171017 \o
10181018 \! sql/maskout.sh results/ut-R.tmpout
1019- QUERY PLAN
1020----------------------------------------------------------------------------
1019+ QUERY PLAN
1020+----------------
10211021 Merge Join (cost=xxx rows=100 width=xxx)
10221022 Merge Cond: (t1.c1 = t2.c1)
10231023 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -1041,8 +1041,8 @@ Rows(t1 t2 1)
10411041
10421042 \o
10431043 \! sql/maskout.sh results/ut-R.tmpout
1044- QUERY PLAN
1045----------------------------------------------------------------------------
1044+ QUERY PLAN
1045+----------------
10461046 Merge Join (cost=xxx rows=100 width=xxx)
10471047 Merge Cond: (t1.c1 = t2.c1)
10481048 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -1066,8 +1066,8 @@ Rows(t1 t2 #notrows)
10661066
10671067 \o
10681068 \! sql/maskout.sh results/ut-R.tmpout
1069- QUERY PLAN
1070----------------------------------------------------------------------------
1069+ QUERY PLAN
1070+----------------
10711071 Merge Join (cost=xxx rows=100 width=xxx)
10721072 Merge Cond: (t1.c1 = t2.c1)
10731073 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -1117,8 +1117,8 @@ error hint:
11171117
11181118 \o
11191119 \! sql/maskout.sh results/ut-R.tmpout
1120- QUERY PLAN
1121---------------------------------------------------------------------------------------------------------------------
1120+ QUERY PLAN
1121+----------------
11221122 Aggregate (cost=xxx rows=1 width=xxx)
11231123 InitPlan 1 (returns $1)
11241124 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1212,8 +1212,8 @@ error hint:
12121212
12131213 \o
12141214 \! sql/maskout.sh results/ut-R.tmpout
1215- QUERY PLAN
1216---------------------------------------------------------------------------------------------------------------------
1215+ QUERY PLAN
1216+----------------
12171217 Aggregate (cost=xxx rows=1 width=xxx)
12181218 InitPlan 1 (returns $1)
12191219 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1305,8 +1305,8 @@ error hint:
13051305
13061306 \o
13071307 \! sql/maskout.sh results/ut-R.tmpout
1308- QUERY PLAN
1309---------------------------------------------------------------------------------------------------------------------
1308+ QUERY PLAN
1309+----------------
13101310 Aggregate (cost=xxx rows=1 width=xxx)
13111311 InitPlan 1 (returns $1)
13121312 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1426,8 +1426,8 @@ error hint:
14261426
14271427 \o
14281428 \! sql/maskout.sh results/ut-R.tmpout
1429- QUERY PLAN
1430---------------------------------------------------------------------------------------------------------------------
1429+ QUERY PLAN
1430+----------------
14311431 Aggregate (cost=xxx rows=1 width=xxx)
14321432 InitPlan 1 (returns $1)
14331433 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1501,8 +1501,8 @@ error hint:
15011501
15021502 \o
15031503 \! sql/maskout.sh results/ut-R.tmpout
1504- QUERY PLAN
1505------------------------------------------------------------------------------------------------
1504+ QUERY PLAN
1505+----------------
15061506 Aggregate (cost=xxx rows=1 width=xxx)
15071507 -> Merge Join (cost=xxx rows=100 width=xxx)
15081508 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -1538,8 +1538,8 @@ error hint:
15381538
15391539 \o
15401540 \! sql/maskout.sh results/ut-R.tmpout
1541- QUERY PLAN
1542---------------------------------------------------------------------------------------------
1541+ QUERY PLAN
1542+----------------
15431543 Aggregate (cost=xxx rows=1 width=xxx)
15441544 -> Nested Loop (cost=xxx rows=1 width=xxx)
15451545 Join Filter: (bmt2.c1 = bmt1.c1)
@@ -1570,8 +1570,8 @@ error hint:
15701570
15711571 \o
15721572 \! sql/maskout.sh results/ut-R.tmpout
1573- QUERY PLAN
1574------------------------------------------------------------------------------------------------
1573+ QUERY PLAN
1574+----------------
15751575 Aggregate (cost=xxx rows=1 width=xxx)
15761576 -> Merge Join (cost=xxx rows=100 width=xxx)
15771577 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -1607,8 +1607,8 @@ error hint:
16071607
16081608 \o
16091609 \! sql/maskout.sh results/ut-R.tmpout
1610- QUERY PLAN
1611---------------------------------------------------------------------------------------------
1610+ QUERY PLAN
1611+----------------
16121612 Aggregate (cost=xxx rows=1 width=xxx)
16131613 -> Nested Loop (cost=xxx rows=1 width=xxx)
16141614 Join Filter: (bmt2.c1 = bmt1.c1)
@@ -1661,8 +1661,8 @@ error hint:
16611661
16621662 \o
16631663 \! sql/maskout.sh results/ut-R.tmpout
1664- QUERY PLAN
1665---------------------------------------------------------------------------------------------------------------------
1664+ QUERY PLAN
1665+----------------
16661666 Aggregate (cost=xxx rows=1 width=xxx)
16671667 InitPlan 1 (returns $1)
16681668 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1758,8 +1758,8 @@ error hint:
17581758
17591759 \o
17601760 \! sql/maskout.sh results/ut-R.tmpout
1761- QUERY PLAN
1762---------------------------------------------------------------------------------------------------------------------
1761+ QUERY PLAN
1762+----------------
17631763 Aggregate (cost=xxx rows=1 width=xxx)
17641764 InitPlan 1 (returns $1)
17651765 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1852,8 +1852,8 @@ error hint:
18521852
18531853 \o
18541854 \! sql/maskout.sh results/ut-R.tmpout
1855- QUERY PLAN
1856---------------------------------------------------------------------------------------------------------------------
1855+ QUERY PLAN
1856+----------------
18571857 Aggregate (cost=xxx rows=1 width=xxx)
18581858 InitPlan 1 (returns $1)
18591859 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -1974,8 +1974,8 @@ error hint:
19741974
19751975 \o
19761976 \! sql/maskout.sh results/ut-R.tmpout
1977- QUERY PLAN
1978---------------------------------------------------------------------------------------------------------------------
1977+ QUERY PLAN
1978+----------------
19791979 Aggregate (cost=xxx rows=1 width=xxx)
19801980 InitPlan 1 (returns $1)
19811981 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -2080,8 +2080,8 @@ error hint:
20802080
20812081 \o
20822082 \! sql/maskout.sh results/ut-R.tmpout
2083- QUERY PLAN
2084---------------------------------------------------------------------------------------------------------------------
2083+ QUERY PLAN
2084+----------------
20852085 Aggregate (cost=xxx rows=1 width=xxx)
20862086 CTE c1
20872087 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -2195,8 +2195,8 @@ error hint:
21952195
21962196 \o
21972197 \! sql/maskout.sh results/ut-R.tmpout
2198- QUERY PLAN
2199---------------------------------------------------------------------------------------------------------------------
2198+ QUERY PLAN
2199+----------------
22002200 Aggregate (cost=xxx rows=1 width=xxx)
22012201 CTE c1
22022202 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -2308,8 +2308,8 @@ error hint:
23082308
23092309 \o
23102310 \! sql/maskout.sh results/ut-R.tmpout
2311- QUERY PLAN
2312---------------------------------------------------------------------------------------------------------------------
2311+ QUERY PLAN
2312+----------------
23132313 Aggregate (cost=xxx rows=1 width=xxx)
23142314 CTE c1
23152315 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -2458,8 +2458,8 @@ error hint:
24582458
24592459 \o
24602460 \! sql/maskout.sh results/ut-R.tmpout
2461- QUERY PLAN
2462---------------------------------------------------------------------------------------------------------------------
2461+ QUERY PLAN
2462+----------------
24632463 Aggregate (cost=xxx rows=1 width=xxx)
24642464 CTE c1
24652465 -> Aggregate (cost=xxx rows=1 width=xxx)
@@ -2564,8 +2564,8 @@ error hint:
25642564
25652565 \o
25662566 \! sql/maskout.sh results/ut-R.tmpout
2567- QUERY PLAN
2568-----------------------------------------------------------------------------------
2567+ QUERY PLAN
2568+----------------
25692569 Nested Loop (cost=xxx rows=1 width=xxx)
25702570 CTE c1
25712571 -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=xxx)
@@ -2616,8 +2616,8 @@ error hint:
26162616
26172617 \o
26182618 \! sql/maskout.sh results/ut-R.tmpout
2619- QUERY PLAN
2620-----------------------------------------------------------------------------------
2619+ QUERY PLAN
2620+----------------
26212621 Nested Loop (cost=xxx rows=1 width=xxx)
26222622 CTE c1
26232623 -> Index Only Scan using t1_i1 on t1 b1t1 (cost=xxx rows=1 width=xxx)
@@ -2677,8 +2677,8 @@ error hint:
26772677
26782678 \o
26792679 \! sql/maskout.sh results/ut-R.tmpout
2680- QUERY PLAN
2681---------------------------------------------------------------------------------------------
2680+ QUERY PLAN
2681+----------------
26822682 Hash Join (cost=xxx rows=10 width=xxx)
26832683 Hash Cond: (bmt1.c1 = bmt2.c1)
26842684 CTE c1
@@ -2767,8 +2767,8 @@ error hint:
27672767
27682768 \o
27692769 \! sql/maskout.sh results/ut-R.tmpout
2770- QUERY PLAN
2771---------------------------------------------------------------------------------------------
2770+ QUERY PLAN
2771+----------------
27722772 Hash Join (cost=xxx rows=1 width=xxx)
27732773 Hash Cond: (bmt1.c1 = bmt2.c1)
27742774 CTE c1
@@ -2862,8 +2862,8 @@ error hint:
28622862
28632863 \o
28642864 \! sql/maskout.sh results/ut-R.tmpout
2865- QUERY PLAN
2866-------------------------------------------------------------------------------------------------------------------
2865+ QUERY PLAN
2866+----------------
28672867 Merge Join (cost=xxx rows=10 width=xxx)
28682868 Merge Cond: (bmt1.c1 = bmt2.c1)
28692869 CTE c1
@@ -3009,8 +3009,8 @@ error hint:
30093009
30103010 \o
30113011 \! sql/maskout.sh results/ut-R.tmpout
3012- QUERY PLAN
3013-------------------------------------------------------------------------------------------------------------------
3012+ QUERY PLAN
3013+----------------
30143014 Merge Join (cost=xxx rows=1 width=xxx)
30153015 Merge Cond: (bmt1.c1 = bmt2.c1)
30163016 CTE c1
@@ -3115,8 +3115,8 @@ error hint:
31153115
31163116 \o
31173117 \! sql/maskout.sh results/ut-R.tmpout
3118- QUERY PLAN
3119-------------------------------------------------------------------------------------------------------------------
3118+ QUERY PLAN
3119+----------------
31203120 Merge Join (cost=xxx rows=10 width=xxx)
31213121 Merge Cond: (bmt1.c1 = bmt2.c1)
31223122 CTE c1
@@ -3210,8 +3210,8 @@ error hint:
32103210
32113211 \o
32123212 \! sql/maskout.sh results/ut-R.tmpout
3213- QUERY PLAN
3214-------------------------------------------------------------------------------------------------------------------
3213+ QUERY PLAN
3214+----------------
32153215 Merge Join (cost=xxx rows=1 width=xxx)
32163216 Merge Cond: (bmt1.c1 = bmt2.c1)
32173217 CTE c1
@@ -3269,8 +3269,8 @@ error hint:
32693269
32703270 \o
32713271 \! sql/maskout.sh results/ut-R.tmpout
3272- QUERY PLAN
3273------------------------------------------------------------------------------------------------
3272+ QUERY PLAN
3273+----------------
32743274 Aggregate (cost=xxx rows=1 width=xxx)
32753275 -> Nested Loop (cost=xxx rows=1 width=xxx)
32763276 Join Filter: (t1.c1 = t4.c1)
@@ -3315,8 +3315,8 @@ error hint:
33153315
33163316 \o
33173317 \! sql/maskout.sh results/ut-R.tmpout
3318- QUERY PLAN
3319----------------------------------------------------------------------------------
3318+ QUERY PLAN
3319+----------------
33203320 Aggregate (cost=xxx rows=1 width=xxx)
33213321 -> Nested Loop (cost=xxx rows=2 width=xxx)
33223322 Join Filter: (t1.c1 = t4.c1)
@@ -3351,8 +3351,8 @@ error hint:
33513351
33523352 \o
33533353 \! sql/maskout.sh results/ut-R.tmpout
3354- QUERY PLAN
3355-----------------------------------------------------------------------------------------------------
3354+ QUERY PLAN
3355+----------------
33563356 Aggregate (cost=xxx rows=1 width=xxx)
33573357 -> Nested Loop (cost=xxx rows=1 width=xxx)
33583358 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3397,8 +3397,8 @@ error hint:
33973397
33983398 \o
33993399 \! sql/maskout.sh results/ut-R.tmpout
3400- QUERY PLAN
3401--------------------------------------------------------------------------------------
3400+ QUERY PLAN
3401+----------------
34023402 Aggregate (cost=xxx rows=1 width=xxx)
34033403 -> Nested Loop (cost=xxx rows=2 width=xxx)
34043404 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3441,8 +3441,8 @@ error hint:
34413441
34423442 \o
34433443 \! sql/maskout.sh results/ut-R.tmpout
3444- QUERY PLAN
3445------------------------------------------------------------------------------------------------
3444+ QUERY PLAN
3445+----------------
34463446 Aggregate (cost=xxx rows=1 width=xxx)
34473447 -> Nested Loop (cost=xxx rows=1 width=xxx)
34483448 Join Filter: (t1.c1 = t4.c1)
@@ -3519,8 +3519,8 @@ error hint:
35193519
35203520 \o
35213521 \! sql/maskout.sh results/ut-R.tmpout
3522- QUERY PLAN
3523----------------------------------------------------------------------------------
3522+ QUERY PLAN
3523+----------------
35243524 Aggregate (cost=xxx rows=1 width=xxx)
35253525 -> Nested Loop (cost=xxx rows=2 width=xxx)
35263526 Join Filter: (t1.c1 = t4.c1)
@@ -3584,8 +3584,8 @@ error hint:
35843584
35853585 \o
35863586 \! sql/maskout.sh results/ut-R.tmpout
3587- QUERY PLAN
3588-----------------------------------------------------------------------------------------------------
3587+ QUERY PLAN
3588+----------------
35893589 Aggregate (cost=xxx rows=1 width=xxx)
35903590 -> Nested Loop (cost=xxx rows=1 width=xxx)
35913591 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3677,8 +3677,8 @@ error hint:
36773677
36783678 \o
36793679 \! sql/maskout.sh results/ut-R.tmpout
3680- QUERY PLAN
3681--------------------------------------------------------------------------------------
3680+ QUERY PLAN
3681+----------------
36823682 Aggregate (cost=xxx rows=1 width=xxx)
36833683 -> Nested Loop (cost=xxx rows=2 width=xxx)
36843684 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -3747,8 +3747,8 @@ error hint:
37473747
37483748 \o
37493749 \! sql/maskout.sh results/ut-R.tmpout
3750- QUERY PLAN
3751------------------------------------------------------------------------------------------------
3750+ QUERY PLAN
3751+----------------
37523752 Aggregate (cost=xxx rows=1 width=xxx)
37533753 -> Nested Loop (cost=xxx rows=1 width=xxx)
37543754 Join Filter: (t1.c1 = t4.c1)
@@ -3857,8 +3857,8 @@ error hint:
38573857
38583858 \o
38593859 \! sql/maskout.sh results/ut-R.tmpout
3860- QUERY PLAN
3861----------------------------------------------------------------------------------
3860+ QUERY PLAN
3861+----------------
38623862 Aggregate (cost=xxx rows=1 width=xxx)
38633863 -> Nested Loop (cost=xxx rows=2 width=xxx)
38643864 Join Filter: (t1.c1 = t4.c1)
@@ -3953,8 +3953,8 @@ error hint:
39533953
39543954 \o
39553955 \! sql/maskout.sh results/ut-R.tmpout
3956- QUERY PLAN
3957-----------------------------------------------------------------------------------------------------
3956+ QUERY PLAN
3957+----------------
39583958 Aggregate (cost=xxx rows=1 width=xxx)
39593959 -> Nested Loop (cost=xxx rows=1 width=xxx)
39603960 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -4103,8 +4103,8 @@ error hint:
41034103
41044104 \o
41054105 \! sql/maskout.sh results/ut-R.tmpout
4106- QUERY PLAN
4107--------------------------------------------------------------------------------------
4106+ QUERY PLAN
4107+----------------
41084108 Aggregate (cost=xxx rows=1 width=xxx)
41094109 -> Nested Loop (cost=xxx rows=2 width=xxx)
41104110 Join Filter: (b1t1.c1 = b1t4.c1)
@@ -4178,8 +4178,8 @@ HashJoin(v1t1 v1t1)
41784178
41794179 \o
41804180 \! sql/maskout.sh results/ut-R.tmpout
4181- QUERY PLAN
4182---------------------------------------------------------------------------
4181+ QUERY PLAN
4182+----------------
41834183 Hash Join (cost=xxx rows=1000 width=xxx)
41844184 Hash Cond: (v1t1.c1 = v1t1_1.c1)
41854185 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
@@ -4204,8 +4204,8 @@ Rows(v1t1 v1t1 #1)
42044204
42054205 \o
42064206 \! sql/maskout.sh results/ut-R.tmpout
4207- QUERY PLAN
4208---------------------------------------------------------------------------
4207+ QUERY PLAN
4208+----------------
42094209 Hash Join (cost=xxx rows=1000 width=xxx)
42104210 Hash Cond: (v1t1.c1 = v1t1_1.c1)
42114211 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
@@ -4226,8 +4226,8 @@ error hint:
42264226
42274227 \o
42284228 \! sql/maskout.sh results/ut-R.tmpout
4229- QUERY PLAN
4230------------------------------------------------------------------------------
4229+ QUERY PLAN
4230+----------------
42314231 Nested Loop (cost=xxx rows=1000 width=xxx)
42324232 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
42334233 -> Index Scan using t1_i1 on t1 v1t1_ (cost=xxx rows=1 width=xxx)
@@ -4247,8 +4247,8 @@ error hint:
42474247
42484248 \o
42494249 \! sql/maskout.sh results/ut-R.tmpout
4250- QUERY PLAN
4251------------------------------------------------------------------------------
4250+ QUERY PLAN
4251+----------------
42524252 Nested Loop (cost=xxx rows=1 width=xxx)
42534253 -> Seq Scan on t1 v1t1 (cost=xxx rows=1000 width=xxx)
42544254 -> Index Scan using t1_i1 on t1 v1t1_ (cost=xxx rows=1 width=xxx)
@@ -4263,8 +4263,8 @@ INFO: pg_hint_plan: hint syntax error at or near "RowsHashJoin(r4t1 r4t1)"
42634263 DETAIL: Unrecognized hint keyword "RowsHashJoin".
42644264 \o
42654265 \! sql/maskout.sh results/ut-R.tmpout
4266- QUERY PLAN
4267---------------------------------------------------------------------------
4266+ QUERY PLAN
4267+----------------
42684268 Hash Join (cost=xxx rows=1000 width=xxx)
42694269 Hash Cond: (r4t1.c1 = r4t1_1.c1)
42704270 -> Seq Scan on t1 r4t1 (cost=xxx rows=1000 width=xxx)
@@ -4279,8 +4279,8 @@ INFO: pg_hint_plan: hint syntax error at or near "RowsHashJoin(r4t1 r4t1)Rows(r
42794279 DETAIL: Unrecognized hint keyword "RowsHashJoin".
42804280 \o
42814281 \! sql/maskout.sh results/ut-R.tmpout
4282- QUERY PLAN
4283---------------------------------------------------------------------------
4282+ QUERY PLAN
4283+----------------
42844284 Hash Join (cost=xxx rows=1000 width=xxx)
42854285 Hash Cond: (r4t1.c1 = r4t1_1.c1)
42864286 -> Seq Scan on t1 r4t1 (cost=xxx rows=1000 width=xxx)
@@ -4301,8 +4301,8 @@ error hint:
43014301
43024302 \o
43034303 \! sql/maskout.sh results/ut-R.tmpout
4304- QUERY PLAN
4305-----------------------------------------------------------------------------
4304+ QUERY PLAN
4305+----------------
43064306 Nested Loop (cost=xxx rows=1000 width=xxx)
43074307 -> Seq Scan on t1 r4t1 (cost=xxx rows=1000 width=xxx)
43084308 -> Index Scan using t1_i1 on t1 r5t1 (cost=xxx rows=1 width=xxx)
@@ -4322,8 +4322,8 @@ error hint:
43224322
43234323 \o
43244324 \! sql/maskout.sh results/ut-R.tmpout
4325- QUERY PLAN
4326-----------------------------------------------------------------------------
4325+ QUERY PLAN
4326+----------------
43274327 Nested Loop (cost=xxx rows=1 width=xxx)
43284328 -> Seq Scan on t1 r4t1 (cost=xxx rows=1000 width=xxx)
43294329 -> Index Scan using t1_i1 on t1 r5t1 (cost=xxx rows=1 width=xxx)
@@ -4338,8 +4338,8 @@ error hint:
43384338 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;
43394339 \o
43404340 \! sql/maskout.sh results/ut-R.tmpout
4341- QUERY PLAN
4342---------------------------------------------------------------------------------
4341+ QUERY PLAN
4342+----------------
43434343 Nested Loop (cost=xxx rows=1 width=xxx)
43444344 -> Hash Join (cost=xxx rows=2 width=xxx)
43454345 Hash Cond: (t2.c1 = "*VALUES*".column1)
@@ -4364,8 +4364,8 @@ error hint:
43644364
43654365 \o
43664366 \! sql/maskout.sh results/ut-R.tmpout
4367- QUERY PLAN
4368---------------------------------------------------------------------------------
4367+ QUERY PLAN
4368+----------------
43694369 Nested Loop (cost=xxx rows=1 width=xxx)
43704370 -> Hash Join (cost=xxx rows=2 width=xxx)
43714371 Hash Cond: (t2.c1 = "*VALUES*".column1)
@@ -4390,8 +4390,8 @@ error hint:
43904390
43914391 \o
43924392 \! sql/maskout.sh results/ut-R.tmpout
4393- QUERY PLAN
4394------------------------------------------------------------------------------
4393+ QUERY PLAN
4394+----------------
43954395 Nested Loop (cost=xxx rows=20 width=xxx)
43964396 -> Nested Loop (cost=xxx rows=2 width=xxx)
43974397 -> Values Scan on "*VALUES*" (cost=xxx rows=2 width=xxx)
@@ -4406,8 +4406,8 @@ error hint:
44064406 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;
44074407 \o
44084408 \! sql/maskout.sh results/ut-R.tmpout
4409- QUERY PLAN
4410---------------------------------------------------------------------------------------
4409+ QUERY PLAN
4410+----------------
44114411 Nested Loop (cost=xxx rows=1 width=xxx)
44124412 -> Nested Loop (cost=xxx rows=1 width=xxx)
44134413 Join Filter: (t2.c1 = "*VALUES*_1".column1)
@@ -4437,8 +4437,8 @@ error hint:
44374437
44384438 \o
44394439 \! sql/maskout.sh results/ut-R.tmpout
4440- QUERY PLAN
4441---------------------------------------------------------------------------------------
4440+ QUERY PLAN
4441+----------------
44424442 Nested Loop (cost=xxx rows=1 width=xxx)
44434443 -> Nested Loop (cost=xxx rows=1 width=xxx)
44444444 Join Filter: (t2.c1 = "*VALUES*_1".column1)
@@ -4474,8 +4474,8 @@ Rows(*VALUES* t1 t2 t3 #2)
44744474
44754475 \o
44764476 \! sql/maskout.sh results/ut-R.tmpout
4477- QUERY PLAN
4478---------------------------------------------------------------------------------------
4477+ QUERY PLAN
4478+----------------
44794479 Nested Loop (cost=xxx rows=1 width=xxx)
44804480 -> Nested Loop (cost=xxx rows=1 width=xxx)
44814481 Join Filter: (t2.c1 = "*VALUES*_1".column1)
@@ -4498,8 +4498,8 @@ Rows(*VALUES* t1 t2 t3 #2)
44984498 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;
44994499 \o
45004500 \! sql/maskout.sh results/ut-R.tmpout
4501- QUERY PLAN
4502-------------------------------------------------------------------------------------------------------
4501+ QUERY PLAN
4502+----------------
45034503 Aggregate (cost=xxx rows=1 width=xxx)
45044504 -> Nested Loop (cost=xxx rows=100 width=xxx)
45054505 -> Merge Join (cost=xxx rows=100 width=xxx)
@@ -4531,8 +4531,8 @@ error hint:
45314531
45324532 \o
45334533 \! sql/maskout.sh results/ut-R.tmpout
4534- QUERY PLAN
4535------------------------------------------------------------------------------------------
4534+ QUERY PLAN
4535+----------------
45364536 Merge Join (cost=xxx rows=70 width=xxx)
45374537 Merge Cond: (bmt1.c1 = bmt2.c1)
45384538 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=xxx)
@@ -4554,8 +4554,8 @@ error hint:
45544554 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;
45554555 \o
45564556 \! sql/maskout.sh results/ut-R.tmpout
4557- QUERY PLAN
4558-------------------------------------------------------------------------------------------------
4557+ QUERY PLAN
4558+----------------
45594559 Nested Loop (cost=xxx rows=100 width=xxx)
45604560 -> Merge Join (cost=xxx rows=100 width=xxx)
45614561 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -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 rows=60 width=xxx)
45924592 Merge Cond: (bmt1.c1 = bmt2.c1)
45934593 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=xxx)
@@ -4609,8 +4609,8 @@ error hint:
46094609 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;
46104610 \o
46114611 \! sql/maskout.sh results/ut-R.tmpout
4612- QUERY PLAN
4613-------------------------------------------------------------------------------------------------
4612+ QUERY PLAN
4613+----------------
46144614 Nested Loop (cost=xxx rows=100 width=xxx)
46154615 -> Merge Join (cost=xxx rows=100 width=xxx)
46164616 Merge Cond: (bmt1.c1 = bmt2.c1)
@@ -4641,8 +4641,8 @@ error hint:
46414641
46424642 \o
46434643 \! sql/maskout.sh results/ut-R.tmpout
4644- QUERY PLAN
4645------------------------------------------------------------------------------------------
4644+ QUERY PLAN
4645+----------------
46464646 Merge Join (cost=xxx rows=50 width=xxx)
46474647 Merge Cond: (bmt1.c1 = bmt2.c1)
46484648 -> Index Only Scan using t1_i1 on t1 bmt1 (cost=xxx rows=1000 width=xxx)
@@ -4676,8 +4676,8 @@ error hint:
46764676
46774677 \o
46784678 \! sql/maskout.sh results/ut-R.tmpout
4679- QUERY PLAN
4680----------------------------------------------------------------------------
4679+ QUERY PLAN
4680+----------------
46814681 Merge Join (cost=xxx rows=1 width=xxx)
46824682 Merge Cond: (t1.c1 = t2.c1)
46834683 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4699,8 +4699,8 @@ error hint:
46994699
47004700 \o
47014701 \! sql/maskout.sh results/ut-R.tmpout
4702- QUERY PLAN
4703----------------------------------------------------------------------------
4702+ QUERY PLAN
4703+----------------
47044704 Merge Join (cost=xxx rows=5 width=xxx)
47054705 Merge Cond: (t1.c1 = t2.c1)
47064706 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4725,8 +4725,8 @@ error hint:
47254725
47264726 \o
47274727 \! sql/maskout.sh results/ut-R.tmpout
4728- QUERY PLAN
4729----------------------------------------------------------------------------
4728+ QUERY PLAN
4729+----------------
47304730 Merge Join (cost=xxx rows=101 width=xxx)
47314731 Merge Cond: (t1.c1 = t2.c1)
47324732 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4748,8 +4748,8 @@ error hint:
47484748
47494749 \o
47504750 \! sql/maskout.sh results/ut-R.tmpout
4751- QUERY PLAN
4752----------------------------------------------------------------------------
4751+ QUERY PLAN
4752+----------------
47534753 Merge Join (cost=xxx rows=99 width=xxx)
47544754 Merge Cond: (t1.c1 = t2.c1)
47554755 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4772,8 +4772,8 @@ error hint:
47724772
47734773 \o
47744774 \! sql/maskout.sh results/ut-R.tmpout
4775- QUERY PLAN
4776----------------------------------------------------------------------------
4775+ QUERY PLAN
4776+----------------
47774777 Merge Join (cost=xxx rows=1 width=xxx)
47784778 Merge Cond: (t1.c1 = t2.c1)
47794779 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4799,8 +4799,8 @@ error hint:
47994799
48004800 \o
48014801 \! sql/maskout.sh results/ut-R.tmpout
4802- QUERY PLAN
4803----------------------------------------------------------------------------
4802+ QUERY PLAN
4803+----------------
48044804 Merge Join (cost=xxx rows=1 width=xxx)
48054805 Merge Cond: (t1.c1 = t2.c1)
48064806 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4822,8 +4822,8 @@ error hint:
48224822
48234823 \o
48244824 \! sql/maskout.sh results/ut-R.tmpout
4825- QUERY PLAN
4826----------------------------------------------------------------------------
4825+ QUERY PLAN
4826+----------------
48274827 Merge Join (cost=xxx rows=200 width=xxx)
48284828 Merge Cond: (t1.c1 = t2.c1)
48294829 -> Index Scan using t1_i1 on t1 (cost=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 rows=10 width=xxx)
48514851 Merge Cond: (t1.c1 = t2.c1)
48524852 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -4863,8 +4863,8 @@ error hint:
48634863 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
48644864 \o
48654865 \! sql/maskout.sh results/ut-R.tmpout
4866- QUERY PLAN
4867--------------------------------------------------------------------------
4866+ QUERY PLAN
4867+----------------
48684868 Hash Join (cost=xxx rows=301 width=xxx)
48694869 Hash Cond: (p2.c1 = p1.c1)
48704870 -> Append (cost=xxx rows=304 width=xxx)
@@ -4898,8 +4898,8 @@ error hint:
48984898
48994899 \o
49004900 \! sql/maskout.sh results/ut-R.tmpout
4901- QUERY PLAN
4902--------------------------------------------------------------------------
4901+ QUERY PLAN
4902+----------------
49034903 Hash Join (cost=xxx rows=1 width=xxx)
49044904 Hash Cond: (p2.c1 = p1.c1)
49054905 -> Append (cost=xxx rows=304 width=xxx)
@@ -4926,8 +4926,8 @@ error hint:
49264926 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
49274927 \o
49284928 \! sql/maskout.sh results/ut-R.tmpout
4929- QUERY PLAN
4930--------------------------------------------------------------------------
4929+ QUERY PLAN
4930+----------------
49314931 Hash Join (cost=xxx rows=301 width=xxx)
49324932 Hash Cond: (p2.c1 = p1.c1)
49334933 -> Append (cost=xxx rows=304 width=xxx)
@@ -4961,8 +4961,8 @@ error hint:
49614961
49624962 \o
49634963 \! sql/maskout.sh results/ut-R.tmpout
4964- QUERY PLAN
4965--------------------------------------------------------------------------
4964+ QUERY PLAN
4965+----------------
49664966 Hash Join (cost=xxx rows=301 width=xxx)
49674967 Hash Cond: (p2.c1 = p1.c1)
49684968 -> Append (cost=xxx rows=304 width=xxx)
@@ -4992,8 +4992,8 @@ error hint:
49924992 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
49934993 \o
49944994 \! sql/maskout.sh results/ut-R.tmpout
4995- QUERY PLAN
4996----------------------------------------------------------------------------
4995+ QUERY PLAN
4996+----------------
49974997 Merge Join (cost=xxx rows=100 width=xxx)
49984998 Merge Cond: (t1.c1 = t2.c1)
49994999 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5017,8 +5017,8 @@ error hint:
50175017
50185018 \o
50195019 \! sql/maskout.sh results/ut-R.tmpout
5020- QUERY PLAN
5021----------------------------------------------------------------------------
5020+ QUERY PLAN
5021+----------------
50225022 Merge Join (cost=xxx rows=1 width=xxx)
50235023 Merge Cond: (t1.c1 = t2.c1)
50245024 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5032,8 +5032,8 @@ error hint:
50325032 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
50335033 \o
50345034 \! sql/maskout.sh results/ut-R.tmpout
5035- QUERY PLAN
5036----------------------------------------------------------------------------
5035+ QUERY PLAN
5036+----------------
50375037 Merge Join (cost=xxx rows=100 width=xxx)
50385038 Merge Cond: (t1.c1 = t2.c1)
50395039 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5060,8 +5060,8 @@ error hint:
50605060
50615061 \o
50625062 \! sql/maskout.sh results/ut-R.tmpout
5063- QUERY PLAN
5064----------------------------------------------------------------------------
5063+ QUERY PLAN
5064+----------------
50655065 Merge Join (cost=xxx rows=1 width=xxx)
50665066 Merge Cond: (t1.c1 = t2.c1)
50675067 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5075,8 +5075,8 @@ error hint:
50755075 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
50765076 \o
50775077 \! sql/maskout.sh results/ut-R.tmpout
5078- QUERY PLAN
5079----------------------------------------------------------------------------
5078+ QUERY PLAN
5079+----------------
50805080 Merge Join (cost=xxx rows=100 width=xxx)
50815081 Merge Cond: (t1.c1 = t2.c1)
50825082 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5100,8 +5100,8 @@ error hint:
51005100
51015101 \o
51025102 \! sql/maskout.sh results/ut-R.tmpout
5103- QUERY PLAN
5104----------------------------------------------------------------------------
5103+ QUERY PLAN
5104+----------------
51055105 Merge Join (cost=xxx rows=1 width=xxx)
51065106 Merge Cond: (t1.c1 = t2.c1)
51075107 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5115,8 +5115,8 @@ error hint:
51155115 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
51165116 \o
51175117 \! sql/maskout.sh results/ut-R.tmpout
5118- QUERY PLAN
5119----------------------------------------------------------------------------
5118+ QUERY PLAN
5119+----------------
51205120 Merge Join (cost=xxx rows=100 width=xxx)
51215121 Merge Cond: (t1.c1 = t2.c1)
51225122 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5143,8 +5143,8 @@ error hint:
51435143
51445144 \o
51455145 \! sql/maskout.sh results/ut-R.tmpout
5146- QUERY PLAN
5147----------------------------------------------------------------------------
5146+ QUERY PLAN
5147+----------------
51485148 Merge Join (cost=xxx rows=1 width=xxx)
51495149 Merge Cond: (t1.c1 = t2.c1)
51505150 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5162,8 +5162,8 @@ SET client_min_messages TO DEBUG1;
51625162 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
51635163 \o
51645164 \! sql/maskout.sh results/ut-R.tmpout
5165- QUERY PLAN
5166----------------------------------------------------------------------------
5165+ QUERY PLAN
5166+----------------
51675167 Merge Join (cost=xxx rows=100 width=xxx)
51685168 Merge Cond: (t1.c1 = t2.c1)
51695169 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
@@ -5185,8 +5185,8 @@ error hint:
51855185
51865186 \o
51875187 \! sql/maskout.sh results/ut-R.tmpout
5188- QUERY PLAN
5189----------------------------------------------------------------------------
5188+ QUERY PLAN
5189+----------------
51905190 Merge Join (cost=xxx rows=101 width=xxx)
51915191 Merge Cond: (t1.c1 = t2.c1)
51925192 -> Index Scan using t1_i1 on t1 (cost=xxx rows=1000 width=xxx)
--- a/expected/ut-S.out
+++ b/expected/ut-S.out
@@ -5260,8 +5260,8 @@ error hint:
52605260 EXPLAIN SELECT c4 FROM s1.p1 WHERE c2 * 2 < 100 AND c1 < 10;
52615261 \o
52625262 \! sql/maskout.sh results/ut-S.tmpout
5263- QUERY PLAN
5264-----------------------------------------------------------
5263+ QUERY PLAN
5264+----------------
52655265 Append (cost=xxx rows=4 width=xxx)
52665266 -> Seq Scan on p1 (cost=xxx rows=1 width=xxx)
52675267 Filter: ((c1 < 10) AND ((c2 * 2) < 100))
@@ -5282,8 +5282,8 @@ error hint:
52825282
52835283 \o
52845284 \! sql/maskout.sh results/ut-S.tmpout
5285- QUERY PLAN
5286-------------------------------------------------------------------------------------
5285+ QUERY PLAN
5286+----------------
52875287 Append (cost=xxx rows=4 width=xxx)
52885288 -> Index Scan using p1_parent on p1 (cost=xxx rows=1 width=xxx)
52895289 Filter: ((c2 * 2) < 100)
@@ -5307,8 +5307,8 @@ error hint:
53075307
53085308 \o
53095309 \! sql/maskout.sh results/ut-S.tmpout
5310- QUERY PLAN
5311-------------------------------------------------------------------------------
5310+ QUERY PLAN
5311+----------------
53125312 Append (cost=xxx rows=4 width=xxx)
53135313 -> Index Scan using p1_i2 on p1 (cost=xxx rows=1 width=xxx)
53145314 Index Cond: (c2 = 1)
@@ -5335,8 +5335,8 @@ error hint:
53355335
53365336 \o
53375337 \! sql/maskout.sh results/ut-S.tmpout
5338- QUERY PLAN
5339----------------------------------------------------------------------------------
5338+ QUERY PLAN
5339+----------------
53405340 Append (cost=xxx rows=3 width=xxx)
53415341 -> Seq Scan on p2 (cost=xxx rows=1 width=xxx)
53425342 Filter: (c1 = 1)
--- a/sql/maskout.sh
+++ b/sql/maskout.sh
@@ -1,4 +1,4 @@
11 #! /bin/sh
22 cat $1 | \
3-sed 's/cost=[\.0-9]*/cost=xxx/;s/width=[0-9]*/width=xxx/' |\
3+sed 's/cost=[\.0-9]*/cost=xxx/;s/width=[0-9]*/width=xxx/;s/^ *QUERY PLAN *$/ QUERY PLAN/;s/^--*$/----------------/' |\
44 grep -v "Planning time:"
Show on old repository browser