This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 eeb8704b666 [fix](regression-test) add more check to address flaky
test_partial_update_with_delete_stmt (#26474)
eeb8704b666 is described below
commit eeb8704b6661a52d2f40e3a87612c5f3a5274bd1
Author: zhannngchen <[email protected]>
AuthorDate: Mon Nov 6 22:45:13 2023 +0800
[fix](regression-test) add more check to address flaky
test_partial_update_with_delete_stmt (#26474)
---
.../partial_update/test_partial_update_with_delete_stmt.out | 3 +++
.../partial_update/test_partial_update_with_delete_stmt.groovy | 10 +++++++++-
2 files changed, 12 insertions(+), 1 deletion(-)
diff --git
a/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.out
b/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.out
index e9ecbbb3f27..cd105da2043 100644
---
a/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.out
+++
b/regression-test/data/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.out
@@ -3,6 +3,9 @@
1 doris 1000 123 1
2 doris2 2000 223 1
+-- !select_before_delete --
+2
+
-- !select_join --
1 doris 1000 123 1
diff --git
a/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.groovy
b/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.groovy
index c9505e93e94..db33ec6fe46 100644
---
a/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.groovy
+++
b/regression-test/suites/unique_with_mow_p0/partial_update/test_partial_update_with_delete_stmt.groovy
@@ -126,10 +126,18 @@ suite("test_primary_key_partial_update_with_delete_stmt",
"p0") {
sql "sync"
- sql """
+ qt_select_before_delete """
+ select ${tableName}.id from ${tableName} inner join ${tableNameJoinA}
inner join ${tableNameJoinB} on ${tableNameJoinA}.id = ${tableNameJoinB}.id
+ and ${tableName}.id = ${tableNameJoinA}.id
+ """
+
+ def result3 = sql """
delete from ${tableName} using ${tableNameJoinA} inner join
${tableNameJoinB} on ${tableNameJoinA}.id = ${tableNameJoinB}.id
where ${tableName}.id = ${tableNameJoinA}.id
"""
+ assertTrue(result3.size() == 1)
+ assertTrue(result3[0].size() == 1)
+ assertTrue(result3[0][0] == 1, "Query OK, 1 row affected")
sql "sync"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
