This is an automated email from the ASF dual-hosted git repository.
morningman 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 705f9c22f0c [2.1][fix](test) fix test_jdbc_query_mysql sql87 (#41433)
705f9c22f0c is described below
commit 705f9c22f0c4bf09c8e65e584293392f34fbd183
Author: zy-kkk <zhongy...@gmail.com>
AuthorDate: Fri Sep 27 23:46:17 2024 +0800
[2.1][fix](test) fix test_jdbc_query_mysql sql87 (#41433)
pick (#41158)
---
.../suites/external_table_p0/jdbc/test_jdbc_query_mysql.groovy | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
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 eee9e50d65d..1ba4afc52cc 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
@@ -887,7 +887,7 @@ suite("test_jdbc_query_mysql",
"p0,external,mysql,external_docker,external_docke
order_qt_sql84 """ SELECT NULL, NULL INTERSECT SELECT NULL, NULL FROM
$jdbcMysql57Table1 """
order_qt_sql85 """ SELECT COUNT(*) FROM $jdbcMysql57Table1 INTERSECT
SELECT COUNT(k8) FROM $jdbcMysql57Table1 HAVING SUM(k7) IS NOT NULL """
order_qt_sql86 """ SELECT k8 FROM $jdbcMysql57Table1 WHERE k8 < 7
EXCEPT SELECT k8 FROM $jdbcMysql57Table1 WHERE k8 > 21 """
- order_qt_sql87 """ SELECT row_number() OVER (PARTITION BY k7) rn, k8
FROM $jdbcMysql57Table1 LIMIT 3 """
+ order_qt_sql87 """ SELECT row_number() OVER (PARTITION BY k7 ORDER BY
k8) rn, k8 FROM $jdbcMysql57Table1 LIMIT 3 """
order_qt_sql88 """ SELECT row_number() OVER (PARTITION BY k7 ORDER BY
k8) rn FROM $jdbcMysql57Table1 LIMIT 3 """
order_qt_sql89 """ SELECT row_number() OVER (ORDER BY k8) rn FROM
$jdbcMysql57Table1 LIMIT 3 """
order_qt_sql90 """ SELECT row_number() OVER () FROM $jdbcMysql57Table1
as a JOIN ${exMysqlTable} as b ON a.k8 = b.id WHERE a.k8 > 111 LIMIT 2 """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
