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