This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new c5643e13e2a [fix](mtmv) Fix select literal result wrongly in group by
when use materialized view (#38958)
c5643e13e2a is described below
commit c5643e13e2a98f00f5d76680d9a1adad91c53008
Author: seawinde <149132972+seawi...@users.noreply.github.com>
AuthorDate: Tue Aug 20 20:16:04 2024 +0800
[fix](mtmv) Fix select literal result wrongly in group by when use
materialized view (#38958)
This is brought by #34274
if mv def is
select o_orderdate from orders group by o_orderdate;
query is as followiing, the result is wrong.
select 1 from orders group by o_orderdate;
---
.../mv/AbstractMaterializedViewAggregateRule.java | 45 +-
.../agg_optimize_when_uniform.out | 4 +-
.../mv/agg_with_roll_up/aggregate_with_roll_up.out | 476 +++++------
.../nereids_rules_p0/mv/variant/variant_data.json | 15 +
.../nereids_rules_p0/mv/variant/variant_mv.out | 884 ++++++++++++++++++---
.../mv/agg_on_none_agg/agg_on_none_agg.groovy | 22 -
.../agg_optimize_when_uniform.groovy | 7 +-
.../agg_with_roll_up/aggregate_with_roll_up.groovy | 51 +-
.../mv/grouping_sets/grouping_sets.groovy | 4 +
.../mv/join/dphyp_inner/inner_join_dphyp.groovy | 4 +
.../mv/join/dphyp_outer/outer_join_dphyp.groovy | 4 +
.../mv/join/inner/inner_join.groovy | 4 +
.../mv/join/left_outer/outer_join.groovy | 4 +
13 files changed, 1150 insertions(+), 374 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
index 0a1c633cb34..909f67de204 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/AbstractMaterializedViewAggregateRule.java
@@ -217,7 +217,7 @@ public abstract class AbstractMaterializedViewAggregateRule
extends AbstractMate
LogicalAggregate<Plan> queryAggregate = queryTopPlanAndAggPair.value();
List<Expression> queryGroupByExpressions =
queryAggregate.getGroupByExpressions();
// handle the scene that query top plan not use the group by in query
bottom aggregate
- if (queryGroupByExpressions.size() != queryTopPlanGroupBySet.size()) {
+ if (needCompensateGroupBy(queryTopPlanGroupBySet,
queryGroupByExpressions)) {
for (Expression expression : queryGroupByExpressions) {
if (queryTopPlanGroupBySet.contains(expression)) {
continue;
@@ -266,6 +266,42 @@ public abstract class
AbstractMaterializedViewAggregateRule extends AbstractMate
return new LogicalAggregate<>(finalGroupExpressions,
finalOutputExpressions, tempRewritedPlan);
}
+ /**
+ * handle the scene that query top plan not use the group by in query
bottom aggregate
+ * If mv is select o_orderdate from orders group by o_orderdate;
+ * query is select 1 from orders group by o_orderdate.
+ * Or mv is select o_orderdate from orders group by o_orderdate
+ * query is select o_orderdate from orders group by o_orderdate,
o_orderkey;
+ * if the slot which query top project use can not cover the slot which
query bottom aggregate group by slot
+ * should compensate group by to make sure the data is right.
+ * For example:
+ * mv is select o_orderdate from orders group by o_orderdate;
+ * query is select o_orderdate from orders group by o_orderdate,
o_orderkey;
+ *
+ * @param queryGroupByExpressions query bottom aggregate group by is
o_orderdate, o_orderkey
+ * @param queryTopProject query top project is o_orderdate
+ * @return need to compensate group by if true or not need
+ *
+ */
+ private static boolean needCompensateGroupBy(Set<? extends Expression>
queryTopProject,
+ List<Expression> queryGroupByExpressions) {
+ Set<Expression> queryGroupByExpressionSet = new
HashSet<>(queryGroupByExpressions);
+ if (queryGroupByExpressionSet.size() != queryTopProject.size()) {
+ return true;
+ }
+ Set<NamedExpression> queryTopPlanGroupByUseNamedExpressions = new
HashSet<>();
+ Set<NamedExpression> queryGroupByUseNamedExpressions = new HashSet<>();
+ for (Expression expr : queryTopProject) {
+
queryTopPlanGroupByUseNamedExpressions.addAll(expr.collect(NamedExpression.class::isInstance));
+ }
+ for (Expression expr : queryGroupByExpressionSet) {
+
queryGroupByUseNamedExpressions.addAll(expr.collect(NamedExpression.class::isInstance));
+ }
+ // if the slots query top project use can not cover the slots which
query bottom aggregate use
+ // Should compensate.
+ return
!queryTopPlanGroupByUseNamedExpressions.containsAll(queryGroupByUseNamedExpressions);
+ }
+
/**
* Try to rewrite query expression by view, contains both group by
dimension and aggregate function
*/
@@ -435,7 +471,12 @@ public abstract class
AbstractMaterializedViewAggregateRule extends AbstractMate
/**
* Check group by is equal or not after group by eliminate by functional
dependency
- * Such as query group by expression is (l_orderdate#1, l_supperkey#2)
+ * Such as query is select l_orderdate, l_supperkey, count(*) from table
group by l_orderdate, l_supperkey;
+ * materialized view is select l_orderdate, l_supperkey, l_partkey
count(*) from table
+ * group by l_orderdate, l_supperkey, l_partkey;
+ * Would check the extra l_partkey is can be eliminated by functional
dependency.
+ * The process step and data is as following:
+ * group by expression is (l_orderdate#1, l_supperkey#2)
* materialized view is group by expression is (l_orderdate#4,
l_supperkey#5, l_partkey#6)
* materialized view expression mapping is
* {l_orderdate#4:l_orderdate#10, l_supperkey#5:l_supperkey#11,
l_partkey#6:l_partkey#12}
diff --git
a/regression-test/data/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.out
b/regression-test/data/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.out
index 63f0bacf5d4..298d8191964 100644
---
a/regression-test/data/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.out
+++
b/regression-test/data/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.out
@@ -102,10 +102,10 @@ PhysicalResultSink
--hashAgg[GLOBAL]
----hashAgg[LOCAL]
------hashJoin[INNER_JOIN] hashCondition=((t1.l_orderkey = orders.o_orderkey)
and (t1.l_shipdate = orders.o_orderdate)) otherCondition=()
---------filter((orders.o_orderdate = '2023-12-09') and (orders.o_shippriority
= 1) and (orders.o_totalprice = 11.50))
-----------PhysicalOlapScan[orders]
--------filter((t1.l_shipdate = '2023-12-09'))
----------PhysicalOlapScan[lineitem]
+--------filter((orders.o_orderdate = '2023-12-09') and (orders.o_shippriority
= 1) and (orders.o_totalprice = 11.50))
+----------PhysicalOlapScan[orders]
-- !query7_1_after --
yy 4 11.50 11.50 11.50 1
diff --git
a/regression-test/data/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.out
b/regression-test/data/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.out
index 48f8c25fbf4..84a445b956b 100644
---
a/regression-test/data/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.out
+++
b/regression-test/data/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.out
@@ -1,389 +1,417 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !query13_0_before --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query13_0_after --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query13_1_before --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query13_1_after --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query14_0_before --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
2 3 2023-12-12 \N \N \N 1 0
2 4 2023-12-10 \N \N \N 1 0
3 3 2023-12-11 \N \N \N 1 0
4 3 2023-12-09 \N \N \N 1 0
-- !query14_0_after --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
2 3 2023-12-12 \N \N \N 1 0
2 4 2023-12-10 \N \N \N 1 0
3 3 2023-12-11 \N \N \N 1 0
4 3 2023-12-09 \N \N \N 1 0
-- !query15_0_before --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query15_0_after --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query15_1_before --
-2023-12-11 2023-12-11 3 3 43.20 43.20 43.20 1
0 \N 0
+2023-12-11 2023-12-11 3 3 129.60 43.20 43.20 3
0 \N 0
-- !query15_1_after --
-2023-12-11 2023-12-11 3 3 43.20 43.20 43.20 1
0 \N 0
+2023-12-11 2023-12-11 3 3 129.60 43.20 43.20 3
0 \N 0
-- !query16_0_before --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query16_0_after --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query17_0_before --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query17_0_after --
-3 3 2023-12-11 43.20 43.20 43.20 1 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
-- !query18_0_before --
-3 2023-12-11 43.20 43.20 43.20 1 0
+3 2023-12-11 129.60 43.20 43.20 3 0
-- !query18_0_after --
-3 2023-12-11 43.20 43.20 43.20 1 0
+3 2023-12-11 129.60 43.20 43.20 3 0
-- !query19_0_before --
-2 3 2023-12-08 20.00
-2 3 2023-12-12 57.40
-2 4 2023-12-10 46.00
+2 3 2023-12-08 41.00
+2 3 2023-12-12 169.80
+2 4 2023-12-10 71.00
-- !query19_0_after --
-2 3 2023-12-08 20.00
-2 3 2023-12-12 57.40
-2 4 2023-12-10 46.00
+2 3 2023-12-08 41.00
+2 3 2023-12-12 169.80
+2 4 2023-12-10 71.00
-- !query19_1_before --
-2 3 2023-12-08 20.00 10.50 9.50 0 2
-2 3 2023-12-12 57.40 56.20 1.20 0 2
+2 3 2023-12-08 41.00 10.50 9.50 0 4
+2 3 2023-12-12 169.80 56.20 1.20 0 4
-- !query19_1_after --
-2 3 2023-12-08 20.00 10.50 9.50 0 2
-2 3 2023-12-12 57.40 56.20 1.20 0 2
+2 3 2023-12-08 41.00 10.50 9.50 0 4
+2 3 2023-12-12 169.80 56.20 1.20 0 4
-- !query20_0_before --
-2023-12-08 3 2023-12-08 20.00 10.50 9.50 2 0
-2023-12-09 3 2023-12-09 11.50 11.50 11.50 1 0
-2023-12-10 4 2023-12-10 46.00 33.50 12.50 2 0
-2023-12-11 3 2023-12-11 43.20 43.20 43.20 1 0
-2023-12-12 3 2023-12-12 57.40 56.20 1.20 2 0
+2023-12-08 3 2023-12-08 41.00 10.50 9.50 4 0
+2023-12-09 3 2023-12-09 34.50 11.50 11.50 3 0
+2023-12-10 4 2023-12-10 71.00 33.50 12.50 4 0
+2023-12-11 3 2023-12-11 129.60 43.20 43.20 3 0
+2023-12-12 3 2023-12-12 169.80 56.20 1.20 4 0
-- !query20_0_after --
-2023-12-08 3 2023-12-08 20.00 10.50 9.50 2 0
-2023-12-09 3 2023-12-09 11.50 11.50 11.50 1 0
-2023-12-10 4 2023-12-10 46.00 33.50 12.50 2 0
-2023-12-11 3 2023-12-11 43.20 43.20 43.20 1 0
-2023-12-12 3 2023-12-12 57.40 56.20 1.20 2 0
+2023-12-08 3 2023-12-08 41.00 10.50 9.50 4 0
+2023-12-09 3 2023-12-09 34.50 11.50 11.50 3 0
+2023-12-10 4 2023-12-10 71.00 33.50 12.50 4 0
+2023-12-11 3 2023-12-11 129.60 43.20 43.20 3 0
+2023-12-12 3 2023-12-12 169.80 56.20 1.20 4 0
-- !query20_1_before --
-2023-12-08 2023-12-08 2 3 20.00 10.50 9.50 2
0 \N 0
-2023-12-09 2023-12-09 4 3 11.50 11.50 11.50 1
0 \N 0
-2023-12-10 2023-12-10 2 4 46.00 33.50 12.50 2
0 \N 0
-2023-12-11 2023-12-11 3 3 43.20 43.20 43.20 1
0 \N 0
-2023-12-12 2023-12-12 2 3 57.40 56.20 1.20 2
0 \N 0
+2023-12-08 2023-12-08 2 3 41.00 10.50 9.50 4
0 \N 0
+2023-12-09 2023-12-09 4 3 34.50 11.50 11.50 3
0 \N 0
+2023-12-10 2023-12-10 2 4 71.00 33.50 12.50 4
0 \N 0
+2023-12-11 2023-12-11 3 3 129.60 43.20 43.20 3
0 \N 0
+2023-12-12 2023-12-12 2 3 169.80 56.20 1.20 4
0 \N 0
-- !query20_1_after --
-2023-12-08 2023-12-08 2 3 20.00 10.50 9.50 2
0 \N 0
-2023-12-09 2023-12-09 4 3 11.50 11.50 11.50 1
0 \N 0
-2023-12-10 2023-12-10 2 4 46.00 33.50 12.50 2
0 \N 0
-2023-12-11 2023-12-11 3 3 43.20 43.20 43.20 1
0 \N 0
-2023-12-12 2023-12-12 2 3 57.40 56.20 1.20 2
0 \N 0
+2023-12-08 2023-12-08 2 3 41.00 10.50 9.50 4
0 \N 0
+2023-12-09 2023-12-09 4 3 34.50 11.50 11.50 3
0 \N 0
+2023-12-10 2023-12-10 2 4 71.00 33.50 12.50 4
0 \N 0
+2023-12-11 2023-12-11 3 3 129.60 43.20 43.20 3
0 \N 0
+2023-12-12 2023-12-12 2 3 169.80 56.20 1.20 4
0 \N 0
-- !query21_0_before --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
-2 3 2023-12-12 57.40 56.20 1.20 2 0
-2 4 2023-12-10 46.00 33.50 12.50 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
+2 3 2023-12-12 169.80 56.20 1.20 4 0
+2 4 2023-12-10 71.00 33.50 12.50 4 0
-- !query21_0_after --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
-2 3 2023-12-12 57.40 56.20 1.20 2 0
-2 4 2023-12-10 46.00 33.50 12.50 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
+2 3 2023-12-12 169.80 56.20 1.20 4 0
+2 4 2023-12-10 71.00 33.50 12.50 4 0
-- !query22_0_before --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
-2 3 2023-12-12 57.40 56.20 1.20 2 0
-2 4 2023-12-10 46.00 33.50 12.50 2 0
-3 3 2023-12-11 43.20 43.20 43.20 1 0
-4 3 2023-12-09 11.50 11.50 11.50 1 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
+2 3 2023-12-12 169.80 56.20 1.20 4 0
+2 4 2023-12-10 71.00 33.50 12.50 4 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
+4 3 2023-12-09 34.50 11.50 11.50 3 0
-- !query22_0_after --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
-2 3 2023-12-12 57.40 56.20 1.20 2 0
-2 4 2023-12-10 46.00 33.50 12.50 2 0
-3 3 2023-12-11 43.20 43.20 43.20 1 0
-4 3 2023-12-09 11.50 11.50 11.50 1 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
+2 3 2023-12-12 169.80 56.20 1.20 4 0
+2 4 2023-12-10 71.00 33.50 12.50 4 0
+3 3 2023-12-11 129.60 43.20 43.20 3 0
+4 3 2023-12-09 34.50 11.50 11.50 3 0
-- !query22_1_before --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
-2 3 2023-12-12 57.40 56.20 1.20 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
+2 3 2023-12-12 169.80 56.20 1.20 4 0
-- !query22_1_after --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
-2 3 2023-12-12 57.40 56.20 1.20 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
+2 3 2023-12-12 169.80 56.20 1.20 4 0
-- !query23_0_before --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
-- !query23_0_after --
-2 3 2023-12-08 20.00 10.50 9.50 2 0
+2 3 2023-12-08 41.00 10.50 9.50 4 0
-- !query24_0_before --
-3 2023-12-08 20.00 10.50 9.50 2 0
-3 2023-12-09 11.50 11.50 11.50 1 0
-3 2023-12-11 43.20 43.20 43.20 1 0
-3 2023-12-12 57.40 56.20 1.20 2 0
+3 2023-12-08 41.00 10.50 9.50 4 0
+3 2023-12-09 34.50 11.50 11.50 3 0
+3 2023-12-11 129.60 43.20 43.20 3 0
+3 2023-12-12 169.80 56.20 1.20 4 0
-- !query24_0_after --
-3 2023-12-08 20.00 10.50 9.50 2 0
-3 2023-12-09 11.50 11.50 11.50 1 0
-3 2023-12-11 43.20 43.20 43.20 1 0
-3 2023-12-12 57.40 56.20 1.20 2 0
+3 2023-12-08 41.00 10.50 9.50 4 0
+3 2023-12-09 34.50 11.50 11.50 3 0
+3 2023-12-11 129.60 43.20 43.20 3 0
+3 2023-12-12 169.80 56.20 1.20 4 0
-- !query25_0_before --
-2 3 2023-12-08 20.00 10.50 9.50 2
-2 3 2023-12-12 57.40 56.20 1.20 2
-2 4 2023-12-10 46.00 33.50 12.50 2
-3 3 2023-12-11 43.20 43.20 43.20 1
-4 3 2023-12-09 11.50 11.50 11.50 1
+2 3 2023-12-08 41.00 10.50 9.50 4
+2 3 2023-12-12 169.80 56.20 1.20 4
+2 4 2023-12-10 71.00 33.50 12.50 4
+3 3 2023-12-11 129.60 43.20 43.20 3
+4 3 2023-12-09 34.50 11.50 11.50 3
-- !query25_0_after --
-2 3 2023-12-08 20.00 10.50 9.50 2
-2 3 2023-12-12 57.40 56.20 1.20 2
-2 4 2023-12-10 46.00 33.50 12.50 2
-3 3 2023-12-11 43.20 43.20 43.20 1
-4 3 2023-12-09 11.50 11.50 11.50 1
+2 3 2023-12-08 41.00 10.50 9.50 4
+2 3 2023-12-12 169.80 56.20 1.20 4
+2 4 2023-12-10 71.00 33.50 12.50 4
+3 3 2023-12-11 129.60 43.20 43.20 3
+4 3 2023-12-09 34.50 11.50 11.50 3
-- !query25_1_before --
-2023-12-08 3 20.00 10.50 9.50 2 \N \N
-2023-12-09 3 11.50 11.50 11.50 1 \N \N
-2023-12-10 4 46.00 33.50 12.50 2 \N \N
-2023-12-11 3 43.20 43.20 43.20 1 \N \N
-2023-12-12 3 57.40 56.20 1.20 2 \N \N
+2023-12-08 3 41.00 10.50 9.50 4 \N \N
+2023-12-09 3 34.50 11.50 11.50 3 \N \N
+2023-12-10 4 71.00 33.50 12.50 4 \N \N
+2023-12-11 3 129.60 43.20 43.20 3 \N \N
+2023-12-12 3 169.80 56.20 1.20 4 \N \N
-- !query25_1_after --
-2023-12-08 3 20.00 10.50 9.50 2 \N \N
-2023-12-09 3 11.50 11.50 11.50 1 \N \N
-2023-12-10 4 46.00 33.50 12.50 2 \N \N
-2023-12-11 3 43.20 43.20 43.20 1 \N \N
-2023-12-12 3 57.40 56.20 1.20 2 \N \N
+2023-12-08 3 41.00 10.50 9.50 4 \N \N
+2023-12-09 3 34.50 11.50 11.50 3 \N \N
+2023-12-10 4 71.00 33.50 12.50 4 \N \N
+2023-12-11 3 129.60 43.20 43.20 3 \N \N
+2023-12-12 3 169.80 56.20 1.20 4 \N \N
-- !query25_2_before --
-2023-12-08 3 20.00 10.50 9.50 2 \N \N 1
0 0
-2023-12-09 3 11.50 11.50 11.50 1 \N \N 1
0 0
-2023-12-10 4 46.00 33.50 12.50 2 \N \N 1
0 0
-2023-12-11 3 43.20 43.20 43.20 1 \N \N 0
1 1
-2023-12-12 3 57.40 56.20 1.20 2 \N \N 0
1 1
+2023-12-08 3 41.00 10.50 9.50 4 \N \N 1
0 0
+2023-12-09 3 34.50 11.50 11.50 3 \N \N 1
0 0
+2023-12-10 4 71.00 33.50 12.50 4 \N \N 1
0 0
+2023-12-11 3 129.60 43.20 43.20 3 \N \N 0
1 1
+2023-12-12 3 169.80 56.20 1.20 4 \N \N 0
1 1
-- !query25_2_after --
-2023-12-08 3 20.00 10.50 9.50 2 \N \N 1
0 0
-2023-12-09 3 11.50 11.50 11.50 1 \N \N 1
0 0
-2023-12-10 4 46.00 33.50 12.50 2 \N \N 1
0 0
-2023-12-11 3 43.20 43.20 43.20 1 \N \N 0
1 1
-2023-12-12 3 57.40 56.20 1.20 2 \N \N 0
1 1
+2023-12-08 3 41.00 10.50 9.50 4 \N \N 1
0 0
+2023-12-09 3 34.50 11.50 11.50 3 \N \N 1
0 0
+2023-12-10 4 71.00 33.50 12.50 4 \N \N 1
0 0
+2023-12-11 3 129.60 43.20 43.20 3 \N \N 0
1 1
+2023-12-12 3 169.80 56.20 1.20 4 \N \N 0
1 1
-- !query25_3_before --
-2023-12-08 5 21.00 10.50 9.50 2 \N \N 1
0 1 0
-2023-12-09 7 11.50 11.50 11.50 1 \N \N 1
0 1 0
-2023-12-10 6 67.00 33.50 12.50 2 \N \N 1
0 1 0
-2023-12-11 6 43.20 43.20 43.20 1 \N \N 0
1 1 1
-2023-12-12 5 112.40 56.20 1.20 2 \N \N 0
1 1 1
+2023-12-08 5 42.00 10.50 9.50 4 \N \N 1
0 1 0
+2023-12-09 7 34.50 11.50 11.50 3 \N \N 1
0 1 0
+2023-12-10 6 92.00 33.50 12.50 4 \N \N 1
0 1 0
+2023-12-11 6 129.60 43.20 43.20 3 \N \N 0
1 1 1
+2023-12-12 5 224.80 56.20 1.20 4 \N \N 0
1 1 1
-- !query25_3_after --
-2023-12-08 5 21.00 10.50 9.50 2 \N \N 1
0 1 0
-2023-12-09 7 11.50 11.50 11.50 1 \N \N 1
0 1 0
-2023-12-10 6 67.00 33.50 12.50 2 \N \N 1
0 1 0
-2023-12-11 6 43.20 43.20 43.20 1 \N \N 0
1 1 1
-2023-12-12 5 112.40 56.20 1.20 2 \N \N 0
1 1 1
+2023-12-08 5 42.00 10.50 9.50 4 \N \N 1
0 1 0
+2023-12-09 7 34.50 11.50 11.50 3 \N \N 1
0 1 0
+2023-12-10 6 92.00 33.50 12.50 4 \N \N 1
0 1 0
+2023-12-11 6 129.60 43.20 43.20 3 \N \N 0
1 1 1
+2023-12-12 5 224.80 56.20 1.20 4 \N \N 0
1 1 1
-- !query25_4_before --
-2 3 2023-12-08 20.00 23.00
-2 3 2023-12-12 57.40 60.40
-2 4 2023-12-10 46.00 50.00
+2 3 2023-12-08 41.00 44.00
+2 3 2023-12-12 169.80 172.80
+2 4 2023-12-10 71.00 75.00
-- !query25_4_after --
-2 3 2023-12-08 20.00 23.00
-2 3 2023-12-12 57.40 60.40
-2 4 2023-12-10 46.00 50.00
+2 3 2023-12-08 41.00 44.00
+2 3 2023-12-12 169.80 172.80
+2 4 2023-12-10 71.00 75.00
-- !query25_5_before --
-2 3 2023-12-08 20.00 10.50 9.50 1 1 1
1 1 \N \N
-2 3 2023-12-12 57.40 56.20 1.20 1 1 1
1 1 \N \N
-2 4 2023-12-10 46.00 33.50 12.50 1 1 1
1 1 \N \N
-3 3 2023-12-11 43.20 43.20 43.20 1 1 1
1 1 \N \N
-4 3 2023-12-09 11.50 11.50 11.50 1 1 1
1 1 \N \N
+2 3 2023-12-08 41.00 10.50 9.50 1 1 1
1 1 \N \N
+2 3 2023-12-12 169.80 56.20 1.20 1 1 1
1 1 \N \N
+2 4 2023-12-10 71.00 33.50 12.50 1 1 1
1 1 \N \N
+3 3 2023-12-11 129.60 43.20 43.20 1 1 1
1 1 \N \N
+4 3 2023-12-09 34.50 11.50 11.50 1 1 1
1 1 \N \N
-- !query25_5_after --
-2 3 2023-12-08 20.00 10.50 9.50 1 1 1
1 1 \N \N
-2 3 2023-12-12 57.40 56.20 1.20 1 1 1
1 1 \N \N
-2 4 2023-12-10 46.00 33.50 12.50 1 1 1
1 1 \N \N
-3 3 2023-12-11 43.20 43.20 43.20 1 1 1
1 1 \N \N
-4 3 2023-12-09 11.50 11.50 11.50 1 1 1
1 1 \N \N
+2 3 2023-12-08 41.00 10.50 9.50 1 1 1
1 1 \N \N
+2 3 2023-12-12 169.80 56.20 1.20 1 1 1
1 1 \N \N
+2 4 2023-12-10 71.00 33.50 12.50 1 1 1
1 1 \N \N
+3 3 2023-12-11 129.60 43.20 43.20 1 1 1
1 1 \N \N
+4 3 2023-12-09 34.50 11.50 11.50 1 1 1
1 1 \N \N
-- !query25_6_before --
-2 3 2023-12-08 20.00 10.50 9.50 1 1 1
1 1 \N \N
-2 3 2023-12-12 57.40 56.20 1.20 0 0 0
0 0 \N \N
-2 4 2023-12-10 46.00 33.50 12.50 1 1 1
1 1 \N \N
-3 3 2023-12-11 43.20 43.20 43.20 0 0 0
0 0 \N \N
-4 3 2023-12-09 11.50 11.50 11.50 0 0 0
0 0 \N \N
+2 3 2023-12-08 41.00 10.50 9.50 1 1 1
1 1 \N \N
+2 3 2023-12-12 169.80 56.20 1.20 0 0 0
0 0 \N \N
+2 4 2023-12-10 71.00 33.50 12.50 1 1 1
1 1 \N \N
+3 3 2023-12-11 129.60 43.20 43.20 0 0 0
0 0 \N \N
+4 3 2023-12-09 34.50 11.50 11.50 0 0 0
0 0 \N \N
-- !query25_6_after --
-2 3 2023-12-08 20.00 10.50 9.50 1 1 1
1 1 \N \N
-2 3 2023-12-12 57.40 56.20 1.20 0 0 0
0 0 \N \N
-2 4 2023-12-10 46.00 33.50 12.50 1 1 1
1 1 \N \N
-3 3 2023-12-11 43.20 43.20 43.20 0 0 0
0 0 \N \N
-4 3 2023-12-09 11.50 11.50 11.50 0 0 0
0 0 \N \N
+2 3 2023-12-08 41.00 10.50 9.50 1 1 1
1 1 \N \N
+2 3 2023-12-12 169.80 56.20 1.20 0 0 0
0 0 \N \N
+2 4 2023-12-10 71.00 33.50 12.50 1 1 1
1 1 \N \N
+3 3 2023-12-11 129.60 43.20 43.20 0 0 0
0 0 \N \N
+4 3 2023-12-09 34.50 11.50 11.50 0 0 0
0 0 \N \N
-- !query1_1_before --
-1 yy 0 0 11.50 11.50 11.50 1
+1 yy 0 0 34.50 11.50 11.50 3
-- !query1_1_after --
-1 yy 0 0 11.50 11.50 11.50 1
+1 yy 0 0 34.50 11.50 11.50 3
-- !query2_0_before --
-2 mi 0 0 57.40 56.20 1.20 2
-2 mm 0 0 43.20 43.20 43.20 1
+2 mi 0 0 169.80 56.20 1.20 4
+2 mm 0 0 129.60 43.20 43.20 3
-- !query2_0_after --
-2 mi 0 0 57.40 56.20 1.20 2
-2 mm 0 0 43.20 43.20 43.20 1
+2 mi 0 0 169.80 56.20 1.20 4
+2 mm 0 0 129.60 43.20 43.20 3
-- !query26_0_before --
-2023-12-08 1 20.00 10.50 9.50 2 0 0
-2023-12-09 1 11.50 11.50 11.50 1 0 0
-2023-12-10 1 46.00 33.50 12.50 2 0 0
-2023-12-11 2 43.20 43.20 43.20 1 0 0
-2023-12-12 2 57.40 56.20 1.20 2 0 0
+2023-12-08 1 41.00 10.50 9.50 4 0 0
+2023-12-09 1 34.50 11.50 11.50 3 0 0
+2023-12-10 1 71.00 33.50 12.50 4 0 0
+2023-12-11 2 129.60 43.20 43.20 3 0 0
+2023-12-12 2 169.80 56.20 1.20 4 0 0
-- !query26_0_after --
-2023-12-08 1 20.00 10.50 9.50 2 0 0
-2023-12-09 1 11.50 11.50 11.50 1 0 0
-2023-12-10 1 46.00 33.50 12.50 2 0 0
-2023-12-11 2 43.20 43.20 43.20 1 0 0
-2023-12-12 2 57.40 56.20 1.20 2 0 0
+2023-12-08 1 41.00 10.50 9.50 4 0 0
+2023-12-09 1 34.50 11.50 11.50 3 0 0
+2023-12-10 1 71.00 33.50 12.50 4 0 0
+2023-12-11 2 129.60 43.20 43.20 3 0 0
+2023-12-12 2 169.80 56.20 1.20 4 0 0
-- !query27_0_before --
-2023-12-08 1 20.00 10.50 9.50 2 0 0
-2023-12-09 1 11.50 11.50 11.50 1 0 0
-2023-12-10 1 46.00 33.50 12.50 2 0 0
-2023-12-11 2 43.20 43.20 43.20 1 0 0
-2023-12-12 2 57.40 56.20 1.20 2 0 0
+2023-12-08 1 41.00 10.50 9.50 4 0 0
+2023-12-09 1 34.50 11.50 11.50 3 0 0
+2023-12-10 1 71.00 33.50 12.50 4 0 0
+2023-12-11 2 129.60 43.20 43.20 3 0 0
+2023-12-12 2 169.80 56.20 1.20 4 0 0
-- !query27_0_after --
-2023-12-08 1 20.00 10.50 9.50 2 0 0
-2023-12-09 1 11.50 11.50 11.50 1 0 0
-2023-12-10 1 46.00 33.50 12.50 2 0 0
-2023-12-11 2 43.20 43.20 43.20 1 0 0
-2023-12-12 2 57.40 56.20 1.20 2 0 0
+2023-12-08 1 41.00 10.50 9.50 4 0 0
+2023-12-09 1 34.50 11.50 11.50 3 0 0
+2023-12-10 1 71.00 33.50 12.50 4 0 0
+2023-12-11 2 129.60 43.20 43.20 3 0 0
+2023-12-12 2 169.80 56.20 1.20 4 0 0
-- !query28_0_before --
-2023-12-08 20.00
-2023-12-09 11.50
-2023-12-10 46.00
-2023-12-11 43.20
-2023-12-12 57.40
+2023-12-08 41.00
+2023-12-09 34.50
+2023-12-10 71.00
+2023-12-11 129.60
+2023-12-12 169.80
-- !query28_0_after --
-2023-12-08 20.00
-2023-12-09 11.50
-2023-12-10 46.00
-2023-12-11 43.20
-2023-12-12 57.40
+2023-12-08 41.00
+2023-12-09 34.50
+2023-12-10 71.00
+2023-12-11 129.60
+2023-12-12 169.80
-- !query29_0_before --
-8
+18
-- !query29_0_after --
-8
+18
-- !query29_1_before --
-0 178.10 1.20 8
+0 445.90 1.20 18
-- !query29_1_after --
-0 178.10 1.20 8
+0 445.90 1.20 18
-- !query29_2_before --
-0 1434.40 1.20
+0 8047.80 1.20
-- !query29_2_after --
-0 1434.40 1.20
+0 8047.80 1.20
-- !query30_0_before --
-4 4 68 100.0000 36.5000
-6 1 0 22.0000 57.2000
+4 4 148 100.0000 36.7500
+6 1 0 22.0000 70.9500
-- !query30_0_after --
-4 4 68 100.0000 36.5000
-6 1 0 22.0000 57.2000
+4 4 148 100.0000 36.7500
+6 1 0 22.0000 70.9500
-- !query31_0_before --
-2023-12-08 1 yy 1 \N 2
-2023-12-09 1 yy 2 2 2
-2023-12-10 1 yy 3 \N 2
-2023-12-11 2 mm 4 \N 1
-2023-12-12 2 mi 5 \N 2
+2023-12-08 1 yy 1 \N 4
+2023-12-09 1 yy 2 2 6
+2023-12-10 1 yy 3 \N 4
+2023-12-11 2 mm 4 \N 3
+2023-12-12 2 mi 5 \N 4
-- !query31_0_after --
-2023-12-08 1 yy 1 \N 2
-2023-12-09 1 yy 2 2 2
-2023-12-10 1 yy 3 \N 2
-2023-12-11 2 mm 4 \N 1
-2023-12-12 2 mi 5 \N 2
+2023-12-08 1 yy 1 \N 4
+2023-12-09 1 yy 2 2 6
+2023-12-10 1 yy 3 \N 4
+2023-12-11 2 mm 4 \N 3
+2023-12-12 2 mi 5 \N 4
-- !query32_0_before --
-2023-12-08 2
-2023-12-09 1
-2023-12-10 2
-2023-12-11 1
-2023-12-12 2
+2023-12-08 4
+2023-12-09 3
+2023-12-10 4
+2023-12-11 3
+2023-12-12 4
-- !query32_0_after --
-2023-12-08 2
-2023-12-09 1
-2023-12-10 2
-2023-12-11 1
-2023-12-12 2
+2023-12-08 4
+2023-12-09 3
+2023-12-10 4
+2023-12-11 3
+2023-12-12 4
+
+-- !query32_1_before --
+1
+1
+1
+1
+1
+
+-- !query32_1_after --
+1
+1
+1
+1
+1
+
+-- !query32_2_before --
+1
+1
+1
+1
+1
+
+-- !query32_2_after --
+1
+1
+1
+1
+1
-- !query33_0_before --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query33_0_after --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query33_1_before --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query33_1_after --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query35_0_before --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query35_0_after --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query36_0_before --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
-- !query36_0_after --
-o 3 9 o,o,o,o,o,o 4.666666666666667 mi 6
2
-o 4 2 o,o 4.0 yy 2 1
+o 3 21 o,o,o,o,o,o,o,o,o,o,o,o,o,o 4.571428571428571
mi 14 2
+o 4 4 o,o,o,o 4.0 yy 4 1
diff --git a/regression-test/data/nereids_rules_p0/mv/variant/variant_data.json
b/regression-test/data/nereids_rules_p0/mv/variant/variant_data.json
index 40ac0e9ece2..8c5ba6e094d 100644
--- a/regression-test/data/nereids_rules_p0/mv/variant/variant_data.json
+++ b/regression-test/data/nereids_rules_p0/mv/variant/variant_data.json
@@ -25,4 +25,19 @@
{"id":"25061821910","type":"PullRequestEvent","actor":{"id":49699333,"login":"dependabot[bot]","display_login":"dependabot","gravatar_id":"","url":"https://api.github.com/users/dependabot[bot]","avatar_url":"https://avatars.githubusercontent.com/u/49699333?"},"repo":{"id":530875030,"name":"girlsavenue/pancake-frontend","url":"https://api.github.com/repos/girlsavenue/pancake-frontend"},"payload":{"action":"opened","number":1,"pull_request":{"url":"https://api.github.com/repos/girlsavenue/
[...]
{"id":"25061821916","type":"PushEvent","actor":{"id":14532444,"login":"onirosd","display_login":"onirosd","gravatar_id":"","url":"https://api.github.com/users/onirosd","avatar_url":"https://avatars.githubusercontent.com/u/14532444?"},"repo":{"id":562681613,"name":"onirosd/appdirektor","url":"https://api.github.com/repos/onirosd/appdirektor"},"payload":{"push_id":11572649891,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"8182bbf8c643daedbd5ed9219cb7ab2d81ab2616","before":"54ae
[...]
{"id":"25061821923","type":"CreateEvent","actor":{"id":49699333,"login":"dependabot[bot]","display_login":"dependabot","gravatar_id":"","url":"https://api.github.com/users/dependabot[bot]","avatar_url":"https://avatars.githubusercontent.com/u/49699333?"},"repo":{"id":240446072,"name":"AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia","url":"https://api.github.com/repos/AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia"},"payload":{"ref":"dependabot/npm_and_yarn/minimatch-and-ion
[...]
+{"id":"25061821927","type":"PushEvent","actor":{"id":40018936,"login":"ramachandrasai7","display_login":"ramachandrasai7","gravatar_id":"","url":"https://api.github.com/users/ramachandrasai7","avatar_url":"https://avatars.githubusercontent.com/u/40018936?"},"repo":{"id":561944721,"name":"disha4u/CSE564-Assignment3","url":"https://api.github.com/repos/disha4u/CSE564-Assignment3"},"payload":{"push_id":11572649905,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"2d9fbe9df4f6312004
[...]
+{"id":"25061821817","type":"ForkEvent","actor":{"id":45201868,"login":"ZhxJia","display_login":"ZhxJia","gravatar_id":"","url":"https://api.github.com/users/ZhxJia","avatar_url":"https://avatars.githubusercontent.com/u/45201868?"},"repo":{"id":360530218,"name":"ethz-asl/sl_sensor","url":"https://api.github.com/repos/ethz-asl/sl_sensor"},"payload":{"forkee":{"id":562683981,"node_id":"R_kgDOIYngTQ","name":"sl_sensor","full_name":"ZhxJia/sl_sensor","private":false,"owner":{"login":"ZhxJia";,
[...]
+{"id":"25061821824","type":"CreateEvent","actor":{"id":110168274,"login":"itigoame","display_login":"itigoame","gravatar_id":"","url":"https://api.github.com/users/itigoame","avatar_url":"https://avatars.githubusercontent.com/u/110168274?"},"repo":{"id":562683980,"name":"itigoame/sample-AI","url":"https://api.github.com/repos/itigoame/sample-AI"},"payload":{"ref":null,"ref_type":"repository","master_branch":"main","description":null,"pusher_type":"user"},"public":true,"created_at":"2022-
[...]
+{"id":"25061821825","type":"PushEvent","actor":{"id":34259289,"login":"simonxin","display_login":"simonxin","gravatar_id":"","url":"https://api.github.com/users/simonxin","avatar_url":"https://avatars.githubusercontent.com/u/34259289?"},"repo":{"id":542899877,"name":"simonxin/aadtokens","url":"https://api.github.com/repos/simonxin/aadtokens"},"payload":{"push_id":11572649851,"size":3,"distinct_size":3,"ref":"refs/heads/main","head":"f17bde840e883424b52a04800dc689bf403ce179","before":"690
[...]
+{"id":"25061821843","type":"PushEvent","actor":{"id":73926367,"login":"armenfesliyan","display_login":"armenfesliyan","gravatar_id":"","url":"https://api.github.com/users/armenfesliyan","avatar_url":"https://avatars.githubusercontent.com/u/73926367?"},"repo":{"id":562670554,"name":"armenfesliyan/seatpsychology","url":"https://api.github.com/repos/armenfesliyan/seatpsychology"},"payload":{"push_id":11572649869,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"4173f304d660220cc1a6
[...]
+{"id":"25061821852","type":"PullRequestEvent","actor":{"id":98024358,"login":"jfrog-pipelie-intg","display_login":"jfrog-pipelie-intg","gravatar_id":"","url":"https://api.github.com/users/jfrog-pipelie-intg","avatar_url":"https://avatars.githubusercontent.com/u/98024358?"},"repo":{"id":562683829,"name":"jfrog-pipelie-intg/jfinte2e_1667789956723_16","url":"https://api.github.com/repos/jfrog-pipelie-intg/jfinte2e_1667789956723_16"},"payload":{"action":"opened","number":3,"pull_request":{"u
[...]
+{"id":"25061821874","type":"PushEvent","actor":{"id":97817672,"login":"alawrence30","display_login":"alawrence30","gravatar_id":"","url":"https://api.github.com/users/alawrence30","avatar_url":"https://avatars.githubusercontent.com/u/97817672?"},"repo":{"id":539737621,"name":"alawrence30/Deep-Learning","url":"https://api.github.com/repos/alawrence30/Deep-Learning"},"payload":{"push_id":11572649878,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"74cdba61e387b4ca52f9e2eeb2ef028d
[...]
+{"id":"25061821880","type":"PushEvent","actor":{"id":29478770,"login":"Tanimodori","display_login":"Tanimodori","gravatar_id":"","url":"https://api.github.com/users/Tanimodori","avatar_url":"https://avatars.githubusercontent.com/u/29478770?"},"repo":{"id":555947399,"name":"Tanimodori/viteburner-template","url":"https://api.github.com/repos/Tanimodori/viteburner-template"},"payload":{"push_id":11572649876,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"c78af6066de42b741a01db474
[...]
+{"id":"25061821893","type":"PullRequestReviewEvent","actor":{"id":108444335,"login":"filiphsps","display_login":"filiphsps","gravatar_id":"","url":"https://api.github.com/users/filiphsps","avatar_url":"https://avatars.githubusercontent.com/u/108444335?"},"repo":{"id":361369680,"name":"SerenityOS/discord-bot","url":"https://api.github.com/repos/SerenityOS/discord-bot"},"payload":{"action":"created","review":{"id":1169740146,"node_id":"PRR_kwDOFYoQUM5FuNFy","user":{"login":"filiphsps","id";
[...]
+{"id":"25061821900","type":"CreateEvent","actor":{"id":88118667,"login":"KidBourbon","display_login":"KidBourbon","gravatar_id":"","url":"https://api.github.com/users/KidBourbon","avatar_url":"https://avatars.githubusercontent.com/u/88118667?"},"repo":{"id":562683862,"name":"KidBourbon/bea-gift","url":"https://api.github.com/repos/KidBourbon/bea-gift"},"payload":{"ref":"main","ref_type":"branch","master_branch":"main","description":null,"pusher_type":"user"},"public":true,"created_at":"2
[...]
+{"id":"25061821904","type":"PushEvent","actor":{"id":41898282,"login":"github-actions[bot]","display_login":"github-actions","gravatar_id":"","url":"https://api.github.com/users/github-actions[bot]","avatar_url":"https://avatars.githubusercontent.com/u/41898282?"},"repo":{"id":510923468,"name":"felipelyra3/felipelyra3","url":"https://api.github.com/repos/felipelyra3/felipelyra3"},"payload":{"push_id":11572649892,"size":1,"distinct_size":1,"ref":"refs/heads/output","head":"5c2e11b7f4b60ad
[...]
+{"id":"25061821908","type":"PushEvent","actor":{"id":77421250,"login":"mikaelaslade","display_login":"mikaelaslade","gravatar_id":"","url":"https://api.github.com/users/mikaelaslade","avatar_url":"https://avatars.githubusercontent.com/u/77421250?"},"repo":{"id":340796783,"name":"mikaelaslade/LISportfolio","url":"https://api.github.com/repos/mikaelaslade/LISportfolio"},"payload":{"push_id":11572649889,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"6b3ae57fdc0d84ce460ad5f129852
[...]
+{"id":"25061821910","type":"PullRequestEvent","actor":{"id":49699333,"login":"dependabot[bot]","display_login":"dependabot","gravatar_id":"","url":"https://api.github.com/users/dependabot[bot]","avatar_url":"https://avatars.githubusercontent.com/u/49699333?"},"repo":{"id":530875030,"name":"girlsavenue/pancake-frontend","url":"https://api.github.com/repos/girlsavenue/pancake-frontend"},"payload":{"action":"opened","number":1,"pull_request":{"url":"https://api.github.com/repos/girlsavenue/
[...]
+{"id":"25061821916","type":"PushEvent","actor":{"id":14532444,"login":"onirosd","display_login":"onirosd","gravatar_id":"","url":"https://api.github.com/users/onirosd","avatar_url":"https://avatars.githubusercontent.com/u/14532444?"},"repo":{"id":562681613,"name":"onirosd/appdirektor","url":"https://api.github.com/repos/onirosd/appdirektor"},"payload":{"push_id":11572649891,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"8182bbf8c643daedbd5ed9219cb7ab2d81ab2616","before":"54ae
[...]
+{"id":"25061821923","type":"CreateEvent","actor":{"id":49699333,"login":"dependabot[bot]","display_login":"dependabot","gravatar_id":"","url":"https://api.github.com/users/dependabot[bot]","avatar_url":"https://avatars.githubusercontent.com/u/49699333?"},"repo":{"id":240446072,"name":"AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia","url":"https://api.github.com/repos/AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia"},"payload":{"ref":"dependabot/npm_and_yarn/minimatch-and-ion
[...]
{"id":"25061821927","type":"PushEvent","actor":{"id":40018936,"login":"ramachandrasai7","display_login":"ramachandrasai7","gravatar_id":"","url":"https://api.github.com/users/ramachandrasai7","avatar_url":"https://avatars.githubusercontent.com/u/40018936?"},"repo":{"id":561944721,"name":"disha4u/CSE564-Assignment3","url":"https://api.github.com/repos/disha4u/CSE564-Assignment3"},"payload":{"push_id":11572649905,"size":1,"distinct_size":1,"ref":"refs/heads/main","head":"2d9fbe9df4f6312004
[...]
\ No newline at end of file
diff --git a/regression-test/data/nereids_rules_p0/mv/variant/variant_mv.out
b/regression-test/data/nereids_rules_p0/mv/variant/variant_mv.out
index 42400ca6276..34b32db0da4 100644
--- a/regression-test/data/nereids_rules_p0/mv/variant/variant_mv.out
+++ b/regression-test/data/nereids_rules_p0/mv/variant/variant_mv.out
@@ -8,12 +8,19 @@
25061821803 CreateEvent 74837452 RodrigoNOliveira \N
25061821806 PushEvent 102448538 goodstudy2022327 \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
-- !query1_0_after --
25061821745 PushEvent 99616694 nahuel3223 \N
@@ -24,11 +31,18 @@
25061821803 CreateEvent 74837452 RodrigoNOliveira \N
25061821806 PushEvent 102448538 goodstudy2022327 \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
-- !query1_1_before --
@@ -46,20 +60,35 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
25061821880 PushEvent 29478870 Tanimodori \N
+25061821880 PushEvent 29478870 Tanimodori \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
25061821910 PullRequestEvent 49699433 dependabot
1112188324
25061821916 PushEvent 14532544 onirosd \N
+25061821916 PushEvent 14532544 onirosd \N
+25061821923 CreateEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query1_1_after --
25061821745 PushEvent 99616694 nahuel3223 \N
@@ -76,19 +105,34 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821825 PushEvent 34259389 simonxin \N
25061821825 PushEvent 34259389 simonxin \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821880 PushEvent 29478870 Tanimodori \N
25061821880 PushEvent 29478870 Tanimodori \N
25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821916 PushEvent 14532544 onirosd \N
25061821916 PushEvent 14532544 onirosd \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query1_2_before --
@@ -106,20 +150,35 @@
25061821810 PushEvent 41898382 \N
25061821814 PushEvent 41898382 \N
25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
+25061821824 CreateEvent 110168374 \N
25061821824 CreateEvent 110168374 \N
25061821825 PushEvent 34259389 \N
+25061821825 PushEvent 34259389 \N
+25061821843 PushEvent 73926467 \N
25061821843 PushEvent 73926467 \N
25061821852 PullRequestEvent 98024458 1112188326
+25061821852 PullRequestEvent 98024458 1112188326
+25061821874 PushEvent 97817772 \N
25061821874 PushEvent 97817772 \N
25061821880 PushEvent 29478870 \N
+25061821880 PushEvent 29478870 \N
+25061821893 PullRequestReviewEvent 108444435 1112140494
25061821893 PullRequestReviewEvent 108444435 1112140494
25061821900 CreateEvent 88118767 \N
+25061821900 CreateEvent 88118767 \N
+25061821904 PushEvent 41898382 \N
25061821904 PushEvent 41898382 \N
25061821908 PushEvent 77421350 \N
+25061821908 PushEvent 77421350 \N
+25061821910 PullRequestEvent 49699433 1112188324
25061821910 PullRequestEvent 49699433 1112188324
25061821916 PushEvent 14532544 \N
+25061821916 PushEvent 14532544 \N
+25061821923 CreateEvent 49699433 \N
25061821923 CreateEvent 49699433 \N
25061821927 PushEvent 40019036 \N
+25061821927 PushEvent 40019036 \N
-- !query1_2_after --
25061821745 PushEvent 99616694 \N
@@ -136,19 +195,34 @@
25061821810 PushEvent 41898382 \N
25061821814 PushEvent 41898382 \N
25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
25061821824 CreateEvent 110168374 \N
+25061821824 CreateEvent 110168374 \N
+25061821825 PushEvent 34259389 \N
25061821825 PushEvent 34259389 \N
25061821843 PushEvent 73926467 \N
+25061821843 PushEvent 73926467 \N
+25061821852 PullRequestEvent 98024458 1112188326
25061821852 PullRequestEvent 98024458 1112188326
25061821874 PushEvent 97817772 \N
+25061821874 PushEvent 97817772 \N
+25061821880 PushEvent 29478870 \N
25061821880 PushEvent 29478870 \N
25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821900 CreateEvent 88118767 \N
25061821900 CreateEvent 88118767 \N
25061821904 PushEvent 41898382 \N
+25061821904 PushEvent 41898382 \N
+25061821908 PushEvent 77421350 \N
25061821908 PushEvent 77421350 \N
25061821910 PullRequestEvent 49699433 1112188324
+25061821910 PullRequestEvent 49699433 1112188324
+25061821916 PushEvent 14532544 \N
25061821916 PushEvent 14532544 \N
25061821923 CreateEvent 49699433 \N
+25061821923 CreateEvent 49699433 \N
+25061821927 PushEvent 40019036 \N
25061821927 PushEvent 40019036 \N
-- !query1_3_before --
@@ -160,12 +234,19 @@
25061821803 CreateEvent 74837452 RodrigoNOliveira \N
25061821806 PushEvent 102448538 goodstudy2022327 \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
-- !query1_3_after --
25061821745 PushEvent 99616694 nahuel3223 \N
@@ -176,11 +257,18 @@
25061821803 CreateEvent 74837452 RodrigoNOliveira \N
25061821806 PushEvent 102448538 goodstudy2022327 \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
-- !query1_4_before --
@@ -192,12 +280,19 @@
25061821803 CreateEvent 74837452 RodrigoNOliveira \N
25061821806 PushEvent 102448538 goodstudy2022327 \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
-- !query1_4_after --
25061821745 PushEvent 99616694 nahuel3223 \N
@@ -208,11 +303,18 @@
25061821803 CreateEvent 74837452 RodrigoNOliveira \N
25061821806 PushEvent 102448538 goodstudy2022327 \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
-- !query2_0_before --
@@ -229,18 +331,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_0_after --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -256,18 +358,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_1_before --
25061821745 anmarinur/E-commerce-PF 1 99616694
@@ -283,18 +385,18 @@
25061821806 goodstudy2022327/personPic 1 102448538
25061821810 sebbourgeois/sebbourgeois 1 41898382
25061821814 rvaughan/weather-data 1 41898382
-25061821817 ethz-asl/sl_sensor 1 45201968
-25061821824 itigoame/sample-AI 1 110168374
-25061821843 armenfesliyan/seatpsychology 1 73926467
-25061821852 jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 alawrence30/Deep-Learning 1 97817772
-25061821893 SerenityOS/discord-bot 1 108444435
-25061821900 KidBourbon/bea-gift 1 88118767
-25061821904 felipelyra3/felipelyra3 1 41898382
-25061821908 mikaelaslade/LISportfolio 1 77421350
-25061821910 girlsavenue/pancake-frontend 1 49699433
-25061821923 AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1
49699433
-25061821927 disha4u/CSE564-Assignment3 1 40019036
+25061821817 ethz-asl/sl_sensor 2 45201968
+25061821824 itigoame/sample-AI 2 110168374
+25061821843 armenfesliyan/seatpsychology 2 73926467
+25061821852 jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 alawrence30/Deep-Learning 2 97817772
+25061821893 SerenityOS/discord-bot 2 108444435
+25061821900 KidBourbon/bea-gift 2 88118767
+25061821904 felipelyra3/felipelyra3 2 41898382
+25061821908 mikaelaslade/LISportfolio 2 77421350
+25061821910 girlsavenue/pancake-frontend 2 49699433
+25061821923 AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2
49699433
+25061821927 disha4u/CSE564-Assignment3 2 40019036
-- !query2_1_after --
25061821745 anmarinur/E-commerce-PF 1 99616694
@@ -310,18 +412,18 @@
25061821806 goodstudy2022327/personPic 1 102448538
25061821810 sebbourgeois/sebbourgeois 1 41898382
25061821814 rvaughan/weather-data 1 41898382
-25061821817 ethz-asl/sl_sensor 1 45201968
-25061821824 itigoame/sample-AI 1 110168374
-25061821843 armenfesliyan/seatpsychology 1 73926467
-25061821852 jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 alawrence30/Deep-Learning 1 97817772
-25061821893 SerenityOS/discord-bot 1 108444435
-25061821900 KidBourbon/bea-gift 1 88118767
-25061821904 felipelyra3/felipelyra3 1 41898382
-25061821908 mikaelaslade/LISportfolio 1 77421350
-25061821910 girlsavenue/pancake-frontend 1 49699433
-25061821923 AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1
49699433
-25061821927 disha4u/CSE564-Assignment3 1 40019036
+25061821817 ethz-asl/sl_sensor 2 45201968
+25061821824 itigoame/sample-AI 2 110168374
+25061821843 armenfesliyan/seatpsychology 2 73926467
+25061821852 jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 alawrence30/Deep-Learning 2 97817772
+25061821893 SerenityOS/discord-bot 2 108444435
+25061821900 KidBourbon/bea-gift 2 88118767
+25061821904 felipelyra3/felipelyra3 2 41898382
+25061821908 mikaelaslade/LISportfolio 2 77421350
+25061821910 girlsavenue/pancake-frontend 2 49699433
+25061821923 AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2
49699433
+25061821927 disha4u/CSE564-Assignment3 2 40019036
-- !query2_2_before --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -337,18 +439,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_2_after --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -364,18 +466,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_3_before --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -391,18 +493,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_3_after --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -418,18 +520,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_4_before --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -445,18 +547,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query2_4_after --
25061821745 PushEvent anmarinur/E-commerce-PF 1 99616694
@@ -472,18 +574,18 @@
25061821806 PushEvent goodstudy2022327/personPic 1
102448538
25061821810 PushEvent sebbourgeois/sebbourgeois 1 41898382
25061821814 PushEvent rvaughan/weather-data 1 41898382
-25061821817 ForkEvent ethz-asl/sl_sensor 1 45201968
-25061821824 CreateEvent itigoame/sample-AI 1 110168374
-25061821843 PushEvent armenfesliyan/seatpsychology 1 73926467
-25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 1 98024458
-25061821874 PushEvent alawrence30/Deep-Learning 1 97817772
-25061821893 PullRequestReviewEvent SerenityOS/discord-bot 1
108444435
-25061821900 CreateEvent KidBourbon/bea-gift 1 88118767
-25061821904 PushEvent felipelyra3/felipelyra3 1 41898382
-25061821908 PushEvent mikaelaslade/LISportfolio 1 77421350
-25061821910 PullRequestEvent girlsavenue/pancake-frontend 1
49699433
-25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 1 49699433
-25061821927 PushEvent disha4u/CSE564-Assignment3 1 40019036
+25061821817 ForkEvent ethz-asl/sl_sensor 2 45201968
+25061821824 CreateEvent itigoame/sample-AI 2 110168374
+25061821843 PushEvent armenfesliyan/seatpsychology 2 73926467
+25061821852 PullRequestEvent
jfrog-pipelie-intg/jfinte2e_1667789956723_16 2 98024458
+25061821874 PushEvent alawrence30/Deep-Learning 2 97817772
+25061821893 PullRequestReviewEvent SerenityOS/discord-bot 2
108444435
+25061821900 CreateEvent KidBourbon/bea-gift 2 88118767
+25061821904 PushEvent felipelyra3/felipelyra3 2 41898382
+25061821908 PushEvent mikaelaslade/LISportfolio 2 77421350
+25061821910 PullRequestEvent girlsavenue/pancake-frontend 2
49699433
+25061821923 CreateEvent
AdamariMosqueda/P05.Mosqueda-Espinoza-Adamari-Antonia 2 49699433
+25061821927 PushEvent disha4u/CSE564-Assignment3 2 40019036
-- !query3_0_before --
25061821745 PushEvent 99616694 nahuel3223 \N
@@ -500,16 +602,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_0_after --
@@ -527,16 +665,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_5_before --
@@ -554,16 +728,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_5_after --
@@ -581,16 +791,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_1_before --
@@ -608,19 +854,64 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
25061821843 PushEvent 73926467 armenfesliyan \N
-25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821880 PushEvent 29478870 Tanimodori \N
+25061821880 PushEvent 29478870 Tanimodori \N
+25061821880 PushEvent 29478870 Tanimodori \N
25061821880 PushEvent 29478870 Tanimodori \N
25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821916 PushEvent 14532544 onirosd \N
+25061821916 PushEvent 14532544 onirosd \N
+25061821916 PushEvent 14532544 onirosd \N
25061821916 PushEvent 14532544 onirosd \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_1_after --
@@ -638,20 +929,65 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
+25061821825 PushEvent 34259389 simonxin \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
1112188326
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
25061821880 PushEvent 29478870 Tanimodori \N
+25061821880 PushEvent 29478870 Tanimodori \N
+25061821880 PushEvent 29478870 Tanimodori \N
+25061821880 PushEvent 29478870 Tanimodori \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
+25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
25061821893 PullRequestReviewEvent 108444435 filiphsps
1112140494
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
+25061821910 PullRequestEvent 49699433 dependabot
1112188324
25061821910 PullRequestEvent 49699433 dependabot
1112188324
25061821916 PushEvent 14532544 onirosd \N
+25061821916 PushEvent 14532544 onirosd \N
+25061821916 PushEvent 14532544 onirosd \N
+25061821916 PushEvent 14532544 onirosd \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_2_before --
25061821745 PushEvent 99616694 \N
@@ -668,19 +1004,64 @@
25061821810 PushEvent 41898382 \N
25061821814 PushEvent 41898382 \N
25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
25061821824 CreateEvent 110168374 \N
+25061821824 CreateEvent 110168374 \N
+25061821824 CreateEvent 110168374 \N
+25061821824 CreateEvent 110168374 \N
+25061821825 PushEvent 34259389 \N
+25061821825 PushEvent 34259389 \N
+25061821825 PushEvent 34259389 \N
25061821825 PushEvent 34259389 \N
25061821843 PushEvent 73926467 \N
+25061821843 PushEvent 73926467 \N
+25061821843 PushEvent 73926467 \N
+25061821843 PushEvent 73926467 \N
+25061821852 PullRequestEvent 98024458 1112188326
+25061821852 PullRequestEvent 98024458 1112188326
+25061821852 PullRequestEvent 98024458 1112188326
25061821852 PullRequestEvent 98024458 1112188326
25061821874 PushEvent 97817772 \N
+25061821874 PushEvent 97817772 \N
+25061821874 PushEvent 97817772 \N
+25061821874 PushEvent 97817772 \N
+25061821880 PushEvent 29478870 \N
25061821880 PushEvent 29478870 \N
+25061821880 PushEvent 29478870 \N
+25061821880 PushEvent 29478870 \N
+25061821893 PullRequestReviewEvent 108444435 1112140494
25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821900 CreateEvent 88118767 \N
25061821900 CreateEvent 88118767 \N
+25061821900 CreateEvent 88118767 \N
+25061821900 CreateEvent 88118767 \N
+25061821904 PushEvent 41898382 \N
25061821904 PushEvent 41898382 \N
+25061821904 PushEvent 41898382 \N
+25061821904 PushEvent 41898382 \N
+25061821908 PushEvent 77421350 \N
25061821908 PushEvent 77421350 \N
+25061821908 PushEvent 77421350 \N
+25061821908 PushEvent 77421350 \N
+25061821910 PullRequestEvent 49699433 1112188324
25061821910 PullRequestEvent 49699433 1112188324
+25061821910 PullRequestEvent 49699433 1112188324
+25061821910 PullRequestEvent 49699433 1112188324
+25061821916 PushEvent 14532544 \N
25061821916 PushEvent 14532544 \N
+25061821916 PushEvent 14532544 \N
+25061821916 PushEvent 14532544 \N
+25061821923 CreateEvent 49699433 \N
25061821923 CreateEvent 49699433 \N
+25061821923 CreateEvent 49699433 \N
+25061821923 CreateEvent 49699433 \N
+25061821927 PushEvent 40019036 \N
+25061821927 PushEvent 40019036 \N
+25061821927 PushEvent 40019036 \N
25061821927 PushEvent 40019036 \N
-- !query3_2_after --
@@ -698,19 +1079,64 @@
25061821810 PushEvent 41898382 \N
25061821814 PushEvent 41898382 \N
25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
+25061821817 ForkEvent 45201968 \N
+25061821824 CreateEvent 110168374 \N
25061821824 CreateEvent 110168374 \N
+25061821824 CreateEvent 110168374 \N
+25061821824 CreateEvent 110168374 \N
+25061821825 PushEvent 34259389 \N
25061821825 PushEvent 34259389 \N
+25061821825 PushEvent 34259389 \N
+25061821825 PushEvent 34259389 \N
+25061821843 PushEvent 73926467 \N
25061821843 PushEvent 73926467 \N
+25061821843 PushEvent 73926467 \N
+25061821843 PushEvent 73926467 \N
+25061821852 PullRequestEvent 98024458 1112188326
25061821852 PullRequestEvent 98024458 1112188326
+25061821852 PullRequestEvent 98024458 1112188326
+25061821852 PullRequestEvent 98024458 1112188326
+25061821874 PushEvent 97817772 \N
25061821874 PushEvent 97817772 \N
+25061821874 PushEvent 97817772 \N
+25061821874 PushEvent 97817772 \N
+25061821880 PushEvent 29478870 \N
25061821880 PushEvent 29478870 \N
+25061821880 PushEvent 29478870 \N
+25061821880 PushEvent 29478870 \N
+25061821893 PullRequestReviewEvent 108444435 1112140494
25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821893 PullRequestReviewEvent 108444435 1112140494
+25061821900 CreateEvent 88118767 \N
25061821900 CreateEvent 88118767 \N
+25061821900 CreateEvent 88118767 \N
+25061821900 CreateEvent 88118767 \N
+25061821904 PushEvent 41898382 \N
25061821904 PushEvent 41898382 \N
+25061821904 PushEvent 41898382 \N
+25061821904 PushEvent 41898382 \N
+25061821908 PushEvent 77421350 \N
25061821908 PushEvent 77421350 \N
+25061821908 PushEvent 77421350 \N
+25061821908 PushEvent 77421350 \N
+25061821910 PullRequestEvent 49699433 1112188324
25061821910 PullRequestEvent 49699433 1112188324
+25061821910 PullRequestEvent 49699433 1112188324
+25061821910 PullRequestEvent 49699433 1112188324
+25061821916 PushEvent 14532544 \N
25061821916 PushEvent 14532544 \N
+25061821916 PushEvent 14532544 \N
+25061821916 PushEvent 14532544 \N
+25061821923 CreateEvent 49699433 \N
25061821923 CreateEvent 49699433 \N
+25061821923 CreateEvent 49699433 \N
+25061821923 CreateEvent 49699433 \N
+25061821927 PushEvent 40019036 \N
+25061821927 PushEvent 40019036 \N
+25061821927 PushEvent 40019036 \N
25061821927 PushEvent 40019036 \N
-- !query3_3_before --
@@ -728,16 +1154,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_3_after --
@@ -755,16 +1217,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_4_before --
@@ -782,16 +1280,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_4_after --
@@ -809,16 +1343,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
25061821874 PushEvent 97817772 alawrence30 \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_6_before --
@@ -836,16 +1406,52 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
-- !query3_6_after --
@@ -863,15 +1469,51 @@
25061821810 PushEvent 41898382 github-actions \N
25061821814 PushEvent 41898382 github-actions \N
25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821817 ForkEvent 45201968 ZhxJia \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
+25061821824 CreateEvent 110168374 itigoame \N
25061821824 CreateEvent 110168374 itigoame \N
25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821843 PushEvent 73926467 armenfesliyan \N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
+25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821852 PullRequestEvent 98024458 jfrog-pipelie-intg
\N
25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821874 PushEvent 97817772 alawrence30 \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
+25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821893 PullRequestReviewEvent 108444435 filiphsps \N
25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821900 CreateEvent 88118767 KidBourbon \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
+25061821904 PushEvent 41898382 github-actions \N
25061821904 PushEvent 41898382 github-actions \N
25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821908 PushEvent 77421350 mikaelaslade \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
+25061821910 PullRequestEvent 49699433 dependabot \N
25061821910 PullRequestEvent 49699433 dependabot \N
25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821923 CreateEvent 49699433 dependabot \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
+25061821927 PushEvent 40019036 ramachandrasai7 \N
25061821927 PushEvent 40019036 ramachandrasai7 \N
diff --git
a/regression-test/suites/nereids_rules_p0/mv/agg_on_none_agg/agg_on_none_agg.groovy
b/regression-test/suites/nereids_rules_p0/mv/agg_on_none_agg/agg_on_none_agg.groovy
index 59e0bff9f76..865e3f8f66e 100644
---
a/regression-test/suites/nereids_rules_p0/mv/agg_on_none_agg/agg_on_none_agg.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/agg_on_none_agg/agg_on_none_agg.groovy
@@ -133,28 +133,6 @@ suite("agg_on_none_agg") {
sql """analyze table lineitem with sync;"""
sql """analyze table partsupp with sync;"""
- def check_rewrite_but_not_chose = { mv_sql, query_sql, mv_name ->
-
- sql """DROP MATERIALIZED VIEW IF EXISTS ${mv_name}"""
- sql"""
- CREATE MATERIALIZED VIEW ${mv_name}
- BUILD IMMEDIATE REFRESH COMPLETE ON MANUAL
- DISTRIBUTED BY RANDOM BUCKETS 2
- PROPERTIES ('replication_num' = '1')
- AS ${mv_sql}
- """
-
- def job_name = getJobName(db, mv_name);
- waitingMTMVTaskFinished(job_name)
- explain {
- sql("${query_sql}")
- check {result ->
- def splitResult = result.split("MaterializedViewRewriteFail")
- splitResult.length == 2 ? splitResult[0].contains(mv_name) :
false
- }
- }
- }
-
// query used expression is in mv
def mv1_0 = """
select case when o_shippriority > 1 and o_orderkey IN (4, 5) then
o_custkey else o_shippriority end,
diff --git
a/regression-test/suites/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.groovy
b/regression-test/suites/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.groovy
index 285f429d0f7..f132aec4f36 100644
---
a/regression-test/suites/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/agg_optimize_when_uniform/agg_optimize_when_uniform.groovy
@@ -128,8 +128,11 @@ suite("agg_optimize_when_uniform") {
(2, 3, 9, 10.01, 'supply1'),
(2, 3, 10, 11.01, 'supply2');
"""
- sql """analyze table orders with sync"""
-
+
+ sql """analyze table lineitem with sync;"""
+ sql """analyze table orders with sync;"""
+ sql """analyze table partsupp with sync;"""
+
// single table
// filter cover all roll up dimensions and contains agg function in
mapping, combinator handler
def mv1_0 = """
diff --git
a/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
b/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
index a910be06ea6..c75fb5f6e9d 100644
---
a/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/agg_with_roll_up/aggregate_with_roll_up.groovy
@@ -114,10 +114,20 @@ suite("aggregate_with_roll_up") {
insert into orders values
(1, 1, 'o', 9.5, '2023-12-08', 'a', 'b', 1, 'yy'),
(1, 1, 'o', 10.5, '2023-12-08', 'a', 'b', 1, 'yy'),
+ (1, 1, 'o', 10.5, '2023-12-08', 'a', 'b', 1, 'yy'),
+ (1, 1, 'o', 10.5, '2023-12-08', 'a', 'b', 1, 'yy'),
+ (2, 1, 'o', 11.5, '2023-12-09', 'a', 'b', 1, 'yy'),
(2, 1, 'o', 11.5, '2023-12-09', 'a', 'b', 1, 'yy'),
+ (2, 1, 'o', 11.5, '2023-12-09', 'a', 'b', 1, 'yy'),
+ (3, 1, 'o', 12.5, '2023-12-10', 'a', 'b', 1, 'yy'),
+ (3, 1, 'o', 12.5, '2023-12-10', 'a', 'b', 1, 'yy'),
(3, 1, 'o', 12.5, '2023-12-10', 'a', 'b', 1, 'yy'),
(3, 1, 'o', 33.5, '2023-12-10', 'a', 'b', 1, 'yy'),
(4, 2, 'o', 43.2, '2023-12-11', 'c','d',2, 'mm'),
+ (4, 2, 'o', 43.2, '2023-12-11', 'c','d',2, 'mm'),
+ (4, 2, 'o', 43.2, '2023-12-11', 'c','d',2, 'mm'),
+ (5, 2, 'o', 56.2, '2023-12-12', 'c','d',2, 'mi'),
+ (5, 2, 'o', 56.2, '2023-12-12', 'c','d',2, 'mi'),
(5, 2, 'o', 56.2, '2023-12-12', 'c','d',2, 'mi'),
(5, 2, 'o', 1.2, '2023-12-12', 'c','d',2, 'mi');
"""
@@ -128,6 +138,10 @@ suite("aggregate_with_roll_up") {
(2, 3, 10, 11.01, 'supply2');
"""
+ sql """analyze table partsupp with sync"""
+ sql """analyze table lineitem with sync"""
+ sql """analyze table orders with sync"""
+
def check_rewrite_with_mv_partition = { mv_sql, query_sql, mv_name,
partition_column ->
sql """DROP MATERIALIZED VIEW IF EXISTS ${mv_name}"""
@@ -1330,7 +1344,7 @@ suite("aggregate_with_roll_up") {
order_qt_query31_0_after "${query31_0}"
sql """ DROP MATERIALIZED VIEW IF EXISTS mv31_0"""
- // should rewrite fail, because the part of query is join but mv is
aggregate
+ // should rewrite fail, because the group by dimension query used is not
in mv group by dimension
def mv32_0 = """
select
o_orderdate,
@@ -1355,6 +1369,41 @@ suite("aggregate_with_roll_up") {
order_qt_query32_0_after "${query32_0}"
sql """ DROP MATERIALIZED VIEW IF EXISTS mv32_0"""
+ // should rewrite fail, because the group by dimension query used is not
in mv group by dimension
+ def mv32_1 = """
+ select o_orderdate
+ from orders
+ group by o_orderdate;
+ """
+ def query32_1 = """
+ select
+ 1
+ from orders
+ group by
+ o_orderdate;
+ """
+ order_qt_query32_1_before "${query32_1}"
+ async_mv_rewrite_success(db, mv32_1, query32_1, "mv32_1")
+ order_qt_query32_1_after "${query32_1}"
+ sql """ DROP MATERIALIZED VIEW IF EXISTS mv32_1"""
+
+ def mv32_2 = """
+ select o_orderdate, o_orderkey
+ from orders
+ group by o_orderdate, o_orderkey;
+ """
+ def query32_2 = """
+ select
+ 1
+ from orders
+ group by
+ o_orderdate;
+ """
+ order_qt_query32_2_before "${query32_2}"
+ async_mv_rewrite_success(db, mv32_2, query32_2, "mv32_2")
+ order_qt_query32_2_after "${query32_2}"
+ sql """ DROP MATERIALIZED VIEW IF EXISTS mv32_2"""
+
// test combinator aggregate function rewrite
sql """set enable_agg_state=true"""
// query has no combinator and mv has combinator
diff --git
a/regression-test/suites/nereids_rules_p0/mv/grouping_sets/grouping_sets.groovy
b/regression-test/suites/nereids_rules_p0/mv/grouping_sets/grouping_sets.groovy
index 0e81d42eb4e..b7b1215e565 100644
---
a/regression-test/suites/nereids_rules_p0/mv/grouping_sets/grouping_sets.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/grouping_sets/grouping_sets.groovy
@@ -132,6 +132,10 @@ suite("materialized_view_grouping_sets") {
(2, 3, 10, 11.01, 'supply2');
"""
+ sql """analyze table lineitem with sync;"""
+ sql """analyze table orders with sync;"""
+ sql """analyze table partsupp with sync;"""
+
// query has group sets, and mv doesn't
// single table grouping sets without grouping scalar function
def mv1_0 =
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
index 51a01aa1333..60b649a8caf 100644
---
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_inner/inner_join_dphyp.groovy
@@ -121,6 +121,10 @@ suite("inner_join_dphyp") {
(2, 3, 10, 11.01, 'supply2');
"""
+ sql """analyze table lineitem with sync;"""
+ sql """analyze table orders with sync;"""
+ sql """analyze table partsupp with sync;"""
+
// without filter
def mv1_0 = "select lineitem.L_LINENUMBER, orders.O_CUSTKEY " +
"from lineitem " +
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
index b4dc24fb613..1e34ca299a3 100644
---
a/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/join/dphyp_outer/outer_join_dphyp.groovy
@@ -121,6 +121,10 @@ suite("outer_join_dphyp") {
(2, 3, 10, 11.01, 'supply2');
"""
+ sql """analyze table lineitem with sync;"""
+ sql """analyze table orders with sync;"""
+ sql """analyze table partsupp with sync;"""
+
// without filter
def mv1_0 = "select lineitem.L_LINENUMBER, orders.O_CUSTKEY " +
"from lineitem " +
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
index dc68a3169a7..6fdfe08ed2f 100644
--- a/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/join/inner/inner_join.groovy
@@ -120,6 +120,10 @@ suite("inner_join") {
(2, 3, 10, 11.01, 'supply2');
"""
+ sql """analyze table lineitem with sync;"""
+ sql """analyze table orders with sync;"""
+ sql """analyze table partsupp with sync;"""
+
// without filter
def mv1_0 =
"""
diff --git
a/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
b/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
index a55cac0e309..4ebb57b9338 100644
---
a/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/join/left_outer/outer_join.groovy
@@ -198,6 +198,10 @@ suite("outer_join") {
(2, 3, 10, 11.01, 'supply2');
"""
+ sql """analyze table lineitem with sync;"""
+ sql """analyze table orders with sync;"""
+ sql """analyze table partsupp with sync;"""
+
// without filter
def mv1_0 = "select lineitem.L_LINENUMBER, orders.O_CUSTKEY " +
"from lineitem " +
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
