This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 5dd549a2e9f8e721fd1b254da692b90fb5df1bc4
Author: Kang <kxiao.ti...@gmail.com>
AuthorDate: Fri Aug 4 17:36:32 2023 +0800
[fix](inverted index) return empty result instead of error for empty match
query (#22592)
return empty result instead of error for empty match query as follows:
`SELECT * FROM t WHERE msg MATCH ''`
`SELECT * FROM t WHERE msg MATCH 'stop_word'`
---
.../rowset/segment_v2/inverted_index_reader.cpp | 10 +-
be/src/vec/functions/match.cpp | 9 +-
.../inverted_index_p0/test_index_match_select.out | 212 +++++++++++++++++++++
.../test_index_match_select.groovy | 59 +++---
4 files changed, 256 insertions(+), 34 deletions(-)
diff --git a/be/src/olap/rowset/segment_v2/inverted_index_reader.cpp
b/be/src/olap/rowset/segment_v2/inverted_index_reader.cpp
index 8a9a08df0a..d94c20be14 100644
--- a/be/src/olap/rowset/segment_v2/inverted_index_reader.cpp
+++ b/be/src/olap/rowset/segment_v2/inverted_index_reader.cpp
@@ -250,10 +250,18 @@ Status FullTextIndexReader::query(OlapReaderStatistics*
stats, const std::string
get_analyse_result(column_name, search_str, query_type,
inverted_index_ctx.get());
if (analyse_result.empty()) {
- return Status::Error<ErrorCode::INVERTED_INDEX_NO_TERMS>(
+ auto msg = fmt::format(
"token parser result is empty for query, "
"please check your query: '{}' and index parser: '{}'",
search_str,
get_parser_string_from_properties(_index_meta.properties()));
+ if (query_type == InvertedIndexQueryType::MATCH_ALL_QUERY ||
+ query_type == InvertedIndexQueryType::MATCH_ANY_QUERY ||
+ query_type == InvertedIndexQueryType::MATCH_PHRASE_QUERY) {
+ LOG(WARNING) << msg;
+ return Status::OK();
+ } else {
+ return Status::Error<ErrorCode::INVERTED_INDEX_NO_TERMS>(msg);
+ }
}
std::unique_ptr<lucene::search::Query> query;
diff --git a/be/src/vec/functions/match.cpp b/be/src/vec/functions/match.cpp
index 451455771c..3c47699369 100644
--- a/be/src/vec/functions/match.cpp
+++ b/be/src/vec/functions/match.cpp
@@ -137,10 +137,11 @@ Status FunctionMatchAny::execute_match(const std::string&
column_name,
column_name, match_query_str,
doris::segment_v2::InvertedIndexQueryType::MATCH_ANY_QUERY, inverted_index_ctx);
if (query_tokens.empty()) {
- return Status::Error<ErrorCode::INVERTED_INDEX_NO_TERMS>(
+ LOG(WARNING) << fmt::format(
"token parser result is empty for query, "
"please check your query: '{}' and index parser: '{}'",
match_query_str,
inverted_index_parser_type_to_string(parser_type));
+ return Status::OK();
}
auto current_src_array_offset = 0;
@@ -179,10 +180,11 @@ Status FunctionMatchAll::execute_match(const std::string&
column_name,
column_name, match_query_str,
doris::segment_v2::InvertedIndexQueryType::MATCH_ALL_QUERY, inverted_index_ctx);
if (query_tokens.empty()) {
- return Status::Error<ErrorCode::INVERTED_INDEX_NO_TERMS>(
+ LOG(WARNING) << fmt::format(
"token parser result is empty for query, "
"please check your query: '{}' and index parser: '{}'",
match_query_str,
inverted_index_parser_type_to_string(parser_type));
+ return Status::OK();
}
auto current_src_array_offset = 0;
@@ -228,10 +230,11 @@ Status FunctionMatchPhrase::execute_match(const
std::string& column_name,
doris::segment_v2::InvertedIndexQueryType::MATCH_PHRASE_QUERY,
inverted_index_ctx);
if (query_tokens.empty()) {
- return Status::Error<ErrorCode::INVERTED_INDEX_NO_TERMS>(
+ LOG(WARNING) << fmt::format(
"token parser result is empty for query, "
"please check your query: '{}' and index parser: '{}'",
match_query_str,
inverted_index_parser_type_to_string(parser_type));
+ return Status::OK();
}
auto current_src_array_offset = 0;
diff --git a/regression-test/data/inverted_index_p0/test_index_match_select.out
b/regression-test/data/inverted_index_p0/test_index_match_select.out
index 940e8b5066..d7e9aa41bd 100644
--- a/regression-test/data/inverted_index_p0/test_index_match_select.out
+++ b/regression-test/data/inverted_index_p0/test_index_match_select.out
@@ -1,4 +1,16 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_empty1 --
+
+-- !sql_empty2 --
+
+-- !sql_empty3 --
+
+-- !sql_empty4 --
+
+-- !sql_empty5 --
+
+-- !sql_empty6 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -21,6 +33,10 @@ zhang san yi grade 5 zhang yi chen san buy
11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql1 --
+
+-- !sql2 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -47,6 +63,10 @@ zhang san yi grade 5 zhang yi chen san buy
11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -73,6 +93,10 @@ zhang san yi grade 5 zhang yi chen san buy
11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -99,6 +123,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -125,6 +153,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -151,6 +183,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -163,6 +199,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -175,6 +215,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -187,6 +231,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -199,6 +247,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -211,6 +263,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -229,6 +285,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -247,6 +307,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -265,6 +329,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -283,6 +351,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -301,6 +373,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -312,6 +388,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -323,6 +401,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -334,6 +414,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -345,6 +427,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -356,6 +440,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -365,6 +451,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -374,6 +464,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -383,6 +477,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -392,6 +490,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -401,6 +503,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -409,6 +515,18 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql_empty1 --
+
+-- !sql_empty2 --
+
+-- !sql_empty3 --
+
+-- !sql_empty4 --
+
+-- !sql_empty5 --
+
+-- !sql_empty6 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -431,6 +549,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql1 --
+
+-- !sql2 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -457,6 +579,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -483,6 +609,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -509,6 +639,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -535,6 +669,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
@@ -561,6 +699,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
-- !sql --
+-- !sql3 --
+
+-- !sql4 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -573,6 +715,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -585,6 +731,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -597,6 +747,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -609,6 +763,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
@@ -621,6 +779,10 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql5 --
+
+-- !sql6 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -639,6 +801,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -657,6 +823,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -675,6 +845,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -693,6 +867,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
li sisi grade 6 li ba li liuliu 11
2016-10-01T00:00 tall:150cm, weight: 40kg, hobbies: sing, dancing,
running good at handiwork and beaty
@@ -711,6 +889,10 @@ san zhang grade 5 10
2017-10-01T00:00 tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql7 --
+
+-- !sql8 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -722,6 +904,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -733,6 +917,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -744,6 +930,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -755,6 +943,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -766,6 +956,8 @@ zhang san yi grade 5 zhang yi chen san
buy 11 2017-10-01T00:00 tall:120cm, weigh
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
zhang san yi grade 5 zhang yi chen san buy 11
2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: reading book A quiet
little boy learn makes me happy
+-- !sql9 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -775,6 +967,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -784,6 +980,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -793,6 +993,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -802,6 +1006,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
@@ -811,6 +1019,10 @@ li si grade 4 li er wan jiu 9
2018-10-01T00:00 tall:100cm, weight: 30kg, hobbie
-- !sql --
li si grade 4 li er wan jiu 9 2018-10-01T00:00
tall:100cm, weight: 30kg, hobbies: playing ball A naughty boy i just want go
outside
+-- !sql10 --
+
+-- !sql11 --
+
-- !sql --
san zhang grade 5 10 2017-10-01T00:00
tall:100cm, weight: 30kg, hobbies:
zhang san grade 5 zhang yi chen san buy dancing book
10 2017-10-01T00:00 tall:120cm, weight: 35kg, hobbies: sing,
dancing Like cultural and recreational activities Class activists
diff --git
a/regression-test/suites/inverted_index_p0/test_index_match_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_match_select.groovy
index 0bd03eea6a..21e17a1be7 100644
--- a/regression-test/suites/inverted_index_p0/test_index_match_select.groovy
+++ b/regression-test/suites/inverted_index_p0/test_index_match_select.groovy
@@ -155,36 +155,17 @@ suite("test_index_match_select", "inverted_index_select"){
// case1: match term
// case1.0 test match ""
- try {
- sql """ select * from ${indexTbName1} where ${varchar_colume1}
match_any "" order by name; """
- } catch(Exception ex) {
- logger.info("select * from ${indexTbName1} where
${varchar_colume1} match_any, result: " + ex)
- }
- try {
- sql """ select * from ${indexTbName1} where ${varchar_colume2}
match_any "" order by name; """
- } catch(Exception ex) {
- logger.info("select * from ${indexTbName1} where
${varchar_colume1} match_any, result: " + ex)
- }
- try {
- sql """ select * from ${indexTbName1} where ${varchar_colume3}
match_any "" order by name; """
- } catch(Exception ex) {
- logger.info("select * from ${indexTbName1} where
${varchar_colume1} match_any, result: " + ex)
- }
- try {
- sql """ select * from ${indexTbName1} where ${string_colume1}
match_any "" order by name; """
- } catch(Exception ex) {
- logger.info("select * from ${indexTbName1} where
${varchar_colume1} match_any, result: " + ex)
- }
- try {
- sql """ select * from ${indexTbName1} where ${char_colume1}
match_any "" order by name; """
- } catch(Exception ex) {
- logger.info("select * from ${indexTbName1} where
${varchar_colume1} match_any, result: " + ex)
- }
- try {
- sql """ select * from ${indexTbName1} where ${text_colume1}
match_any "" order by name; """
- } catch(Exception ex) {
- logger.info("select * from ${indexTbName1} where
${varchar_colume1} match_any, result: " + ex)
- }
+ qt_sql_empty1 """ select * from ${indexTbName1} where
${varchar_colume1} match_any "" order by name; """
+
+ qt_sql_empty2 """ select * from ${indexTbName1} where
${varchar_colume2} match_any "" order by name; """
+
+ qt_sql_empty3 """ select * from ${indexTbName1} where
${varchar_colume3} match_any "" order by name; """
+
+ qt_sql_empty4 """ select * from ${indexTbName1} where
${string_colume1} match_any "" order by name; """
+
+ qt_sql_empty5 """ select * from ${indexTbName1} where ${char_colume1}
match_any "" order by name; """
+
+ qt_sql_empty6 """ select * from ${indexTbName1} where ${text_colume1}
match_any "" order by name; """
// case1.0 test int colume cannot use match
def colume_match_result = "fail"
@@ -203,6 +184,10 @@ suite("test_index_match_select", "inverted_index_select"){
qt_sql """ select * from ${indexTbName1} where ${varchar_colume1}
match_all '"zhang san"' order by name; """
qt_sql """ select * from ${indexTbName1} where ${varchar_colume1}
match_any 'san' order by name; """
qt_sql """ select * from ${indexTbName1} where ${varchar_colume1}
match_any 'not exist name' order by name; """
+ // stop word and empty query should return 0 rows
+ qt_sql1 """ select * from ${indexTbName1} where ${varchar_colume1}
match_any '' order by name; """
+ qt_sql2 """ select * from ${indexTbName1} where ${varchar_colume1}
match_any 'a' order by name; """
+
// case2.1: test varchar none match same term with different way and
repeate 5 times
for (int test_times = 0; test_times < 5; test_times++) {
@@ -213,6 +198,9 @@ suite("test_index_match_select", "inverted_index_select"){
qt_sql """ select * from ${indexTbName1} where ${varchar_colume2}
match "grade 5" order by name """
qt_sql """ select * from ${indexTbName1} where ${varchar_colume2}
match 'grade none' order by name """
qt_sql """ select * from ${indexTbName1} where ${varchar_colume2}
match 'grade' order by name """
+ // stop word and empty query should return 0 rows
+ qt_sql3 """ select * from ${indexTbName1} where ${varchar_colume2}
match '' order by name """
+ qt_sql4 """ select * from ${indexTbName1} where ${varchar_colume2}
match 'a' order by name """
}
// cas2.2 test varchar standard match same term with different way and
repeate 5 times
@@ -220,6 +208,9 @@ suite("test_index_match_select", "inverted_index_select"){
qt_sql """ select * from ${indexTbName1} where ${varchar_colume3}
match_any 'zhang yi' order by name """
qt_sql """ select * from ${indexTbName1} where ${varchar_colume3}
match_all "zhang yi" order by name """
qt_sql """ select * from ${indexTbName1} where ${varchar_colume3}
match_any '"zhang yi"' order by name """
+ // stop word and empty query should return 0 rows
+ qt_sql5 """ select * from ${indexTbName1} where ${varchar_colume3}
match_any '' order by name """
+ qt_sql6 """ select * from ${indexTbName1} where ${varchar_colume3}
match_any 'a' order by name """
}
// case3: test char standard match same term with different way and
repeate 5 times
@@ -227,6 +218,9 @@ suite("test_index_match_select", "inverted_index_select"){
qt_sql """ select * from ${indexTbName1} where ${char_colume1}
match_any 'tall:100cm, weight: 30kg, hobbies:' order by name """
qt_sql """ select * from ${indexTbName1} where ${char_colume1}
match_all "tall:100cm, weight: 30kg, hobbies:" order by name """
qt_sql """ select * from ${indexTbName1} where ${char_colume1}
match_any '"tall:100cm, weight: 30kg, hobbies:"' order by name """
+ // stop word and empty query should return 0 rows
+ qt_sql7 """ select * from ${indexTbName1} where ${char_colume1}
match_any '' order by name """
+ qt_sql8 """ select * from ${indexTbName1} where ${char_colume1}
match_any 'a' order by name """
}
// case4: test string simple match same term with different way and
repeate 5 times
@@ -234,6 +228,8 @@ suite("test_index_match_select", "inverted_index_select"){
qt_sql """ select * from ${indexTbName1} where ${string_colume1}
match_all 'A naughty boy' order by name """
qt_sql """ select * from ${indexTbName1} where ${string_colume1}
match_any "A naughty boy" order by name """
qt_sql """ select * from ${indexTbName1} where ${string_colume1}
match_any '"A naughty boy"' order by name """
+ // stop word and empty query should return 0 rows
+ qt_sql9 """ select * from ${indexTbName1} where ${string_colume1}
match_any '' order by name """
}
// case5: test text standard match same term with different way and
repeate 5 times
@@ -241,6 +237,9 @@ suite("test_index_match_select", "inverted_index_select"){
qt_sql """ select * from ${indexTbName1} where ${text_colume1}
match_all 'i just want go outside' order by name """
qt_sql """ select * from ${indexTbName1} where ${text_colume1}
match_any "i just want go outside" order by name """
qt_sql """ select * from ${indexTbName1} where ${text_colume1}
match_all '"i just want go outside"' order by name """
+ // stop word and empty query should return 0 rows
+ qt_sql10 """ select * from ${indexTbName1} where ${text_colume1}
match_all '' order by name """
+ qt_sql11 """ select * from ${indexTbName1} where ${text_colume1}
match_all 'a' order by name """
}
// case6: test term and phrase mix select
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
