This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 1f3ab4fd244bfe8b94b11f5c7957334547e084a6
Author: zy-kkk <zhongy...@gmail.com>
AuthorDate: Mon Apr 8 09:05:03 2024 +0800
[fix](jdbc catalog) fix db2 test connection sql (#33335)
---
.../java/org/apache/doris/datasource/jdbc/client/JdbcDB2Client.java | 4 ++++
.../suites/external_table_p0/jdbc/test_db2_jdbc_catalog.groovy | 2 +-
2 files changed, 5 insertions(+), 1 deletion(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/datasource/jdbc/client/JdbcDB2Client.java
b/fe/fe-core/src/main/java/org/apache/doris/datasource/jdbc/client/JdbcDB2Client.java
index fb22d3bd62d..af89f33eb9a 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/datasource/jdbc/client/JdbcDB2Client.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/datasource/jdbc/client/JdbcDB2Client.java
@@ -34,6 +34,10 @@ public class JdbcDB2Client extends JdbcClient {
super(jdbcClientConfig);
}
+ public String getTestQuery() {
+ return "select 1 from sysibm.sysdummy1";
+ }
+
@Override
public List<String> getDatabaseNameList() {
Connection conn = getConnection();
diff --git
a/regression-test/suites/external_table_p0/jdbc/test_db2_jdbc_catalog.groovy
b/regression-test/suites/external_table_p0/jdbc/test_db2_jdbc_catalog.groovy
index ddd812c7955..a7e7ecf764f 100644
--- a/regression-test/suites/external_table_p0/jdbc/test_db2_jdbc_catalog.groovy
+++ b/regression-test/suites/external_table_p0/jdbc/test_db2_jdbc_catalog.groovy
@@ -261,7 +261,7 @@ suite("test_db2_jdbc_catalog",
"p0,external,db2,external_docker,external_docker_
order_qt_desc_db "show databases from ${catalog_name};"
- order_qt_select_xml "select * from db2.TEST.BOOKS;"
+ order_qt_select_xml "select * from TEST.BOOKS;"
sql """ drop catalog if exists ${catalog_name} """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
