Update tidscan optimizer expected output
The commit removed system column stats from Orca, but forgot to
update the expected output plan.
@@ -146,17 +146,20 @@ EXPLAIN (COSTS OFF)
SELECT t1.ctid, t1.*, t2.ctid, t2.*
FROM tidscan t1 JOIN tidscan t2 ON t1.ctid = t2.ctid WHERE t1.id = 1;
QUERY PLAN
----------------------------------------------------------------
+------------------------------------------------------------------
Gather Motion 3:1 (slice1; segments: 3)
-> Hash Join
Hash Cond: (tidscan.ctid = tidscan_1.ctid)
+ -> Redistribute Motion 3:3 (slice2; segments: 3)
+ Hash Key: tidscan.ctid
-> Seq Scan on tidscan
+ Filter: (id = 1)
-> Hash
- -> Broadcast Motion 3:3 (slice2; segments: 3)
+ -> Redistribute Motion 3:3 (slice3; segments: 3)
+ Hash Key: tidscan_1.ctid
-> Seq Scan on tidscan tidscan_1
- Filter: (id = 1)
Optimizer: Pivotal Optimizer (GPORCA)
-(9 rows)
+(12 rows)
SELECT t1.ctid, t1.*, t2.ctid, t2.*
FROM tidscan t1 JOIN tidscan t2 ON t1.ctid = t2.ctid WHERE t1.id = 1;
@@ -169,17 +172,20 @@ EXPLAIN (COSTS OFF)
SELECT t1.ctid, t1.*, t2.ctid, t2.*
FROM tidscan t1 LEFT JOIN tidscan t2 ON t1.ctid = t2.ctid WHERE t1.id = 1;
QUERY PLAN
-------------------------------------------------------
- Hash Right Join
+------------------------------------------------------------------
+ Gather Motion 3:1 (slice1; segments: 3)
+ -> Hash Left Join
Hash Cond: (tidscan.ctid = tidscan_1.ctid)
- -> Gather Motion 3:1 (slice1; segments: 3)
+ -> Redistribute Motion 3:3 (slice2; segments: 3)
+ Hash Key: tidscan.ctid
-> Seq Scan on tidscan
+ Filter: (id = 1)
-> Hash
- -> Gather Motion 3:1 (slice2; segments: 3)
+ -> Redistribute Motion 3:3 (slice3; segments: 3)
+ Hash Key: tidscan_1.ctid
-> Seq Scan on tidscan tidscan_1
- Filter: (id = 1)
Optimizer: Pivotal Optimizer (GPORCA)
-(9 rows)
+(12 rows)
SELECT t1.ctid, t1.*, t2.ctid, t2.*
FROM tidscan t1 LEFT JOIN tidscan t2 ON t1.ctid = t2.ctid WHERE t1.id = 1;
