This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 021982fc710 [fix](mtmv) Fix some pr to 21, prs are
(#39041)(#38958)(#39541) (#39678)
021982fc710 is described below
commit 021982fc71048a737270f7e7699969c0b1006b32
Author: seawinde <149132972+seawi...@users.noreply.github.com>
AuthorDate: Thu Aug 22 10:27:55 2024 +0800
[fix](mtmv) Fix some pr to 21, prs are (#39041)(#38958)(#39541) (#39678)
## Proposed changes
pr: https://github.com/apache/doris/pull/39041
commitId: 22562985
pr: https://github.com/apache/doris/pull/38958
commitId: c365cb64
pr: https://github.com/apache/doris/pull/39541
commitId: 89bb669c
---
.../main/java/org/apache/doris/catalog/MTMV.java | 4 +-
.../main/java/org/apache/doris/mtmv/MTMVCache.java | 13 +-
.../mv/AbstractMaterializedViewAggregateRule.java | 38 +-
.../mv/MaterializedViewFilterProjectScanRule.java | 13 +-
.../mv/MaterializedViewFilterScanRule.java | 7 +-
.../mv/MaterializedViewProjectFilterScanRule.java | 13 +-
.../mv/MaterializedViewProjectScanRule.java | 7 +-
.../trees/plans/visitor/TableCollector.java | 2 +-
.../mv/agg_with_roll_up/aggregate_with_roll_up.out | 476 +++++------
.../mv/external_table/single_external_table.out | 17 +
.../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_with_roll_up/aggregate_with_roll_up.groovy | 51 +-
.../mv/external_table/single_external_table.groovy | 116 +++
.../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 +
20 files changed, 1307 insertions(+), 391 deletions(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/MTMV.java
b/fe/fe-core/src/main/java/org/apache/doris/catalog/MTMV.java
index 1b4a8e7063e..3550ae131c1 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/MTMV.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/MTMV.java
@@ -190,7 +190,7 @@ public class MTMV extends OlapTable {
this.relation = relation;
if (!Env.isCheckpointThread()) {
try {
- this.cache = MTMVCache.from(this,
MTMVPlanUtil.createMTMVContext(this));
+ this.cache = MTMVCache.from(this,
MTMVPlanUtil.createMTMVContext(this), true);
} catch (Throwable e) {
this.cache = null;
LOG.warn("generate cache failed", e);
@@ -277,7 +277,7 @@ public class MTMV extends OlapTable {
writeMvLock();
try {
if (cache == null) {
- this.cache = MTMVCache.from(this, connectionContext);
+ this.cache = MTMVCache.from(this, connectionContext, true);
}
} finally {
writeMvUnlock();
diff --git a/fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVCache.java
b/fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVCache.java
index aceb453c2c3..56061c75b9c 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVCache.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVCache.java
@@ -79,7 +79,7 @@ public class MTMVCache {
return structInfo;
}
- public static MTMVCache from(MTMV mtmv, ConnectContext connectContext) {
+ public static MTMVCache from(MTMV mtmv, ConnectContext connectContext,
boolean needCost) {
LogicalPlan unboundMvPlan = new
NereidsParser().parseSingle(mtmv.getQuerySql());
StatementContext mvSqlStatementContext = new
StatementContext(connectContext,
new OriginStatement(mtmv.getQuerySql(), 0));
@@ -89,7 +89,13 @@ public class MTMVCache {
}
// Can not convert to table sink, because use the same column from
different table when self join
// the out slot is wrong
- planner.planWithLock(unboundMvPlan, PhysicalProperties.ANY,
ExplainLevel.ALL_PLAN);
+ if (needCost) {
+ // Only in mv rewrite, we need plan with eliminated cost which is
used for mv chosen
+ planner.planWithLock(unboundMvPlan, PhysicalProperties.ANY,
ExplainLevel.ALL_PLAN);
+ } else {
+ // No need cost for performance
+ planner.planWithLock(unboundMvPlan, PhysicalProperties.ANY,
ExplainLevel.REWRITTEN_PLAN);
+ }
Plan originPlan = planner.getCascadesContext().getRewritePlan();
// Eliminate result sink because sink operator is useless in query
rewrite by materialized view
// and the top sort can also be removed
@@ -111,7 +117,8 @@ public class MTMVCache {
Optional<StructInfo> structInfoOptional =
MaterializationContext.constructStructInfo(mvPlan, originPlan,
planner.getCascadesContext(),
new BitSet());
- return new MTMVCache(mvPlan, originPlan,
planner.getCascadesContext().getMemo().getRoot().getStatistics(),
+ return new MTMVCache(mvPlan, originPlan, needCost
+ ?
planner.getCascadesContext().getMemo().getRoot().getStatistics() : null,
structInfoOptional.orElseGet(() -> null));
}
}
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 6c1af050f07..4168d7f176c 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
@@ -214,7 +214,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;
@@ -263,6 +263,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
*/
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterProjectScanRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterProjectScanRule.java
index 7063030f24d..d72c54ffd84 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterProjectScanRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterProjectScanRule.java
@@ -19,8 +19,9 @@ package org.apache.doris.nereids.rules.exploration.mv;
import org.apache.doris.nereids.rules.Rule;
import org.apache.doris.nereids.rules.RuleType;
+import org.apache.doris.nereids.trees.plans.Plan;
+import org.apache.doris.nereids.trees.plans.logical.LogicalCatalogRelation;
import org.apache.doris.nereids.trees.plans.logical.LogicalFilter;
-import org.apache.doris.nereids.trees.plans.logical.LogicalOlapScan;
import org.apache.doris.nereids.trees.plans.logical.LogicalProject;
import com.google.common.collect.ImmutableList;
@@ -37,9 +38,11 @@ public class MaterializedViewFilterProjectScanRule extends
MaterializedViewScanR
@Override
public List<Rule> buildRules() {
return ImmutableList.of(
-
logicalFilter(logicalProject(logicalOlapScan())).thenApplyMultiNoThrow(ctx -> {
- LogicalFilter<LogicalProject<LogicalOlapScan>> root =
ctx.root;
- return rewrite(root, ctx.cascadesContext);
- }).toRule(RuleType.MATERIALIZED_VIEW_FILTER_PROJECT_SCAN));
+
logicalFilter(logicalProject(any().when(LogicalCatalogRelation.class::isInstance)))
+ .thenApplyMultiNoThrow(
+ ctx -> {
+ LogicalFilter<LogicalProject<Plan>> root =
ctx.root;
+ return rewrite(root, ctx.cascadesContext);
+
}).toRule(RuleType.MATERIALIZED_VIEW_FILTER_PROJECT_SCAN));
}
}
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterScanRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterScanRule.java
index 4cdde78ca4d..b967ffb6615 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterScanRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewFilterScanRule.java
@@ -19,8 +19,9 @@ package org.apache.doris.nereids.rules.exploration.mv;
import org.apache.doris.nereids.rules.Rule;
import org.apache.doris.nereids.rules.RuleType;
+import org.apache.doris.nereids.trees.plans.Plan;
+import org.apache.doris.nereids.trees.plans.logical.LogicalCatalogRelation;
import org.apache.doris.nereids.trees.plans.logical.LogicalFilter;
-import org.apache.doris.nereids.trees.plans.logical.LogicalOlapScan;
import com.google.common.collect.ImmutableList;
@@ -36,8 +37,8 @@ public class MaterializedViewFilterScanRule extends
MaterializedViewScanRule {
@Override
public List<Rule> buildRules() {
return ImmutableList.of(
- logicalFilter(logicalOlapScan()).thenApplyMultiNoThrow(ctx -> {
- LogicalFilter<LogicalOlapScan> root = ctx.root;
+
logicalFilter(any().when(LogicalCatalogRelation.class::isInstance)).thenApplyMultiNoThrow(ctx
-> {
+ LogicalFilter<Plan> root = ctx.root;
return rewrite(root, ctx.cascadesContext);
}).toRule(RuleType.MATERIALIZED_VIEW_FILTER_SCAN));
}
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectFilterScanRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectFilterScanRule.java
index 55f28b94904..abc2c353829 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectFilterScanRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectFilterScanRule.java
@@ -19,8 +19,9 @@ package org.apache.doris.nereids.rules.exploration.mv;
import org.apache.doris.nereids.rules.Rule;
import org.apache.doris.nereids.rules.RuleType;
+import org.apache.doris.nereids.trees.plans.Plan;
+import org.apache.doris.nereids.trees.plans.logical.LogicalCatalogRelation;
import org.apache.doris.nereids.trees.plans.logical.LogicalFilter;
-import org.apache.doris.nereids.trees.plans.logical.LogicalOlapScan;
import org.apache.doris.nereids.trees.plans.logical.LogicalProject;
import com.google.common.collect.ImmutableList;
@@ -37,9 +38,11 @@ public class MaterializedViewProjectFilterScanRule extends
MaterializedViewScanR
@Override
public List<Rule> buildRules() {
return ImmutableList.of(
-
logicalProject(logicalFilter(logicalOlapScan())).thenApplyMultiNoThrow(ctx -> {
- LogicalProject<LogicalFilter<LogicalOlapScan>> root =
ctx.root;
- return rewrite(root, ctx.cascadesContext);
- }).toRule(RuleType.MATERIALIZED_VIEW_PROJECT_FILTER_SCAN));
+
logicalProject(logicalFilter(any().when(LogicalCatalogRelation.class::isInstance)))
+ .thenApplyMultiNoThrow(
+ ctx -> {
+ LogicalProject<LogicalFilter<Plan>> root =
ctx.root;
+ return rewrite(root, ctx.cascadesContext);
+
}).toRule(RuleType.MATERIALIZED_VIEW_PROJECT_FILTER_SCAN));
}
}
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectScanRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectScanRule.java
index d73b31f2c7c..56f0cc4ec5a 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectScanRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/exploration/mv/MaterializedViewProjectScanRule.java
@@ -19,7 +19,8 @@ package org.apache.doris.nereids.rules.exploration.mv;
import org.apache.doris.nereids.rules.Rule;
import org.apache.doris.nereids.rules.RuleType;
-import org.apache.doris.nereids.trees.plans.logical.LogicalOlapScan;
+import org.apache.doris.nereids.trees.plans.Plan;
+import org.apache.doris.nereids.trees.plans.logical.LogicalCatalogRelation;
import org.apache.doris.nereids.trees.plans.logical.LogicalProject;
import com.google.common.collect.ImmutableList;
@@ -36,8 +37,8 @@ public class MaterializedViewProjectScanRule extends
MaterializedViewScanRule {
@Override
public List<Rule> buildRules() {
return ImmutableList.of(
- logicalProject(logicalOlapScan()).thenApplyMultiNoThrow(ctx ->
{
- LogicalProject<LogicalOlapScan> root = ctx.root;
+
logicalProject(any().when(LogicalCatalogRelation.class::isInstance)).thenApplyMultiNoThrow(ctx
-> {
+ LogicalProject<Plan> root = ctx.root;
return rewrite(root, ctx.cascadesContext);
}).toRule(RuleType.MATERIALIZED_VIEW_PROJECT_SCAN));
}
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/TableCollector.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/TableCollector.java
index 5ab6b7ef015..2e2cdb810f0 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/TableCollector.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/visitor/TableCollector.java
@@ -75,7 +75,7 @@ public class TableCollector extends DefaultPlanVisitor<Plan,
TableCollectorConte
}
// Make sure use only one connection context when in query to avoid
ConnectionContext.get() wrong
MTMVCache expandedMv = MTMVCache.from(mtmv,
context.getConnectContext() == null
- ? MTMVPlanUtil.createMTMVContext(mtmv) :
context.getConnectContext());
+ ? MTMVPlanUtil.createMTMVContext(mtmv) :
context.getConnectContext(), false);
expandedMv.getLogicalPlan().accept(this, context);
}
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/external_table/single_external_table.out
b/regression-test/data/nereids_rules_p0/mv/external_table/single_external_table.out
new file mode 100644
index 00000000000..5305ddb7e5c
--- /dev/null
+++
b/regression-test/data/nereids_rules_p0/mv/external_table/single_external_table.out
@@ -0,0 +1,17 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !query1_0_before --
+1
+2
+3
+
+-- !query1_0_after --
+1
+2
+3
+
+-- !query1_1_before --
+3
+
+-- !query1_1_after --
+3
+
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 2219354e417..9c1e5076d06 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_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 87c582f80c8..9e00a2ff52f 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}"""
@@ -1356,7 +1370,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,
@@ -1381,6 +1395,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}"
+ check_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}"
+ check_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/external_table/single_external_table.groovy
b/regression-test/suites/nereids_rules_p0/mv/external_table/single_external_table.groovy
new file mode 100644
index 00000000000..30f3fe64b3f
--- /dev/null
+++
b/regression-test/suites/nereids_rules_p0/mv/external_table/single_external_table.groovy
@@ -0,0 +1,116 @@
+package mv.external_table
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("single_external_table", "p0,external,hive") {
+ String enabled = context.config.otherConfigs.get("enableHiveTest")
+ if (enabled == null || !enabled.equalsIgnoreCase("true")) {
+ logger.info("diable Hive test. then doesn't test mv rewrite")
+ return;
+ }
+ // prepare catalog
+ def suite_name = "single_external_table";
+ def externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
+ def hms_port = context.config.otherConfigs.get("hive2HmsPort")
+ def hive_catalog_name = "${suite_name}_catalog"
+ def hive_database = "${suite_name}_db"
+ def hive_table = "${suite_name}_orders"
+
+ sql """drop catalog if exists ${hive_catalog_name}"""
+ sql """
+ create catalog if not exists ${hive_catalog_name} properties (
+ "type"="hms",
+ 'hive.metastore.uris' = 'thrift://${externalEnvIp}:${hms_port}'
+ );"""
+
+ sql """switch ${hive_catalog_name};"""
+ sql """drop table if exists
${hive_catalog_name}.${hive_database}.${hive_table}"""
+ sql """ drop database if exists ${hive_database}"""
+ sql """ create database ${hive_database}"""
+ sql """use ${hive_database}"""
+ sql """
+ CREATE TABLE IF NOT EXISTS ${hive_table} (
+ o_orderkey integer,
+ o_custkey integer,
+ o_orderstatus char(1),
+ o_totalprice decimalv3(15,2),
+ o_orderpriority char(15),
+ o_clerk char(15),
+ o_shippriority integer,
+ o_comment varchar(79),
+ o_orderdate date
+ ) ENGINE=hive
+ PARTITION BY list(o_orderdate)()
+ PROPERTIES (
+ "replication_num" = "1",
+ "file_format"="orc",
+ "compression"="zlib"
+ );
+ """
+
+ sql """insert into ${hive_catalog_name}.${hive_database}.${hive_table}
values(1, 1, 'ok', 99.5, 'a', 'b', 1, 'yy', '2023-10-17');"""
+ sql """insert into ${hive_catalog_name}.${hive_database}.${hive_table}
values(2, 2, 'ok', 109.2, 'c','d',2, 'mm', '2023-10-18');"""
+ sql """insert into ${hive_catalog_name}.${hive_database}.${hive_table}
values(3, 3, 'ok', 99.5, 'a', 'b', 1, 'yy', '2023-10-19');"""
+
+ // prepare table and data in olap
+ def internal_catalog = "internal"
+ def olap_db = context.config.getDbNameByFile(context.file)
+
+ sql """switch ${internal_catalog};"""
+ sql "use ${olap_db};"
+ sql "SET enable_nereids_planner=true;"
+ sql "set runtime_filter_mode=OFF";
+ sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject';"
+ sql "SET materialized_view_rewrite_enable_contain_external_table=true"
+
+
+ // single table without aggregate
+ def mv1_0 = """
+ select o_custkey, o_orderdate
+ from ${hive_catalog_name}.${hive_database}.${hive_table};
+ """
+ def query1_0 = """
+ select o_custkey
+ from ${hive_catalog_name}.${hive_database}.${hive_table};
+ """
+ order_qt_query1_0_before "${query1_0}"
+ check_mv_rewrite_success(olap_db, mv1_0, query1_0, "mv1_0")
+ order_qt_query1_0_after "${query1_0}"
+ sql """ DROP MATERIALIZED VIEW IF EXISTS mv1_0"""
+
+
+ // single table filter without aggregate
+ def mv1_1 = """
+ select o_custkey, o_orderdate
+ from ${hive_catalog_name}.${hive_database}.${hive_table}
+ where o_custkey > 1;
+ """
+ def query1_1 = """
+ select o_custkey
+ from ${hive_catalog_name}.${hive_database}.${hive_table}
+ where o_custkey > 2;
+ """
+ order_qt_query1_1_before "${query1_1}"
+ check_mv_rewrite_success(olap_db, mv1_1, query1_1, "mv1_1")
+ order_qt_query1_1_after "${query1_1}"
+ sql """ DROP MATERIALIZED VIEW IF EXISTS mv1_1"""
+
+
+ sql """drop table if exists
${hive_catalog_name}.${hive_database}.${hive_table}"""
+ sql """drop database if exists ${hive_catalog_name}.${hive_database}"""
+ sql """drop catalog if exists ${hive_catalog_name}"""
+}
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 73c30527990..00854e8abf8 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 75b5276e442..b5296068fc0 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 048d802e274..a9431c7fe59 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 6a990b67b72..fa5ae2399f8 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 68e323f1eb9..22998a537f9 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
