[inverted index]if sync mv includes 'gin index match xx', create sync mv failed

[chengqianli-git]

Steps to reproduce the behavior (Required)

1. CREATE TABLE '...'
2. INSERT INTO '....'
3. SELECT '....'

use test_inverted_index8c9e82f8_054f_11ef_a47d_00163e21975a
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(20000) COMMENT "", EEE LARGEINT  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 STRING   NULL COMMENT "", MMM VARCHAR(20)   NULL COMMENT "", NNN BINARY  NULL COMMENT "", OOO TINYINT NULL COMMENT "", PPP DATETIME NULL COMMENT "", QQQ ARRAY<INT> NULL COMMENT "", RRR JSON NULL COMMENT "", SSS MAP<INT,INT> NULL COMMENT "", TTT STRUCT<a INT, b INT> NULL COMMENT "", INDEX init_bitmap_index (KKK) USING BITMAP ) duplicate KEY(AAA, BBB, CCC) PARTITION BY RANGE (`AAA`) ( START ("1970-01-01") END ("2030-01-01") EVERY (INTERVAL 30 YEAR) ) DISTRIBUTED BY HASH(`AAA`, `BBB`) BUCKETS 3 ORDER BY(`AAA`,`BBB`,`CCC`,`DDD`) PROPERTIES ( "replicated_storage"="false", "replication_num" = "3", "storage_format" = "v2", "enable_persistent_index" = "true", "bloom_filter_columns" = "MMM", "unique_constraints" = "GGG" );

CREATE INDEX idx ON duplicate_table_demo_datatype_not_replicated_all_varchar(DDD) USING GIN('parser' = 'english');
SHOW ALTER TABLE COLUMN where tablename='duplicate_table_demo_datatype_not_replicated_all_varchar' ORDER BY JobId DESC LIMIT 1;

insert into test_inverted_index8c9e82f8_054f_11ef_a47d_00163e21975a.duplicate_table_demo_datatype_not_replicated_all_varchar values ('1985-01-09 03:41:31', 'emGvMhuKVcVIpMtQBXTL', 'jRWtMMGiNoZDoCowVtWV', 'BlYDYsljVFfFUJthwMWv', 2758, 27180.99482, 'wlzacMVrREsDUJKLtJZC', 72.6533140139143, False, 'sxURyKReLjPzSGKNLODj', 'DrGrbTuLmLxbKZxdnEWS', 'BppFqGETDjgTKMpPOSTJ', '', 2, '2023-10-14 22:25:20', [4139, 8383, 12077], '{"job": "Economist", "company": "Mueller-Webb", "ssn": "065-44-1237", "residence": "382 Mark Ridge\nNorth Lisa, NE 84640", "current_location": ["-33.4545555", "101.336262"], "blood_group": "O+", "website": ["https://www.allen-medina.com/", "https://www.wells.net/"], "username": "barry67", "name": "Brenda Jones", "sex": "F", "address": "09383 Miller Hollow Apt. 217\nNew Robert, CO 22604", "mail": "[email protected]", "birthdate": "1950-03-08"}', null, null);

CREATE MATERIALIZED VIEW mv1 AS SELECT AAA, CCC, DDD FROM duplicate_table_demo_datatype_not_replicated_all_varchar;
success

CREATE MATERIALIZED VIEW mv2 AS SELECT AAA, CCC, DDD, KKK FROM duplicate_table_demo_datatype_not_replicated_all_varchar where DDD match '%a%'
fail

Expected behavior (Required)

success

Real behavior (Required)

mv task status:{'status': True, 'result': (('21135', 'duplicate_table_demo_datatype_not_replicated_all_varchar', '2024-04-28 19:08:08', '2024-04-28 19:08:20', 'duplicate_table_demo_datatype_not_replicated_all_varchar', 'mv1', '21136', '871', 'FINISHED', '', None, '86400'), ('21161', 'duplicate_table_demo_datatype_not_replicated_all_varchar', '2024-04-28 19:08:22', '2024-04-28 19:08:50', 'duplicate_table_demo_datatype_not_replicated_all_varchar', 'mv2', '21162', '872', 'CANCELLED', 'rollup task failed after try three times: task type: ALTER, status_code: RUNTIME_ERROR, alter failed,status: STARROCKS_ERROR,[Alter Job:21161, tablet:20922]: failed to convert chunk data. base tablet:20922, new tablet:21163, backendId: 10002, signature: 21163', None, '86400')), 'msg': None}

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version() branch-3.3-355456a