eskriett opened a new issue, #31438: URL: https://github.com/apache/doris/issues/31438
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.4 ### What's Wrong? When using inverted indexes with `"support_phrase"="true"`, MATCH_REGEXP will work for the first batch of data inserted, but will then fail once new data is inserted with the error `FunctionMatchRegexp not support execute_match`. ### What You Expected? When new data is inserted, MATCH_REGEXP continues to function. ### How to Reproduce? ```mysql MySQL [test]> CREATE TABLE `test` ( `foo` varchar(500) NULL, INDEX idx_foo(foo) USING INVERTED PROPERTIES("parser" = "unicode", "support_phrase" = "true") ) ENGINE=OLAP AGGREGATE KEY(`foo`) DISTRIBUTED BY HASH(`foo`) BUCKETS 16 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "compression" = "ZSTD"); Query OK, 0 rows affected (0.015 sec) MySQL [test]> INSERT INTO test (foo) values ('bar'); Query OK, 1 row affected (0.041 sec) {'label':'insert_f477b962bed64ede_85236ac1571160b4', 'status':'VISIBLE', 'txnId':'29'} MySQL [test]> select * from test where foo MATCH_REGEXP 'b*'; +------+ | foo | +------+ | bar | +------+ 1 row in set (0.036 sec) MySQL [test]> INSERT INTO test (foo) values ('baz'); Query OK, 1 row affected (0.037 sec) {'label':'insert_6f4a22979eff4680_9d5ffe0f2b0bad0a', 'status':'VISIBLE', 'txnId':'30'} MySQL [test]> select * from test where foo MATCH_REGEXP 'b*'; ERROR 1105 (HY000): errCode = 2, detailMessage = (127.0.0.1)[CANCELLED][E-6001]FunctionMatchRegexp not support execute_match ``` ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
