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 2024/03/22 00:54:44 UTC
(doris) 02/24: [Fix](auto-inc) Fix auto inc unique table case (#32393)
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
commit 0537952573a08f554cd57b137ebf68912bd5c14c
Author: abmdocrt <Yu...@gmail.com>
AuthorDate: Thu Mar 21 12:27:42 2024 +0800
[Fix](auto-inc) Fix auto inc unique table case (#32393)
---
.../unique/test_unique_table_auto_inc.out | 54 ++++++++++++----------
.../unique/test_unique_table_auto_inc.groovy | 6 ++-
2 files changed, 33 insertions(+), 27 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 e075ea4d260..800e97b1daf 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
@@ -129,32 +129,36 @@ Nereids 900
-- !partial_update_value2 --
--- !partial_update_value --
-Bob 9990 1
-Alice 200 2
-Tom 9992 3
-Test 400 4
-Carter 9994 5
-Smith 600 6
-Beata 9996 7
-Doris 800 8
-Nereids 9998 9
+-- !partial_update_value1 --
+Alice 200
+Test 400
+Smith 600
+Doris 800
+Bob 9990
+Tom 9992
+Carter 9994
+Beata 9996
+Nereids 9998
--- !partial_update_value --
-Bob 9990 1
-Alice 200 2
-Tom 9992 3
-Test 400 4
-Carter 9994 5
-Smith 600 6
-Beata 9996 7
-Doris 800 8
-Nereids 9998 9
-BBeata 9996 15
-BBob 9990 16
-CCarter 9994 17
-NNereids 9998 18
-TTom 9992 19
+-- !partial_update_value2 --
+
+-- !partial_update_value1 --
+Alice 200
+Test 400
+Smith 600
+Doris 800
+Bob 9990
+BBob 9990
+Tom 9992
+TTom 9992
+Carter 9994
+CCarter 9994
+Beata 9996
+BBeata 9996
+Nereids 9998
+NNereids 9998
+
+-- !partial_update_value2 --
-- !sql --
1 a
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 dc5ed554a35..ee6c45b92a4 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
@@ -294,7 +294,8 @@ suite("test_unique_table_auto_inc") {
time 10000
}
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}"
@@ -308,7 +309,8 @@ suite("test_unique_table_auto_inc") {
time 10000
}
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;"
sql "drop table if exists ${table7};"
def table8 = "test_auto_inc_col_create_as_select1"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org