This is an automated email from the ASF dual-hosted git repository.

maxyang pushed a change to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git


    from 0faf8e1836 FIX: re-enable the NL-index in ORCA and fix the 
Join2IndexApplyGeneric (#807)
     new aff4a81d68 Derive Combined Hashed Spec For Outer Joins (#13714)
     new b1d2e27ef8 [ORCA] Fix duplicate stats reset (#13817)
     new fc065034df Queries on Distributed Replicated tables hangs when using 
optimizer
     new 0ffc4af83d ORCA Update reset stat to handle cyclic memo path (#13879)
     new b763ec9ce3 Convert ORCA pipelines to use Vault variables (#13907)
     new 32ba45efd1 Derive Combined Hashed Spec For Outer Joins - Patch (#13899)
     new 6e7b4d58e6 Remove WITH OIDS from ORCA code base (#13920)
     new fcb9d008af Fix improper copying of group statistics in Orca (#13926)
     new c34428846e Fix assert op executor node (#13900)
     new a565c9fc7e Derive combined hashed spec outer join master revert 
(#13967)
     new 26c35a8ab1 Enable direct dispatch for DML statements with ORCA (#13471)
     new 463f2fdb8d Remove unused GUC optimizer_enable_partial_index
     new 2034e5e3b2 Remove FIXME label to gut has_oids
     new f5bdc807a7 Remove unused function PdxlnBitmapIndexPathForChildPart()
     new 0e3e7a3b25 Remove ORCA specific duplicate code
     new ac6926d428 Update ordered-set agg preprocess step for skew
     new 5a720a1e7c Allow certain functions to be safely executed on replicated 
slices in Orca (#13873)
     new a76a41736c [ORCA] Fix duplicate cast predicates  (#14061)
     new 0600f616ec [ORCA] Resolve merge FIXMEs in CPartitionPropagationSpec
     new 06d00130c5 Add HashValue function to CPartitionPropagationSpec
     new f4c7f1c37d Address FIXMEs in gpdbwrappers.cpp file (#14104)
     new c9f44457d6 Add exception using unsupported default comparator 
evaulator types
     new b43dfb64bf Allow ORCA to generate DML plans on GENERATED column tables
     new f0a6160d3c [ORCA] Allow empty target list (#14159)
     new 7f6f4a6b60 Derive Combined Hashed Spec For Outer Joins (#14045)
     new 6c289ada59 FIX: Ordered set agg with a ref type column will generate 
coredump
     new 7f919d894c Fix icw test "Derive Combined Hashed Spec For Outer Joins"

The 27 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.


Summary of changes:
 src/backend/gpopt/config/CConfigParamMapping.cpp   |    5 -
 src/backend/gpopt/gpdbwrappers.cpp                 |   42 -
 .../gpopt/translate/CTranslatorDXLToPlStmt.cpp     |   16 +-
 .../gpopt/translate/CTranslatorQueryToDXL.cpp      |   63 +-
 .../gpopt/translate/CTranslatorRelcacheToDXL.cpp   |  149 +-
 src/backend/gpopt/translate/CTranslatorUtils.cpp   |  140 +-
 .../gporca/concourse/test_explain_pipeline.yml     |   46 +-
 .../gporca/concourse/test_orca_pipeline.yml        |    8 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q1.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q10.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q11.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q12.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q13.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q14.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q15.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q16.xml   |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q2.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q3.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q4.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q5.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q6.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q7.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q8.xml    |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q9.xml    |    4 +-
 .../dxl/expressiontests/NullableDroppedColumn.xml  |    2 +-
 ...nFunc-OuterRef-Partition-Order-Frames-Query.xml |    6 +-
 .../WinFunc-OuterRef-Partition-Order-Query.xml     |    6 +-
 .../WinFunc-OuterRef-Partition-Query.xml           |    6 +-
 .../data/dxl/expressiontests/WinFunc-Tests-MD.xml  |    2 +-
 .../gporca/data/dxl/indexjoin/positive_04.mdp      |   12 +-
 src/backend/gporca/data/dxl/metadata/md.xml        |    6 +-
 .../3WayJoinOnMultiDistributionColumnsTables.mdp   |    6 +-
 ...oinOnMultiDistributionColumnsTablesNoMotion.mdp |    6 +-
 .../3WayJoinUsingOperatorsOfNonDefaultOpfamily.mdp |    6 +-
 .../4WayJoinInferredPredsRemovedWith2Motion.mdp    |    8 +-
 .../data/dxl/minidump/AddEqualityPredicates.mdp    |    2 +-
 .../data/dxl/minidump/AddPredsInSubqueries.mdp     |    4 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-1.mdp |    4 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-2.mdp |    2 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-3.mdp |    8 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-4.mdp |    8 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-5.mdp |    6 +-
 src/backend/gporca/data/dxl/minidump/Agg-Limit.mdp |    2 +-
 .../gporca/data/dxl/minidump/Agg-NonSplittable.mdp |    2 +-
 .../gporca/data/dxl/minidump/AggWithSubqArgs.mdp   |    4 +-
 .../data/dxl/minidump/AggWithVolatileFunc.mdp      |    2 +-
 .../gporca/data/dxl/minidump/AggregateWithSkew.mdp |    2 +-
 .../AggregatesConstraintDeriveNegation.mdp         |    2 +-
 .../minidump/AllSubqueryWithSubqueryInScalar.mdp   |    4 +-
 .../data/dxl/minidump/AntiSemiJoin2Select-1.mdp    |    4 +-
 .../data/dxl/minidump/AntiSemiJoin2Select-2.mdp    |    4 +-
 .../AnySubq-With-NonScalarSubqueryChild-1.mdp      |    6 +-
 .../AnySubq-With-NonScalarSubqueryChild-2.mdp      |    6 +-
 .../AnySubq-With-NonScalarSubqueryChild-3.mdp      |    6 +-
 .../AnySubqueryWithAllSubqueryInScalar.mdp         |    6 +-
 .../minidump/AnySubqueryWithSubqueryInScalar.mdp   |    4 +-
 .../dxl/minidump/AnySubqueryWithVolatileComp.mdp   |    4 +-
 .../dxl/minidump/AnySubqueryWithVolatileFunc.mdp   |    4 +-
 .../data/dxl/minidump/ArrayCmp-IN-ManyElements.mdp |    2 +-
 .../data/dxl/minidump/ArrayCmpAll-Disjunct.mdp     |    2 +-
 .../gporca/data/dxl/minidump/ArrayCmpAll.mdp       |    2 +-
 .../gporca/data/dxl/minidump/ArrayCmpAllEmpty.mdp  |    2 +-
 .../gporca/data/dxl/minidump/ArrayCmpAnyEmpty.mdp  |    2 +-
 .../data/dxl/minidump/ArrayCmpAnyEmptyLessThan.mdp |    2 +-
 .../gporca/data/dxl/minidump/ArrayCmpInList.mdp    |    2 +-
 .../gporca/data/dxl/minidump/ArrayCoerceCast.mdp   |    2 +-
 .../gporca/data/dxl/minidump/ArrayCoerceExpr.mdp   |    2 +-
 src/backend/gporca/data/dxl/minidump/ArrayRef.mdp  |    2 +-
 .../gporca/data/dxl/minidump/AssertMaxOneRow.mdp   |    4 +-
 .../dxl/minidump/AssertOneRowWithCorrelation.mdp   |    2 +-
 .../minidump/AvoidConstraintDerivationForLike.mdp  |    2 +-
 .../gporca/data/dxl/minidump/BRINScan-Or.mdp       |    2 +-
 .../dxl/minidump/BTreeIndex-Against-InList.mdp     |    2 +-
 .../minidump/BTreeIndex-Against-InListLarge.mdp    |    2 +-
 .../minidump/BTreeIndex-Against-ScalarSubquery.mdp |    2 +-
 .../gporca/data/dxl/minidump/BitmapBoolAnd.mdp     |    4 +-
 .../data/dxl/minidump/BitmapBoolOp-DeepTree.mdp    |    4 +-
 .../data/dxl/minidump/BitmapBoolOp-DeepTree2.mdp   |    4 +-
 .../data/dxl/minidump/BitmapBoolOp-DeepTree3.mdp   |    4 +-
 .../data/dxl/minidump/BitmapBoolOr-BoolColumn.mdp  |    4 +-
 .../gporca/data/dxl/minidump/BitmapBoolOr.mdp      |    4 +-
 .../dxl/minidump/BitmapIndex-Against-InList.mdp    |    2 +-
 .../dxl/minidump/BitmapIndex-ChooseHashJoin.mdp    |    4 +-
 .../minidump/BitmapIndexApply-Basic-SelfJoin.mdp   |    4 +-
 .../minidump/BitmapIndexApply-Basic-TwoTables.mdp  |    6 +-
 .../BitmapIndexApply-Complex-Condition.mdp         |    6 +-
 .../BitmapIndexApply-InnerSelect-Basic.mdp         |    6 +-
 .../BitmapIndexApply-InnerSelect-PartTable.mdp     |   18 +-
 .../dxl/minidump/BitmapIndexApply-PartTable.mdp    |   18 +-
 .../dxl/minidump/BitmapIndexNLJWithProject.mdp     |   14 +-
 .../minidump/BitmapIndexNLJWithProjectNoFilt.mdp   |   14 +-
 .../dxl/minidump/BitmapIndexNLOJWithProject.mdp    |   14 +-
 .../minidump/BitmapIndexNLOJWithProjectNonPart.mdp |    4 +-
 .../dxl/minidump/BitmapIndexProbeMergeFilters.mdp  |    6 +-
 ...tmapIndexScan-WithUnsupportedOperatorFilter.mdp |    4 +-
 .../gporca/data/dxl/minidump/BitmapIndexScan.mdp   |    6 +-
 .../dxl/minidump/BitmapIndexScanChooseIndex.mdp    |    2 +-
 .../data/dxl/minidump/BitmapIndexScanCost.mdp      |    2 +-
 .../minidump/BitmapIndexUnsupportedOperator.mdp    |    2 +-
 .../BitmapScan-Hetrogeneous-Partitioned.mdp        |    8 +-
 ...BitmapTableScan-AO-Btree-PickIndexWithNoGap.mdp |    2 +-
 .../BitmapTableScan-AO-Btree-PickOnlyHighNDV.mdp   |    2 +-
 .../data/dxl/minidump/BitmapTableScan-AO-Btree.mdp |    4 +-
 .../data/dxl/minidump/BitmapTableScan-AO.mdp       |    4 +-
 .../dxl/minidump/BitmapTableScan-AndCondition.mdp  |    4 +-
 .../data/dxl/minidump/BitmapTableScan-Basic.mdp    |    4 +-
 .../minidump/BitmapTableScan-ColumnOnRightSide.mdp |    4 +-
 .../minidump/BitmapTableScan-ComplexConjDisj.mdp   |    2 +-
 .../BitmapTableScan-ConjDisjWithOuterRefs.mdp      |    4 +-
 .../minidump/Blocking-Spool-Parallel-Union-All.mdp |    8 +-
 .../dxl/minidump/BpCharMCVCardinalityEquals.mdp    |    2 +-
 .../minidump/BpCharMCVCardinalityGreaterThan.mdp   |    2 +-
 .../data/dxl/minidump/BroadcastSkewedHashjoin.mdp  |    4 +-
 .../minidump/BtreeIndexNLJWithProjectNoPart.mdp    |    4 +-
 .../dxl/minidump/BtreeIndexNLOJWithProject.mdp     |   14 +-
 .../CArrayExpansionTest/JoinWithInListExpand.mdp   |    4 +-
 .../CArrayExpansionTest/JoinWithInListNoExpand.mdp |    4 +-
 .../minidump/CJoinOrderDPTest/JoinOrderWithDP.mdp  |   10 +-
 .../CJoinOrderDPTest/JoinOrderWithOutDP.mdp        |   10 +-
 .../FallBackToSerialAppend.mdp                     |    8 +-
 .../NoOpMotionUsesOnlyGroupOutputColumns.mdp       |    2 +-
 .../ParallelAppend-ConstTable.mdp                  |    2 +-
 .../ParallelAppend-Insert.mdp                      |    2 +-
 .../ParallelAppend-Select.mdp                      |    4 +-
 ...arallelUnionAllWithNoRedistributableColumns.mdp |    4 +-
 ...rallelUnionAllWithNotEqualNumOfDistrColumns.mdp |    4 +-
 ...lUnionAllWithSingleNotRedistributableColumn.mdp |    4 +-
 .../RandomDistributedChildrenUnhashableColumns.mdp |    4 +-
 .../RedundantMotionParallelUnionAll.mdp            |    2 +-
 .../TwoHashedTables.mdp                            |    4 +-
 .../AggTopOfSetRefFuncsOnTopTbl.mdp                |    2 +-
 .../dxl/minidump/CPruneColumnsTest/AllColsUsed.mdp |    2 +-
 .../MultiLevelSubqueryWithSetRetFuncs.mdp          |    2 +-
 ...iLevelSubqueryWithSetRetFuncsAndScalarFuncs.mdp |    2 +-
 .../PruneIntermediateUnusedColumns.mdp             |    2 +-
 .../UnusedSetRetFuncAndUsedScalarFunc.mdp          |    2 +-
 .../UsedSetRetFuncAndUnusedScalarFunc.mdp          |    2 +-
 .../gporca/data/dxl/minidump/CSQ-VolatileTVF.mdp   |    2 +-
 .../gporca/data/dxl/minidump/CTAS-Random.mdp       |    8 +-
 .../dxl/minidump/CTAS-With-Global-Local-Agg.mdp    |    8 +-
 ...stributed-from-replicated-distributed-table.mdp |    8 +-
 .../gporca/data/dxl/minidump/CTAS-with-Limit.mdp   |    8 +-
 ...CTAS-with-hashed-distributed-external-table.mdp |    6 +-
 ...AS-with-randomly-distributed-external-table.mdp |    6 +-
 src/backend/gporca/data/dxl/minidump/CTAS.mdp      |    8 +-
 .../dxl/minidump/CTAS_OrderedAgg_multiple_cols.mdp | 1961 +++++++++++---------
 src/backend/gporca/data/dxl/minidump/CTE-1.mdp     |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-10.mdp    |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-11.mdp    |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-2.mdp     |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-3.mdp     |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-6.mdp     |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-7.mdp     |    4 +-
 src/backend/gporca/data/dxl/minidump/CTE-8.mdp     |    2 +-
 src/backend/gporca/data/dxl/minidump/CTE-9.mdp     |    4 +-
 .../minidump/CTE-Join-Redistribute-Producer.mdp    |    2 +-
 .../data/dxl/minidump/CTE-NoPushProperties.mdp     |   24 +-
 .../gporca/data/dxl/minidump/CTE-PartTbl.mdp       |   12 +-
 .../gporca/data/dxl/minidump/CTE-Preds1.mdp        |    2 +-
 .../gporca/data/dxl/minidump/CTE-Preds2.mdp        |    2 +-
 .../data/dxl/minidump/CTE-PushProperties.mdp       |   24 +-
 .../data/dxl/minidump/CTE-with-random-filter.mdp   |    2 +-
 .../dxl/minidump/CTEConstraintDeriveNegation.mdp   |    2 +-
 .../minidump/CTEMergeGroupsCircularDeriveStats.mdp |    4 +-
 .../dxl/minidump/CTEMisAlignedProducerConsumer.mdp |    2 +-
 .../data/dxl/minidump/CTEWithMergedGroup.mdp       |    6 +-
 .../gporca/data/dxl/minidump/CTEinlining.mdp       |    2 +-
 .../dxl/minidump/CannotCollapseCascadeProjects.mdp |    2 +-
 .../data/dxl/minidump/CannotPullGrpColAboveAgg.mdp |    4 +-
 .../data/dxl/minidump/CapGbCardToSelectCard.mdp    |    6 +-
 .../Cascaded-UnionAll-Differing-Cols-Order.mdp     |    6 +-
 .../minidump/Cascaded-UnionAll-Differing-Cols.mdp  |    6 +-
 .../minidump/Cascaded-UnionAll-Same-Cols-Order.mdp |    2 +-
 .../gporca/data/dxl/minidump/CastOnSubquery.mdp    |    4 +-
 .../data/dxl/minidump/CastedInClauseWithMCV.mdp    |    2 +-
 .../dxl/minidump/CastedScalarIf-On-Index-Key.mdp   |    6 +-
 .../gporca/data/dxl/minidump/Char-Cardinality.mdp  |    2 +-
 .../gporca/data/dxl/minidump/CheckAsUser.mdp       |    2 +-
 .../data/dxl/minidump/Citext-Cardinality.mdp       |    2 +-
 .../data/dxl/minidump/Coalesce-With-Subquery.mdp   |    6 +-
 .../gporca/data/dxl/minidump/CoerceToDomain.mdp    |   10 +-
 .../gporca/data/dxl/minidump/CoerceViaIO.mdp       |    2 +-
 .../dxl/minidump/CollapseCascadeProjects2of2.mdp   |    2 +-
 .../dxl/minidump/CollapseCascadeProjects2of3.mdp   |    2 +-
 .../dxl/minidump/CollapseGb-MultipleColumn.mdp     |    2 +-
 .../gporca/data/dxl/minidump/CollapseGb-Nested.mdp |    2 +-
 .../data/dxl/minidump/CollapseGb-SingleColumn.mdp  |    2 +-
 .../dxl/minidump/CollapseGb-With-Agg-Funcs.mdp     |    2 +-
 .../dxl/minidump/CollapseGb-Without-Agg-Funcs.mdp  |    2 +-
 .../gporca/data/dxl/minidump/CollapseNot.mdp       |    2 +-
 .../minidump/CollapseProject-SetReturning-CTE.mdp  |    2 +-
 .../dxl/minidump/CollapseProject-SetReturning.mdp  |    2 +-
 .../data/dxl/minidump/ComputedGroupByCol.mdp       |    2 +-
 .../ConstScalarFuncNotPushedBelowGather.mdp        |    2 +-
 ...onstTblGetUnderSubqUnderProjectWithOuterRef.mdp |    2 +-
 .../ConstTblGetUnderSubqWithNoOuterRef.mdp         |    4 +-
 .../minidump/ConstTblGetUnderSubqWithOuterRef.mdp  |    4 +-
 .../minidump/ConstraintIntervalIncludesNull.mdp    |    2 +-
 .../minidump/ConstraintIntervalNotIncludesNull.mdp |    2 +-
 .../ConstraintIntervalWithBoolIncludesNull.mdp     |    2 +-
 .../ConstraintIntervalWithBoolNotIncludesNull.mdp  |    2 +-
 .../ConstraintIntervalWithInIncludesNull.mdp       |    2 +-
 .../ConstraintIntervalWithInIncludesNullArray.mdp  |    2 +-
 .../ConstraintIntervalWithInNotIncludesNull.mdp    |    2 +-
 ...nstraintIntervalWithMultiColumnsIncludeNull.mdp |    2 +-
 ...raintIntervalWithMultiColumnsNotIncludeNull.mdp |    2 +-
 .../ConstraintIntervalWithNotIncludesNull.mdp      |    2 +-
 ...ConvertBoolConstNullToConstTableFalseFilter.mdp |    2 +-
 .../dxl/minidump/ConvertHashToRandomInsert.mdp     |    6 +-
 .../dxl/minidump/ConvertHashToRandomSelect.mdp     |    4 +-
 .../data/dxl/minidump/Correlated-AntiSemiJoin.mdp  |    4 +-
 .../minidump/Correlated-LASJ-With-Outer-Col.mdp    |    4 +-
 .../minidump/Correlated-LASJ-With-Outer-Const.mdp  |    4 +-
 .../minidump/Correlated-LASJ-With-Outer-Expr.mdp   |    4 +-
 .../data/dxl/minidump/Correlated-SemiJoin.mdp      |    4 +-
 .../dxl/minidump/CorrelatedAntiSemiJoin-True.mdp   |   12 +-
 .../minidump/CorrelatedIN-LeftSemiJoin-Limit.mdp   |    4 +-
 .../minidump/CorrelatedIN-LeftSemiJoin-True.mdp    |    4 +-
 .../minidump/CorrelatedIN-LeftSemiNotIn-True.mdp   |    6 +-
 .../minidump/CorrelatedLeftSemiNLJoinWithLimit.mdp |    4 +-
 .../CorrelatedNLJ-PartSelector-Subplan.mdp         |    8 +-
 .../minidump/CorrelatedNLJWithStreamingSpool.mdp   |    4 +-
 .../minidump/CorrelatedNLJWithTrueCondition.mdp    |    4 +-
 .../data/dxl/minidump/CorrelatedSemiJoin-True.mdp  |   12 +-
 .../CorrelatedSubqueryWithAggWindowFunc.mdp        |    4 +-
 .../dxl/minidump/Correlation-With-Casting-1.mdp    |    2 +-
 .../dxl/minidump/Correlation-With-Casting-2.mdp    |    2 +-
 src/backend/gporca/data/dxl/minidump/CountAny.mdp  |    4 +-
 src/backend/gporca/data/dxl/minidump/CountStar.mdp |    4 +-
 .../minidump/DML-ComputeScalar-With-Outerref.mdp   |    4 +-
 .../data/dxl/minidump/DML-Filter-With-OuterRef.mdp |    4 +-
 .../data/dxl/minidump/DML-Replicated-Input.mdp     |    4 +-
 .../dxl/minidump/DML-UnionAll-With-OuterRef.mdp    |    6 +-
 .../minidump/DML-UnionAll-With-Universal-Child.mdp |    4 +-
 .../data/dxl/minidump/DML-Volatile-Function.mdp    |    4 +-
 ...DML-With-CorrelatedNLJ-With-Universal-Child.mdp |    4 +-
 .../minidump/DML-With-HJ-And-UniversalChild.mdp    |    4 +-
 .../DML-With-Join-With-Universal-Child.mdp         |    4 +-
 .../dxl/minidump/DML-With-MasterOnlyTable-1.mdp    |    4 +-
 .../dxl/minidump/DML-With-WindowFunc-OuterRef.mdp  |   10 +-
 .../data/dxl/minidump/DMLCollapseProject.mdp       |    4 +-
 src/backend/gporca/data/dxl/minidump/DPE-IN.mdp    |   10 +-
 .../gporca/data/dxl/minidump/DPE-NOT-IN.mdp        |   10 +-
 .../gporca/data/dxl/minidump/DPE-SemiJoin.mdp      |   10 +-
 .../dxl/minidump/DPE-with-unsupported-pred.mdp     |   18 +-
 .../gporca/data/dxl/minidump/DPv2GreedyOnly.mdp    |    8 +-
 .../gporca/data/dxl/minidump/DPv2MinCardOnly.mdp   |    8 +-
 .../gporca/data/dxl/minidump/DPv2QueryOnly.mdp     |    8 +-
 .../gporca/data/dxl/minidump/DQA-1-RegularAgg.mdp  |    2 +-
 .../gporca/data/dxl/minidump/DQA-2-RegularAgg.mdp  |    2 +-
 .../dxl/minidump/DQA-GroupBy-HashAggregate1.mdp    |    2 +-
 .../dxl/minidump/DQA-GroupBy-HashAggregate2.mdp    |    2 +-
 .../DQA-InnerJoin-GroupBy-HashAggregate.mdp        |    4 +-
 .../data/dxl/minidump/DQA-KeepOuterReference.mdp   |    2 +-
 .../dxl/minidump/DQA-NonRedistributableCol.mdp     |    2 +-
 .../gporca/data/dxl/minidump/DQA-SplitScalar.mdp   |    2 +-
 .../data/dxl/minidump/DQA-SplitScalarOnDistCol.mdp |    2 +-
 .../dxl/minidump/DQA-SplitScalarWithAggAndGuc.mdp  |    2 +-
 .../data/dxl/minidump/DQA-SplitScalarWithGuc.mdp   |    2 +-
 .../dxl/minidump/DTS-Hetrogeneous-Partitioned.mdp  |    8 +-
 .../data/dxl/minidump/Date-TimeStamp-HashJoin.mdp  |    2 +-
 .../data/dxl/minidump/DeduplicatePredicates.mdp    |    2 +-
 .../dxl/minidump/Delete-With-Limit-In-Subquery.mdp |    4 +-
 .../dxl/minidump/DeleteMismatchedDistribution.mdp  |   14 +-
 .../gporca/data/dxl/minidump/DeleteRandomDistr.mdp |    2 +-
 .../minidump/DeleteRandomlyDistributedTable.mdp    |    2 +-
 .../DeleteRandomlyDistributedTableJoin.mdp         |    4 +-
 .../data/dxl/minidump/DeleteWithTriggers.mdp       |    8 +-
 .../minidump/DirectDispatch-DynamicIndexScan.mdp   |   28 +-
 .../dxl/minidump/DirectDispatch-GpSegmentId.mdp    |    2 +-
 .../data/dxl/minidump/DirectDispatch-IndexScan.mdp |    4 +-
 .../DirectDispatch-MultiCol-Disjunction.mdp        |    2 +-
 .../minidump/DirectDispatch-MultiCol-Negative.mdp  |    2 +-
 .../data/dxl/minidump/DirectDispatch-MultiCol.mdp  |    2 +-
 ...DirectDispatch-SingleCol-Disjunction-IsNull.mdp |    2 +-
 ...rectDispatch-SingleCol-Disjunction-Negative.mdp |    2 +-
 .../DirectDispatch-SingleCol-Disjunction.mdp       |    2 +-
 .../data/dxl/minidump/DirectDispatch-SingleCol.mdp |    2 +-
 .../data/dxl/minidump/Distinct-LegacyOpfamily.mdp  |    2 +-
 .../dxl/minidump/DistinctAgg-NonSplittable.mdp     |    2 +-
 .../dxl/minidump/DonotPushPartConstThruLimit.mdp   |    6 +-
 .../minidump/DontAddRedistributeBeforeInsert-1.mdp |    8 +-
 .../minidump/DontAddRedistributeBeforeInsert-2.mdp |    2 +-
 .../dxl/minidump/DoubleNDVCardinalityEquals.mdp    |    2 +-
 .../gporca/data/dxl/minidump/DqaHavingMax.mdp      |    2 +-
 src/backend/gporca/data/dxl/minidump/DqaMax.mdp    |    2 +-
 src/backend/gporca/data/dxl/minidump/DqaMin.mdp    |    2 +-
 .../gporca/data/dxl/minidump/DqaNoRedistribute.mdp |    2 +-
 .../gporca/data/dxl/minidump/DqaSubqueryMax.mdp    |    2 +-
 .../gporca/data/dxl/minidump/DuplicateGrpCol.mdp   |    2 +-
 .../data/dxl/minidump/DynamicBitmapBoolOp.mdp      |   24 +-
 .../data/dxl/minidump/DynamicBitmapIndexScan.mdp   |   16 +-
 .../dxl/minidump/DynamicBitmapTableScan-Basic.mdp  |   22 +-
 .../DynamicBitmapTableScan-Heterogeneous.mdp       |   24 +-
 .../dxl/minidump/DynamicBitmapTableScan-UUID.mdp   |   10 +-
 .../dxl/minidump/DynamicIndexGet-OuterRefs.mdp     |  336 ++--
 .../dxl/minidump/DynamicIndexGetDroppedCols.mdp    |    2 +-
 .../dxl/minidump/DynamicIndexScan-BoolFalse.mdp    |   24 +-
 .../dxl/minidump/DynamicIndexScan-BoolTrue.mdp     |   24 +-
 .../DynamicIndexScan-DefaultPartition-2.mdp        |   12 +-
 .../minidump/DynamicIndexScan-DefaultPartition.mdp |   12 +-
 .../dxl/minidump/DynamicIndexScan-DroppedCols.mdp  |    8 +-
 .../minidump/DynamicIndexScan-DroppedColumns.mdp   |   28 +-
 ...ndexScan-Heterogenous-EnabledDateConstraint.mdp |   10 +-
 .../DynamicIndexScan-Heterogenous-NoDTS.mdp        |   12 +-
 .../DynamicIndexScan-Heterogenous-Overlapping.mdp  |   12 +-
 ...icIndexScan-Heterogenous-PartSelectEquality.mdp |   24 +-
 ...namicIndexScan-Heterogenous-PartSelectRange.mdp |   24 +-
 .../DynamicIndexScan-Heterogenous-Union.mdp        |   20 +-
 ...ndexScan-Heterogenous-UnsupportedConstraint.mdp |    6 +-
 ...IndexScan-Heterogenous-UnsupportedPredicate.mdp |    4 +-
 .../dxl/minidump/DynamicIndexScan-Heterogenous.mdp |   12 +-
 ...cIndexScan-Homogenous-EnabledDateConstraint.mdp |    6 +-
 ...cIndexScan-Homogenous-UnsupportedConstraint.mdp |    6 +-
 .../dxl/minidump/DynamicIndexScan-Homogenous.mdp   |   20 +-
 .../DynamicIndexScan-OpenEndedPartitions.mdp       |   24 +-
 .../data/dxl/minidump/DynamicIndexScan-Relabel.mdp |   24 +-
 .../data/dxl/minidump/EagerAggEmptyInput.mdp       |    4 +-
 .../data/dxl/minidump/EagerAggExpression.mdp       |    4 +-
 .../dxl/minidump/EagerAggGroupColumnInJoin.mdp     |    8 +-
 .../gporca/data/dxl/minidump/EagerAggMax.mdp       |    4 +-
 .../dxl/minidump/EagerAggMaxWithNestedLoop.mdp     |    6 +-
 .../gporca/data/dxl/minidump/EagerAggMinMax.mdp    |    4 +-
 .../gporca/data/dxl/minidump/EagerAggSubquery.mdp  |    4 +-
 .../data/dxl/minidump/EagerAggUnsupportedAgg.mdp   |    4 +-
 .../data/dxl/minidump/EffectOfLocalPredOnJoin.mdp  |    6 +-
 .../data/dxl/minidump/EffectOfLocalPredOnJoin2.mdp |   24 +-
 .../data/dxl/minidump/EffectOfLocalPredOnJoin3.mdp |   16 +-
 .../data/dxl/minidump/EffectsOfJoinFilter.mdp      |    4 +-
 .../gporca/data/dxl/minidump/EqualityJoin.mdp      |    4 +-
 .../dxl/minidump/EqualityPredicateOverDate.mdp     |    2 +-
 .../data/dxl/minidump/EquiJoinOnExpr-Supported.mdp |    2 +-
 .../dxl/minidump/EquiJoinOnExpr-Unsupported.mdp    |    2 +-
 .../data/dxl/minidump/Equiv-HashedDistr-1.mdp      |    4 +-
 .../data/dxl/minidump/Equiv-HashedDistr-2.mdp      |    4 +-
 .../data/dxl/minidump/EquivClassesIntersect.mdp    |    4 +-
 .../gporca/data/dxl/minidump/EquivClassesLimit.mdp |    2 +-
 .../gporca/data/dxl/minidump/EquivClassesUnion.mdp |    4 +-
 .../Equivalence-class-project-over-LOJ.mdp         |    6 +-
 .../minidump/EstimateJoinRowsForCastPredicates.mdp |    4 +-
 .../ExistentialSubquriesInsideScalarExpression.mdp |    6 +-
 .../dxl/minidump/Exists-SuperfluousEquality.mdp    |    4 +-
 .../data/dxl/minidump/ExistsSubqInsideExpr.mdp     |    4 +-
 .../data/dxl/minidump/ExpandFullOuterJoin.mdp      |    2 +-
 .../gporca/data/dxl/minidump/ExpandJoinOrder.mdp   |   10 +-
 .../minidump/ExpandNAryJoinGreedyWithLOJOnly.mdp   |   14 +-
 .../dxl/minidump/ExprOnScSubqueryWithOuterRef.mdp  |    4 +-
 .../minidump/ExtractOneBindingFromScalarGroups.mdp |    8 +-
 .../data/dxl/minidump/ExtractPredicateFromDisj.mdp |   26 +-
 ...ExtractPredicateFromDisjWithComputedColumns.mdp |    6 +-
 .../data/dxl/minidump/FOJ-Condition-False.mdp      |    2 +-
 .../gporca/data/dxl/minidump/FilterScalarCast.mdp  |    2 +-
 .../gporca/data/dxl/minidump/FoldedArrayCmp.mdp    |    2 +-
 .../minidump/FullJoin-2PredicateOnDistColumns.mdp  |    4 +-
 .../gporca/data/dxl/minidump/FullJoin-Caps.mdp     |    2 +-
 .../FullJoin-InnerNotOnDistributionColumn.mdp      |    4 +-
 .../dxl/minidump/FullJoin-NonDefaultOpfamily.mdp   |    4 +-
 .../minidump/FullJoin-NotOnDistributionColumn.mdp  |    4 +-
 .../data/dxl/minidump/FullJoin-NullPredicate.mdp   |    4 +-
 .../dxl/minidump/FullJoin-OnDistributionColumn.mdp |    4 +-
 .../dxl/minidump/FullJoin-PredicateOnSameTable.mdp |    4 +-
 .../data/dxl/minidump/FullJoin-Replicated.mdp      |    4 +-
 .../FullJoin-Subquery-CastedPredicates.mdp         |    8 +-
 .../dxl/minidump/FullJoin-SubquerySingleton.mdp    |    4 +-
 .../minidump/FullJoin-SubqueryWithRedistribute.mdp |    4 +-
 .../dxl/minidump/FullJoin-SwappedPredicates.mdp    |    4 +-
 .../minidump/FullOuterJoin-NullRejectingLHS1.mdp   |    4 +-
 .../minidump/FullOuterJoin-NullRejectingLHS2.mdp   |    4 +-
 .../gporca/data/dxl/minidump/Gb-on-keys.mdp        |    2 +-
 src/backend/gporca/data/dxl/minidump/GinIndex.mdp  |    2 +-
 .../data/dxl/minidump/GinIndexPathOpfamily.mdp     |    2 +-
 .../data/dxl/minidump/GinIndexSearchModeAll.mdp    |    2 +-
 .../Gist-AOCOTable-NonLossy-BitmapIndexPlan.mdp    |    2 +-
 .../Gist-NestedLoopJoin-Lossy-IndexPlan.mdp        |    4 +-
 .../Gist-NestedLoopJoin-Postgis-IndexPlan.mdp      |    4 +-
 .../Gist-NonPart-Lossy-BitmapIndexPlan.mdp         |    2 +-
 .../dxl/minidump/Gist-NonPart-Lossy-IndexPlan.mdp  |    2 +-
 .../data/dxl/minidump/Gist-OrderBy-BitmapPlan.mdp  |    2 +-
 .../data/dxl/minidump/Gist-OrderBy-IndexPlan.mdp   |    2 +-
 .../minidump/Gist-PartTable-Lossy-IndexPlan.mdp    |    6 +-
 .../Gist-PartTable-NonLossy-BitmapIndexPlan.mdp    |    4 +-
 .../dxl/minidump/Gist-PartialIndex-TableScan.mdp   |    8 +-
 .../data/dxl/minidump/GreedyNAryDelayCrossJoin.mdp |    8 +-
 .../gporca/data/dxl/minidump/GreedyNAryJoin.mdp    |    6 +-
 .../GreedyNAryJoinWithDisconnectedEdges.mdp        |   16 +-
 .../data/dxl/minidump/GreedyNAryOnlyCrossJoins.mdp |    6 +-
 .../data/dxl/minidump/GroupByEmptySetNoAgg.mdp     |    2 +-
 .../gporca/data/dxl/minidump/GroupByOuterRef.mdp   |    4 +-
 .../data/dxl/minidump/GroupingOnSameTblCol-1.mdp   |    8 +-
 .../data/dxl/minidump/GroupingOnSameTblCol-2.mdp   |    4 +-
 .../gporca/data/dxl/minidump/GroupingSets.mdp      |    2 +-
 .../dxl/minidump/HAWQ-TPCH-Stat-Derivation.mdp     |   10 +-
 .../dxl/minidump/HJN-DPE-Bitmap-Outer-Child.mdp    |   46 +-
 .../gporca/data/dxl/minidump/HJN-DeeperOuter.mdp   |    6 +-
 .../dxl/minidump/HJN-Redistribute-One-Side.mdp     |    4 +-
 .../dxl/minidump/HashJoinOnRelabeledColumns.mdp    |    4 +-
 .../data/dxl/minidump/IDF-NotNullConstant.mdp      |    2 +-
 .../gporca/data/dxl/minidump/IDF-NullConstant.mdp  |    2 +-
 .../data/dxl/minidump/IN-Nulls-ArrayCmpAny.mdp     |    2 +-
 .../gporca/data/dxl/minidump/IN-Numeric.mdp        |    4 +-
 src/backend/gporca/data/dxl/minidump/IN.mdp        |    2 +-
 .../data/dxl/minidump/INDF-NotNullConstant.mdp     |    2 +-
 .../gporca/data/dxl/minidump/INDF-NullConstant.mdp |    2 +-
 .../gporca/data/dxl/minidump/InClauseWithMCV.mdp   |    2 +-
 .../gporca/data/dxl/minidump/InEqualityJoin.mdp    |    4 +-
 ...InSubqWithPrjListOuterRefNoInnerRefColumnIn.mdp |    4 +-
 ...hPrjListOuterRefNoInnerRefColumnPlusConstIn.mdp |    4 +-
 .../InSubqWithPrjListOuterRefNoInnerRefConstIn.mdp |    4 +-
 .../data/dxl/minidump/InSubqueryWithNotNullCol.mdp |   16 +-
 .../minidump/Index-Join-With-Subquery-In-Pred.mdp  |    4 +-
 ...dexApply-Heterogeneous-BothSidesPartitioned.mdp |   24 +-
 .../dxl/minidump/IndexApply-Heterogeneous-DTS.mdp  |   18 +-
 .../minidump/IndexApply-Heterogeneous-NoDTS.mdp    |   14 +-
 ...IndexApply-IndexCondDisjointWithHashedDistr.mdp |    6 +-
 ...ndexApply-IndexCondIntersectWithHashedDistr.mdp |    6 +-
 .../IndexApply-IndexCondMatchHashedDistr.mdp       |    6 +-
 .../IndexApply-IndexCondSubsetOfHashedDistr.mdp    |    6 +-
 .../IndexApply-IndexCondSupersetOfHashedDistr.mdp  |    6 +-
 .../minidump/IndexApply-IndexOnMasterOnlyTable.mdp |    6 +-
 .../dxl/minidump/IndexApply-InnerSelect-Basic.mdp  |    6 +-
 .../IndexApply-InnerSelect-Heterogeneous-DTS.mdp   |   18 +-
 .../minidump/IndexApply-InnerSelect-PartTable.mdp  |   18 +-
 .../minidump/IndexApply-InnerSelect-PartTable2.mdp |    8 +-
 .../dxl/minidump/IndexApply-LeftOuter-NLJoin.mdp   |   10 +-
 .../IndexApply-MultiDistKey-WithComplexPreds.mdp   |    4 +-
 ...Apply-MultiDistKeys-Bitmap-WithComplexPreds.mdp |    4 +-
 .../minidump/IndexApply-MultiDistKeys-Bitmap.mdp   |    4 +-
 ...pply-MultiDistKeys-IncompletePDS-3-DistCols.mdp |    4 +-
 .../minidump/IndexApply-No-Motion-Below-Join.mdp   |    4 +-
 .../minidump/IndexApply-PartKey-Is-IndexKey.mdp    |   24 +-
 .../dxl/minidump/IndexApply-PartResolverExpand.mdp |    6 +-
 .../data/dxl/minidump/IndexApply-PartTable.mdp     |   18 +-
 .../IndexApply-Redistribute-Const-Table.mdp        |    4 +-
 .../minidump/IndexApply1-CalibratedCostModel.mdp   |    6 +-
 .../gporca/data/dxl/minidump/IndexApply1.mdp       |    6 +-
 .../gporca/data/dxl/minidump/IndexApply2.mdp       |    6 +-
 .../gporca/data/dxl/minidump/IndexApply3.mdp       |    6 +-
 .../gporca/data/dxl/minidump/IndexApply4.mdp       |    6 +-
 .../IndexApply_NestLoopWithNestParamTrue.mdp       |    4 +-
 .../data/dxl/minidump/IndexGet-OuterRefs.mdp       |    4 +-
 .../dxl/minidump/IndexNLJ-IndexGet-OuterRef.mdp    |    4 +-
 .../dxl/minidump/IndexNLJoin_Cast_NoMotion.mdp     |    8 +-
 ...itionToRootTableContainingHeterogenousIndex.mdp |    8 +-
 ...nLeaf-AddPartitionToRootWithHomogenousIndex.mdp |    8 +-
 ...-IndexOnPartitionsWithDifferentStorageTypes.mdp |    8 +-
 ...verlappingHeterogenousIndex-ANDPredicate-AO.mdp |    2 +-
 ...rlappingHeterogenousIndex-ANDPredicate-HEAP.mdp |    8 +-
 ...pingHomogenousIndexesOnRoot-ANDPredicate-AO.mdp |    2 +-
 ...ppingHomogenousIndexesOnRoot-ORPredicate-AO.mdp |    2 +-
 ...verlappingHeterogenousIndex-ANDPredicate-AO.mdp |    2 +-
 ...rlappingHeterogenousIndex-ANDPredicate-HEAP.mdp |    8 +-
 ...OverlappingHeterogenousIndex-ORPredicate-AO.mdp |    2 +-
 ...pingHomogenousIndexesOnRoot-ANDPredicate-AO.mdp |    2 +-
 ...nLeaf-OverlappingHomogenousIndexesOnRoot-AO.mdp |    2 +-
 ...ppingHomogenousIndexesOnRoot-ORPredicate-AO.mdp |    8 +-
 ...af-SingleColumnHeterogenousIndexOnRoot-1-AO.mdp |    8 +-
 ...-SingleColumnHeterogenousIndexOnRoot-1-HEAP.mdp |    8 +-
 ...af-SingleColumnHeterogenousIndexOnRoot-2-AO.mdp |    2 +-
 ...-SingleColumnHeterogenousIndexOnRoot-2-HEAP.mdp |    8 +-
 .../minidump/IndexOnlyScan-NoDistKeyInIndex.mdp    |    2 +-
 .../gporca/data/dxl/minidump/IndexScan-AOTable.mdp |    4 +-
 .../gporca/data/dxl/minidump/IndexScan-AndedIn.mdp |    2 +-
 .../data/dxl/minidump/IndexScan-BoolFalse.mdp      |    4 +-
 .../data/dxl/minidump/IndexScan-BoolTrue.mdp       |    4 +-
 .../data/dxl/minidump/IndexScan-DroppedColumns.mdp |    2 +-
 .../data/dxl/minidump/IndexScan-ORPredsAOPart.mdp  |   14 +-
 .../data/dxl/minidump/IndexScan-ORPredsNonPart.mdp |    2 +-
 .../gporca/data/dxl/minidump/IndexScan-Relabel.mdp |    4 +-
 .../minidump/IndexScanWithNestedCTEAndSetOp.mdp    |    4 +-
 .../gporca/data/dxl/minidump/IndexedNLJBitmap.mdp  |   12 +-
 .../gporca/data/dxl/minidump/InferPredicates.mdp   |    8 +-
 .../dxl/minidump/InferPredicatesBCC-oid-oid.mdp    |    2 +-
 .../dxl/minidump/InferPredicatesBCC-txt-txt.mdp    |    2 +-
 .../dxl/minidump/InferPredicatesBCC-vc-txt.mdp     |    4 +-
 .../data/dxl/minidump/InferPredicatesBCC-vc-vc.mdp |    2 +-
 .../dxl/minidump/InferPredicatesBCC-vcpart-txt.mdp |    4 +-
 .../data/dxl/minidump/InferPredicatesForLimit.mdp  |    2 +-
 .../data/dxl/minidump/InferPredicatesForPartSQ.mdp |    8 +-
 .../minidump/InferPredicatesForProcessedColumn.mdp |    6 +-
 .../minidump/InferPredicatesForQuantifiedSQ.mdp    |    4 +-
 .../dxl/minidump/InferPredicatesInnerOfLOJ.mdp     |   26 +-
 .../InferredPredicatesConstraintSimplification.mdp |    6 +-
 .../data/dxl/minidump/InnerJoin-With-OuterRefs.mdp |    6 +-
 .../minidump/InnerJoinBroadcastTableHashSpec.mdp   |  529 ++++++
 .../data/dxl/minidump/InnerJoinOverJoinExcept.mdp  |    2 +-
 .../dxl/minidump/InnerJoinOverJoinExceptAll.mdp    |    2 +-
 .../minidump/InnerJoinReplicatedTableHashSpec.mdp  |  535 ++++++
 .../Insert-AO-Partitioned-SortDisabled.mdp         |   14 +-
 .../data/dxl/minidump/Insert-AO-Partitioned.mdp    |   12 +-
 src/backend/gporca/data/dxl/minidump/Insert-AO.mdp |    4 +-
 .../data/dxl/minidump/Insert-With-HJ-CTE-Agg.mdp   |    6 +-
 src/backend/gporca/data/dxl/minidump/Insert.mdp    |    2 +-
 .../gporca/data/dxl/minidump/InsertAssertSort.mdp  |    4 +-
 .../InsertConstTupleRandomDistribution.mdp         |    2 +-
 .../minidump/InsertConstTupleVolatileFunction.mdp  |    2 +-
 .../InsertConstTupleVolatileFunctionMOTable.mdp    |    2 +-
 .../minidump/InsertDirectedDispatchNullValue.mdp   |    2 +-
 .../InsertIntoNonNullAfterDroppingColumn.mdp       |    2 +-
 .../data/dxl/minidump/InsertMasterOnlyTable.mdp    |    4 +-
 .../minidump/InsertMasterOnlyTableConstTuple.mdp   |    2 +-
 .../minidump/InsertMismatchedDistrubution-2.mdp    |   14 +-
 .../dxl/minidump/InsertMismatchedDistrubution.mdp  |   14 +-
 .../dxl/minidump/InsertNULLNotNULLConstraint.mdp   |    2 +-
 .../dxl/minidump/InsertNoEnforceConstraints.mdp    |    2 +-
 .../data/dxl/minidump/InsertNonSingleton.mdp       |    4 +-
 .../gporca/data/dxl/minidump/InsertNotNullCols.mdp |    4 +-
 .../dxl/minidump/InsertPrimaryKeyFromMOTable.mdp   |    4 +-
 .../gporca/data/dxl/minidump/InsertProjectSort.mdp |    2 +-
 .../gporca/data/dxl/minidump/InsertRandomDistr.mdp |    4 +-
 ...ertReplicatedIntoSerialHashDistributedTable.mdp |    4 +-
 .../gporca/data/dxl/minidump/InsertSort.mdp        |    4 +-
 .../minidump/InsertSortDistributed2MasterOnly.mdp  |    4 +-
 .../data/dxl/minidump/InsertWithDroppedCol.mdp     |    4 +-
 .../data/dxl/minidump/InsertWithTriggers.mdp       |    4 +-
 .../gporca/data/dxl/minidump/Int2Predicate.mdp     |    2 +-
 .../data/dxl/minidump/Intersect-OuterRefs.mdp      |    6 +-
 .../data/dxl/minidump/InvalidDeleteGather.mdp      |    6 +-
 .../dxl/minidump/InvalidPlan_CTE-2-all-plans.mdp   |    2 +-
 ...Plan_IncompatibleDistributionOnJoinBranches.mdp |    4 +-
 ...an_MotionGatherFromMasterToMaster-ScalarDQA.mdp |    2 +-
 .../InvalidPlan_MotionGatherFromMasterToMaster.mdp |    4 +-
 .../gporca/data/dxl/minidump/InvalidUpdatePlan.mdp |    4 +-
 .../data/dxl/minidump/IsNullUnionAllIsNotNull.mdp  |    2 +-
 .../dxl/minidump/JOIN-NonRedistributableCol.mdp    |    4 +-
 .../data/dxl/minidump/JOIN-Pred-Cast-Int4.mdp      |    4 +-
 .../data/dxl/minidump/JOIN-Pred-Cast-Varchar.mdp   |    4 +-
 .../JOIN-cast2text-int4-Eq-cast2text-double.mdp    |    4 +-
 .../data/dxl/minidump/JOIN-int4-Eq-double.mdp      |    4 +-
 .../gporca/data/dxl/minidump/JOIN-int4-Eq-int2.mdp |    4 +-
 .../gporca/data/dxl/minidump/Join-Disj-Subqs.mdp   |    6 +-
 src/backend/gporca/data/dxl/minidump/Join-IDF.mdp  |    4 +-
 .../data/dxl/minidump/Join-INDF-NoBroadcast.mdp    |    4 +-
 .../minidump/Join-INDF-Nulls-Not-Collocated.mdp    |    4 +-
 src/backend/gporca/data/dxl/minidump/Join-INDF.mdp |    4 +-
 .../data/dxl/minidump/Join-Varchar-Equality.mdp    |   16 +-
 .../data/dxl/minidump/Join-WinFunc-Preds.mdp       |    4 +-
 .../data/dxl/minidump/Join-With-Subq-Preds-1.mdp   |    4 +-
 .../data/dxl/minidump/Join-With-Subq-Preds-2.mdp   |    4 +-
 .../dxl/minidump/JoinAbsEqWithoutOpfamilies.mdp    |    4 +-
 ...inArityAssociativityCommutativityAboveLimit.mdp |    6 +-
 .../JoinArityAssociativityCommutativityAtLimit.mdp |    6 +-
 ...inArityAssociativityCommutativityBelowLimit.mdp |    6 +-
 .../gporca/data/dxl/minidump/JoinCitextVarchar.mdp |    4 +-
 .../data/dxl/minidump/JoinColWithOnlyNDV.mdp       |    8 +-
 ...nDefaultOpfamiliesUsingNonDefaultOpfamilyOp.mdp |    4 +-
 .../gporca/data/dxl/minidump/JoinNDVRemain.mdp     |    8 +-
 .../dxl/minidump/JoinOnViewWithCastedColumn.mdp    |    4 +-
 ...nViewWithCastedColumnAndSubqueryInPredicate.mdp |    4 +-
 ...ewWithMixOfPushableAndNonpushablePredicates.mdp |    4 +-
 .../minidump/JoinOnViewWithSetReturningColumn.mdp  |    4 +-
 .../dxl/minidump/JoinOnViewWithVolatileColumn.mdp  |    4 +-
 ...nOptimizationLevelGreedyNonPartTblInnerJoin.mdp |    8 +-
 ...inOptimizationLevelQuery3WayHashJoinPartTbl.mdp |   14 +-
 ...inOptimizationLevelQueryNonPartTblInnerJoin.mdp |    8 +-
 .../gporca/data/dxl/minidump/JoinOrderDPE.mdp      |   60 +-
 src/backend/gporca/data/dxl/minidump/JoinPlan.mdp  |    6 +-
 .../data/dxl/minidump/JoinPlanWithRedistribute.mdp |    4 +-
 .../gporca/data/dxl/minidump/JoinTinterval.mdp     |    2 +-
 .../JoinWithSingletonAndSingletonBranches.mdp      |    2 +-
 .../JoinWithSingletonAndUniversalBranches.mdp      |    2 +-
 .../dxl/minidump/Join_OuterChild_DistUniversal.mdp |    2 +-
 .../data/dxl/minidump/LIKE-Pattern-Empty.mdp       |    2 +-
 .../data/dxl/minidump/LIKE-Pattern-green-2.mdp     |    2 +-
 .../data/dxl/minidump/LIKE-Pattern-green.mdp       |    2 +-
 .../data/dxl/minidump/LOJ-Condition-False.mdp      |    2 +-
 .../data/dxl/minidump/LOJ-DynBitmapIndex.mdp       |    8 +-
 .../dxl/minidump/LOJ-DynBitmapIndexWithSelect.mdp  |    8 +-
 .../gporca/data/dxl/minidump/LOJ-DynBtreeIndex.mdp |    8 +-
 .../dxl/minidump/LOJ-DynBtreeIndexWithSelect.mdp   |    8 +-
 ...LOJ-HashJoin-MultiDistKeys-WithComplexPreds.mdp |    4 +-
 .../minidump/LOJ-IndexApply-CompsiteKey-Equiv.mdp  |    6 +-
 .../LOJ-IndexApply-CompsiteKey-NoMotion.mdp        |    6 +-
 .../LOJ-IndexApply-DistKey-Multiple-Predicates.mdp |    6 +-
 .../minidump/LOJ-IndexApply-MasterOnly-Table.mdp   |    8 +-
 ...ly-MultiDistKey-MultiIndexKey-NoExtraFilter.mdp |    6 +-
 .../LOJ-IndexApply-MultiDistKey-MultiIndexKey.mdp  |    6 +-
 ...Apply-MultiDistKeys-Bitmap-WithComplexPreds.mdp |    6 +-
 .../LOJ-IndexApply-MultiDistKeys-Bitmap.mdp        |    4 +-
 .../LOJ-IndexApply-MultiDistKeys-IndexKeys.mdp     |    6 +-
 ...J-IndexApply-MultiDistKeys-WithComplexPreds.mdp |    6 +-
 .../dxl/minidump/LOJ-IndexApply-MultiIndexes.mdp   |    6 +-
 .../LOJ-IndexApply-Negative-NonEqual-Predicate.mdp |    6 +-
 .../dxl/minidump/LOJ-IndexApply-NonDistKey.mdp     |    4 +-
 .../LOJ-IndexApply-WithComplexPredicates.mdp       |    6 +-
 .../gporca/data/dxl/minidump/LOJ-IsNullPred.mdp    |    4 +-
 .../gporca/data/dxl/minidump/LOJ-PushDown.mdp      |    6 +-
 .../gporca/data/dxl/minidump/LOJ-With-Agg.mdp      |  128 +-
 .../dxl/minidump/LOJNonNullRejectingPredicates.mdp |  134 +-
 .../dxl/minidump/LOJNullRejectingPredicates.mdp    |    8 +-
 .../LOJNullRejectingZeroPlacePredicates.mdp        |    4 +-
 .../dxl/minidump/LOJReorderComplexNestedLOJs.mdp   |    8 +-
 .../minidump/LOJReorderWithComplexPredicate.mdp    |    6 +-
 .../gporca/data/dxl/minidump/LOJReorderWithIDF.mdp |    6 +-
 .../minidump/LOJReorderWithNestedLOJAndFilter.mdp  |    6 +-
 .../dxl/minidump/LOJReorderWithOneSidedFilter.mdp  |    6 +-
 .../dxl/minidump/LOJReorderWithSimplePredicate.mdp |    6 +-
 .../gporca/data/dxl/minidump/LOJWithFalsePred.mdp  |    2 +-
 ...DF_no_convert_outer_ref_predicate_with_NULL.mdp |    4 +-
 ..._convert_outer_ref_predicate_with_inner_ref.mdp |    4 +-
 .../gporca/data/dxl/minidump/LOJ_bb_mpph.mdp       |   40 +-
 .../LOJ_convert_to_inner_with_and_predicate.mdp    |    4 +-
 ...J_convert_to_inner_with_inner_predicate_IDF.mdp |    4 +-
 .../LOJ_convert_to_inner_with_or_predicate.mdp     |    4 +-
 ...ert_to_inner_with_inner_predicate_IDF_const.mdp |    4 +-
 ..._convert_to_inner_with_outer_predicate_INDF.mdp |    4 +-
 ...rt_to_inner_with_outer_predicate_INDF_const.mdp |    4 +-
 .../data/dxl/minidump/LargeMultiColumnInList.mdp   |   22 +-
 .../gporca/data/dxl/minidump/Lead-Lag-WinFuncs.mdp |    2 +-
 .../gporca/data/dxl/minidump/Least-Greatest.mdp    |    2 +-
 .../dxl/minidump/LeftJoin-DPv2-With-Select.mdp     |    6 +-
 .../LeftJoin-UnsupportedFilter-Cardinality.mdp     |    6 +-
 .../data/dxl/minidump/LeftJoin-With-Coalesce.mdp   |    6 +-
 .../dxl/minidump/LeftJoin-With-Col-Const-Pred.mdp  |   10 +-
 .../dxl/minidump/LeftJoin-With-Pred-On-Inner2.mdp  |    4 +-
 .../minidump/LeftJoinBroadcastTableHashSpec.mdp    |  613 ++++++
 .../data/dxl/minidump/LeftJoinDPv2JoinOrder.mdp    |    8 +-
 .../dxl/minidump/LeftJoinNullsNotColocated.mdp     |  584 ++++++
 .../LeftOuter2InnerUnionAllAntiSemiJoin-Tpcds.mdp  |    6 +-
 .../LeftOuter2InnerUnionAllAntiSemiJoin.mdp        |    4 +-
 .../dxl/minidump/LikePredStatsNotComparable.mdp    |    2 +-
 .../data/dxl/minidump/ListPartLossyCastEq.mdp      |    8 +-
 .../data/dxl/minidump/ListPartLossyCastLT.mdp      |    8 +-
 .../data/dxl/minidump/ListPartLossyCastNEq.mdp     |    2 +-
 .../dxl/minidump/LogicalIndexGetDroppedCols.mdp    |    2 +-
 .../data/dxl/minidump/MDQA-SameDQAColumn.mdp       |    2 +-
 .../data/dxl/minidump/MDQAs-Grouping-OrderBy.mdp   |    2 +-
 .../gporca/data/dxl/minidump/MDQAs-Grouping.mdp    |    2 +-
 .../gporca/data/dxl/minidump/MDQAs-Union.mdp       |    2 +-
 src/backend/gporca/data/dxl/minidump/MDQAs1.mdp    |    2 +-
 .../gporca/data/dxl/minidump/MS-UnionAll-1.mdp     |   78 +-
 .../gporca/data/dxl/minidump/MS-UnionAll-2.mdp     |   78 +-
 .../gporca/data/dxl/minidump/MS-UnionAll-4.mdp     |   78 +-
 .../gporca/data/dxl/minidump/MS-UnionAll-5.mdp     |   18 +-
 .../gporca/data/dxl/minidump/MS-UnionAll-6.mdp     |   18 +-
 .../gporca/data/dxl/minidump/MS-UnionAll-7.mdp     |   18 +-
 .../data/dxl/minidump/ManyTextUnionsInSubquery.mdp |    4 +-
 .../data/dxl/minidump/MissingBoolColStats.mdp      |    2 +-
 .../gporca/data/dxl/minidump/MissingStats.mdp      |    2 +-
 .../MotionHazard-MaterializeUnderResult.mdp        |    6 +-
 ...MotionHazard-NoMaterializeGatherUnderResult.mdp |    6 +-
 ...otionHazard-NoMaterializeHashAggUnderResult.mdp |    6 +-
 .../MotionHazard-NoMaterializeSortUnderResult.mdp  |    6 +-
 .../MultiColumnAggWithDefaultOpfamilies.mdp        |    4 +-
 ...tiColumnDQA-InnerJoin-GroupBy-HashAggregate.mdp |    4 +-
 .../dxl/minidump/MultiDistKeyJoinCardinality.mdp   |    4 +-
 .../MultiDistKeyWithOtherPredsJoinCardinality.mdp  |    4 +-
 .../dxl/minidump/MultiLevel-NOT-IN-Subquery.mdp    |    6 +-
 .../dxl/minidump/MultiLevelPartLossyCastNEq.mdp    |    2 +-
 .../minidump/MultipleDampedPredJoinCardinality.mdp |    4 +-
 .../MultipleIndependentPredJoinCardinality.mdp     |    6 +-
 .../data/dxl/minidump/MultipleIndexPredicate.mdp   |    2 +-
 .../minidump/MultipleSubqueriesInSelectClause.mdp  |    2 +-
 .../minidump/MultipleUpdateWithJoinOnDistCol.mdp   |   10 +-
 .../data/dxl/minidump/NLJ-BC-Outer-Spool-Inner.mdp |    2 +-
 .../dxl/minidump/NLJ-Broadcast-DPE-Outer-Child.mdp |    8 +-
 .../data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp |    4 +-
 .../dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp     |    4 +-
 .../NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp  |    4 +-
 .../NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp  |    4 +-
 .../data/dxl/minidump/NLJ-Rewindability-CTAS.mdp   |    6 +-
 .../data/dxl/minidump/NOT-IN-NotNullBoth.mdp       |    2 +-
 .../gporca/data/dxl/minidump/NOT-IN-NullInner.mdp  |    4 +-
 .../gporca/data/dxl/minidump/NOT-IN-NullOuter.mdp  |    4 +-
 .../gporca/data/dxl/minidump/Name-Cardinality.mdp  |    2 +-
 .../dxl/minidump/NaryWithLojAndNonLojChilds.mdp    |   10 +-
 .../data/dxl/minidump/Negative-IndexApply1.mdp     |    4 +-
 .../data/dxl/minidump/Negative-IndexApply2.mdp     |   12 +-
 .../data/dxl/minidump/Nested-Or-Predicates.mdp     |    2 +-
 .../gporca/data/dxl/minidump/Nested-Setops-2.mdp   |    4 +-
 .../gporca/data/dxl/minidump/Nested-Setops.mdp     |    6 +-
 .../NestedInSubqWithPrjListOuterRefNoInnerRef.mdp  |    6 +-
 .../dxl/minidump/NestedNLJWithBlockingSpool.mdp    |    4 +-
 .../NestedProjectCountStarWithOuterRefs.mdp        |    4 +-
 .../data/dxl/minidump/NestedSubqLimitBindings.mdp  |    2 +-
 .../data/dxl/minidump/NewBtreeIndexScanCost.mdp    |    4 +-
 .../NoBroadcastUnderGatherForWindowFunction.mdp    |    2 +-
 .../minidump/NoDistKeyMultiPredJoinCardinality.mdp |    4 +-
 .../dxl/minidump/NoHashAggWithoutPrelimFunc.mdp    |    2 +-
 .../gporca/data/dxl/minidump/NoMissingStats.mdp    |    2 +-
 .../dxl/minidump/NoMissingStatsAfterDroppedCol.mdp |    2 +-
 .../NoMissingStatsAskingForSystemColFOJ.mdp        |    4 +-
 .../dxl/minidump/NoMissingStatsForEmptyTable.mdp   |    2 +-
 .../gporca/data/dxl/minidump/NoMotionsPlan.mdp     |    4 +-
 ...PartConstraint-WhenNoDefaultPartsAndIndices.mdp |    2 +-
 .../data/dxl/minidump/NoPartPropagationPlan.mdp    |   14 +-
 .../minidump/NoPushdownPredicateWithCTEAnchor.mdp  |    2 +-
 .../data/dxl/minidump/NoRedistributeOnAppend.mdp   |    2 +-
 .../gporca/data/dxl/minidump/NoSortPlan.mdp        |    4 +-
 ...ngHomogenousIndexesOnRoot-ANDPredicate-HEAP.mdp |    8 +-
 .../gporca/data/dxl/minidump/NonSingleton.mdp      |    4 +-
 .../gporca/data/dxl/minidump/NonSplittableAgg.mdp  |    2 +-
 .../NotExists-SuperflousOuterRefWithGbAgg.mdp      |    4 +-
 .../dxl/minidump/NotExists-SuperfluousEquality.mdp |    4 +-
 .../gporca/data/dxl/minidump/NotInToLASJ.mdp       |    2 +-
 .../NotWellDefinedDisjunctConjunctPredicates.mdp   |  185 +-
 .../data/dxl/minidump/NullConstant-INDF-Col.mdp    |    2 +-
 .../data/dxl/minidump/NullIf-With-Subquery.mdp     |    4 +-
 .../gporca/data/dxl/minidump/OR-WithIsNullPred.mdp |    2 +-
 src/backend/gporca/data/dxl/minidump/OR.mdp        |    2 +-
 .../OneDistKeyMultiPredJoinCardinality.mdp         |    4 +-
 .../data/dxl/minidump/OneLevel-CorrelatedExec.mdp  |    6 +-
 .../gporca/data/dxl/minidump/OneSegmentGather.mdp  |    2 +-
 .../OptimizerConfigWithSegmentsForCosting.mdp      |    2 +-
 .../gporca/data/dxl/minidump/OrderByNullsFirst.mdp |    2 +-
 .../gporca/data/dxl/minidump/OrderByOuterRef.mdp   |    4 +-
 .../dxl/minidump/OrderedAgg_array_fraction.mdp     |    2 +-
 .../data/dxl/minidump/OrderedAgg_computed_col.mdp  |    2 +-
 .../dxl/minidump/OrderedAgg_multiple_diffcol.mdp   | 1014 +++++-----
 .../dxl/minidump/OrderedAgg_multiple_samecol.mdp   |  491 ++---
 .../OrderedAgg_multiple_samecol_difforderespec.mdp | 1001 +++++-----
 .../gporca/data/dxl/minidump/OrderedAgg_single.mdp |  487 ++---
 .../data/dxl/minidump/OrderedAgg_skewed_data.mdp   |  692 +++++++
 .../data/dxl/minidump/OrderedAgg_with_groupby.mdp  |    2 +-
 .../dxl/minidump/OrderedAgg_with_nonOrderedAgg.mdp | 1025 +++++-----
 .../minidump/OrderedAgg_with_nonconst_fraction.mdp |  422 +++--
 .../data/dxl/minidump/OuterJoin-With-OuterRefs.mdp |    6 +-
 .../minidump/OuterJoinOnViewWithCastedColumn.mdp   |    4 +-
 ...ngHomogenousIndexesOnRoot-ANDPredicate-HEAP.mdp |    8 +-
 .../OverlappingHomogenousIndexesOnRoot-HEAP.mdp    |    8 +-
 .../dxl/minidump/Part-Selection-ConstArray-1.mdp   |    8 +-
 .../dxl/minidump/Part-Selection-ConstArray-2.mdp   |    8 +-
 .../gporca/data/dxl/minidump/Part-Selection-IN.mdp |    8 +-
 .../data/dxl/minidump/Part-Selection-NOT-IN.mdp    |    8 +-
 .../PartConstraint-WhenDefaultPartsAndIndices.mdp  |    2 +-
 ...PartConstraint-WhenIndicesAndNoDefaultParts.mdp |    2 +-
 .../PartConstraint-WithOnlyDefaultPartInfo.mdp     |    2 +-
 .../data/dxl/minidump/PartPredsWithRandom.mdp      |    8 +-
 .../data/dxl/minidump/PartSelectorOnJoinSide.mdp   |   24 +-
 .../data/dxl/minidump/PartSelectorOnJoinSide2.mdp  |   44 +-
 .../PartTbl-AggWithExistentialSubquery.mdp         |  363 +---
 .../data/dxl/minidump/PartTbl-ArrayCoerce.mdp      |    2 +-
 .../gporca/data/dxl/minidump/PartTbl-ArrayIn.mdp   |    6 +-
 .../minidump/PartTbl-AsymmetricRangePredicate.mdp  |    6 +-
 .../dxl/minidump/PartTbl-AvoidRangePred-DPE.mdp    |   52 +-
 .../data/dxl/minidump/PartTbl-CSQ-NonPartKey.mdp   |   12 +-
 .../data/dxl/minidump/PartTbl-CSQ-PartKey.mdp      |   12 +-
 .../dxl/minidump/PartTbl-ComplexPredicate1.mdp     |   22 +-
 .../dxl/minidump/PartTbl-ComplexPredicate2.mdp     |   22 +-
 .../dxl/minidump/PartTbl-ComplexPredicate3.mdp     |   22 +-
 .../dxl/minidump/PartTbl-ComplexPredicate4.mdp     |   22 +-
 .../dxl/minidump/PartTbl-ComplexPredicate5.mdp     |   22 +-
 .../PartTbl-ComplexRangePredicate-DefaultPart.mdp  |    8 +-
 ...PartTbl-ComplexRangePredicate-NoDefaultPart.mdp |    8 +-
 .../minidump/PartTbl-DPE-Correlated-NLOuter.mdp    |    8 +-
 .../data/dxl/minidump/PartTbl-DPE-GroupBy.mdp      |   16 +-
 .../gporca/data/dxl/minidump/PartTbl-DPE-Limit.mdp |   14 +-
 .../dxl/minidump/PartTbl-DPE-WindowFunction.mdp    |   12 +-
 .../gporca/data/dxl/minidump/PartTbl-DPE.mdp       |   16 +-
 .../gporca/data/dxl/minidump/PartTbl-DateTime.mdp  |   10 +-
 .../dxl/minidump/PartTbl-DisablePartSelection.mdp  |   12 +-
 .../minidump/PartTbl-DisablePartSelectionJoin.mdp  |   14 +-
 .../data/dxl/minidump/PartTbl-Disjunction.mdp      |    8 +-
 .../minidump/PartTbl-EqPredicateWithCastRange.mdp  |    8 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ4.mdp       |   24 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ5.mdp       |   18 +-
 .../gporca/data/dxl/minidump/PartTbl-IDFList.mdp   |   12 +-
 .../gporca/data/dxl/minidump/PartTbl-IDFNull.mdp   |   12 +-
 .../data/dxl/minidump/PartTbl-IDFWithCast.mdp      |    8 +-
 .../dxl/minidump/PartTbl-IndexOnDefPartOnly.mdp    |   28 +-
 .../dxl/minidump/PartTbl-IsNotNullPredicate.mdp    |    8 +-
 .../data/dxl/minidump/PartTbl-IsNullPredicate.mdp  |   14 +-
 .../data/dxl/minidump/PartTbl-JoinOverExcept.mdp   |   26 +-
 .../data/dxl/minidump/PartTbl-JoinOverGbAgg-2.mdp  |   18 +-
 .../data/dxl/minidump/PartTbl-JoinOverGbAgg.mdp    |   24 +-
 .../dxl/minidump/PartTbl-JoinOverIntersect.mdp     |   26 +-
 .../data/dxl/minidump/PartTbl-JoinOverUnion-1.mdp  |   26 +-
 .../data/dxl/minidump/PartTbl-JoinOverUnion-2.mdp  |   14 +-
 .../gporca/data/dxl/minidump/PartTbl-LASJ.mdp      |   16 +-
 .../PartTbl-LeftOuterHashJoin-DPE-IsNull.mdp       |    8 +-
 .../PartTbl-LeftOuterNLJoin-DPE-IsNull.mdp         |    8 +-
 .../minidump/PartTbl-List-DPE-Int-Predicates.mdp   |    8 +-
 .../PartTbl-List-DPE-Varchar-Predicates.mdp        |    2 +-
 .../data/dxl/minidump/PartTbl-MultiWayJoin.mdp     |   10 +-
 .../dxl/minidump/PartTbl-MultiWayJoinWithDPE-2.mdp |   24 +-
 .../dxl/minidump/PartTbl-MultiWayJoinWithDPE.mdp   |   38 +-
 .../dxl/minidump/PartTbl-MultipleEqPredicates.mdp  |   14 +-
 .../data/dxl/minidump/PartTbl-NEqPredicate.mdp     |   12 +-
 .../data/dxl/minidump/PartTbl-NonConstSelect.mdp   |   10 +-
 .../dxl/minidump/PartTbl-PredicateWithCast.mdp     |    8 +-
 .../dxl/minidump/PartTbl-PredicateWithCastList.mdp |    8 +-
 .../PartTbl-PredicateWithCastMultiLevelList.mdp    |    2 +-
 .../data/dxl/minidump/PartTbl-RangeJoinPred.mdp    |    4 +-
 .../data/dxl/minidump/PartTbl-Relabel-Equality.mdp |    2 +-
 .../data/dxl/minidump/PartTbl-Relabel-Range.mdp    |    2 +-
 .../PartTbl-RightOuterHashJoin-DPE-IsNull.mdp      |    4 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost1.mdp    |   12 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost2.mdp    |   12 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost3.mdp    |   12 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost4.mdp    |   12 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost5.mdp    |   12 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost1.mdp   |   24 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost2.mdp   |   24 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost3.mdp   |   24 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost4.mdp   |    4 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost5.mdp   |   24 +-
 .../data/dxl/minidump/PartTbl-SubqueryOuterRef.mdp |   24 +-
 .../data/dxl/minidump/PartTbl-VolatileFunc.mdp     |   12 +-
 .../PartTbl-WindowFuncNoDisjunctPredPushDown.mdp   |    2 +-
 .../minidump/PartTbl-WindowFuncNoPredPushDown.mdp  |    2 +-
 .../PartTbl-WindowFuncPartialPredPushDown.mdp      |    2 +-
 .../minidump/PartTbl-WindowFuncPredPushDown.mdp    |    2 +-
 .../PartTbl-WindowFuncSinglePredPushDown.mdp       |    2 +-
 .../data/dxl/minidump/PartTbl-WindowFunction.mdp   |   12 +-
 .../data/dxl/minidump/PredStatsNotComparable.mdp   |    2 +-
 .../PredicateWithConjunctsAndDisjuncts.mdp         |    2 +-
 .../minidump/PredicateWithConjunctsOfDisjuncts.mdp |    2 +-
 .../dxl/minidump/PredicateWithLongConjunction.mdp  |    2 +-
 .../data/dxl/minidump/Preds-Over-WinFunc1.mdp      |    2 +-
 .../data/dxl/minidump/Preds-Over-WinFunc2.mdp      |    2 +-
 .../data/dxl/minidump/Preds-Over-WinFunc3.mdp      |    2 +-
 .../data/dxl/minidump/Preds-Over-WinFunc4.mdp      |    2 +-
 .../data/dxl/minidump/Preds-Over-WinFunc5.mdp      |    2 +-
 .../gporca/data/dxl/minidump/ProjectCountStar.mdp  |    4 +-
 .../dxl/minidump/ProjectCountStarWithOuterRefs.mdp |    4 +-
 .../data/dxl/minidump/ProjectOutsideCountStar.mdp  |    4 +-
 .../data/dxl/minidump/ProjectRepeatedColumn1.mdp   |    2 +-
 .../data/dxl/minidump/ProjectRepeatedColumn2.mdp   |    2 +-
 .../data/dxl/minidump/ProjectSetFunction.mdp       |    2 +-
 .../gporca/data/dxl/minidump/ProjectUnderSubq.mdp  |    4 +-
 .../data/dxl/minidump/ProjectWithConstant.mdp      |    2 +-
 .../data/dxl/minidump/ProjectWithTextConstant.mdp  |    2 +-
 .../data/dxl/minidump/Push-Subplan-Below-Union.mdp |    4 +-
 .../dxl/minidump/PushFilterToSemiJoinLeftChild.mdp |    4 +-
 .../dxl/minidump/PushGbBelowJoin-NegativeCase.mdp  |    2 +-
 .../data/dxl/minidump/PushGbBelowNaryUnion-1.mdp   |    6 +-
 .../data/dxl/minidump/PushGbBelowNaryUnion-2.mdp   |    6 +-
 .../data/dxl/minidump/PushGbBelowNaryUnionAll.mdp  |    6 +-
 .../gporca/data/dxl/minidump/PushGbBelowUnion.mdp  |    4 +-
 .../data/dxl/minidump/PushGbBelowUnionAll.mdp      |    4 +-
 .../minidump/PushSelectWithOuterRefBelowUnion.mdp  |   14 +-
 ...ueryMismatchedDistribution-DynamicIndexScan.mdp |   24 +-
 .../dxl/minidump/QueryMismatchedDistribution.mdp   |   12 +-
 .../RangePartLossyCastEqInPartitionRange.mdp       |   22 +-
 .../RangePartLossyCastEqOnEndPartitionRange.mdp    |   22 +-
 .../RangePartLossyCastLTEqInPartitionRange.mdp     |   22 +-
 .../RangePartLossyCastLTEqOnEndPartitionRange.mdp  |   22 +-
 .../RangePartLossyCastLTInPartitionRange.mdp       |   22 +-
 .../RangePartLossyCastLTOnEndPartitionRange.mdp    |   22 +-
 .../dxl/minidump/Remove-Distinct-From-Subquery.mdp |    4 +-
 .../minidump/RemoveImpliedPredOnBCCPredicates.mdp  |    2 +-
 .../data/dxl/minidump/RemoveUnusedProjElements.mdp |    2 +-
 .../minidump/RemoveUnusedProjElementsInGbAgg.mdp   |    2 +-
 .../dxl/minidump/ReplicatedHashJoinReplicated.mdp  |    4 +-
 .../ReplicatedJoinHashDistributedTable.mdp         |    4 +-
 .../minidump/ReplicatedJoinPartitionedTable.mdp    |   14 +-
 .../ReplicatedJoinRandomDistributedTable.mdp       |    4 +-
 .../minidump/ReplicatedLOJHashDistributedTable.mdp |    4 +-
 .../ReplicatedLOJRandomDistributedTable.mdp        |    4 +-
 .../data/dxl/minidump/ReplicatedLOJReplicated.mdp  |    4 +-
 .../data/dxl/minidump/ReplicatedNLJReplicated.mdp  |    4 +-
 .../data/dxl/minidump/ReplicatedTable-CTAS.mdp     |    6 +-
 .../data/dxl/minidump/ReplicatedTableAggregate.mdp |    2 +-
 .../data/dxl/minidump/ReplicatedTableCTE.mdp       |    4 +-
 .../data/dxl/minidump/ReplicatedTableGroupBy.mdp   |  117 +-
 .../data/dxl/minidump/ReplicatedTableInClause.mdp  |  131 +-
 .../data/dxl/minidump/ReplicatedTableInsert.mdp    |    2 +-
 .../data/dxl/minidump/ReplicatedTableSelect.mdp    |    2 +-
 .../dxl/minidump/ReplicatedTableSequenceInsert.mdp |    4 +-
 ...alar.mdp => ReplicatedTableWithAggNoMotion.mdp} |  407 ++--
 .../data/dxl/minidump/RightJoinBothReplicated.mdp  |    4 +-
 .../gporca/data/dxl/minidump/RightJoinDPS.mdp      |    4 +-
 .../gporca/data/dxl/minidump/RightJoinHashed.mdp   |    4 +-
 .../data/dxl/minidump/RightJoinNoDPSNonDistKey.mdp |   26 +-
 .../data/dxl/minidump/RightJoinRedistribute.mdp    |    6 +-
 .../data/dxl/minidump/RightJoinReplicated.mdp      |    4 +-
 .../gporca/data/dxl/minidump/RightJoinTVF.mdp      |    2 +-
 .../gporca/data/dxl/minidump/RollupNoAgg.mdp       |    2 +-
 .../data/dxl/minidump/ScSubqueryWithOuterRef.mdp   |    4 +-
 .../minidump/ScalarCorrelatedSubqueryCountStar.mdp |    4 +-
 .../dxl/minidump/ScalarDQAWithNonScalarAgg.mdp     |    2 +-
 .../dxl/minidump/ScalarFuncPushedBelowGather.mdp   |    2 +-
 .../data/dxl/minidump/ScalarSubqueryCountStar.mdp  |    4 +-
 .../dxl/minidump/ScalarSubqueryCountStarInJoin.mdp |    6 +-
 .../data/dxl/minidump/Select-Over-PartTbl.mdp      |   10 +-
 .../data/dxl/minidump/SelectCheckConstraint.mdp    |    4 +-
 .../gporca/data/dxl/minidump/SelectOnBpchar.mdp    |    2 +-
 .../gporca/data/dxl/minidump/SelectOnCastedCol.mdp |    4 +-
 .../data/dxl/minidump/Self-Comparison-Nullable.mdp |    2 +-
 .../gporca/data/dxl/minidump/Self-Comparison.mdp   |    2 +-
 .../minidump/SelfJoinDampedPredJoinCardinality.mdp |    2 +-
 .../gporca/data/dxl/minidump/SelfUpdate.mdp        |    6 +-
 .../data/dxl/minidump/SemiJoin2InnerJoin.mdp       |    4 +-
 .../gporca/data/dxl/minidump/SemiJoin2Select-1.mdp |    4 +-
 .../gporca/data/dxl/minidump/SemiJoin2Select-2.mdp |    4 +-
 .../minidump/SemiJoin2Select-EnforceSubplan.mdp    |    4 +-
 .../minidump/SemiJoinWithWindowsFuncInSubquery.mdp |    4 +-
 .../dxl/minidump/SimplifyExistsSubquery2Limit.mdp  |    4 +-
 .../SingleColumnHomogenousIndexOnRoot-AO.mdp       |    8 +-
 .../SingleColumnHomogenousIndexOnRoot-HEAP.mdp     |    8 +-
 .../gporca/data/dxl/minidump/SixWayDPv2.mdp        |   12 +-
 .../gporca/data/dxl/minidump/SortOverStreamAgg.mdp |    2 +-
 ...SpoolShouldInvalidateUnresolvedDynamicScans.mdp |   12 +-
 .../gporca/data/dxl/minidump/SqlFuncDmlScalar.mdp  |    4 +-
 .../gporca/data/dxl/minidump/SqlFuncDmlTvf.mdp     |    4 +-
 .../gporca/data/dxl/minidump/SqlFuncNullReject.mdp |    4 +-
 .../data/dxl/minidump/SqlFuncPredFactorize.mdp     |    4 +-
 .../dxl/minidump/Stat-Derivation-Leaf-Pattern.mdp  |    8 +-
 .../minidump/Stats-For-Select-With-Outer-Refs.mdp  |    4 +-
 .../minidump/StatsFilter-AnyWithNewColStats.mdp    |    2 +-
 .../data/dxl/minidump/Subq-JoinWithOuterRef.mdp    |    6 +-
 .../gporca/data/dxl/minidump/Subq-NoParams.mdp     |    4 +-
 .../gporca/data/dxl/minidump/Subq-On-OuterRef.mdp  |    4 +-
 .../data/dxl/minidump/Subq-With-OuterRefCol.mdp    |    4 +-
 .../data/dxl/minidump/Subq2CorrSQInLOJOn.mdp       |    6 +-
 .../data/dxl/minidump/Subq2NotInWhereLOJ.mdp       |    6 +-
 .../data/dxl/minidump/Subq2OuterRef2InJoin.mdp     |    6 +-
 .../dxl/minidump/Subq2OuterRefMultiLevelInOn.mdp   |    6 +-
 .../data/dxl/minidump/Subq2PartialDecorrelate.mdp  |    6 +-
 .../minidump/SubqAll-InsideScalarExpression.mdp    |    4 +-
 .../gporca/data/dxl/minidump/SubqAll-Limit1.mdp    |    4 +-
 .../data/dxl/minidump/SubqAll-To-ScalarSubq.mdp    |    2 +-
 .../minidump/SubqAny-InsideScalarExpression.mdp    |    4 +-
 .../data/dxl/minidump/SubqEnforceSubplan.mdp       |    4 +-
 .../minidump/SubqExists-With-External-Corrs.mdp    |    6 +-
 .../minidump/SubqExists-Without-External-Corrs.mdp |    6 +-
 .../gporca/data/dxl/minidump/SubqInIndexPred.mdp   |    8 +-
 .../dxl/minidump/SubqOuterReferenceInClause.mdp    |    4 +-
 .../dxl/minidump/Subquery-AnyAllAggregates.mdp     |    4 +-
 .../dxl/minidump/Subquery-ExistsAllAggregates.mdp  |    6 +-
 .../Subquery-ExistsAllAggregatesWithDisjuncts.mdp  |    6 +-
 .../data/dxl/minidump/SubqueryInsideScalarIf.mdp   |    6 +-
 .../gporca/data/dxl/minidump/SubqueryNullTest.mdp  |    4 +-
 .../data/dxl/minidump/SubqueryOuterRefLimit.mdp    |    4 +-
 .../data/dxl/minidump/SubqueryOuterRefTVF.mdp      |    2 +-
 .../data/dxl/minidump/Switch-With-Subquery.mdp     |    4 +-
 .../minidump/TPCDS-39-InnerJoin-JoinEstimate.mdp   |    4 +-
 .../data/dxl/minidump/TPCH-Partitioned-256GB.mdp   |   16 +-
 src/backend/gporca/data/dxl/minidump/TPCH-Q5.mdp   |   12 +-
 .../data/dxl/minidump/TVF-With-Deep-Subq-Args.mdp  |    2 +-
 .../gporca/data/dxl/minidump/TVFVolatileJoin.mdp   |    2 +-
 .../data/dxl/minidump/TaintedReplicatedAgg.mdp     |    4 +-
 .../data/dxl/minidump/TaintedReplicatedFilter.mdp  |    2 +-
 .../data/dxl/minidump/TaintedReplicatedLimit.mdp   |    4 +-
 .../dxl/minidump/TaintedReplicatedTablesCTE.mdp    |  565 ++++++
 .../dxl/minidump/TaintedReplicatedWindowAgg.mdp    |    4 +-
 .../data/dxl/minidump/TextMCVCardinalityEquals.mdp |    2 +-
 .../dxl/minidump/TextMCVCardinalityGreaterThan.mdp |    2 +-
 .../ThreeStageAgg-DistinctOnComputedCol.mdp        |    2 +-
 .../minidump/ThreeStageAgg-DistinctOnDistrCol.mdp  |    2 +-
 .../ThreeStageAgg-DistinctOnSameNonDistrCol.mdp    |    2 +-
 ...eeStageAgg-GbMultipleCol-DistinctOnDistrCol.mdp |    2 +-
 .../ThreeStageAgg-GbandDistinctOnDistrCol.mdp      |    2 +-
 ...ThreeStageAgg-ScalarAgg-DistinctComputedCol.mdp |    2 +-
 .../ThreeStageAgg-ScalarAgg-DistinctDistrCol.mdp   |    2 +-
 ...ThreeStageAgg-ScalarAgg-DistinctNonDistrCol.mdp |    2 +-
 .../gporca/data/dxl/minidump/ThreeStageAgg.mdp     |    2 +-
 .../data/dxl/minidump/TimeStamp-Date-HashJoin.mdp  |    2 +-
 .../dxl/minidump/TimeTypeStatsNotComparable.mdp    |    2 +-
 .../dxl/minidump/Tpcds-10TB-Q37-NoIndexJoin.mdp    |   76 +-
 .../data/dxl/minidump/Tpcds-NonPart-Q70a.mdp       |   12 +-
 .../dxl/minidump/TranslateFilterDisjunctQuals.mdp  |    6 +-
 ...thCTEAndTableScanIntoFilterAndOneTimeFilter.mdp |    4 +-
 .../TranslateOneTimeFilterConjunctQuals.mdp        |    6 +-
 .../data/dxl/minidump/TypeModifierArrayRef.mdp     |    2 +-
 .../gporca/data/dxl/minidump/TypeModifierCast.mdp  |    2 +-
 .../data/dxl/minidump/TypeModifierColumn.mdp       |    2 +-
 .../gporca/data/dxl/minidump/UDA-AnyArray.mdp      |    2 +-
 .../gporca/data/dxl/minidump/UDA-AnyElement-1.mdp  |    2 +-
 .../gporca/data/dxl/minidump/UDA-AnyElement-2.mdp  |    2 +-
 .../Union-Distributed-Table-With-Const-Table.mdp   |    2 +-
 .../dxl/minidump/Union-NOT-Plus-OR-Constraint.mdp  |    2 +-
 .../gporca/data/dxl/minidump/Union-On-HJNs.mdp     |   14 +-
 .../minidump/Union-OuterRefs-Casting-Output.mdp    |    4 +-
 .../dxl/minidump/Union-OuterRefs-InnerChild.mdp    |    4 +-
 .../data/dxl/minidump/Union-OuterRefs-Output.mdp   |    4 +-
 .../data/dxl/minidump/Union-Over-UnionAll.mdp      |    2 +-
 .../dxl/minidump/UnionAllCompatibleDataType.mdp    |    6 +-
 .../gporca/data/dxl/minidump/UnionGbSubquery.mdp   |    2 +-
 .../gporca/data/dxl/minidump/UnionOfDQAQueries.mdp |    2 +-
 .../gporca/data/dxl/minidump/UnionWithCTE.mdp      |    2 +-
 .../data/dxl/minidump/UnionWithOuterRefs.mdp       |    4 +-
 .../gporca/data/dxl/minidump/UnnestSQJoins.mdp     |    2 +-
 .../dxl/minidump/UnsupportedStatsPredicate.mdp     |    4 +-
 .../data/dxl/minidump/UpdateCardinalityAssert.mdp  |   10 +-
 .../data/dxl/minidump/UpdateCheckConstraint.mdp    |    8 +-
 .../UpdateDistKeyMismatchedDistribution.mdp        |   20 +-
 .../dxl/minidump/UpdateDistKeyWithNestedJoin.mdp   |    8 +-
 .../gporca/data/dxl/minidump/UpdateDistrKey.mdp    |   10 +-
 .../gporca/data/dxl/minidump/UpdateDroppedCols.mdp |   18 +-
 .../dxl/minidump/UpdateNoCardinalityAssert.mdp     |    8 +-
 .../UpdateNoDistKeyMismatchedDistribution.mdp      |   20 +-
 .../dxl/minidump/UpdateNoEnforceConstraints.mdp    |    6 +-
 .../gporca/data/dxl/minidump/UpdateNotNullCols.mdp |    4 +-
 .../gporca/data/dxl/minidump/UpdatePartTable.mdp   |   18 +-
 .../gporca/data/dxl/minidump/UpdateRandomDistr.mdp |    6 +-
 .../data/dxl/minidump/UpdateUniqueConstraint-2.mdp |   12 +-
 .../data/dxl/minidump/UpdateUniqueConstraint.mdp   |    8 +-
 .../data/dxl/minidump/UpdateVolatileFunction.mdp   |    8 +-
 .../data/dxl/minidump/UpdateWindowGatherMerge.mdp  |    6 +-
 .../data/dxl/minidump/UpdateWithHashJoin.mdp       |   10 +-
 .../gporca/data/dxl/minidump/UpdateWithOids.mdp    |  397 ----
 .../data/dxl/minidump/UpdateWithTriggers.mdp       |    6 +-
 .../gporca/data/dxl/minidump/UpdateZeroRows.mdp    |    8 +-
 .../dxl/minidump/UpdatingDistributionColumn.mdp    |    8 +-
 .../data/dxl/minidump/UpdatingMultipleColumn.mdp   |    8 +-
 .../dxl/minidump/UpdatingNonDistColSameTable.mdp   |    6 +-
 .../minidump/UpdatingNonDistributionColumnFunc.mdp |    6 +-
 .../dxl/minidump/VarcharMCVCardinalityEquals.mdp   |    2 +-
 .../minidump/VarcharMCVCardinalityGreaterThan.mdp  |    2 +-
 .../minidump/VolatileFunctionsBelowScalarAgg.mdp   |    2 +-
 .../WinFunc-Redistribute-Sort-CTE-Producer.mdp     |    2 +-
 .../gporca/data/dxl/minidump/WinFunc-Simple.mdp    |    2 +-
 .../data/dxl/minidump/WinFuncWithSubqArgs.mdp      |    4 +-
 .../data/dxl/minidump/WindowFrame-SingleEdged.mdp  |    2 +-
 .../data/dxl/minidump/cte-duplicate-columns-1.mdp  |    2 +-
 .../data/dxl/minidump/cte-duplicate-columns-2.mdp  |    2 +-
 .../data/dxl/minidump/cte-duplicate-columns-3.mdp  |    2 +-
 .../data/dxl/minidump/cte-duplicate-columns-4.mdp  |    2 +-
 src/backend/gporca/data/dxl/minidump/retail_28.mdp |    4 +-
 .../data/dxl/minidump/window-count-gpdb6.mdp       |    2 +-
 ...tilevel-Casting-cast_boundary_value_to_date.mdp |    2 +-
 ...level-Casting-cast_partition_column_to_text.mdp |    2 +-
 .../Multilevel-Casting-no_casting.mdp              |    2 +-
 .../Multilevel-Casting-predicate-on-all-levels.mdp |    2 +-
 ...ilevel-Casting-predicate-on-non-leaf-levels.mdp |    2 +-
 ...ilevel-Casting-predicate-on-non-root-levels.mdp |    2 +-
 .../Multilevel-ConstPred-AllLevels-Default.mdp     |    2 +-
 .../Multilevel-ConstPred-AllLevels-NoDefault.mdp   |    2 +-
 .../Multilevel-ConstPred-Level1-Default.mdp        |    2 +-
 .../Multilevel-ConstPred-Level1-NoDefault.mdp      |    2 +-
 .../Multilevel-ConstPred-Level2-Default.mdp        |    2 +-
 .../Multilevel-ConstPred-Level2-NoDefault.mdp      |    2 +-
 .../Multilevel-FullScan.mdp                        |    2 +-
 .../Multilevel-JoinPred-AllLevels.mdp              |    4 +-
 .../Multilevel-JoinPred-Level1.mdp                 |    4 +-
 .../Multilevel-JoinPred-Level2.mdp                 |    4 +-
 .../Multilevel-Nary-Join.mdp                       |    6 +-
 .../gporca/data/dxl/parse_tests/q26-Metadata.xml   |   20 +-
 .../gporca/data/dxl/parse_tests/q59-Update.xml     |    2 +-
 .../gporca/data/dxl/parse_tests/q60-DMLUpdate.xml  |    4 +-
 .../data/dxl/parse_tests/q65-LogicalCTASHash.xml   |    2 +-
 .../data/dxl/parse_tests/q66-LogicalCTASRandom.xml |    2 +-
 .../data/dxl/parse_tests/q67-PhysicalCTAS.xml      |    2 +-
 .../include/gpopt/base/CDistributionSpecHashed.h   |   13 +-
 .../gpopt/base/CDistributionSpecNonSingleton.h     |   13 +-
 .../libgpopt/include/gpopt/base/CDrvdPropScalar.h  |    8 +
 .../include/gpopt/base/CPartitionPropagationSpec.h |   49 +-
 .../gporca/libgpopt/include/gpopt/base/CUtils.h    |    5 +
 .../libgpopt/include/gpopt/operators/CExpression.h |    1 +
 .../include/gpopt/operators/CExpressionHandle.h    |    1 +
 .../libgpopt/include/gpopt/operators/CLogicalDML.h |   13 +-
 .../include/gpopt/operators/CLogicalSplit.h        |   13 +-
 .../include/gpopt/operators/CLogicalUpdate.h       |   13 +-
 .../gpopt/operators/COrderedAggPreprocessor.h      |    3 +-
 .../include/gpopt/operators/CPhysicalDML.h         |   13 +-
 .../gpopt/operators/CPhysicalFullMergeJoin.h       |    1 +
 .../include/gpopt/operators/CPhysicalHashJoin.h    |    7 +-
 .../gpopt/operators/CPhysicalInnerHashJoin.h       |    1 +
 .../operators/CPhysicalLeftAntiSemiHashJoin.h      |    1 +
 .../operators/CPhysicalLeftAntiSemiHashJoinNotIn.h |    1 +
 .../gpopt/operators/CPhysicalLeftOuterHashJoin.h   |   10 +
 .../gpopt/operators/CPhysicalLeftSemiHashJoin.h    |    1 +
 .../gpopt/operators/CPhysicalRightOuterHashJoin.h  |    1 +
 .../include/gpopt/operators/CPhysicalSplit.h       |   13 +-
 .../include/gpopt/operators/CScalarProjectList.h   |    3 +
 .../gporca/libgpopt/include/gpopt/search/CMemo.h   |    3 -
 .../include/gpopt/translate/CTranslatorExprToDXL.h |   10 -
 .../libgpopt/include/gpopt/xforms/CXformUtils.h    |   65 +-
 .../libgpopt/src/base/CDefaultComparator.cpp       |    6 +-
 .../libgpopt/src/base/CDistributionSpecHashed.cpp  |  146 +-
 .../src/base/CDistributionSpecNonSingleton.cpp     |    4 +-
 .../gporca/libgpopt/src/base/CDrvdPropScalar.cpp   |   27 +
 .../gporca/libgpopt/src/base/CEnfdDistribution.cpp |    7 +
 .../gporca/libgpopt/src/base/CKeyCollection.cpp    |    2 +-
 .../src/base/CPartitionPropagationSpec.cpp         |   86 +-
 src/backend/gporca/libgpopt/src/base/CUtils.cpp    |   27 +-
 .../gporca/libgpopt/src/mdcache/CMDAccessor.cpp    |    3 +-
 .../gporca/libgpopt/src/operators/CExpression.cpp  |    7 +
 .../libgpopt/src/operators/CExpressionHandle.cpp   |   14 +
 .../src/operators/CExpressionPreprocessor.cpp      |    6 +-
 .../gporca/libgpopt/src/operators/CLogicalDML.cpp  |   29 +-
 .../libgpopt/src/operators/CLogicalSplit.cpp       |   24 +-
 .../libgpopt/src/operators/CLogicalUpdate.cpp      |   23 +-
 .../src/operators/COrderedAggPreprocessor.cpp      |  155 +-
 .../gporca/libgpopt/src/operators/CPhysicalAgg.cpp |    9 +
 .../gporca/libgpopt/src/operators/CPhysicalDML.cpp |   10 +-
 .../src/operators/CPhysicalFullMergeJoin.cpp       |   16 +-
 .../libgpopt/src/operators/CPhysicalHashJoin.cpp   |   18 +-
 .../src/operators/CPhysicalInnerHashJoin.cpp       |    4 +-
 .../operators/CPhysicalLeftAntiSemiHashJoin.cpp    |    4 +-
 .../CPhysicalLeftAntiSemiHashJoinNotIn.cpp         |    5 +-
 .../src/operators/CPhysicalLeftOuterHashJoin.cpp   |  119 +-
 .../src/operators/CPhysicalLeftSemiHashJoin.cpp    |    4 +-
 .../src/operators/CPhysicalRightOuterHashJoin.cpp  |    4 +-
 .../libgpopt/src/operators/CPhysicalSequence.cpp   |   31 +
 .../src/operators/CPhysicalSerialUnionAll.cpp      |    6 +-
 .../libgpopt/src/operators/CPhysicalSplit.cpp      |    9 +-
 .../libgpopt/src/operators/CScalarProjectList.cpp  |   49 +
 src/backend/gporca/libgpopt/src/search/CGroup.cpp  |   19 +-
 src/backend/gporca/libgpopt/src/search/CMemo.cpp   |    2 -
 .../src/translate/CTranslatorDXLToExpr.cpp         |   26 +-
 .../src/translate/CTranslatorExprToDXL.cpp         |  179 +-
 .../gporca/libgpopt/src/xforms/CJoinOrderDP.cpp    |    7 +
 .../xforms/CXformDifference2LeftAntiSemiJoin.cpp   |   32 +-
 .../libgpopt/src/xforms/CXformImplementDML.cpp     |    7 +-
 .../libgpopt/src/xforms/CXformImplementSplit.cpp   |    3 +-
 .../libgpopt/src/xforms/CXformUpdate2DML.cpp       |   16 +-
 .../gporca/libgpopt/src/xforms/CXformUtils.cpp     |   10 +-
 .../include/naucrates/dxl/gpdb_types.h             |    1 +
 .../naucrates/dxl/operators/CDXLLogicalCTAS.h      |   12 +-
 .../naucrates/dxl/operators/CDXLLogicalUpdate.h    |   23 +-
 .../naucrates/dxl/operators/CDXLPhysicalCTAS.h     |    4 -
 .../naucrates/dxl/operators/CDXLPhysicalDML.h      |   21 -
 .../naucrates/dxl/operators/CDXLPhysicalSplit.h    |   23 +-
 .../dxl/parser/CParseHandlerLogicalCTAS.h          |    3 -
 .../dxl/parser/CParseHandlerLogicalUpdate.h        |    6 -
 .../naucrates/dxl/parser/CParseHandlerMDRelation.h |    3 -
 .../dxl/parser/CParseHandlerPhysicalCTAS.h         |    3 -
 .../dxl/parser/CParseHandlerPhysicalDML.h          |    6 -
 .../dxl/parser/CParseHandlerPhysicalSplit.h        |    6 -
 .../include/naucrates/dxl/xml/dxltokens.h          |    2 -
 .../include/naucrates/md/CMDRelationCtasGPDB.h     |   12 +-
 .../include/naucrates/md/CMDRelationGPDB.h         |   29 +-
 .../include/naucrates/md/CMDTypeOidGPDB.h          |    4 +-
 .../include/naucrates/md/IMDRelation.h             |    3 -
 .../include/naucrates/md/IMDRelationExternal.h     |    7 -
 .../include/naucrates/statistics/CStatistics.h     |    3 +-
 .../libnaucrates/src/md/CMDRelationCtasGPDB.cpp    |    5 +-
 .../gporca/libnaucrates/src/md/CMDRelationGPDB.cpp |   19 +-
 .../libnaucrates/src/operators/CDXLLogicalCTAS.cpp |    5 +-
 .../src/operators/CDXLLogicalUpdate.cpp            |   16 +-
 .../src/operators/CDXLPhysicalCTAS.cpp             |    6 +-
 .../libnaucrates/src/operators/CDXLPhysicalDML.cpp |   16 -
 .../src/operators/CDXLPhysicalSplit.cpp            |   17 +-
 .../src/parser/CParseHandlerLogicalCTAS.cpp        |    5 +-
 .../src/parser/CParseHandlerLogicalUpdate.cpp      |   24 +-
 .../src/parser/CParseHandlerMDRelation.cpp         |   13 +-
 .../src/parser/CParseHandlerMDRelationCtas.cpp     |   12 +-
 .../src/parser/CParseHandlerPhysicalCTAS.cpp       |   10 +-
 .../src/parser/CParseHandlerPhysicalDML.cpp        |   33 +-
 .../src/parser/CParseHandlerPhysicalSplit.cpp      |   27 +-
 .../libnaucrates/src/statistics/CStatistics.cpp    |   17 +-
 .../gporca/libnaucrates/src/xml/dxltokens.cpp      |    2 -
 src/backend/gporca/server/CMakeLists.txt           |    7 +-
 src/backend/gporca/server/dxl.xsd                  |    6 -
 .../unittest/dxl/statistics/CStatisticsTest.h      |    3 +
 .../CXformFactoryTest.h => base/CGroupTest.h}      |   28 +-
 src/backend/gporca/server/src/startup/main.cpp     |    6 +-
 .../gporca/server/src/unittest/CTestUtils.cpp      |   11 +-
 .../unittest/dxl/statistics/CStatisticsTest.cpp    |   54 +
 .../unittest/gpopt/base/CDistributionSpecTest.cpp  |  346 +++-
 .../server/src/unittest/gpopt/base/CGroupTest.cpp  |  121 ++
 .../src/unittest/gpopt/minidump/CCastTest.cpp      |    5 +-
 .../src/unittest/gpopt/minidump/CDMLTest.cpp       |    1 -
 src/backend/nodes/copyfuncs.c                      |    1 -
 src/backend/nodes/outfuncs_common.c                |    1 -
 src/backend/nodes/readfast.c                       |    1 -
 src/backend/utils/adt/orderedsetaggs.c             |   36 +-
 src/backend/utils/misc/guc_gp.c                    |   12 -
 src/include/catalog/pg_proc.dat                    |    6 +
 src/include/gpopt/gpdbwrappers.h                   |   11 -
 .../gpopt/translate/CTranslatorRelcacheToDXL.h     |   10 -
 src/include/gpopt/translate/CTranslatorUtils.h     |    9 -
 src/include/nodes/plannodes.h                      |    1 -
 src/include/utils/guc.h                            |    1 -
 src/include/utils/unsync_guc_name.h                |    1 -
 .../output/uao/parallel_delete_optimizer.source    |    6 +-
 src/test/regress/expected/ao_locks_optimizer.out   |    6 +-
 src/test/regress/expected/bfv_joins.out            |  152 ++
 src/test/regress/expected/bfv_joins_optimizer.out  |  150 ++
 src/test/regress/expected/bfv_statistic.out        |   29 +
 .../regress/expected/bfv_statistic_optimizer.out   |   47 +-
 .../regress/expected/direct_dispatch_optimizer.out |   14 +-
 src/test/regress/expected/generated.out            |    2 +
 .../{generated.out => generated_optimizer.out}     |  389 +++-
 src/test/regress/expected/gporca.out               |    6 -
 src/test/regress/expected/gporca_optimizer.out     |   24 +-
 src/test/regress/expected/join_optimizer.out       |   27 +-
 src/test/regress/expected/notin_optimizer.out      |    6 +-
 src/test/regress/expected/qp_with_clause.out       |    2 -
 .../regress/expected/qp_with_clause_optimizer.out  |    2 -
 src/test/regress/expected/rpt.out                  |   85 +
 src/test/regress/expected/rpt_optimizer.out        |  107 +-
 src/test/regress/expected/tidscan_optimizer.out    |   38 +-
 src/test/regress/expected/tsrf_optimizer.out       |    4 +-
 src/test/regress/expected/union.out                |    2 +
 src/test/regress/expected/union_optimizer.out      |  114 +-
 src/test/regress/sql/bfv_joins.sql                 |   30 +
 src/test/regress/sql/bfv_statistic.sql             |   31 +
 src/test/regress/sql/generated.sql                 |    2 +
 src/test/regress/sql/gporca.sql                    |    6 -
 src/test/regress/sql/qp_with_clause.sql            |    2 -
 src/test/regress/sql/rpt.sql                       |   35 +
 src/test/regress/sql/union.sql                     |    3 +
 1184 files changed, 13554 insertions(+), 9210 deletions(-)
 create mode 100644 
src/backend/gporca/data/dxl/minidump/InnerJoinBroadcastTableHashSpec.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/InnerJoinReplicatedTableHashSpec.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/LeftJoinBroadcastTableHashSpec.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/LeftJoinNullsNotColocated.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/OrderedAgg_skewed_data.mdp
 copy src/backend/gporca/data/dxl/minidump/{SqlFuncDmlScalar.mdp => 
ReplicatedTableWithAggNoMotion.mdp} (56%)
 create mode 100644 
src/backend/gporca/data/dxl/minidump/TaintedReplicatedTablesCTE.mdp
 delete mode 100644 src/backend/gporca/data/dxl/minidump/UpdateWithOids.mdp
 copy 
src/backend/gporca/server/include/unittest/gpopt/{xforms/CXformFactoryTest.h => 
base/CGroupTest.h} (57%)
 create mode 100644 
src/backend/gporca/server/src/unittest/gpopt/base/CGroupTest.cpp
 copy src/test/regress/expected/{generated.out => generated_optimizer.out} (64%)


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to