Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.02, 6.4.2, 6.4.6
-
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.