This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 58adcc2ef33 branch-3.0: [test](jdbc table) fix jdbc table view test
#48236 (#48275)
58adcc2ef33 is described below
commit 58adcc2ef3312d92e2c98b4410900921cf02383c
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Feb 28 09:57:09 2025 +0800
branch-3.0: [test](jdbc table) fix jdbc table view test #48236 (#48275)
Cherry-picked from #48236
Co-authored-by: zy-kkk <zhongy...@gmail.com>
---
.../suites/external_table_p0/jdbc/test_jdbc_query_mysql.groovy | 5 +++--
.../suites/external_table_p0/jdbc/test_jdbc_query_pg.groovy | 5 +++--
2 files changed, 6 insertions(+), 4 deletions(-)
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 1ba4afc52cc..4a32e2e206a 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
@@ -785,8 +785,9 @@ suite("test_jdbc_query_mysql",
"p0,external,mysql,external_docker,external_docke
// test for distribute queries
order_qt_sql38 """ SELECT count(*) FROM ${exMysqlTable} WHERE id IN
(SELECT k8 FROM $jdbcMysql57Table1 WHERE k8 > 111); """
- sql """ create view if not exists aview as select k7, k8 from
$jdbcMysql57Table1; """
- order_qt_sql39 """ SELECT * FROM aview a JOIN aview b on a.k8 = b.k8
order by a.k8 desc limit 5 """
+ sql """ drop view if exists aview_mysql """
+ sql """ create view if not exists aview_mysql as select k7, k8 from
$jdbcMysql57Table1; """
+ order_qt_sql39 """ SELECT * FROM aview_mysql a JOIN aview_mysql b on
a.k8 = b.k8 order by a.k8 desc limit 5 """
order_qt_sql42 """ SELECT * FROM (SELECT * FROM $jdbcMysql57Table1
WHERE k8 % 8 = 0) l JOIN ${exMysqlTable} o ON l.k8 = o.id """
order_qt_sql43 """ SELECT * FROM (SELECT * FROM $jdbcMysql57Table1
WHERE k8 % 8 = 0) l LEFT JOIN ${exMysqlTable} o ON l.k8 = o.id order by k8
limit 5"""
order_qt_sql44 """ SELECT * FROM (SELECT * FROM $jdbcMysql57Table1
WHERE k8 % 8 = 0) l RIGHT JOIN ${exMysqlTable} o ON l.k8 = o.id"""
diff --git
a/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_pg.groovy
b/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_pg.groovy
index 623bd6e8932..80c368b7627 100644
--- a/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_pg.groovy
+++ b/regression-test/suites/external_table_p0/jdbc/test_jdbc_query_pg.groovy
@@ -489,8 +489,9 @@ suite("test_jdbc_query_pg",
"p0,external,pg,external_docker,external_docker_pg")
);
"""
order_qt_sql38 """ SELECT count(*) FROM ${dorisExTable1} WHERE id IN
(SELECT k8 FROM $jdbcPg14Table1 WHERE k8 > 111); """
- sql """ create view if not exists aview as select k7, k8 from
$jdbcPg14Table1; """
- order_qt_sql39 """ SELECT * FROM aview a JOIN aview b on a.k8 = b.k8
order by a.k8 desc limit 5 """
+ sql """ drop view if exists aview_pg """
+ sql """ create view if not exists aview_pg as select k7, k8 from
$jdbcPg14Table1; """
+ order_qt_sql39 """ SELECT * FROM aview_pg a JOIN aview_pg b on a.k8 =
b.k8 order by a.k8 desc limit 5 """
order_qt_sql42 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l JOIN ${dorisExTable1} o ON l.k8 = o.id """
order_qt_sql43 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l LEFT JOIN ${dorisExTable1} o ON l.k8 = o.id order by k8 limit 5"""
order_qt_sql44 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l RIGHT JOIN ${dorisExTable1} o ON l.k8 = o.id"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
