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

Regular expression queries containing 4-byte multicharacters result in an error.

    XMLWordPrintable

Details

    Description

      ■query statement

      SELECT * FROM `test` WHERE `word` REGEXP '^𨋢$';

      ■error message
      error 'nothing to repeat at offset 1' from regexp.

      ■about the table used
      tablename : test

      +-------------------+------+
      		 
      | type              | word |
      		 
      +-------------------+------+
      		 
      | 4-byte characters | 𨋢   |
      		 
      | 4-byte characters | 㖭   |
      		 
      | 2-byte characters | 手   |
      		 
      | 2-byte characters | 高   |
      		 
      | 4-byte characters | 𠺫   |
      		 
      +-------------------+------+

      ■Other information
      Occurs only with 4-byte charactor; 2-byte charactor is not a problem.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11777 REGEXP_REPLACE converts utf8mb4 supplementary characters to '?'

          • Major - Major loss of function.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              shacho3501 numa shacho
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.