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

Inconsistent results of DISTINCT with NOPAD

    XMLWordPrintable

Details

    Description

      CREATE OR REPLACE TABLE t1 (c CHAR(100) COLLATE utf8mb3_unicode_nopad_ci);
      		 
      INSERT INTO t1 VALUES ('ss'),('ß');
      		 
      SET big_tables=0;
      		 
      SELECT DISTINCT c FROM t1;


      +------+
      		 
      | c    |
      		 
      +------+
      		 
      | ss   |
      		 
      | ß    |
      		 
      +------+


      SET big_tables=1;
      		 
      SELECT DISTINCT c FROM t1;


      +------+
      		 
      | c    |
      		 
      +------+
      		 
      | ss   |
      		 
      +------+

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25904 New collation functions to compare InnoDB style trimmed NO PAD strings

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27670 Assertion `(cs->state & 0x20000) == 0' failed in my_strnncollsp_nchars_generic_8bit

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27768 MDEV-25440: Assertion `(cs->state & 0x20000) == 0' failed in my_strnncollsp_nchars_generic_8bit

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30048 Prefix keys for CHAR work differently for MyISAM vs InnoDB

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30072 Wrong ORDER BY for a partitioned prefix key + NOPAD

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30034 UNIQUE USING HASH accepts duplicate entries for tricky collations

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              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.