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

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


    from b99b12bae7 Error out when create or put role into system_group.
     new c069dfbcb4 Force two-stage local aggregate to remove duplicates
     new ed7d24463b Pass requiredPerms from parse tree to plstmt
     new 19549a23d5 Remove unused partition selector code from Orca (#16054)
     new ff9f7609d0 fix bug of RelabelType in group by clause (#15958)
     new c8344d1a38 Declare ACL mode as a ULONG
     new 33b36471d2 Correct the child order when creating grouping sets for the 
rollup (#16096)
     new 4ea126dd0e Disable some Orca histogram asserts (#16052)
     new 7ba8e15675 [ORCA] Implement dynamic index only scan (#15974)
     new 45267fcfc6 Enhance Orca's cardinality estimation for local aggregate 
(#15992)
     new 45c177bcc3 Enable ORCA to generate IndexScan plans with ScalarArrayOp 
quals
     new a8ac5b3d74 Do not convert IN query to Exists for set returning 
function (#16049)
     new cfa4f8073a Change Query Parameter fallback message in Orca to notice 
type (#16197)
     new d2b4b03762 ORCA initialization refactoring
     new 2b72516adb Fall back to planner for queries on relations with pgvector 
index
     new 7a2b1360d4 Update ORCA ans files for index costing change
     new 67a1bee4dc Fix Orca crash due to improper colref mapping with CTEs 
(#16212)
     new 3c3e5e51c0 [ORCA] Enable index-only scan on AO tables (#16162)
     new 5d86a49b13 Remove unused error messages in Orca
     new d2f3cf97a2 Remove ExmiPlStmt2DXLConversion error label in Orca
     new 85ed090b8f Rename GPORCA and planner optimizer in logging and explain 
output
     new 32f515dd11 Change fallback message from GPORCA to Postgres-based 
planner
     new bb472f913c Update ICW expected files
     new f56a70d47a Remove unused partitioning code in Orca (#16274)
     new 39dd11c2ed Added support for Backward indexscan in ORCA (#16087)
     new 25197b4e1a Refactor string length checks in Orca
     new f3ada177c2 Remove default column information from Orca (#16273)
     new 80fa455a18 Fix redundant sort being enforced on group aggregate 
(#16276)
     new 37224a3d17 [ORCA] Allow index only scan on more index types (#16260)
     new cecc82d567 Fixing column width of partitioned tables (#16282)
     new 08e0b7489c Support FIELDSELECT node from ORCA (#16265)
     new 03eca3430f Correcting derived distribution spec for CPhysicalJoin. 
(#16342)
     new 584db61218 Fix clang-formatting in CPhysicalJoin.cpp and MDP file 
(#16377)
     new 7d0ea5944e [ORCA] Add fallback on relations with 'hnsw' index type 
(#16384)
     new 1c07547b3f Remove check restricting some array casts by orca (#16379)
     new 53ca202d72 Introducing Non-Replicated Distribution Spec
     new 282743a7f1 Optimize string creation in Orca (#16332)
     new 68ad577436 Optimize serialization of IMDId objects in Orca to be lazy 
(#16339)
     new 9374844ee4 Orca memory pool refactoring (#16392)
     new a722fee7cf Remove unused PartIndexId DXL token from Orca (#16418)
     new 9d8d8c29f5 Fix "cache lookup failed for foreign table" for multi-level 
partition table with foreign tables in Orca (#16376)
     new 7e59649b40 [ORCA] Fix bug checking index_can_return() (#16575)
     new fec83a88b0 Fix build && core generated by cherry-pick "index only 
scan, ao support index only scan..."
     new f65e82bcb8 Fix icw tests "index only scan, ao support index only scan, 
rename fallback message..."

The 43 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:
 contrib/auto_explain/expected/auto_explain.out     |    8 +-
 .../expected/auto_explain_optimizer.out            |    9 +-
 contrib/auto_explain/sql/auto_explain.sql          |    4 +-
 contrib/file_fdw/output/file_fdw_optimizer.source  |   56 +-
 contrib/file_fdw/output/gp_file_fdw.source         |    8 +-
 .../file_fdw/output/gp_file_fdw_optimizer.source   |    8 +-
 contrib/pg_trgm/expected/pg_trgm_optimizer.out     |   20 +-
 contrib/postgres_fdw/expected/gp_postgres_fdw.out  |  167 +
 .../expected/gp_postgres_fdw_optimizer.out         |  179 +
 contrib/postgres_fdw/sql/gp_postgres_fdw.sql       |   97 +
 src/backend/access/index/amapi.c                   |   19 +
 src/backend/cdb/cdbplan.c                          |   18 +-
 src/backend/commands/explain.c                     |   37 +-
 src/backend/commands/tablecmds.c                   |    4 +-
 src/backend/executor/Makefile                      |    4 +-
 src/backend/executor/execAmi.c                     |    5 +-
 src/backend/executor/execDynamicIndexes.c          |  326 +
 src/backend/executor/execProcnode.c                |    7 +
 src/backend/executor/nodeDynamicBitmapIndexscan.c  |    3 +-
 src/backend/executor/nodeDynamicIndexOnlyscan.c    |  134 +
 src/backend/executor/nodeDynamicIndexscan.c        |  268 +-
 src/backend/executor/nodeIndexonlyscan.c           |   23 +-
 src/backend/gpopt/CGPOptimizer.cpp                 |   71 +-
 src/backend/gpopt/config/CConfigParamMapping.cpp   |    7 +
 src/backend/gpopt/gpdbwrappers.cpp                 |   69 +-
 .../gpopt/translate/CTranslatorDXLToPlStmt.cpp     |  455 +-
 .../gpopt/translate/CTranslatorDXLToScalar.cpp     |   40 +-
 .../gpopt/translate/CTranslatorQueryToDXL.cpp      |    1 -
 .../gpopt/translate/CTranslatorRelcacheToDXL.cpp   |  338 +-
 .../gpopt/translate/CTranslatorScalarToDXL.cpp     |   61 +-
 src/backend/gpopt/translate/CTranslatorUtils.cpp   |   15 +-
 .../gpopt/utils/CMemoryPoolPallocManager.cpp       |    6 +-
 src/backend/gpopt/utils/COptTasks.cpp              |    1 -
 .../expressiontests/DynamicGetBooleanNotPlan.xml   |    2 +-
 .../dxl/expressiontests/DynamicGetBooleanPlan.xml  |    2 +-
 .../expressiontests/DynamicGetCountStarPlan.xml    |    2 +-
 .../DynamicGetHashJoinOtherKeyPlan.xml             |    2 +-
 .../DynamicGetHashJoinPartKeyPlan.xml              |    2 +-
 .../expressiontests/DynamicGetMultiJoinPlan.xml    |    2 +-
 .../DynamicGetNLJoinOtherKeyPlan.xml               |    2 +-
 .../DynamicGetNLJoinPartKeyPlan.xml                |    2 +-
 .../data/dxl/expressiontests/DynamicGetPlan.xml    |    2 +-
 .../dxl/expressiontests/DynamicGetPointPlan.xml    |    2 +-
 .../expressiontests/DynamicGetRangeSelectPlan1.xml |    2 +-
 .../expressiontests/DynamicGetRangeSelectPlan2.xml |    2 +-
 .../DynamicGetUnionAllOuterJoinPlan.xml            |    4 +-
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q1.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q10.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q11.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q12.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q13.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q14.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q15.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q16.xml   |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q2.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q3.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q4.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q5.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q6.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q7.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q8.xml    |   18 -
 .../dxl/expressiontests/LOJ-TO-InnerJoin-Q9.xml    |   18 -
 .../dxl/expressiontests/NullableDroppedColumn.xml  |    2 -
 .../expressiontests/VolatileWithPartTablePlan.xml  |    2 +-
 ...nFunc-OuterRef-Partition-Order-Frames-Query.xml |   34 +-
 .../WinFunc-OuterRef-Partition-Order-Query.xml     |   34 +-
 .../WinFunc-OuterRef-Partition-Query.xml           |   34 +-
 .../data/dxl/expressiontests/WinFunc-Tests-MD.xml  |   10 -
 .../gporca/data/dxl/indexjoin/positive_04.mdp      |  178 +-
 src/backend/gporca/data/dxl/metadata/md.xml        |  658 +-
 .../3WayJoinOnMultiDistributionColumnsTables.mdp   |   30 -
 ...oinOnMultiDistributionColumnsTablesNoMotion.mdp |   30 -
 .../3WayJoinUsingOperatorsOfNonDefaultOpfamily.mdp |   24 -
 .../4WayJoinInferredPredsRemovedWith2Motion.mdp    |   39 -
 .../data/dxl/minidump/AddEqualityPredicates.mdp    |   10 -
 .../data/dxl/minidump/AddPredsInSubqueries.mdp     |   18 -
 .../dxl/minidump/AddRedistributeBeforeInsert-1.mdp |   18 -
 .../dxl/minidump/AddRedistributeBeforeInsert-2.mdp |    9 -
 .../dxl/minidump/AddRedistributeBeforeInsert-3.mdp |   38 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-4.mdp |   42 +-
 .../dxl/minidump/AddRedistributeBeforeInsert-5.mdp |   29 +-
 src/backend/gporca/data/dxl/minidump/Agg-Limit.mdp |    9 -
 .../gporca/data/dxl/minidump/Agg-NonSplittable.mdp |   23 -
 .../dxl/minidump/AggSubqCollapseFalseFilter.mdp    |   98 -
 .../gporca/data/dxl/minidump/AggWithSubqArgs.mdp   |   18 -
 .../data/dxl/minidump/AggWithVolatileFunc.mdp      |   23 +-
 .../dxl/minidump/AggonExternalTableNoMotion.mdp    |   12 -
 .../gporca/data/dxl/minidump/AggregateWithSkew.mdp |   12 +-
 .../AggregatesConstraintDeriveNegation.mdp         |  122 +-
 .../minidump/AllSubqueryWithSubqueryInScalar.mdp   |   16 -
 .../AllowIndexOnlyScanOnAppendOnlyTable.mdp        |  682 ++
 ...xOnlyScanOnMixedAppendOnlyPartitionedTable.mdp} |  585 +-
 .../AllowIndexOnlyScanOnMixedPartitionedTable.mdp  |  853 +++
 .../data/dxl/minidump/AntiSemiJoin2Select-1.mdp    |   18 -
 .../data/dxl/minidump/AntiSemiJoin2Select-2.mdp    |   18 -
 .../minidump/AnyPredicate-Over-UnionOfConsts.mdp   |   10 +-
 .../AnySubq-With-NonScalarSubqueryChild-1.mdp      |   58 +-
 .../AnySubq-With-NonScalarSubqueryChild-2.mdp      |   46 +-
 .../AnySubq-With-NonScalarSubqueryChild-3.mdp      |   30 -
 .../AnySubqueryWithAllSubqueryInScalar.mdp         |   24 -
 .../minidump/AnySubqueryWithSubqueryInScalar.mdp   |   16 -
 .../dxl/minidump/AnySubqueryWithVolatileComp.mdp   |   16 -
 .../dxl/minidump/AnySubqueryWithVolatileFunc.mdp   |   16 -
 .../data/dxl/minidump/ArrayCmp-IN-ManyElements.mdp |   10 -
 .../data/dxl/minidump/ArrayCmpAll-Disjunct.mdp     |    8 -
 .../gporca/data/dxl/minidump/ArrayCmpAll.mdp       |   23 -
 .../gporca/data/dxl/minidump/ArrayCmpAllEmpty.mdp  |    8 -
 .../gporca/data/dxl/minidump/ArrayCmpAnyEmpty.mdp  |    8 -
 .../data/dxl/minidump/ArrayCmpAnyEmptyLessThan.mdp |    8 -
 .../gporca/data/dxl/minidump/ArrayCmpInList.mdp    |   13 +-
 .../gporca/data/dxl/minidump/ArrayCoerceCast.mdp   |    9 -
 .../gporca/data/dxl/minidump/ArrayCoerceExpr.mdp   |    9 -
 .../data/dxl/minidump/ArrayCoerceImplicitCast.mdp  |   18 -
 src/backend/gporca/data/dxl/minidump/ArrayRef.mdp  |   14 -
 .../gporca/data/dxl/minidump/AssertMaxOneRow.mdp   |   80 +-
 .../dxl/minidump/AssertOneRowWithCorrelation.mdp   |    8 -
 .../minidump/AvoidConstraintDerivationForLike.mdp  |    8 -
 .../gporca/data/dxl/minidump/BRINScan-Or.mdp       |   15 +-
 .../dxl/minidump/BTreeIndex-Against-InList.mdp     |   38 +-
 .../minidump/BTreeIndex-Against-InListLarge.mdp    |   54 +-
 .../minidump/BTreeIndex-Against-ScalarSubquery.mdp |   12 +-
 ...rd-IndexOnlyScan-OrderBy-on-MultiCol-Index.mdp} |  442 +-
 ...ackward-IndexScan-OrderBy-on-MultiCol-Index.mdp |  452 ++
 ...ckward-IndexScan-OrderBy-on-SingleCol-Index.mdp |  405 ++
 .../gporca/data/dxl/minidump/BitmapBoolAnd.mdp     |   30 +-
 .../data/dxl/minidump/BitmapBoolOp-DeepTree.mdp    |   30 +-
 .../data/dxl/minidump/BitmapBoolOp-DeepTree2.mdp   |   32 +-
 .../data/dxl/minidump/BitmapBoolOp-DeepTree3.mdp   |   32 +-
 .../data/dxl/minidump/BitmapBoolOr-BoolColumn.mdp  |   34 +-
 .../gporca/data/dxl/minidump/BitmapBoolOr.mdp      |   30 +-
 .../dxl/minidump/BitmapIndex-Against-InList.mdp    |   10 +-
 .../dxl/minidump/BitmapIndex-ChooseHashJoin.mdp    |   20 +-
 .../minidump/BitmapIndexApply-Basic-SelfJoin.mdp   |   30 +-
 .../minidump/BitmapIndexApply-Basic-TwoTables.mdp  |   44 +-
 .../BitmapIndexApply-Complex-Condition.mdp         |   46 +-
 .../BitmapIndexApply-InnerSelect-Basic.mdp         |   35 +-
 .../BitmapIndexApply-InnerSelect-PartTable.mdp     |  103 +-
 .../dxl/minidump/BitmapIndexApply-PartTable.mdp    |  413 +-
 .../dxl/minidump/BitmapIndexNLJWithProject.mdp     |   80 +-
 .../minidump/BitmapIndexNLJWithProjectNoFilt.mdp   |   80 +-
 .../dxl/minidump/BitmapIndexNLOJWithProject.mdp    |   80 +-
 .../minidump/BitmapIndexNLOJWithProjectNonPart.mdp |   22 +-
 .../dxl/minidump/BitmapIndexProbeMergeFilters.mdp  |   24 +-
 ...tmapIndexScan-WithUnsupportedOperatorFilter.mdp |   30 +-
 .../gporca/data/dxl/minidump/BitmapIndexScan.mdp   |   33 +-
 .../dxl/minidump/BitmapIndexScanChooseIndex.mdp    |   10 +-
 .../data/dxl/minidump/BitmapIndexScanCost.mdp      |  136 +-
 .../minidump/BitmapIndexUnsupportedOperator.mdp    |   16 +-
 .../BitmapScan-Hetrogeneous-Partitioned.mdp        |   43 +-
 ...BitmapTableScan-AO-Btree-PickIndexWithNoGap.mdp |   15 +-
 .../BitmapTableScan-AO-Btree-PickOnlyHighNDV.mdp   |    9 +-
 .../data/dxl/minidump/BitmapTableScan-AO-Btree.mdp |   10 +-
 .../data/dxl/minidump/BitmapTableScan-AO.mdp       |   22 +-
 .../dxl/minidump/BitmapTableScan-AndCondition.mdp  |   24 +-
 .../data/dxl/minidump/BitmapTableScan-Basic.mdp    |   22 +-
 .../minidump/BitmapTableScan-ColumnOnRightSide.mdp |   26 +-
 .../minidump/BitmapTableScan-ComplexConjDisj.mdp   |   14 +-
 .../BitmapTableScan-ConjDisjWithOuterRefs.mdp      |   25 +-
 .../minidump/Blocking-Spool-Parallel-Union-All.mdp |   34 -
 .../dxl/minidump/BpCharMCVCardinalityEquals.mdp    |    8 -
 .../minidump/BpCharMCVCardinalityGreaterThan.mdp   |    8 -
 .../data/dxl/minidump/BroadcastSkewedHashjoin.mdp  |   18 -
 .../minidump/BtreeIndexNLJWithProjectNoPart.mdp    |   22 +-
 .../dxl/minidump/BtreeIndexNLOJWithProject.mdp     |   80 +-
 .../CArrayExpansionTest/JoinWithInListExpand.mdp   |   18 -
 .../CArrayExpansionTest/JoinWithInListNoExpand.mdp |   18 -
 .../minidump/CJoinOrderDPTest/JoinOrderWithDP.mdp  |   29 -
 .../CJoinOrderDPTest/JoinOrderWithOutDP.mdp        |   29 -
 .../FallBackToSerialAppend.mdp                     |   46 +-
 .../NoOpMotionUsesOnlyGroupOutputColumns.mdp       |   25 +-
 .../ParallelAppend-ConstTable.mdp                  |    8 -
 .../ParallelAppend-Insert.mdp                      |    8 -
 .../ParallelAppend-Select.mdp                      |   26 +-
 ...arallelUnionAllWithNoRedistributableColumns.mdp |   16 -
 ...rallelUnionAllWithNotEqualNumOfDistrColumns.mdp |   18 -
 ...lUnionAllWithSingleNotRedistributableColumn.mdp |   20 -
 .../RandomDistributedChildrenUnhashableColumns.mdp |   18 -
 .../RedundantMotionParallelUnionAll.mdp            |    9 -
 .../TwoHashedTables.mdp                            |   16 -
 .../AggTopOfSetRefFuncsOnTopTbl.mdp                |    9 -
 .../dxl/minidump/CPruneColumnsTest/AllColsUsed.mdp |    9 -
 .../MultiLevelSubqueryWithSetRetFuncs.mdp          |    9 -
 ...iLevelSubqueryWithSetRetFuncsAndScalarFuncs.mdp |    9 -
 .../PruneIntermediateUnusedColumns.mdp             |   11 -
 .../UnusedSetRetFuncAndUsedScalarFunc.mdp          |    9 -
 .../UsedSetRetFuncAndUnusedScalarFunc.mdp          |    9 -
 .../gporca/data/dxl/minidump/CSQ-VolatileTVF.mdp   |    9 -
 .../gporca/data/dxl/minidump/CTAS-Random.mdp       |   11 -
 .../dxl/minidump/CTAS-With-Global-Local-Agg.mdp    |   12 +-
 .../gporca/data/dxl/minidump/CTAS-random-distr.mdp |    3 -
 ...stributed-from-replicated-distributed-table.mdp |   11 -
 .../gporca/data/dxl/minidump/CTAS-with-Limit.mdp   |   11 -
 ...CTAS-with-hashed-distributed-external-table.mdp |   13 -
 ...AS-with-randomly-distributed-external-table.mdp |   13 -
 src/backend/gporca/data/dxl/minidump/CTAS.mdp      |   11 -
 .../dxl/minidump/CTAS_OrderedAgg_multiple_cols.mdp |   13 -
 src/backend/gporca/data/dxl/minidump/CTE-1.mdp     |   10 -
 src/backend/gporca/data/dxl/minidump/CTE-10.mdp    |    9 -
 src/backend/gporca/data/dxl/minidump/CTE-11.mdp    |    9 -
 src/backend/gporca/data/dxl/minidump/CTE-2.mdp     |   10 -
 src/backend/gporca/data/dxl/minidump/CTE-3.mdp     |   10 -
 src/backend/gporca/data/dxl/minidump/CTE-4.mdp     |    9 -
 src/backend/gporca/data/dxl/minidump/CTE-5.mdp     |   18 -
 src/backend/gporca/data/dxl/minidump/CTE-6.mdp     |    9 -
 src/backend/gporca/data/dxl/minidump/CTE-7.mdp     |   18 -
 src/backend/gporca/data/dxl/minidump/CTE-8.mdp     |    9 -
 src/backend/gporca/data/dxl/minidump/CTE-9.mdp     |   18 -
 .../minidump/CTE-Join-Redistribute-Producer.mdp    |    9 -
 .../data/dxl/minidump/CTE-NoPushProperties.mdp     |  120 -
 .../gporca/data/dxl/minidump/CTE-PartTbl.mdp       |   86 +-
 .../gporca/data/dxl/minidump/CTE-Preds1.mdp        |   19 +-
 .../gporca/data/dxl/minidump/CTE-Preds2.mdp        |   19 +-
 .../data/dxl/minidump/CTE-PushProperties.mdp       |  122 +-
 .../gporca/data/dxl/minidump/CTE-volatile.mdp      |    9 -
 .../data/dxl/minidump/CTE-with-random-filter.mdp   |    8 -
 .../gporca/data/dxl/minidump/CTE15HAReplicated.mdp |   20 -
 .../gporca/data/dxl/minidump/CTE15Replicated.mdp   |   30 +-
 .../gporca/data/dxl/minidump/CTE2HAReplicated.mdp  |   20 -
 .../gporca/data/dxl/minidump/CTE2Replicated.mdp    |   30 +-
 .../dxl/minidump/CTEConstraintDeriveNegation.mdp   |  120 +-
 .../minidump/CTEMergeGroupsCircularDeriveStats.mdp |   18 -
 .../dxl/minidump/CTEMisAlignedProducerConsumer.mdp |    8 -
 .../data/dxl/minidump/CTEWithMergedGroup.mdp       |  341 +-
 .../data/dxl/minidump/CTEWithOuterReferences.mdp   |   10 -
 .../data/dxl/minidump/CTEWithVolatileFunction.mdp  |   14 +-
 .../gporca/data/dxl/minidump/CTEinlining.mdp       |    9 -
 .../dxl/minidump/CannotCollapseCascadeProjects.mdp |    9 -
 .../data/dxl/minidump/CannotPullGrpColAboveAgg.mdp |  126 +-
 .../data/dxl/minidump/CapGbCardToSelectCard.mdp    |   98 +-
 .../Cascaded-UnionAll-Differing-Cols-Order.mdp     |   30 -
 .../minidump/Cascaded-UnionAll-Differing-Cols.mdp  |   30 -
 .../minidump/Cascaded-UnionAll-Same-Cols-Order.mdp |    9 -
 .../gporca/data/dxl/minidump/CastOnSubquery.mdp    |   18 -
 .../data/dxl/minidump/CastedInClauseWithMCV.mdp    |    9 -
 .../dxl/minidump/CastedScalarIf-On-Index-Key.mdp   |   25 +-
 .../gporca/data/dxl/minidump/Char-Cardinality.mdp  |    8 -
 .../gporca/data/dxl/minidump/CheckAsUser.mdp       |    9 -
 .../data/dxl/minidump/Citext-Cardinality.mdp       |    9 -
 .../data/dxl/minidump/Coalesce-With-Subquery.mdp   |   67 +-
 .../gporca/data/dxl/minidump/CoerceToDomain.mdp    |  123 +-
 .../gporca/data/dxl/minidump/CoerceViaIO.mdp       |    8 -
 .../dxl/minidump/CollapseCascadeProjects2of2.mdp   |    9 -
 .../dxl/minidump/CollapseCascadeProjects2of3.mdp   |    9 -
 .../dxl/minidump/CollapseGb-MultipleColumn.mdp     |    9 -
 .../gporca/data/dxl/minidump/CollapseGb-Nested.mdp |    9 -
 .../data/dxl/minidump/CollapseGb-SingleColumn.mdp  |    9 -
 .../dxl/minidump/CollapseGb-With-Agg-Funcs.mdp     |  155 +-
 .../dxl/minidump/CollapseGb-Without-Agg-Funcs.mdp  |   87 +-
 .../gporca/data/dxl/minidump/CollapseNot.mdp       |  180 +-
 .../minidump/CollapseProject-SetReturning-CTE.mdp  |    9 -
 .../dxl/minidump/CollapseProject-SetReturning.mdp  |    9 -
 .../data/dxl/minidump/CompositeTypeRelMdId.mdp     |  136 +-
 .../data/dxl/minidump/ComputedGroupByCol.mdp       |   25 +-
 .../ConstScalarFuncNotPushedBelowGather.mdp        |    8 -
 ...onstTblGetUnderSubqUnderProjectWithOuterRef.mdp |    9 -
 .../ConstTblGetUnderSubqWithNoOuterRef.mdp         |   73 +-
 .../minidump/ConstTblGetUnderSubqWithOuterRef.mdp  |   18 -
 .../minidump/ConstraintIntervalIncludesNull.mdp    |    8 -
 .../minidump/ConstraintIntervalNotIncludesNull.mdp |    8 -
 .../ConstraintIntervalWithBoolIncludesNull.mdp     |    8 -
 .../ConstraintIntervalWithBoolNotIncludesNull.mdp  |    8 -
 .../ConstraintIntervalWithInIncludesNull.mdp       |    8 -
 .../ConstraintIntervalWithInIncludesNullArray.mdp  |    8 -
 .../ConstraintIntervalWithInNotIncludesNull.mdp    |    8 -
 ...nstraintIntervalWithMultiColumnsIncludeNull.mdp |    9 -
 ...raintIntervalWithMultiColumnsNotIncludeNull.mdp |    9 -
 .../ConstraintIntervalWithNotIncludesNull.mdp      |    8 -
 ...ConvertBoolConstNullToConstTableFalseFilter.mdp |    8 -
 .../dxl/minidump/ConvertHashToRandomInsert.mdp     |   15 -
 .../dxl/minidump/ConvertHashToRandomSelect.mdp     |   10 -
 .../data/dxl/minidump/Correlated-AntiSemiJoin.mdp  |   18 -
 .../minidump/Correlated-LASJ-With-Outer-Col.mdp    |   18 -
 .../minidump/Correlated-LASJ-With-Outer-Const.mdp  |   18 -
 .../minidump/Correlated-LASJ-With-Outer-Expr.mdp   |   18 -
 .../data/dxl/minidump/Correlated-SemiJoin.mdp      |   18 -
 .../Correlated-Stat-Function-Dependency-2.mdp      |   10 -
 .../Correlated-Stat-Function-Dependency-3.mdp      |    9 -
 .../Correlated-Stat-Function-Dependency.mdp        |    9 -
 .../dxl/minidump/Correlated-Stat-NDistinct-2.mdp   |    9 -
 .../dxl/minidump/Correlated-Stat-NDistinct-3.mdp   |    9 -
 .../dxl/minidump/Correlated-Stat-NDistinct-4.mdp   |   10 -
 .../dxl/minidump/Correlated-Stat-NDistinct-5.mdp   |   10 -
 .../dxl/minidump/Correlated-Stat-NDistinct.mdp     |    9 -
 .../dxl/minidump/CorrelatedAntiSemiJoin-True.mdp   |   72 +-
 .../minidump/CorrelatedIN-LeftSemiJoin-Limit.mdp   |   16 -
 .../minidump/CorrelatedIN-LeftSemiJoin-True.mdp    |   16 -
 .../minidump/CorrelatedIN-LeftSemiNotIn-True.mdp   |   39 +-
 .../minidump/CorrelatedLeftSemiNLJoinWithLimit.mdp |   16 -
 .../CorrelatedNLJ-PartSelector-Subplan.mdp         |   38 +-
 .../minidump/CorrelatedNLJWithStreamingSpool.mdp   |   16 -
 .../minidump/CorrelatedNLJWithTrueCondition.mdp    |  103 +-
 .../data/dxl/minidump/CorrelatedSemiJoin-True.mdp  |   72 +-
 .../CorrelatedSubqueryWithAggWindowFunc.mdp        |   30 +-
 .../dxl/minidump/Correlation-With-Casting-1.mdp    |   44 +-
 .../dxl/minidump/Correlation-With-Casting-2.mdp    |   10 -
 src/backend/gporca/data/dxl/minidump/CountAny.mdp  |   18 -
 src/backend/gporca/data/dxl/minidump/CountStar.mdp |   18 -
 .../gporca/data/dxl/minidump/CoveringIndex-1.mdp   |   14 +-
 .../gporca/data/dxl/minidump/CoveringIndex-2.mdp   |   14 +-
 .../gporca/data/dxl/minidump/CoveringIndex-3.mdp   |   27 +-
 .../data/dxl/minidump/CoveringIndex-Cost-1.mdp     |   37 +-
 .../data/dxl/minidump/CoveringIndex-Cost-2.mdp     |   37 +-
 ...17.mdp => CoveringIndex-DoesNotSupport-Gin.mdp} |  117 +-
 ...n-17.mdp => CoveringIndex-DoesSupport-Gist.mdp} |  205 +-
 .../minidump/DML-ComputeScalar-With-Outerref.mdp   |   16 -
 .../data/dxl/minidump/DML-Filter-With-OuterRef.mdp |   16 -
 .../data/dxl/minidump/DML-Replicated-Input.mdp     |   19 -
 .../dxl/minidump/DML-UnionAll-With-OuterRef.mdp    |   25 -
 .../minidump/DML-UnionAll-With-Universal-Child.mdp |   16 -
 .../data/dxl/minidump/DML-Volatile-Function.mdp    |   16 -
 .../minidump/DML-With-CoordinatorOnlyTable-1.mdp   |   29 +-
 ...DML-With-CorrelatedNLJ-With-Universal-Child.mdp |   16 -
 .../minidump/DML-With-HJ-And-UniversalChild.mdp    |  111 +-
 .../DML-With-Join-With-Universal-Child.mdp         |   17 -
 .../dxl/minidump/DML-With-WindowFunc-OuterRef.mdp  |   35 +-
 .../data/dxl/minidump/DMLCollapseProject.mdp       |   20 -
 src/backend/gporca/data/dxl/minidump/DPE-IN.mdp    |   46 +-
 .../gporca/data/dxl/minidump/DPE-NOT-IN.mdp        |   46 +-
 .../gporca/data/dxl/minidump/DPE-SemiJoin.mdp      |   28 -
 .../dxl/minidump/DPE-with-unsupported-pred.mdp     |   90 +-
 .../gporca/data/dxl/minidump/DPv2GreedyOnly.mdp    |   36 -
 .../gporca/data/dxl/minidump/DPv2MinCardOnly.mdp   |   36 -
 .../gporca/data/dxl/minidump/DPv2QueryOnly.mdp     |   36 -
 .../gporca/data/dxl/minidump/DQA-1-RegularAgg.mdp  |   34 +-
 .../gporca/data/dxl/minidump/DQA-2-RegularAgg.mdp  |   38 +-
 .../dxl/minidump/DQA-GroupBy-HashAggregate1.mdp    |   10 +-
 .../dxl/minidump/DQA-GroupBy-HashAggregate2.mdp    |   11 +-
 .../DQA-InnerJoin-GroupBy-HashAggregate.mdp        |   20 +-
 .../data/dxl/minidump/DQA-KeepOuterReference.mdp   |   20 +-
 .../dxl/minidump/DQA-NonRedistributableCol.mdp     |   18 +-
 .../gporca/data/dxl/minidump/DQA-SplitScalar.mdp   |   23 +-
 .../data/dxl/minidump/DQA-SplitScalarOnDistCol.mdp |  289 +-
 .../dxl/minidump/DQA-SplitScalarWithAggAndGuc.mdp  |  134 +-
 .../data/dxl/minidump/DQA-SplitScalarWithGuc.mdp   |   23 +-
 .../dxl/minidump/DTS-Hetrogeneous-Partitioned.mdp  |   38 +-
 .../data/dxl/minidump/Date-TimeStamp-HashJoin.mdp  |   18 -
 .../data/dxl/minidump/DeduplicatePredicates.mdp    |   10 -
 .../Delete-Check-AssignedQueryIdForTargetRel.mdp   |    8 -
 .../dxl/minidump/Delete-With-Limit-In-Subquery.mdp |   31 +-
 .../dxl/minidump/DeleteMismatchedDistribution.mdp  |   72 +-
 .../gporca/data/dxl/minidump/DeleteRandomDistr.mdp |    9 -
 .../minidump/DeleteRandomlyDistributedTable.mdp    |    8 -
 .../DeleteRandomlyDistributedTableJoin.mdp         |   16 -
 .../minidump/DirectDispatch-DynamicIndexScan.mdp   |  144 +-
 ...ctDispatch-GpSegmentId-MultiCol-Conjunction.mdp |    9 -
 ...tDispatch-GpSegmentId-SingleCol-Conjunction.mdp |    8 -
 .../dxl/minidump/DirectDispatch-GpSegmentId.mdp    |    9 -
 .../data/dxl/minidump/DirectDispatch-IndexScan.mdp |   24 +-
 .../DirectDispatch-MultiCol-Disjunction.mdp        |    9 -
 .../minidump/DirectDispatch-MultiCol-Negative.mdp  |    9 -
 .../data/dxl/minidump/DirectDispatch-MultiCol.mdp  |    9 -
 .../DirectDispatch-RandDistTable-Disjunction.mdp   |    9 -
 .../dxl/minidump/DirectDispatch-RandDistTable.mdp  |    9 -
 ...DirectDispatch-SingleCol-Disjunction-IsNull.mdp |    9 -
 ...rectDispatch-SingleCol-Disjunction-Negative.mdp |    9 -
 .../DirectDispatch-SingleCol-Disjunction.mdp       |    9 -
 .../data/dxl/minidump/DirectDispatch-SingleCol.mdp |    9 -
 .../dxl/minidump/DisableBroadcastThreshold.mdp     |   16 -
 .../dxl/minidump/DiscardRedistributeHashJoin.mdp   |   20 -
 .../data/dxl/minidump/Distinct-LegacyOpfamily.mdp  |   95 +-
 .../dxl/minidump/DistinctAgg-NonSplittable.mdp     |   23 -
 .../data/dxl/minidump/DistinctQueryWithMotions.mdp |   10 -
 .../dxl/minidump/DonotPushPartConstThruLimit.mdp   |   39 +-
 .../minidump/DontAddRedistributeBeforeInsert-1.mdp |   58 +-
 .../minidump/DontAddRedistributeBeforeInsert-2.mdp |    8 -
 .../dxl/minidump/DoubleNDVCardinalityEquals.mdp    |   36 +-
 .../gporca/data/dxl/minidump/DqaHavingMax.mdp      |   26 +-
 src/backend/gporca/data/dxl/minidump/DqaMax.mdp    |   10 -
 src/backend/gporca/data/dxl/minidump/DqaMin.mdp    |   10 -
 .../gporca/data/dxl/minidump/DqaNoRedistribute.mdp |   20 +-
 .../gporca/data/dxl/minidump/DqaSubqueryMax.mdp    |   10 -
 .../gporca/data/dxl/minidump/DuplicateGrpCol.mdp   |   23 +-
 .../data/dxl/minidump/DynamicBitmapBoolOp.mdp      |  138 +-
 .../data/dxl/minidump/DynamicBitmapIndexScan.mdp   |   71 +-
 .../dxl/minidump/DynamicBitmapTableScan-Basic.mdp  |  114 +-
 .../DynamicBitmapTableScan-Heterogeneous.mdp       |  134 +-
 .../dxl/minidump/DynamicBitmapTableScan-UUID.mdp   |   27 +-
 .../dxl/minidump/DynamicIndexGet-OuterRefs.mdp     | 6815 +-------------------
 .../dxl/minidump/DynamicIndexGetDroppedCols.mdp    |   41 +-
 ...dom.mdp => DynamicIndexOnlyScan-Homogenous.mdp} |  523 +-
 ...able.mdp => DynamicIndexOnlyScan-InnerJoin.mdp} |  689 +-
 ...Table.mdp => DynamicIndexOnlyScan-LeftJoin.mdp} |  679 +-
 .../dxl/minidump/DynamicIndexScan-BoolFalse.mdp    |  122 +-
 .../dxl/minidump/DynamicIndexScan-BoolTrue.mdp     |  122 +-
 .../DynamicIndexScan-DefaultPartition-2.mdp        |   66 +-
 .../minidump/DynamicIndexScan-DefaultPartition.mdp |   64 +-
 .../dxl/minidump/DynamicIndexScan-DroppedCols.mdp  |   47 +-
 .../minidump/DynamicIndexScan-DroppedColumns.mdp   |  172 +-
 ...ndexScan-Heterogenous-EnabledDateConstraint.mdp |   54 +-
 .../DynamicIndexScan-Heterogenous-NoDTS.mdp        |   60 +-
 .../DynamicIndexScan-Heterogenous-Overlapping.mdp  |   60 +-
 ...icIndexScan-Heterogenous-PartSelectEquality.mdp |  112 +-
 ...namicIndexScan-Heterogenous-PartSelectRange.mdp |  112 +-
 .../DynamicIndexScan-Heterogenous-Union.mdp        |   96 +-
 ...ndexScan-Heterogenous-UnsupportedConstraint.mdp |   34 +-
 ...IndexScan-Heterogenous-UnsupportedPredicate.mdp |   34 +-
 .../dxl/minidump/DynamicIndexScan-Heterogenous.mdp |   60 +-
 ...cIndexScan-Homogenous-EnabledDateConstraint.mdp |   36 +-
 ...cIndexScan-Homogenous-UnsupportedConstraint.mdp |   36 +-
 .../dxl/minidump/DynamicIndexScan-Homogenous.mdp   |   94 +-
 .../DynamicIndexScan-OpenEndedPartitions.mdp       |  112 +-
 .../data/dxl/minidump/DynamicIndexScan-Relabel.mdp |  110 +-
 .../data/dxl/minidump/EagerAggEmptyInput.mdp       |  185 +-
 .../data/dxl/minidump/EagerAggExpression.mdp       |   44 +-
 .../dxl/minidump/EagerAggGroupColumnInJoin.mdp     |  254 +-
 .../gporca/data/dxl/minidump/EagerAggMax.mdp       |  185 +-
 .../dxl/minidump/EagerAggMaxWithNestedLoop.mdp     |   46 +-
 .../gporca/data/dxl/minidump/EagerAggMinMax.mdp    |   42 +-
 .../gporca/data/dxl/minidump/EagerAggSubquery.mdp  |  268 +-
 .../data/dxl/minidump/EagerAggUnsupportedAgg.mdp   |   52 +-
 .../data/dxl/minidump/EffectOfLocalPredOnJoin.mdp  |   27 -
 .../data/dxl/minidump/EffectOfLocalPredOnJoin2.mdp |  372 --
 .../data/dxl/minidump/EffectOfLocalPredOnJoin3.mdp |  298 +-
 .../data/dxl/minidump/EffectsOfJoinFilter.mdp      |   18 -
 .../gporca/data/dxl/minidump/EqualityJoin.mdp      |   18 -
 .../dxl/minidump/EqualityPredicateOverDate.mdp     |    8 -
 .../data/dxl/minidump/EquiJoinOnExpr-Supported.mdp |   10 -
 .../dxl/minidump/EquiJoinOnExpr-Unsupported.mdp    |   10 -
 .../data/dxl/minidump/Equiv-HashedDistr-1.mdp      |   35 -
 .../data/dxl/minidump/Equiv-HashedDistr-2.mdp      |   35 -
 .../gporca/data/dxl/minidump/EquivClassesAndOr.mdp |   30 -
 .../data/dxl/minidump/EquivClassesIntersect.mdp    |   34 +-
 .../gporca/data/dxl/minidump/EquivClassesLimit.mdp |    9 -
 .../gporca/data/dxl/minidump/EquivClassesUnion.mdp |   28 +-
 .../Equivalence-class-project-over-LOJ.mdp         |   27 -
 .../minidump/EstimateJoinRowsForCastPredicates.mdp |   18 -
 .../data/dxl/minidump/Except-Volatile-Func.mdp     |    6 +-
 src/backend/gporca/data/dxl/minidump/Except.mdp    |   16 -
 .../dxl/minidump/ExceptAllCompatibleDataType.mdp   |   63 +-
 .../dxl/minidump/ExceptHashCompatibleRange.mdp     |    4 +-
 .../dxl/minidump/ExceptHashIncompatibleRange.mdp   |    4 +-
 .../ExistentialSubquriesInsideScalarExpression.mdp |  304 +-
 .../dxl/minidump/Exists-SuperfluousEquality.mdp    |   18 -
 .../data/dxl/minidump/ExistsSubqInsideExpr.mdp     |   28 +-
 .../data/dxl/minidump/ExpandFullOuterJoin.mdp      |   20 -
 .../data/dxl/minidump/ExpandFullOuterJoin2.mdp     |    8 -
 .../gporca/data/dxl/minidump/ExpandJoinOrder.mdp   |   73 -
 .../minidump/ExpandNAryJoinGreedyWithLOJOnly.mdp   |   60 -
 .../dxl/minidump/ExprOnScSubqueryWithOuterRef.mdp  |   18 -
 .../gporca/data/dxl/minidump/ExternalTable1.mdp    |   11 -
 .../gporca/data/dxl/minidump/ExternalTable2.mdp    |    8 -
 .../gporca/data/dxl/minidump/ExternalTable3.mdp    |    8 -
 .../gporca/data/dxl/minidump/ExternalTable4.mdp    |    8 -
 .../data/dxl/minidump/ExternalTableWithFilter.mdp  |   11 -
 .../minidump/ExtractOneBindingFromScalarGroups.mdp |   38 +-
 .../data/dxl/minidump/ExtractPredicateFromDisj.mdp |  419 +-
 ...ExtractPredicateFromDisjWithComputedColumns.mdp |  216 +-
 .../data/dxl/minidump/FOJ-Condition-False.mdp      |    8 -
 .../gporca/data/dxl/minidump/Factorized-Preds.mdp  |   18 -
 .../{VariadicFlagWithJson.mdp => FieldSelect.mdp}  |  294 +-
 .../gporca/data/dxl/minidump/FilterScalarCast.mdp  |    9 -
 .../gporca/data/dxl/minidump/FoldedArrayCmp.mdp    |    9 -
 .../dxl/minidump/ForeignPartOneTimeFilterDPE.mdp   |   29 +-
 .../data/dxl/minidump/ForeignPartUniform.mdp       |   27 -
 .../dxl/minidump/ForeignScanExecLocAnyJoin.mdp     |   19 +-
 .../minidump/ForeignScanExecLocAnySimpleScan.mdp   |    9 -
 ...rd-IndexOnlyScan-OrderBy-on-MultiCol-Index.mdp} |  442 +-
 ...orward-IndexScan-OrderBy-on-MultiCol-Index.mdp} |  475 +-
 ...rward-IndexScan-OrderBy-on-SingleCol-Index.mdp} |  436 +-
 .../minidump/FullJoin-2PredicateOnDistColumns.mdp  |   26 +-
 .../gporca/data/dxl/minidump/FullJoin-Caps.mdp     |   18 +-
 .../FullJoin-InnerNotOnDistributionColumn.mdp      |   26 +-
 .../dxl/minidump/FullJoin-NonDefaultOpfamily.mdp   |   16 -
 .../minidump/FullJoin-NotOnDistributionColumn.mdp  |   26 +-
 .../data/dxl/minidump/FullJoin-NullPredicate.mdp   |   18 -
 .../dxl/minidump/FullJoin-OnDistributionColumn.mdp |   26 +-
 .../dxl/minidump/FullJoin-PredicateOnSameTable.mdp |   18 -
 .../data/dxl/minidump/FullJoin-Replicated.mdp      |   26 +-
 .../FullJoin-Subquery-CastedPredicates.mdp         |   52 +-
 .../dxl/minidump/FullJoin-SubquerySingleton.mdp    |   32 +-
 .../minidump/FullJoin-SubqueryWithRedistribute.mdp |   30 +-
 .../dxl/minidump/FullJoin-SwappedPredicates.mdp    |   26 +-
 .../minidump/FullOuterJoin-NullRejectingLHS1.mdp   |   18 -
 .../minidump/FullOuterJoin-NullRejectingLHS2.mdp   |   18 -
 .../gporca/data/dxl/minidump/Gb-on-keys.mdp        |   12 +-
 src/backend/gporca/data/dxl/minidump/GinIndex.mdp  |   10 +-
 .../data/dxl/minidump/GinIndexPathOpfamily.mdp     |   10 +-
 .../data/dxl/minidump/GinIndexSearchModeAll.mdp    |   10 +-
 .../Gist-AOCOTable-NonLossy-BitmapIndexPlan.mdp    |   15 +-
 .../Gist-NestedLoopJoin-Lossy-IndexPlan.mdp        |   22 +-
 .../Gist-NestedLoopJoin-Postgis-IndexPlan.mdp      |   20 +-
 .../Gist-NonPart-Lossy-BitmapIndexPlan.mdp         |   12 +-
 .../dxl/minidump/Gist-NonPart-Lossy-IndexPlan.mdp  |   12 +-
 .../data/dxl/minidump/Gist-OrderBy-BitmapPlan.mdp  |   24 +-
 .../data/dxl/minidump/Gist-OrderBy-IndexPlan.mdp   |   26 +-
 .../minidump/Gist-PartTable-Lossy-IndexPlan.mdp    |   37 +-
 .../Gist-PartTable-NonLossy-BitmapIndexPlan.mdp    |   26 +-
 .../dxl/minidump/Gist-PartialIndex-TableScan.mdp   |   28 +-
 .../data/dxl/minidump/GreedyNAryDelayCrossJoin.mdp |   32 -
 .../gporca/data/dxl/minidump/GreedyNAryJoin.mdp    |   24 -
 .../GreedyNAryJoinWithDisconnectedEdges.mdp        |   72 -
 .../data/dxl/minidump/GreedyNAryOnlyCrossJoins.mdp |   24 -
 .../data/dxl/minidump/GroupByEmptySetNoAgg.mdp     |    9 -
 .../gporca/data/dxl/minidump/GroupByOuterRef.mdp   |   18 -
 .../data/dxl/minidump/GroupingOnSameTblCol-1.mdp   |  132 +-
 .../data/dxl/minidump/GroupingOnSameTblCol-2.mdp   |   57 +-
 .../gporca/data/dxl/minidump/GroupingSets.mdp      |   25 +-
 .../dxl/minidump/HAWQ-TPCH-Stat-Derivation.mdp     |   84 +-
 .../dxl/minidump/HJN-DPE-Bitmap-Outer-Child.mdp    |  232 +-
 .../gporca/data/dxl/minidump/HJN-DeeperOuter.mdp   |   28 -
 .../dxl/minidump/HJN-Redistribute-One-Side.mdp     |   39 -
 .../data/dxl/minidump/Hash-BitmapScan-InArray.mdp  |   11 +-
 .../gporca/data/dxl/minidump/Hash-BitmapScan.mdp   |   11 +-
 .../gporca/data/dxl/minidump/Hash-IndexScan.mdp    |   11 +-
 .../data/dxl/minidump/Hash-TableScan-AllArray.mdp  |   11 +-
 .../dxl/minidump/HashJoinOnRelabeledColumns.mdp    |   16 -
 .../data/dxl/minidump/IDF-NotNullConstant.mdp      |    8 -
 .../gporca/data/dxl/minidump/IDF-NullConstant.mdp  |    8 -
 .../gporca/data/dxl/minidump/IN-ArrayCmp.mdp       |   18 -
 .../data/dxl/minidump/IN-Nulls-ArrayCmpAny.mdp     |    8 -
 .../gporca/data/dxl/minidump/IN-Numeric.mdp        |   18 -
 src/backend/gporca/data/dxl/minidump/IN.mdp        |   16 -
 .../data/dxl/minidump/INDF-NotNullConstant.mdp     |    8 -
 .../gporca/data/dxl/minidump/INDF-NullConstant.mdp |    8 -
 .../gporca/data/dxl/minidump/InClauseWithMCV.mdp   |    8 -
 .../gporca/data/dxl/minidump/InEqualityJoin.mdp    |   84 +-
 ...InSubqWithPrjListOuterRefNoInnerRefColumnIn.mdp |   17 -
 ...hPrjListOuterRefNoInnerRefColumnPlusConstIn.mdp |   17 -
 .../InSubqWithPrjListOuterRefNoInnerRefConstIn.mdp |   17 -
 ...ubqAll-1.mdp => InSubqWithPrjListReturnSet.mdp} |  238 +-
 .../data/dxl/minidump/InSubqueryWithNotNullCol.mdp |   17 -
 .../minidump/Index-Join-With-Subquery-In-Pred.mdp  |   22 +-
 ...dexApply-Heterogeneous-BothSidesPartitioned.mdp |  140 +-
 .../dxl/minidump/IndexApply-Heterogeneous-DTS.mdp  |  111 +-
 .../minidump/IndexApply-Heterogeneous-NoDTS.mdp    |  333 +-
 ...IndexApply-IndexCondDisjointWithHashedDistr.mdp |   31 +-
 ...ndexApply-IndexCondIntersectWithHashedDistr.mdp |   31 +-
 .../IndexApply-IndexCondMatchHashedDistr.mdp       |   29 +-
 .../IndexApply-IndexCondSubsetOfHashedDistr.mdp    |   31 +-
 .../IndexApply-IndexCondSupersetOfHashedDistr.mdp  |   29 +-
 .../IndexApply-IndexOnCoordinatorOnlyTable.mdp     |   89 +-
 .../dxl/minidump/IndexApply-InnerSelect-Basic.mdp  |   44 +-
 .../IndexApply-InnerSelect-Heterogeneous-DTS.mdp   |  113 +-
 .../minidump/IndexApply-InnerSelect-PartTable.mdp  |  130 +-
 .../minidump/IndexApply-InnerSelect-PartTable2.mdp |   38 +-
 .../dxl/minidump/IndexApply-LeftOuter-NLJoin.mdp   |   45 +-
 .../IndexApply-MultiDistKey-WithComplexPreds.mdp   |   20 +-
 ...Apply-MultiDistKeys-Bitmap-WithComplexPreds.mdp |   20 +-
 .../minidump/IndexApply-MultiDistKeys-Bitmap.mdp   |   20 +-
 ...pply-MultiDistKeys-IncompletePDS-3-DistCols.mdp |   26 +-
 .../minidump/IndexApply-No-Motion-Below-Join.mdp   |   24 +-
 .../minidump/IndexApply-PartKey-Is-IndexKey.mdp    |  126 +-
 .../dxl/minidump/IndexApply-PartResolverExpand.mdp |   37 +-
 .../data/dxl/minidump/IndexApply-PartTable.mdp     |  375 +-
 .../IndexApply-Redistribute-Const-Table.mdp        |   26 +-
 .../minidump/IndexApply1-CalibratedCostModel.mdp   |   29 +-
 .../gporca/data/dxl/minidump/IndexApply1.mdp       |   29 +-
 .../gporca/data/dxl/minidump/IndexApply2.mdp       |   29 +-
 .../gporca/data/dxl/minidump/IndexApply3.mdp       |   29 +-
 .../gporca/data/dxl/minidump/IndexApply4.mdp       |   29 +-
 .../IndexApply_NestLoopWithNestParamTrue.mdp       |   22 +-
 .../dxl/minidump/IndexConstraintsMDidCache.mdp     |   13 +-
 .../data/dxl/minidump/IndexGet-OuterRefs.mdp       |   20 +-
 .../dxl/minidump/IndexNLJ-IndexGet-OuterRef.mdp    |   22 +-
 .../dxl/minidump/IndexNLJoin_Cast_NoMotion.mdp     |   32 +-
 ...itionToRootTableContainingHeterogenousIndex.mdp |   46 +-
 ...nLeaf-AddPartitionToRootWithHomogenousIndex.mdp |   46 +-
 ...-IndexOnPartitionsWithDifferentStorageTypes.mdp |   30 +-
 ...verlappingHeterogenousIndex-ANDPredicate-AO.mdp |   13 +-
 ...rlappingHeterogenousIndex-ANDPredicate-HEAP.mdp |   56 +-
 ...pingHomogenousIndexesOnRoot-ANDPredicate-AO.mdp |   13 +-
 ...ppingHomogenousIndexesOnRoot-ORPredicate-AO.mdp |   15 +-
 ...verlappingHeterogenousIndex-ANDPredicate-AO.mdp |   11 +-
 ...rlappingHeterogenousIndex-ANDPredicate-HEAP.mdp |   48 +-
 ...OverlappingHeterogenousIndex-ORPredicate-AO.mdp |   11 +-
 ...pingHomogenousIndexesOnRoot-ANDPredicate-AO.mdp |   11 +-
 ...nLeaf-OverlappingHomogenousIndexesOnRoot-AO.mdp |   11 +-
 ...ppingHomogenousIndexesOnRoot-ORPredicate-AO.mdp |   32 +-
 ...af-SingleColumnHeterogenousIndexOnRoot-1-AO.mdp |   32 +-
 ...-SingleColumnHeterogenousIndexOnRoot-1-HEAP.mdp |   48 +-
 ...af-SingleColumnHeterogenousIndexOnRoot-2-AO.mdp |   11 +-
 ...-SingleColumnHeterogenousIndexOnRoot-2-HEAP.mdp |   48 +-
 .../gporca/data/dxl/minidump/IndexOnlyScan-CTE.mdp |   11 +-
 .../minidump/IndexOnlyScan-NoDistKeyInIndex.mdp    |   11 +-
 ...IndexOnlyScan-OrderBy-on-MultiCol-NonIndex.mdp} |  445 +-
 .../gporca/data/dxl/minidump/IndexScan-AOTable.mdp |   14 +-
 .../gporca/data/dxl/minidump/IndexScan-AndedIn.mdp |   12 +-
 .../data/dxl/minidump/IndexScan-BoolFalse.mdp      |   20 +-
 .../data/dxl/minidump/IndexScan-BoolTrue.mdp       |   20 +-
 .../data/dxl/minidump/IndexScan-DroppedColumns.mdp |   12 +-
 .../data/dxl/minidump/IndexScan-ORPredsAOPart.mdp  |   46 +-
 .../data/dxl/minidump/IndexScan-ORPredsNonPart.mdp |   11 +-
 .../IndexScan-OrderBy-on-MultiCol-NonIndex.mdp     |  462 ++
 .../IndexScan-OrderBy-on-Multiple-IndexCols.mdp    |   17 +-
 .../minidump/IndexScan-OrderBy-on-NonIndexCol.mdp  |   17 +-
 .../IndexScan-OrderBy-on-Single-IndexCol.mdp       |   17 +-
 .../gporca/data/dxl/minidump/IndexScan-Relabel.mdp |   20 +-
 .../minidump/IndexScanWithNestedCTEAndSetOp.mdp    |   18 +-
 .../gporca/data/dxl/minidump/IndexedNLJBitmap.mdp  |   62 +-
 .../gporca/data/dxl/minidump/InferPredicates.mdp   |   54 +-
 .../dxl/minidump/InferPredicatesBCC-oid-oid.mdp    |    8 -
 .../dxl/minidump/InferPredicatesBCC-txt-txt.mdp    |    8 -
 .../dxl/minidump/InferPredicatesBCC-vc-txt.mdp     |   16 -
 .../data/dxl/minidump/InferPredicatesBCC-vc-vc.mdp |    8 -
 .../dxl/minidump/InferPredicatesBCC-vcpart-txt.mdp |   19 +-
 .../data/dxl/minidump/InferPredicatesForLimit.mdp  |    9 -
 .../data/dxl/minidump/InferPredicatesForPartSQ.mdp |  176 +-
 .../minidump/InferPredicatesForProcessedColumn.mdp |   27 -
 .../minidump/InferPredicatesForQuantifiedSQ.mdp    |   18 -
 .../minidump/InferPredicatesFromExistsSubquery.mdp |   20 +-
 .../minidump/InferPredicatesFromMultiSubquery.mdp  |   24 -
 .../dxl/minidump/InferPredicatesInnerOfLOJ.mdp     |  110 +-
 .../InferPredicatesIntFromExistsSubquery.mdp       |   24 -
 .../minidump/InferPredicatesIntFromSubquery.mdp    |   20 +-
 .../dxl/minidump/InferPredicatesJoinSubquery.mdp   |   35 -
 .../dxl/minidump/InferPredicatesMultiColumns.mdp   |   24 -
 .../InferredPredicatesConstraintSimplification.mdp |   24 -
 .../data/dxl/minidump/InnerJoin-With-OuterRefs.mdp |   27 -
 .../minidump/InnerJoinBroadcastTableHashSpec.mdp   |  193 +-
 .../data/dxl/minidump/InnerJoinOverJoinExcept.mdp  |  164 +-
 .../dxl/minidump/InnerJoinOverJoinExceptAll.mdp    |   24 +-
 .../minidump/InnerJoinReplicatedTableHashSpec.mdp  |  209 +-
 .../Insert-AO-Partitioned-SortDisabled.mdp         |   39 -
 .../data/dxl/minidump/Insert-AO-Partitioned.mdp    |   34 -
 src/backend/gporca/data/dxl/minidump/Insert-AO.mdp |   14 -
 .../data/dxl/minidump/Insert-With-HJ-CTE-Agg.mdp   |   34 +-
 src/backend/gporca/data/dxl/minidump/Insert.mdp    |    9 -
 .../gporca/data/dxl/minidump/InsertAssertSort.mdp  |   30 -
 .../data/dxl/minidump/InsertCheckConstraint.mdp    |   22 -
 .../gporca/data/dxl/minidump/InsertConstTuple.mdp  |    9 -
 .../InsertConstTupleRandomDistribution.mdp         |    9 -
 .../minidump/InsertConstTupleVolatileFunction.mdp  |   15 -
 .../InsertConstTupleVolatileFunctionMOTable.mdp    |   15 -
 ...nlyTable.mdp => InsertCoordinatorOnlyTable.mdp} |   20 +-
 ...dp => InsertCoordinatorOnlyTableConstTuple.mdp} |   11 +-
 .../minidump/InsertDirectedDispatchNullValue.mdp   |   12 -
 .../InsertIntoNonNullAfterDroppingColumn.mdp       |    9 -
 .../minidump/InsertMismatchedDistrubution-2.mdp    |   70 -
 .../dxl/minidump/InsertMismatchedDistrubution.mdp  |   70 -
 .../dxl/minidump/InsertNULLNotNULLConstraint.mdp   |    8 -
 .../dxl/minidump/InsertNoEnforceConstraints.mdp    |    9 -
 .../data/dxl/minidump/InsertNonSingleton.mdp       |   16 -
 .../gporca/data/dxl/minidump/InsertNotNullCols.mdp |   18 -
 .../dxl/minidump/InsertPrimaryKeyFromMOTable.mdp   |   18 -
 .../gporca/data/dxl/minidump/InsertProjectSort.mdp |   20 -
 .../gporca/data/dxl/minidump/InsertRandomDistr.mdp |   18 -
 ...ertReplicatedIntoSerialHashDistributedTable.mdp |   23 -
 .../gporca/data/dxl/minidump/InsertSort.mdp        |   16 -
 ...p => InsertSortDistributed2CoordinatorOnly.mdp} |   36 +-
 .../data/dxl/minidump/InsertWithDroppedCol.mdp     |   20 -
 .../gporca/data/dxl/minidump/Int2Predicate.mdp     |    8 -
 .../data/dxl/minidump/Intersect-OuterRefs.mdp      |   33 -
 .../data/dxl/minidump/Intersect-Volatile-Func.mdp  |   12 +-
 .../data/dxl/minidump/InvalidDeleteGather.mdp      |   34 -
 .../dxl/minidump/InvalidPlan_CTE-2-all-plans.mdp   |   10 -
 ...Plan_IncompatibleDistributionOnJoinBranches.mdp |   22 -
 ...an_MotionGatherFromMasterToMaster-ScalarDQA.mdp |   23 -
 .../InvalidPlan_MotionGatherFromMasterToMaster.mdp |   22 -
 .../gporca/data/dxl/minidump/InvalidUpdatePlan.mdp |   24 -
 .../data/dxl/minidump/IsNullUnionAllIsNotNull.mdp  |    8 -
 .../dxl/minidump/JOIN-NonRedistributableCol.mdp    |   17 -
 .../data/dxl/minidump/JOIN-Pred-Cast-Int4.mdp      |   16 -
 .../data/dxl/minidump/JOIN-Pred-Cast-Varchar.mdp   |   18 -
 .../JOIN-cast2text-int4-Eq-cast2text-double.mdp    |   16 -
 .../data/dxl/minidump/JOIN-int4-Eq-double.mdp      |   16 -
 .../gporca/data/dxl/minidump/JOIN-int4-Eq-int2.mdp |   16 -
 .../gporca/data/dxl/minidump/Join-Disj-Subqs.mdp   |   69 +-
 src/backend/gporca/data/dxl/minidump/Join-IDF.mdp  |   18 -
 .../data/dxl/minidump/Join-INDF-NoBroadcast.mdp    |   18 -
 .../minidump/Join-INDF-Nulls-Not-Collocated.mdp    |   18 -
 src/backend/gporca/data/dxl/minidump/Join-INDF.mdp |   17 -
 .../data/dxl/minidump/Join-Varchar-Equality.mdp    |  104 +-
 .../data/dxl/minidump/Join-WinFunc-Preds.mdp       |   19 -
 .../data/dxl/minidump/Join-With-Subq-Preds-1.mdp   |   18 -
 .../data/dxl/minidump/Join-With-Subq-Preds-2.mdp   |   18 -
 .../dxl/minidump/JoinAbsEqWithoutOpfamilies.mdp    |   16 -
 ...inArityAssociativityCommutativityAboveLimit.mdp |   27 -
 .../JoinArityAssociativityCommutativityAtLimit.mdp |   27 -
 ...inArityAssociativityCommutativityBelowLimit.mdp |   27 -
 .../gporca/data/dxl/minidump/JoinBelowUnionAll.mdp |   55 +-
 .../gporca/data/dxl/minidump/JoinCitextVarchar.mdp |   18 -
 .../data/dxl/minidump/JoinColWithOnlyNDV.mdp       |  152 +-
 ...nDefaultOpfamiliesUsingNonDefaultOpfamilyOp.mdp |   16 -
 .../gporca/data/dxl/minidump/JoinNDVRemain.mdp     |  116 +-
 ...hOuterRef.mdp => JoinOnReplicatedUniversal.mdp} |  150 +-
 .../dxl/minidump/JoinOnViewWithCastedColumn.mdp    |   18 -
 ...nViewWithCastedColumnAndSubqueryInPredicate.mdp |   18 -
 ...ewWithMixOfPushableAndNonpushablePredicates.mdp |   18 -
 .../minidump/JoinOnViewWithSetReturningColumn.mdp  |   18 -
 .../dxl/minidump/JoinOnViewWithVolatileColumn.mdp  |   18 -
 ...nOptimizationLevelGreedyNonPartTblInnerJoin.mdp |   36 -
 ...inOptimizationLevelQuery3WayHashJoinPartTbl.mdp |   65 +-
 ...inOptimizationLevelQueryNonPartTblInnerJoin.mdp |   36 -
 .../gporca/data/dxl/minidump/JoinOrderDPE.mdp      |  276 +-
 src/backend/gporca/data/dxl/minidump/JoinPlan.mdp  |   27 -
 .../data/dxl/minidump/JoinPlanWithRedistribute.mdp |   18 -
 .../data/dxl/minidump/JoinPredFalseFilter.mdp      |   18 -
 .../gporca/data/dxl/minidump/JoinTinterval.mdp     |   14 +-
 .../JoinWithSingletonAndSingletonBranches.mdp      |   38 -
 .../JoinWithSingletonAndUniversalBranches.mdp      |   38 -
 .../dxl/minidump/JoinWithSubqueryProjectColumn.mdp |   20 -
 .../dxl/minidump/Join_OuterChild_DistUniversal.mdp |   10 +-
 .../dxl/minidump/LASJ-Not-In-Force-Broadcast.mdp   |   16 -
 .../data/dxl/minidump/LIKE-Pattern-Empty.mdp       |   16 -
 .../data/dxl/minidump/LIKE-Pattern-green-2.mdp     |   16 -
 .../data/dxl/minidump/LIKE-Pattern-green.mdp       |   16 -
 .../data/dxl/minidump/LOJ-Condition-False.mdp      |    8 -
 .../data/dxl/minidump/LOJ-DynBitmapIndex.mdp       |   40 +-
 .../dxl/minidump/LOJ-DynBitmapIndexWithSelect.mdp  |   38 +-
 .../gporca/data/dxl/minidump/LOJ-DynBtreeIndex.mdp |   40 +-
 .../dxl/minidump/LOJ-DynBtreeIndexWithSelect.mdp   |  150 +-
 ...LOJ-HashJoin-MultiDistKeys-WithComplexPreds.mdp |   20 +-
 .../minidump/LOJ-IndexApply-CompsiteKey-Equiv.mdp  |   30 +-
 .../LOJ-IndexApply-CompsiteKey-NoMotion.mdp        |   34 +-
 .../LOJ-IndexApply-CoordinatorOnly-Table.mdp       |   96 +-
 .../LOJ-IndexApply-DistKey-Multiple-Predicates.mdp |   35 +-
 ...ly-MultiDistKey-MultiIndexKey-NoExtraFilter.mdp |   22 +-
 .../LOJ-IndexApply-MultiDistKey-MultiIndexKey.mdp  |   22 +-
 ...Apply-MultiDistKeys-Bitmap-WithComplexPreds.mdp |   20 +-
 .../LOJ-IndexApply-MultiDistKeys-Bitmap.mdp        |   20 +-
 .../LOJ-IndexApply-MultiDistKeys-IndexKeys.mdp     |   46 +-
 ...J-IndexApply-MultiDistKeys-WithComplexPreds.mdp |   20 +-
 .../dxl/minidump/LOJ-IndexApply-MultiIndexes.mdp   |   31 +-
 .../LOJ-IndexApply-Negative-NonEqual-Predicate.mdp |   31 +-
 .../dxl/minidump/LOJ-IndexApply-NonDistKey.mdp     |   20 +-
 .../LOJ-IndexApply-WithComplexPredicates.mdp       |   20 +-
 .../gporca/data/dxl/minidump/LOJ-IsNullPred.mdp    |   57 -
 .../gporca/data/dxl/minidump/LOJ-PushDown.mdp      |   27 -
 .../gporca/data/dxl/minidump/LOJ-With-Agg.mdp      |  197 +-
 .../dxl/minidump/LOJ-With-Single-Pred-On-Outer.mdp |   19 -
 .../dxl/minidump/LOJNonNullRejectingPredicates.mdp |   44 -
 .../dxl/minidump/LOJNullRejectingPredicates.mdp    |   44 -
 .../LOJNullRejectingZeroPlacePredicates.mdp        |   17 -
 .../dxl/minidump/LOJReorderComplexNestedLOJs.mdp   |   30 -
 .../minidump/LOJReorderWithComplexPredicate.mdp    |   30 -
 .../gporca/data/dxl/minidump/LOJReorderWithIDF.mdp |   30 -
 .../minidump/LOJReorderWithNestedLOJAndFilter.mdp  |   30 -
 .../dxl/minidump/LOJReorderWithOneSidedFilter.mdp  |   30 -
 .../dxl/minidump/LOJReorderWithSimplePredicate.mdp |   30 -
 .../gporca/data/dxl/minidump/LOJWithFalsePred.mdp  |    9 -
 ...DF_no_convert_outer_ref_predicate_with_NULL.mdp |   18 -
 ..._convert_outer_ref_predicate_with_inner_ref.mdp |   18 -
 .../minidump/LOJ_NULLTEST-On-SelfCheck-Pred.mdp    |   19 -
 .../gporca/data/dxl/minidump/LOJ_bb_mpph.mdp       |  728 +--
 .../LOJ_convert_to_inner_with_and_predicate.mdp    |   21 +-
 ...J_convert_to_inner_with_inner_predicate_IDF.mdp |   18 -
 .../LOJ_convert_to_inner_with_or_predicate.mdp     |   21 +-
 ...ert_to_inner_with_inner_predicate_IDF_const.mdp |   18 -
 ..._convert_to_inner_with_outer_predicate_INDF.mdp |   18 -
 ...rt_to_inner_with_outer_predicate_INDF_const.mdp |   18 -
 .../gporca/data/dxl/minidump/LargeJoins.mdp        |  117 -
 .../data/dxl/minidump/LargeMultiColumnInList.mdp   |  112 +-
 .../gporca/data/dxl/minidump/Lead-Lag-WinFuncs.mdp |    9 -
 .../gporca/data/dxl/minidump/Least-Greatest.mdp    |   10 -
 .../dxl/minidump/LeftJoin-DPv2-With-Select.mdp     |   27 -
 .../LeftJoin-UnsupportedFilter-Cardinality.mdp     |   27 -
 .../data/dxl/minidump/LeftJoin-With-Coalesce.mdp   |   36 +-
 .../dxl/minidump/LeftJoin-With-Col-Const-Pred.mdp  |  120 +-
 .../dxl/minidump/LeftJoin-With-Pred-On-Inner.mdp   |   18 -
 .../dxl/minidump/LeftJoin-With-Pred-On-Inner2.mdp  |   18 -
 .../minidump/LeftJoinBroadcastTableHashSpec.mdp    |  291 +-
 .../data/dxl/minidump/LeftJoinDPv2JoinOrder.mdp    |   36 -
 .../dxl/minidump/LeftJoinNullsNotColocated.mdp     |   27 -
 .../gporca/data/dxl/minidump/LeftJoinPruning.mdp   |   32 +-
 .../minidump/LeftJoinPruningInOuterInnerQuery.mdp  |   44 +-
 .../dxl/minidump/LeftJoinPruningInnerQuery.mdp     |   53 +-
 .../dxl/minidump/LeftJoinPruningOuterQuery.mdp     |   24 +-
 .../LeftOuter2InnerUnionAllAntiSemiJoin-Tpcds.mdp  |   95 -
 .../LeftOuter2InnerUnionAllAntiSemiJoin.mdp        |  110 +-
 .../dxl/minidump/LikePredStatsNotComparable.mdp    |    8 -
 .../data/dxl/minidump/ListPartLossyCastEq.mdp      |   38 +-
 .../data/dxl/minidump/ListPartLossyCastLT.mdp      |   38 +-
 .../data/dxl/minidump/ListPartLossyCastNEq.mdp     |   11 +-
 .../dxl/minidump/LogicalIndexGetDroppedCols.mdp    |   39 +-
 .../data/dxl/minidump/MDQA-SameDQAColumn.mdp       |   24 +-
 .../data/dxl/minidump/MDQAs-Grouping-OrderBy.mdp   |    9 -
 .../gporca/data/dxl/minidump/MDQAs-Grouping.mdp    |    9 -
 .../gporca/data/dxl/minidump/MDQAs-Union.mdp       |   29 +-
 src/backend/gporca/data/dxl/minidump/MDQAs1.mdp    |    9 -
 .../data/dxl/minidump/ManyTextUnionsInSubquery.mdp |   20 +-
 src/backend/gporca/data/dxl/minidump/Minidump.xml  |    4 -
 .../data/dxl/minidump/MissingBoolColStats.mdp      |   19 +-
 .../gporca/data/dxl/minidump/MissingStats.mdp      |   10 -
 .../MotionHazard-MaterializeUnderResult.mdp        |   30 -
 ...MotionHazard-NoMaterializeGatherUnderResult.mdp |   30 -
 ...otionHazard-NoMaterializeHashAggUnderResult.mdp |   46 +-
 .../MotionHazard-NoMaterializeSortUnderResult.mdp  |   30 -
 .../MultiColumnAggWithDefaultOpfamilies.mdp        |   26 +-
 ...tiColumnDQA-InnerJoin-GroupBy-HashAggregate.mdp |   20 +-
 .../dxl/minidump/MultiDistKeyJoinCardinality.mdp   |   18 -
 .../MultiDistKeyWithOtherPredsJoinCardinality.mdp  |   22 -
 .../dxl/minidump/MultiLevel-CorrelatedExec.mdp     |   27 -
 .../data/dxl/minidump/MultiLevel-IN-Subquery.mdp   |   27 -
 .../dxl/minidump/MultiLevel-NOT-IN-Subquery.mdp    |   27 -
 .../MultiLevelDecorrelationWithSemiJoins.mdp       |   32 -
 .../dxl/minidump/MultiLevelPartLossyCastNEq.mdp    |   12 +-
 .../minidump/MultipleDampedPredJoinCardinality.mdp |   18 -
 .../MultipleIndependentPredJoinCardinality.mdp     |   27 -
 .../data/dxl/minidump/MultipleIndexPredicate.mdp   |   65 +-
 .../minidump/MultipleSubqueriesInSelectClause.mdp  |    7 -
 .../minidump/MultipleUpdateWithJoinOnDistCol.mdp   |   18 -
 .../data/dxl/minidump/NLJ-BC-Outer-Spool-Inner.mdp |    8 -
 .../dxl/minidump/NLJ-Broadcast-DPE-Outer-Child.mdp |   40 +-
 .../data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp |   18 -
 .../dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp     |   18 -
 .../NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp  |   18 -
 .../NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp  |   18 -
 .../data/dxl/minidump/NLJ-Rewindability-CTAS.mdp   |   29 +-
 .../gporca/data/dxl/minidump/NLJ-Rewindability.mdp |   20 +-
 .../gporca/data/dxl/minidump/NOT-IN-ArrayCmp.mdp   |   18 -
 .../data/dxl/minidump/NOT-IN-NotNullBoth.mdp       |    9 -
 .../gporca/data/dxl/minidump/NOT-IN-NullInner.mdp  |   18 -
 .../gporca/data/dxl/minidump/NOT-IN-NullOuter.mdp  |   18 -
 .../gporca/data/dxl/minidump/Name-Cardinality.mdp  |    8 -
 .../dxl/minidump/NaryWithLojAndNonLojChilds.mdp    |   45 -
 .../data/dxl/minidump/Negative-IndexApply1.mdp     |   23 +-
 .../data/dxl/minidump/Negative-IndexApply2.mdp     |   61 +-
 .../data/dxl/minidump/Nested-Or-Predicates.mdp     |   94 -
 .../gporca/data/dxl/minidump/Nested-Setops-2.mdp   |   65 +-
 .../gporca/data/dxl/minidump/Nested-Setops.mdp     |  262 +-
 .../NestedInSubqWithPrjListOuterRefNoInnerRef.mdp  |   25 -
 .../dxl/minidump/NestedJoinWithCastedColumn.mdp    |   49 +-
 .../dxl/minidump/NestedNLJWithBlockingSpool.mdp    |   49 +-
 .../NestedProjectCountStarWithOuterRefs.mdp        |   18 -
 .../data/dxl/minidump/NestedSubqLimitBindings.mdp  |  372 +-
 .../data/dxl/minidump/NewBtreeIndexScanCost.mdp    |   47 +-
 .../NoBroadcastUnderGatherForWindowFunction.mdp    |  101 +-
 .../minidump/NoDistKeyMultiPredJoinCardinality.mdp |   20 -
 .../dxl/minidump/NoHashAggWithoutPrelimFunc.mdp    |   17 -
 .../gporca/data/dxl/minidump/NoMissingStats.mdp    |   10 -
 .../dxl/minidump/NoMissingStatsAfterDroppedCol.mdp |   10 -
 .../NoMissingStatsAskingForSystemColFOJ.mdp        |   19 -
 .../dxl/minidump/NoMissingStatsForEmptyTable.mdp   |   10 -
 .../gporca/data/dxl/minidump/NoMotionsPlan.mdp     |   69 -
 ...PartConstraint-WhenNoDefaultPartsAndIndices.mdp |   14 +-
 .../data/dxl/minidump/NoPartPropagationPlan.mdp    |   65 +-
 .../minidump/NoPushdownPredicateWithCTEAnchor.mdp  |    9 -
 .../data/dxl/minidump/NoRedistributeOnAppend.mdp   |  542 +-
 .../gporca/data/dxl/minidump/NoSortPlan.mdp        |   20 +-
 .../data/dxl/minidump/Non-Hashjoinable-Pred-2.mdp  |   18 -
 .../data/dxl/minidump/Non-Hashjoinable-Pred.mdp    |   33 +-
 ...ngHomogenousIndexesOnRoot-ANDPredicate-HEAP.mdp |   56 +-
 .../gporca/data/dxl/minidump/NonSingleton.mdp      |   16 -
 .../gporca/data/dxl/minidump/NonSplittableAgg.mdp  |    9 -
 .../NotExists-SuperflousOuterRefWithGbAgg.mdp      |   18 -
 .../dxl/minidump/NotExists-SuperfluousEquality.mdp |   18 -
 .../gporca/data/dxl/minidump/NotInToLASJ.mdp       |    8 -
 .../NotWellDefinedDisjunctConjunctPredicates.mdp   |    9 -
 .../data/dxl/minidump/NullConstant-INDF-Col.mdp    |    8 -
 .../data/dxl/minidump/NullIf-With-Subquery.mdp     |   18 -
 .../gporca/data/dxl/minidump/OR-WithIsNullPred.mdp |   10 -
 src/backend/gporca/data/dxl/minidump/OR.mdp        |   16 -
 .../OneDistKeyMultiPredJoinCardinality.mdp         |   20 -
 .../data/dxl/minidump/OneLevel-CorrelatedExec.mdp  |   27 -
 .../gporca/data/dxl/minidump/OneSegmentGather.mdp  |    9 -
 .../OptimizerConfigWithSegmentsForCosting.mdp      |    9 -
 ...ableHashSpec.mdp => OrderByNoRedundantSort.mdp} |  459 +-
 .../gporca/data/dxl/minidump/OrderByNullsFirst.mdp |    9 -
 .../gporca/data/dxl/minidump/OrderByOuterRef.mdp   |   18 -
 .../dxl/minidump/OrderedAgg_array_fraction.mdp     |   12 -
 .../data/dxl/minidump/OrderedAgg_computed_col.mdp  |   12 -
 .../dxl/minidump/OrderedAgg_multiple_diffcol.mdp   |   52 +-
 .../dxl/minidump/OrderedAgg_multiple_samecol.mdp   |   30 +-
 .../OrderedAgg_multiple_samecol_difforderespec.mdp |   50 +-
 .../gporca/data/dxl/minidump/OrderedAgg_single.mdp |   30 +-
 .../data/dxl/minidump/OrderedAgg_skewed_data.mdp   |  141 +-
 .../data/dxl/minidump/OrderedAgg_with_groupby.mdp  |   20 +-
 .../dxl/minidump/OrderedAgg_with_nonOrderedAgg.mdp |   54 +-
 .../minidump/OrderedAgg_with_nonconst_fraction.mdp |   36 +-
 .../data/dxl/minidump/OuterJoin-With-OuterRefs.mdp |   27 -
 .../minidump/OuterJoinOnViewWithCastedColumn.mdp   |   18 -
 ...ngHomogenousIndexesOnRoot-ANDPredicate-HEAP.mdp |   48 +-
 .../OverlappingHomogenousIndexesOnRoot-HEAP.mdp    |   48 +-
 .../dxl/minidump/Part-Selection-ConstArray-1.mdp   |   38 +-
 .../dxl/minidump/Part-Selection-ConstArray-2.mdp   |   38 +-
 .../gporca/data/dxl/minidump/Part-Selection-IN.mdp |   38 +-
 .../data/dxl/minidump/Part-Selection-NOT-IN.mdp    |   38 +-
 .../PartConstraint-WhenDefaultPartsAndIndices.mdp  |   16 +-
 ...PartConstraint-WhenIndicesAndNoDefaultParts.mdp |   16 +-
 .../PartConstraint-WithOnlyDefaultPartInfo.mdp     |   14 +-
 .../minidump/PartForeignDifferentExecLocation.mdp  |   27 -
 .../dxl/minidump/PartForeignDifferentServer.mdp    |   36 -
 .../gporca/data/dxl/minidump/PartForeignMixed.mdp  |   45 -
 .../data/dxl/minidump/PartForeignMixedDPE.mdp      |   54 -
 .../data/dxl/minidump/PartForeignMixedSPE.mdp      |   45 -
 .../data/dxl/minidump/PartForeignUniformSPE.mdp    |   27 -
 .../data/dxl/minidump/PartPredsWithRandom.mdp      |   36 -
 .../data/dxl/minidump/PartSelectorOnJoinSide.mdp   |  134 +-
 .../data/dxl/minidump/PartSelectorOnJoinSide2.mdp  |  246 +-
 .../PartTbl-AggWithExistentialSubquery.mdp         |   53 +-
 .../data/dxl/minidump/PartTbl-ArrayCoerce.mdp      |   11 +-
 .../gporca/data/dxl/minidump/PartTbl-ArrayIn.mdp   |   35 +-
 .../minidump/PartTbl-AsymmetricRangePredicate.mdp  |   29 +-
 .../dxl/minidump/PartTbl-AvoidRangePred-DPE.mdp    |  225 -
 .../data/dxl/minidump/PartTbl-CSQ-NonPartKey.mdp   |   66 -
 .../data/dxl/minidump/PartTbl-CSQ-PartKey.mdp      |   70 +-
 .../dxl/minidump/PartTbl-ComplexPredicate1.mdp     |  112 +-
 .../dxl/minidump/PartTbl-ComplexPredicate2.mdp     |  112 +-
 .../dxl/minidump/PartTbl-ComplexPredicate3.mdp     |  112 +-
 .../dxl/minidump/PartTbl-ComplexPredicate4.mdp     |  112 +-
 .../dxl/minidump/PartTbl-ComplexPredicate5.mdp     |  112 +-
 .../PartTbl-ComplexRangePredicate-DefaultPart.mdp  |   46 +-
 ...PartTbl-ComplexRangePredicate-NoDefaultPart.mdp |   38 +-
 .../minidump/PartTbl-DPE-Correlated-NLOuter.mdp    |   38 +-
 .../PartTbl-DPE-DynamicIndexOnlyScan-Range.mdp     | 1033 +++
 .../data/dxl/minidump/PartTbl-DPE-GroupBy.mdp      |   83 -
 .../gporca/data/dxl/minidump/PartTbl-DPE-Limit.mdp |   99 +-
 .../data/dxl/minidump/PartTbl-DPE-Opfamily.mdp     |   54 -
 .../dxl/minidump/PartTbl-DPE-WindowFunction.mdp    |   54 -
 .../gporca/data/dxl/minidump/PartTbl-DPE.mdp       |   89 +-
 .../gporca/data/dxl/minidump/PartTbl-DTS.mdp       |   56 +-
 .../gporca/data/dxl/minidump/PartTbl-DTSEq.mdp     |   56 +-
 .../data/dxl/minidump/PartTbl-DTSLessThan.mdp      |   56 +-
 .../gporca/data/dxl/minidump/PartTbl-DateTime.mdp  |  117 +-
 .../dxl/minidump/PartTbl-DisablePartSelection.mdp  |   56 +-
 .../minidump/PartTbl-DisablePartSelectionJoin.mdp  |   65 +-
 .../data/dxl/minidump/PartTbl-Disjunction.mdp      |   46 +-
 .../minidump/PartTbl-EqPredicateWithCastRange.mdp  |   38 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ1.mdp       |   56 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ2.mdp       |   65 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ3.mdp       |   58 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ4.mdp       |  100 +-
 .../gporca/data/dxl/minidump/PartTbl-HJ5.mdp       |   85 +-
 .../gporca/data/dxl/minidump/PartTbl-IDFList.mdp   |   62 +-
 .../gporca/data/dxl/minidump/PartTbl-IDFNull.mdp   |   62 +-
 .../data/dxl/minidump/PartTbl-IDFWithCast.mdp      |   36 -
 .../dxl/minidump/PartTbl-IndexOnDefPartOnly.mdp    |  164 +-
 .../dxl/minidump/PartTbl-IsNotNullPredicate.mdp    |   42 +-
 .../data/dxl/minidump/PartTbl-IsNullPredicate.mdp  |   72 +-
 .../data/dxl/minidump/PartTbl-JoinOverExcept.mdp   |  121 +-
 .../data/dxl/minidump/PartTbl-JoinOverGbAgg-2.mdp  |  108 +-
 .../data/dxl/minidump/PartTbl-JoinOverGbAgg.mdp    |  124 +-
 .../dxl/minidump/PartTbl-JoinOverIntersect.mdp     |  121 +-
 .../data/dxl/minidump/PartTbl-JoinOverUnion-1.mdp  |  121 +-
 .../data/dxl/minidump/PartTbl-JoinOverUnion-2.mdp  |   65 +-
 .../gporca/data/dxl/minidump/PartTbl-LASJ.mdp      |   80 -
 .../PartTbl-LeftOuterHashJoin-DPE-IsNull.mdp       |   38 +-
 .../PartTbl-LeftOuterNLJoin-DPE-IsNull.mdp         |   38 +-
 .../minidump/PartTbl-List-DPE-Int-Predicates.mdp   |   44 +-
 .../PartTbl-List-DPE-Varchar-Predicates.mdp        |    9 -
 .../data/dxl/minidump/PartTbl-MultiWayJoin.mdp     |   43 -
 .../dxl/minidump/PartTbl-MultiWayJoinWithDPE-2.mdp |  595 +-
 .../dxl/minidump/PartTbl-MultiWayJoinWithDPE.mdp   |  544 +-
 .../dxl/minidump/PartTbl-MultipleEqPredicates.mdp  |  170 +-
 .../data/dxl/minidump/PartTbl-NEqPredicate.mdp     |   66 +-
 .../gporca/data/dxl/minidump/PartTbl-NLJ.mdp       |   65 +-
 .../data/dxl/minidump/PartTbl-NonConstSelect.mdp   |  117 +-
 .../dxl/minidump/PartTbl-PredicateWithCast.mdp     |   38 +-
 .../dxl/minidump/PartTbl-PredicateWithCastList.mdp |   38 +-
 .../PartTbl-PredicateWithCastMultiLevelList.mdp    |   14 +-
 .../data/dxl/minidump/PartTbl-RangeJoinPred.mdp    |   84 +-
 .../data/dxl/minidump/PartTbl-Relabel-Equality.mdp |   12 +-
 .../data/dxl/minidump/PartTbl-Relabel-Range.mdp    |   12 +-
 .../PartTbl-RightOuterHashJoin-DPE-IsNull-V2.mdp   |   36 -
 .../data/dxl/minidump/PartTbl-SPE-Boolean1.mdp     |   27 -
 .../data/dxl/minidump/PartTbl-SPE-Boolean2.mdp     |   36 -
 .../PartTbl-SPE-DynamicTableScan-List-Cost1.mdp    |   62 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost2.mdp    |   62 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost3.mdp    |   62 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost4.mdp    |   62 +-
 .../PartTbl-SPE-DynamicTableScan-List-Cost5.mdp    |   62 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost1.mdp   |  122 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost2.mdp   |  122 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost3.mdp   |  122 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost4.mdp   |   22 +-
 .../PartTbl-SPE-DynamicTableScan-Range-Cost5.mdp   |  122 +-
 .../gporca/data/dxl/minidump/PartTbl-SQAll.mdp     |   94 +-
 .../gporca/data/dxl/minidump/PartTbl-SQAny.mdp     |  104 +-
 .../gporca/data/dxl/minidump/PartTbl-SQExists.mdp  |   96 +-
 .../data/dxl/minidump/PartTbl-SQNotExists.mdp      |   96 +-
 .../gporca/data/dxl/minidump/PartTbl-SQScalar.mdp  |  104 +-
 .../data/dxl/minidump/PartTbl-SubqueryOuterRef.mdp |   61 +-
 .../data/dxl/minidump/PartTbl-VolatileFunc.mdp     |   56 +-
 .../PartTbl-WindowFuncNoDisjunctPredPushDown.mdp   |   12 +-
 .../minidump/PartTbl-WindowFuncNoPredPushDown.mdp  |   13 +-
 .../PartTbl-WindowFuncPartialPredPushDown.mdp      |   13 +-
 .../minidump/PartTbl-WindowFuncPredPushDown.mdp    |   13 +-
 .../PartTbl-WindowFuncSinglePredPushDown.mdp       |   12 +-
 .../data/dxl/minidump/PartTbl-WindowFunction.mdp   |   56 +-
 .../data/dxl/minidump/PredStatsNotComparable.mdp   |    8 -
 .../PredicateWithConjunctsAndDisjuncts.mdp         |   21 +-
 .../minidump/PredicateWithConjunctsOfDisjuncts.mdp |   21 +-
 .../dxl/minidump/PredicateWithLongConjunction.mdp  |   21 +-
 .../data/dxl/minidump/Preds-Over-WinFunc1.mdp      |   16 +-
 .../data/dxl/minidump/Preds-Over-WinFunc2.mdp      |   18 +-
 .../data/dxl/minidump/Preds-Over-WinFunc3.mdp      |   20 +-
 .../data/dxl/minidump/Preds-Over-WinFunc4.mdp      |   22 +-
 .../data/dxl/minidump/Preds-Over-WinFunc5.mdp      |   22 +-
 ...exOnlyScanOnAppendOnlyVersion6UpgradedTable.mdp |  695 ++
 ...ionedTableContainingAppendOnlyVersion6Child.mdp |  871 +++
 ...ionedTableContainingAppendOnlyVersion6Child.mdp |  871 +++
 .../gporca/data/dxl/minidump/ProjectCountStar.mdp  |   18 -
 .../dxl/minidump/ProjectCountStarWithOuterRefs.mdp |   18 -
 .../data/dxl/minidump/ProjectOutsideCountStar.mdp  |   18 -
 .../data/dxl/minidump/ProjectRepeatedColumn1.mdp   |    9 -
 .../data/dxl/minidump/ProjectRepeatedColumn2.mdp   |    9 -
 .../data/dxl/minidump/ProjectSetFunction.mdp       |    9 -
 .../gporca/data/dxl/minidump/ProjectUnderSubq.mdp  |   18 -
 .../data/dxl/minidump/ProjectWithConstant.mdp      |   10 -
 .../data/dxl/minidump/ProjectWithTextConstant.mdp  |   25 -
 .../data/dxl/minidump/Push-Subplan-Below-Union.mdp | 1082 ++--
 .../PushConstantSelectPredicateThruJoin-1.mdp      |   18 -
 .../PushConstantSelectPredicateThruJoin-10.mdp     |   27 -
 .../PushConstantSelectPredicateThruJoin-11.mdp     |   16 -
 .../PushConstantSelectPredicateThruJoin-12.mdp     |   16 -
 .../PushConstantSelectPredicateThruJoin-13.mdp     |   16 -
 .../PushConstantSelectPredicateThruJoin-14.mdp     |   16 -
 .../PushConstantSelectPredicateThruJoin-15.mdp     |   16 -
 .../PushConstantSelectPredicateThruJoin-16.mdp     |    8 -
 .../PushConstantSelectPredicateThruJoin-17.mdp     |    8 -
 .../PushConstantSelectPredicateThruJoin-2.mdp      |   27 -
 .../PushConstantSelectPredicateThruJoin-3.mdp      |   18 -
 .../PushConstantSelectPredicateThruJoin-4.mdp      |   18 -
 .../PushConstantSelectPredicateThruJoin-5.mdp      |   18 -
 .../PushConstantSelectPredicateThruJoin-6.mdp      |   27 -
 .../PushConstantSelectPredicateThruJoin-7.mdp      |   18 -
 .../PushConstantSelectPredicateThruJoin-8.mdp      |   20 -
 .../PushConstantSelectPredicateThruJoin-9.mdp      |   50 -
 .../dxl/minidump/PushFilterToSemiJoinLeftChild.mdp |   18 +-
 .../dxl/minidump/PushGbBelowJoin-NegativeCase.mdp  |  566 +-
 .../data/dxl/minidump/PushGbBelowNaryUnion-1.mdp   |   27 -
 .../data/dxl/minidump/PushGbBelowNaryUnion-2.mdp   |   47 +-
 .../data/dxl/minidump/PushGbBelowNaryUnionAll.mdp  |   27 -
 .../gporca/data/dxl/minidump/PushGbBelowUnion.mdp  |  329 +-
 .../data/dxl/minidump/PushGbBelowUnionAll.mdp      |   18 -
 .../minidump/PushSelectWithOuterRefBelowUnion.mdp  |  170 +-
 ...ueryMismatchedDistribution-DynamicIndexScan.mdp |  293 +-
 .../dxl/minidump/QueryMismatchedDistribution.mdp   |  216 +-
 ...ueryIdForTargetRel.mdp => RTErequiredPerms.mdp} |  248 +-
 .../RangePartLossyCastEqInPartitionRange.mdp       |  101 +-
 .../RangePartLossyCastEqOnEndPartitionRange.mdp    |  101 +-
 .../RangePartLossyCastLTEqInPartitionRange.mdp     |  101 +-
 .../RangePartLossyCastLTEqOnEndPartitionRange.mdp  |  101 +-
 .../RangePartLossyCastLTInPartitionRange.mdp       |  101 +-
 .../RangePartLossyCastLTOnEndPartitionRange.mdp    |  101 +-
 .../dxl/minidump/Remove-Distinct-From-Subquery.mdp |   88 +-
 .../minidump/RemoveImpliedPredOnBCCPredicates.mdp  |    9 -
 .../data/dxl/minidump/RemoveUnusedProjElements.mdp |   11 -
 .../minidump/RemoveUnusedProjElementsInGbAgg.mdp   |   21 +-
 .../dxl/minidump/ReplicatedHashJoinReplicated.mdp  |   18 -
 .../ReplicatedJoinHashDistributedTable.mdp         |   18 -
 .../minidump/ReplicatedJoinPartitionedTable.mdp    |   65 +-
 .../ReplicatedJoinRandomDistributedTable.mdp       |   18 -
 .../minidump/ReplicatedLOJHashDistributedTable.mdp |   18 -
 .../ReplicatedLOJRandomDistributedTable.mdp        |   18 -
 .../data/dxl/minidump/ReplicatedLOJReplicated.mdp  |   18 -
 .../data/dxl/minidump/ReplicatedNLJReplicated.mdp  |   18 -
 .../data/dxl/minidump/ReplicatedTable-CTAS.mdp     |    2 -
 .../data/dxl/minidump/ReplicatedTableAggregate.mdp |    9 -
 .../data/dxl/minidump/ReplicatedTableCTE.mdp       |   18 -
 .../data/dxl/minidump/ReplicatedTableGroupBy.mdp   |    9 -
 .../data/dxl/minidump/ReplicatedTableInClause.mdp  |   18 -
 .../data/dxl/minidump/ReplicatedTableInsert.mdp    |    9 -
 .../data/dxl/minidump/ReplicatedTableSelect.mdp    |    9 -
 .../dxl/minidump/ReplicatedTableSequenceInsert.mdp |   23 -
 .../minidump/ReplicatedTableWithAggNoMotion.mdp    |   16 -
 .../data/dxl/minidump/RightJoinBothReplicated.mdp  |   18 -
 .../gporca/data/dxl/minidump/RightJoinDPE.mdp      |  243 -
 .../dxl/minidump/RightJoinDpeWithWhereClause.mdp   |   72 -
 .../gporca/data/dxl/minidump/RightJoinHashed.mdp   |   18 -
 .../data/dxl/minidump/RightJoinNoDPSNonDistKey.mdp |  110 +-
 .../data/dxl/minidump/RightJoinRedistribute.mdp    |   18 -
 .../data/dxl/minidump/RightJoinReplicated.mdp      |   18 -
 .../gporca/data/dxl/minidump/RightJoinTVF.mdp      |   19 +-
 .../gporca/data/dxl/minidump/RollupNoAgg.mdp       |   23 +-
 .../data/dxl/minidump/ScSubqueryWithOuterRef.mdp   |   18 -
 .../minidump/ScalarCorrelatedSubqueryCountStar.mdp |  137 +-
 .../dxl/minidump/ScalarDQAWithNonScalarAgg.mdp     |   12 +-
 .../dxl/minidump/ScalarFuncPushedBelowGather.mdp   |    8 -
 .../data/dxl/minidump/ScalarSubqueryCountStar.mdp  |  147 +-
 .../dxl/minidump/ScalarSubqueryCountStarInJoin.mdp |  299 +-
 .../data/dxl/minidump/Select-Over-CTEAnchor.mdp    |   18 -
 .../data/dxl/minidump/Select-Over-PartTbl.mdp      |  115 -
 .../data/dxl/minidump/Select-Proj-OuterJoin.mdp    |   50 +-
 .../data/dxl/minidump/SelectCheckConstraint.mdp    |   20 -
 .../gporca/data/dxl/minidump/SelectOnBpchar.mdp    |   23 -
 .../gporca/data/dxl/minidump/SelectOnCastedCol.mdp |   42 +-
 .../data/dxl/minidump/Self-Comparison-Nullable.mdp |    9 -
 .../gporca/data/dxl/minidump/Self-Comparison.mdp   |    9 -
 .../minidump/SelfJoinDampedPredJoinCardinality.mdp |   10 -
 .../gporca/data/dxl/minidump/SelfUpdate.mdp        |   10 -
 .../data/dxl/minidump/SemiJoin2InnerJoin.mdp       |   18 -
 .../gporca/data/dxl/minidump/SemiJoin2Select-1.mdp |   18 -
 .../gporca/data/dxl/minidump/SemiJoin2Select-2.mdp |   18 -
 .../minidump/SemiJoin2Select-EnforceSubplan.mdp    |   18 -
 .../gporca/data/dxl/minidump/SemiJoinDPE.mdp       |   95 -
 .../minidump/SemiJoinWithWindowsFuncInSubquery.mdp |   26 +-
 .../dxl/minidump/SimplifyExistsSubquery2Limit.mdp  |   18 -
 .../SingleColumnHomogenousIndexOnRoot-AO.mdp       |   26 +-
 .../SingleColumnHomogenousIndexOnRoot-HEAP.mdp     |   42 +-
 .../gporca/data/dxl/minidump/SixWayDPv2.mdp        |   54 -
 .../gporca/data/dxl/minidump/SortOverStreamAgg.mdp |   51 +-
 ...SpoolShouldInvalidateUnresolvedDynamicScans.mdp |   56 +-
 .../gporca/data/dxl/minidump/SqlFuncDmlScalar.mdp  |   16 -
 .../gporca/data/dxl/minidump/SqlFuncDmlTvf.mdp     |   19 +-
 .../gporca/data/dxl/minidump/SqlFuncNullReject.mdp |   16 -
 .../data/dxl/minidump/SqlFuncPredFactorize.mdp     |   17 -
 .../dxl/minidump/Stat-Derivation-Leaf-Pattern.mdp  |  100 +-
 .../minidump/Stats-For-Select-With-Outer-Refs.mdp  |   36 -
 .../minidump/StatsFilter-AnyWithNewColStats.mdp    |   10 -
 .../data/dxl/minidump/Subq-JoinWithOuterRef.mdp    |   27 -
 .../gporca/data/dxl/minidump/Subq-NoParams.mdp     |   18 -
 .../gporca/data/dxl/minidump/Subq-On-OuterRef.mdp  |   18 -
 .../data/dxl/minidump/Subq-With-OuterRefCol.mdp    |   18 -
 .../data/dxl/minidump/Subq2CorrSQInLOJOn.mdp       |   27 -
 .../data/dxl/minidump/Subq2NotInWhereLOJ.mdp       |  705 +-
 .../data/dxl/minidump/Subq2OuterRef2InJoin.mdp     |   27 -
 .../dxl/minidump/Subq2OuterRefMultiLevelInOn.mdp   |   27 -
 .../data/dxl/minidump/Subq2PartialDecorrelate.mdp  |   27 -
 .../minidump/SubqAll-InsideScalarExpression.mdp    |   22 +-
 .../gporca/data/dxl/minidump/SubqAll-Limit1.mdp    |   18 -
 .../data/dxl/minidump/SubqAll-To-ScalarSubq.mdp    |  346 +-
 .../minidump/SubqAny-InsideScalarExpression.mdp    |  192 +-
 .../data/dxl/minidump/SubqEnforceSubplan.mdp       |   16 -
 .../minidump/SubqExists-With-External-Corrs.mdp    |   33 +-
 .../minidump/SubqExists-Without-External-Corrs.mdp |   27 -
 .../gporca/data/dxl/minidump/SubqInIndexPred.mdp   |   34 +-
 .../dxl/minidump/SubqOuterReferenceInClause.mdp    |   24 +-
 .../dxl/minidump/Subquery-AnyAllAggregates.mdp     |   34 +-
 .../dxl/minidump/Subquery-ExistsAllAggregates.mdp  |   43 +-
 .../Subquery-ExistsAllAggregatesWithDisjuncts.mdp  |   43 +-
 .../data/dxl/minidump/SubqueryInsideScalarIf.mdp   |   30 -
 .../gporca/data/dxl/minidump/SubqueryNullTest.mdp  |   20 -
 .../data/dxl/minidump/SubqueryOuterRefLimit.mdp    |   17 -
 .../data/dxl/minidump/SubqueryOuterRefTVF.mdp      |   13 +-
 .../data/dxl/minidump/Switch-With-Subquery.mdp     |  129 +-
 .../minidump/TPCDS-39-InnerJoin-JoinEstimate.mdp   |   50 +-
 .../data/dxl/minidump/TPCH-Partitioned-256GB.mdp   |  159 +-
 .../data/dxl/minidump/TVF-With-Deep-Subq-Args.mdp  |   10 -
 .../gporca/data/dxl/minidump/TVFVolatileJoin.mdp   |    9 -
 .../data/dxl/minidump/TaintedReplicatedAgg.mdp     |   16 -
 .../data/dxl/minidump/TaintedReplicatedFilter.mdp  |    9 -
 .../data/dxl/minidump/TaintedReplicatedLimit.mdp   |   16 -
 .../dxl/minidump/TaintedReplicatedTablesCTE.mdp    |   20 +-
 .../dxl/minidump/TaintedReplicatedWindowAgg.mdp    |   16 -
 .../data/dxl/minidump/TextMCVCardinalityEquals.mdp |    9 -
 .../dxl/minidump/TextMCVCardinalityGreaterThan.mdp |    8 -
 .../ThreeStageAgg-DistinctOnComputedCol.mdp        |   26 +-
 .../minidump/ThreeStageAgg-DistinctOnDistrCol.mdp  |   24 +-
 .../ThreeStageAgg-DistinctOnSameNonDistrCol.mdp    |   26 +-
 ...eeStageAgg-GbMultipleCol-DistinctOnDistrCol.mdp |   24 +-
 .../ThreeStageAgg-GbandDistinctOnDistrCol.mdp      |   22 +-
 ...ThreeStageAgg-ScalarAgg-DistinctComputedCol.mdp |   10 -
 .../ThreeStageAgg-ScalarAgg-DistinctDistrCol.mdp   |   10 -
 ...ThreeStageAgg-ScalarAgg-DistinctNonDistrCol.mdp |   10 -
 .../gporca/data/dxl/minidump/ThreeStageAgg.mdp     |   26 +-
 .../data/dxl/minidump/TimeStamp-Date-HashJoin.mdp  |   18 -
 .../dxl/minidump/Tpcds-10TB-Q37-NoIndexJoin.mdp    | 1156 +---
 .../data/dxl/minidump/Tpcds-NonPart-Q70a.mdp       | 1179 ++--
 .../dxl/minidump/TranslateFilterDisjunctQuals.mdp  |   27 -
 ...thCTEAndTableScanIntoFilterAndOneTimeFilter.mdp |   18 -
 .../TranslateOneTimeFilterConjunctQuals.mdp        |   27 -
 .../data/dxl/minidump/TypeModifierArrayRef.mdp     |    9 -
 .../gporca/data/dxl/minidump/TypeModifierCast.mdp  |    9 -
 .../data/dxl/minidump/TypeModifierColumn.mdp       |    9 -
 .../gporca/data/dxl/minidump/UDA-AnyArray.mdp      |  129 +-
 .../gporca/data/dxl/minidump/UDA-AnyElement-1.mdp  |    9 -
 .../gporca/data/dxl/minidump/UDA-AnyElement-2.mdp  |    9 -
 .../Union-Distributed-Table-With-Const-Table.mdp   |   10 -
 .../dxl/minidump/Union-NOT-Plus-OR-Constraint.mdp  |   20 +-
 .../minidump/Union-OuterRefs-Casting-Output.mdp    |   17 -
 .../dxl/minidump/Union-OuterRefs-InnerChild.mdp    |   17 -
 .../data/dxl/minidump/Union-OuterRefs-Output.mdp   |   17 -
 .../data/dxl/minidump/Union-Over-UnionAll.mdp      |   19 +-
 src/backend/gporca/data/dxl/minidump/UnionAll.mdp  |  109 +-
 .../dxl/minidump/UnionAllCompatibleDataType.mdp    |   33 -
 .../dxl/minidump/UnionAllWithTruncatedOutput.mdp   |   18 -
 .../gporca/data/dxl/minidump/UnionGbSubquery.mdp   |   10 +-
 .../gporca/data/dxl/minidump/UnionOfDQAQueries.mdp |   15 +-
 .../gporca/data/dxl/minidump/UnionWithCTE.mdp      |  126 +-
 .../data/dxl/minidump/UnionWithOuterRefs.mdp       |   18 -
 .../gporca/data/dxl/minidump/UnnestSQJoins.mdp     |   92 +-
 .../dxl/minidump/UnsupportedStatsPredicate.mdp     |   53 +-
 .../data/dxl/minidump/UpdateCardinalityAssert.mdp  |   18 -
 .../data/dxl/minidump/UpdateCheckConstraint.mdp    |   22 -
 .../UpdateDistKeyMismatchedDistribution.mdp        |   70 -
 .../dxl/minidump/UpdateDistKeyWithNestedJoin.mdp   |    9 -
 .../gporca/data/dxl/minidump/UpdateDistrKey.mdp    |   18 -
 .../gporca/data/dxl/minidump/UpdateDroppedCols.mdp |   60 -
 .../dxl/minidump/UpdateNoCardinalityAssert.mdp     |    9 -
 .../UpdateNoDistKeyMismatchedDistribution.mdp      |   70 -
 .../dxl/minidump/UpdateNoEnforceConstraints.mdp    |   10 -
 .../gporca/data/dxl/minidump/UpdateNotNullCols.mdp |   18 -
 .../gporca/data/dxl/minidump/UpdatePartTable.mdp   |   60 -
 .../gporca/data/dxl/minidump/UpdateRandomDistr.mdp |    9 -
 .../data/dxl/minidump/UpdateUniqueConstraint-2.mdp |   29 +-
 .../data/dxl/minidump/UpdateUniqueConstraint.mdp   |   13 +-
 .../data/dxl/minidump/UpdateVolatileFunction.mdp   |    9 -
 .../data/dxl/minidump/UpdateWindowGatherMerge.mdp  |    9 -
 .../data/dxl/minidump/UpdateWithHashJoin.mdp       |   18 -
 .../gporca/data/dxl/minidump/UpdateZeroRows.mdp    |   60 -
 .../dxl/minidump/UpdatingDistributionColumn.mdp    |    9 -
 .../data/dxl/minidump/UpdatingMultipleColumn.mdp   |    9 -
 .../dxl/minidump/UpdatingNonDistColSameTable.mdp   |   10 -
 .../minidump/UpdatingNonDistributionColumnFunc.mdp |    9 -
 ...tributionSatisfactionForUniversalInnerChild.mdp |    6 +-
 .../dxl/minidump/VarcharMCVCardinalityEquals.mdp   |    8 -
 .../minidump/VarcharMCVCardinalityGreaterThan.mdp  |    8 -
 .../data/dxl/minidump/VariadicFlagWithJson.mdp     |   10 -
 .../minidump/VolatileFunctionsBelowScalarAgg.mdp   |    8 -
 .../WinFunc-Redistribute-Sort-CTE-Producer.mdp     |    9 -
 .../gporca/data/dxl/minidump/WinFunc-Simple.mdp    |    9 -
 .../data/dxl/minidump/WinFuncWithSubqArgs.mdp      |   18 -
 .../data/dxl/minidump/WindowFrame-SingleEdged.mdp  |   10 -
 .../data/dxl/minidump/cte-duplicate-columns-1.mdp  |    9 -
 .../data/dxl/minidump/cte-duplicate-columns-2.mdp  |    9 -
 .../data/dxl/minidump/cte-duplicate-columns-3.mdp  |    9 -
 .../data/dxl/minidump/cte-duplicate-columns-4.mdp  |    9 -
 src/backend/gporca/data/dxl/minidump/retail_28.mdp |   82 +-
 .../data/dxl/minidump/window-count-gpdb6.mdp       |   10 -
 ...tilevel-Casting-cast_boundary_value_to_date.mdp |   13 +-
 ...level-Casting-cast_partition_column_to_text.mdp |   13 +-
 .../Multilevel-Casting-no_casting.mdp              |   13 +-
 .../Multilevel-Casting-predicate-on-all-levels.mdp |   13 +-
 ...ilevel-Casting-predicate-on-non-leaf-levels.mdp |   13 +-
 ...ilevel-Casting-predicate-on-non-root-levels.mdp |   13 +-
 .../Multilevel-ConstPred-AllLevels-Default.mdp     |   12 +-
 .../Multilevel-ConstPred-AllLevels-NoDefault.mdp   |   12 +-
 .../Multilevel-ConstPred-Level1-Default.mdp        |   12 +-
 .../Multilevel-ConstPred-Level1-NoDefault.mdp      |   12 +-
 .../Multilevel-ConstPred-Level2-Default.mdp        |   12 +-
 .../Multilevel-ConstPred-Level2-NoDefault.mdp      |   12 +-
 .../Multilevel-FullScan.mdp                        |   12 +-
 .../Multilevel-JoinPred-AllLevels.mdp              |   13 +-
 .../Multilevel-JoinPred-Level1.mdp                 |   13 +-
 .../Multilevel-JoinPred-Level2.mdp                 |   13 +-
 .../Multilevel-Nary-Join.mdp                       |   18 +-
 .../gporca/data/dxl/parse_tests/q26-Metadata.xml   |  240 +-
 .../gporca/data/dxl/tpch/q1-partitioned.mdp        |   25 +-
 src/backend/gporca/data/dxl/tpch/q1.mdp            |   23 -
 src/backend/gporca/data/dxl/tpch/q10.mdp           |   65 -
 src/backend/gporca/data/dxl/tpch/q11.mdp           |   37 -
 src/backend/gporca/data/dxl/tpch/q12.mdp           |   39 -
 src/backend/gporca/data/dxl/tpch/q13.mdp           |   31 -
 src/backend/gporca/data/dxl/tpch/q14.mdp           |   39 -
 src/backend/gporca/data/dxl/tpch/q15.mdp           |   37 -
 src/backend/gporca/data/dxl/tpch/q16.mdp           |   42 -
 src/backend/gporca/data/dxl/tpch/q17.mdp           |   39 -
 src/backend/gporca/data/dxl/tpch/q18.mdp           |   54 -
 src/backend/gporca/data/dxl/tpch/q19.mdp           |   39 -
 src/backend/gporca/data/dxl/tpch/q2.mdp            |   63 -
 src/backend/gporca/data/dxl/tpch/q20.mdp           |   76 -
 src/backend/gporca/data/dxl/tpch/q21.mdp           |   64 -
 src/backend/gporca/data/dxl/tpch/q22.mdp           |   31 -
 src/backend/gporca/data/dxl/tpch/q3.mdp            |   54 -
 src/backend/gporca/data/dxl/tpch/q4.mdp            |   39 -
 src/backend/gporca/data/dxl/tpch/q5.mdp            |   89 -
 src/backend/gporca/data/dxl/tpch/q6.mdp            |   23 -
 src/backend/gporca/data/dxl/tpch/q7.mdp            |   79 -
 src/backend/gporca/data/dxl/tpch/q8.mdp            |  105 -
 src/backend/gporca/data/dxl/tpch/q9.mdp            |   92 -
 .../gporca/libgpdbcost/src/CCostModelGPDB.cpp      |  165 +-
 .../include/gpopt/base/CDistributionSpec.h         |   25 +
 .../gpopt/base/CDistributionSpecNonReplicated.h    |   81 +
 .../libgpopt/include/gpopt/base/COrderSpec.h       |    7 +-
 .../gporca/libgpopt/include/gpopt/base/CUtils.h    |    3 +
 .../gporca/libgpopt/include/gpopt/exception.h      |    2 +-
 .../include/gpopt/metadata/CIndexDescriptor.h      |    2 +-
 .../include/gpopt/metadata/CTableDescriptor.h      |   22 +-
 .../libgpopt/include/gpopt/operators/CLogical.h    |   10 +-
 .../include/gpopt/operators/CLogicalIndexGet.h     |   13 +-
 .../gpopt/operators/CLogicalPartitionSelector.h    |  201 -
 .../libgpopt/include/gpopt/operators/COperator.h   |    3 +
 .../operators/CPhysicalDynamicIndexOnlyScan.h      |   92 +
 .../gpopt/operators/CPhysicalIndexOnlyScan.h       |   12 +-
 .../include/gpopt/operators/CPhysicalIndexScan.h   |   12 +-
 .../include/gpopt/operators/CPredicateUtils.h      |   28 +-
 .../{CScalarArrayRef.h => CScalarFieldSelect.h}    |  122 +-
 .../include/gpopt/translate/CTranslatorDXLToExpr.h |    3 +
 .../include/gpopt/translate/CTranslatorExprToDXL.h |   19 +-
 .../gporca/libgpopt/include/gpopt/xforms/CXform.h  |    1 +
 ...> CXformDynamicIndexGet2DynamicIndexOnlyScan.h} |   33 +-
 .../libgpopt/include/gpopt/xforms/CXformFactory.h  |    2 +-
 .../xforms/CXformImplementPartitionSelector.h      |   75 -
 .../include/gpopt/xforms/CXformLimit2IndexGet.h    |   15 +-
 .../libgpopt/include/gpopt/xforms/CXformUtils.h    |   51 +-
 .../gporca/libgpopt/include/gpopt/xforms/xforms.h  |    2 +-
 .../gporca/libgpopt/src/base/CColumnFactory.cpp    |    3 +-
 .../libgpopt/src/base/CDistributionSpecHashed.cpp  |    5 +-
 .../libgpopt/src/base/CDistributionSpecRandom.cpp  |    3 +-
 .../src/base/CDistributionSpecReplicated.cpp       |    6 +
 .../src/base/CDistributionSpecSingleton.cpp        |    4 +-
 .../src/base/CDistributionSpecStrictRandom.cpp     |    2 +-
 .../src/base/CDistributionSpecStrictSingleton.cpp  |    4 +-
 src/backend/gporca/libgpopt/src/exception.cpp      |   63 +-
 src/backend/gporca/libgpopt/src/init.cpp           |   19 +-
 .../libgpopt/src/metadata/CIndexDescriptor.cpp     |    8 +-
 .../libgpopt/src/metadata/CTableDescriptor.cpp     |    7 +-
 .../src/operators/CExpressionPreprocessor.cpp      |   11 +-
 .../gporca/libgpopt/src/operators/CLogical.cpp     |   48 +-
 .../src/operators/CLogicalDynamicIndexGet.cpp      |    8 +-
 .../libgpopt/src/operators/CLogicalIndexGet.cpp    |   21 +-
 .../src/operators/CLogicalPartitionSelector.cpp    |  193 -
 .../operators/CPhysicalDynamicIndexOnlyScan.cpp    |   32 +
 .../libgpopt/src/operators/CPhysicalHashJoin.cpp   |   44 +-
 .../src/operators/CPhysicalIndexOnlyScan.cpp       |    9 +-
 .../libgpopt/src/operators/CPhysicalIndexScan.cpp  |    9 +-
 .../src/operators/CPhysicalInnerNLJoin.cpp         |    6 +-
 .../libgpopt/src/operators/CPhysicalJoin.cpp       |   10 +-
 .../libgpopt/src/operators/CPredicateUtils.cpp     |   77 +-
 .../libgpopt/src/operators/CScalarFieldSelect.cpp  |   96 +
 src/backend/gporca/libgpopt/src/operators/Makefile |    3 +-
 .../libgpopt/src/search/CSchedulerContext.cpp      |    4 +-
 .../src/translate/CTranslatorDXLToExpr.cpp         |   51 +-
 .../src/translate/CTranslatorExprToDXL.cpp         |  161 +-
 ...CXformDynamicIndexGet2DynamicIndexOnlyScan.cpp} |   76 +-
 .../CXformDynamicIndexGet2DynamicIndexScan.cpp     |   10 +-
 .../gporca/libgpopt/src/xforms/CXformFactory.cpp   |   45 +-
 .../xforms/CXformImplementPartitionSelector.cpp    |   85 -
 .../src/xforms/CXformIndexGet2IndexOnlyScan.cpp    |   79 +-
 .../src/xforms/CXformIndexGet2IndexScan.cpp        |   11 +-
 .../libgpopt/src/xforms/CXformJoin2IndexApply.cpp  |    6 +-
 .../libgpopt/src/xforms/CXformLimit2IndexGet.cpp   |  119 +-
 .../src/xforms/CXformSelect2DynamicIndexGet.cpp    |    8 +-
 .../libgpopt/src/xforms/CXformSelect2IndexGet.cpp  |    6 +-
 .../gporca/libgpopt/src/xforms/CXformSplitDQA.cpp  |    6 +-
 .../libgpopt/src/xforms/CXformUpdate2DML.cpp       |    1 -
 .../gporca/libgpopt/src/xforms/CXformUtils.cpp     |  141 +-
 src/backend/gporca/libgpopt/src/xforms/Makefile    |    2 +-
 src/backend/gporca/libgpos/include/gpos/_api.h     |    3 -
 .../libgpos/include/gpos/common/DbgPrintMixin.h    |    3 +-
 .../include/gpos/error/CMessageRepository.h        |    4 +-
 .../gporca/libgpos/include/gpos/memory/CCache.h    |    2 +-
 .../libgpos/include/gpos/memory/CCacheAccessor.h   |    4 +-
 .../libgpos/include/gpos/memory/CCacheFactory.h    |    6 +-
 .../include/gpos/memory/CMemoryPoolManager.h       |   39 +-
 .../libgpos/include/gpos/string/CStringStatic.h    |    2 -
 .../libgpos/include/gpos/string/CWStringBase.h     |    7 +-
 .../libgpos/include/gpos/string/CWStringConst.h    |    1 +
 .../libgpos/include/gpos/task/CWorkerPoolManager.h |    2 +-
 .../src/unittest/gpos/string/CWStringTest.cpp      |    6 +
 src/backend/gporca/libgpos/src/_api.cpp            |   52 +-
 .../gporca/libgpos/src/common/CDebugCounter.cpp    |   12 +-
 .../libgpos/src/error/CMessageRepository.cpp       |   24 +-
 .../gporca/libgpos/src/memory/CAutoMemoryPool.cpp  |    8 +-
 .../gporca/libgpos/src/memory/CCacheFactory.cpp    |   41 +-
 .../libgpos/src/memory/CMemoryPoolManager.cpp      |   36 +-
 .../gporca/libgpos/src/string/CWStringBase.cpp     |   18 +-
 .../gporca/libgpos/src/string/CWStringConst.cpp    |   46 +-
 src/backend/gporca/libgpos/src/task/CTask.cpp      |    2 +-
 .../gporca/libgpos/src/task/CWorkerPoolManager.cpp |   39 +-
 .../libnaucrates/include/naucrates/dxl/CDXLUtils.h |    4 +
 .../include/naucrates/dxl/operators/CDXLOperator.h |    2 +
 .../naucrates/dxl/operators/CDXLOperatorFactory.h  |   10 +
 .../naucrates/dxl/operators/CDXLPhysicalAppend.h   |   41 -
 .../operators/CDXLPhysicalDynamicIndexOnlyScan.h   |   68 +
 .../dxl/operators/CDXLScalarFieldSelect.h          |  109 +
 .../naucrates/dxl/operators/CDXLTableDescr.h       |    9 +-
 .../dxl/parser/CParseHandlerDefaultValueExpr.h     |   68 -
 ...xScan.h => CParseHandlerDynamicIndexOnlyScan.h} |   30 +-
 .../naucrates/dxl/parser/CParseHandlerFactory.h    |   15 +-
 .../naucrates/dxl/parser/CParseHandlerMDIndex.h    |   13 +-
 .../naucrates/dxl/parser/CParseHandlerMDRelation.h |    4 +-
 .../dxl/parser/CParseHandlerMetadataColumn.h       |    3 -
 ...rceViaIO.h => CParseHandlerScalarFieldSelect.h} |   39 +-
 .../include/naucrates/dxl/parser/parsehandlers.h   |    3 +-
 .../include/naucrates/dxl/xml/dxltokens.h          |   21 +-
 .../libnaucrates/include/naucrates/exception.h     |   17 +-
 .../libnaucrates/include/naucrates/md/CMDColumn.h  |    4 -
 .../libnaucrates/include/naucrates/md/CMDIdCast.h  |    4 +-
 .../include/naucrates/md/CMDIdColStats.h           |    4 +-
 .../libnaucrates/include/naucrates/md/CMDIdGPDB.h  |    4 +-
 .../include/naucrates/md/CMDIdRelStats.h           |    4 +-
 .../libnaucrates/include/naucrates/md/CMDIdScCmp.h |    4 +-
 .../include/naucrates/md/CMDIndexGPDB.h            |   33 +-
 .../include/naucrates/md/CMDPartConstraintGPDB.h   |   88 -
 .../include/naucrates/md/CMDRelationCtasGPDB.h     |    6 +
 .../include/naucrates/md/CMDRelationGPDB.h         |   28 +-
 .../libnaucrates/include/naucrates/md/IMDIndex.h   |   15 +
 .../include/naucrates/md/IMDRelation.h             |   22 +
 .../include/naucrates/statistics/CStatistics.h     |   11 +
 src/backend/gporca/libnaucrates/src/CDXLUtils.cpp  |   57 +-
 src/backend/gporca/libnaucrates/src/exception.cpp  |  141 +-
 src/backend/gporca/libnaucrates/src/init.cpp       |   22 +-
 .../gporca/libnaucrates/src/md/CMDColumn.cpp       |   20 +-
 .../gporca/libnaucrates/src/md/CMDIdCast.cpp       |   15 +-
 .../gporca/libnaucrates/src/md/CMDIdColStats.cpp   |   15 +-
 .../gporca/libnaucrates/src/md/CMDIdGPDB.cpp       |   19 +-
 .../gporca/libnaucrates/src/md/CMDIdGPDBCtas.cpp   |    2 -
 .../gporca/libnaucrates/src/md/CMDIdRelStats.cpp   |   14 +-
 .../gporca/libnaucrates/src/md/CMDIdScCmp.cpp      |   13 +-
 .../gporca/libnaucrates/src/md/CMDIndexGPDB.cpp    |  136 +-
 .../libnaucrates/src/md/CMDPartConstraintGPDB.cpp  |  143 -
 .../gporca/libnaucrates/src/md/CMDRelationGPDB.cpp |   28 +-
 src/backend/gporca/libnaucrates/src/md/Makefile    |    1 -
 .../src/operators/CDXLOperatorFactory.cpp          |  109 +-
 .../src/operators/CDXLPhysicalAppend.cpp           |   38 -
 .../operators/CDXLPhysicalDynamicIndexOnlyScan.cpp |   51 +
 ...XLScalarArray.cpp => CDXLScalarFieldSelect.cpp} |  125 +-
 .../libnaucrates/src/operators/CDXLTableDescr.cpp  |   14 +
 .../gporca/libnaucrates/src/operators/Makefile     |    2 +
 .../src/parser/CParseHandlerAppend.cpp             |   24 -
 .../src/parser/CParseHandlerDefaultValueExpr.cpp   |  122 -
 ...n.cpp => CParseHandlerDynamicIndexOnlyScan.cpp} |   52 +-
 .../src/parser/CParseHandlerFactory.cpp            |   34 +-
 .../src/parser/CParseHandlerIndexScan.cpp          |   11 +
 .../src/parser/CParseHandlerMDIndex.cpp            |   48 +-
 .../src/parser/CParseHandlerMDRelation.cpp         |   23 +-
 .../src/parser/CParseHandlerMetadataColumn.cpp     |   25 +-
 ...iaIO.cpp => CParseHandlerScalarFieldSelect.cpp} |   38 +-
 .../gporca/libnaucrates/src/parser/Makefile        |    3 +-
 .../libnaucrates/src/statistics/CHistogram.cpp     |   60 +-
 .../libnaucrates/src/statistics/CStatistics.cpp    |   40 +-
 .../gporca/libnaucrates/src/xml/dxltokens.cpp      |   23 +-
 src/backend/gporca/scripts/cal_bitmap_test.py      |  129 +-
 src/backend/gporca/server/CMakeLists.txt           |   33 +-
 src/backend/gporca/server/src/startup/main.cpp     |    4 +-
 .../gporca/server/src/unittest/CTestUtils.cpp      |    4 +-
 .../unittest/dxl/statistics/CStatisticsTest.cpp    |    2 +
 .../src/unittest/gpopt/minidump/CAggTest.cpp       |    1 +
 .../src/unittest/gpopt/minidump/CDMLTest.cpp       |    1 +
 .../gpopt/translate/CTranslatorDXLToExprTest.cpp   |    4 +-
 src/backend/nodes/copyfuncs.c                      |   40 +-
 src/backend/nodes/outfast.c                        |    3 +
 src/backend/nodes/outfuncs.c                       |   26 +-
 src/backend/nodes/readfast.c                       |    3 +
 src/backend/nodes/readfuncs.c                      |   25 +-
 src/backend/optimizer/plan/orca.c                  |    4 +-
 src/backend/optimizer/plan/setrefs.c               |   11 -
 src/backend/optimizer/util/plancat.c               |   51 +
 src/backend/optimizer/util/walkers.c               |    1 +
 src/backend/utils/adt/ruleutils.c                  |    2 +
 src/backend/utils/misc/guc_gp.c                    |   18 +-
 src/include/access/amapi.h                         |    1 +
 src/include/executor/execDynamicIndexes.h          |   21 +
 src/include/executor/nodeDynamicIndexOnlyscan.h    |   24 +
 src/include/executor/nodeDynamicIndexscan.h        |    2 -
 src/include/executor/nodeIndexonlyscan.h           |    2 +
 src/include/gpopt/gpdbwrappers.h                   |   17 +-
 .../gpopt/translate/CTranslatorDXLToPlStmt.h       |   24 +-
 .../gpopt/translate/CTranslatorDXLToScalar.h       |    3 +
 .../gpopt/translate/CTranslatorRelcacheToDXL.h     |   22 -
 .../gpopt/translate/CTranslatorScalarToDXL.h       |    4 +
 src/include/gpopt/utils/CMemoryPoolPallocManager.h |    3 +-
 src/include/gpopt/utils/COptTasks.h                |    4 -
 src/include/nodes/execnodes.h                      |   68 +-
 src/include/nodes/nodes.h                          |    2 +
 src/include/nodes/plannodes.h                      |   27 +
 src/include/optimizer/plancat.h                    |    6 +
 src/include/utils/guc.h                            |    1 +
 src/include/utils/unsync_guc_name.h                |    1 +
 ...tition_table_operations_should_not_deadlock.out |    1 -
 ...le_operations_should_not_deadlock_optimizer.out |    1 -
 src/test/isolation2/expected/spilling_hashagg.out  |   68 +
 .../expected/spilling_hashagg_optimizer.out        |   68 +
 src/test/isolation2/isolation2_schedule            |    2 +
 ...tition_table_operations_should_not_deadlock.sql |    1 -
 src/test/isolation2/sql/spilling_hashagg.sql       |   49 +
 .../regress/expected/DML_over_joins_optimizer.out  |  444 +-
 src/test/regress/expected/aggregates_optimizer.out |  628 +-
 src/test/regress/expected/autostats.out            |    3 +
 src/test/regress/expected/bfv_aggregate.out        |   29 +-
 .../regress/expected/bfv_aggregate_optimizer.out   |   96 +-
 .../expected/bfv_dd_multicolumn_optimizer.out      |    8 +-
 src/test/regress/expected/bfv_dml_optimizer.out    |    2 +-
 src/test/regress/expected/bfv_index.out            |  179 +-
 src/test/regress/expected/bfv_index_optimizer.out  |  224 +-
 src/test/regress/expected/bfv_joins.out            |   67 +
 src/test/regress/expected/bfv_joins_optimizer.out  |   83 +-
 src/test/regress/expected/bfv_olap.out             |  107 +
 src/test/regress/expected/bfv_olap_optimizer.out   |  188 +-
 src/test/regress/expected/bfv_partition_plans.out  |   12 +
 .../expected/bfv_partition_plans_optimizer.out     |  166 +-
 .../regress/expected/bfv_planner_optimizer.out     |   13 +-
 src/test/regress/expected/bitmapops_optimizer.out  |    2 +-
 src/test/regress/expected/brin.out                 |    2 +-
 src/test/regress/expected/brin_ao.out              |    2 +-
 src/test/regress/expected/brin_ao_optimizer.out    |   20 +-
 src/test/regress/expected/brin_aocs.out            |    2 +-
 src/test/regress/expected/brin_aocs_optimizer.out  |   20 +-
 src/test/regress/expected/brin_optimizer.out       |   20 +-
 src/test/regress/expected/catcache.out             |   20 +-
 src/test/regress/expected/catcache_optimizer.out   |   23 +-
 src/test/regress/expected/co_nestloop_idxscan.out  |    2 +
 .../expected/co_nestloop_idxscan_optimizer.out     |    2 +
 src/test/regress/expected/correlated_subquery.out  |    1 +
 .../regress/expected/create_index_optimizer.out    |   50 +-
 src/test/regress/expected/dpe.out                  |   61 +-
 src/test/regress/expected/dpe_optimizer.out        |   40 +-
 src/test/regress/expected/eagerfree_optimizer.out  |   27 +-
 src/test/regress/expected/explain_format.out       |   15 +-
 .../regress/expected/explain_format_optimizer.out  |   13 +-
 src/test/regress/expected/explain_optimizer.out    |  510 +-
 src/test/regress/expected/generated_optimizer.out  |  740 +--
 .../regress/expected/gp_array_agg_optimizer.out    |   20 +-
 src/test/regress/expected/gp_covering_index.out    |  232 +-
 .../expected/gp_covering_index_optimizer.out       |  253 +-
 src/test/regress/expected/gp_dqa_optimizer.out     |  488 +-
 src/test/regress/expected/gp_explain.out           |    2 +-
 src/test/regress/expected/gp_explain_optimizer.out |  206 +-
 src/test/regress/expected/gp_tsrf.out              |   76 +-
 src/test/regress/expected/gp_tsrf_optimizer.out    |   85 +-
 .../regress/expected/gpdiffcheck_optimizer.out     |   15 +-
 .../expected/gpdist_legacy_opclasses_optimizer.out |   14 +-
 src/test/regress/expected/gporca.out               |  286 +-
 src/test/regress/expected/gporca_optimizer.out     |  624 +-
 .../regress/expected/groupingsets_optimizer.out    |   93 +-
 src/test/regress/expected/join.out                 |    2 +
 src/test/regress/expected/join_optimizer.out       |  163 +-
 src/test/regress/expected/limit_gp_optimizer.out   |    8 +-
 src/test/regress/expected/matview_optimizer.out    |    6 +-
 .../regress/expected/misc_functions_optimizer.out  |   28 +-
 src/test/regress/expected/notin_optimizer.out      |    2 +-
 src/test/regress/expected/olap_plans_optimizer.out |  104 +-
 .../expected/orca_groupingsets_fallbacks.out       |    4 +-
 .../orca_groupingsets_fallbacks_optimizer.out      |   30 +-
 .../expected/orca_static_pruning_optimizer.out     |    8 +-
 src/test/regress/expected/privileges.out           |   11 +-
 .../expected/qp_correlated_query_optimizer.out     |   94 +-
 src/test/regress/expected/qp_indexscan.out         | 2670 ++++++++
 .../regress/expected/qp_indexscan_optimizer.out    | 2572 +++++++-
 .../expected/qp_join_union_all_optimizer.out       |   74 +-
 src/test/regress/expected/qp_join_universal.out    |  447 ++
 .../expected/qp_join_universal_optimizer.out       |  480 ++
 .../regress/expected/qp_misc_jiras_optimizer.out   |   83 +-
 src/test/regress/expected/qp_misc_optimizer.out    |   16 +-
 .../expected/qp_orca_fallback_optimizer.out        |  101 +-
 src/test/regress/expected/qp_query_execution.out   |    2 +-
 .../expected/qp_targeted_dispatch_optimizer.out    |   10 +-
 .../regress/expected/qp_with_clause_optimizer.out  |  100 +-
 src/test/regress/expected/rpt.out                  |   37 +
 src/test/regress/expected/rpt_optimizer.out        |   89 +-
 .../regress/expected/select_distinct_optimizer.out |    5 +-
 .../regress/expected/subselect_gp_optimizer.out    |  252 +-
 src/test/regress/expected/subselect_optimizer.out  |    4 +-
 src/test/regress/expected/tsrf_optimizer.out       |   19 +-
 src/test/regress/expected/union_gp_optimizer.out   |  184 +-
 src/test/regress/expected/union_optimizer.out      |  110 +-
 src/test/regress/expected/window_optimizer.out     |  132 +-
 src/test/regress/greenplum_schedule                |    8 +-
 src/test/regress/init_file                         |    2 +
 src/test/regress/input/aocs.source                 |    3 +-
 src/test/regress/output/aocs.source                |    8 +-
 ...nal_table_persistent_error_log_optimizer.source |  100 +-
 .../output/part_external_table_optimizer.source    |    4 +-
 .../output/qp_gist_indexes2_optimizer.source       |   28 +-
 src/test/regress/sql/autostats.sql                 |    2 +
 src/test/regress/sql/bfv_aggregate.sql             |   10 +-
 src/test/regress/sql/bfv_index.sql                 |   69 +-
 src/test/regress/sql/bfv_joins.sql                 |   47 +
 src/test/regress/sql/bfv_olap.sql                  |   17 +
 src/test/regress/sql/bfv_partition_plans.sql       |    4 +
 src/test/regress/sql/brin.sql                      |    2 +-
 src/test/regress/sql/brin_ao.sql                   |    2 +-
 src/test/regress/sql/brin_aocs.sql                 |    2 +-
 src/test/regress/sql/catcache.sql                  |    2 +-
 src/test/regress/sql/co_nestloop_idxscan.sql       |    2 +
 src/test/regress/sql/correlated_subquery.sql       |    2 +
 src/test/regress/sql/dpe.sql                       |   12 +-
 src/test/regress/sql/gp_covering_index.sql         |  114 +-
 src/test/regress/sql/gp_tsrf.sql                   |   21 +-
 src/test/regress/sql/gporca.sql                    |  104 +-
 src/test/regress/sql/join.sql                      |    2 +
 .../regress/sql/orca_groupingsets_fallbacks.sql    |    3 +
 src/test/regress/sql/privileges.sql                |   12 +-
 src/test/regress/sql/qp_indexscan.sql              |  715 +-
 src/test/regress/sql/qp_join_universal.sql         |  144 +
 src/test/regress/sql/qp_query_execution.sql        |    2 +-
 src/test/regress/sql/rpt.sql                       |    9 +
 1549 files changed, 34796 insertions(+), 62778 deletions(-)
 create mode 100644 src/backend/executor/execDynamicIndexes.c
 create mode 100644 src/backend/executor/nodeDynamicIndexOnlyscan.c
 create mode 100644 
src/backend/gporca/data/dxl/minidump/AllowIndexOnlyScanOnAppendOnlyTable.mdp
 copy src/backend/gporca/data/dxl/minidump/{PartPredsWithRandom.mdp => 
AllowIndexOnlyScanOnMixedAppendOnlyPartitionedTable.mdp} (58%)
 create mode 100644 
src/backend/gporca/data/dxl/minidump/AllowIndexOnlyScanOnMixedPartitionedTable.mdp
 copy src/backend/gporca/data/dxl/minidump/{UpdatingMultipleColumn.mdp => 
Backward-IndexOnlyScan-OrderBy-on-MultiCol-Index.mdp} (64%)
 create mode 100644 
src/backend/gporca/data/dxl/minidump/Backward-IndexScan-OrderBy-on-MultiCol-Index.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/Backward-IndexScan-OrderBy-on-SingleCol-Index.mdp
 copy 
src/backend/gporca/data/dxl/minidump/{PushConstantSelectPredicateThruJoin-17.mdp
 => CoveringIndex-DoesNotSupport-Gin.mdp} (71%)
 copy 
src/backend/gporca/data/dxl/minidump/{PushConstantSelectPredicateThruJoin-17.mdp
 => CoveringIndex-DoesSupport-Gist.mdp} (64%)
 copy src/backend/gporca/data/dxl/minidump/{PartPredsWithRandom.mdp => 
DynamicIndexOnlyScan-Homogenous.mdp} (54%)
 copy src/backend/gporca/data/dxl/minidump/{ReplicatedJoinPartitionedTable.mdp 
=> DynamicIndexOnlyScan-InnerJoin.mdp} (67%)
 copy src/backend/gporca/data/dxl/minidump/{ReplicatedJoinPartitionedTable.mdp 
=> DynamicIndexOnlyScan-LeftJoin.mdp} (66%)
 copy src/backend/gporca/data/dxl/minidump/{VariadicFlagWithJson.mdp => 
FieldSelect.mdp} (54%)
 copy src/backend/gporca/data/dxl/minidump/{UpdatingMultipleColumn.mdp => 
Forward-IndexOnlyScan-OrderBy-on-MultiCol-Index.mdp} (64%)
 copy src/backend/gporca/data/dxl/minidump/{IndexConstraintsMDidCache.mdp => 
Forward-IndexScan-OrderBy-on-MultiCol-Index.mdp} (50%)
 copy src/backend/gporca/data/dxl/minidump/{IndexConstraintsMDidCache.mdp => 
Forward-IndexScan-OrderBy-on-SingleCol-Index.mdp} (50%)
 copy src/backend/gporca/data/dxl/minidump/{ScalarSubq-Eq-SubqAll-1.mdp => 
InSubqWithPrjListReturnSet.mdp} (55%)
 copy src/backend/gporca/data/dxl/minidump/{UpdatingMultipleColumn.mdp => 
IndexOnlyScan-OrderBy-on-MultiCol-NonIndex.mdp} (64%)
 create mode 100644 
src/backend/gporca/data/dxl/minidump/IndexScan-OrderBy-on-MultiCol-NonIndex.mdp
 copy src/backend/gporca/data/dxl/minidump/{InsertMasterOnlyTable.mdp => 
InsertCoordinatorOnlyTable.mdp} (96%)
 copy src/backend/gporca/data/dxl/minidump/{InsertMasterOnlyTableConstTuple.mdp 
=> InsertCoordinatorOnlyTableConstTuple.mdp} (96%)
 copy 
src/backend/gporca/data/dxl/minidump/{InsertSortDistributed2MasterOnly.mdp => 
InsertSortDistributed2CoordinatorOnly.mdp} (94%)
 copy 
src/backend/gporca/data/dxl/minidump/{ConstTblGetUnderSubqUnderProjectWithOuterRef.mdp
 => JoinOnReplicatedUniversal.mdp} (66%)
 copy src/backend/gporca/data/dxl/minidump/{InnerJoinBroadcastTableHashSpec.mdp 
=> OrderByNoRedundantSort.mdp} (56%)
 create mode 100644 
src/backend/gporca/data/dxl/minidump/PartTbl-DPE-DynamicIndexOnlyScan-Range.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/PreventIndexOnlyScanOnAppendOnlyVersion6UpgradedTable.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/PreventIndexOnlyScanOnMixedAppendOnlyPartitionedTableContainingAppendOnlyVersion6Child.mdp
 create mode 100644 
src/backend/gporca/data/dxl/minidump/PreventIndexOnlyScanOnMixedPartitionedTableContainingAppendOnlyVersion6Child.mdp
 copy 
src/backend/gporca/data/dxl/minidump/{Delete-Check-AssignedQueryIdForTargetRel.mdp
 => RTErequiredPerms.mdp} (72%)
 create mode 100644 
src/backend/gporca/libgpopt/include/gpopt/base/CDistributionSpecNonReplicated.h
 delete mode 100644 
src/backend/gporca/libgpopt/include/gpopt/operators/CLogicalPartitionSelector.h
 create mode 100644 
src/backend/gporca/libgpopt/include/gpopt/operators/CPhysicalDynamicIndexOnlyScan.h
 copy src/backend/gporca/libgpopt/include/gpopt/operators/{CScalarArrayRef.h => 
CScalarFieldSelect.h} (52%)
 copy 
src/backend/gporca/libgpopt/include/gpopt/xforms/{CXformDynamicForeignGet2DynamicForeignScan.h
 => CXformDynamicIndexGet2DynamicIndexOnlyScan.h} (51%)
 delete mode 100644 
src/backend/gporca/libgpopt/include/gpopt/xforms/CXformImplementPartitionSelector.h
 delete mode 100644 
src/backend/gporca/libgpopt/src/operators/CLogicalPartitionSelector.cpp
 create mode 100644 
src/backend/gporca/libgpopt/src/operators/CPhysicalDynamicIndexOnlyScan.cpp
 create mode 100644 
src/backend/gporca/libgpopt/src/operators/CScalarFieldSelect.cpp
 copy 
src/backend/gporca/libgpopt/src/xforms/{CXformDynamicIndexGet2DynamicIndexScan.cpp
 => CXformDynamicIndexGet2DynamicIndexOnlyScan.cpp} (58%)
 delete mode 100644 
src/backend/gporca/libgpopt/src/xforms/CXformImplementPartitionSelector.cpp
 create mode 100644 
src/backend/gporca/libnaucrates/include/naucrates/dxl/operators/CDXLPhysicalDynamicIndexOnlyScan.h
 create mode 100644 
src/backend/gporca/libnaucrates/include/naucrates/dxl/operators/CDXLScalarFieldSelect.h
 delete mode 100644 
src/backend/gporca/libnaucrates/include/naucrates/dxl/parser/CParseHandlerDefaultValueExpr.h
 copy 
src/backend/gporca/libnaucrates/include/naucrates/dxl/parser/{CParseHandlerDynamicIndexScan.h
 => CParseHandlerDynamicIndexOnlyScan.h} (60%)
 copy 
src/backend/gporca/libnaucrates/include/naucrates/dxl/parser/{CParseHandlerScalarCoerceViaIO.h
 => CParseHandlerScalarFieldSelect.h} (64%)
 delete mode 100644 
src/backend/gporca/libnaucrates/include/naucrates/md/CMDPartConstraintGPDB.h
 delete mode 100644 
src/backend/gporca/libnaucrates/src/md/CMDPartConstraintGPDB.cpp
 create mode 100644 
src/backend/gporca/libnaucrates/src/operators/CDXLPhysicalDynamicIndexOnlyScan.cpp
 copy src/backend/gporca/libnaucrates/src/operators/{CDXLScalarArray.cpp => 
CDXLScalarFieldSelect.cpp} (52%)
 delete mode 100644 
src/backend/gporca/libnaucrates/src/parser/CParseHandlerDefaultValueExpr.cpp
 copy 
src/backend/gporca/libnaucrates/src/parser/{CParseHandlerDynamicIndexScan.cpp 
=> CParseHandlerDynamicIndexOnlyScan.cpp} (54%)
 copy 
src/backend/gporca/libnaucrates/src/parser/{CParseHandlerScalarCoerceViaIO.cpp 
=> CParseHandlerScalarFieldSelect.cpp} (78%)
 create mode 100644 src/include/executor/execDynamicIndexes.h
 create mode 100644 src/include/executor/nodeDynamicIndexOnlyscan.h
 create mode 100644 src/test/isolation2/expected/spilling_hashagg.out
 create mode 100644 src/test/isolation2/expected/spilling_hashagg_optimizer.out
 create mode 100644 src/test/isolation2/sql/spilling_hashagg.sql
 create mode 100644 src/test/regress/expected/qp_join_universal.out
 create mode 100644 src/test/regress/expected/qp_join_universal_optimizer.out
 create mode 100644 src/test/regress/sql/qp_join_universal.sql


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

Reply via email to