You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2026/02/06 09:21:27 UTC
(doris) branch branch-4.0 updated: branch-4.0: [fix](translator) fix set operation compute wrong result #60525 (#60562)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new bae8cb513ad branch-4.0: [fix](translator) fix set operation compute wrong result #60525 (#60562)
bae8cb513ad is described below
commit bae8cb513adf51bd038799105ff59b68fd8a8663
Author: github-actions[bot] <41...@users.noreply.github.com>
AuthorDate: Fri Feb 6 17:21:17 2026 +0800
branch-4.0: [fix](translator) fix set operation compute wrong result #60525 (#60562)
Cherry-picked from #60525
Co-authored-by: 924060929 <la...@selectdb.com>
---
.../glue/translator/PhysicalPlanTranslator.java | 4 +-
.../distribute/set_operation_colocate.out | 456 +++++++++++++++++++++
.../distribute/set_operation_colocate.groovy | 72 ++++
3 files changed, 529 insertions(+), 3 deletions(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/nereids/glue/translator/PhysicalPlanTranslator.java b/fe/fe-core/src/main/java/org/apache/doris/nereids/glue/translator/PhysicalPlanTranslator.java
index 89cf2b21585..f150c7f3bf4 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/nereids/glue/translator/PhysicalPlanTranslator.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/nereids/glue/translator/PhysicalPlanTranslator.java
@@ -90,7 +90,6 @@ import org.apache.doris.nereids.properties.DistributionSpecReplicated;
import org.apache.doris.nereids.properties.DistributionSpecStorageAny;
import org.apache.doris.nereids.properties.DistributionSpecStorageGather;
import org.apache.doris.nereids.properties.OrderKey;
-import org.apache.doris.nereids.properties.PhysicalProperties;
import org.apache.doris.nereids.rules.implementation.LogicalWindowToPhysicalWindow.WindowFrameGroup;
import org.apache.doris.nereids.rules.rewrite.MergeLimits;
import org.apache.doris.nereids.stats.StatsErrorEstimator;
@@ -2326,8 +2325,7 @@ public class PhysicalPlanTranslator extends DefaultPlanVisitor<PlanFragment, Pla
// in pipeline engine, we use parallel scan by default, but it broke the rule of data distribution
// we need turn of parallel scan to ensure to get correct result.
// TODO: nereids forbid all parallel scan under PhysicalSetOperation temporary
- if (!setOperation.getPhysicalProperties().equals(PhysicalProperties.ANY)
- && findOlapScanNodesByPassExchangeNode(setOperationFragment.getPlanRoot())) {
+ if (findOlapScanNodesByPassExchangeNode(setOperationFragment.getPlanRoot())) {
setOperationFragment.setHasColocatePlanNode(true);
setOperationNode.setColocate(true);
}
diff --git a/regression-test/data/nereids_syntax_p0/distribute/set_operation_colocate.out b/regression-test/data/nereids_syntax_p0/distribute/set_operation_colocate.out
new file mode 100644
index 00000000000..59fed2634eb
--- /dev/null
+++ b/regression-test/data/nereids_syntax_p0/distribute/set_operation_colocate.out
@@ -0,0 +1,456 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !test_1 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_2 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_3 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_4 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_5 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_6 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_7 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_8 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_9 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_10 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_11 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_12 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_13 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_14 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_15 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_16 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_17 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_18 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_19 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_20 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_21 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_22 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_23 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_24 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_25 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_26 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_27 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_28 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_29 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_30 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_31 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_32 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_33 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_34 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_35 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_36 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_37 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_38 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_39 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_40 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_41 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_42 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_43 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_44 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_45 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_46 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_47 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_48 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_49 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_50 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_51 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_52 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_53 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_54 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_55 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_56 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_57 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_58 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_59 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_60 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_61 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_62 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_63 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_64 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
+-- !test_65 --
+\N \N \N \N \N \N \N \N 1 -3231441 11504 68.1936 2019-10-28T01:04:45 2009-04-16 11.0481000000 y
+\N \N \N \N \N \N \N \N 13 \N 1806 71.0824 2007-04-02T18:31:51 2007-05-03 54.0616000000 think
+\N \N \N \N \N \N \N \N 2 10 31917 23.0015 2006-05-06T18:15:33 2013-02-14 19.0817000000 k
+\N \N \N \N \N \N \N \N 4 5 30294 13.1517 2010-04-18T00:55:35 2007-04-21 33.1809000000 there
+\N \N \N \N \N \N \N \N 7 \N 23507 97.1316 2016-09-09T05:23:54 2017-09-16 30.0162000000 y
+
diff --git a/regression-test/suites/nereids_syntax_p0/distribute/set_operation_colocate.groovy b/regression-test/suites/nereids_syntax_p0/distribute/set_operation_colocate.groovy
new file mode 100644
index 00000000000..5382cf8fb1d
--- /dev/null
+++ b/regression-test/suites/nereids_syntax_p0/distribute/set_operation_colocate.groovy
@@ -0,0 +1,72 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("set_operation_colocate") {
+ multi_sql """
+ drop table if exists table_20_undef_partitions2_keys3_properties4_distributed_by52;
+ create table table_20_undef_partitions2_keys3_properties4_distributed_by52 (
+ pk int,
+ col_int_undef_signed int ,
+ col_smallint_undef_signed smallint ,
+ col_float_undef_signed float ,
+ col_datetimev2_undef_signed datetimev2 ,
+ col_datev2_undef_signed datev2 ,
+ col_decimalv3_20_10__undef_signed decimalv3(20,10) ,
+ col_varchar_20__undef_signed varchar(20)
+ ) engine=olap
+ DUPLICATE KEY(pk, col_int_undef_signed)
+ distributed by hash(pk) buckets 10
+ properties("replication_num" = "1");
+ insert into table_20_undef_partitions2_keys3_properties4_distributed_by52(pk,col_int_undef_signed,col_smallint_undef_signed,col_float_undef_signed,col_datetimev2_undef_signed,col_datev2_undef_signed,col_decimalv3_20_10__undef_signed,col_varchar_20__undef_signed) values (0,30.1260,10555,32.0749,'2013-09-15 01:45:26','2002-01-19',66.0324,null),(1,-3231441,11504,68.1936,'2019-10-28 01:04:45','2009-04-16',11.0481,'y'),(2,10,31917,23.0015,'2006-05-06 18:15:33','2013-02-14',19.0817,'k' [...]
+
+ set session enable_runtime_filter_prune = false;
+ SET SESSION enable_fold_constant_by_be=true;
+ SET SESSION nth_optimized_plan = 1;
+ set enable_sql_cache=false;
+ set enable_query_cache=false;
+ """
+
+ String s = """SELECT *
+ FROM (SELECT *
+ FROM table_20_undef_partitions2_keys3_properties4_distributed_by52
+ WHERE col_varchar_20__undef_signed > 'q'
+ EXCEPT
+ SELECT *
+ FROM table_20_undef_partitions2_keys3_properties4_distributed_by52
+ WHERE col_datetimev2_undef_signed > '2004-09-24 11:57:37') t1
+ RIGHT JOIN (SELECT *
+ FROM table_20_undef_partitions2_keys3_properties4_distributed_by52
+ WHERE col_smallint_undef_signed > 6
+ INTERSECT
+ SELECT *
+ FROM table_20_undef_partitions2_keys3_properties4_distributed_by52
+ WHERE col_smallint_undef_signed > 7
+ INTERSECT
+ SELECT *
+ FROM table_20_undef_partitions2_keys3_properties4_distributed_by52
+ WHERE col_varchar_20__undef_signed > 'j') t2
+ ON t1.col_datetimev2_undef_signed = t2.col_datetimev2_undef_signed
+
+ """
+
+ sleep(60 * 1000)
+
+ for (int i = 1; i <= 65; ++i) {
+ sql "set parallel_pipeline_task_num=" + i
+ quickTest("test_" + i, s, true)
+ }
+}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org