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