You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by kx...@apache.org on 2023/10/12 14:53:32 UTC

[doris] 11/14: [test](fix) unstable case test_jdbc_query_mysql (#25279)

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

kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git

commit 0143ac59fe58453f3318b83ef1c9567c8040580b
Author: zhangguoqiang <18...@163.com>
AuthorDate: Thu Oct 12 16:56:38 2023 +0800

    [test](fix) unstable case test_jdbc_query_mysql (#25279)
---
 .../external_table_p0/jdbc/test_jdbc_query_mysql.out | 20 ++++++++++----------
 .../jdbc/test_jdbc_query_mysql.groovy                |  2 +-
 2 files changed, 11 insertions(+), 11 deletions(-)

diff --git a/regression-test/data/external_table_p0/jdbc/test_jdbc_query_mysql.out b/regression-test/data/external_table_p0/jdbc/test_jdbc_query_mysql.out
index be09c0a6a46..de2b898688f 100644
--- a/regression-test/data/external_table_p0/jdbc/test_jdbc_query_mysql.out
+++ b/regression-test/data/external_table_p0/jdbc/test_jdbc_query_mysql.out
@@ -1150,16 +1150,16 @@ true	521	1
 abc	\N
 
 -- !sql14 --
-\N	342
-0	136
-11	1
-13	1
-14	1
-16	1
-2	1
-4	1
-7	1
-8	1
+1007	1
+1009	1
+1012	1
+1013	1
+1016	1
+1018	1
+1019	1
+1021	1
+1022	1
+1024	1
 
 -- !sql15 --
 1025	1
diff --git a/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_mysql.groovy b/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_mysql.groovy
index 36fa0b0ced1..b06f14de4ee 100644
--- a/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_mysql.groovy
+++ b/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_mysql.groovy
@@ -728,7 +728,7 @@ suite("test_jdbc_query_mysql", "p0") {
         order_qt_sql13 """ SELECT k2, sum(CAST(NULL AS BIGINT)) FROM $jdbcMysql57Table1 GROUP BY k2 """
         order_qt_sql14 """ SELECT `key`, COUNT(*) as c FROM (
                             SELECT CASE WHEN k8 % 3 = 0 THEN NULL WHEN k8 % 5 = 0 THEN 0 ELSE k8 END AS `key`
-                            FROM $jdbcMysql57Table1) as a GROUP BY `key` order by c desc limit 10"""
+                            FROM $jdbcMysql57Table1) as a GROUP BY `key` order by `key` desc limit 10"""
         order_qt_sql15 """ SELECT lines, COUNT(*) as c FROM (SELECT k7, COUNT(*) lines FROM $jdbcMysql57Table1 GROUP BY k7) U GROUP BY lines order by c"""
         order_qt_sql16 """ SELECT COUNT(DISTINCT k8 + 1) FROM $jdbcMysql57Table1 """
         order_qt_sql17 """ SELECT COUNT(*) FROM (SELECT DISTINCT k8 + 1 FROM $jdbcMysql57Table1) t """


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