This is an automated email from the ASF dual-hosted git repository.
zhangchen 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 daa579b6e58 [Fix](regression) Fix p0 case
`test_unique_table_auto_inc_concurrent` (#37048)
daa579b6e58 is described below
commit daa579b6e5845054a9290cfc4c6a1eb7610da3cd
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]
