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 e90b78d783 [chore](regression) add case in test_delete (#20372)
e90b78d783 is described below
commit e90b78d783932f6dac78c0da252bf3c42bc4c6d4
Author: Jerry Hu <mrh...@gmail.com>
AuthorDate: Mon Jun 5 09:38:29 2023 +0800
[chore](regression) add case in test_delete (#20372)
Add some cases of deletion conditions with numeric values.
---
regression-test/data/delete_p0/test_delete.out | 41 ++++++++++++++++++++++
.../suites/delete_p0/test_delete.groovy | 41 ++++++++++++++++++++++
2 files changed, 82 insertions(+)
diff --git a/regression-test/data/delete_p0/test_delete.out
b/regression-test/data/delete_p0/test_delete.out
index a58fbf8a09..905fa5daf4 100644
--- a/regression-test/data/delete_p0/test_delete.out
+++ b/regression-test/data/delete_p0/test_delete.out
@@ -90,3 +90,44 @@ f' 8
3
abc 5
+-- !check_numeric --
+\N \N 6.6
+\N 4.45 4.4
+1 1.12 1.1
+2 2.23 2.2
+3 3.34 3.3
+5 \N 5.5
+
+-- !check_numeric --
+\N \N 6.6
+\N 4.45 4.4
+2 2.23 2.2
+3 3.34 3.3
+5 \N 5.5
+
+-- !check_numeric2 --
+\N \N 6.6
+\N 4.45 4.4
+3 3.34 3.3
+5 \N 5.5
+
+-- !check_numeric3 --
+\N \N 6.6
+\N 4.45 4.4
+3 3.34 3.3
+5 \N 5.5
+
+-- !check_numeric4 --
+\N \N 6.6
+\N 4.45 4.4
+5 \N 5.5
+
+-- !check_numeric4 --
+\N \N 6.6
+\N 4.45 4.4
+5 \N 5.5
+
+-- !check_numeric4 --
+\N \N 6.6
+5 \N 5.5
+
diff --git a/regression-test/suites/delete_p0/test_delete.groovy
b/regression-test/suites/delete_p0/test_delete.groovy
index c0eda6e787..bb78918d7d 100644
--- a/regression-test/suites/delete_p0/test_delete.groovy
+++ b/regression-test/suites/delete_p0/test_delete.groovy
@@ -177,4 +177,45 @@ suite("test_delete") {
qt_check_data6 """
select k1, v1 from delete_test_tb order by v1;
"""
+
+ sql """ DROP TABLE IF EXISTS delete_test_tb2 """
+ sql """
+ CREATE TABLE `delete_test_tb2` (
+ `k1` int NULL,
+ `k2` decimal(9, 2) NULL,
+ `v1` double NULL
+ )
+ UNIQUE KEY(`k1`, `k2`)
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 4
+ PROPERTIES
+ (
+ "replication_num" = "1"
+ );
+ """
+
+ sql """
+ insert into delete_test_tb2 values
+ (1, 1.12, 1.1), (2, 2.23, 2.2), (3, 3.34, 3.3), (null, 4.45, 4.4),
+ (5, null, 5.5), (null, null, 6.6);
+ """
+
+ qt_check_numeric """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
+
+ sql """ delete from delete_test_tb2 where k1 = 1; """
+ qt_check_numeric """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
+
+ sql """ delete from delete_test_tb2 where k2 = 2.23; """
+ qt_check_numeric2 """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
+
+ sql """ delete from delete_test_tb2 where k1 = 3 and k2 = 3.3; """
+ qt_check_numeric3 """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
+
+ sql """ delete from delete_test_tb2 where k1 = 3 and k2 = 3.34; """
+ qt_check_numeric4 """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
+
+ sql """ delete from delete_test_tb2 where k1 is not null and k2 = 4.45;
"""
+ qt_check_numeric4 """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
+
+ sql """ delete from delete_test_tb2 where k1 is null and k2 = 4.45; """
+ qt_check_numeric4 """ select k1, k2, v1 from delete_test_tb2 order by k1,
k2; """;
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
