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

MySQL BUG#11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0.9
    • Fix Version/s: 10.0
    • Component/s: None
    • Labels:
      None

      Description

      Test case for MySQL "BUG#11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED" fails in 10.0:

      --echo #
      --echo # BUG #11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED
      --echo #
       
      --disable_warnings
      DROP TABLE IF EXISTS t1, t2;
      --enable_warnings
       
      CREATE TABLE t1 (id INT PRIMARY KEY);
      INSERT INTO t1 VALUES (1), (2);
       
      --enable_info
      UPDATE IGNORE t1, (SELECT 1 AS duplicate_id) AS t2 SET t1.id=t2.duplicate_id;
      --disable_info
       
      --echo # Check that no rows changed.
      SELECT * FROM t1;
      DROP TABLE t1;

      Relevant revision:

      revno: 3402.1.251
      committer: Raghav Kapoor <raghav.kapoor@oracle.com>
      branch nick: mysql-trunk-bug-11766576
      timestamp: Tue 2011-12-13 19:40:33 +0530
      message:
        BUG#11766576 - 59715: UPDATE IGNORE, 1 ROW AFFECTED
       
        BACKGROUND:
        UPDATE IGNORE returns the wrong number of rows updated when there
        are duplicate key conflicts in the multi table update.
       
        FIX:
        This bug has been fixed by putting a check on updated variable
        in mysql_multi_update::do_update function so that count is not
        updated when duplicate key conflicts occur (and the corresponding
        rows are not updated).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              psergey Sergei Petrunia
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: