This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 d82c6144be0 [Test](index) fix the index property inconsistency for
check_before_quit (#46854)
d82c6144be0 is described below
commit d82c6144be090de67c2b58bd455f08436a57c591
Author: Uniqueyou <wangyix...@selectdb.com>
AuthorDate: Mon Jan 13 22:31:20 2025 +0800
[Test](index) fix the index property inconsistency for check_before_quit
(#46854)
---
.../inverted_index/test_binlog_config_change.groovy | 8 ++++----
.../suites/ccr_syncer_p0/inverted_index/test_get_binlog.groovy | 10 +++++-----
.../ccr_syncer_p0/inverted_index/test_ingest_binlog.groovy | 8 ++++----
.../ccr_syncer_p0/inverted_index/test_multi_buckets.groovy | 8 ++++----
.../ccr_syncer_p1/inverted_index/test_backup_restore.groovy | 8 ++++----
regression-test/suites/datatype_p0/scalar_types/load.groovy | 6 +++---
.../test_index_bkd_writer_fault_injection.groovy | 2 +-
.../test_index_compaction_fault_injection.groovy | 4 ++--
.../test_index_compound_directory_fault_injection.groovy | 2 +-
.../fault_injection_p0/test_index_fault_injection.groovy | 4 ++--
.../test_index_compaction_unique_keys_arr.groovy | 4 ++--
.../inverted_index_p0/index_change/test_index_change_1.groovy | 8 ++++----
.../inverted_index_p0/index_change/test_index_change_2.groovy | 4 ++--
.../inverted_index_p0/index_change/test_index_change_3.groovy | 4 ++--
.../inverted_index_p0/index_change/test_index_change_4.groovy | 4 ++--
.../index_compaction/test_index_compaction_dup_keys.groovy | 2 +-
.../index_compaction/test_index_compaction_null.groovy | 4 ++--
.../index_compaction/test_index_compaction_unique_keys.groovy | 2 +-
.../storage_format/test_storage_format_v1.groovy | 2 +-
.../storage_format/test_storage_format_v2.groovy | 2 +-
.../suites/inverted_index_p0/test_count_on_index.groovy | 4 ++--
.../suites/inverted_index_p0/test_index_equal_select.groovy | 2 +-
.../inverted_index_p0/test_index_key_match_select.groovy | 2 +-
.../suites/inverted_index_p0/test_index_like_select.groovy | 4 ++--
.../suites/inverted_index_p0/test_index_match_phrase.groovy | 4 ++--
.../suites/inverted_index_p0/test_index_match_select.groovy | 8 ++++----
.../inverted_index_p0/test_index_no_need_read_data.groovy | 2 +-
.../inverted_index_p0/test_index_range_between_select.groovy | 4 ++--
.../test_index_range_bigger_and_equal_select.groovy | 2 +-
.../inverted_index_p0/test_index_range_bigger_select.groovy | 2 +-
.../suites/inverted_index_p0/test_index_range_in_select.groovy | 4 ++--
.../inverted_index_p0/test_index_range_not_in_select.groovy | 4 ++--
.../test_index_range_smaller_and_equal_select.groovy | 2 +-
.../inverted_index_p0/test_index_range_smaller_select.groovy | 2 +-
.../suites/inverted_index_p0/test_inverted_index_mor.groovy | 2 +-
.../suites/inverted_index_p0/test_inverted_index_null.groovy | 2 +-
.../inverted_index_p0/test_inverted_index_null_ram_dir.groovy | 2 +-
.../inverted_index_p0/test_inverted_index_v2_file_size.groovy | 2 +-
regression-test/suites/inverted_index_p0/test_lowercase.groovy | 2 +-
.../suites/inverted_index_p0/test_pk_no_need_read_data.groovy | 2 +-
.../unique_with_mow/test_mow_with_null_sequence.groovy | 4 ++--
regression-test/suites/inverted_index_p2/test_show_data.groovy | 6 +++---
regression-test/suites/nereids_syntax_p0/match.groovy | 6 +++---
.../auto_partition/test_auto_partition_behavior.groovy | 2 +-
44 files changed, 86 insertions(+), 86 deletions(-)
diff --git
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_binlog_config_change.groovy
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_binlog_config_change.groovy
index cccf25780d7..bde2f357005 100644
---
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_binlog_config_change.groovy
+++
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_binlog_config_change.groovy
@@ -58,7 +58,7 @@ suite("test_binlog_config_change_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -76,7 +76,7 @@ suite("test_binlog_config_change_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -94,7 +94,7 @@ suite("test_binlog_config_change_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -115,7 +115,7 @@ suite("test_binlog_config_change_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_get_binlog.groovy
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_get_binlog.groovy
index 1e3fed68923..a8ee8e5f819 100644
--- a/regression-test/suites/ccr_syncer_p0/inverted_index/test_get_binlog.groovy
+++ b/regression-test/suites/ccr_syncer_p0/inverted_index/test_get_binlog.groovy
@@ -57,7 +57,7 @@ suite("test_get_binlog_case_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -75,7 +75,7 @@ suite("test_get_binlog_case_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -93,7 +93,7 @@ suite("test_get_binlog_case_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -114,7 +114,7 @@ suite("test_get_binlog_case_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -216,7 +216,7 @@ suite("test_get_binlog_case_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_ingest_binlog.groovy
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_ingest_binlog.groovy
index b46d256a52f..c273ec6832a 100644
---
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_ingest_binlog.groovy
+++
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_ingest_binlog.groovy
@@ -59,7 +59,7 @@ suite("test_ingest_binlog_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -77,7 +77,7 @@ suite("test_ingest_binlog_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -95,7 +95,7 @@ suite("test_ingest_binlog_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -116,7 +116,7 @@ suite("test_ingest_binlog_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_multi_buckets.groovy
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_multi_buckets.groovy
index 4a7b7263af2..796400c8044 100644
---
a/regression-test/suites/ccr_syncer_p0/inverted_index/test_multi_buckets.groovy
+++
b/regression-test/suites/ccr_syncer_p0/inverted_index/test_multi_buckets.groovy
@@ -58,7 +58,7 @@ suite("test_multi_buckets_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -76,7 +76,7 @@ suite("test_multi_buckets_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -94,7 +94,7 @@ suite("test_multi_buckets_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -115,7 +115,7 @@ suite("test_multi_buckets_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/ccr_syncer_p1/inverted_index/test_backup_restore.groovy
b/regression-test/suites/ccr_syncer_p1/inverted_index/test_backup_restore.groovy
index 86f4cc89913..b375badfe9b 100644
---
a/regression-test/suites/ccr_syncer_p1/inverted_index/test_backup_restore.groovy
+++
b/regression-test/suites/ccr_syncer_p1/inverted_index/test_backup_restore.groovy
@@ -59,7 +59,7 @@ suite("test_backup_restore_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -80,7 +80,7 @@ suite("test_backup_restore_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -102,7 +102,7 @@ suite("test_backup_restore_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -123,7 +123,7 @@ suite("test_backup_restore_index") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git a/regression-test/suites/datatype_p0/scalar_types/load.groovy
b/regression-test/suites/datatype_p0/scalar_types/load.groovy
index 4c7c7ee9366..d4989ce4e35 100644
--- a/regression-test/suites/datatype_p0/scalar_types/load.groovy
+++ b/regression-test/suites/datatype_p0/scalar_types/load.groovy
@@ -394,7 +394,7 @@ suite("test_scalar_types_load", "p0") {
INDEX idx_c_datetimev2 (c_datetimev2) USING INVERTED,
INDEX idx_c_char (c_char) USING INVERTED,
INDEX idx_c_varchar (c_varchar) USING INVERTED,
- INDEX idx_c_string (c_string) USING INVERTED
PROPERTIES("parser"="english")
+ INDEX idx_c_string (c_string) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true")
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
COMMENT 'OLAP'
@@ -443,7 +443,7 @@ suite("test_scalar_types_load", "p0") {
INDEX idx_c_datetimev2 (c_datetimev2) USING INVERTED,
INDEX idx_c_char (c_char) USING INVERTED,
INDEX idx_c_varchar (c_varchar) USING INVERTED,
- INDEX idx_c_string (c_string) USING INVERTED
PROPERTIES("parser"="english")
+ INDEX idx_c_string (c_string) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true")
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
COMMENT 'OLAP'
@@ -491,7 +491,7 @@ suite("test_scalar_types_load", "p0") {
INDEX idx_c_datetimev2 (c_datetimev2) USING INVERTED,
INDEX idx_c_char (c_char) USING INVERTED,
INDEX idx_c_varchar (c_varchar) USING INVERTED,
- INDEX idx_c_string (c_string) USING INVERTED
PROPERTIES("parser"="english")
+ INDEX idx_c_string (c_string) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true")
) ENGINE=OLAP
UNIQUE KEY(`c_datetimev2`, `c_bigint`, `c_decimalv3`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/fault_injection_p0/test_index_bkd_writer_fault_injection.groovy
b/regression-test/suites/fault_injection_p0/test_index_bkd_writer_fault_injection.groovy
index 7df72ebeaf1..e13a6a9bc34 100644
---
a/regression-test/suites/fault_injection_p0/test_index_bkd_writer_fault_injection.groovy
+++
b/regression-test/suites/fault_injection_p0/test_index_bkd_writer_fault_injection.groovy
@@ -29,7 +29,7 @@ suite("test_index_bkd_writer_fault_injection",
"nonConcurrent") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git
a/regression-test/suites/fault_injection_p0/test_index_compaction_fault_injection.groovy
b/regression-test/suites/fault_injection_p0/test_index_compaction_fault_injection.groovy
index 7820c001ce4..b33ce977bbe 100644
---
a/regression-test/suites/fault_injection_p0/test_index_compaction_fault_injection.groovy
+++
b/regression-test/suites/fault_injection_p0/test_index_compaction_fault_injection.groovy
@@ -305,7 +305,7 @@ suite("test_index_compaction_failure_injection",
"nonConcurrent") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -332,7 +332,7 @@ suite("test_index_compaction_failure_injection",
"nonConcurrent") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/fault_injection_p0/test_index_compound_directory_fault_injection.groovy
b/regression-test/suites/fault_injection_p0/test_index_compound_directory_fault_injection.groovy
index 27f939dcbc0..ca25f47c88d 100644
---
a/regression-test/suites/fault_injection_p0/test_index_compound_directory_fault_injection.groovy
+++
b/regression-test/suites/fault_injection_p0/test_index_compound_directory_fault_injection.groovy
@@ -57,7 +57,7 @@ suite("test_index_compound_directory_fault_injection",
"nonConcurrent") {
INDEX size_idx (`size`) USING INVERTED COMMENT '',
INDEX status_idx (`status`) USING INVERTED COMMENT
'',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/fault_injection_p0/test_index_fault_injection.groovy
b/regression-test/suites/fault_injection_p0/test_index_fault_injection.groovy
index 5fd47739b48..f27b7157b22 100644
---
a/regression-test/suites/fault_injection_p0/test_index_fault_injection.groovy
+++
b/regression-test/suites/fault_injection_p0/test_index_fault_injection.groovy
@@ -32,7 +32,7 @@ suite("test_index_failure_injection", "nonConcurrent") {
INDEX size_idx (`size`) USING INVERTED COMMENT '',
INDEX status_idx (`status`) USING INVERTED COMMENT
'',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
COMMENT 'OLAP'
@@ -68,7 +68,7 @@ suite("test_index_failure_injection", "nonConcurrent") {
INDEX size_idx (`size`) USING INVERTED COMMENT
'',
INDEX status_idx (`status`) USING INVERTED
COMMENT '',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
UNIQUE KEY(`@timestamp`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/inverted_index_p0/array_contains/test_index_compaction_unique_keys_arr.groovy
b/regression-test/suites/inverted_index_p0/array_contains/test_index_compaction_unique_keys_arr.groovy
index 3f7965c969f..875acba7574 100644
---
a/regression-test/suites/inverted_index_p0/array_contains/test_index_compaction_unique_keys_arr.groovy
+++
b/regression-test/suites/inverted_index_p0/array_contains/test_index_compaction_unique_keys_arr.groovy
@@ -188,7 +188,7 @@ suite("test_index_compaction_unique_keys_arr",
"array_contains_inverted_index, n
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
@@ -212,7 +212,7 @@ suite("test_index_compaction_unique_keys_arr",
"array_contains_inverted_index, n
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_1.groovy
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_1.groovy
index decd075b8fb..c3c31aef5f7 100644
---
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_1.groovy
+++
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_1.groovy
@@ -81,9 +81,9 @@ suite("test_index_change_1") {
// create inverted index
sql """ CREATE INDEX idx_user_id ON ${tableName}(`user_id`) USING INVERTED
"""
wait_for_latest_op_on_table_finish(tableName, timeout)
- sql """ CREATE INDEX idx_note ON ${tableName}(`note`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_note ON ${tableName}(`note`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
- sql """ CREATE INDEX idx_city ON ${tableName}(`city`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_city ON ${tableName}(`city`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// create bitmap index
@@ -148,9 +148,9 @@ suite("test_index_change_1") {
// create inverted index
sql """ CREATE INDEX idx_user_id ON ${tableName}(`user_id`) USING INVERTED
"""
wait_for_latest_op_on_table_finish(tableName, timeout)
- sql """ CREATE INDEX idx_note ON ${tableName}(`note`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_note ON ${tableName}(`note`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
- sql """ CREATE INDEX idx_city ON ${tableName}(`city`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_city ON ${tableName}(`city`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// create bitmap index
diff --git
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_2.groovy
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_2.groovy
index b6d26657737..85c79340f79 100644
---
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_2.groovy
+++
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_2.groovy
@@ -110,7 +110,7 @@ suite("test_index_change_2") {
qt_select6 """ SELECT * FROM ${tableName} t WHERE note MATCH 'engineer
Developer' AND city match_all 'Shanghai China' ORDER BY user_id; """
// create inverted index idx_city
- sql """ CREATE INDEX idx_city ON ${tableName}(`city`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_city ON ${tableName}(`city`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// drop inverted index idx_user_id, idx_note
@@ -183,7 +183,7 @@ suite("test_index_change_2") {
qt_select6_v1 """ SELECT * FROM ${tableName} t WHERE note MATCH 'engineer
Developer' AND city match_all 'Shanghai China' ORDER BY user_id; """
// create inverted index idx_city
- sql """ CREATE INDEX idx_city ON ${tableName}(`city`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_city ON ${tableName}(`city`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// drop inverted index idx_user_id, idx_note
diff --git
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_3.groovy
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_3.groovy
index ade7f4d6c18..9c6f43e4bc1 100644
---
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_3.groovy
+++
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_3.groovy
@@ -110,7 +110,7 @@ suite("test_index_change_3") {
qt_select6 """ SELECT * FROM ${tableName} t WHERE note MATCH 'engineer
Developer' AND city match_all 'Shanghai China' ORDER BY user_id; """
// create inverted index idx_city
- sql """ CREATE INDEX idx_city ON ${tableName}(`city`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_city ON ${tableName}(`city`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// build index
if (!isCloudMode()) {
@@ -185,7 +185,7 @@ suite("test_index_change_3") {
qt_select6_v1 """ SELECT * FROM ${tableName} t WHERE note MATCH 'engineer
Developer' AND city match_all 'Shanghai China' ORDER BY user_id; """
// create inverted index idx_city
- sql """ CREATE INDEX idx_city ON ${tableName}(`city`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_city ON ${tableName}(`city`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// build index
if (!isCloudMode()) {
diff --git
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_4.groovy
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_4.groovy
index 7c3c955c998..29ffddc4dc4 100644
---
a/regression-test/suites/inverted_index_p0/index_change/test_index_change_4.groovy
+++
b/regression-test/suites/inverted_index_p0/index_change/test_index_change_4.groovy
@@ -115,7 +115,7 @@ suite("test_index_change_4") {
sql """ DROP INDEX idx_note ON ${tableName} """
wait_for_latest_op_on_table_finish(tableName, timeout)
// create inverted index idx_city
- sql """ CREATE INDEX idx_note ON ${tableName}(`note`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_note ON ${tableName}(`note`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// build index
if (!isCloudMode()) {
@@ -189,7 +189,7 @@ suite("test_index_change_4") {
sql """ DROP INDEX idx_note ON ${tableName} """
wait_for_latest_op_on_table_finish(tableName, timeout)
// create inverted index idx_city
- sql """ CREATE INDEX idx_note ON ${tableName}(`note`) USING INVERTED
PROPERTIES("parser"="english") """
+ sql """ CREATE INDEX idx_note ON ${tableName}(`note`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") """
wait_for_latest_op_on_table_finish(tableName, timeout)
// build index
if (!isCloudMode()) {
diff --git
a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_dup_keys.groovy
b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_dup_keys.groovy
index c5617e7d6c8..0e678ef7ea0 100644
---
a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_dup_keys.groovy
+++
b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_dup_keys.groovy
@@ -99,7 +99,7 @@ suite("test_index_compaction_dup_keys", "nonConcurrent") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_null.groovy
b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_null.groovy
index 5bf1ec1773b..e72a5edeabe 100644
---
a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_null.groovy
+++
b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_null.groovy
@@ -260,7 +260,7 @@ suite("test_index_compaction_null", "nonConcurrent") {
`compy` varchar(20) NULL COMMENT "",
`n` int NULL COMMENT "",
INDEX idx_city(city) USING INVERTED,
- INDEX idx_addr(addr) USING INVERTED
PROPERTIES("parser"="english"),
+ INDEX idx_addr(addr) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
INDEX idx_n(n) USING INVERTED
) ENGINE=OLAP
DUPLICATE KEY(`id`)
@@ -295,7 +295,7 @@ suite("test_index_compaction_null", "nonConcurrent") {
`compy` varchar(20) NULL COMMENT "",
`n` int NULL COMMENT "",
INDEX idx_city(city) USING INVERTED,
- INDEX idx_addr(addr) USING INVERTED
PROPERTIES("parser"="english"),
+ INDEX idx_addr(addr) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
INDEX idx_n(n) USING INVERTED
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_unique_keys.groovy
b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_unique_keys.groovy
index 688a0dab144..74cc4ffbc31 100644
---
a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_unique_keys.groovy
+++
b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_unique_keys.groovy
@@ -99,7 +99,7 @@ suite("test_index_compaction_unique_keys", "nonConcurrent") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
UNIQUE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v1.groovy
b/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v1.groovy
index 02ebc1b5b12..6d5e1917fe1 100644
---
a/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v1.groovy
+++
b/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v1.groovy
@@ -31,7 +31,7 @@ suite("test_storage_format_v1", "p0") {
INDEX size_idx (`size`) USING INVERTED COMMENT '',
INDEX status_idx (`status`) USING INVERTED COMMENT
'',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v2.groovy
b/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v2.groovy
index 639717d5689..8996d0989a6 100644
---
a/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v2.groovy
+++
b/regression-test/suites/inverted_index_p0/storage_format/test_storage_format_v2.groovy
@@ -31,7 +31,7 @@ suite("test_storage_format_v2", "p0, nonConcurrent") {
INDEX size_idx (`size`) USING INVERTED COMMENT '',
INDEX status_idx (`status`) USING INVERTED COMMENT
'',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/inverted_index_p0/test_count_on_index.groovy
b/regression-test/suites/inverted_index_p0/test_count_on_index.groovy
index 89d1e8f93b2..6e5a33002f0 100644
--- a/regression-test/suites/inverted_index_p0/test_count_on_index.groovy
+++ b/regression-test/suites/inverted_index_p0/test_count_on_index.groovy
@@ -32,7 +32,7 @@ suite("test_count_on_index_httplogs", "p0") {
INDEX size_idx (`size`) USING INVERTED COMMENT '',
INDEX status_idx (`status`) USING INVERTED COMMENT
'',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
COMMENT 'OLAP'
@@ -68,7 +68,7 @@ suite("test_count_on_index_httplogs", "p0") {
INDEX size_idx (`size`) USING INVERTED COMMENT
'',
INDEX status_idx (`status`) USING INVERTED
COMMENT '',
INDEX clientip_idx (`clientip`) USING INVERTED
COMMENT '',
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
UNIQUE KEY(`@timestamp`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/inverted_index_p0/test_index_equal_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_equal_select.groovy
index de8991e72ec..c062b7438c5 100644
--- a/regression-test/suites/inverted_index_p0/test_index_equal_select.groovy
+++ b/regression-test/suites/inverted_index_p0/test_index_equal_select.groovy
@@ -37,7 +37,7 @@ suite("test_index_equal_select", "inverted_index_select"){
INDEX name_idx(name) USING INVERTED COMMENT 'name index',
INDEX age_idx(age) USING INVERTED COMMENT 'age index',
INDEX grade_idx(grade) USING INVERTED
PROPERTIES("parser"="none") COMMENT 'grade index',
- INDEX tearchComment_index(tearchComment) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'tearchComment index',
+ INDEX tearchComment_index(tearchComment) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'tearchComment index',
INDEX studentInfo_index(studentInfo) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX selfComment_index(selfComment) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX fatherName_idx(fatherName) USING INVERTED
PROPERTIES("parser"="standard") COMMENT ' fatherName index'
diff --git
a/regression-test/suites/inverted_index_p0/test_index_key_match_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_key_match_select.groovy
index 4334a636f70..a9d9df943f8 100644
---
a/regression-test/suites/inverted_index_p0/test_index_key_match_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_key_match_select.groovy
@@ -27,7 +27,7 @@ suite("test_index_key_match_select", "inverted_index_select"){
CREATE TABLE IF NOT EXISTS ${indexTbName1} (
${varchar_colume1} varchar(500),
${array_string_colume2} array<string>,
- INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${varchar_colume1} index',
+ INDEX ${varchar_colume1}_idx(${varchar_colume1}) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${varchar_colume1} index',
INDEX ${array_string_colume2}_idx(${array_string_colume2})
USING INVERTED PROPERTIES("parser"="none") COMMENT '${array_string_colume2}
index'
)
DUPLICATE KEY(`user`)
diff --git
a/regression-test/suites/inverted_index_p0/test_index_like_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_like_select.groovy
index 975fac2eaa5..14996599789 100644
--- a/regression-test/suites/inverted_index_p0/test_index_like_select.groovy
+++ b/regression-test/suites/inverted_index_p0/test_index_like_select.groovy
@@ -65,7 +65,7 @@ suite("test_index_like_select", "inverted_index_select"){
INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED COMMENT '${varchar_colume1} index',
INDEX ${int_colume1}_idx(${int_colume1}) USING INVERTED
COMMENT '${int_colume1} index',
INDEX ${varchar_colume2}_idx(${varchar_colume2}) USING
INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
- INDEX ${string_colume1}_idx(${string_colume1}) USING INVERTED
PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ INDEX ${string_colume1}_idx(${string_colume1}) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '${string_colume1} index',
INDEX ${char_colume1}_idx(${char_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
INDEX ${text_colume1}_idx(${text_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${text_colume1} index',
INDEX ${varchar_colume3}_idx(${varchar_colume3}) USING
INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3} index'
@@ -111,7 +111,7 @@ suite("test_index_like_select", "inverted_index_select"){
add index ${varchar_colume2}_idx(`${varchar_colume2}`)
USING INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
add index ${varchar_colume3}_idx(`${varchar_colume3}`)
USING INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3}
index',
add index ${int_colume1}_idx(`${int_colume1}`) USING
INVERTED COMMENT '${int_colume1} index',
- add index ${string_colume1}_idx(`${string_colume1}`) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ add index ${string_colume1}_idx(`${string_colume1}`) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${string_colume1} index',
add index ${char_colume1}_idx(`${char_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
add index ${text_colume1}_idx(`${text_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${text_colume1} index';
"""
diff --git
a/regression-test/suites/inverted_index_p0/test_index_match_phrase.groovy
b/regression-test/suites/inverted_index_p0/test_index_match_phrase.groovy
index 1199e640848..f7e793f8490 100644
--- a/regression-test/suites/inverted_index_p0/test_index_match_phrase.groovy
+++ b/regression-test/suites/inverted_index_p0/test_index_match_phrase.groovy
@@ -83,10 +83,10 @@ suite("test_index_match_phrase_select",
"inverted_index_select"){
${char_colume1} char(100),
${string_colume1} string,
${text_colume1} text,
- INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${varchar_colume1} index',
+ INDEX ${varchar_colume1}_idx(${varchar_colume1}) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${varchar_colume1} index',
INDEX ${int_colume1}_idx(${int_colume1}) USING INVERTED
COMMENT '${int_colume1} index',
INDEX ${varchar_colume2}_idx(${varchar_colume2}) USING
INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
- INDEX ${string_colume1}_idx(${string_colume1}) USING INVERTED
PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ INDEX ${string_colume1}_idx(${string_colume1}) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '${string_colume1} index',
INDEX ${char_colume1}_idx(${char_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
INDEX ${text_colume1}_idx(${text_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${text_colume1} index',
INDEX ${varchar_colume3}_idx(${varchar_colume3}) USING
INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3} index'
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 387893e470f..45eda4f1ddb 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
@@ -83,10 +83,10 @@ suite("test_index_match_select", "inverted_index_select"){
${char_colume1} char(100),
${string_colume1} string,
${text_colume1} text,
- INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${varchar_colume1} index',
+ INDEX ${varchar_colume1}_idx(${varchar_colume1}) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${varchar_colume1} index',
INDEX ${int_colume1}_idx(${int_colume1}) USING INVERTED
COMMENT '${int_colume1} index',
INDEX ${varchar_colume2}_idx(${varchar_colume2}) USING
INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
- INDEX ${string_colume1}_idx(${string_colume1}) USING INVERTED
PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ INDEX ${string_colume1}_idx(${string_colume1}) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '${string_colume1} index',
INDEX ${char_colume1}_idx(${char_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
INDEX ${text_colume1}_idx(${text_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${text_colume1} index',
INDEX ${varchar_colume3}_idx(${varchar_colume3}) USING
INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3} index'
@@ -128,11 +128,11 @@ suite("test_index_match_select", "inverted_index_select"){
logger.info("it's " + i + " times select, readd all index before
select again")
sql """
ALTER TABLE ${indexTbName1}
- add index ${varchar_colume1}_idx(`${varchar_colume1}`)
USING INVERTED PROPERTIES("parser"="english") COMMENT '${varchar_colume1}
index',
+ add index ${varchar_colume1}_idx(`${varchar_colume1}`)
using inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${varchar_colume1} index',
add index ${varchar_colume2}_idx(`${varchar_colume2}`)
USING INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
add index ${varchar_colume3}_idx(`${varchar_colume3}`)
USING INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3}
index',
add index ${int_colume1}_idx(`${int_colume1}`) USING
INVERTED COMMENT '${int_colume1} index',
- add index ${string_colume1}_idx(`${string_colume1}`) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ add index ${string_colume1}_idx(`${string_colume1}`) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${string_colume1} index',
add index ${char_colume1}_idx(`${char_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
add index ${text_colume1}_idx(`${text_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${text_colume1} index';
"""
diff --git
a/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
b/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
index 43ec140fd3a..c0e205ec953 100644
---
a/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_no_need_read_data.groovy
@@ -28,7 +28,7 @@ suite("test_index_no_need_read_data",
"inverted_index_select"){
`compy` varchar(20) NULL COMMENT "",
`n` int NULL COMMENT "",
INDEX idx_city(city) USING INVERTED,
- INDEX idx_addr(addr) USING INVERTED PROPERTIES("parser"="english"),
+ INDEX idx_addr(addr) using inverted properties("support_phrase" =
"true", "parser" = "english", "lower_case" = "true"),
INDEX idx_n(n) USING INVERTED
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_between_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_between_select.groovy
index 5401c9e410a..6e4f3168885 100644
---
a/regression-test/suites/inverted_index_p0/test_index_range_between_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_range_between_select.groovy
@@ -65,7 +65,7 @@ suite("test_index_range_between_select",
"inverted_index_select"){
INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED COMMENT '${varchar_colume1} index',
INDEX ${int_colume1}_idx(${int_colume1}) USING INVERTED
COMMENT '${int_colume1} index',
INDEX ${varchar_colume2}_idx(${varchar_colume2}) USING
INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
- INDEX ${string_colume1}_idx(${string_colume1}) USING INVERTED
PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ INDEX ${string_colume1}_idx(${string_colume1}) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '${string_colume1} index',
INDEX ${char_colume1}_idx(${char_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
INDEX ${text_colume1}_idx(${text_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${text_colume1} index',
INDEX ${varchar_colume3}_idx(${varchar_colume3}) USING
INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3} index'
@@ -111,7 +111,7 @@ suite("test_index_range_between_select",
"inverted_index_select"){
add index ${varchar_colume2}_idx(`${varchar_colume2}`)
USING INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
add index ${varchar_colume3}_idx(`${varchar_colume3}`)
USING INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3}
index',
add index ${int_colume1}_idx(`${int_colume1}`) USING
INVERTED COMMENT '${int_colume1} index',
- add index ${string_colume1}_idx(`${string_colume1}`) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ add index ${string_colume1}_idx(`${string_colume1}`) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${string_colume1} index',
add index ${char_colume1}_idx(`${char_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
add index ${text_colume1}_idx(`${text_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${text_colume1} index';
"""
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_bigger_and_equal_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_bigger_and_equal_select.groovy
index 517caaea651..41333fdca0d 100644
---
a/regression-test/suites/inverted_index_p0/test_index_range_bigger_and_equal_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_range_bigger_and_equal_select.groovy
@@ -37,7 +37,7 @@ suite("test_index_range_bigger_and_equal_select",
"inverted_index_select"){
INDEX name_idx(name) USING INVERTED COMMENT 'name index',
INDEX age_idx(age) USING INVERTED COMMENT 'age index',
INDEX grade_idx(grade) USING INVERTED
PROPERTIES("parser"="none") COMMENT 'grade index',
- INDEX tearchComment_idx(tearchComment) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'tearchComment index',
+ INDEX tearchComment_idx(tearchComment) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'tearchComment index',
INDEX studentInfo_idx(studentInfo) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX selfComment_idx(selfComment) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX fatherName_idx(fatherName) USING INVERTED
PROPERTIES("parser"="standard") COMMENT ' fatherName index'
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_bigger_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_bigger_select.groovy
index 937d24ba2d1..d84313c2da3 100644
---
a/regression-test/suites/inverted_index_p0/test_index_range_bigger_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_range_bigger_select.groovy
@@ -37,7 +37,7 @@ suite("test_index_range_bigger_select",
"inverted_index_select"){
INDEX name_idx(name) USING INVERTED COMMENT 'name index',
INDEX age_idx(age) USING INVERTED COMMENT 'age index',
INDEX grade_idx(grade) USING INVERTED
PROPERTIES("parser"="none") COMMENT 'grade index',
- INDEX tearchComment_idx(tearchComment) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'tearchComment index',
+ INDEX tearchComment_idx(tearchComment) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'tearchComment index',
INDEX studentInfo_idx(studentInfo) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX selfComment_idx(selfComment) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX fatherName_idx(fatherName) USING INVERTED
PROPERTIES("parser"="standard") COMMENT ' fatherName index'
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_in_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_in_select.groovy
index 432151a9a28..a169aef3fe5 100644
--- a/regression-test/suites/inverted_index_p0/test_index_range_in_select.groovy
+++ b/regression-test/suites/inverted_index_p0/test_index_range_in_select.groovy
@@ -46,7 +46,7 @@ suite("test_index_range_in_select", "inverted_index_select"){
INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED COMMENT '${varchar_colume1} index',
INDEX ${int_colume1}_idx(${int_colume1}) USING INVERTED
COMMENT '${int_colume1} index',
INDEX ${varchar_colume2}_idx(${varchar_colume2}) USING
INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
- INDEX ${string_colume1}_idx(${string_colume1}) USING INVERTED
PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ INDEX ${string_colume1}_idx(${string_colume1}) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '${string_colume1} index',
INDEX ${char_colume1}_idx(${char_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
INDEX ${text_colume1}_idx(${text_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${text_colume1} index',
INDEX ${varchar_colume3}_idx(${varchar_colume3}) USING
INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3} index'
@@ -131,7 +131,7 @@ suite("test_index_range_in_select",
"inverted_index_select"){
add index ${varchar_colume2}_idx(`${varchar_colume2}`)
USING INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
add index ${varchar_colume3}_idx(`${varchar_colume3}`)
USING INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3}
index',
add index ${int_colume1}_idx(`${int_colume1}`) USING
INVERTED COMMENT '${int_colume1} index',
- add index ${string_colume1}_idx(`${string_colume1}`) USING
INVERTED PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ add index ${string_colume1}_idx(`${string_colume1}`) using
inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${string_colume1} index',
add index ${char_colume1}_idx(`${char_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
add index ${text_colume1}_idx(`${text_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${text_colume1} index';
"""
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_not_in_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_not_in_select.groovy
index fd330c78b01..179ac47b28c 100644
---
a/regression-test/suites/inverted_index_p0/test_index_range_not_in_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_range_not_in_select.groovy
@@ -54,7 +54,7 @@ suite("test_index_range_not_in_select",
"inverted_index_select"){
INDEX ${varchar_colume1}_idx(${varchar_colume1}) USING
INVERTED COMMENT '${varchar_colume1} index',
INDEX ${int_colume1}_idx(${int_colume1}) USING INVERTED
COMMENT '${int_colume1} index',
INDEX ${varchar_colume2}_idx(${varchar_colume2}) USING
INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
- INDEX ${string_colume1}_idx(${string_colume1}) USING INVERTED
PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ INDEX ${string_colume1}_idx(${string_colume1}) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '${string_colume1} index',
INDEX ${char_colume1}_idx(${char_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
INDEX ${text_colume1}_idx(${text_colume1}) USING INVERTED
PROPERTIES("parser"="standard") COMMENT '${text_colume1} index',
INDEX ${varchar_colume3}_idx(${varchar_colume3}) USING
INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3} index'
@@ -138,7 +138,7 @@ suite("test_index_range_not_in_select",
"inverted_index_select"){
add index ${varchar_colume2}_idx(`${varchar_colume2}`)
USING INVERTED PROPERTIES("parser"="none") COMMENT '${varchar_colume2} index',
add index ${varchar_colume3}_idx(`${varchar_colume3}`)
USING INVERTED PROPERTIES("parser"="standard") COMMENT ' ${varchar_colume3}
index',
add index ${int_colume1}_idx(`${int_colume1}`) USING
INVERTED COMMENT '${int_colume1} index',
- add index ${string_colume1}_idx(`${string_colume1}`)
USING INVERTED PROPERTIES("parser"="english") COMMENT '${string_colume1} index',
+ add index ${string_colume1}_idx(`${string_colume1}`)
using inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true") COMMENT '${string_colume1} index',
add index ${char_colume1}_idx(`${char_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${char_colume1} index',
add index ${text_colume1}_idx(`${text_colume1}`) USING
INVERTED PROPERTIES("parser"="standard") COMMENT '${text_colume1} index';
"""
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_smaller_and_equal_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_smaller_and_equal_select.groovy
index 4cc3ca1ab62..b4133754459 100644
---
a/regression-test/suites/inverted_index_p0/test_index_range_smaller_and_equal_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_range_smaller_and_equal_select.groovy
@@ -37,7 +37,7 @@ suite("test_index_range_smaller_and_equal_select",
"inverted_index_select"){
INDEX name_idx(name) USING INVERTED COMMENT 'name index',
INDEX age_idx(age) USING INVERTED COMMENT 'age index',
INDEX grade_idx(grade) USING INVERTED
PROPERTIES("parser"="none") COMMENT 'grade index',
- INDEX tearchComment_idx(tearchComment) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'tearchComment index',
+ INDEX tearchComment_idx(tearchComment) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'tearchComment index',
INDEX studentInfo_idx(studentInfo) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX selfComment_idx(selfComment) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX fatherName_idx(fatherName) USING INVERTED
PROPERTIES("parser"="standard") COMMENT ' fatherName index'
diff --git
a/regression-test/suites/inverted_index_p0/test_index_range_smaller_select.groovy
b/regression-test/suites/inverted_index_p0/test_index_range_smaller_select.groovy
index cf03e7c8caf..9c9f0b120d6 100644
---
a/regression-test/suites/inverted_index_p0/test_index_range_smaller_select.groovy
+++
b/regression-test/suites/inverted_index_p0/test_index_range_smaller_select.groovy
@@ -37,7 +37,7 @@ suite("test_index_range_smaller_select",
"inverted_index_select"){
INDEX name_idx(name) USING INVERTED COMMENT 'name index',
INDEX age_idx(age) USING INVERTED COMMENT 'age index',
INDEX grade_idx(grade) USING INVERTED
PROPERTIES("parser"="none") COMMENT 'grade index',
- INDEX tearchComment_idx(tearchComment) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'tearchComment index',
+ INDEX tearchComment_idx(tearchComment) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'tearchComment index',
INDEX studentInfo_idx(studentInfo) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX selfComment_idx(selfComment) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'studentInfo index',
INDEX fatherName_idx(fatherName) USING INVERTED
PROPERTIES("parser"="standard") COMMENT ' fatherName index'
diff --git
a/regression-test/suites/inverted_index_p0/test_inverted_index_mor.groovy
b/regression-test/suites/inverted_index_p0/test_inverted_index_mor.groovy
index 0f9ca2f31e8..64073b18610 100644
--- a/regression-test/suites/inverted_index_p0/test_inverted_index_mor.groovy
+++ b/regression-test/suites/inverted_index_p0/test_inverted_index_mor.groovy
@@ -62,7 +62,7 @@ suite("test_inverted_index_mor", "p0"){
// can not add INVERTED INDEX with parser
test{
- sql """ ALTER TABLE ${indexTblName} ADD INDEX idx_c_string(`c_string`)
USING INVERTED PROPERTIES("parser"="english"); """
+ sql """ ALTER TABLE ${indexTblName} ADD INDEX idx_c_string(`c_string`)
using inverted properties("support_phrase" = "true", "parser" = "english",
"lower_case" = "true"); """
exception "errCode = 2, detailMessage = INVERTED index with parser can
NOT be used in value columns of UNIQUE_KEYS table with merge_on_write disable.
invalid index: idx_c_string"
}
diff --git
a/regression-test/suites/inverted_index_p0/test_inverted_index_null.groovy
b/regression-test/suites/inverted_index_p0/test_inverted_index_null.groovy
index 6dac5d3e447..b9c8ed6119a 100644
--- a/regression-test/suites/inverted_index_p0/test_inverted_index_null.groovy
+++ b/regression-test/suites/inverted_index_p0/test_inverted_index_null.groovy
@@ -30,7 +30,7 @@ suite("test_inverted_index_null") {
`compy` varchar(20) NULL COMMENT "",
`n` int NULL COMMENT "",
INDEX idx_city(city) USING INVERTED,
- INDEX idx_addr(addr) USING INVERTED PROPERTIES("parser"="english"),
+ INDEX idx_addr(addr) using inverted properties("support_phrase" =
"true", "parser" = "english", "lower_case" = "true"),
INDEX idx_n(n) USING INVERTED
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/test_inverted_index_null_ram_dir.groovy
b/regression-test/suites/inverted_index_p0/test_inverted_index_null_ram_dir.groovy
index 784c2316416..425cea7b4cf 100644
---
a/regression-test/suites/inverted_index_p0/test_inverted_index_null_ram_dir.groovy
+++
b/regression-test/suites/inverted_index_p0/test_inverted_index_null_ram_dir.groovy
@@ -82,7 +82,7 @@ suite("test_inverted_index_null_ram_dir") {
`compy` varchar(20) NULL COMMENT "",
`n` int NULL COMMENT "",
INDEX idx_city(city) USING INVERTED,
- INDEX idx_addr(addr) USING INVERTED PROPERTIES("parser"="english"),
+ INDEX idx_addr(addr) using inverted properties("support_phrase" =
"true", "parser" = "english", "lower_case" = "true"),
INDEX idx_n(n) USING INVERTED
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git
a/regression-test/suites/inverted_index_p0/test_inverted_index_v2_file_size.groovy
b/regression-test/suites/inverted_index_p0/test_inverted_index_v2_file_size.groovy
index 76017c8bb30..c0eae0ccd4a 100644
---
a/regression-test/suites/inverted_index_p0/test_inverted_index_v2_file_size.groovy
+++
b/regression-test/suites/inverted_index_p0/test_inverted_index_v2_file_size.groovy
@@ -72,7 +72,7 @@ suite("test_index_index_V2_file_size", "nonConcurrent") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git a/regression-test/suites/inverted_index_p0/test_lowercase.groovy
b/regression-test/suites/inverted_index_p0/test_lowercase.groovy
index 3dacec72f4c..3de3b3da732 100644
--- a/regression-test/suites/inverted_index_p0/test_lowercase.groovy
+++ b/regression-test/suites/inverted_index_p0/test_lowercase.groovy
@@ -25,7 +25,7 @@ suite("test_lowercase"){
CREATE TABLE IF NOT EXISTS ${indexTblName}(
`id`int(11)NULL,
`c` text NULL,
- INDEX c_idx(`c`) USING INVERTED PROPERTIES("parser"="english")
COMMENT ''
+ INDEX c_idx(`c`) using inverted properties("support_phrase" =
"true", "parser" = "english", "lower_case" = "true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/inverted_index_p0/test_pk_no_need_read_data.groovy
b/regression-test/suites/inverted_index_p0/test_pk_no_need_read_data.groovy
index b8cf3f4c0b5..1641d0e3e16 100644
--- a/regression-test/suites/inverted_index_p0/test_pk_no_need_read_data.groovy
+++ b/regression-test/suites/inverted_index_p0/test_pk_no_need_read_data.groovy
@@ -28,7 +28,7 @@ suite("test_pk_no_need_read_data", "p0"){
`compy` varchar(20) NULL COMMENT "",
`n` int NULL COMMENT "",
INDEX idx_city(city) USING INVERTED,
- INDEX idx_addr(addr) USING INVERTED PROPERTIES("parser"="english"),
+ INDEX idx_addr(addr) using inverted properties("support_phrase" =
"true", "parser" = "english", "lower_case" = "true"),
INDEX idx_n(n) USING INVERTED
) ENGINE=OLAP
DUPLICATE KEY(`date`)
diff --git
a/regression-test/suites/inverted_index_p0/unique_with_mow/test_mow_with_null_sequence.groovy
b/regression-test/suites/inverted_index_p0/unique_with_mow/test_mow_with_null_sequence.groovy
index 2da3509f1d5..ef266e23432 100644
---
a/regression-test/suites/inverted_index_p0/unique_with_mow/test_mow_with_null_sequence.groovy
+++
b/regression-test/suites/inverted_index_p0/unique_with_mow/test_mow_with_null_sequence.groovy
@@ -25,7 +25,7 @@ suite("test_mow_with_null_sequence", "inverted_index") {
`c_address` varchar(20) NOT NULL COMMENT "",
`c_date` date NULL COMMENT "",
INDEX c_custkey_idx(c_custkey) USING INVERTED COMMENT
'c_custkey index',
- INDEX c_name_idx(c_name) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'c_name index',
+ INDEX c_name_idx(c_name) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'c_name index',
INDEX c_address_idx(c_address) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'c_address index',
INDEX c_date_index(c_date) USING INVERTED COMMENT
'c_date_index index'
)
@@ -87,7 +87,7 @@ suite("test_mow_with_null_sequence", "inverted_index") {
`c_address` varchar(20) NOT NULL COMMENT "",
`c_int` int NULL COMMENT "",
INDEX c_custkey_idx(c_custkey) USING INVERTED COMMENT
'c_custkey index',
- INDEX c_name_idx(c_name) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'c_name index',
+ INDEX c_name_idx(c_name) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'c_name index',
INDEX c_address_idx(c_address) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'c_address index',
INDEX c_int_index(c_int) USING INVERTED COMMENT
'c_int_index index'
)
diff --git a/regression-test/suites/inverted_index_p2/test_show_data.groovy
b/regression-test/suites/inverted_index_p2/test_show_data.groovy
index 91939d5507d..93c87027cca 100644
--- a/regression-test/suites/inverted_index_p2/test_show_data.groovy
+++ b/regression-test/suites/inverted_index_p2/test_show_data.groovy
@@ -52,7 +52,7 @@ suite("test_show_data", "p2") {
`request` text NULL,
`status` int(11) NULL,
`size` int(11) NULL,
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
DISTRIBUTED BY HASH(`@timestamp`) BUCKETS 1
@@ -659,7 +659,7 @@ suite("test_show_data_with_compaction", "p2") {
`request` text NULL,
`status` int(11) NULL,
`size` int(11) NULL,
- INDEX request_idx (`request`) USING INVERTED
PROPERTIES("parser"="english") COMMENT ''
+ INDEX request_idx (`request`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`@timestamp`)
DISTRIBUTED BY HASH(`@timestamp`) BUCKETS 1
@@ -751,7 +751,7 @@ suite("test_show_data_with_compaction", "p2") {
`hobbies` text NULL,
`score` int(11) NULL,
index index_name (name) using inverted,
- index index_hobbies (hobbies) using inverted
properties("parser"="english"),
+ index index_hobbies (hobbies) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true"),
index index_score (score) using inverted
) ENGINE=OLAP
DUPLICATE KEY(`id`)
diff --git a/regression-test/suites/nereids_syntax_p0/match.groovy
b/regression-test/suites/nereids_syntax_p0/match.groovy
index 4505460ac27..fdc238ad176 100644
--- a/regression-test/suites/nereids_syntax_p0/match.groovy
+++ b/regression-test/suites/nereids_syntax_p0/match.groovy
@@ -37,11 +37,11 @@ suite("match") {
`fatherName` varchar(50),
`matherName` varchar(50),
`selfComment` text,
- INDEX name_idx(name) USING INVERTED PROPERTIES("parser"="english")
COMMENT 'name index',
+ INDEX name_idx(name) using inverted properties("support_phrase" =
"true", "parser" = "english", "lower_case" = "true") COMMENT 'name index',
INDEX age_idx(age) USING INVERTED COMMENT 'age index',
INDEX grade_idx(grade) USING INVERTED PROPERTIES("parser"="none")
COMMENT 'grade index',
- INDEX fatherName_idx(fatherName) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'fatherName index',
- INDEX matherName_idx(matherName) USING INVERTED
PROPERTIES("parser"="english") COMMENT 'matherName index',
+ INDEX fatherName_idx(fatherName) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'fatherName index',
+ INDEX matherName_idx(matherName) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT 'matherName index',
INDEX selfComment_idx(selfComment) USING INVERTED
PROPERTIES("parser"="standard") COMMENT 'selfComment index'
) ENGINE=OLAP
DUPLICATE KEY(`name`)
diff --git
a/regression-test/suites/partition_p0/auto_partition/test_auto_partition_behavior.groovy
b/regression-test/suites/partition_p0/auto_partition/test_auto_partition_behavior.groovy
index 0334bb68474..e57901dc928 100644
---
a/regression-test/suites/partition_p0/auto_partition/test_auto_partition_behavior.groovy
+++
b/regression-test/suites/partition_p0/auto_partition/test_auto_partition_behavior.groovy
@@ -333,7 +333,7 @@ suite("test_auto_partition_behavior") {
INDEX idx_level (`level`) USING INVERTED COMMENT '',
INDEX idx_component (`component`) USING INVERTED COMMENT '',
INDEX idx_clientRequestId (`clientRequestId`) USING INVERTED
COMMENT '',
- INDEX idx_message (`message`) USING INVERTED
PROPERTIES("parser"="english") COMMENT '',
+ INDEX idx_message (`message`) using inverted
properties("support_phrase" = "true", "parser" = "english", "lower_case" =
"true") COMMENT '',
-- INDEX idx_properties (`properties`) USING INVERTED COMMENT '',
) ENGINE=OLAP
DUPLICATE KEY(`timestamp`)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
