This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 3706aee0ef0 [fix](case) test_limit result is unstable (#41938)
3706aee0ef0 is described below
commit 3706aee0ef0fd86a7b4d0ca9908f7c52094dfe94
Author: morrySnow <[email protected]>
AuthorDate: Wed Oct 16 18:19:37 2024 +0800
[fix](case) test_limit result is unstable (#41938)
---
regression-test/suites/nereids_syntax_p0/test_limit.groovy | 11 ++---------
1 file changed, 2 insertions(+), 9 deletions(-)
diff --git a/regression-test/suites/nereids_syntax_p0/test_limit.groovy
b/regression-test/suites/nereids_syntax_p0/test_limit.groovy
index 49759f57128..fb24d8f1a3a 100644
--- a/regression-test/suites/nereids_syntax_p0/test_limit.groovy
+++ b/regression-test/suites/nereids_syntax_p0/test_limit.groovy
@@ -16,10 +16,6 @@
// under the License.
suite("test_limit") {
- sql 'set enable_nereids_planner=true'
- sql 'set enable_fallback_to_original_planner=false'
-
-
sql """
drop table if exists test1
"""
@@ -32,6 +28,7 @@ suite("test_limit") {
sql """ insert into test1 values(1) """
sql """ insert into test1 values(1) """
+
test {
sql "select * from test1 limit 2 offset 1"
result([[1]])
@@ -60,19 +57,15 @@ 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)
-
qt_limit1 """
- select row_number() over(order by k6 desc) k6s, t.* from
row_number_limit_tbl t limit 1 offset 1;
+ 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 """ 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)
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]
