This is an automated email from the ASF dual-hosted git repository. dataroaring pushed a commit to branch branch-3.0 in repository https://gitbox.apache.org/repos/asf/doris.git
commit c97839a240f44a2e5f72ce2f3c35b865d922c217 Author: bobhan1 <[email protected]> AuthorDate: Mon Jul 1 15:11:53 2024 +0800 [Fix](regression) Fix p0 case `test_unique_table_auto_inc_concurrent` (#37048) since we can't wait all transaction publish finish for insert statement, we just check the uniqueness of the generated auto-increment values --- .../data/data_model_p0/unique/test_unique_auto_inc_concurrent.out | 3 --- .../suites/data_model_p0/unique/test_unique_auto_inc_concurrent.groovy | 3 ++- 2 files changed, 2 insertions(+), 4 deletions(-) diff --git a/regression-test/data/data_model_p0/unique/test_unique_auto_inc_concurrent.out b/regression-test/data/data_model_p0/unique/test_unique_auto_inc_concurrent.out index 03819c9a717..c803ca86189 100644 --- a/regression-test/data/data_model_p0/unique/test_unique_auto_inc_concurrent.out +++ b/regression-test/data/data_model_p0/unique/test_unique_auto_inc_concurrent.out @@ -1,10 +1,7 @@ -- This file is automatically generated. You should know what you did if you want to edit this -- !sql -- -1500000 1500000 -- !sql -- -3000000 3000000 -- !sql -- -4500000 4500000 diff --git a/regression-test/suites/data_model_p0/unique/test_unique_auto_inc_concurrent.groovy b/regression-test/suites/data_model_p0/unique/test_unique_auto_inc_concurrent.groovy index bf6d584b2af..4793fb52343 100644 --- a/regression-test/suites/data_model_p0/unique/test_unique_auto_inc_concurrent.groovy +++ b/regression-test/suites/data_model_p0/unique/test_unique_auto_inc_concurrent.groovy @@ -46,8 +46,9 @@ suite("test_unique_table_auto_inc_concurrent") { } threads.each { thread -> thread.join() } + sql "sync" - qt_sql "select count(id), count(distinct id) from ${table1};" + qt_sql "select id, count(*) from ${table1} group by id having count(*) > 1;" } run_test(15, 10000, 10) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
