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 2023/02/10 00:53:30 UTC
[doris] branch master updated: [fix](regression test) fix test_array_index.groovy without 'order by' lead to result mismatch (#16575)
This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 e68299113e [fix](regression test) fix test_array_index.groovy without 'order by' lead to result mismatch (#16575)
e68299113e is described below
commit e68299113ecde553434cf270bc00f742f2f9940e
Author: YueW <45...@users.noreply.github.com>
AuthorDate: Fri Feb 10 08:53:22 2023 +0800
[fix](regression test) fix test_array_index.groovy without 'order by' lead to result mismatch (#16575)
---
.../inverted_index_p0/test_array_index.groovy | 28 +++++++++++-----------
1 file changed, 14 insertions(+), 14 deletions(-)
diff --git a/regression-test/suites/inverted_index_p0/test_array_index.groovy b/regression-test/suites/inverted_index_p0/test_array_index.groovy
index d240dbdeb7..b660451269 100644
--- a/regression-test/suites/inverted_index_p0/test_array_index.groovy
+++ b/regression-test/suites/inverted_index_p0/test_array_index.groovy
@@ -53,18 +53,18 @@ suite("test_array_index"){
sql "INSERT INTO $indexTblName VALUES (1, [10,20,30], ['i','love','china']), (2, [20,30,40], ['i','love','north korea']), (3, [30,40,50], NULL);"
sql "INSERT INTO $indexTblName VALUES (4, [40,50,60], NULL);"
- qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'china';"
- qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'love';"
- qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'north';"
- qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'korea';"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_ge 40;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_le 40;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_gt 40;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_lt 40;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 10;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 20;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 30;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 40;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 50;"
- qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 60;"
+ qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'china' ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'love' ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'north' ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE c_array MATCH 'korea' ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_ge 40 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_le 40 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_gt 40 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_lt 40 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 10 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 20 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 30 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 40 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 50 ORDER BY id;"
+ qt_sql "SELECT * FROM $indexTblName WHERE int_array element_eq 60 ORDER BY id;"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org