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