This is an automated email from the ASF dual-hosted git repository.
lihaopeng 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 83ce4379ff [regression] add order by in test case for stable output
(#21815)
83ce4379ff is described below
commit 83ce4379ff3b167a321dbc7b37793079c94ea577
Author: Kang <[email protected]>
AuthorDate: Fri Jul 14 18:01:43 2023 +0800
[regression] add order by in test case for stable output (#21815)
---
.../data/index_p0/test_ngram_bloomfilter_index.out | 8 +++----
.../index_p0/test_ngram_bloomfilter_index.groovy | 26 +++++++++++-----------
2 files changed, 17 insertions(+), 17 deletions(-)
diff --git a/regression-test/data/index_p0/test_ngram_bloomfilter_index.out
b/regression-test/data/index_p0/test_ngram_bloomfilter_index.out
index 7849739f42..531ce8119e 100644
--- a/regression-test/data/index_p0/test_ngram_bloomfilter_index.out
+++ b/regression-test/data/index_p0/test_ngram_bloomfilter_index.out
@@ -1,7 +1,7 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !select_all_1 --
1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699% /test 100 false
-1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
+2 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
-- !select_eq_1 --
1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699% /test 100 false
@@ -11,17 +11,17 @@
-- !select_like_1 --
1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699% /test 100 false
-1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
+2 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
-- !select_all_2 --
-1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
+2 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
-- !select_eq_2 --
-- !select_in_2 --
-- !select_like_2 --
-1 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
+2 dt_bjn001 p9-webcast-sign.douyinpic.com test
/%/7212503657802320699%xxx /test 100 false
-- !select_all_3 --
diff --git
a/regression-test/suites/index_p0/test_ngram_bloomfilter_index.groovy
b/regression-test/suites/index_p0/test_ngram_bloomfilter_index.groovy
index 7619adedc3..c56eed967a 100644
--- a/regression-test/suites/index_p0/test_ngram_bloomfilter_index.groovy
+++ b/regression-test/suites/index_p0/test_ngram_bloomfilter_index.groovy
@@ -37,26 +37,26 @@ suite("test_ngram_bloomfilter_index") {
"""
sql "INSERT INTO ${tableName} values (1, 'dt_bjn001',
'p9-webcast-sign.douyinpic.com', 'test', '/%/7212503657802320699%', '/test',
100, false);"
- sql "INSERT INTO ${tableName} values (1, 'dt_bjn001',
'p9-webcast-sign.douyinpic.com', 'test', '/%/7212503657802320699%xxx', '/test',
100, false);"
+ sql "INSERT INTO ${tableName} values (2, 'dt_bjn001',
'p9-webcast-sign.douyinpic.com', 'test', '/%/7212503657802320699%xxx', '/test',
100, false);"
sql "SET enable_function_pushdown = true"
- qt_select_all_1 "SELECT * FROM ${tableName}"
- qt_select_eq_1 "SELECT * FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%'"
- qt_select_in_1 "SELECT * FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%')"
- qt_select_like_1 "SELECT * FROM ${tableName} WHERE http_url like
'/%/7212503657802320699%'"
+ qt_select_all_1 "SELECT * FROM ${tableName} ORDER BY key_id"
+ qt_select_eq_1 "SELECT * FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%' ORDER BY key_id"
+ qt_select_in_1 "SELECT * FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%') ORDER BY key_id"
+ qt_select_like_1 "SELECT * FROM ${tableName} WHERE http_url like
'/%/7212503657802320699%' ORDER BY key_id"
// delete and then select
sql "DELETE FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%')"
- qt_select_all_2 "SELECT * FROM ${tableName}"
- qt_select_eq_2 "SELECT * FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%'"
- qt_select_in_2 "SELECT * FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%')"
- qt_select_like_2 "SELECT * FROM ${tableName} WHERE http_url like
'/%/7212503657802320699%'"
+ qt_select_all_2 "SELECT * FROM ${tableName} ORDER BY key_id"
+ qt_select_eq_2 "SELECT * FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%' ORDER BY key_id"
+ qt_select_in_2 "SELECT * FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%') ORDER BY key_id"
+ qt_select_like_2 "SELECT * FROM ${tableName} WHERE http_url like
'/%/7212503657802320699%' ORDER BY key_id"
sql "DELETE FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%xxx'"
- qt_select_all_3 "SELECT * FROM ${tableName}"
- qt_select_eq_3 "SELECT * FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%'"
- qt_select_in_3 "SELECT * FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%')"
- qt_select_like_3 "SELECT * FROM ${tableName} WHERE http_url like
'/%/7212503657802320699%'"
+ qt_select_all_3 "SELECT * FROM ${tableName} ORDER BY key_id"
+ qt_select_eq_3 "SELECT * FROM ${tableName} WHERE http_url =
'/%/7212503657802320699%' ORDER BY key_id"
+ qt_select_in_3 "SELECT * FROM ${tableName} WHERE http_url IN
('/%/7212503657802320699%') ORDER BY key_id"
+ qt_select_like_3 "SELECT * FROM ${tableName} WHERE http_url like
'/%/7212503657802320699%' ORDER BY key_id"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
