You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by ma...@apache.org on 2025/01/02 10:21:59 UTC
(cloudberry) 05/15: Simplify Nary join with inner joins if predicate is false in Orca (#14284)
This is an automated email from the ASF dual-hosted git repository.
maxyang pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit ebd236e003487a8bcd68ff2daf75d3942aa4d93c
Author: Chris Hajas <ch...@vmware.com>
AuthorDate: Wed Oct 19 12:59:31 2022 -0700
Simplify Nary join with inner joins if predicate is false in Orca (#14284)
Previously, if an Nary join with only inner joins had a false filter, it
was possible the normalization preprocessing step would pull the false
filter into one of the joins. While this would end up simplifying one of
the joins, it would cause the other joins to still exist with a constant
true filter, leading to poor performing plans.
Now, if we have an nary join with a false scalar condition, just
simplify the entire join tree to a false filter. Note that we can't do
this if outer joins exist in the tree, so we take care to only do this
for inner joins.
---
.../dxl/minidump/AggSubqCollapseFalseFilter.mdp | 794 +++++++++++++++++++++
.../gporca/libgpopt/src/operators/CNormalizer.cpp | 16 +
src/backend/gporca/server/CMakeLists.txt | 3 +-
3 files changed, 812 insertions(+), 1 deletion(-)
diff --git a/src/backend/gporca/data/dxl/minidump/AggSubqCollapseFalseFilter.mdp b/src/backend/gporca/data/dxl/minidump/AggSubqCollapseFalseFilter.mdp
new file mode 100644
index 0000000000..3d3e8abfcd
--- /dev/null
+++ b/src/backend/gporca/data/dxl/minidump/AggSubqCollapseFalseFilter.mdp
@@ -0,0 +1,794 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<dxl:DXLMessage xmlns:dxl="http://greenplum.com/dxl/2010/12/">
+ <dxl:Comment><![CDATA[
+ Objective: This query should be collapsed into a one-time false filter during preprocessing
+
+ create table part (i int, j int) distributed by (i) partition by range(j) (start(1) end(10) every(1));
+ create table foo (a int);
+ explain select 1 from (select distinct a from foo) t1, part where j =2 and 0=1;
+
+ QUERY PLAN
+ ------------------------------------------
+ Result (cost=0.00..0.00 rows=0 width=4)
+ One-Time Filter: false
+ Optimizer: Pivotal Optimizer (GPORCA)
+ (3 rows)
+ ]]>
+ </dxl:Comment>
+ <dxl:Thread Id="0">
+ <dxl:OptimizerConfig>
+ <dxl:EnumeratorConfig Id="0" PlanSamples="0" CostThreshold="0"/>
+ <dxl:StatisticsConfig DampingFactorFilter="0.750000" DampingFactorJoin="0.000000" DampingFactorGroupBy="0.750000" MaxStatsBuckets="100"/>
+ <dxl:CTEConfig CTEInliningCutoff="0"/>
+ <dxl:WindowOids RowNumber="3100" Rank="3101"/>
+ <dxl:CostModelConfig CostModelType="1" SegmentsForCosting="3">
+ <dxl:CostParams>
+ <dxl:CostParam Name="NLJFactor" Value="1024.000000" LowerBound="1023.500000" UpperBound="1024.500000"/>
+ </dxl:CostParams>
+ </dxl:CostModelConfig>
+ <dxl:Hint MinNumOfPartsToRequireSortOnInsert="2147483647" JoinArityForAssociativityCommutativity="18" ArrayExpansionThreshold="20" JoinOrderDynamicProgThreshold="10" BroadcastThreshold="100000" EnforceConstraintsOnDML="false" PushGroupByBelowSetopThreshold="10" XformBindThreshold="0"/>
+ <dxl:TraceFlags Value="102001,102002,102003,102043,102074,102120,102144,103001,103014,103022,103026,103027,103029,103033,103038,103040,104002,104003,104004,104005,105000,106000"/>
+ </dxl:OptimizerConfig>
+ <dxl:Metadata SystemIds="0.GPDB">
+ <dxl:Type Mdid="0.16.1.0" Name="bool" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="1" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.2222.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7124.1.0"/>
+ <dxl:EqualityOp Mdid="0.91.1.0"/>
+ <dxl:InequalityOp Mdid="0.85.1.0"/>
+ <dxl:LessThanOp Mdid="0.58.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.1694.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.59.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.1695.1.0"/>
+ <dxl:ComparisonOp Mdid="0.1693.1.0"/>
+ <dxl:ArrayType Mdid="0.1000.1.0"/>
+ <dxl:MinAgg Mdid="0.0.0.0"/>
+ <dxl:MaxAgg Mdid="0.0.0.0"/>
+ <dxl:AvgAgg Mdid="0.0.0.0"/>
+ <dxl:SumAgg Mdid="0.0.0.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.23.1.0" Name="int4" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7100.1.0"/>
+ <dxl:EqualityOp Mdid="0.96.1.0"/>
+ <dxl:InequalityOp Mdid="0.518.1.0"/>
+ <dxl:LessThanOp Mdid="0.97.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.523.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.521.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.525.1.0"/>
+ <dxl:ComparisonOp Mdid="0.351.1.0"/>
+ <dxl:ArrayType Mdid="0.1007.1.0"/>
+ <dxl:MinAgg Mdid="0.2132.1.0"/>
+ <dxl:MaxAgg Mdid="0.2116.1.0"/>
+ <dxl:AvgAgg Mdid="0.2101.1.0"/>
+ <dxl:SumAgg Mdid="0.2108.1.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.26.1.0" Name="oid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.1990.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7109.1.0"/>
+ <dxl:EqualityOp Mdid="0.607.1.0"/>
+ <dxl:InequalityOp Mdid="0.608.1.0"/>
+ <dxl:LessThanOp Mdid="0.609.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.611.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.610.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.612.1.0"/>
+ <dxl:ComparisonOp Mdid="0.356.1.0"/>
+ <dxl:ArrayType Mdid="0.1028.1.0"/>
+ <dxl:MinAgg Mdid="0.2134.1.0"/>
+ <dxl:MaxAgg Mdid="0.2118.1.0"/>
+ <dxl:AvgAgg Mdid="0.0.0.0"/>
+ <dxl:SumAgg Mdid="0.0.0.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.27.1.0" Name="tid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="true" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="6" PassByValue="false">
+ <dxl:DistrOpfamily Mdid="0.2227.1.0"/>
+ <dxl:LegacyDistrOpfamily Mdid="0.7110.1.0"/>
+ <dxl:EqualityOp Mdid="0.387.1.0"/>
+ <dxl:InequalityOp Mdid="0.402.1.0"/>
+ <dxl:LessThanOp Mdid="0.2799.1.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.2801.1.0"/>
+ <dxl:GreaterThanOp Mdid="0.2800.1.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.2802.1.0"/>
+ <dxl:ComparisonOp Mdid="0.2794.1.0"/>
+ <dxl:ArrayType Mdid="0.1010.1.0"/>
+ <dxl:MinAgg Mdid="0.2798.1.0"/>
+ <dxl:MaxAgg Mdid="0.2797.1.0"/>
+ <dxl:AvgAgg Mdid="0.0.0.0"/>
+ <dxl:SumAgg Mdid="0.0.0.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.29.1.0" Name="cid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="false" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.2226.1.0"/>
+ <dxl:EqualityOp Mdid="0.385.1.0"/>
+ <dxl:InequalityOp Mdid="0.0.0.0"/>
+ <dxl:LessThanOp Mdid="0.0.0.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.0.0.0"/>
+ <dxl:GreaterThanOp Mdid="0.0.0.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/>
+ <dxl:ComparisonOp Mdid="0.0.0.0"/>
+ <dxl:ArrayType Mdid="0.1012.1.0"/>
+ <dxl:MinAgg Mdid="0.0.0.0"/>
+ <dxl:MaxAgg Mdid="0.0.0.0"/>
+ <dxl:AvgAgg Mdid="0.0.0.0"/>
+ <dxl:SumAgg Mdid="0.0.0.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Type Mdid="0.28.1.0" Name="xid" IsRedistributable="true" IsHashable="true" IsMergeJoinable="false" IsComposite="false" IsTextRelated="false" IsFixedLength="true" Length="4" PassByValue="true">
+ <dxl:DistrOpfamily Mdid="0.2225.1.0"/>
+ <dxl:EqualityOp Mdid="0.352.1.0"/>
+ <dxl:InequalityOp Mdid="0.3315.1.0"/>
+ <dxl:LessThanOp Mdid="0.0.0.0"/>
+ <dxl:LessThanEqualsOp Mdid="0.0.0.0"/>
+ <dxl:GreaterThanOp Mdid="0.0.0.0"/>
+ <dxl:GreaterThanEqualsOp Mdid="0.0.0.0"/>
+ <dxl:ComparisonOp Mdid="0.0.0.0"/>
+ <dxl:ArrayType Mdid="0.1011.1.0"/>
+ <dxl:MinAgg Mdid="0.0.0.0"/>
+ <dxl:MaxAgg Mdid="0.0.0.0"/>
+ <dxl:AvgAgg Mdid="0.0.0.0"/>
+ <dxl:SumAgg Mdid="0.0.0.0"/>
+ <dxl:CountAgg Mdid="0.2147.1.0"/>
+ </dxl:Type>
+ <dxl:Relation Mdid="0.278707.1.0" Name="part" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="7,8,2" PartitionColumns="1" PartitionTypes="r" NumberLeafPartitions="9">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:Partitions>
+ <dxl:Partition Mdid="0.278710.1.0"/>
+ <dxl:Partition Mdid="0.278713.1.0"/>
+ <dxl:Partition Mdid="0.278716.1.0"/>
+ <dxl:Partition Mdid="0.278719.1.0"/>
+ <dxl:Partition Mdid="0.278722.1.0"/>
+ <dxl:Partition Mdid="0.278725.1.0"/>
+ <dxl:Partition Mdid="0.278728.1.0"/>
+ <dxl:Partition Mdid="0.278731.1.0"/>
+ <dxl:Partition Mdid="0.278734.1.0"/>
+ </dxl:Partitions>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278710.1.0" Name="part_1_prt_1" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="1"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="2"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278713.1.0" Name="part_1_prt_2" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="2"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="3"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278719.1.0" Name="part_1_prt_4" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="4"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="5"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278716.1.0" Name="part_1_prt_3" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="3"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="4"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278722.1.0" Name="part_1_prt_5" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="5"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="6"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278725.1.0" Name="part_1_prt_6" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="6"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="7"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278731.1.0" Name="part_1_prt_8" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="8"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="9"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278728.1.0" Name="part_1_prt_7" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="7"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="8"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278734.1.0" Name="part_1_prt_9" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="8,2" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="i" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="j" Attno="2" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ <dxl:PartConstraint>
+ <dxl:And>
+ <dxl:IsNotNull>
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ </dxl:IsNotNull>
+ <dxl:Comparison ComparisonOperator=">=" OperatorMdid="0.525.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="9"/>
+ </dxl:Comparison>
+ <dxl:Comparison ComparisonOperator="<" OperatorMdid="0.97.1.0">
+ <dxl:Ident ColId="2" ColName="j" TypeMdid="0.23.1.0"/>
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="10"/>
+ </dxl:Comparison>
+ </dxl:And>
+ </dxl:PartConstraint>
+ </dxl:Relation>
+ <dxl:Relation Mdid="0.278737.1.0" Name="foo" IsTemporary="false" StorageType="Heap" DistributionPolicy="Hash" DistributionColumns="0" Keys="7,1" NumberLeafPartitions="0">
+ <dxl:Columns>
+ <dxl:Column Name="a" Attno="1" Mdid="0.23.1.0" Nullable="true" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="ctid" Attno="-1" Mdid="0.27.1.0" Nullable="false" ColWidth="6">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmin" Attno="-2" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmin" Attno="-3" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="xmax" Attno="-4" Mdid="0.28.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="cmax" Attno="-5" Mdid="0.29.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="tableoid" Attno="-6" Mdid="0.26.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ <dxl:Column Name="gp_segment_id" Attno="-7" Mdid="0.23.1.0" Nullable="false" ColWidth="4">
+ <dxl:DefaultValue/>
+ </dxl:Column>
+ </dxl:Columns>
+ <dxl:IndexInfoList/>
+ <dxl:Triggers/>
+ <dxl:CheckConstraints/>
+ <dxl:DistrOpfamilies>
+ <dxl:DistrOpfamily Mdid="0.1977.1.0"/>
+ </dxl:DistrOpfamilies>
+ </dxl:Relation>
+ </dxl:Metadata>
+ <dxl:Query>
+ <dxl:OutputColumns>
+ <dxl:Ident ColId="18" ColName="?column?" TypeMdid="0.23.1.0"/>
+ </dxl:OutputColumns>
+ <dxl:CTEList/>
+ <dxl:LogicalProject>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="18" Alias="?column?">
+ <dxl:ConstValue TypeMdid="0.23.1.0" Value="1"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:LogicalJoin JoinType="Inner">
+ <dxl:LogicalGroupBy>
+ <dxl:GroupingColumns>
+ <dxl:GroupingColumn ColId="1"/>
+ </dxl:GroupingColumns>
+ <dxl:ProjList/>
+ <dxl:LogicalGet>
+ <dxl:TableDescriptor Mdid="0.278737.1.0" TableName="foo" LockMode="1">
+ <dxl:Columns>
+ <dxl:Column ColId="1" Attno="1" ColName="a" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="2" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0" ColWidth="6"/>
+ <dxl:Column ColId="3" Attno="-2" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="4" Attno="-3" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="5" Attno="-4" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="6" Attno="-5" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="7" Attno="-6" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
+ <dxl:Column ColId="8" Attno="-7" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
+ </dxl:Columns>
+ </dxl:TableDescriptor>
+ </dxl:LogicalGet>
+ </dxl:LogicalGroupBy>
+ <dxl:LogicalGet>
+ <dxl:TableDescriptor Mdid="0.278707.1.0" TableName="part" LockMode="1">
+ <dxl:Columns>
+ <dxl:Column ColId="9" Attno="1" ColName="i" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="10" Attno="2" ColName="j" TypeMdid="0.23.1.0" ColWidth="4"/>
+ <dxl:Column ColId="11" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0" ColWidth="6"/>
+ <dxl:Column ColId="12" Attno="-2" ColName="xmin" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="13" Attno="-3" ColName="cmin" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="14" Attno="-4" ColName="xmax" TypeMdid="0.28.1.0" ColWidth="4"/>
+ <dxl:Column ColId="15" Attno="-5" ColName="cmax" TypeMdid="0.29.1.0" ColWidth="4"/>
+ <dxl:Column ColId="16" Attno="-6" ColName="tableoid" TypeMdid="0.26.1.0" ColWidth="4"/>
+ <dxl:Column ColId="17" Attno="-7" ColName="gp_segment_id" TypeMdid="0.23.1.0" ColWidth="4"/>
+ </dxl:Columns>
+ </dxl:TableDescriptor>
+ </dxl:LogicalGet>
+ <dxl:ConstValue TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:LogicalJoin>
+ </dxl:LogicalProject>
+ </dxl:Query>
+ <dxl:Plan Id="0" SpaceSize="0">
+ <dxl:Result>
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="0.000000" Rows="0.000000" Width="4"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="17" Alias="?column?">
+ <dxl:Ident ColId="17" ColName="?column?" TypeMdid="0.23.1.0"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:OneTimeFilter/>
+ <dxl:Result>
+ <dxl:Properties>
+ <dxl:Cost StartupCost="0" TotalCost="0.000000" Rows="0.000000" Width="4"/>
+ </dxl:Properties>
+ <dxl:ProjList>
+ <dxl:ProjElem ColId="17" Alias="?column?">
+ <dxl:ConstValue TypeMdid="0.23.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="0" Alias="a">
+ <dxl:ConstValue TypeMdid="0.23.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="8" Alias="i">
+ <dxl:ConstValue TypeMdid="0.23.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="9" Alias="j">
+ <dxl:ConstValue TypeMdid="0.23.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="10" Alias="ctid">
+ <dxl:ConstValue TypeMdid="0.27.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="11" Alias="xmin">
+ <dxl:ConstValue TypeMdid="0.28.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="12" Alias="cmin">
+ <dxl:ConstValue TypeMdid="0.29.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="13" Alias="xmax">
+ <dxl:ConstValue TypeMdid="0.28.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="14" Alias="cmax">
+ <dxl:ConstValue TypeMdid="0.29.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="15" Alias="tableoid">
+ <dxl:ConstValue TypeMdid="0.26.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ <dxl:ProjElem ColId="16" Alias="gp_segment_id">
+ <dxl:ConstValue TypeMdid="0.23.1.0" IsNull="true"/>
+ </dxl:ProjElem>
+ </dxl:ProjList>
+ <dxl:Filter/>
+ <dxl:OneTimeFilter>
+ <dxl:ConstValue TypeMdid="0.16.1.0" Value="false"/>
+ </dxl:OneTimeFilter>
+ </dxl:Result>
+ </dxl:Result>
+ </dxl:Plan>
+ </dxl:Thread>
+</dxl:DXLMessage>
diff --git a/src/backend/gporca/libgpopt/src/operators/CNormalizer.cpp b/src/backend/gporca/libgpopt/src/operators/CNormalizer.cpp
index 4b179a90ba..97fb97a140 100644
--- a/src/backend/gporca/libgpopt/src/operators/CNormalizer.cpp
+++ b/src/backend/gporca/libgpopt/src/operators/CNormalizer.cpp
@@ -17,6 +17,7 @@
#include "gpopt/base/COptCtxt.h"
#include "gpopt/base/CUtils.h"
#include "gpopt/operators/CLogical.h"
+#include "gpopt/operators/CLogicalConstTableGet.h"
#include "gpopt/operators/CLogicalInnerJoin.h"
#include "gpopt/operators/CLogicalLeftOuterCorrelatedApply.h"
#include "gpopt/operators/CLogicalLeftOuterJoin.h"
@@ -864,6 +865,21 @@ CNormalizer::PushThruJoin(CMemoryPool *mp, CExpression *pexprJoin,
return;
}
+ // if we have an nary join with only inner joins and a false scalar condition,
+ // simplify the expression to a constant false. Trying to normalize this would
+ // improperly cause the scalar condition to be pulled into one of the predicates,
+ // and leave the condition as a const false
+ if (popNAryJoin && !fMixedInnerOuterJoin &&
+ CUtils::FScalarConstFalse(pexprConj))
+ {
+ COperator *popCTG = GPOS_NEW(mp) CLogicalConstTableGet(
+ mp, pexprJoin->DeriveOutputColumns()->Pdrgpcr(mp),
+ GPOS_NEW(mp) IDatum2dArray(mp));
+ *ppexprResult = GPOS_NEW(mp) CExpression(mp, popCTG);
+
+ return;
+ }
+
// combine conjunct with join predicate
CExpression *pexprScalar = (*pexprJoin)[arity - 1];
if (fMixedInnerOuterJoin)
diff --git a/src/backend/gporca/server/CMakeLists.txt b/src/backend/gporca/server/CMakeLists.txt
index db105f8743..50b2a3fc64 100644
--- a/src/backend/gporca/server/CMakeLists.txt
+++ b/src/backend/gporca/server/CMakeLists.txt
@@ -169,7 +169,8 @@ CJoinPredTest:
MultipleDampedPredJoinCardinality MultipleIndependentPredJoinCardinality MultiDistKeyJoinCardinality
MultiDistKeyWithOtherPredsJoinCardinality NoDistKeyMultiPredJoinCardinality OneDistKeyMultiPredJoinCardinality
JoinOnViewWithCastedColumn JoinOnViewWithCastedColumnAndSubqueryInPredicate JoinOnViewWithVolatileColumn
-JoinOnViewWithMixOfPushableAndNonpushablePredicates JoinOnViewWithSetReturningColumn OuterJoinOnViewWithCastedColumn JoinWithSubqueryProjectColumn;
+JoinOnViewWithMixOfPushableAndNonpushablePredicates JoinOnViewWithSetReturningColumn OuterJoinOnViewWithCastedColumn JoinWithSubqueryProjectColumn
+AggSubqCollapseFalseFilter;
CArrayCmpTest:
ArrayConcat ArrayRef FoldedArrayCmp ArrayCmpAll
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org