Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5328

Using regexp_substr on table with engine=columnstore results in error:"Function 'regexp_substr' isn't supported."

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            mpflaum Maria M Pflaum
            Votes:
            1 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.