starrocks
starrocks copied to clipboard
[inverted index]In English and Chinese, xx match '' returns different results.
Steps to reproduce the behavior (Required)
- CREATE TABLE '...'
- INSERT INTO '....'
- SELECT '....'4. 4.
CREATE TABLE `duplicate_table_demo_datatype_not_replicated_all_varchar` (
`AAA` datetime NOT NULL COMMENT "",
`BBB` varchar(200) NOT NULL COMMENT "",
`CCC` varchar(200) NOT NULL COMMENT "",
`DDD` varchar(2000) NULL COMMENT "",
`EEE` largeint(40) NULL COMMENT "",
`FFF` decimal(20, 10) NULL COMMENT "",
`GGG` varchar(200) NULL COMMENT "",
`HHH` float NULL COMMENT "",
`III` boolean NULL COMMENT "",
`KKK` char(20) NULL COMMENT "",
`LLL` varchar(65533) NULL COMMENT "",
`MMM` varchar(20) NULL COMMENT "",
`NNN` varbinary NULL COMMENT "",
`OOO` tinyint(4) NULL COMMENT "",
`PPP` datetime NULL COMMENT "",
`QQQ` array<int(11)> NULL COMMENT "",
`RRR` json NULL COMMENT "",
`SSS` map<int(11),int(11)> NULL COMMENT "",
`TTT` struct<a int(11), b int(11)> NULL COMMENT "",
INDEX init_bitmap_index (`KKK`) USING BITMAP COMMENT '',
INDEX idx (`DDD`) USING GIN("parser" = "chinese") COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`AAA`, `BBB`, `CCC`)
PARTITION BY RANGE(`AAA`)
(PARTITION p1970 VALUES [("1970-01-01 00:00:00"), ("2000-01-01 00:00:00")),
PARTITION p2000 VALUES [("2000-01-01 00:00:00"), ("2030-01-01 00:00:00")))
DISTRIBUTED BY HASH(`AAA`, `BBB`) BUCKETS 3
ORDER BY(`AAA`, `BBB`, `CCC`, `DDD`)
PROPERTIES (
"bloom_filter_columns" = "MMM",
"compression" = "LZ4",
"fast_schema_evolution" = "true",
"replicated_storage" = "false",
"replication_num" = "3",
"unique_constraints" = "default_catalog.test_inverted_indexa4a35500_0e77_11ef_b07c_00163e21975a.duplicate_table_demo_datatype_not_replicated_all_varchar.GGG"
);
insert five data,
select * from duplicate_table_demo_datatype_not_replicated_all_varchar where DDD match '';
Expected behavior (Required)
Real behavior (Required)
return 1 row but if parser is English, return 0 row
StarRocks version (Required)
- You can get the StarRocks version by executing SQL
select current_version()