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

Unique blobs allow duplicate values upon UPDATE

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

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            sachin.setiya.007 Sachin Setiya (Inactive) made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ] Sergei Golubchik [ serg ]
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Sachin Setiya [ sachin.setiya.007 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Elkin Andrei Elkin made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ] Oleksandr Byelkin [ sanja ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 111599 ] MariaDB v4 [ 143657 ]
            marko Marko Mäkelä made changes -
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Affects Version/s 10.8 [ 26121 ]
            Affects Version/s 10.9 [ 26905 ]
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            sanja Oleksandr Byelkin made changes -
            Affects Version/s 10.3 [ 22126 ]
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.3 [ 22126 ]
            sanja Oleksandr Byelkin made changes -
            Affects Version/s 10.3 [ 22126 ]
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.3 [ 22126 ]
            elenst Elena Stepanova made changes -
            dmonteverde Daniel Monteverde made changes -
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.4.28 [ 28509 ]
            Fix Version/s 10.5.19 [ 28511 ]
            Fix Version/s 10.6.12 [ 28513 ]
            Fix Version/s 10.7.8 [ 28515 ]
            Fix Version/s 10.8.7 [ 28517 ]
            Fix Version/s 10.9.5 [ 28519 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            sanja Oleksandr Byelkin made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -

            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.