Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39896

MariaDB crash triggered by recursive CTE with REGEXP_REPLACE and ROW_NUMBER

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.3.2
    • None
    • Server
    • None
    • Linux x86_64, Docker container

    Description

      ~~~sql
      SELECT DISTINCT REGEXP_REPLACE ( 'base:7 hidden:6 rebel:1 spaceship:2,33A,34B,35C,36D strike:3' , ROW_NUMBER ( ) OVER ( ) >= 4 , ' ' ) AS x FROM ( SELECT x FROM ( WITH RECURSIVE x ( x ) AS ( SELECT 1 UNION SELECT x + 1 FROM x ) SELECT * FROM x WHERE CHAR_LENGTH ( '����������' ) ) AS x ) AS x GROUP BY x ;
      ~~~

        1. Expected result
          The server should either execute the query or return a normal SQL error without crashing.
        1. Actual result
          The fuzzing run observed a server crash. The deduplicated stack signature is:
          ~~~
          stack:ZN16Item_func_buffer11Transporter15add_edge_bufferEddbb|_ZN16Item_func_buffer11Transporter8completeEv|_ZN16Item_func_buffer11Transporter13complete_lineEv|_ZN16Item_func_buffer7val_strEP6String|_ZN16Item_func_as_wkt13val_str_asciiEP6String|_ZN9Item_func26val_str_from_val_str_asciiEP6StringS1|_ZN24Item_func_regexp_replace16val_str_internalEP6Stringb|_ZNK12Type_handler13Item_send_strEP4ItemP8ProtocolP8st_value
          ~~~

      Top frames:
      ~~~
      _ZN16Item_func_buffer11Transporter15add_edge_bufferEddbb
      _ZN16Item_func_buffer11Transporter8completeEv
      _ZN16Item_func_buffer11Transporter13complete_lineEv
      _ZN16Item_func_buffer7val_strEP6String
      _ZN16Item_func_as_wkt13val_str_asciiEP6String
      ZN9Item_func26val_str_from_val_str_asciiEP6StringS1
      _ZN24Item_func_regexp_replace16val_str_internalEP6Stringb
      _ZNK12Type_handler13Item_send_strEP4ItemP8ProtocolP8st_value
      ~~~

      Attachments

        Activity

          People

            shipjain Shipra Jain
            maohaogang maohaogang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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