This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 45aeb1d40d [test](delete) Change delete case (#14483)
45aeb1d40d is described below
commit 45aeb1d40d5b2a1c38ea7837c5552ccea991e5c9
Author: yuanyuan8983 <[email protected]>
AuthorDate: Tue Nov 22 19:41:43 2022 +0800
[test](delete) Change delete case (#14483)
* kafka kerberos
* change delete where in case
---
.../suites/delete_p0/test_delete_where_in.groovy | 16 +++++++++-------
1 file changed, 9 insertions(+), 7 deletions(-)
diff --git a/regression-test/suites/delete_p0/test_delete_where_in.groovy
b/regression-test/suites/delete_p0/test_delete_where_in.groovy
index 77d27fa5cb..26fcd362f4 100644
--- a/regression-test/suites/delete_p0/test_delete_where_in.groovy
+++ b/regression-test/suites/delete_p0/test_delete_where_in.groovy
@@ -15,8 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_delete_where_in", "delete_p0") {
- def tb_name = "test_1"
-
+
+ def tb_name = "test_delete_where_in"
+
+ sql """DROP TABLE IF EXISTS ${tb_name};"""
// create table
sql """CREATE TABLE ${tb_name}(
`k1` INT(50) COMMENT '*****',
@@ -72,23 +74,23 @@ suite("test_delete_where_in", "delete_p0") {
//delete test
- def test_1 = sql """ DELETE FROM test_1 where k1 in
(1,3000,2500,900,13); """
+ sql """ DELETE FROM ${tb_name} where k1 in (1,3000,2500,900,13); """
def count_1= qt_sql """select count(*) from ${tb_name}"""
logger.info("delete_1 : ${count_1}")
- sql """ DELETE FROM test_1 where k1 < 10000 and k2
in('a','c','b','f');"""
+ sql """ DELETE FROM ${tb_name} where k1 < 10000 and k2
in('a','c','b','f');"""
def count_2= qt_sql """select count(*) from ${tb_name}"""
logger.info("delete_2 : ${count_2}")
- sql """ DELETE FROM test_1 where k5 > 100000 and k8 in
('a','b','d');"""
+ sql """ DELETE FROM ${tb_name} where k5 > 100000 and k8 in
('a','b','d');"""
def count_3= qt_sql """select count(*) from ${tb_name}"""
logger.info("delete_3 : ${count_3}")
- sql """ DELETE FROM test_1 where k1 > 80000 and k12 in
('a','b','d','e') and k2 in ('c','f','g');"""
+ sql """ DELETE FROM ${tb_name} where k1 > 80000 and k12 in
('a','b','d','e') and k2 in ('c','f','g');"""
def count_4= qt_sql """select count(*) from ${tb_name}"""
logger.info("delete_4 : ${count_4}")
- sql """ DELETE FROM test_1 where k5 >50000 and k1 < 80000;"""
+ sql """ DELETE FROM ${tb_name} where k5 >50000 and k1 < 80000;"""
def count_5= qt_sql """select count(*) from ${tb_name}"""
logger.info("delete_5 : ${count_5}")
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
