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 e55d343430d [Fix](auto-inc) Fix partial update auto inc unique table
case failure #32114
e55d343430d is described below
commit e55d343430d597e08ee1463a8a9a585368d16c72
Author: abmdocrt <yukang.lian2...@gmail.com>
AuthorDate: Tue Mar 12 21:50:51 2024 +0800
[Fix](auto-inc) Fix partial update auto inc unique table case failure
#32114
---
.../unique/test_unique_table_auto_inc.out | 22 ++++++++++++----------
.../unique/test_unique_table_auto_inc.groovy | 3 ++-
2 files changed, 14 insertions(+), 11 deletions(-)
diff --git
a/regression-test/data/data_model_p0/unique/test_unique_table_auto_inc.out
b/regression-test/data/data_model_p0/unique/test_unique_table_auto_inc.out
index 60fe3b765e3..e075ea4d260 100644
--- a/regression-test/data/data_model_p0/unique/test_unique_table_auto_inc.out
+++ b/regression-test/data/data_model_p0/unique/test_unique_table_auto_inc.out
@@ -116,16 +116,18 @@ Carter 500 9994
Beata 700 9996
Nereids 900 9998
--- !partial_update_value --
-Bob 100 1
-Alice 200 2
-Tom 300 3
-Test 400 4
-Carter 500 5
-Smith 600 6
-Beata 700 7
-Doris 800 8
-Nereids 900 9
+-- !partial_update_value1 --
+Bob 100
+Alice 200
+Tom 300
+Test 400
+Carter 500
+Smith 600
+Beata 700
+Doris 800
+Nereids 900
+
+-- !partial_update_value2 --
-- !partial_update_value --
Bob 9990 1
diff --git
a/regression-test/suites/data_model_p0/unique/test_unique_table_auto_inc.groovy
b/regression-test/suites/data_model_p0/unique/test_unique_table_auto_inc.groovy
index 16ab4f7abb4..dc5ed554a35 100644
---
a/regression-test/suites/data_model_p0/unique/test_unique_table_auto_inc.groovy
+++
b/regression-test/suites/data_model_p0/unique/test_unique_table_auto_inc.groovy
@@ -279,7 +279,8 @@ suite("test_unique_table_auto_inc") {
time 10000 // limit inflight 10s
}
sql "sync"
- qt_partial_update_value "select * from ${table7} order by id;"
+ qt_partial_update_value1 "select name, value from ${table7} order by
value;"
+ qt_partial_update_value2 "select id, count(*) from ${table7} group by id
having count(*) > 1;"
streamLoad {
table "${table7}"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
