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

Unique blobs allow duplicate values upon UPDATE

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (f TEXT UNIQUE);
      		 
      INSERT INTO t1 VALUES (NULL),(NULL);
      		 
      UPDATE t1 SET f = '';
      		 
      SELECT * FROM t1;
      		 
      DROP TABLE t1;

      10.4 de20872331

      		 
      MariaDB [test]> UPDATE t1 SET f = '';
      		 
      Query OK, 2 rows affected (0.116 sec)
      		 
      Rows matched: 2  Changed: 2  Warnings: 0
      		 
       
      		 
      MariaDB [test]> SELECT * FROM t1;
      		 
      +------+
      		 
      | f    |
      		 
      +------+
      		 
      |      |
      		 
      |      |
      		 
      +------+
      		 
      2 rows in set (0.000 sec)

      Reproducible on 10.4, 10.5.

      INSERT of empty values returns ER_DUP_ENTRY as expected.
      UPDATE from non-NULL values and UPDATE to non-empty values also returns ER_DUP_ENTRY.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-371 Unique indexes for blobs

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23265 Assertion `!expl_lock || expl_lock->trx == arg->impl_trx' failed in lock_rec_other_trx_holds_expl_callback upon concurrent UPDATE with unique blobs

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29199 Unique hash key is ignored upon INSERT ... SELECT into non-empty MyISAM table

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29949 Unique blobs allow duplicate values upon concurrent INSERT

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

          Activity

            People

              sanja Oleksandr Byelkin
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.