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/10/18 13:53:37 UTC
(doris) branch branch-2.1 updated: [fix](unstablecase) fix unstable testcase (#42091)
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 9febead0ccb [fix](unstablecase) fix unstable testcase (#42091)
9febead0ccb is described below
commit 9febead0ccbcb7ca5f07c1b26fbaf484aada987b
Author: yiguolei <67...@qq.com>
AuthorDate: Fri Oct 18 21:53:28 2024 +0800
[fix](unstablecase) fix unstable testcase (#42091)
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
Co-authored-by: yiguolei <yi...@gmail.com>
---
regression-test/suites/nereids_syntax_p0/test_limit.groovy | 9 ++++++---
1 file changed, 6 insertions(+), 3 deletions(-)
diff --git a/regression-test/suites/nereids_syntax_p0/test_limit.groovy b/regression-test/suites/nereids_syntax_p0/test_limit.groovy
index 01b122c9c95..6856a5e7a20 100644
--- a/regression-test/suites/nereids_syntax_p0/test_limit.groovy
+++ b/regression-test/suites/nereids_syntax_p0/test_limit.groovy
@@ -32,6 +32,9 @@ suite("test_limit") {
sql """ insert into test1 values(1) """
sql """ insert into test1 values(1) """
+
+ sql "sync"
+
test {
sql "select * from test1 limit 2 offset 1"
result([[1]])
@@ -59,16 +62,16 @@ suite("test_limit") {
"""
sql """ INSERT INTO row_number_limit_tbl VALUES (7788, 'SCOTT', 'ANALYST', 7566, '1987-04-19', 3000, 0, 20); """
sql """ INSERT INTO row_number_limit_tbl VALUES (7844, 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500, 0, 30); """
- sleep(1000)
+ sql "sync"
qt_limit1 """
select row_number() over(order by k6 desc) k6s, t.* from row_number_limit_tbl t order by k6s limit 1 offset 1;
"""
sql """ truncate table row_number_limit_tbl; """
- sleep(1000)
+ sql "sync"
sql """ INSERT INTO row_number_limit_tbl VALUES (7788, 'SCOTT', 'ANALYST', 7566, '1987-04-19', 3000, 0, 20); """
sql """ INSERT INTO row_number_limit_tbl VALUES (7844, 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500, 0, 30); """
sql """ INSERT INTO row_number_limit_tbl VALUES (7934, 'MILLER', 'CLERK', 7782, '1982-01-23', 1300, 0, 10); """
- sleep(1000)
+ sql "sync"
qt_lmit2 """
select row_number() over(order by k6 desc) k6s, t.* from row_number_limit_tbl t limit 1 offset 2;
"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org