This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 7ac4df67ab [Fix](regression)Fix test_mysql_jdbc_catalog_nereids p2
test case (#22870)
7ac4df67ab is described below
commit 7ac4df67ab41f11c0cd7a56075f7a30a0e574770
Author: Jibing-Li <[email protected]>
AuthorDate: Fri Aug 11 17:57:48 2023 +0800
[Fix](regression)Fix test_mysql_jdbc_catalog_nereids p2 test case (#22870)
Fix test_mysql_jdbc_catalog_nereids p2 test case.
---
.../jdbc/test_mysql_jdbc_catalog_nereids.groovy | 12 ++++++++----
1 file changed, 8 insertions(+), 4 deletions(-)
diff --git
a/regression-test/suites/external_table_p0/jdbc/test_mysql_jdbc_catalog_nereids.groovy
b/regression-test/suites/external_table_p0/jdbc/test_mysql_jdbc_catalog_nereids.groovy
index 91d3075fe8..db189ec6bf 100644
---
a/regression-test/suites/external_table_p0/jdbc/test_mysql_jdbc_catalog_nereids.groovy
+++
b/regression-test/suites/external_table_p0/jdbc/test_mysql_jdbc_catalog_nereids.groovy
@@ -67,10 +67,10 @@ suite("test_mysql_jdbc_catalog_nereids",
"p0,external,mysql,external_docker,exte
"driver_url" = "${driver_url}",
"driver_class" = "com.mysql.cj.jdbc.Driver"
);"""
- sql """use ${internal_db_name}"""
- sql """ drop table if exists ${internal_db_name}.${inDorisTable} """
+ sql """use internal.${internal_db_name}"""
+ sql """ drop table if exists ${inDorisTable} """
sql """
- CREATE TABLE ${internal_db_name}.${inDorisTable} (
+ CREATE TABLE ${inDorisTable} (
`id` INT NULL COMMENT "主键id",
`name` string NULL COMMENT "名字"
) DISTRIBUTED BY HASH(id) BUCKETS 10
@@ -84,8 +84,12 @@ suite("test_mysql_jdbc_catalog_nereids",
"p0,external,mysql,external_docker,exte
qt_ex_tb0_where """select id from ${ex_tb0} where id = 111;"""
order_qt_ex_tb0 """ select id, name from ${ex_tb0} order by id; """
sql """ insert into internal.${internal_db_name}.${inDorisTable}
select id, name from ${ex_tb0}; """
- order_qt_in_tb """ select id, name from
internal.${internal_db_name}.${inDorisTable} order by id; """
+ // order_qt_in_tb """ select id, name from
${internal_db_name}.${inDorisTable} order by id; """
+ sql """switch internal;"""
+ order_qt_in_tb """ select id, name from
${internal_db_name}.${inDorisTable} order by id; """
+ sql """switch ${catalog_name}"""
+ sql """ use ${ex_db_name}"""
order_qt_ex_tb1 """ select * from ${ex_tb1} order by id; """
order_qt_ex_tb2 """ select * from ${ex_tb2} order by id; """
order_qt_ex_tb3 """ select * from ${ex_tb3} order by game_code; """
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
