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