bk commit into 5.1 tree (aelkin:1.2472) BUG#27044

[Andrei Elkin]

Below is the list of changes that have just been committed into a local
5.1 repository of elkin. When elkin does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-05-02 12:44:26+03:00, aelkin@stripped
+3 -0
  Bug#27044 replicated with unique field ndb table allows duplkey inserts
  The bug in that slave version of a table with unique field still was
  able to execute INSERT query as replace whereas it's impossible on master.
  
  The reason of this artifact is wrong usage of ndb->extra:s.
  
  Fixed with resetting flags at do_after.
  There is open issue with symmetrical resetting
     table->file->extra(HA_EXTRA_NO_IGNORE_NO_KEY)
  which i had to hand to bug#27077.

  mysql-test/r/rpl_ndb_do_table.result@stripped, 2007-05-02 12:44:19+03:00,
aelkin@stripped +4 -0
    results changed

  mysql-test/t/rpl_ndb_do_table.test@stripped, 2007-05-02 12:44:19+03:00,
aelkin@stripped +12 -0
    regression test for the bug. Since it appeared to be not possible
    to summon the bug with other engines, the test is here.

  sql/log_event.cc@stripped, 2007-05-02 12:44:19+03:00,
aelkin@stripped +21 -4
    fixing do_after_row_operation to reset the effect of the extra engine's 
    flags set at do_before;
    comments on meaning of extra flags added;

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	aelkin
# Host:	dsl-hkibras1-ff18c300-219.dhcp.inet.fi
# Root:	/home/elkin/MySQL/TEAM/FIXES/5.1/bug27044_slave_dup2unique

--- 1.273/sql/log_event.cc	2007-03-01 16:16:13 +02:00
+++ 1.274/sql/log_event.cc	2007-05-02 12:44:19 +03:00
@@ -6601,10 +6601,17 @@ int Write_rows_log_event::do_before_row_
     lex->duplicates flag.
   */
   thd->lex->sql_command= SQLCOM_REPLACE;
-
-  table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);  // Needed for ndbcluster
-  table->file->extra(HA_EXTRA_WRITE_CAN_REPLACE);  // Needed for ndbcluster
-  table->file->extra(HA_EXTRA_IGNORE_NO_KEY);   // Needed for ndbcluster
+  /* Do not raise the error flag in case of hitting to an unique attribute */
+  table->file->extra(HA_EXTRA_IGNORE_DUP_KEY);
+  /* NDB specific: update from ndb master wrapped as Write_rows */
+  /* so that the event should be applied to replace slave's row */
+  table->file->extra(HA_EXTRA_WRITE_CAN_REPLACE);
+  /* 
+     NDB specific: if update from ndb master wrapped as Write_rows
+     does not find the row it's assumed idempotent binlog applying
+     is taking place; don't raise the error.
+  */
+  table->file->extra(HA_EXTRA_IGNORE_NO_KEY);
   /*
     TODO: the cluster team (Tomas?) says that it's better if the engine knows
     how many rows are going to be inserted, then it can allocate needed memory
@@ -6633,7 +6640,17 @@ int Write_rows_log_event::do_before_row_
 int Write_rows_log_event::do_after_row_operations(TABLE *table, int error)
 {
   if (error == 0)
+  {
+    table->file->extra(HA_EXTRA_NO_IGNORE_DUP_KEY);
+    table->file->extra(HA_EXTRA_WRITE_CANNOT_REPLACE);
+    /*
+      reseting the extra with 
+      table->file->extra(HA_EXTRA_NO_IGNORE_NO_KEY); 
+      fires bug#27077
+      todo: explain or fix
+    */
     error= table->file->ha_end_bulk_insert();
+  }
   return error;
 }
 

--- 1.2/mysql-test/r/rpl_ndb_do_table.result	2007-01-04 05:08:31 +02:00
+++ 1.3/mysql-test/r/rpl_ndb_do_table.result	2007-05-02 12:44:19 +03:00
@@ -19,4 +19,8 @@ t1
 SELECT COUNT(*) FROM t1;
 COUNT(*)
 3
+INSERT INTO t1 VALUES (3, repeat('bad',1));
+ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
+INSERT INTO t1 VALUES (3, repeat('bad too',1));
+ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
 DROP TABLE IF EXISTS t1, t2;

--- 1.2/mysql-test/t/rpl_ndb_do_table.test	2007-01-04 05:08:22 +02:00
+++ 1.3/mysql-test/t/rpl_ndb_do_table.test	2007-05-02 12:44:19 +03:00
@@ -27,6 +27,18 @@ INSERT INTO t2 VALUES(3, repeat('ghi',30
 SHOW TABLES;
 SELECT COUNT(*) FROM t1;
 
+#
+# Bug #27044 replicated with unique field ndb table allows dup key inserts
+#
+connection master;
+
+--error ER_DUP_ENTRY_WITH_KEY_NAME
+INSERT INTO t1 VALUES (3, repeat('bad',1));
+
+connection slave;
+--error ER_DUP_ENTRY_WITH_KEY_NAME
+INSERT INTO t1 VALUES (3, repeat('bad too',1));
+
 connection master;
 DROP TABLE IF EXISTS t1, t2;
 --sync_slave_with_master