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

Columnstore Server crashes when REGEX is matched to function return value

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 23.02.2, 23.10.2
    • 23.10.3
    • MDB Plugin
    • None
    • 2024-2

    Description

      Use the attached SQL file to create schema Z206885 and reproduce this scenario:

      -- check the functions, all return valid text for regex matching:
      use Z206885;
      select inno_test_function('Value1', 7);
      select cs_test_function('Value1', 7);
      select static_test_function('Value1', 7);
       
      -- innodb table, function calls innodb table SUCCEEDS
      SELECT location_id    
      FROM  inno_test_lhh
      where (top_prnt NOT REGEXP inno_test_function('Value1', 7)); 
       
      -- innodb table, function calls static text SUCCEEDS
      SELECT location_id    
      FROM  inno_test_lhh
      where (top_prnt NOT REGEXP static_test_function('Value1', 7)); 
       
      -- columnstore table, function calls static text  SUCCEEDS
      SELECT location_id    
      FROM  cs_test_lhh
      where (top_prnt NOT REGEXP static_test_function('Value1', 7)); 
       
      -- innodb table, function calls columnstore table CRASHES DATABASE SERVER
      SELECT location_id    
      FROM  inno_test_lhh
      where (top_prnt NOT REGEXP cs_test_function('Value1', 7)); 
       
      -- columnstore table, function calls innodb table  CRASHES DATABASE SERVER
      SELECT location_id    
      FROM  cs_test_lhh
      where (top_prnt NOT REGEXP inno_test_function('Value1', 7)); 
       
      -- columnstore table, function calls columnstore table CRASHES DATABASE SERVER
      SELECT location_id    
      FROM  cs_test_lhh
      where (top_prnt NOT REGEXP cs_test_function('Value1', 7)); 
      
      

      This can be reproduced on a single instance.

      Attachments

        Activity

          People

            alexey.antipovsky Alexey Antipovsky
            edward Edward Stoever
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.