This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 6acdd9cd481 The issue introduced by the recently added auto-increment
column works fine on a single node but may result in discontinuous
auto-increment IDs when running on a cluster. This PR has been modified to
check for the uniqueness of the auto-increment column values instead of
checking for equality to a fixed value. (#32115)
6acdd9cd481 is described below
commit 6acdd9cd4819d40700914d39da024f1a36c76070
Author: abmdocrt <[email protected]>
AuthorDate: Tue Mar 12 21:51:36 2024 +0800
The issue introduced by the recently added auto-increment column works fine
on a single node but may result in discontinuous auto-increment IDs when
running on a cluster. This PR has been modified to check for the uniqueness of
the auto-increment column values instead of checking for equality to a fixed
value. (#32115)
---
.../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: [email protected]
For additional commands, e-mail: [email protected]
