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

commit ecaadaf953d6b687d514cca727b2684f9efa3fac
Author: zhangstar333 <[email protected]>
AuthorDate: Tue Apr 23 14:33:17 2024 +0800

    [test](hll) fix unstable case without order by clause (#33947)
---
 .../data/query_p0/sql_functions/hll_functions/test_hll_functions.out    | 2 +-
 .../query_p0/sql_functions/hll_functions/test_hll_functions.groovy      | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/regression-test/data/query_p0/sql_functions/hll_functions/test_hll_functions.out
 
b/regression-test/data/query_p0/sql_functions/hll_functions/test_hll_functions.out
index c9cebac5079..e9012565746 100644
--- 
a/regression-test/data/query_p0/sql_functions/hll_functions/test_hll_functions.out
+++ 
b/regression-test/data/query_p0/sql_functions/hll_functions/test_hll_functions.out
@@ -10,7 +10,7 @@ shanghai      2
 shanxi 1
 
 -- !table_select --
-1
+0
 
 -- !const_select --
 1
diff --git 
a/regression-test/suites/query_p0/sql_functions/hll_functions/test_hll_functions.groovy
 
b/regression-test/suites/query_p0/sql_functions/hll_functions/test_hll_functions.groovy
index 87a5f5360d0..43afed6f52a 100644
--- 
a/regression-test/suites/query_p0/sql_functions/hll_functions/test_hll_functions.groovy
+++ 
b/regression-test/suites/query_p0/sql_functions/hll_functions/test_hll_functions.groovy
@@ -60,7 +60,7 @@ suite("test_hll_functions") {
 
     qt_table_select "select hll_union_agg(hll_from_base64(hll_to_base64(pv))) 
from test_hll_func;"
     qt_table_select "select province, 
hll_union_agg(hll_from_base64(hll_to_base64(pv))) from test_hll_func group by 
province order by province;"
-    qt_table_select "select 
hll_cardinality(hll_from_base64(hll_to_base64(pv))) from test_hll_func limit 1;"
+    qt_table_select "select 
hll_cardinality(hll_from_base64(hll_to_base64(pv))) as res from test_hll_func  
order by res limit 1;"
 
     qt_const_select "select 
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));"
     qt_const_select "select 
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(''))));"


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to