Details
- 
    New Feature 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    6.4.2, 6.4.6, 23.02
- 
    None
- 
        2024-1
Description
Using regexp_substr on table with engine=columnstore results in error:
ERROR 1178 (42000): The storage engine for the table doesn't support MCS-1001: Function 'regexp_substr' isn't supported.
To reproduce:
create table t3(a int not null, b varchar(100)) engine=columnstore;
insert into t3 values(1, 'My mouse'),(2,'Breakfast Food');
select a, regexp_substr(b, 'a|e|i|o|u') AS "vowel" from t3;
works with engine=innodb.