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

long unique does not work like unique key when using replace

Details

    Description

      REPLACE is supposed to remove all conflicting rows.
      For UNIQUE HASH, REPLACE only removes the first conflicting row, not all conflicting rows, and generates an error:

      Test case:

      create or replace table t1 (a int primary key, b int, c int, unique key `test` (b,c) using hash) engine=myisam;
      		 
      insert into t1 values (1,1,1),(2,2,2);
      		 
      replace into t1 values (3,1,1);
      		 
      select * from t1;
      		 
      --error 1062
      		 
      replace into t1 values (3,2,2);
      		 
      select * from t1;


      +---+------+------+
      		 
      | a | b    | c    |
      		 
      +---+------+------+
      		 
      | 3 |    1 |    1 |
      		 
      | 2 |    2 |    2 |
      		 
      +---+------+------+

      Test without USING HASH

      create or replace table t1 (a int primary key, b int, c int, unique key `test` (b,c)) engine=myisam;
      		 
      insert into t1 values (1,1,1),(2,2,2);
      		 
      replace into t1 values (3,1,1);
      		 
      select * from t1;
      		 
      replace into t1 values (3,2,2);
      		 
      select * from t1;


      +---+------+------+
      		 
      | a | b    | c    |
      		 
      +---+------+------+
      		 
      | 3 |    2 |    2 |
      		 
      +---+------+------+

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32839 LONG UNIQUE gives error when used with REPLACE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov added a comment -

            Hello serg,

            Please review a patch:

            https://github.com/MariaDB/server/commit/424ee6eac783dd91d08305a9efff9347da6a6b4a

            bar Alexander Barkov added a comment - Hello serg , Please review a patch: https://github.com/MariaDB/server/commit/424ee6eac783dd91d08305a9efff9347da6a6b4a
            bar Alexander Barkov added a comment -

            Hello serg,

            Please review a new patch version:

            https://github.com/MariaDB/server/commit/af51be1106b6738f64ebe5ee7a18573a94fdf934

            bar Alexander Barkov added a comment - Hello serg , Please review a new patch version: https://github.com/MariaDB/server/commit/af51be1106b6738f64ebe5ee7a18573a94fdf934

            People

              bar Alexander Barkov
              monty Michael Widenius
              Votes:
              1 Vote for this issue
              Watchers:
              10 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.