You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2022/05/30 01:01:30 UTC
[incubator-doris] branch master updated: [regression test]Add regression test case for multiple column delete. (#9817)
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/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 080c70f32d [regression test]Add regression test case for multiple column delete. (#9817)
080c70f32d is described below
commit 080c70f32df2959332899e3db428f4a977bdfa09
Author: smallhibiscus <84...@qq.com>
AuthorDate: Mon May 30 09:01:25 2022 +0800
[regression test]Add regression test case for multiple column delete. (#9817)
Co-authored-by: smallhibiscus <844981280>
---
.../data/delete/test_multi_columns_delete.out | 3 +++
.../suites/delete/test_multi_columns_delete.groovy | 29 ++++++++++++++++++++++
2 files changed, 32 insertions(+)
diff --git a/regression-test/data/delete/test_multi_columns_delete.out b/regression-test/data/delete/test_multi_columns_delete.out
new file mode 100644
index 0000000000..6284d99f09
--- /dev/null
+++ b/regression-test/data/delete/test_multi_columns_delete.out
@@ -0,0 +1,3 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !sql --
+1302 mus f sed_qui_aut
diff --git a/regression-test/suites/delete/test_multi_columns_delete.groovy b/regression-test/suites/delete/test_multi_columns_delete.groovy
new file mode 100644
index 0000000000..1c188d2632
--- /dev/null
+++ b/regression-test/suites/delete/test_multi_columns_delete.groovy
@@ -0,0 +1,29 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_multi_columns_delete", "delete") {
+ def tableName = "test_multi_columns_delete"
+
+ sql """ SET enable_vectorized_engine = TRUE; """
+ sql """ DROP TABLE IF EXISTS ${tableName}; """
+ sql """ CREATE TABLE ${tableName} ( id INT NULL COMMENT "",name VARCHAR(500) NULL COMMENT "",gender VARCHAR(500) NULL COMMENT "",remark VARCHAR(500) NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(id, name) DISTRIBUTED BY HASH(id, name) BUCKETS 4 PROPERTIES ( "replication_allocation" = "tag.location.default: 1","in_memory" = "false","storage_format" = "V2");"""
+
+ sql """ INSERT INTO ${tableName} VALUES (1125,'mus','f','xDavis'),(1338,'mos','f','kDiaz'),(1443,'mus','f','enim_unde_quae'),(1564,'mos','f','quasi'),(1745,'mus','m','sit_et_quidem'),(1898,'mos','m','est_sit'),(2256,'mus','f','SusanHolmes'),(2316,'mus','f','jSpencer'),(2448,'mus','f','impedit_exercitationem_nobis'),(2493,'mus','f','aut_id'),(2768,'mos','f','dolor_neque'),(2813,'mos','f','SeanHill'),(2834,'mus','f','xMorrison'),(2894,'mos','m','incidunt'),(2933,'mos','m','CharlesFishe [...]
+ sql """ DELETE FROM ${tableName} WHERE name = 'mos' AND gender = 'm'; """
+
+ qt_sql """SELECT * FROM ${tableName} WHERE name = 'mus' AND id = 1302;"""
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org