This is an automated email from the ASF dual-hosted git repository.

morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 9b0978fad9 [fix](test) make output of test stable (#13317)
9b0978fad9 is described below

commit 9b0978fad98fc9ca346de3a971fd5d75e8a40576
Author: Yongqiang YANG <98214048+dataroar...@users.noreply.github.com>
AuthorDate: Thu Oct 13 09:07:59 2022 +0800

    [fix](test) make output of test stable (#13317)
---
 .../data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out | 4 ++--
 .../sql/repositoriesWithTheMaximumAmountOfIssues1.out                 | 2 +-
 .../sql/repositoriesWithTheMaximumAmountOfIssues2.out                 | 2 +-
 .../suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql  | 2 +-
 .../github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql      | 2 +-
 .../sql/repositoriesWithTheMaximumAmountOfIssues1.sql                 | 2 +-
 .../sql/repositoriesWithTheMaximumAmountOfIssues2.sql                 | 2 +-
 regression-test/suites/query_p0/cache/partition_cache.groovy          | 3 +++
 8 files changed, 11 insertions(+), 8 deletions(-)

diff --git 
a/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
 
b/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
index c53bf0d0d7..6a6c7448ee 100644
--- 
a/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
+++ 
b/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
@@ -31,8 +31,8 @@ denoland/deno 31550   12833   2.459   2018-08-03T00:26:45
 GitSquared/edex-ui     14151   5797    2.441   2017-10-14T15:55:21
 MathewSachin/Captura   3392    1392    2.437   2015-09-12T12:31:42
 Aircoookie/WLED        2767    1141    2.425   2017-12-17T08:36:13
-tiangolo/fastapi       17962   7474    2.403   2018-12-08T10:05:29
 edent/SuperTinyIcons   3747    1559    2.403   2017-11-12T01:57:38
+tiangolo/fastapi       17962   7474    2.403   2018-12-08T10:05:29
 remoteintech/remote-jobs       6819    2858    2.386   2017-09-09T13:12:05
 retejs/rete    2541    1075    2.364   2018-05-31T03:06:05
 Anuken/Mindustry       5439    2322    2.342   2017-05-12T17:52:31
@@ -40,8 +40,8 @@ Dreamacro/clash       8836    3850    2.295   
2018-06-10T14:41:49
 debauchee/barrier      5731    2505    2.288   2018-02-23T12:36:21
 ryansolid/solid        3249    1433    2.267   2018-05-26T14:28:51
 wilsonfreitas/awesome-quant    2362    1053    2.243   2016-05-10T10:19:52
-TheAlgorithms/Go       2905    1299    2.236   2017-07-11T04:34:48
 JanDeDobbeleer/oh-my-posh      2748    1229    2.236   2018-04-12T04:42:01
+TheAlgorithms/Go       2905    1299    2.236   2017-07-11T04:34:48
 The-Art-of-Hacking/h4cker      5791    2622    2.209   2018-10-06T12:02:56
 TheCherno/Hazel        2852    1292    2.207   2018-10-20T04:01:11
 FreeCAD/FreeCAD        3897    1777    2.193   2015-07-04T23:06:13
diff --git 
a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
 
b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
index 1b8be962ee..ad456c590e 100644
--- 
a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
+++ 
b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
@@ -48,6 +48,6 @@ cockroachdb/cockroach 28390   1049
 tensorflow/tensorflow  28380   16377
 Zhycrin/Time   28104   1
 rust-lang/rust 28036   6283
-ikedaosushi/tech-news  27774   6
 ansible/ansible        27774   13050
+ikedaosushi/tech-news  27774   6
 
diff --git 
a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
 
b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
index 248c4d75f1..a3819848b8 100644
--- 
a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
+++ 
b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
@@ -48,6 +48,6 @@ cockroachdb/cockroach 28390   1049    21147
 tensorflow/tensorflow  28380   16377   173681
 Zhycrin/Time   28104   1       1
 rust-lang/rust 28036   6283    53027
-ikedaosushi/tech-news  27774   6       15
 ansible/ansible        27774   13050   51144
+ikedaosushi/tech-news  27774   6       15
 
diff --git 
a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
 
b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
index 6d446ebf0a..090664f778 100644
--- 
a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
+++ 
b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
@@ -14,5 +14,5 @@ FROM
 ) t
 GROUP BY repo_name
 HAVING (stars > 100) AND (forks > 100)
-ORDER BY ratio DESC
+ORDER BY ratio DESC, repo_name
 LIMIT 50
diff --git 
a/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
 
b/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
index ccc2e30173..40c25b9528 100644
--- 
a/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
+++ 
b/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
@@ -16,5 +16,5 @@ FROM
 ) t
 GROUP BY repo_name
 HAVING (min(created_at) <= '2019-01-01 00:00:00') AND (stars2019 >= 1000)
-ORDER BY yoy DESC
+ORDER BY yoy DESC, repo_name
 LIMIT 50
diff --git 
a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
 
b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
index 9e3ebb3400..68c4426bfd 100644
--- 
a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
+++ 
b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
@@ -1 +1 @@
-SELECT repo_name, count() AS c, count(distinct actor_login) AS u FROM 
github_events WHERE event_type = 'IssuesEvent' AND action = 'opened' GROUP BY 
repo_name ORDER BY c DESC LIMIT 50
+SELECT repo_name, count() AS c, count(distinct actor_login) AS u FROM 
github_events WHERE event_type = 'IssuesEvent' AND action = 'opened' GROUP BY 
repo_name ORDER BY c DESC, repo_name LIMIT 50
diff --git 
a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
 
b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
index 3acf5de133..87869583ce 100644
--- 
a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
+++ 
b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
@@ -14,5 +14,5 @@ FROM
     WHERE event_type IN ('IssuesEvent', 'WatchEvent')
 ) t
 GROUP BY repo_name
-ORDER BY c DESC
+ORDER BY c DESC, repo_name
 LIMIT 50
diff --git a/regression-test/suites/query_p0/cache/partition_cache.groovy 
b/regression-test/suites/query_p0/cache/partition_cache.groovy
index 5f5dc3ffd8..435949fd27 100644
--- a/regression-test/suites/query_p0/cache/partition_cache.groovy
+++ b/regression-test/suites/query_p0/cache/partition_cache.groovy
@@ -40,6 +40,9 @@ suite("partition_cache") {
             "storage_format" = "V2"
             )
         """
+
+    sql "sync"
+
     sql """ INSERT INTO ${tableName} VALUES 
                     ("2022-05-27",0),
                     ("2022-05-28",0),


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to