This is an automated email from the ASF dual-hosted git repository.
maxyang pushed a change to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
from 3a2626d5c2 Introduce gp_appendonly_compaction_segfile_limit
new 86170a2dbd Adding motion when join columns in NLJ belong to different
Opfamiliy =====================================================================
new 915d321c9f Adding Testcases
new 9bc0eac106 Adding inner NLJ cases
new 57bd5184b2 Modifying code as per feedback
new 37cfef2e7e Fixing test cases
new 1e0c18d899 Modifying Test Cases
new b49f333c49 Addressing Review Comments
new a64a0c2701 new operator shouldn't return NULL
new 1237a6f320 [ORCA] Support cover indexes using INCLUDE columns (#15463)
new 81fee68e97 Fix bug in ORCA of removing required redistribution motion
when query uses GROUP BY over gp_segment_id (#15537)
new 6e9120a197 Support executing foreign tables from segments in Orca
(#15559)
new 91edb604fd Fall back to planner for queries with foreign partitions
using greenplum_fdw (#15706)
new 4484f5f1a4 Support DPE for duplicate sensitive random motions in Orca
(#15629)
new cf902688ec Add workload for explain pipeline (#15730)
new 6992643ee6 ORCA should generate plans with the ProjectSet node (#15170)
new 83ac047343 Comment about direct dispatch's indexqualorig changes
new 06fecda244 [ORCA] Enable Index-Only Scan on CTE
new 8d9cb940c2 Remove GUC/traceflag related to pruning unused columns
new cff7c6c4e2 Enable push join below union all (#15535)
new 4501a69846 [ORCA] Update index cost model to account for INCLUDE
columns (#15697)
new 3b045bec09 Fix to remove Asserts on release build (#15845)
new a2bf2f3d33 Fixing crash in ORCA with skip-level correlated query
(#15648)
new 195b614de7 Fix unlock the pruned partitions of partition table (#15665)
new 4de0bcc11f Reorder scalar comparison expression in case of cast
(#15880)
new dbc291a979 Allow ORCA plans with empty target list (#15939)
new cbc3663dd6 ORCA: update relcache logic for setting hashable for
RANGETYPES
new 0982f343fe Consider bitmap alternative only for ANY ScalarArray
new fe394b08ca [ORCA] Support BitmapIndex plans for ArrayCmp on Hash
indexes
new 4b6211cb97 Fix memory leak in Orca (#16006)
new 3322a41df7 Utilizing btree index's order property when used as part of
Order By clause and limit (#15894)
new 34ab0b2529 Remove unuseful mdps from Orca (#16035)
new 2b056bc07c Backfill isolation2 test for commit 0417465a744 (#16018)
new f009bc8685 Refactoring RTE deduplication logic from PR #14304
new cf220529be Fix: cherry-pick "pushdown in union all, pruned partitions,
plans with the ProjectSet node..."
The 34 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/file_fdw/input/gp_file_fdw.source | 1 +
contrib/file_fdw/output/gp_file_fdw.source | 12 +
.../file_fdw/output/gp_file_fdw_optimizer.source | 12 +
contrib/postgres_fdw/Makefile | 3 +-
contrib/postgres_fdw/expected/gp_postgres_fdw.out | 393 +-
...tgres_fdw.out => gp_postgres_fdw_optimizer.out} | 449 +-
contrib/postgres_fdw/sql/gp_postgres_fdw.sql | 160 +-
src/backend/gpopt/config/CConfigParamMapping.cpp | 13 +-
src/backend/gpopt/gpdbwrappers.cpp | 117 +
.../gpopt/translate/CContextDXLToPlStmt.cpp | 111 +-
.../gpopt/translate/CTranslatorDXLToPlStmt.cpp | 602 +-
.../gpopt/translate/CTranslatorRelcacheToDXL.cpp | 154 +-
src/backend/gpopt/utils/CMemoryPoolPalloc.cpp | 5 -
.../gporca/concourse/test_explain_pipeline.yml | 117 +
...nFunc-OuterRef-Partition-Order-Frames-Query.xml | 4 +-
.../WinFunc-OuterRef-Partition-Order-Query.xml | 4 +-
.../WinFunc-OuterRef-Partition-Query.xml | 4 +-
.../gporca/data/dxl/indexjoin/positive_04.mdp | 6 +-
src/backend/gporca/data/dxl/metadata/md.xml | 14 +-
.../gporca/data/dxl/minidump/ArrayCmpInList.mdp | 4 +-
.../gporca/data/dxl/minidump/AssertMaxOneRow.mdp | 4 +-
.../gporca/data/dxl/minidump/BRINScan-Or.mdp | 2 +-
.../dxl/minidump/BTreeIndex-Against-InList.mdp | 2 +-
.../minidump/BTreeIndex-Against-InListLarge.mdp | 2 +-
.../minidump/BTreeIndex-Against-ScalarSubquery.mdp | 2 +-
.../gporca/data/dxl/minidump/BitmapBoolAnd.mdp | 8 +-
.../data/dxl/minidump/BitmapBoolOp-DeepTree.mdp | 8 +-
.../data/dxl/minidump/BitmapBoolOp-DeepTree2.mdp | 4 +-
.../data/dxl/minidump/BitmapBoolOp-DeepTree3.mdp | 4 +-
.../data/dxl/minidump/BitmapBoolOr-BoolColumn.mdp | 6 +-
.../gporca/data/dxl/minidump/BitmapBoolOr.mdp | 8 +-
.../dxl/minidump/BitmapIndex-Against-InList.mdp | 2 +-
.../dxl/minidump/BitmapIndex-ChooseHashJoin.mdp | 2 +-
.../minidump/BitmapIndexApply-Basic-SelfJoin.mdp | 2 +-
.../minidump/BitmapIndexApply-Basic-TwoTables.mdp | 2 +-
.../BitmapIndexApply-Complex-Condition.mdp | 4 +-
.../BitmapIndexApply-InnerSelect-Basic.mdp | 2 +-
.../BitmapIndexApply-InnerSelect-PartTable.mdp | 2 +-
.../dxl/minidump/BitmapIndexApply-PartTable.mdp | 2 +-
.../dxl/minidump/BitmapIndexNLJWithProject.mdp | 2 +-
.../minidump/BitmapIndexNLJWithProjectNoFilt.mdp | 2 +-
.../dxl/minidump/BitmapIndexNLOJWithProject.mdp | 2 +-
.../minidump/BitmapIndexNLOJWithProjectNonPart.mdp | 2 +-
.../dxl/minidump/BitmapIndexProbeMergeFilters.mdp | 4 +-
...tmapIndexScan-WithUnsupportedOperatorFilter.mdp | 2 +-
.../gporca/data/dxl/minidump/BitmapIndexScan.mdp | 14 +-
.../dxl/minidump/BitmapIndexScanChooseIndex.mdp | 2 +-
.../data/dxl/minidump/BitmapIndexScanCost.mdp | 2 +-
.../minidump/BitmapIndexUnsupportedOperator.mdp | 2 +-
.../BitmapScan-Hetrogeneous-Partitioned.mdp | 2 +-
...BitmapTableScan-AO-Btree-PickIndexWithNoGap.mdp | 6 +-
.../BitmapTableScan-AO-Btree-PickOnlyHighNDV.mdp | 4 +-
.../data/dxl/minidump/BitmapTableScan-AO-Btree.mdp | 2 +-
.../data/dxl/minidump/BitmapTableScan-AO.mdp | 2 +-
.../dxl/minidump/BitmapTableScan-AndCondition.mdp | 2 +-
.../data/dxl/minidump/BitmapTableScan-Basic.mdp | 2 +-
.../minidump/BitmapTableScan-ColumnOnRightSide.mdp | 2 +-
.../minidump/BitmapTableScan-ComplexConjDisj.mdp | 4 +-
.../BitmapTableScan-ConjDisjWithOuterRefs.mdp | 4 +-
.../minidump/Blocking-Spool-Parallel-Union-All.mdp | 2 +-
.../minidump/BtreeIndexNLJWithProjectNoPart.mdp | 2 +-
.../dxl/minidump/BtreeIndexNLOJWithProject.mdp | 2 +-
.../FallBackToSerialAppend.mdp | 4 +-
.../gporca/data/dxl/minidump/CTE-Preds2.mdp | 1 -
.../gporca/data/dxl/minidump/CTE15HAReplicated.mdp | 1 -
.../gporca/data/dxl/minidump/CTE15Replicated.mdp | 1 -
.../data/dxl/minidump/CannotPullGrpColAboveAgg.mdp | 45 +-
.../data/dxl/minidump/CapGbCardToSelectCard.mdp | 2 +-
.../dxl/minidump/CastedScalarIf-On-Index-Key.mdp | 6 +-
.../data/dxl/minidump/Coalesce-With-Subquery.mdp | 8 +-
.../gporca/data/dxl/minidump/CoerceToDomain.mdp | 8 +-
.../dxl/minidump/CorrelatedAntiSemiJoin-True.mdp | 6 +-
.../minidump/CorrelatedIN-LeftSemiNotIn-True.mdp | 6 +-
.../data/dxl/minidump/CorrelatedSemiJoin-True.mdp | 6 +-
.../dxl/minidump/Correlation-With-Casting-1.mdp | 7 +
.../{Hash-IndexScan.mdp => CoveringIndex-1.mdp} | 164 +-
...eBroadcastThreshold.mdp => CoveringIndex-2.mdp} | 951 +--
.../{Hash-IndexScan.mdp => CoveringIndex-3.mdp} | 241 +-
.../data/dxl/minidump/CoveringIndex-Cost-1.mdp | 393 +
.../data/dxl/minidump/CoveringIndex-Cost-2.mdp | 394 +
.../minidump/DML-With-CoordinatorOnlyTable-1.mdp | 20 +-
.../minidump/DirectDispatch-DynamicIndexScan.mdp | 2 +-
.../data/dxl/minidump/DirectDispatch-IndexScan.mdp | 4 +-
...Aggregate2.mdp => DistinctQueryWithMotions.mdp} | 382 +-
.../dxl/minidump/DoubleNDVCardinalityEquals.mdp | 2 +-
.../data/dxl/minidump/DynamicBitmapBoolOp.mdp | 6 +-
.../data/dxl/minidump/DynamicBitmapIndexScan.mdp | 42 +-
.../dxl/minidump/DynamicBitmapTableScan-Basic.mdp | 2 +-
.../DynamicBitmapTableScan-Heterogeneous.mdp | 2 +-
.../dxl/minidump/DynamicBitmapTableScan-UUID.mdp | 2 +-
.../dxl/minidump/DynamicIndexGet-OuterRefs.mdp | 4 +-
.../dxl/minidump/DynamicIndexGetDroppedCols.mdp | 2 +-
.../dxl/minidump/DynamicIndexScan-BoolFalse.mdp | 2 +-
.../dxl/minidump/DynamicIndexScan-BoolTrue.mdp | 2 +-
.../DynamicIndexScan-DefaultPartition-2.mdp | 4 +-
.../minidump/DynamicIndexScan-DefaultPartition.mdp | 2 +-
.../dxl/minidump/DynamicIndexScan-DroppedCols.mdp | 2 +-
.../minidump/DynamicIndexScan-DroppedColumns.mdp | 2 +-
...ndexScan-Heterogenous-EnabledDateConstraint.mdp | 2 +-
.../DynamicIndexScan-Heterogenous-NoDTS.mdp | 4 +-
.../DynamicIndexScan-Heterogenous-Overlapping.mdp | 4 +-
...icIndexScan-Heterogenous-PartSelectEquality.mdp | 2 +-
...namicIndexScan-Heterogenous-PartSelectRange.mdp | 2 +-
.../DynamicIndexScan-Heterogenous-Union.mdp | 2 +-
...ndexScan-Heterogenous-UnsupportedConstraint.mdp | 2 +-
...IndexScan-Heterogenous-UnsupportedPredicate.mdp | 4 +-
.../dxl/minidump/DynamicIndexScan-Heterogenous.mdp | 4 +-
...cIndexScan-Homogenous-EnabledDateConstraint.mdp | 4 +-
...cIndexScan-Homogenous-UnsupportedConstraint.mdp | 4 +-
.../dxl/minidump/DynamicIndexScan-Homogenous.mdp | 2 +-
.../DynamicIndexScan-OpenEndedPartitions.mdp | 2 +-
.../data/dxl/minidump/DynamicIndexScan-Relabel.mdp | 2 +-
.../dxl/minidump/ExceptHashCompatibleRange.mdp | 263 +
.../dxl/minidump/ExceptHashIncompatibleRange.mdp | 272 +
.../data/dxl/minidump/ExpandFullOuterJoin.mdp | 2 -
.../minidump/ExtractOneBindingFromScalarGroups.mdp | 2 +-
...ixedDPE.mdp => ForeignPartOneTimeFilterDPE.mdp} | 407 +-
...-On-Outer.mdp => ForeignScanExecLocAnyJoin.mdp} | 312 +-
...her.mdp => ForeignScanExecLocAnySimpleScan.mdp} | 229 +-
.../FullJoin-Subquery-CastedPredicates.mdp | 4 +-
.../gporca/data/dxl/minidump/Gb-on-keys.mdp | 2 +-
src/backend/gporca/data/dxl/minidump/GinIndex.mdp | 2 +-
.../data/dxl/minidump/GinIndexPathOpfamily.mdp | 2 +-
.../data/dxl/minidump/GinIndexSearchModeAll.mdp | 2 +-
.../Gist-AOCOTable-NonLossy-BitmapIndexPlan.mdp | 2 +-
.../Gist-NestedLoopJoin-Lossy-IndexPlan.mdp | 2 +-
.../Gist-NestedLoopJoin-Postgis-IndexPlan.mdp | 2 +-
.../Gist-NonPart-Lossy-BitmapIndexPlan.mdp | 2 +-
.../dxl/minidump/Gist-NonPart-Lossy-IndexPlan.mdp | 2 +-
.../data/dxl/minidump/Gist-OrderBy-BitmapPlan.mdp | 2 +-
.../data/dxl/minidump/Gist-OrderBy-IndexPlan.mdp | 2 +-
.../minidump/Gist-PartTable-Lossy-IndexPlan.mdp | 2 +-
.../Gist-PartTable-NonLossy-BitmapIndexPlan.mdp | 2 +-
.../dxl/minidump/Gist-PartialIndex-TableScan.mdp | 2 +-
.../data/dxl/minidump/GroupingOnSameTblCol-1.mdp | 4 +-
.../dxl/minidump/HJN-DPE-Bitmap-Outer-Child.mdp | 2 +-
...ableGroupBy.mdp => Hash-BitmapScan-InArray.mdp} | 419 +-
.../gporca/data/dxl/minidump/Hash-BitmapScan.mdp | 2 +-
.../gporca/data/dxl/minidump/Hash-IndexScan.mdp | 2 +-
...ableGroupBy.mdp => Hash-TableScan-AllArray.mdp} | 409 +-
.../gporca/data/dxl/minidump/InEqualityJoin.mdp | 2 +-
.../minidump/Index-Join-With-Subquery-In-Pred.mdp | 2 +-
...dexApply-Heterogeneous-BothSidesPartitioned.mdp | 4 +-
.../dxl/minidump/IndexApply-Heterogeneous-DTS.mdp | 4 +-
.../minidump/IndexApply-Heterogeneous-NoDTS.mdp | 4 +-
...IndexApply-IndexCondDisjointWithHashedDistr.mdp | 2 +-
...ndexApply-IndexCondIntersectWithHashedDistr.mdp | 2 +-
.../IndexApply-IndexCondMatchHashedDistr.mdp | 2 +-
.../IndexApply-IndexCondSubsetOfHashedDistr.mdp | 2 +-
.../IndexApply-IndexCondSupersetOfHashedDistr.mdp | 2 +-
... => IndexApply-IndexOnCoordinatorOnlyTable.mdp} | 13 +-
.../dxl/minidump/IndexApply-InnerSelect-Basic.mdp | 2 +-
.../IndexApply-InnerSelect-Heterogeneous-DTS.mdp | 4 +-
.../minidump/IndexApply-InnerSelect-PartTable.mdp | 2 +-
.../minidump/IndexApply-InnerSelect-PartTable2.mdp | 2 +-
.../dxl/minidump/IndexApply-LeftOuter-NLJoin.mdp | 8 +-
.../IndexApply-MultiDistKey-WithComplexPreds.mdp | 2 +-
...Apply-MultiDistKeys-Bitmap-WithComplexPreds.mdp | 2 +-
.../minidump/IndexApply-MultiDistKeys-Bitmap.mdp | 2 +-
...pply-MultiDistKeys-IncompletePDS-3-DistCols.mdp | 2 +-
.../minidump/IndexApply-No-Motion-Below-Join.mdp | 4 +-
.../minidump/IndexApply-PartKey-Is-IndexKey.mdp | 6 +-
.../dxl/minidump/IndexApply-PartResolverExpand.mdp | 2 +-
.../data/dxl/minidump/IndexApply-PartTable.mdp | 2 +-
.../IndexApply-Redistribute-Const-Table.mdp | 4 +-
.../minidump/IndexApply1-CalibratedCostModel.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexApply1.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexApply2.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexApply3.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexApply4.mdp | 2 +-
.../IndexApply_NestLoopWithNestParamTrue.mdp | 4 +-
.../dxl/minidump/IndexConstraintsMDidCache.mdp | 2 +-
.../data/dxl/minidump/IndexGet-OuterRefs.mdp | 2 +-
.../dxl/minidump/IndexNLJ-IndexGet-OuterRef.mdp | 2 +-
.../dxl/minidump/IndexNLJoin_Cast_NoMotion.mdp | 8 +-
...itionToRootTableContainingHeterogenousIndex.mdp | 2 +-
...nLeaf-AddPartitionToRootWithHomogenousIndex.mdp | 2 +-
...-IndexOnPartitionsWithDifferentStorageTypes.mdp | 2 +-
...verlappingHeterogenousIndex-ANDPredicate-AO.mdp | 4 +-
...rlappingHeterogenousIndex-ANDPredicate-HEAP.mdp | 4 +-
...pingHomogenousIndexesOnRoot-ANDPredicate-AO.mdp | 4 +-
...ppingHomogenousIndexesOnRoot-ORPredicate-AO.mdp | 6 +-
...verlappingHeterogenousIndex-ANDPredicate-AO.mdp | 4 +-
...rlappingHeterogenousIndex-ANDPredicate-HEAP.mdp | 4 +-
...OverlappingHeterogenousIndex-ORPredicate-AO.mdp | 4 +-
...pingHomogenousIndexesOnRoot-ANDPredicate-AO.mdp | 4 +-
...nLeaf-OverlappingHomogenousIndexesOnRoot-AO.mdp | 4 +-
...ppingHomogenousIndexesOnRoot-ORPredicate-AO.mdp | 4 +-
...af-SingleColumnHeterogenousIndexOnRoot-1-AO.mdp | 4 +-
...-SingleColumnHeterogenousIndexOnRoot-1-HEAP.mdp | 4 +-
...af-SingleColumnHeterogenousIndexOnRoot-2-AO.mdp | 4 +-
...-SingleColumnHeterogenousIndexOnRoot-2-HEAP.mdp | 4 +-
.../{Hash-IndexScan.mdp => IndexOnlyScan-CTE.mdp} | 208 +-
.../minidump/IndexOnlyScan-NoDistKeyInIndex.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexScan-AOTable.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexScan-AndedIn.mdp | 2 +-
.../data/dxl/minidump/IndexScan-BoolFalse.mdp | 2 +-
.../data/dxl/minidump/IndexScan-BoolTrue.mdp | 2 +-
.../data/dxl/minidump/IndexScan-DroppedColumns.mdp | 2 +-
.../data/dxl/minidump/IndexScan-ORPredsAOPart.mdp | 2 +-
.../data/dxl/minidump/IndexScan-ORPredsNonPart.mdp | 2 +-
...=> IndexScan-OrderBy-on-Multiple-IndexCols.mdp} | 1056 +--
...it.mdp => IndexScan-OrderBy-on-NonIndexCol.mdp} | 1053 +--
...dp => IndexScan-OrderBy-on-Single-IndexCol.mdp} | 1055 +--
.../gporca/data/dxl/minidump/IndexScan-Relabel.mdp | 2 +-
.../minidump/IndexScanWithNestedCTEAndSetOp.mdp | 2 +-
.../gporca/data/dxl/minidump/IndexedNLJBitmap.mdp | 4 +-
.../data/dxl/minidump/InferPredicatesBCC-vc-vc.mdp | 8 +-
.../data/dxl/minidump/Insert-With-HJ-CTE-Agg.mdp | 5 +-
.../gporca/data/dxl/minidump/Join-Disj-Subqs.mdp | 6 +-
.../data/dxl/minidump/Join-INDF-NoBroadcast.mdp | 8 +-
.../minidump/Join-INDF-Nulls-Not-Collocated.mdp | 10 +-
...ojAndNonLojChilds.mdp => JoinBelowUnionAll.mdp} | 3101 +++----
.../data/dxl/minidump/JoinColWithOnlyNDV.mdp | 4 +-
.../gporca/data/dxl/minidump/JoinNDVRemain.mdp | 4 +-
...lFuncNullReject.mdp => JoinPredFalseFilter.mdp} | 310 +-
.../data/dxl/minidump/LOJ-DynBitmapIndex.mdp | 2 +-
.../dxl/minidump/LOJ-DynBitmapIndexWithSelect.mdp | 2 +-
.../gporca/data/dxl/minidump/LOJ-DynBtreeIndex.mdp | 2 +-
.../dxl/minidump/LOJ-DynBtreeIndexWithSelect.mdp | 2 +-
...LOJ-HashJoin-MultiDistKeys-WithComplexPreds.mdp | 2 +-
.../minidump/LOJ-IndexApply-CompsiteKey-Equiv.mdp | 4 +-
.../LOJ-IndexApply-CompsiteKey-NoMotion.mdp | 4 +-
...dp => LOJ-IndexApply-CoordinatorOnly-Table.mdp} | 18 +-
.../LOJ-IndexApply-DistKey-Multiple-Predicates.mdp | 8 +-
...ly-MultiDistKey-MultiIndexKey-NoExtraFilter.mdp | 2 +-
.../LOJ-IndexApply-MultiDistKey-MultiIndexKey.mdp | 2 +-
...Apply-MultiDistKeys-Bitmap-WithComplexPreds.mdp | 2 +-
.../LOJ-IndexApply-MultiDistKeys-Bitmap.mdp | 2 +-
.../LOJ-IndexApply-MultiDistKeys-IndexKeys.mdp | 16 +-
...J-IndexApply-MultiDistKeys-WithComplexPreds.mdp | 2 +-
.../dxl/minidump/LOJ-IndexApply-MultiIndexes.mdp | 8 +-
.../LOJ-IndexApply-Negative-NonEqual-Predicate.mdp | 8 +-
.../dxl/minidump/LOJ-IndexApply-NonDistKey.mdp | 2 +-
.../LOJ-IndexApply-WithComplexPredicates.mdp | 2 +-
.../LOJ_convert_to_inner_with_and_predicate.mdp | 2 +-
.../LOJ_convert_to_inner_with_or_predicate.mdp | 2 +-
.../dxl/minidump/LeftJoin-With-Col-Const-Pred.mdp | 6 +-
.../gporca/data/dxl/minidump/LeftJoinPruning.mdp | 4 +-
.../minidump/LeftJoinPruningInOuterInnerQuery.mdp | 4 +-
.../dxl/minidump/LeftJoinPruningInnerQuery.mdp | 6 +-
.../dxl/minidump/LeftJoinPruningOuterQuery.mdp | 4 +-
.../LeftOuter2InnerUnionAllAntiSemiJoin-Tpcds.mdp | 70 -
.../dxl/minidump/LogicalIndexGetDroppedCols.mdp | 2 +-
.../gporca/data/dxl/minidump/MS-UnionAll-1.mdp | 7389 -----------------
.../gporca/data/dxl/minidump/MS-UnionAll-2.mdp | 7389 -----------------
.../gporca/data/dxl/minidump/MS-UnionAll-4.mdp | 8483 --------------------
.../gporca/data/dxl/minidump/MS-UnionAll-5.mdp | 2052 -----
.../gporca/data/dxl/minidump/MS-UnionAll-6.mdp | 2234 ------
.../gporca/data/dxl/minidump/MS-UnionAll-7.mdp | 2234 ------
.../data/dxl/minidump/MultipleIndexPredicate.mdp | 10 +-
.../data/dxl/minidump/NLJ-DistCol-No-Broadcast.mdp | 8 +-
.../dxl/minidump/NLJ-EqAllCol-No-Broadcast.mdp | 165 +-
.../NLJ-EqDistCol-InEqNonDistCol-No-Broadcast.mdp | 8 +-
.../NLJ-InEqDistCol-EqNonDistCol-Redistribute.mdp | 10 +-
.../data/dxl/minidump/Negative-IndexApply1.mdp | 4 +-
.../data/dxl/minidump/Negative-IndexApply2.mdp | 4 +-
.../gporca/data/dxl/minidump/Nested-Setops-2.mdp | 2 +-
.../dxl/minidump/NestedNLJWithBlockingSpool.mdp | 4 +-
.../data/dxl/minidump/NewBtreeIndexScanCost.mdp | 4 +-
.../gporca/data/dxl/minidump/NoSortPlan.mdp | 2 +-
...ngHomogenousIndexesOnRoot-ANDPredicate-HEAP.mdp | 4 +-
.../dxl/minidump/OrderedAgg_multiple_diffcol.mdp | 6 -
.../dxl/minidump/OrderedAgg_multiple_samecol.mdp | 3 -
.../OrderedAgg_multiple_samecol_difforderespec.mdp | 6 -
.../gporca/data/dxl/minidump/OrderedAgg_single.mdp | 3 -
.../dxl/minidump/OrderedAgg_with_nonOrderedAgg.mdp | 6 -
.../minidump/OrderedAgg_with_nonconst_fraction.mdp | 4 -
...ngHomogenousIndexesOnRoot-ANDPredicate-HEAP.mdp | 4 +-
.../OverlappingHomogenousIndexesOnRoot-HEAP.mdp | 4 +-
.../PartConstraint-WhenDefaultPartsAndIndices.mdp | 2 +-
...PartConstraint-WhenIndicesAndNoDefaultParts.mdp | 2 +-
.../data/dxl/minidump/PartForeignMixedDPE.mdp | 2 +-
.../PartTbl-ComplexRangePredicate-DefaultPart.mdp | 4 +-
.../data/dxl/minidump/PartTbl-IDFWithCast.mdp | 4 +-
.../dxl/minidump/PartTbl-IndexOnDefPartOnly.mdp | 2 +-
.../data/dxl/minidump/PartTbl-JoinOverUnion-1.mdp | 2 +-
.../data/dxl/minidump/PartTbl-JoinOverUnion-2.mdp | 2 +-
.../dxl/minidump/PartTbl-MultiWayJoinWithDPE.mdp | 4 +-
.../data/dxl/minidump/PartTbl-NEqPredicate.mdp | 4 +-
.../PredicateWithConjunctsAndDisjuncts.mdp | 6 +-
.../minidump/PredicateWithConjunctsOfDisjuncts.mdp | 6 +-
.../dxl/minidump/PredicateWithLongConjunction.mdp | 6 +-
...ueryMismatchedDistribution-DynamicIndexScan.mdp | 2 +-
.../data/dxl/minidump/Select-Proj-OuterJoin.mdp | 8 +-
.../gporca/data/dxl/minidump/SelectOnCastedCol.mdp | 2 +-
.../SingleColumnHomogenousIndexOnRoot-AO.mdp | 2 +-
.../SingleColumnHomogenousIndexOnRoot-HEAP.mdp | 2 +-
.../dxl/minidump/Stat-Derivation-Leaf-Pattern.mdp | 10 +-
.../gporca/data/dxl/minidump/SubqInIndexPred.mdp | 2 +-
.../minidump/TPCDS-39-InnerJoin-JoinEstimate.mdp | 4 +-
.../data/dxl/minidump/TVF-With-Deep-Subq-Args.mdp | 8 -
.../dxl/minidump/Tpcds-10TB-Q37-NoIndexJoin.mdp | 48 +-
.../data/dxl/minidump/Tpcds-NonPart-Q70a.mdp | 6 +-
src/backend/gporca/data/dxl/minidump/UnionAll.mdp | 4 +-
.../gporca/data/dxl/minidump/UnionOfDQAQueries.mdp | 2 +-
.../gporca/data/dxl/minidump/UnnestSQJoins.mdp | 12 +-
.../dxl/minidump/UnsupportedStatsPredicate.mdp | 4 +-
.../data/dxl/minidump/UpdateUniqueConstraint-2.mdp | 2 +-
src/backend/gporca/data/dxl/minidump/retail_28.mdp | 2 +-
.../gporca/data/dxl/parse_tests/q26-Metadata.xml | 6 +-
.../include/gpdbcost/CCostModelParamsGPDB.h | 6 +-
.../gporca/libgpdbcost/src/CCostModelGPDB.cpp | 68 +-
.../libgpdbcost/src/CCostModelParamsGPDB.cpp | 10 +-
.../libgpopt/include/gpopt/base/CCastUtils.h | 3 +
.../gporca/libgpopt/include/gpopt/base/CColRef.h | 3 +-
.../libgpopt/include/gpopt/base/CColumnFactory.h | 5 +-
.../include/gpopt/base/CDistributionSpecHashed.h | 2 -
.../include/gpopt/base/CDistributionSpecRandom.h | 2 -
.../gpopt/operators/CLogicalDynamicForeignGet.h | 11 +-
.../libgpopt/include/gpopt/operators/CPhysical.h | 2 +-
.../gpopt/operators/CPhysicalDynamicForeignScan.h | 11 +-
.../include/gpopt/operators/CPhysicalMotion.h | 2 +-
.../gpopt/operators/CPhysicalMotionRandom.h | 9 +
.../include/gpopt/operators/CPredicateUtils.h | 4 +-
.../gporca/libgpopt/include/gpopt/xforms/CXform.h | 3 +
.../CXformExpandDynamicGetWithForeignPartitions.h | 9 +-
.../include/gpopt/xforms/CXformJoin2IndexApply.h | 5 +-
.../include/gpopt/xforms/CXformLimit2IndexGet.h | 75 +
.../gpopt/xforms/CXformPushJoinBelowLeftUnionAll.h | 95 +
.../xforms/CXformPushJoinBelowRightUnionAll.h | 86 +
.../gpopt/xforms/CXformPushJoinBelowUnionAll.h | 68 +
.../libgpopt/include/gpopt/xforms/CXformUtils.h | 41 +-
.../gporca/libgpopt/include/gpopt/xforms/xforms.h | 4 +
.../gporca/libgpopt/src/base/CCastUtils.cpp | 8 +
.../gporca/libgpopt/src/base/CColumnFactory.cpp | 12 +-
.../libgpopt/src/base/CDistributionSpecHashed.cpp | 32 -
.../src/base/CDistributionSpecNonSingleton.cpp | 3 +-
.../libgpopt/src/base/CDistributionSpecRandom.cpp | 3 +-
.../src/operators/CExpressionPreprocessor.cpp | 30 +-
.../src/operators/CLogicalDynamicForeignGet.cpp | 6 +-
.../libgpopt/src/operators/CLogicalInnerJoin.cpp | 2 +
.../src/operators/CLogicalLeftOuterJoin.cpp | 2 +
.../libgpopt/src/operators/CLogicalLimit.cpp | 1 +
.../gporca/libgpopt/src/operators/CPhysical.cpp | 5 +
.../src/operators/CPhysicalDynamicForeignScan.cpp | 21 +-
.../src/operators/CPhysicalForeignScan.cpp | 13 -
.../libgpopt/src/operators/CPhysicalJoin.cpp | 32 +-
.../src/operators/CPhysicalMotionRandom.cpp | 43 +-
.../libgpopt/src/operators/CPredicateUtils.cpp | 52 +-
.../CXformDynamicForeignGet2DynamicForeignScan.cpp | 2 +-
...CXformExpandDynamicGetWithForeignPartitions.cpp | 12 +-
.../gporca/libgpopt/src/xforms/CXformFactory.cpp | 3 +
.../src/xforms/CXformIndexGet2IndexOnlyScan.cpp | 9 +-
.../libgpopt/src/xforms/CXformJoin2IndexApply.cpp | 16 +-
.../libgpopt/src/xforms/CXformLimit2IndexGet.cpp | 205 +
.../src/xforms/CXformPushJoinBelowUnionAll.cpp | 208 +
.../src/xforms/CXformSelect2DynamicIndexGet.cpp | 8 +-
.../libgpopt/src/xforms/CXformSelect2IndexGet.cpp | 8 +-
.../gporca/libgpopt/src/xforms/CXformUtils.cpp | 110 +-
src/backend/gporca/libgpopt/src/xforms/Makefile | 2 +
.../include/naucrates/dxl/xml/dxltokens.h | 1 +
.../include/naucrates/md/IMDRelation.h | 1 +
.../include/naucrates/traceflags/traceflags.h | 4 -
.../gporca/libnaucrates/src/md/CMDIndexGPDB.cpp | 8 +-
.../gporca/libnaucrates/src/md/IMDRelation.cpp | 2 +
.../src/operators/CDXLOperatorFactory.cpp | 6 +
.../gporca/libnaucrates/src/xml/dxltokens.cpp | 1 +
src/backend/gporca/server/CMakeLists.txt | 28 +-
.../dxl/statistics/CJoinCardinalityTest.cpp | 8 +-
.../unittest/dxl/statistics/CStatisticsTest.cpp | 12 +-
src/backend/optimizer/util/plancat.c | 16 +-
src/backend/optimizer/util/tlist.c | 11 +-
src/backend/utils/misc/guc_gp.c | 22 +-
src/include/gpopt/gpdbwrappers.h | 20 +
src/include/gpopt/translate/CContextDXLToPlStmt.h | 7 +-
.../gpopt/translate/CTranslatorDXLToPlStmt.h | 22 +-
.../gpopt/translate/CTranslatorRelcacheToDXL.h | 8 +-
src/include/nodes/plannodes.h | 2 -
src/include/utils/guc.h | 2 +-
src/include/utils/unsync_guc_name.h | 2 +-
...tition_table_operations_should_not_deadlock.out | 223 +
...le_operations_should_not_deadlock_optimizer.out | 217 +
src/test/isolation2/isolation2_schedule | 1 +
...tition_table_operations_should_not_deadlock.sql | 95 +
.../regress/expected/DML_over_joins_optimizer.out | 190 -
src/test/regress/expected/bfv_aggregate.out | 56 +
.../regress/expected/bfv_aggregate_optimizer.out | 56 +
src/test/regress/expected/bfv_dml.out | 14 +
src/test/regress/expected/bfv_dml_optimizer.out | 17 +
src/test/regress/expected/bfv_index.out | 227 +
src/test/regress/expected/bfv_index_optimizer.out | 236 +
.../regress/expected/create_index_optimizer.out | 5 +-
src/test/regress/expected/direct_dispatch.out | 27 +-
.../regress/expected/direct_dispatch_optimizer.out | 24 +-
src/test/regress/expected/gp_covering_index.out | 651 ++
.../expected/gp_covering_index_optimizer.out | 608 ++
src/test/regress/expected/gp_dqa.out | 53 +-
src/test/regress/expected/gp_dqa_optimizer.out | 67 +-
src/test/regress/expected/gp_tsrf.out | 262 +
src/test/regress/expected/gp_tsrf_optimizer.out | 263 +
src/test/regress/expected/gporca_optimizer.out | 8 -
.../expected/incremental_sort_optimizer.out | 26 +-
.../expected/index_including_gist_optimizer.out | 15 +-
src/test/regress/expected/indexjoin_optimizer.out | 12 +-
src/test/regress/expected/join_gp.out | 166 +
src/test/regress/expected/join_gp_optimizer.out | 153 +
src/test/regress/expected/join_optimizer.out | 44 +-
src/test/regress/expected/memoize.out | 4 +
src/test/regress/expected/memoize_optimizer.out | 49 +-
src/test/regress/expected/partition_locking.out | 46 +-
...locking.out => partition_locking_optimizer.out} | 70 +-
src/test/regress/expected/qp_correlated_query.out | 104 +
.../expected/qp_correlated_query_optimizer.out | 112 +
src/test/regress/expected/qp_indexscan.out | 579 ++
.../regress/expected/qp_indexscan_optimizer.out | 582 ++
src/test/regress/expected/qp_join_union_all.out | 1027 +++
.../expected/qp_join_union_all_optimizer.out | 1090 +++
src/test/regress/expected/qp_misc_optimizer.out | 2 -
src/test/regress/expected/rangetypes.out | 3 -
src/test/regress/expected/rangetypes_optimizer.out | 3 -
src/test/regress/expected/stats_ext_optimizer.out | 4 +-
.../regress/expected/subselect_gp_optimizer.out | 62 +-
src/test/regress/expected/tsrf_optimizer.out | 39 +-
src/test/regress/expected/union_optimizer.out | 76 +-
src/test/regress/greenplum_schedule | 6 +-
src/test/regress/init_file | 4 +
src/test/regress/sql/bfv_aggregate.sql | 19 +
src/test/regress/sql/bfv_dml.sql | 6 +
src/test/regress/sql/bfv_index.sql | 88 +
src/test/regress/sql/direct_dispatch.sql | 5 +-
src/test/regress/sql/gp_covering_index.sql | 360 +
src/test/regress/sql/gp_dqa.sql | 16 +-
src/test/regress/sql/gp_tsrf.sql | 45 +
src/test/regress/sql/join_gp.sql | 53 +
src/test/regress/sql/memoize.sql | 4 +
src/test/regress/sql/partition_locking.sql | 30 +-
src/test/regress/sql/qp_correlated_query.sql | 88 +
src/test/regress/sql/qp_indexscan.sql | 77 +
src/test/regress/sql/qp_join_union_all.sql | 348 +
src/test/regress/sql/rangetypes.sql | 5 -
431 files changed, 18438 insertions(+), 36718 deletions(-)
copy contrib/postgres_fdw/expected/{gp_postgres_fdw.out =>
gp_postgres_fdw_optimizer.out} (53%)
copy src/backend/gporca/data/dxl/minidump/{Hash-IndexScan.mdp =>
CoveringIndex-1.mdp} (64%)
copy src/backend/gporca/data/dxl/minidump/{DisableBroadcastThreshold.mdp =>
CoveringIndex-2.mdp} (80%)
copy src/backend/gporca/data/dxl/minidump/{Hash-IndexScan.mdp =>
CoveringIndex-3.mdp} (66%)
create mode 100644
src/backend/gporca/data/dxl/minidump/CoveringIndex-Cost-1.mdp
create mode 100644
src/backend/gporca/data/dxl/minidump/CoveringIndex-Cost-2.mdp
copy src/backend/gporca/data/dxl/minidump/{DQA-GroupBy-HashAggregate2.mdp =>
DistinctQueryWithMotions.mdp} (57%)
create mode 100644
src/backend/gporca/data/dxl/minidump/ExceptHashCompatibleRange.mdp
create mode 100644
src/backend/gporca/data/dxl/minidump/ExceptHashIncompatibleRange.mdp
copy src/backend/gporca/data/dxl/minidump/{PartForeignMixedDPE.mdp =>
ForeignPartOneTimeFilterDPE.mdp} (56%)
copy src/backend/gporca/data/dxl/minidump/{LOJ-With-Single-Pred-On-Outer.mdp
=> ForeignScanExecLocAnyJoin.mdp} (62%)
copy
src/backend/gporca/data/dxl/minidump/{ConstScalarFuncNotPushedBelowGather.mdp
=> ForeignScanExecLocAnySimpleScan.mdp} (58%)
copy src/backend/gporca/data/dxl/minidump/{ReplicatedTableGroupBy.mdp =>
Hash-BitmapScan-InArray.mdp} (86%)
copy src/backend/gporca/data/dxl/minidump/{ReplicatedTableGroupBy.mdp =>
Hash-TableScan-AllArray.mdp} (87%)
copy
src/backend/gporca/data/dxl/minidump/{IndexApply-IndexOnMasterOnlyTable.mdp =>
IndexApply-IndexOnCoordinatorOnlyTable.mdp} (99%)
copy src/backend/gporca/data/dxl/minidump/{Hash-IndexScan.mdp =>
IndexOnlyScan-CTE.mdp} (56%)
copy src/backend/gporca/data/dxl/minidump/{CTAS-with-Limit.mdp =>
IndexScan-OrderBy-on-Multiple-IndexCols.mdp} (67%)
copy src/backend/gporca/data/dxl/minidump/{CTAS-with-Limit.mdp =>
IndexScan-OrderBy-on-NonIndexCol.mdp} (66%)
copy src/backend/gporca/data/dxl/minidump/{CTAS-with-Limit.mdp =>
IndexScan-OrderBy-on-Single-IndexCol.mdp} (67%)
copy src/backend/gporca/data/dxl/minidump/{NaryWithLojAndNonLojChilds.mdp =>
JoinBelowUnionAll.mdp} (59%)
copy src/backend/gporca/data/dxl/minidump/{SqlFuncNullReject.mdp =>
JoinPredFalseFilter.mdp} (57%)
copy src/backend/gporca/data/dxl/minidump/{LOJ-IndexApply-MasterOnly-Table.mdp
=> LOJ-IndexApply-CoordinatorOnly-Table.mdp} (98%)
delete mode 100644 src/backend/gporca/data/dxl/minidump/MS-UnionAll-1.mdp
delete mode 100644 src/backend/gporca/data/dxl/minidump/MS-UnionAll-2.mdp
delete mode 100644 src/backend/gporca/data/dxl/minidump/MS-UnionAll-4.mdp
delete mode 100644 src/backend/gporca/data/dxl/minidump/MS-UnionAll-5.mdp
delete mode 100644 src/backend/gporca/data/dxl/minidump/MS-UnionAll-6.mdp
delete mode 100644 src/backend/gporca/data/dxl/minidump/MS-UnionAll-7.mdp
create mode 100644
src/backend/gporca/libgpopt/include/gpopt/xforms/CXformLimit2IndexGet.h
create mode 100644
src/backend/gporca/libgpopt/include/gpopt/xforms/CXformPushJoinBelowLeftUnionAll.h
create mode 100644
src/backend/gporca/libgpopt/include/gpopt/xforms/CXformPushJoinBelowRightUnionAll.h
create mode 100644
src/backend/gporca/libgpopt/include/gpopt/xforms/CXformPushJoinBelowUnionAll.h
create mode 100644
src/backend/gporca/libgpopt/src/xforms/CXformLimit2IndexGet.cpp
create mode 100644
src/backend/gporca/libgpopt/src/xforms/CXformPushJoinBelowUnionAll.cpp
create mode 100644
src/test/isolation2/expected/concurrent_partition_table_operations_should_not_deadlock.out
create mode 100644
src/test/isolation2/expected/concurrent_partition_table_operations_should_not_deadlock_optimizer.out
create mode 100644
src/test/isolation2/sql/concurrent_partition_table_operations_should_not_deadlock.sql
create mode 100644 src/test/regress/expected/gp_covering_index.out
create mode 100644 src/test/regress/expected/gp_covering_index_optimizer.out
create mode 100644 src/test/regress/expected/gp_tsrf.out
create mode 100644 src/test/regress/expected/gp_tsrf_optimizer.out
copy src/test/regress/expected/{partition_locking.out =>
partition_locking_optimizer.out} (93%)
create mode 100644 src/test/regress/expected/qp_indexscan.out
create mode 100644 src/test/regress/expected/qp_indexscan_optimizer.out
create mode 100644 src/test/regress/expected/qp_join_union_all.out
create mode 100644 src/test/regress/expected/qp_join_union_all_optimizer.out
create mode 100644 src/test/regress/sql/gp_covering_index.sql
create mode 100644 src/test/regress/sql/gp_tsrf.sql
create mode 100644 src/test/regress/sql/qp_indexscan.sql
create mode 100644 src/test/regress/sql/qp_join_union_all.sql
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
