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 <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
