Fix pipeline error of DML_over_joins.
Commit failed at case DML_over_joins because
ORCA answer file's format has changed.
This commit fixes this issue.
@@ -1656,10 +1656,10 @@ analyze tab2;
explain (costs off) delete from tab1 using tab2 where tab1.a = tab2.a;
QUERY PLAN
------------------------------------------------------
- Delete
+ Delete on tab1
-> Hash Join
- Hash Cond: (tab1.a = tab2.a)
- -> Seq Scan on tab1
+ Hash Cond: (tab1_1.a = tab2.a)
+ -> Seq Scan on tab1 tab1_1
-> Hash
-> Seq Scan on tab2
Optimizer: Pivotal Optimizer (GPORCA) version 3.86.0
@@ -1670,10 +1670,10 @@ explain (costs off) delete from tab1 using tab2 where tab1.a = tab2.a;
explain (costs off) delete from tab1 using tab2 where tab1.a = tab2.b;
QUERY PLAN
------------------------------------------------------------------
- Delete
+ Delete on tab1
-> Hash Join
- Hash Cond: (tab1.a = tab2.b)
- -> Seq Scan on tab1
+ Hash Cond: (tab1_1.a = tab2.b)
+ -> Seq Scan on tab1 tab1_1
-> Hash
-> Redistribute Motion 3:3 (slice1; segments: 3)
Hash Key: tab2.b
@@ -1685,10 +1685,10 @@ explain (costs off) delete from tab1 using tab2 where tab1.a = tab2.b;
explain (costs off) delete from tab1 using tab2 where tab1.b = tab2.b;
QUERY PLAN
---------------------------------------------------------------
- Delete
+ Delete on tab1
-> Hash Join
- Hash Cond: (tab1.b = tab2.b)
- -> Seq Scan on tab1
+ Hash Cond: (tab1_1.b = tab2.b)
+ -> Seq Scan on tab1 tab1_1
-> Hash
-> Broadcast Motion 3:3 (slice1; segments: 3)
-> Seq Scan on tab2
@@ -1713,21 +1713,21 @@ NOTICE: One or more columns in the following table(s) do not have statistics: t
HINT: For non-partitioned tables, run analyze <table_name>(<column_list>). For partitioned tables, run analyze rootpartition <table_name>(<column_list>). See log for columns missing statistics.
QUERY PLAN
------------------------------------------------------------------------------
- Delete
+ Delete on tab1
-> Result
-> Redistribute Motion 3:3 (slice2; segments: 3)
- Hash Key: tab1.b
+ Hash Key: tab1_1.b
-> Hash Join
- Hash Cond: (tab2.a = tab1.a)
+ Hash Cond: (tab2.a = tab1_1.a)
-> Seq Scan on tab2
-> Hash
-> Redistribute Motion 3:3 (slice1; segments: 3)
- Hash Key: tab1.a
+ Hash Key: tab1_1.a
-> Hash Join
- Hash Cond: (tab3.b = tab1.b)
+ Hash Cond: (tab3.b = tab1_1.b)
-> Seq Scan on tab3
-> Hash
- -> Seq Scan on tab1
+ -> Seq Scan on tab1 tab1_1
Optimizer: Pivotal Optimizer (GPORCA) version 3.86.0
(16 rows)
