[doris] branch branch-2.0 updated: [Fix](regression)fix test_doris_jdbc_catalog case 0829 (#23625)

[kxiao]

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


The following commit(s) were added to refs/heads/branch-2.0 by this push:
     new e4437fc4a0 [Fix](regression)fix test_doris_jdbc_catalog case 0829 
(#23625)
e4437fc4a0 is described below

commit e4437fc4a08096647d4316db2e038186ed971e78
Author: zhangguoqiang <18372634...@163.com>
AuthorDate: Thu Aug 31 11:23:19 2023 +0800

    [Fix](regression)fix test_doris_jdbc_catalog case 0829 (#23625)
---
 .../external_table_p0/jdbc/test_doris_jdbc_catalog.out     |  3 +--
 .../external_table_p0/jdbc/test_doris_jdbc_catalog.groovy  | 14 +++++++++-----
 2 files changed, 10 insertions(+), 7 deletions(-)

diff --git 
a/regression-test/data/external_table_p0/jdbc/test_doris_jdbc_catalog.out 
b/regression-test/data/external_table_p0/jdbc/test_doris_jdbc_catalog.out
index 4456a38d50..eea0d8f8fc 100644
--- a/regression-test/data/external_table_p0/jdbc/test_doris_jdbc_catalog.out
+++ b/regression-test/data/external_table_p0/jdbc/test_doris_jdbc_catalog.out
@@ -65,5 +65,4 @@ true  1       1       1       1       1       1.0     1.0     
1.00000 1.0000000000    2021-01-01      2021-01-01T00:00        a       a       
{"a"
 doris_jdbc_catalog
 
 -- !sql --
-internal
-
+internal
\ No newline at end of file
diff --git 
a/regression-test/suites/external_table_p0/jdbc/test_doris_jdbc_catalog.groovy 
b/regression-test/suites/external_table_p0/jdbc/test_doris_jdbc_catalog.groovy
index 154b4df2da..baf886edfd 100644
--- 
a/regression-test/suites/external_table_p0/jdbc/test_doris_jdbc_catalog.groovy
+++ 
b/regression-test/suites/external_table_p0/jdbc/test_doris_jdbc_catalog.groovy
@@ -15,7 +15,7 @@
 // specific language governing permissions and limitations
 // under the License.
 
-suite("test_doris_jdbc_catalog", "p0") {
+suite("test_doris_jdbc_catalog", 
"p0,external,doris,external_docker,external_docker_doris") {
     qt_sql """select current_catalog()"""
 
     String jdbcUrl = context.config.jdbcUrl + 
"&sessionVariables=return_object_data_as_binary=true"
@@ -24,6 +24,8 @@ suite("test_doris_jdbc_catalog", "p0") {
     String s3_endpoint = getS3Endpoint()
     String bucket = getS3BucketName()
     String driver_url = 
"https://${bucket}.${s3_endpoint}/regression/jdbc_driver/mysql-connector-java-8.0.25.jar";
+    String externalEnvIp = context.config.otherConfigs.get("externalEnvIp")
+
 
     String resource_name = "jdbc_resource_catalog_doris"
     String catalog_name = "doris_jdbc_catalog";
@@ -34,6 +36,8 @@ suite("test_doris_jdbc_catalog", "p0") {
     String base_table = "base";
     String arr_table = "arr";
 
+    sql """create database if not exists ${internal_db_name}; """
+
     qt_sql """select current_catalog()"""
     sql """drop catalog if exists ${catalog_name} """
 
@@ -45,10 +49,10 @@ suite("test_doris_jdbc_catalog", "p0") {
         "driver_url" = "${driver_url}",
         "driver_class" = "com.mysql.cj.jdbc.Driver"
         )"""
-
-    sql  """ drop table if exists ${inDorisTable} """
+    sql """use ${internal_db_name}"""
+    sql  """ drop table if exists ${internal_db_name}.${inDorisTable} """
     sql  """
-          CREATE TABLE ${inDorisTable} (
+          CREATE TABLE ${internal_db_name}.${inDorisTable} (
             `id` INT NULL COMMENT "主键id",
             `name` string NULL COMMENT "名字"
             ) DISTRIBUTED BY HASH(id) BUCKETS 10
@@ -174,4 +178,4 @@ suite("test_doris_jdbc_catalog", "p0") {
     sql """ drop table if exists ${base_table} """
     sql """ drop table if exists ${arr_table} """
 
-}
+}
\ No newline at end of file


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